Trying to REPRO VSAM DB to flat file.



IBM's hierarchical database management system with a Database Manager (IMS DB) and a Transaction Manager(IMS DC)

Trying to REPRO VSAM DB to flat file.

Postby rev1976 » Wed Apr 30, 2008 12:00 am

Hi everyone,

I'm trying to REPRO a VSAM db to a flat file. But i'm getting the following error message:

REPRO INFILE(REPROIN) OUTFILE(REPROOUT)
IDC3302I ACTION ERROR ON IMSVS.KY.DB
IDC3309I ** RECORD X'2007356F21' NOT WRITTEN. LENGTH INVALID
IDC3302I ACTION ERROR ON IMSVS.KY.DB
IDC3309I ** RECORD X'0000000100' NOT WRITTEN. LENGTH INVALID
IDC3302I ACTION ERROR ON IMSVS.KY.DB
IDC3309I ** RECORD X'0BDA000001' NOT WRITTEN. LENGTH INVALID
IDC3302I ACTION ERROR ON IMSVS.KY.DB
IDC3309I ** RECORD X'0614000002' NOT WRITTEN. LENGTH INVALID
IDC31467I MAXIMUM ERROR LIMIT REACHED.
IDC0005I NUMBER OF RECORDS PROCESSED WAS 0
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12

Here's my JCL:

//STEP20 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD DISP=SHR,DSN=CBA285.VSAM.CNTL(REPRODUP)
//REPROIN DD DISP=SHR,DSN=VSAM.DB,
// AMP=('BUFND=250','BUFNI=250')
//REPROOUT DD DISP=(,CATLG,DELETE),DSN=IMSVS.KY.DB,
// SPACE=(CYL,(3500,550),RLSE),
// VOL=SER=HALDB4,
// DCB=(LRECL=80,RECFM=FB)
//PLIDUMP DD SYSOUT=0
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=0

I tried changing the LRECL with no success. Any help would be greatly appreciated. Thank you.
rev1976
 
Posts: 2
Joined: Tue Apr 29, 2008 11:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Trying to REPRO VSAM DB to flat file.

Postby dick scherrer » Wed Apr 30, 2008 12:02 am

Hello rev1976 and welcome to the forums,

Please post the definition of the vsam dataset you are trying to repro.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Trying to REPRO VSAM DB to flat file.

Postby rev1976 » Wed Apr 30, 2008 12:18 am

I want to convert the contents in my database into a flat file. The database is a vsam database:

General Data Current Allocation
Management class . . : IMSDB Allocated tracks . : 0
Storage class . . . : DSFAST Allocated extents . : 0
Volume serial . . . : IMSM07
Device type . . . . : 3390
Data class . . . . . : IMSMED Current Utilization
Organization . . . : VS Used tracks . . . . : ?
Record format . . . : ? Used extents . . . : ?
Record length . . . : ?
Block size . . . . : ?
1st extent tracks . : 0
Secondary tracks . : 0
Data set name type :
rev1976
 
Posts: 2
Joined: Tue Apr 29, 2008 11:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Trying to REPRO VSAM DB to flat file.

Postby William Thompson » Wed Apr 30, 2008 12:42 am

dick scherrer wrote:Please post the definition of the vsam dataset you are trying to repro.
Or better yet, a listcat o this VSAM (why in the IMS DB/DC Fourum?) dataset......
William Thompson
 
Posts: 81
Joined: Sat Jun 09, 2007 4:24 am
Location: Tucson AZ
Has thanked: 0 time
Been thanked: 1 time

Re: Trying to REPRO VSAM DB to flat file.

Postby dick scherrer » Wed Apr 30, 2008 1:02 am

Hello,

What you posted is the info about the dataset allocation.

We need the definition of the vsam file (either the delete/define or the listcat).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Trying to REPRO VSAM DB to flat file.

Postby MrSpock » Wed Apr 30, 2008 1:58 am

Organization . . . : VS??
User avatar
MrSpock
Global moderator
 
Posts: 807
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 4 times

Re: Trying to REPRO VSAM DB to flat file.

Postby dick scherrer » Wed Apr 30, 2008 2:09 am

Hello,

Organization . . . : VS??
VSAM. This is what i get for the cluster, the index, and the data from an "S" off of 3.4.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to IMS DB/DC

 


  • Related topics
    Replies
    Views
    Last post