ca.portal.admin

Re:one more thing .....

Discussion created by ca.portal.admin on Mar 13, 2009
Compuware Abend-Aid for IDMS supports release 17 at version 11.1 only!


Chris Hoelscher
Senior IDMS & DB2 Database Administrator Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL
material. If you receive this material/information in error,
please contact the sender and delete or destroy the
material/information.
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Why 1211?
"yes - i would look for a index length vs a print space such that no one
page coulds handle a full sr8 to be stored .....


Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
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: [IDMSVENDOR-L] Why 1211?
"yes - i would look for a index length vs a print space such that no one
page coulds handle a full sr8 to be stored .....


Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Why 1211?
"A batch job received a 1211 abend on an index area that was 72% full. A FIND for ""orph"" in the B-tree output did not get very many hits, but each ORPH= statement showed thousands of orphans. When the index was rebuilt it went down to 68% and the job was rerun successfully. My guess is that there is a really bad SR8 length on the index. Is that the most likely cause, or should I be looking elsewhere?

We're on Release 16. The index has been around for years with no other problems.

TIA,

Jerry




"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Why 1211?
"Hi Jerry,

The index ""being around for years"" might be the problem. Over the years, m=
odifying this index caused fragmentation. I don't think TUNE INDEX would h=
ave helped because you had so many orphans. =20
You did the right thing by rebuilding the index. We schedule regular index=
rebuild jobs on our most actively updated indexes.
It wouldn't hurt to review your page size, SR8 size, index key length, etc.
Sixty eight percent utilization does not leave much room for growth. This =
must be a fairly static index to have been around for years with no issues.
There is a calculation that you can use in the IDMS documentation to maximi=
ze to efficiency of your index areas.

Best of luck,

Jim

Outcomes