ca.portal.admin

BUILD/REBUILD Indexes

Discussion created by ca.portal.admin on Mar 1, 2005
Latest reply on Mar 1, 2005 by ca.portal.admin
Would someone be able to tell me which one I should use if I want to tidy up
indexes, do I use BUILD or REBUILD in MAINTAIN INDEX?
I think I read somewhere that BUILD can only be used for SQL database, is
this correct?

Thankyou
Ina Mason
Transport SA

--------------------------------------
Dexia Bank disclaimer :
http://www.dexia.be/maildisclaimer.htm
--------------------------------------




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








Normal

Normal
2005 IDMS EDUCATION SCHEDULE
"Hello All:

ARCH Consulting is pleased to announce that we have updated our web site
www.archcons.com (http://www.archcons.com) with our 2005 IDMS Education
Schedule.

Please visit our web site and click on IDMS Public Education for a complete
schedule, course descriptions and training facility information.

Visit www.archcons.com (http://www.archcons.com) for all your IDMS
Education & Training needs.

William M. Allen, Jr.
ARCH Consulting Associates, Ltd.
www.archcons.com (http://www.archcons.com) Web Site
archcons@aol.com (mailTo:archcons@aol.com) E-mail
(704) 641-0296 Phone
(704) 543-0158 Fax

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








Normal

Normal
Re: SMP Question
"Actually no - the area has 99000+ pages @ 18452. Only 543 were logially
full. In fact 5600 had 9K free and over 33000 had about 7K free. The
problem was that the SMPs showed 0 space available on all pages. Since the
record is calc, IDMS goes to the target page to store the record - if no
space is available, IDMS goes to the SMP to 1) update the SMP to a page full
condition for the target page in question and 2) to look for the next
available page with space left to store the new record. The SMPs (all 11 of
them) showed that there were NO pages with space. And yet, as I noted above
there was space available.

I guess my question is - what (and when) decrements an SMP from 'full' to
'space available'. The answer to this could possibly lead to a change in
our processing logic during an erase/modify condition.

Or, does this have something to do with 1) the fact that the records are
compressed or maybe 2) the condition (utilization) of the area when the
page-convert utility was run?

Outcomes