Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Ottawa
    Posts
    21

    Unanswered: REORGCHK example

    Hi, could someone give an example of a REORGCHK command? I would like to do a REORGCHK on all my tables inside my database.

    I'm running on a S/390 DB2 v7.2.

    Any help would be great.

    Thanks.
    Mbourd25

  2. #2
    Join Date
    May 2002
    Posts
    43
    db2 reorgchk current statistics on table ALL
    or if you want it to run runstats
    db2 reorgchk on table ALL

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi mbourd25,

    You wrote:

    I'm running on a S/390 DB2 v7.2.
    On witch operating sistem are you running the db2? S/390 is hardware like Intel on PC world. There are 4 operating sistems on S/390 hardware having the DB2 database:
    - MVS, OS/390, z/OS
    - VM, z/VM
    - VSE and
    - Linux for S/390.

    Execute the following command in Command Window for full sintax of reorgchk command (if using z/OS or Linux):
    db2 ? reorgchk

    Hope this helps,
    Grofaty
    Last edited by grofaty; 03-05-04 at 02:21.

  4. #4
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    in O/S 390 no reogchk utility.

    only reorg available.


    but you can find table need reorg



    if clasterratio in sysibm.sysindexe is < 90

    row overflow in sysibm.systables is > 5


    need to run reorg

    for more detail Utility Guide and Reference for

Posting Permissions

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