Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rshk
After a load is performed on the DB2 table, it will be in
Copy pending status. When the table is in copy pending
status, you cannot access the table. In order to release the
table from copy pending status, we need to force complete it
using the Db2 command:
-START(DBname)TBSPACE(Tablespace)ACCESS(FORCE)
Pls check the syntax of the above command.
| Is This Answer Correct ? | 14 Yes | 8 No |
Post New Answer View All Answers
What is bind and rebind in db2?
What language is db2 written in?
What is clone table?
What is the meaning concurrency in the db2 database?
On which levels locks can be applied?
What are catalog tables in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What does reorg do in db2?
What is the connection string to connect to the DB2 Database ?
Which command is used to remove all rows from a table?
define clustering index.
What is a db2 package?
What is a db2 cursor?
How to retrieve rows from a db2 table in embedded sql?
What is cursor with hold option in db2?
