Results 1 to 4 of 4

Thread: Db2rbind

  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: Db2rbind

    Hi,
    Db2 version is V9.5

    I have to run REORG,RUNSTAT,REBIND on a regular basis.What all the steps i have to perform for doing the same.please help

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Do a RUNSTATS
    Do a REORGCHK to identify the tables that need a reorg.
    REORG the table/index
    Do runstats on the reorged objects
    rebind

    hth
    Last edited by sathyaram_s; 03-08-11 at 08:27. Reason: upper-cased commands
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2011
    Posts
    2
    tnx....please let me know the commands to perform the same....

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I suggest that you google for them .. You may find scripts to do it all ..

    I have put the command strings in upper-case to help you do the search

    This forum likes and helps people who ask for support rather than asking to be spoon-fed ;-)

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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