ca.portal.admin

Re: Broken Chain

Discussion created by ca.portal.admin on Jan 14, 2008
Check out the option of running IDMSDBAN with the SETS=NOCALC option
DBAN has been known to report erroneous CALC set errors.


In a message dated 1/14/2008 12:35:20 P.M. Eastern Standard Time,
Vince.Jensen@CGI.HEALTH.GOV.AB.CA writes:

Laura:

It is possible to have an owner pointer on a CALC record. I have a CALC
set that is a member of a via set with Next/Prior/Owner pointers. The
owner is in another CALC set.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Simpson, Colette [DOT]
Sent: Monday, January 14, 2008 10:00 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Broken Chain


Laura, I thought that was the case. but then why does my DBAN indicate
otherwise? It seems to me that if the owner of 185070:17 were
1853070:0 instead of 1844805:0, the chain would not be broken.=20

599702 - NEXT LINK NOT FOUND SET=3DCALC START OF LINK
1853070:17 OWNER IS AT 1844805:0 =20
CHAIN LENGTH 1 LINK POINTS TO
1853070:0 PRIOR IN PFX 1853070:16=20
=20

599703 - PRIOR LINK NOT FOUND SET=3DCALC START OF LINK
1853070:17 OWNER IS AT 1844805:0=20
CHAIN LENGTH 1 LINK POINTS TO
1853070:0 PRIOR IN PFX 1853070:16=20
=20

599703 - PRIOR LINK NOT FOUND SET=3DCALC START OF LINK
1853070:0 OWNER IS AT 1853070:0=20
CHAIN LENGTH 1 LINK POINTS TO
1853070:1 PRIOR IN PFX 1853070:17
=20

599702 - NEXT LINK NOT FOUND SET=3DCALC START OF LINK
1853070:16 OWNER IS AT 1853070:0
CHAIN LENGTH 1 LINK POINTS TO
1853070:17 PRIOR IN PFX 1853070:1=20
Thanks,

Colette


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Monday, January 14, 2008 10:21 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Broken Chain

Hi Colette,

There is no owner pointer in the CALC set.

Laura Rochon
Ajilon Consulting

Simpson, Colette [DOT] wrote:
I am trying to fix a broken chain which is in the CALC set of a
record.
The next and prior db keys seem to be fine, but the owner pointer=20
seems to point to the wrong owner. I can see the next and prior=20
pointers in the record, but cannot find the owner pointer. Can=20
someone tell me where to look for the CALC chain owner pointer for
a=20 record, so I can fix it to point to the correct owner?

TIA
Colette

**************Start the year off right. Easy ways to stay in shape.
http://body.aol.com/fitness/winter-exercise?NCID=aolcmp00300000002489
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Broken Chain
"Broken pointers usually occurs when a local job updates and abends, and the
buffer for one page is written back, but not the buffer for another.
In your case the broken pointers are all on the same page, so I am going to
stick my neck out and suggest that the CALC key for that one record has
been updated using TSO, PFix or another utility outside of the regular IDMS
environment.

Since you have only one of these, it is unlikely expand page, extend area,
reorg or some other maintenance has gone wrong.

You may be able to go into DMLO or DBOL, retrieve the record via the DB key
(1853070:17) and change the CALC key to something that it isn't and issue
the modify, then change it back, and modify, and then be back in business.
If IDMS won't let you do that, you will need to fix the record the same way
it was broken to make sure the CALC key points to the target page
1853070:0.

Because this is the CALC set, you may also be able to run an unload/reload
to fix it.

Tommy Petersen




""Simpson, Colette
[DOT]""
<Colette.Simpson@ To
DOT.IOWA.GOV> IDMS-L@LISTSERV.IUASSN.COM
Sent by: IDMS cc
Public Discussion
Forum Subject
<IDMS-L@LISTSERV. Re: Broken Chain
IUASSN.COM>


01/14/2008 11:59
AM


Please respond to
IDMS Public
Discussion Forum
<IDMS-L@LISTSERV.
IUASSN.COM>







Laura, I thought that was the case. but then why does my DBAN indicate
otherwise? It seems to me that if the owner of 185070:17 were 1853070:0
instead of 1844805:0, the chain would not be broken.

599702 - NEXT LINK NOT FOUND SET=CALC START OF LINK 1853070:17
OWNER IS AT 1844805:0
CHAIN LENGTH 1 LINK POINTS TO 1853070:0
PRIOR IN PFX 1853070:16


599703 - PRIOR LINK NOT FOUND SET=CALC START OF LINK 1853070:17
OWNER IS AT 1844805:0
CHAIN LENGTH 1 LINK POINTS TO 1853070:0
PRIOR IN PFX 1853070:16


599703 - PRIOR LINK NOT FOUND SET=CALC START OF LINK 1853070:0
OWNER IS AT 1853070:0
CHAIN LENGTH 1 LINK POINTS TO 1853070:1
PRIOR IN PFX 1853070:17


599702 - NEXT LINK NOT FOUND SET=CALC START OF LINK 1853070:16
OWNER IS AT 1853070:0
CHAIN LENGTH 1 LINK POINTS TO 1853070:17
PRIOR IN PFX 1853070:1
Thanks,

Colette

Outcomes