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
 

 

Layout of the IMS Unload file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
raveendra_ibm
Currently Banned

New User


Joined: 07 Jan 2006
Posts: 31

PostPosted: Fri Jun 16, 2006 6:19 pm    Post subject: Layout of the IMS Unload file
Reply with quote

Hi,
I have unloaded the IMS database using the utility DFSRRC00.

The output unloaded file contains the one Header Record, Few details records & at end one Trailer Record.

In detail record from position 1-35, it contains the data required for IMS and actual Segment data starts from 36th position onwards.

Can anyone please provide me the actual field layout from position 1-35. By looking at data i can make out Segment name will start at 7th Position. I am not sure about the rest of the bytes in 1-35 position.

Thanks
Back to top
View user's profile Send private message

subramaniabharathi

New User


Joined: 09 Mar 2006
Posts: 9

PostPosted: Sun Jul 16, 2006 2:18 pm    Post subject: Re: Layout of the IMS Unload file
Reply with quote

The o/p file will be prefixed before with 10 bytes which contains segment name rest of the information will be ur segment info as such.
Back to top
View user's profile Send private message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Mon Aug 14, 2006 12:08 pm    Post subject: Re: Layout of the IMS Unload file
Reply with quote

raveendra_ibm wrote:
Hi,
I have unloaded the IMS database using the utility DFSRRC00.

The output unloaded file contains the one Header Record, Few details records & at end one Trailer Record.

In detail record from position 1-35, it contains the data required for IMS and actual Segment data starts from 36th position onwards.

Can anyone please provide me the actual field layout from position 1-35. By looking at data i can make out Segment name will start at 7th Position. I am not sure about the rest of the bytes in 1-35 position.

Thanks



Hi,
can you please post the JCL which uses the tool DFSRRC00?
Is it a generic tool available with IMS DB? or your project specific?
We need to extract IMS DB all segments/one by one to a PS file(s)
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Aug 14, 2006 1:17 pm    Post subject:
Reply with quote

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

New User


Joined: 12 May 2006
Posts: 20

PostPosted: Mon Aug 14, 2006 8:47 pm    Post subject:
Reply with quote

raveendra_ibm,

I've been looking for this layout before and did not have success. I think it is probably not available to the public or customers.

However, if you find a documentation about the record layout, please let me know icon_smile.gif
Back to top
View user's profile Send private message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Tue Aug 15, 2006 2:22 pm    Post subject:
Reply with quote

guptae wrote:
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



Could you explain me the steps in detail>?
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


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