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: 668
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 How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm


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