Issue when copying data from flat file to a VSAM file

jgantena · New User Joined: 13 Aug 2008 Posts: 8 Location: Hyderabad

Hi All,

Can someone help me out in resolving the query.

I m trying to copy data from Flat file of variable length to VSAM file of variable length, i me getting issue like VSAM logical error.

1)Initially i copied data from a VSAM file which is a VB length file(123 bytes) to a flat file of length 145 bytes with recfm VB.
For that i added 4 bytes additional to my actual file length like below

//SORTIN DD DSN=DARN1.VSO.DCR1.AMNK1,DISP=SHR
//SORTOUT DD DSN=DARN1.FFB.DCR1.AMNKA.SORT,
// DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(10,5),RLSE),
// DCB=(RECFM=VB,LRECL=149)

while copying i kept condition like SUM FIELDS=NONE to remove duplicates. Then all the recs were copied.

2)Now when i try to copy data from the above flat file to a new VSAM file which is defined with below parameters
RECORDSIZE ( 105 145 )
KEYS ( 40 0 )

getting a VSAM logical error after some records are copied into VSAM file.

When i manually check the input flat file,there were no duplicates also.

Could some help on this.

regards,
jai

dbzTHEdinosauer · Posted: Fri Apr 08, 2011 12:13 pm

1. i have found that, when using sort, i am better off not specifiying lrecel ,
sort does a much better job of calculating the lrecl than I do.

2. had you done the above, you could have used sort to copy the flat file back.

3. have you insured that the new vsam is defined exactly as the originial. (the define parms should have used model).

Frank Yaeger · Posted: Fri Apr 08, 2011 10:12 pm

Jayadev,

You haven't really given enough information about what you did, and what you're trying to do, for me to help you.

You might be able to help yourself by reading about how DFSORT processes VSAM files at:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA50/1.8.3.4?SHELF=&DT=20100630155256&CASE=

expat · Posted: Sat Apr 09, 2011 12:58 pm

You also need to post all of the error messages AND codes that were issued by the failing job.