Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us