VSAM with AIX.. Read Failure after writing a record

vcjadhav · New User Joined: 27 May 2008 Posts: 5 Location: Thane

Hi..I m writing a record to a VSAM base cluster which has 2 AIX files associated with it..I tried to write a record into that Cluster and then Read the record below in some other Section. The problem here i faced is when i try to read the record which was written in above section is not been read...I was able to read the same record if and only if i close and open the base and AIX files again...But this is not the solution...i need some other effective way to get it...I have read that this normally occurs due to the data getting written into Buffer Space of Base cluster...so normally when we close-open file the data from buffer gets written into base/aix file..Can any one put there suggestion on any alternate option on it..

yogeshwar_ade · Active User Joined: 31 Aug 2006 Posts: 72 Location: INDIA

vcjadhav · New User Joined: 27 May 2008 Posts: 5 Location: Thane

No i cant do so..bcoz d situation is like this..i have a key...n i need to find if the record already exists in file with that key..if it exists i den add a tie breaker to it..n den again write the record with new key...n hence situation/problem arises if i try to write d same data again.in some other section..its not reading the previously written data..

yogeshwar_ade · Active User Joined: 31 Aug 2006 Posts: 72 Location: INDIA

If possible explain your query with example, that will help all to better understand it.

vcjadhav · New User Joined: 27 May 2008 Posts: 5 Location: Thane

I am having a record in base cluster whose AIX file has some key suppose emp id..n dis emp id is based on his/her first/last name/dob/sex n different combination...now if i try to add a record with same id...it should first search the base cluster for if the record with dis new emp id is present or not...if present den add a tie breaker to d new emp id..hope dis clears..

dick scherrer · Posted: Wed May 28, 2008 8:50 pm Post subject:

Hello,