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
How would you find out the total number of rows in a db2 table?
What is dbrm? When it will be created?
What is nvl in db2?
What is the difference between db2 and oracle?
What is the use of db2?
Explain packages.
What are db2 objects?
What action db2 takes when a program aborts in the middle of a transaction?
What is bufferpool in db2?
What type of database is db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
On which levels locks can be applied?
What is database alias db2?
What does db2 plan contain?