CA IDMS IUA EIUA

Expand all | Collapse all

Connect and Disconnect System Index

  • 1.  Connect and Disconnect System Index

    Posted 06-06-2007 03:40 PM
    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


  • 2.  Re: Connect and Disconnect System Index

    Posted 06-06-2007 06:09 PM
    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: +61 2 9012 5434 | Mobile: +61 419 398 116 |
    Fax: +61 2 9012 6707 | Email: paul.mak@eds.com |