Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What is COPY PENDING status in DB2

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sandy_mcs

New User


Joined: 01 Apr 2006
Posts: 17
Location: Pune

PostPosted: Tue Apr 18, 2006 4:22 pm    Post subject: What is COPY PENDING status in DB2
Reply with quote

I m accessing tables & COPY PENDING STATUS is been showed
What is COPY PENDING STATUS???
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Apr 18, 2006 4:49 pm    Post subject:
Reply with quote

Sandy,

i think u put c & gave some cut command on command line & forget to paste that
Back to top
View user's profile Send private message
vidhyanarayanan

New User


Joined: 23 Dec 2005
Posts: 52

PostPosted: Tue Apr 18, 2006 5:02 pm    Post subject:
Reply with quote

Hi,
If u have load or reorg the table space with option LOGNO, then
the table space get in to copy pending status............
Back to top
View user's profile Send private message
twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Wed Apr 19, 2006 2:18 pm    Post subject:
Reply with quote

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

New User


Joined: 24 Jul 2006
Posts: 99
Location: Los Angeles

PostPosted: Fri Apr 13, 2007 9:07 pm    Post subject:
Reply with quote

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

New User


Joined: 13 Mar 2007
Posts: 4
Location: chennai

PostPosted: Mon Apr 16, 2007 6:27 pm    Post subject: Re: What is COPY PENDING status in DB2
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 XMITIP sends it out. Can it copy on l... Rommel Dayon Rustia IBM Tools 0 Tue Sep 05, 2017 10:16 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 7 Thu Apr 27, 2017 1:15 am
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us