ca.portal.admin

Mysterious occurrences of 0226 status code

Discussion created by ca.portal.admin on Jan 21, 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.

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.



Disclaimer:
De inhoud van dit bericht is uitsluitend bestemd voor geadresseerde.
Gebruik van de inhoud van dit bericht door anderen zonder toestemming van het Kadaster
is onrechtmatig. Mocht dit bericht ten onrechte bij u terecht komen, dan verzoeken wij u
dit direct te melden aan de verzender en het bericht te vernietigen.
Aan de inhoud van dit bericht kunnen geen rechten worden ontleend.

Disclaimer:
The content of this message is meant to be received by the addressee only.
Use of the content of this message by anyone other than the addressee without the consent
of the Kadaster is unlawful. If you have received this message but are not the addressee,
please contact the sender immediately and destroy the message.
No rights can be derived from the content of this message.
"
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
"Hello Gary,

We had the same problem on IDMS 16.0 SP 0. Database got corrupted during a Rollback together with a journal switch.
We deployed APAR TD67777 for this and corrected the database with a FIX PAGE.

For IDMS 16.0 SP1 there is APAR QO79307. If you dit not deployed that this could be the problem.

APAR #: QO79307
DATE: 26 MAY 2006 PROBLEM DESCRIPTION: IDMS FAILS TO ROLL OUT UPDATES TO THE DATABASE.
IF A TRANSACTION SPANS JOURNALS, IDMS WILL NOT ROLL OUT
THE UPDATES WHICH WERE JOURNALED TO THE NEW JOURNAL.
THE FOLLOWING MESSAGES MAY APPEAR;
DC209002 TEMPORARY DELAY IN ROLLBACK
DC203006 UNABLE TO FIND BGIN/COMT CKPTS FOR ALL ACTIVE TRANSACTIONS.

Regards, Cor van Berkel
__________________________________________________________________

Kadaster Concernstaf
Afdeling ITS/SO/Bouw/DBA
Cor van Berkel, Database Administrator
Telefoonnummer (088) 183 23 13
E-mail: cor.vanberkel@kadaster.nl

Outcomes