READ ERROR TO RANDOMLY ACCESSED RECORD IN VSAM FILE

JAYADEV.G · New User Joined: 13 Apr 2007 Posts: 11 Location: hyderabad

Hi,

I have a problem like during my batch run, one particular job is trying to read file for a particluar record and when that record is not found, job fails with u999 giving STA=23.

After few minutes without any fix when I restart the job, job goes fine.

Can anyone tell me why it has happened.

Thanks/Jai

Robert Sample · Posted: Wed Sep 02, 2009 6:43 pm

Is the file updated online while the batch program is accessing it? If so, the online system might be adding records that are interfering with the batch processing. If not, then your program has some combination of conditions that cause the record key it attempts to read to be invalid (as in, not found in the file). Finding those conditions requires scanning the source code to find out what is causing the issue -- also known as debugging.

The bigger issue in my mind is why does the program abend when it cannot find a record -- shouldn't it just display an error message and continue?

dbzTHEdinosauer · Posted: Wed Sep 02, 2009 6:43 pm

probably has to do with the 7th record in the file.

Terry Heinze · Posted: Wed Sep 02, 2009 7:39 pm

No Dick, since the 7th record is not there, it's the 8th record.

JAYADEV.G · New User Joined: 13 Apr 2007 Posts: 11 Location: hyderabad

common people don't play games. I am having genuine problem please try to help me.

Terry Heinze · Posted: Wed Sep 02, 2009 8:22 pm

I don't want to speak for Dick, but I suspect both he and I are trying to say that you didn't provide enough information in your original post to be of much help. Please follow Robert's debugging suggestion.

dbzTHEdinosauer · Posted: Wed Sep 02, 2009 8:23 pm

Jayadev,

your basic problem is defining the problem.

JAYADEV.G · New User Joined: 13 Apr 2007 Posts: 11 Location: hyderabad

dick,

let me explain u again what my problem is

during my batch processing, one of the batch job is trying to read a record of particular file, it failed because it could not find record.

When i restarted the job , it went fine.This job has only one step.
I have checked whether that particular record is being maintained in online.But it is'n the case.

so what could be the reason that is what for i have posted this query.

I think Dick Brenholtz u understood what my query is.

dbzTHEdinosauer · Posted: Wed Sep 02, 2009 8:41 pm

enrico-sorichetti · Posted: Wed Sep 02, 2009 8:43 pm

investigate the approach suggested by Robert in the first reply,

You are expecting too much, giving too little

JAYADEV.G · New User Joined: 13 Apr 2007 Posts: 11 Location: hyderabad

Hi Dick,

1)File is VSAM file. It was read in Dyn Input mode.
Select clause does not have any info except file name.
FD also does not have file length except that file layout is mentioned.

2)File status is 23. I am using simple 2 char file status.

I did not get this query
"what are the responses you receive in the status fields?"

3)File is not maintained.Record is also not found in the file.
VSAM file SHAREOPTIONS(2,3).

DICK I think I have provided details which u require.I am ready to provide whatever details u want. Thing is that i want to resolve this issue. Guys please help me.

Thanks/Jai

Robert Sample · Posted: Wed Sep 02, 2009 9:49 pm

JAYADEV.G · New User Joined: 13 Apr 2007 Posts: 11 Location: hyderabad

hi TANSTAAFL

so you mean to say that record is definetly maintained.

Can u explain this in a bit detailed manner

Robert Sample · Posted: Wed Sep 02, 2009 11:04 pm

Depending upon the VSAM parameters (record length, CI size, free space), there could be anywhere from 1 to thousands of VSAM records in a single CI. When VSAM is updating a record (online or batch), the entire CI is locked -- not just the one record being changed. And without looking at a lot of hex values, you do not know which records are in which CI unless you've just unloaded and reloaded the VSAM (in which case you could do the calculations to determine which records are in a CI). So your batch job would not be able to get to the record while the online system is updating any record in the CI.

There is a Redbook at the IBM site called VSAM Demystified. It would be worth your while to read this Redbook.