| View previous topic :: View next topic |
| Author |
Message |
Jai
Beginner
Joined: 06 Jun 2003
Posts: 57
Topics: 20
|
 Posted: Thu Nov 06, 2003 11:32 am Post subject: Copy Pending JCL |
 |
|
Hi Friends,
I need the Copy Pendng JCL as soon as possible as my Database is in copy pending status.
Please send me the Copy pending jcl.
Thanks in advance
_________________
Have a Great Day.
Thanks & Regards,
Jai |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Nov 06, 2003 12:13 pm Post subject: |
|
|
Jai,
There are many ways of resetting the copy pending status.If you have DB2 V6 or higher, you can have the option to do LOAD REPLACE LOG NO NOCOPYPEND. The below listed are some other techniques.
- LOAD REPLACE LOG YES
- LOAD REPLACE LOG NO with an inline copy
- REORG LOG YES
- REORG LOG NO with an inline copy
- REPAIR SET with NOCOPYPEND
The following Sample JCL with REPAIR utility will remove the copy pending status.
| Code: |
//STEP0100 EXEC PGM=IKJEFT01,REGION=3072K
//*
//SYSUDUMP DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2P)
-REPAIR OBJECT LOG YES SET TABLESPACE ZZZZZ NOCOPYPEND
END
//*
|
Or alternatively If you are sure about that you dont have any foreign key violations on the child tables then you can use the following DSN command to start the databases
| Code: |
//STEP0100 EXEC PGM=IKJEFT01,REGION=3072K
//*
//SYSUDUMP DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2P)
-START DATABASE(DBNAME) SPACENAM(TABLENAME) ACCESS(FORCE)
END
//*
|
check this link for a detailed explanation of REPAIR utility
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH11/2.22?DT=20010719144747
Hope this helps...
cheers
kolusu |
|
| Back to top |
|
|
Jai
Beginner
Joined: 06 Jun 2003
Posts: 57
Topics: 20
|
| Posted: Thu Nov 06, 2003 12:16 pm Post subject: |
|
|
thanks a lot olusu for ur prompt response...
I got the JCL fortunately ..and now check pending is removed..
Thanks again.
_________________
Have a Great Day.
Thanks & Regards,
Jai |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
