ca.portal.admin

Re:Re: Mysterious occurrences of 0226 status code

Discussion created by ca.portal.admin on Jan 22, 2009
DBAN and DB-Audit both find errors. The big puzzle here is how did the
chains get broken.



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 Chris Hoelscher
Sent: Wednesday, January 21, 2009 3:49 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Mysterious occurrences of 0226 status code

not likely - but could the 0226 be on a calc set ?

my first thought is to run a DBAN (if this was already done my
apologies)


------=_NextPart_000_E9A5B_01C97D3A.A6826B70
Content-Type: text/plain;
name=""disclaimer.txt""
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename=""disclaimer.txt""

//5EAGkAdAAgAGIAZQByAGkAYwBoAHQAIABpAHMAIAB2AGUAcgB0AHIAbwB1AHcAZQBsAGkAagBr
ACAAZQBuACAAawBhAG4AIABnAGUAaABlAGkAbQBlACAAaQBuAGYAbwByAG0AYQB0AGkAZQAgAGIA
ZQB2AGEAdAB0AGUAbgAgAGUAbgBrAGUAbAANAAoAYgBlAHMAdABlAG0AZAAgAHYAbwBvAHIAIABk
AGUAIABnAGUAYQBkAHIAZQBzAHMAZQBlAHIAZABlAC4AIABJAG4AZABpAGUAbgAgAGQAaQB0ACAA
YgBlAHIAaQBjAGgAdAAgAG4AaQBlAHQAIAB2AG8AbwByACAAdQAgAGkAcwAgAGIAZQBzAHQAZQBt
AGQALAANAAoAdgBlAHIAegBvAGUAawBlAG4AIAB3AGkAagAgAHUAIABkAGkAdAAgAG8AbgBtAGkA
ZABkAGUAbABsAGkAagBrACAAYQBhAG4AIABvAG4AcwAgAHQAZQAgAG0AZQBsAGQAZQBuACAAZQBu
ACAAaABlAHQAIABiAGUAcgBpAGMAaAB0ACAAdABlAA0ACgB2AGUAcgBuAGkAZQB0AGkAZwBlAG4A
LgANAAoAQQBhAG4AZwBlAHoAaQBlAG4AIABkAGUAIABpAG4AdABlAGcAcgBpAHQAZQBpAHQAIAB2
AGEAbgAgAGgAZQB0ACAAYgBlAHIAaQBjAGgAdAAgAG4AaQBlAHQAIAB2AGUAaQBsAGkAZwAgAGcA
ZQBzAHQAZQBsAGQAIABpAHMAIABtAGkAZABkAGUAbABzAA0ACgB2AGUAcgB6AGUAbgBkAGkAbgBn
ACAAdgBpAGEAIABpAG4AdABlAHIAbgBlAHQALAAgAGsAYQBuACAAQQB0AG8AcwAgAE8AcgBpAGcA
aQBuACAAbgBpAGUAdAAgAGEAYQBuAHMAcAByAGEAawBlAGwAaQBqAGsAIAB3AG8AcgBkAGUAbgAg
AGcAZQBoAG8AdQBkAGUAbgANAAoAdgBvAG8AcgAgAGQAZQAgAGkAbgBoAG8AdQBkACAAZABhAGEA
cgB2AGEAbgAuAA0ACgBIAG8AZQB3AGUAbAAgAHcAaQBqACAAbwBuAHMAIABpAG4AcwBwAGEAbgBu
AGUAbgAgAGUAZQBuACAAdgBpAHIAdQBzAHYAcgBpAGoAIABuAGUAdAB3AGUAcgBrACAAdABlACAA
aABhAG4AdABlAHIAZQBuACwAIABnAGUAdgBlAG4ADQAKAHcAaQBqACAAZwBlAGUAbgAgAGUAbgBr
AGUAbABlACAAZwBhAHIAYQBuAHQAaQBlACAAZABhAHQAIABkAGkAdAAgAGIAZQByAGkAYwBoAHQA
IAB2AGkAcgB1AHMAdgByAGkAagAgAGkAcwAsACAAbgBvAGMAaAAgAGEAYQBuAHYAYQBhAHIAZABl
AG4AIAB3AGkAagANAAoAZQBuAGkAZwBlACAAYQBhAG4AcwBwAHIAYQBrAGUAbABpAGoAawBoAGUA
aQBkACAAdgBvAG8AcgAgAGQAZQAgAG0AbwBnAGUAbABpAGoAawBlACAAYQBhAG4AdwBlAHoAaQBn
AGgAZQBpAGQAIAB2AGEAbgAgAGUAZQBuACAAdgBpAHIAdQBzACAAaQBuACAAZABpAHQADQAKAGIA
ZQByAGkAYwBoAHQALgANAAoAoAANAAoATwBwACAAYQBsACAAbwBuAHoAZQAgAHIAZQBjAGgAdABz
AHYAZQByAGgAbwB1AGQAaQBuAGcAZQBuACwAIABhAGEAbgBiAGkAZQBkAGkAbgBnAGUAbgAgAGUA
bgAgAG8AdgBlAHIAZQBlAG4AawBvAG0AcwB0AGUAbgAgAHcAYQBhAHIAbwBuAGQAZQByAA0ACgBB
AHQAbwBzACAATwByAGkAZwBpAG4AIABnAG8AZQBkAGUAcgBlAG4AIABlAG4ALwBvAGYAIABkAGkA
ZQBuAHMAdABlAG4AIABsAGUAdgBlAHIAdAAgAHoAaQBqAG4AIABtAGUAdAAgAHUAaQB0AHMAbAB1
AGkAdABpAG4AZwAgAHYAYQBuACAAYQBsAGwAZQANAAoAYQBuAGQAZQByAGUAIAB2AG8AbwByAHcA
YQBhAHIAZABlAG4AIABkAGUAIABMAGUAdgBlAHIAaQBuAGcAcwB2AG8AbwByAHcAYQBhAHIAZABl
AG4AIAB2AGEAbgAgAEEAdABvAHMAIABPAHIAaQBnAGkAbgAgAHYAYQBuACAAdABvAGUAcABhAHMA
cwBpAG4AZwAuAA0ACgBEAGUAegBlACAAdwBvAHIAZABlAG4AIAB1ACAAbwBwACAAYQBhAG4AdgBy
AGEAYQBnACAAZABpAHIAZQBjAHQAIABrAG8AcwB0AGUAbABvAG8AcwAgAHQAbwBlAGcAZQB6AG8A
bgBkAGUAbgAuAA0ACgCgAA0ACgBUAGgAaQBzACAAZQAtAG0AYQBpAGwAIABhAG4AZAAgAHQAaABl
ACAAZABvAGMAdQBtAGUAbgB0AHMAIABhAHQAdABhAGMAaABlAGQAIABhAHIAZQAgAGMAbwBuAGYA
aQBkAGUAbgB0AGkAYQBsACAAYQBuAGQAIABpAG4AdABlAG4AZABlAGQAIABzAG8AbABlAGwAeQAN
AAoAZgBvAHIAIAB0AGgAZQAgAGEAZABkAHIAZQBzAHMAZQBlADsAIABpAHQAIABtAGEAeQAgAGEA
bABzAG8AIABiAGUAIABwAHIAaQB2AGkAbABlAGcAZQBkAC4AIABJAGYAIAB5AG8AdQAgAHIAZQBj
AGUAaQB2AGUAIAB0AGgAaQBzACAAZQAtAG0AYQBpAGwADQAKAGkAbgAgAGUAcgByAG8AcgAsACAA
cABsAGUAYQBzAGUAIABuAG8AdABpAGYAeQAgAHQAaABlACAAcwBlAG4AZABlAHIAIABpAG0AbQBl
AGQAaQBhAHQAZQBsAHkAIABhAG4AZAAgAGQAZQBzAHQAcgBvAHkAIABpAHQALgANAAoAQQBzACAA
aQB0AHMAIABpAG4AdABlAGcAcgBpAHQAeQAgAGMAYQBuAG4AbwB0ACAAYgBlACAAcwBlAGMAdQBy
AGUAZAAgAG8AbgAgAHQAaABlACAASQBuAHQAZQByAG4AZQB0ACwAIAB0AGgAZQAgAEEAdABvAHMA
IABPAHIAaQBnAGkAbgAgAGcAcgBvAHUAcAANAAoAbABpAGEAYgBpAGwAaQB0AHkAIABjAGEAbgBu
AG8AdAAgAGIAZQAgAHQAcgBpAGcAZwBlAHIAZQBkACAAZgBvAHIAIAB0AGgAZQAgAG0AZQBzAHMA
YQBnAGUAIABjAG8AbgB0AGUAbgB0AC4AIABBAGwAdABoAG8AdQBnAGgAIAB0AGgAZQANAAoAcwBl
AG4AZABlAHIAIABlAG4AZABlAGEAdgBvAHUAcgBzACAAdABvACAAbQBhAGkAbgB0AGEAaQBuACAA
YQAgAGMAbwBtAHAAdQB0AGUAcgAgAHYAaQByAHUAcwAtAGYAcgBlAGUAIABuAGUAdAB3AG8AcgBr
ACwAIAB0AGgAZQAgAHMAZQBuAGQAZQByAA0ACgBkAG8AZQBzACAAbgBvAHQAIAB3AGEAcgByAGEA
bgB0ACAAdABoAGEAdAAgAHQAaABpAHMAIAB0AHIAYQBuAHMAbQBpAHMAcwBpAG8AbgAgAGkAcwAg
AHYAaQByAHUAcwAtAGYAcgBlAGUAIABhAG4AZAAgAHcAaQBsAGwAIABuAG8AdAAgAGIAZQANAAoA
bABpAGEAYgBsAGUAIABmAG8AcgAgAGEAbgB5ACAAZABhAG0AYQBnAGUAcwAgAHIAZQBzAHUAbAB0
AGkAbgBnACAAZgByAG8AbQAgAGEAbgB5ACAAdgBpAHIAdQBzACAAdAByAGEAbgBzAG0AaQB0AHQA
ZQBkAC4ADQAKAKAADQAKAE8AbgAgAGEAbABsACAAbwBmAGYAZQByAHMAIABhAG4AZAAgAGEAZwBy
AGUAZQBtAGUAbgB0AHMAIAB1AG4AZABlAHIAIAB3AGgAaQBjAGgAIABBAHQAbwBzACAATwByAGkA
ZwBpAG4AIABzAHUAcABwAGwAaQBlAHMAIABnAG8AbwBkAHMAIABhAG4AZAAvAG8AcgANAAoAcwBl
AHIAdgBpAGMAZQBzACAAbwBmACAAdwBoAGEAdABlAHYAZQByACAAbgBhAHQAdQByAGUALAAgAHQA
aABlACAAVABlAHIAbQBzACAAbwBmACAARABlAGwAaQB2AGUAcgB5ACAAZgByAG8AbQAgAEEAdABv
AHMAIABPAHIAaQBnAGkAbgANAAoAZQB4AGMAbAB1AHMAaQB2AGUAbAB5ACAAYQBwAHAAbAB5AC4A
IAANAAoAVABoAGUAIABUAGUAcgBtAHMAIABvAGYAIABEAGUAbABpAHYAZQByAHkAIABzAGgAYQBs
AGwAIABiAGUAIABwAHIAbwBtAHAAdABsAHkAIABzAHUAYgBtAGkAdAB0AGUAZAAgAHQAbwAgAHkA
bwB1ACAAbwBuACAAeQBvAHUAcgAgAHIAZQBxAHUAZQBzAHQALgANAAoAoAANAAoAQQB0AG8AcwAg
AE8AcgBpAGcAaQBuACAATgBlAGQAZQByAGwAYQBuAGQAIABCAC4AVgAuACAALwAgAFUAdAByAGUA
YwBoAHQADQAKAEsAdgBLACAAVQB0AHIAZQBjAGgAdAAgADMAMAAxADMAMgA3ADYAMgA=

------=_NextPart_000_E9A5B_01C97D3A.A6826B70--
"
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
"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