Results 1 to 11 of 11

Thread: Db2 reorg

  1. #1
    Join Date
    Sep 2012
    Posts
    24

    Unanswered: Db2 reorg

    Hi All,

    I ran offline reorg "db2 reorg table employee1"...when I try to see the progress by executing the command db2 list utilities show detail,it is not showing anything...

    what is the problem any gueses .....please help me

    Thank you in advance

  2. #2
    Join Date
    May 2005
    Posts
    29
    Following SQL will provide you the status

    select
    substr(tabname, 1, 15) as tab_name,
    substr(tabschema, 1, 15) as tab_schema,
    reorg_phase,
    substr(reorg_type, 1, 20) as reorg_type,
    reorg_status,
    reorg_completion,
    dbpartitionnum
    from sysibmadm.snaptab_reorg
    order by dbpartitionnum

  3. #3
    Join Date
    Sep 2012
    Posts
    24
    even that is not showing the Reorg_phase...I tried that

  4. #4
    Join Date
    May 2005
    Posts
    29
    Are you sure you have the reorg running? What version of DB2 & OS is this on?

    How about list applications?

    Also try a snapshot on tables.

  5. #5
    Join Date
    Sep 2012
    Posts
    24
    yes the reorg is running on 3 crore rows table ..os is linux and db2 is v9.7.0.1..and no applications are running because this is my lab server...I trying to looking the reorg phases for that reason I created those table and practising on it ...I am trying avoid sort phase but the phases are not showing in the db2 list utilities and and on the sql which you have given


    Really thank you for your reply

  6. #6
    Join Date
    May 2005
    Posts
    29
    Try snapshot on tables and also try db2pd -reorgs

  7. #7
    Join Date
    Sep 2012
    Posts
    24
    I tried the db2pd also but no luck,I don't know how to to snapshot on table ,can you please give me any commands ....and when I see in list history reorg it shows the reorg commpleted successfuly

  8. #8
    Join Date
    May 2005
    Posts
    29
    What command did you try for db2pd and what was the output?

    Is this db Partitioned?

    Ok, you have mentioned none of the commands to show reorg. Did you execute "db2 list applications global" and see the connection for reorg?

  9. #9
    Join Date
    Sep 2012
    Posts
    24
    Thank you got it it showing now before it is not showed for db2pd and from sql ..now it is showing ...everything is fine ...when I was working in real time usualy I will check the progress with db2 list utilities command but in my lab server it is not returning ...any guess ?


    Really Thank you for reply .....I will get answers very soon in this forum That's why I love this

  10. #10
    Join Date
    May 2005
    Posts
    29
    reorg is not one of them list utilities show the progress, it does show for utilities like RESTORE, BACKUP, LOAD, ROLLFORWARD & RUNSTATS but not for reorg.

  11. #11
    Join Date
    Sep 2012
    Posts
    24
    Thank you for the info

Posting Permissions

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