VSAM return code 23 - for a Random read

saba2309 · New User Joined: 22 Dec 2022 Posts: 5 Location: Malaysia

Dear All,

We have an IAM dataset(KSDS) which is a master file(Customer info). The same file used for on-line and batch as well. We use to read the record randomly in batch however we do read, read-update and rewrite in online.

In batch program the file defined as below
Org - Indexed
Access Mode - Dynamic

Read using key
READ <<File Name>> KEY IS KEY-XX.

This IAM is very large file contains customer info. Same file accessed in online as well concurrently.

The batch job encounters record not found error - VSAM return code 23. however the record is exist already in the file.

We even printed the key and it is same value as in the file. The same record is also able to read in another day batch. This occurs very few records <=2 for a week.

Could you please assist what should I further verify?

Thank you

Joerg.Findeisen · Posted: Fri Apr 28, 2023 5:22 pm

You should ask the vendor FDR (or it's new owner). In the past they were very helpful assisting to solve any issues.

Rohit Umarjikar · Posted: Tue May 02, 2023 1:48 am

Why don’t you handle 23 and retry 3 times ? Need to know about why was it happening for few records when for all others it works fine , so try to look for online logs if the key is updated , deleted and reinserted or whatever .. find that logic .. I Brielle you are dealing with RLS file , is that right ?

saba2309 · New User Joined: 22 Dec 2022 Posts: 5 Location: Malaysia

Dear All,
Thank you for the feedback.

I will ask our customer about FDR.

It is a Non-RLS file.

Thank you

saba2309 · New User Joined: 22 Dec 2022 Posts: 5 Location: Malaysia

Thank you for the suggestion to attempt three times if happens, I was keen to understand what could happened and why it returns 23.

Thank you