ca.portal.admin

Re: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.=20

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.

Thanks,
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.
=20
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Mysterious occurrences of 0226 status code
"The program that gets the 0226 is in an OBTAIN ERASE loop. I assume it
is doing a sweep, but I can't say for sure at this moment. I'll see if
I can find out when I gat a few minutes.



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.
-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Cherlet, Gary (JTS)
Sent: Wednesday, January 21, 2009 3:17 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: 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?

Cheers - Gary

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
MailTo:cherlet.gary@saugov.sa.gov.au

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.

Outcomes