Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Table space in copy pend status

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Satheeshkumar

New User


Joined: 20 Feb 2009
Posts: 51
Location: Chennai

PostPosted: Sat Nov 07, 2009 1:52 am    Post subject: Table space in copy pend status
Reply with quote

Can any one explain about tablespace in DB2?

what does it mean tablespace has been left in copy pend status?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Nov 07, 2009 2:16 am    Post subject:
Reply with quote

Hello,

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

Look here for info on creating a tablespace:
http://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.
Back to top
View user's profile Send private message
Satheeshkumar

New User


Joined: 20 Feb 2009
Posts: 51
Location: Chennai

PostPosted: Sat Nov 07, 2009 2:49 am    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Nov 07, 2009 2:59 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Ronald Burr

Active User


Joined: 22 Oct 2009
Posts: 293
Location: U.S.A.

PostPosted: Sat Nov 07, 2009 3:00 am    Post subject:
Reply with quote

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. ).
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sun Nov 08, 2009 12:40 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Nidhi_P

New User


Joined: 21 Oct 2009
Posts: 6
Location: Pune, India

PostPosted: Tue Nov 10, 2009 12:41 pm    Post subject: Reply to: Table space in copy pend status
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us