Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    1

    Unanswered: Reorging of a table

    UDB V9.1 OS Aix.5.3

    I am reroging a table with the following command.
    reorg table tablename use temp;

    I was expecting that it reorgs only the table data. But for my surprise
    i did see in the diaglog that it rebuilding the indexes too.

    Is there any special option that will allow us to reorg only table data.

    thanks
    miami

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Off-line reorg (sometimes known as classic reorg) will reorg table and indexes. If you do an on-line reorg, you can reorg the table only.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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