What is COPY PENDING status in DB2

sandy_mcs · New User Joined: 01 Apr 2006 Posts: 17 Location: Pune

I m accessing tables & COPY PENDING STATUS is been showed
What is COPY PENDING STATUS???

guptae · Posted: Tue Apr 18, 2006 4:49 pm

Sandy,

i think u put c & gave some cut command on command line & forget to paste that

vidhyanarayanan · New User Joined: 23 Dec 2005 Posts: 52

Hi,
If u have load or reorg the table space with option LOGNO, then
the table space get in to copy pending status............

twissi · Posted: Wed Apr 19, 2006 2:18 pm

Hi Sandy,

COPY PENDING
A state in which, an Image Copy on a table needs to be taken. In this status, the table is available only for queries, this means that you cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility.

Ekta, please try and uderstand the question before you answer it, Sandy has clearly mentioned that he/she was accessing tables (not flat files) and you've explaned the reason for "MOVE/COPY is pending" seen on flat files.
Please realise that this forum is widely used by budding programmers world wide.

Cheers, Twissi.

neelesht · Posted: Fri Apr 13, 2007 9:07 pm

Hi Twissi/Sandy,

Could you please explain me the procedure to remove table from Copy pending Status.

I know we need to use REPAIR utility however could anyone give me the REPAIR JCL for the same.

Thanks
-Neelesh

srikanth245 · New User Joined: 13 Mar 2007 Posts: 4 Location: chennai

Hi Sandy,
Pls find the JCL for Repair utility.
000001 //REPAIRRP JOB (XXX,XXX,XXXXXX,D2,DT99X),'DB2 RECOVERY',
000002 // MSGLEVEL=(1,1),MSGCLASS=X,NOTIFY=&SYSUID,
000003 // CLASS=O
000004 //**********************************************************************
000005 //* Utility Name : DB2 REPAIR using DSNUTILB
000006 //* Purpose : To Repair data like space map pages & index entries
000008 //* Description : This JCL will replacing invalid data with valid data.
000009 //*
000010 //* SYSIN should be associated with proper syntax
000011 //*
000012 //**********************************************************************
000013 //DSNTIUT EXEC PGM=DSNUTILB,PARM='DBXX,REPAIR1',REGION=0M
000014 //STEPLIB DD DISP=SHR,DSN=DSN710.SDSNLOAD
000015 // DD DISP=SHR,DSN=DSN710.SDSNEXIT
000016 //SYSPRINT DD SYSOUT=*
000017 //SORTWK01 DD DSN=&&TEMP01,DISP=(NEW,DELETE,DELETE),
000018 // SPACE=(16384,(20,20),,,ROUND),UNIT=SYSDA
000019 //SORTWK02 DD DSN=&&TEMP02,DISP=(NEW,DELETE,DELETE),
000020 // SPACE=(16384,(20,20),,,ROUND),UNIT=SYSDA
000021 //SORTWK03 DD DSN=&&TEMP03,DISP=(NEW,DELETE,DELETE),
000022 // SPACE=(16384,(20,20),,,ROUND),UNIT=SYSDA
000023 //SORTWK04 DD DSN=&&TEMP04,DISP=(NEW,DELETE,DELETE),
000024 // SPACE=(16384,(20,20),,,ROUND),UNIT=SYSDA
000025 //SYSREC DD DSN=&&SYSREC,DISP=(NEW,DELETE,DELETE),
000026 // SPACE=(16384,(20,20),,,ROUND),UNIT=SYSDA
000027 //SYSUT1 DD DSN=&&SYSUT1,DISP=(NEW,DELETE,DELETE),
000028 // SPACE=(16384,(20,20),,,ROUND),UNIT=SYSDA
000029 //SORTOUT DD DSN=&&SORTOUT,DISP=(NEW,DELETE,DELETE),
000030 // SPACE=(16384,(20,20),,,ROUND),UNIT=SYSDA
000031 //SYSIN DD *
000032 REPAIR SET TABLESPACE tsname NOCOPYPEND
000033 //* REPAIR LOG YES LEVELID TABLESPACE DBNAME.TSNAME
000034 //* REPAIR REPLACE RESET OFFSET X'00000000'
000035 //*REPAIR SET TABLESPACE DBNAME.TSNAME NOCOPYPEND
000036 //*REPAIR SET INDEX DBNAME.IXNAME NORCVRPEND
000037 //*

Regards,
Srikanth Reddy.B