Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Mark Labby
    You have a secure email message waiting for you from Mark Labby at AES/PHEAA with the subject: Rebuild Pending on Index.

    How to Retrieve Your Message

    To retrieve your message from Mark Labby with the subject: Rebuild Pending on Index, go to:
    https://securemail.aessuccess.org/messenger/msg?x=d-28942932-st4PR9KSdSH3NPyD

    This message will be available until 05/22/2009.

    Why You Are Receiving this Email

    AES/PHEAA has sent you a message that may include sensitive information or personal data, as defined by federal law. To protect the privacy of this information, the email has been encrypted.


    Personal data protected by federal law includes:
    Social Security numbers
    Driver's license numbers
    credit reports/scores


    If you have questions regarding the authenticity of this message, please
    visit us online at www.aesSuccess.org/securemail, or contact us:

    Phone: 1-800-233-0557
    Email: [login to unmask email]
    Postal mail: AES/PHEAA
    1200 N 7th St
    Harrisburg, PA 17102


    =====
    This message contains privileged and confidential information intended for the
    above addressees only. If you receive this message in error please delete or
    destroy this message and/or attachments.

    The sender of this message will fully cooperate in the civil and criminal
    prosecution of any individual engaging in the unauthorized use of this message.
    =====

    ______________________________________________________________________

    * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
    ______________________________________________________________________




    IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html
    Mark Labby

    What are the ramifications of creating an index with DEFER YES and not immediately rebuilding the index?

    The new index is put into REBUILD PENDING.   Neither the table nor any previously existing index is placed into any special status, so should be fully accessible.  Has anyone had any issues or things to consider if the index creates actually occur a few days before the building of the index?

    Normally we have been creating the indices deferred, followed by a Reorg Tablespace - which can be Shrlevel Change, so no outage.  Our reorg window, even with Shrlevel Change is pretty much confined to a few hours on Sunday morning.  When we do other data model changes, the create index is added to the list of changes and the reorg jobs start immediately after.  I have some new indices required and no other changes to occur, so rather than putting them in Sunday morning I was considering doing the create on Friday and just letting the reorg occur on Sunday as usual. ===== This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging in the unauthorized use of this message. =====

    IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia

    IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.

    Kirk Hampton
    [HCL Technologies]
    One issue I encountered in the past was that,
    as soon as I created the index with DEFER YES,
    an existing CICS transaction could no longer
    insert rows into the table, because the new index's
    status of REBUILD PENDING prevented the insert.

    Not user if that was on V6 or v7, but be careful. Do
    you have a test environment where you can try it ?




    ________________________________________
    From: DB2 Data Base Discussion List [[login to unmask email] On Behalf Of Mark Labby - AES [[login to unmask email]
    Sent: Monday, March 23, 2009 8:55 AM
    To: [login to unmask email]
    Subject: [DB2-L] Rebuild Pending on Index

    What are the ramifications of creating an index with DEFER YES and not immediately rebuilding the index?

    The new index is put into REBUILD PENDING. Neither the table nor any previously existing index is placed into any special status, so should be fully accessible. Has anyone had any issues or things to consider if the index creates actually occur a few days before the building of the index?

    Normally we have been creating the indices deferred, followed by a Reorg Tablespace - which can be Shrlevel Change, so no outage. Our reorg window, even with Shrlevel Change is pretty much confined to a few hours on Sunday morning. When we do other data model changes, the create index is added to the list of changes and the reorg jobs start immediately after. I have some new indices required and no other changes to occur, so rather than putting them in Sunday morning I was considering doing the create on Friday and just letting the reorg occur on Sunday as usual. ====== This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging in the unauthorized use of this message. ======
    ________________________________

    IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia < http://idug.org/lsAU >

    IDUG.org <http://www.idug.org> was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.< http://www.idug.org/component/juser/register.html >







    This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is
    intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to
    read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message
    in error, please notify the sender immediately and delete all copies of this message.

    ______________________________________________________________________

    * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
    ______________________________________________________________________




    IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html
    Adam Baldwin
    [DB2 Consultant]
    Mark, as REBUILD PENDING is a restrictive state you wont be able to modify
    the table - no Inserts/Updates/Deletes. Obviously if your table is read only
    that wont be a problem.

    ______________________________________________________________________

    * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
    ______________________________________________________________________




    IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact