Connect and Disconnect System Index

[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
[e-mail]
SMTP
[e-mail]
[e-mail]
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
[e-mail]
SMTP
[e-mail]
[e-mail]
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
[e-mail]
SMTP
[e-mail]
[e-mail]
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
[e-mail]



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
[e-mail]
SMTP
[e-mail]
[e-mail]
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
[phone]

In a message dated 6/7/2007 9:17:41 A.M. Eastern Daylight Time,
[e-mail] 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
[e-mail] (mailTo:[e-mail])




************************************** See what's free at http://www.aol.com.
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
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
[e-mail]
SMTP
[e-mail]
[e-mail]
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 [phone]
Fax: [phone]

[ca.portal.admin]

I think the following procedure could be used:

1) Backup the database areas that contain the member records and the
system-owned index

2) Clone a temporary schema (using a different schema name) changing
the system-owned index from Mandatory Automatic
to Optional Manual

3) Clone a new subschema using the new schema that includes the OM
system-owned index set and its member records

4) Re-compile the update/load program using the new subschema name. The
index prefix pointer already allocated to
existing members will remain unchanged.

5) Run your long running update / load program to add new member
records. Since the system-owned index is OM, no attempt
is made to connect the new members to the index set. Existing members
remain connected to the index set. But that
would not impede your update program performance

6) When completed, run Maintain Index to rebuild index from members. You
will use the old subschema (where the
system-owned index is defined as MA) for this job. NEWSUB will be the
same old subschema with the MA index set.

MAINTAIN INDEX
IN SEGMENT segment-name
USING subschema-name NEWSUB subschema-name
REBUILD index-name FROM MEMBERS


Regards,
Paul Mak
EDS | Australia ADU | Data Engineering Capability - DBA | Level 1, 36-46
George Street, Burwood, NSW 2134 |
Office: [phone] | Mobile: [phone] |
Fax: [phone] | Email: [e-mail] |