Partition 1 is in Copy Pending

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
mkk157
Member
Posts: 37
Joined: Wed Feb 07, 2007 2:00 pm
Location: Hyderabad

Partition 1 is in Copy Pending

Post by mkk157 » Fri Dec 28, 2007 9:45 am

Dear Expert,

I got the following message while loading the data from a file to the first partition of the table. (And here the input file is empty).

I am using IBMLOAD Utility.

-DQB1 DSNUGSRX - TABLESPACE RBZPR1U2.SBZ78MMP PARTITION 1 IS IN COPY PENDING

After all the load statistics the message came at the last. And I got MAXCC = 4.

what does this message signify ?
Kumar
If u can dream it, U can do it.

mkk157
Member
Posts: 37
Joined: Wed Feb 07, 2007 2:00 pm
Location: Hyderabad

Post by mkk157 » Fri Dec 28, 2007 10:36 am

I got the same message for all the partitions.

Is it only because of the Empty input file ??
As I don't have the test data right now and as the length of the file is large I couldn't even manufacture the data to test it with the non-empty file.
Kumar
If u can dream it, U can do it.

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Fri Dec 28, 2007 10:44 am

Data loaded into table without any issues.
But Partition 1 is in COPY PENDING status. You need to run REPAIR utitility to correct this.

mkk157
Member
Posts: 37
Joined: Wed Feb 07, 2007 2:00 pm
Location: Hyderabad

Post by mkk157 » Fri Dec 28, 2007 2:43 pm

I used the following command
REPAIR SET TABLESPACE RBZPR1U2.SBZ78MMP NOCOPYPEND

and it works fine.

Thanks Krishna.
Kumar
If u can dream it, U can do it.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others