JCL to extract IMS Segments (all)/ one by one

kris_madras · New User Joined: 04 Jul 2005 Posts: 45

Hi,
Could anybody post JCL (probably File-Aid) generated JCL to extract all segments of IMS database to a PS file(s)?

Our requirement is to extract all IMS Database segments/ Segment wise data to a PS file(s).

Our next step is to Trigger these JCLs using CA7 schedulers...

guptae · Posted: Mon Aug 14, 2006 12:31 pm Post subject:

Hi.

Here is the JCl
//ULP011 EXEC PGM=DFSRRC00,PARM='DLI,XES,PS6P011G'
//STEPLIB DD DSN=IMS6.RESLIB,DISP=SHR
// DD DSN=WORKLIB,DISP=SHR
//IMS DD DSN=IMS6.PSBLIB,DISP=SHR
// DD DSN=IMS6.DBDLIB,DISP=SHR
//DFSRESLB DD DSN=IMS6.RESLIB,DISP=SHR
//DFSVSAMP DD DSN=MSD.CARDLIB(DFSVSM10),DISP=SHR
//SYSOUT DD SYSOUT=*
//REPORT DD SYSOUT=*
//XCEFILE DD DUMMY
//SORTFILE DD DUMMY
//SYSUDUMP DD SYSOUT=*
//PRNTOUT DD SYSOUT=*
//SYSIN DD DSN=RD04.XES.CBLTDLI.DATA,DISP=SHR
//OUTFILE DD DSN=TBH2.XES6P011.DATA,
// DISP=(,CATLG),UNIT=DISK,SPACE=(CYL,(1,3),RLSE),
// DCB=(BLKSIZE=19000,LRECL=4624,RECFM=VB)
//**

RD04.XES.CBLTDLI.DATA its contain
-CBLTDLI

it may be helpful

Cheers
Ekta

kris_madras · New User Joined: 04 Jul 2005 Posts: 45

Thanks for your reply...
I don't know this is a generic tool used across all Mainframe systems
Could you explain all the steps? We can change the JCL accordingly...

Thanks,
Sai Krishna

satishstar · New User Joined: 14 Mar 2005 Posts: 16

DFSRRC00 - Its the IMS utility which executes IMS programs similar to DSNUTLIB in db2.
PARM='DLI,XES,PS6P011G' - In this we pass the type whether its a DLI or BMP where DLI means Data Language 1 and BMP means Batch mode processing.

DLI does only browse.
BMP does edits in IMS database.

//STEPLIB DD DSN=IMS6.RESLIB - contains the utility(DFSRRC00) which executes the IMS programs.

//IMS DD DSN=IMS6.PSBLIB,DISP=SHR - Conatins the PSB libraries i.e.,
program specification libraries.
PSB specifies the type of mode of the program (GOTP - for browse , GOD - delete etc..,) and what all IMS databases are being accessed by the program i.e., PSB maps all the IMS databases which are being accessed by the program and in what mode.

// DD DSN=IMS6.DBDLIB,DISP=SHR - contains the DBD libraries. i.e., data base descriptors. They contain the data of the IMS database. Usually they are being stored in VSAM files.

Shirazpasha · New User Joined: 24 Nov 2006 Posts: 17 Location: India

Hi Guptae,
What will be the content of MSD.CARDLIB(DFSVSM10) and RD04.XES.CBLTDLI.DATA?

Is RD04.XES.CBLTDLI.DATA is the pds which contains the CBLTDLI load??

Shirazpasha · New User Joined: 24 Nov 2006 Posts: 17 Location: India

Also what is XES in

rameshfoa · New User Joined: 05 Apr 2007 Posts: 28 Location: chennai

XES is program name and next PSB name

ahr · New User Joined: 24 Apr 2007 Posts: 15 Location: India

DLI - means pure Batch, the IMS needs the exclusive control over the database, It won't allow sharing of databases with on-lines or with any other Tasks/JOBs.

BMP - Batch message processing, The IMS can share the databases with On-lines and as well as do it's processing.

While unloading data from IMS database to flat files do we need a program name and PSB name ?

rahulkolhe2003 · New User Joined: 06 Mar 2007 Posts: 21 Location: columbus

If XES is program coded in cobol or any other lang then it does not answer the question posted.

Hi guptae, Please throw light on your jcl.

enrico-sorichetti

Hi!

if You have the IMS tools with the HSSR ( high speed sequential retrieval) component,
then You have what You need, the "FABHFSU" utility will unload in different formats at a very high speed, ( very high is an understatement ) the content of any IMS Database

here is the url with the docs
[url]
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.imstools.hpu.doc.ug/hpuhome.htm
[/url]

regards

e.s

Shirazpasha · New User Joined: 24 Nov 2006 Posts: 17 Location: India

Hi,
What will be the content of RD04.XES.CBLTDLI.DATA?

enrico-sorichetti,
Is there a way to findout if the HSSR ( high speed sequential retrieval) component is installed or not in my mainframes?

Thanks,

enrico-sorichetti