Reorg pending status

[maidy]

Hello People!

how can i find a reorg pending status and advisory reorg pending status in catalog tables in db2 z/os?

tks

[zprogrammer]

Hi,

I don't think you can find those details in Catalog tables

You might need to use DB2 commands

Code: Select all

-DIS DB(dbname)

[maidy]

Tks Pandora,

I got the following: -DIS DB(*) SPACENAM(*) ADVISORY(AREO*)

Do You know how I do for 'REORG PENDING STATUS'? for tablespaces and indexes?

Tks again!

[zprogrammer]

Do You know how I do for 'REORG PENDING STATUS'? for tablespaces and indexes?

You mean you wanted to know how to make the Tablespace back to RW ??

[maidy]

not, sorryyyyy.... How do I find the status REORG PENDING using the Db2 commands. For tbs and indexes.

tks

[zprogrammer]

Try this command

Code: Select all

-DIS DB(*) SPACENAM(*) RES(REORP)

Also check this link

http://publibz.boulder.ibm.com/cgi-bin/ ... 0609173250

[maidy]

Thank you Pandora. With your help, I got what I needed.

[zprogrammer]

Glad it helped