ca.portal.admin

Re:Connect and Disconnect System Index

Discussion created by ca.portal.admin on Jun 7, 2007
Hi,

Currently, we have a record that is having a system index. It is abit
slow to update a field which is the index field as the amount of data
need to be updated is huge. We would want to temporary disconnect the
system index and connnect back the index when the update is done. What
should be the correct procedure to do this.

Thks

Rgds


WARNING: This communication is meant only for the addressee(s) named
above and may contain information which is confidential and/or legally
privileged. If you are not the named addressee(s), or the agent
responsible for receiving and delivering this communication to the named
addressee(s), this communication has been sent to you in error. If so,
kindly notify the sender and delete the information immediately.
Unauthorised dissemination, distribution, copying or reliance on this
communication is prohibited and may attract criminal penalties.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Connect and Disconnect System Index
"At 22:10 6/6/2007, you wrote:
A suggestion would be to have 2 sub-schemas, one that contains the
indexes, and one that does not. Load the record set using the
sub-schema that does not have the indexes, then run a second job that
will rebuild the indexes using the complete sub-schema. Should work.
would that solution be viable if there is a UP pointer involved? if
the set is unlinked it MIGHT work, but in any schema should account
for all pointers <?> - a store might happen incorrectly if the
pointer was not known to exist

just a thought




This is Chris Hoelscher and I approved this email
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Connect and Disconnect System Index
">ensure the set is defined optional manual - if it is not, and you do
not want to change all other programs that store or delete this
record, you could create a clone schema & sinschema where the set IS
defined OM, and use that subschema for the long running update
This is Chris Hoelscher and I approved this email
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Connect and Disconnect System Index
"A suggestion would be to have 2 sub-schemas, one that contains the
indexes, and one that does not. Load the record set using the
sub-schema that does not have the indexes, then run a second job that
will rebuild the indexes using the complete sub-schema. Should work.

Outcomes