Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

PTLDRIVM utility for DB2 unload

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Bala1

New User


Joined: 18 Mar 2010
Posts: 6
Location: london

PostPosted: Fri Mar 19, 2010 4:14 pm    Post subject: PTLDRIVM utility for DB2 unload
Reply with quote

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

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Mar 19, 2010 7:44 pm    Post subject:
Reply with quote

Hello,

What happened when you ran this?

You need to provide the informatonal and/or diagnostic information generated by the run. . .
Back to top
View user's profile Send private message
Bala1

New User


Joined: 18 Mar 2010
Posts: 6
Location: london

PostPosted: Fri Mar 19, 2010 7:56 pm    Post subject:
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 660
Location: Pennsylvania

PostPosted: Fri Mar 19, 2010 8:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Bala1

New User


Joined: 18 Mar 2010
Posts: 6
Location: london

PostPosted: Fri Mar 19, 2010 9:19 pm    Post subject:
Reply with quote

Hi Dave,

Thanks a lot for your response... It worked. since the tool wasnt installed properly was facing.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    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 TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Any docs / links for isub- cobol comp... SRICOBSAS COBOL Programming 4 Fri Aug 26, 2016 2:35 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us