MVSFORUMS.com

[Ram]

Hi All,

I am trying to free up some space in our development systems. I am trying to delete first 100 occurences of a particular record. This is how I am doing it :
Obtain next record within <area>
erase <rec type> all members.

The IDMS error code when I execute the erase stmt is '0202' or '0260' or '0226'. I am getting the same error codes when I do it thu batch or dmlo. I tried readying all areas , but it does'nt work .

Any help would be greatly appreciated .

Thanks
Ram

[kolusu]

Ram,
Here is an explanation of the Error-codes you are getting.

0202 - DBKEY is inconsistent

Probable causes are:

1) DBKEY may have a wrong value, nulls, zero, or overlaid working storage
2) Record name is incorrect
3) Wrong Subschema
4) DBKEY is outside of page range for Area

0226 - Record not found

Probable causes are:

Possible Broken Chain.

If you are running on a nonproduction system, this error often means a VDB shadow needs to be refreshed

0260 - A record occurrence has been encountered whose type is inconsistent with the set named in the error set field of the IDMS Control Block.

1) An affected record occurrence has been found in the database, but its record-type has
not been found in the subschema as a member or owner of the set.

Probable causes are:
(a) A broken chain exists in the database due to improper recovery.
(b) A new schema and associated subschemas describe an existing database improperly.
(c) VDB Shadow (Virtual Database) too far out-of-sync with live database.


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Ram]

Kolusu

Thanks a zillion for the reply . So I believe its the DBA's who will have to fix these errors . You mentioned about VDB Shadow. Could you pls provide links or expain in brief what it atually means ?

Thanks
Ram

[vivek]