what needs to be done if a table is in copy pending / check
pending status?
Answer Posted / sasi
use repair utility
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCOPYPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NORCVRPEND
REPAIR SET TABLESPACE DATABASE.TABLESPACENAME NOCHECKPEND
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Explain db2.
What is declare cursor?
What is a buffer in memory?
How connect db2 database to datastage?
Explain how can you do the explain of a dynamic sql statement?
How do I add a column to an existing table in 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.
What is the physical storage length of date data type?
What are foreign keys in db2?
How does cobol compile db2 program?
What is data manager?
Why cursor is used in db2?
What is database reorganization?
what is db2 restart?