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
ADDON ADS/Alive to 16.0 SP6
"Hello All:



I want to do an ADDON installation of ADS/Alive to an existing 16.0 SP6 VSE
environment.



Has anyone ever heard of having to do a maintenance tape upgrade to do an
ADDON installation?



The outsourcer is telling my client that they need to upgrade to SP7 to add
ADS/Alive?



William M. Allen, Jr.

ARCH Consulting Associates, Ltd.

(704) 641-0296
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
ADDON ADS/Alive to 16.0 SP6
"Hello All:



I want to do an ADDON installation of ADS/Alive to an existing 16.0 SP6 VSE
environment.



Has anyone ever heard of having to do a maintenance tape upgrade to do an
ADDON installation?



The outsourcer is telling my client that they need to upgrade to SP7 to add
ADS/Alive?



William M. Allen, Jr.

ARCH Consulting Associates, Ltd.

(704) 641-0296
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Mysterious occurrences of 0226 status code
"Gary;=0D=0A=0D=0AIt sounds as though the only reasonable explanation is cor=
ruption in the=0D=0Acalc chain set=2E When the erase tries to use a calc s=
et dbkey to find=0D=0Aanother record, it is not able to find the record=2E =
Running DBAN should=0D=0Aidentify the problem, but not necessarily the cau=
se of it=2E=0D=0A=0D=0AWe had a bad calc set pointer about 10 years ago, bu=
t that was an=0D=0Aisolated problem=2E If this is happening to you repeate=
dly, that is=0D=0Aworrisome=2E If there have been no obvious recovery fail=
ures, you might=0D=0Asuspect some instability in your I/O subsystem (disk p=
ages not being=0D=0Awritten and changes being lost?), or else some sort of =
storage overlay=0D=0Aissue=2E As usual, the most useful question to ask is=
""What has changed=0D=0Arecently in our processing environment?"" And of co=
urse C=2EA=2E has some=0D=0Aexcellent IDMS support staff=2E I'm sure they'=
ll give you all the help=0D=0Athey can=2E =0D=0A=0D=0ABest of luck,=0D=0AD=
oug =0D=0A=0D=0A=0D=0A=0D=0A-----Original Message-----=0D=0AFrom: IDMS Publ=
ic Discussion Forum [mailTo:IDMS-L@LISTSERV=2EIUASSN=2ECOM]=0D=0AOn Behalf =
Of Gary Bryson=0D=0ASent: Wednesday, January 21, 2009 1:01 PM=0D=0ATo: IDMS=
-L@LISTSERV=2EIUASSN=2ECOM=0D=0ASubject: Mysterious occurrences of 0226 sta=
tus code=0D=0A=0D=0ATo all the experts,=0D=0A=0D=0AWe have had a particular=
batch program abend twice in the last three=0D=0Aweeks with an 0226 status=
code=2E The program's purpose is to ERASE all=0D=0Athe records =0D=0A(onl=
y one type, CALC, no sets) in the area, while calculating statistics=0D=0Af=
rom those =0D=0Arecords=2E In both instances, in the interest of getting b=
atch processing=0D=0Adone in a reasonable time, we reFORMATed the area, and=
did without the=0D=0Astatistics=2E =0D=0A=0D=0ACan anyone suggest any non-=
obvious reason how pointers in an area with=0D=0Aone CALC record type and n=
o sets defined might be getting corrupted? We=0D=0Ahave no production loca=
l mode update jobs in this application=2E=0D=0A=0D=0AThanks,=0D=0AGary Brys=
on=0D=0ADatabase Administrator, SG Database Group=0D=0ADelta Dental/EDS Den=
ti-Cal=0D=0A=0D=0A=0D=0A=0D=0AThe information contained in this e-mail mess=
age and any attachments is=0D=0Aconfidential and intended only for the addr=
essee(s)=2E If you are not an=0D=0Aaddressee, you may not copy or disclose =
the information, or act upon it,=0D=0Aand you should delete it entirely fro=
m your e-mail system=2E Please notify=0D=0Athe sender that you received thi=
s e-mail in error=2E=0D=0A =0D=0A=0D=0A-----------------------------------=
------=0D=0AThis message and any attachments are intended only for the use =
of=0Athe addressee and may contain information that is privileged and=0Acon=
fidential=2E If the reader of the message is not the intended=0Arecipient o=
r an authorized representative of the intended=0Arecipient, you are hereby =
notified that any dissemination of this=0Acommunication is strictly prohibi=
ted=2E If you have received this=0Acommunication in error, notify the sende=
r immediately by return=0Aemail and delete the message and any attachments =
from your system=2E
"
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
"Gary;

It sounds as though the only reasonable explanation is corruption in the
calc chain set. When the erase tries to use a calc set dbkey to find
another record, it is not able to find the record. Running DBAN should
identify the problem, but not necessarily the cause of it.

We had a bad calc set pointer about 10 years ago, but that was an
isolated problem. If this is happening to you repeatedly, that is
worrisome. If there have been no obvious recovery failures, you might
suspect some instability in your I/O subsystem (disk pages not being
written and changes being lost?), or else some sort of storage overlay
issue. As usual, the most useful question to ask is ""What has changed
recently in our processing environment?"" And of course C.A. has some
excellent IDMS support staff. I'm sure they'll give you all the help
they can.

Best of luck,
Doug

Outcomes