If you share the area between two CVs, with one having it set to update and the other having it set to retrieval, you should look into using shared cache, the manuals are fairly straight forward on how to do it.
We had it for years with the two CVs sharing the file, and once in a while the programs on the retrieval CV would not find the data that we knew were in the database. We tracked it down to a high level SR8; once it was read, it would stay in the buffer. What would happen, usually during the busiest period of the year, the lower level SR8 would split due to updates, but the SR8 in the buffer would not receive the update, and still point to the old lower level SR8 for keys that were split off into a new SR8.
I was going to use data sharing, but after consulting with IDMS support who suggested shared cache, we used that. Data sharing is not needed if only one CV is updating.
I continue to reply to myself. Maybe I end up starting an argument, with me, about how to best resolve this.
------------------------------
Tommy Petersen
------------------------------
Original Message:
Sent: 09-29-2020 12:40 PM
From: Petersen
Subject: Status 0353 error.... INDEXED SET MISMATCH SS/DB
Are you running in local mode, or accessing a record that is updated from another CV? Then it may just be a phantom broken chain.
These can happen when a buffer in one block has a pointer to a line index, but the record at that line index was deleted and another inserted, so your read-only CV/local running program has an old buffer that thinks it is pointing to a CLIENT, but in reality that line index is now a VENDOR record. If the error happened in a local running program, the problem would likely go away by rerunning. If it is a CV that has the file included in read-only mode while another CV is updating, the issue can persist for a long time, depending on the type of record and size of buffers in the read-only CV.
If the area can be set to retrieval, you can run a DBAN to find out if there is an issue with the index.
------------------------------
Tommy Petersen
Original Message:
Sent: 09-29-2020 02:34 AM
From: Stephen Cox
Subject: Status 0353 error.... INDEXED SET MISMATCH SS/DB
Hi,
I'm getting the above error when trying to Obtain a Record. How do I find the mismatch and fix it?
OBTAIN FIRST RECORD
INDEXED SET MISMATCH SS/DB
SUBSCHEMA=SS001 SCHEMA=SC001 VER=0001 COL 001-080 LINE 0001 OF 0167
Any help will be appreciated.... ��
| | | TSSA | Mainframe DBA | Avanti Towers North Block, 4 Churchill Close, Bellville, 7530 | | | | | | | | | Registration Number: 1989/007547/07 | | | | | |
Disclaimer: This message and/or attachment(s) may contain privileged, confidential and/or personal information. If you are not the intended recipient you may not disclose or distribute any of the information contained within this message. In such case you must destroy this message and inform the sender of the error. T-Systems does not accept liability for any errors, omissions, information and viruses contained in the transmission of this message. Any opinions, conclusions and other information contained within this message not related to T-Systems' official business is deemed to be that of the individual only and is not endorsed by T-Systems.