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 kind of database is db2?
What is difference between isnull and coalesce?
What is the difference between dbm cfg and db cfg file in db2 ?
What are host variables in db2?
What is dclgen (declaration generator)?
What is collection in db2 bind?
Which command is used to remove all rows from a table?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the difference between db2 and oracle?
What is db2 bind?
What is the syntax for FETCH in DB2 ?
What is ibm db2 client?
Is it possible using max on a char column?
What is explain plan in db2?
What is the purpose of rollback and commit?
