How to check Copy Pending Flag and fix it

2 posts / 0 new
Last post
Anonymous
How to check Copy Pending Flag and fix it

 

 

 

 

How to check if any table is in copy pending state?
 
And also how can we remove it.
 
"; ; ; ;
Anonymous
Normally you can get to know

Normally you can get to know that a table is in Copy pending if your application program returns a -904 at the time of any insert or update.

Or, you can run the following query in the DB2 commands (option 7) of the DB2 Interactive (DB2I) in your installation:

-DISPLAY DATABASE(database-name) LIMIT(*)

This query shall list all the objects in your database and if you notice a CO next to any object, it means that object in your database is in COpy Pending state.

For how to remove copypending... Refer

https://mainframewizard.com/content/difference-between-copy-pending-and-check-pending

Log in or register to post comments
Sponsored Listing