Mysterious occurrences of 0226 status code

Discussion created by ca.portal.admin on Jan 22, 2009
To all the experts,

We have had a particular batch program abend twice in the last three
weeks with an 0226 status code. The program's purpose is to ERASE all
the records (only one type, CALC, no sets) in the area, while
calculating statistics from those records. In both instances, in the
interest of getting batch processing done in a reasonable time, we
reFORMATed the area, and did without the statistics.

Can anyone suggest any non-obvious reason how pointers in an area with
one CALC record type and no sets defined might be getting corrupted? We
have no production local mode update jobs in this application.

Gary Bryson
Database Administrator, SG Database Group Delta Dental/EDS Denti-Cal

The information contained in this e-mail message and any attachments is
confidential and intended only for the addressee(s). If you are not an
addressee, you may not copy or disclose the information, or act upon it,
and you should delete it entirely from your e-mail system. Please notify
the sender that you received this e-mail in error.

IDMS Public Discussion Forum


Re: Mysterious occurrences of 0226 status code
"Clearly you can't be doing an area sweep - are you ? I do not understand
how you can get a record not found or no duplicates found on an ERASE.
The ERASE verb requires currency to work - so surely you would have
obtained next in area or CALC'd in on a key from a flat file. Can you
tell us a bit more about the logic / access plan? I find this very
puzzling. Are you running under CV or local mode?=20

Cheers - Gary=20

Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original
transmission and its contents. Confidentiality: This e-mail may contain
confidential information which also may be legally privileged. Only the
intended recipient(s) may access, use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are
those of the sender, not Justice Technology Services. Computer Viruses:
It is the recipient's responsibility to check the e-mail and any
attached files for viruses.