pmvino
New User
Joined: 22 Aug 2008 Posts: 20 Location: india
|
|
|
|
Hi,
While I am trying to insert the row, I am getting the SQL code - 904. I have run the repair util to make NO-CopyPend status.
Now I am able to insert the records.
Can any one tell me, from which SYSIBM table, i can find the copy pending staus? Because, I am running and finding the tables in the copy pend status... So whether may i find all copy pending tablespace from SYSIBM...? |
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
I don't think it is reflected in the catalog.
you can see them with the DB2 Command (not SQL, not DSN)
-DISPLAY DATABASE(*) SPACENAM(*) RESTRICT
or via result set 2 of the the Supplied Stored Procedure :
CALL "SYSPROC".ADMIN_COMMAND_DB2(
'-DISPLAY DATABASE(*) SPACENAM(*) RESTRICT '
,43,'TS','',0,0,0,0,0,0,0,'') |
|