Table space in copy pend status

Satheeshkumar · New User Joined: 20 Feb 2009 Posts: 51 Location: Chennai

Can any one explain about tablespace in DB2?

what does it mean tablespace has been left in copy pend status?

dick scherrer · Posted: Sat Nov 07, 2009 2:16 am

Hello,

It is not clear what you are looking for "about tablespace". . .

Look here for info on creating a tablespace:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.39

Copy Pending means something had a problem. What error message or sql-code was shown?

If you haven't done so already, you should ask your dba.

Satheeshkumar · New User Joined: 20 Feb 2009 Posts: 51 Location: Chennai

i am trying to update or insert the records in DB2 table in test with extracted production values using FileAID for DB2.

I am getting a -904, Resource not Available

Full Error Message:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200,
AND RESOURCE NAME E0385IMP.SO1#UNVL
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRINS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -110 13172746 0 13223106 -974970878 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32002' X'00C20042' SQL DIAGNOSTIC INFORMATION

Can anyone tell me how to solve this error?

dbzTHEdinosauer · Posted: Sat Nov 07, 2009 2:59 am

E0385IMP.SO1#UNVL
is the name of the resource.
it is unique to your site/system.
find out what it is and you will be on your way.

Ronald Burr · Posted: Sat Nov 07, 2009 3:00 am

Pass the information (that you posted) on to your DBA and ask him/her to assist. Sometimes there is information in the DB2 Logs indicating an error that occurred in a prior job ( not your own ) that caused the tablespace to be left in copy-pending status. He/she should also be able to restore it to read/write status ( which sometimes requires a tablespace restore operation, sometimes an index rebuild, etc. ).

dejunzhu · Active User Joined: 08 May 2008 Posts: 390 Location: China

copy-pending, means tablespace needed to be copied, for the sake of data backup.

If tablespace is in copy-pending strict status, you can select from the tables in the it, but you can not update data in the table before you take some necessary action to remove the restriction status.

Nidhi_P · Posted: Tue Nov 10, 2009 12:41 pm

Run the command -DISPLAY DATABASE(DB NAME) in DB2 COMMANDS panel. This is for DB2 V8, i don't know whether this works in V9 or not. It will show you a list of TABLESPACES along with their status. You can find out here which TABLESPACE is in Copy/Pend status.

To resolve this, you need to run REPAIR utility. I use the following command and it works fine: REPAIR SET TABLESPACE DBNAME.TABLESPACENAME NOCOPYPEND. You need to ask your DBA for further assistance if you do not have permission to run this.