IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Layout of the IMS Unload file


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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
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: 31

PostPosted: Mon Aug 14, 2006 12:08 pm
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: 1208
Location: Bangalore,India

PostPosted: Mon Aug 14, 2006 1:17 pm
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
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: 31

PostPosted: Tue Aug 15, 2006 2:22 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Load new table with Old unload - DB2 DB2 6
Search our Forums:

Back to Top