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
Is db2 a database?
How and when does the db2 enforces the unique key?
What is precompiler in db2?
What does db2 plan contain?
Mention some fields that are a part of sqlca.
What is the use of runstats in db2?
Highlight all the advantages that are attached to a package.
What is the role of union all and union
List down the types of triggers in the db2 database?
How to resolve deadlock issue
What is load replace in db2?
Which component is responsible for db2 startup and shutdown?
What is host variable in db2 cobol?
What is dbrm in db2 database?
Give a brief description of db2 isolation levels?
