substr(tabname, 1, 15) as tab_name,
substr(tabschema, 1, 15) as tab_schema,
substr(reorg_type, 1, 20) as reorg_type,
order by dbpartitionnum
yes the reorg is running on 3 crore rows table ..os is linux and db2 is v220.127.116.11..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
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