View previous topic :: View next topic
|
Author |
Message |
Bala1
New User
Joined: 18 Mar 2010 Posts: 6 Location: london
|
|
|
|
Hi All,
Could any one help in routing the output for a DB2 unload into a flat PS using the utility PTLDRIVM. I beleive the system which i am using, the CA/DB2 tool is not properly installed and as a result of this i am not able to execute the PTLDRIVM in batch mode.
The following JCL is populated but i was not able to fetch the records into a PS file
******************************************************
//STEPLIB DD DISP=SHR,DSN=SYS3.RCUPDATE.LOADLIB
// DD DISP=SHR,DSN=DB2F.DB2.SSPGM
//PTILIB DD DISP=SHR,DSN=SYS3.RCUPDATE.LOADLIB
// DD DISP=SHR,DSN=DB2F.DB2.SSPGM
//PTIPARM DD DISP=SHR,DSN=SYS3.RCUPDATE.PARMLIB
//PTIXMSG DD DISP=SHR,DSN=SYS3.RCUPDATE.XMESSAGE
//SYSOUT DD SYSOUT=*
//PTIIMSG DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//ABNLIGNR DD DUMMY SUPPRESS ABENDAID DUMPS
//SYSUT1 DD UNIT=SYSDA,SPACE=(CYL,(30,30))
//SYSREC DD UNIT=SYSDA,SPACE=(TRK,(1,1))
//BPIIPT DD DISP=SHR,
// DSN=CRD.CRD014.SPUFI.IN(TSET)
//BPIOPT DD *
.CONTROL BPID(CRD.CRD014.SPUFI.IN-TSET) +
LOGID(DB2F) UNIT(SYSDA)
.LIST SYSOUT(A,,CRD014)
.OPTION NOERRORS NOSQLERRORS RETRY(24) NOBINDERRORS
.CONNECT DB2F
*************************************************** |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
What happened when you ran this?
You need to provide the informatonal and/or diagnostic information generated by the run. . . |
|
Back to top |
|
|
Bala1
New User
Joined: 18 Mar 2010 Posts: 6 Location: london
|
|
|
|
the sysout of the program was only providing the status of the execution which was as follows. In the JCL i couldnt provide the name of the output PS.
CONTROL PROCESS CARD:
BATCH PROCESSOR PLAN ===> RBPAR120
BATCH PROCESSOR ID ===> CRD.CRD014.SPUFI.IN-TSET
STRATEGY NAME ===> (NONE)
DEVICE ALLOCATION UNIT => SYSDA
BPA0144I: FINAL LOG RECORD WRITTEN FOR SUBSYSTEM ===> DB2F.
***** BATCH PROCESSOR COMPLETE *****
******************************** BOTTOM OF DATA ************** |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
Your JCL was missing the EXEC statement. That would have been nice to see.
Anyways, try adding this DD for the output file.
If it doesn't work it may be because I hade to guess what program you were running (luckily physic day came twice this week).
//PTISELDD DD DSN=OUTPUT.DATASET,
// UNIT=SYSDA,SPACE=(CYL,(1,1),RLSE),
// DISP=(NEW,CATLG),
// DCB=(BLKSIZE=0,LRECL=XXX,RECFM=FB)
//* |
|
Back to top |
|
|
Bala1
New User
Joined: 18 Mar 2010 Posts: 6 Location: london
|
|
|
|
Hi Dave,
Thanks a lot for your response... It worked. since the tool wasnt installed properly was facing. |
|
Back to top |
|
|
|