ca.portal.admin

Re: Mysterious occurrences of 0226 status code

Discussion created by ca.portal.admin on Jan 22, 2009
Gary,

We have occasionally seen things under the category of Stupid Programmer
Tricks -- such as creating their own version of SUBSCHEMA-CTRL in
working storage, then using incorrect offsets, or having the program
overwrite its own storage causing all sorts of havoc, etc.

Of course, as you point out, the problem is finding which program caused
the error and when it happened. If you can restore from your backups to
alternate named files, you can then run the DBAN in local mode against
those without disturbing your production data while it is under control
of the CV.

Be sure to let us all know when you finally find the solution! This one
sure has generated a lot of excitement on the list.

Jim Ritterbusch

--
""The road to **** is paved with unbought stuffed dogs."" -- Hemingway


Gary Bryson wrote:
The program that gets the 0226 is in an OBTAIN ERASE loop. I assume=20
it is doing a sweep, but I can't say for sure at this moment. I'll=20
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=20
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=20
obtained next in area or CALC'd in on a key from a flat file. Can you=20
tell us a bit more about the logic / access plan? I find this very=20
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=20
by reply e-mail to the sender. Please also destroy the original=20
transmission and its contents. Confidentiality: This e-mail may=20
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=20
attached files for viruses.

-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Gary Bryson
Sent: Thursday, 22 January 2009 4:31
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Mysterious occurrences of 0226 status code

To all the experts,

We have had a particular batch program abend twice in the last three=20
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=20
calculating statistics from those records. In both instances, in the=20
interest of getting batch processing done in a reasonable time, we=20
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? =20
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=20
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=20
upon it, and you should delete it entirely from your e-mail system.=20
Please notify the sender that you received this e-mail in error.

"
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
"We had the same problem just yesterday with 9 jobs getting 0226. A
programmer turned over JCL that had a test loadlib and the test database
area had just been resized with an Unload/Reload. I always use SMF
record type 15 to see who is really writing to a database file, it does
not lie and I never know what some enterprising application programmer
here can do without me knowing about it, there have been some real good
ones here over the years.........

Steve Harmeson

Outcomes