Results 1 to 4 of 4

Thread: reorgchk

  1. #1
    Join Date
    Aug 2003
    Posts
    33

    Unanswered: reorgchk

    Is it necessary to disconnect all the applications connected to database before doing reorgchk.

    Thanks
    mc

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    mc,
    No.

    Andy

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: reorgchk

    NO

    Reorgchk does a runstats(if requested) and some simple SQL Queries to find out whether a reorg will be useful ...

    If you decide to REORG a table, your applications using that table will fail when the reorg is in progress ...

    With V8 , you can do an online reorg ...

    HTH

    Sathyaram

    Originally posted by mcdb2
    Is it necessary to disconnect all the applications connected to database before doing reorgchk.

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

  4. #4
    Join Date
    Aug 2003
    Posts
    33
    Thanks Andy , Sathyaram for providing me the information
    mc

Posting Permissions

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