ca.portal.admin

PAGE RESERVE AND CALC ALGORITHM

Discussion created by ca.portal.admin on Jan 4, 2006
Hi everybody !!!!

We are trying to unload/reload a page with calc records and defining a
page
reserve for the future new records. Is there any effect in the calc
algorithm with the page reserve sentence in the area ??? I remember than
in
the past I had some problems extending a page with calc records, because
the
clac algorithm consider the page range and if you extend the page range
there is a change in the calc algorithm. I'm wonder if in the case of
page
reserve is there any effect in the calc algorithm ?? The idea is
unload/reload one area using page reserve of *** characters and after
that
switch the page reserve to 0 characters.

TIA.

Javier S.

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

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








Normal

Normal
Re: PAGE RESERVE AND CALC ALGORITHM
"The CALC algorithm is not affected - but - as I'm sure people will explain -
what happens after records are physically stored in the database will
definitely be affected by a Page Reserve as you may put CALC records into
overflow that you had not intended. Some overflow is unavoidable - but
sorting the data in descending sequence on DBKEY before the load will
minimise the impact of overflows. See Neal Walter's ItDoesMoreStuff.com for
an explanation.

Happy New Year - cheers - Gary

Gary Cherlet
Justice Technology Services
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613
MailTo:cherlet.gary@saugov.sa.gov.au

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original transmission
and its contents.
Confidentiality: This e-mail may contain confidential information which
also may be legally privileged. Only the intended recipient(s) may access,
use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are those
of the sender, not Justice Technology Services.
Computer Viruses: It is the recipient's responsibility to check the e-mail
and any attached files for viruses.

Outcomes