View previous topic :: View next topic
|
Author |
Message |
srvk_2k2
New User
Joined: 07 May 2008 Posts: 36 Location: Chennai
|
|
|
|
Hi,
Can anyone provide a sample JCL to unload the ADABAS DB
Thanks,
Srvk_2k2 |
|
Back to top |
|
|
srvk_2k2
New User
Joined: 07 May 2008 Posts: 36 Location: Chennai
|
|
|
|
a small correction. The utility name is ADARUN |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You need to talk with your dba and use the jcl that is already in use on your system - customized for your specifics.
The generic jcl is available in the product documentation. |
|
Back to top |
|
|
srvk_2k2
New User
Joined: 07 May 2008 Posts: 36 Location: Chennai
|
|
|
|
Thank you sch. I have used an existing JCL but got the statistics as below-
MY JCL
=====
//ADAULD1 EXEC PGM=ADARUN
//DDASSOR1 DD DSN=DSN.ASSO,DISP=SHR
//DDDATAR1 DD DSN=DSN.DATA,DISP=SHR
//DDWORKR1 DD DSN=DSN.WORK,DISP=SHR
//DDEBAND DD DUMMY
//DDOUT1 DD DSN=<OUTPUT EXTRACT DSN>,
// DISP=(NEW,CATLG,DELETE)
//DDCARD DD *
ADARUN PROGRAM=ADAULD
ADARUN DBID=<DBID>
ADARUN DEVICE=<DEVICE NO>
ADARUN SVC=242
/*
//DDKARTE DD *
ADAULD UNLOAD FILE=<FILE NO>
//DDDRUCK DD SYSOUT=*
//DDPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=D
Statistics
======
A D A U L D Statistics
-----------------------
Number of Output Data Sets = 1
Number of Requested Records = 16777215
STARTISN = 0
Options = DVT
Unload Sequence = PHYS SEQ
Number of Records Read = 0
Number of Records Written = 0
Records Written to DDOUT1 = 0
Records Written to DDOUT2 = 0
Records Rejected by USEREXIT-9 = 0
Number of ISNS Written to DDISN = 0
Also, In the o/p extract I got only one record in un-readable format.
Can you tell me if anything needs to be changed in the above JCL.
Thanks,
Srvk_2k2 |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
To repeat:
Quote: |
You need to talk with your dba |
Quote: |
Also, In the o/p extract I got only one record in un-readable format. |
I suspect this is completely readable - it is just not text. Look at the record in hex.
Your statistics show no records were read/written. Possibly because of syntactically correct jcl and/or control statements that are still not what you want.
You dba can also resolve this. |
|
Back to top |
|
|
|