Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2013
    Posts
    9

    Unanswered: reorg in hadr environment

    Hi

    I post this thread to know if there is a best practice to execute reorg command in hadr environment. My OS is AIX and my db2 version is 9.5.

    To be sure I understand

    I must reorg the primary databases
    and
    synchronisation in the same time of the standby databases

    I want to avoid the offline status on my instance.

    I think I need to improve the size of
    LOGFILSIZ, LOGPRIMARY, LOGSECOND

    Maybe create an other tablespace just for reorg action.

    I don't know exactly how procede to have the minimum of impacts in my environment...

    could you help me ?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    "I want to avoid the offline status on my instance. :" what is meant with this ?
    I think I need to improve the size of
    LOGFILSIZ, LOGPRIMARY, LOGSECOND

    these setting have no impact on hadr : logbuffer is shipped to stdby
    logfilsiz : controls the interval of archiving
    logprimary and logsecond controls the size of allowed logspace..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Feb 2013
    Posts
    9
    "I want to avoid the offline status on my instance. :" what is meant with this ?
    Sorry for my english, I don't want to have adowntime if possible...

    "these setting have no impact on hadr : logbuffer is shipped to stdby"
    what is meant with this ?
    logfilsiz : controls the interval of archiving
    logprimary and logsecond controls the size of allowed logspace..

    but these parameters can improve the efficient of the reorg ?

    for you wich procedure you use if you need to execute reorg in hadr environment ?

    thanks for your answer

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need to explain whether you want to do a classic reorg (offline) or an in-place reorg (online). Please check the documentation that explains the differences. Both are supported by HADR.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Feb 2013
    Posts
    9
    Thank you for your answer.
    To minimize the impacts, We will choose an online reorg.

    extraction of my reorgchk file :
    Table statistics:
    F1: 100 * OVERFLOW / CARD < 5
    F2: 100 * (Effective Space Utilization of Data Pages) > 70
    F3: 100 * (Required Pages / Total Pages) > 80

    SCHEMA.NAME CARD OV NP FP ACTBLK TSIZE F1 F2 F3 REORG
    ----------------------------------------------------------------------------------------

    Table: SYSIBM.SYSDATAPARTITIONS
    1270 0 15 15 - 111760 0 100 100 ---
    Table: SYSIBM.SYSDATATYPES
    25 0 1 1 - 3775 0 - 100 ---
    Table: SYSIBM.SYSDBAUTH
    2 0 1 1 - 114 0 - 100 ---
    Table: SYSIBM.SYSDEPENDENCIES
    62 0 2 9 - 5580 0 17 40 -**
    Table: SYSIBM.SYSEVENTMONITORS
    1 0 1 1 - 162 0 - 100 ---
    Table: SYSIBM.SYSEVENTS
    1 0 1 1 - 55 0 - 100 ---

    Index: JCR.IDX1522
    148 1 0 1 0 148 52 52 1862 1862 83 - - 0 0 -----
    Index: JCR.IDX1524
    148 1 0 1 148 148 42 42 1862 1862 70 - - 50 0 *--*-
    Index: JCR.IDX1525
    148 1 0 1 0 148 51 51 1862 1862 72 - - 0 0 *----
    Index: JCR.IDX1526
    148 1 0 1 0 148 51 51 1862 1862 72 - - 0 0 *----
    Index: JCR.IDX1527
    148 1 0 1 1 148 40 40 1862 1862 70 - - 0 0 *----
    Index: JCR.IDX1528
    148 1 0 1 0 148 39 39 1548 1548 84 - - 0 0 -----
    Index: JCR.IDX1529
    148 1 0 1 298 148 38 38 1548 1548 70 - - 66 0 *--*-
    Apparently, I can reorg only the lines at least 2 *


    with the command for the indexes linked to the index of primary key (reogchk lines beginning with the word table)
    example :

    db2 reorg table test.tabletest inplace


    But

    for the others indexes (reogchk lines beginning with the word index)

    I find this command

    REORG INDEXES ALL FOR schema.table ALLOW WRITE ACCESS

    Is it possible to add the option inplace

    Which consequences to execute this command ?
    Ibm speaks about a z-lock (super exclusive lock)
    In this case, is it possible to execute queries on a table locked with z-lock ?

    thanks
    Last edited by kelkel; 06-21-13 at 08:25.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •