Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007

    Unanswered: db2pd reorg status

    I have v8.2 FP 17.

    The other day I ran online reorgs and was looking at the db2pd status. When they were done, db2pd reported nothing active and showed no tables.

    When I do a db2pd today (the reorg ran this morning as a batch job), I get "Active", but Status says Done.

    E:\Jobs\reorg>db2pd -d mydb -reorgs
    Database Partition 0 -- Database mydb -- Active -- Up 4 days 02:19:55
    Table Reorg Stats:
    Address    TbspaceID  TableID    TableName          Start                      End                        PhaseStart               MaxPhase   Phase      CurCount   MaxCount   Type    Status  Completion IndexID    TempSpaceID
    0x03189304 2          7          ISSUE              03/09/2010 04:55:34.302234 03/09/2010 04:55:54.262300             n/a          n/a        n/a        3291       3292       Online  Done    0          0          2
    When do they drop off this listing?
    Last edited by bic; 03-09-10 at 09:38.

  2. #2
    Join Date
    Feb 2007
    Essentially is it safe to do a db2rbind now?

  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    I'd begin with runstats anyway.
    "It does not work" is not a valid problem statement.

Posting Permissions

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