ca.portal.admin

Re:Re: Tune Index

Discussion created by ca.portal.admin on Jan 15, 2007
Hello Mike:

The performance improvement would be almost impossible to calculate
because
of the way the index is used, insertions, deletions, index sizing,
displacement and page reserve, there are just to many variables.

My experience with ""tune index"" is that if you attempt to run it in
Central
Version mode it will execute a lot longer than a normal ""rebuild from
index""
in local mode. I would assume that this is due to journal activity and
orphan
adoption? During orphan adoption the calls to IDMS skyrocketed?

Also you will not see a large decrease in the number of SR8 records or
an
increase in the space available percentage with tune index.

I tried ""tune index"" on a very large index with a very large number of
orphans and it ran for over 12 hours before I canceled the job.

Over the weekend I ran a normal ""rebuild from index"" and it executed in
approximately four hours.

I can't say if you will have a similar experience but my experience with
""tune index"" on very large indexes with a large number of orphans was
not that
good.

Bill Allen

In a message dated 1/15/2007 9:08:43 P.M. Eastern Standard Time,
mikebaker345@HOTMAIL.COM writes:

Hi all,

What is the best way to estimate the performance improvement resulting
from running the ""TUNE INDEX"" utility?

Does anyone actually do this, or do you just run ""Tune Index"", knowing
that whatever orphans are adopted will improve the database
performance.
Whether the performance improvement be 1.o% or 5.0% who really cares?

After running ""Print Index"" on one particular Index, Level 0 has about
100,000 orphans within 431 SR8s.

It would be nice to measure the performance gain if its not too
difficult.

Thank you.

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








Normal

Normal
Re: Tune Index
"Hello Mike:

The performance improvement would be almost impossible to calculate because
of the way the index is used, insertions, deletions, index sizing,
displacement and page reserve, there are just to many variables.

My experience with ""tune index"" is that if you attempt to run it in Central
Version mode it will execute a lot longer than a normal ""rebuild from index""
in local mode. I would assume that this is due to journal activity and orphan
adoption? During orphan adoption the calls to IDMS skyrocketed?

Also you will not see a large decrease in the number of SR8 records or an
increase in the space available percentage with tune index.

I tried ""tune index"" on a very large index with a very large number of
orphans and it ran for over 12 hours before I canceled the job.

Over the weekend I ran a normal ""rebuild from index"" and it executed in
approximately four hours.

I can't say if you will have a similar experience but my experience with
""tune index"" on very large indexes with a large number of orphans was not that
good.

Bill Allen

In a message dated 1/15/2007 9:08:43 P.M. Eastern Standard Time,
mikebaker345@HOTMAIL.COM writes:

Hi all,

What is the best way to estimate the performance improvement resulting
from running the ""TUNE INDEX"" utility?

Does anyone actually do this, or do you just run ""Tune Index"", knowing
that whatever orphans are adopted will improve the database performance.
Whether the performance improvement be 1.o% or 5.0% who really cares?

After running ""Print Index"" on one particular Index, Level 0 has about
100,000 orphans within 431 SR8s.

It would be nice to measure the performance gain if its not too difficult.

Thank you.

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








Normal

Normal
Tune Index
"Hi all,

What is the best way to estimate the performance improvement resulting
from running the ""TUNE INDEX"" utility?

Does anyone actually do this, or do you just run ""Tune Index"", knowing
that whatever orphans are adopted will improve the database performance.
Whether the performance improvement be 1.o% or 5.0% who really cares?

After running ""Print Index"" on one particular Index, Level 0 has about
100,000 orphans within 431 SR8s.

It would be nice to measure the performance gain if its not too difficult.

Thank you.

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








Normal

Normal
Re: sysgen
"Hello Laura:

It is IDMSCSTB VERSION ##. the number is the system generation system
number.

In our case it is IDMSCSTB VER 7 as our system generation is number 7.

Bill Allen
ARCH Consulting Associates, Ltd.

In a message dated 1/15/2007 4:10:36 P.M. Eastern Standard Time,
l.rochon@VIDEOTRON.CA writes:

Hi everyone,

Please help someone whose memory is failing....

What is the name of the resource name table load module that is
generated when you do a sysgen?

Thanks,
Laura Rochon
Ajilon Consulting
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
QO85169 (16.0) and QO85168 (16.2/3/4) Apars
"Hi,



We just applied QO85169 to our test system and it caused abends in
ADSOMAIN. As soon as someone signed on it threw these messages:-



T76 D003 PROGRAM CHECK IN ADSOMAIN AT OFFSET 6EB6

PSW WAS 078D0E00 8913D4B6 DUMP OF TASK FOLLOWS



We removed QO85169 and the messages go away.



Anyone seeing this problem.



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








Normal

Normal
sysgen
"Hi everyone,

Please help someone whose memory is failing....

What is the name of the resource name table load module that is
generated when you do a sysgen?

Thanks,
Laura Rochon
Ajilon Consulting
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Print Index - report output
"Hi all,

Thanks very much for your help.

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








Normal

Normal
Re: Print Index - report output
"Hello All:

Pete is correct; the SPA is the space available on the page that the SR8
resides on. I ran a print index, got the data base key of the SR8 and then
ran a print space on that page to confirm. Pete, thanks for the correction.

Bill Allen

In a message dated 1/15/2007 3:29:22 A.M. Eastern Standard Time,
peter.g.charles@BT.COM writes:

Mike,

I agree with the answers for Bill Allen and Paul Mak apart from their
description of SPA. This I believe is the space available on the PAGE in
which the SR8 being reported on resides.

Regards

Pete Charles

Outcomes