ca.portal.admin

Connect and Disconnect System Index

Discussion created by ca.portal.admin on Jun 6, 2007
Latest reply on Jun 6, 2007 by ca.portal.admin
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
Connect and Disconnect System Index
"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
"HellTo:

If the index set is Mandatory Automatic and you are NOT modifying the
elements that make up the key to the index why not make the INDEX DBKEY IS OMITTED
then there will be no INDEX UP pointer in the member records and index
overhead would be kept to a minimum.

Even if you ARE modifying the elements that make up the key you should still
consider OMITTING the INDEX DBKEY from the members because along with all
the other suggestions that were provided it would make the rebuilding of the
index extremely faster.

Bill Allen
ARCH Consulting Associates, Ltd.



************************************** See what's free at http://www.aol.com.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Connect and Disconnect System Index
"Bill,
if one were to adopt the suggestion of making the set OM (and manually
connecting and disconnecting within application programs where needed)
would that not preclude the ability to go unlinked?



This is Chris Hoelscher and I approved this message!

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
Re: Connect and Disconnect System Index
"Hello Chris:

Yes, it would, but, what about future maintenance, anytime I have the
opportunity I always make a Mandatory Automatic system index OMITTED and use a
symbolic for the IBC and Displacement, during an index rebuild there is no DBL3
or DBL4 because of the OMITTED.

I am always thinking about ongoing maintenance, at some point they may want
to rebuild this index and it sounded like it had a lot of members?

Bill Allen
(704) 641-0296

In a message dated 6/7/2007 9:17:41 A.M. Eastern Daylight Time,
choelscher@HUMANA.COM writes:

Bill,
if one were to adopt the suggestion of making the set OM (and manually
connecting and disconnecting within application programs where needed)
would that not preclude the ability to go unlinked?



This is Chris Hoelscher and I approved this message!

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




************************************** See what's free at http://www.aol.com.
"
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
"Be careful when defining another schema without the index if the member
record is compressed with IDMSCOMP/DCOM or Presspack. If the control
field for the index is lower down the record than any other control
fields then the ""Control length"" will change and your new records will
be completely unreadable afterwards.

Naturally I have cocked it up with this before so I have another magic
piece of Assembler which zaps the subschema load module to get it right.
It isn't very difficult to do.

Chris Trayler

*****JuliusBaer Disclaimer***** This message is for the addressee only and may contain confidential or privileged information. You must delete and not use it if you are not the intended recipient. It may not be secure or error-free. All e-mail communications to and from the Julius Baer Group may be monitored. Processing of incoming e-mails cannot be guaranteed. Any views expressed in this message are those of the individual sender. This message is for information purposes only. All liability of the Julius Baer Group and its entities for any damages resulting from e-mail use is excluded. US persons are kindly requested to read the important legal information presented at following URL: http://www.juliusbaer.com/maildisclaimer
"
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
"If I understand this correctly you are updating the index key, not just
adding a large amount of new records.

If this is a linked index:
1. Create a new schema/subschema that has the set as optional manual.
2. Run a restructure to initialize the index pointers in the record.
3. Run the update using the new subschema.
4. Rebuild the index from allrows using the original production
schema/subschema.
If you are just adding new records you can skip the second step.

If it is an unlinked index:
1. Create a new schema/subschema that does not contain the index
2. Run the update using the new subschema.
3. Then rebuild the index from allrows using the original production
schema/subschema.

Remember backups before and after.

Tommy Petersen
110 Cokesbury Rd
Room 542H
Lebanon, NJ 08833

Phone:
Internal 200 - 3699
External (908) 236-3699
Fax: (908) 236-3692

Outcomes