Page 1 of 1
Reorg pending status
Posted: Sat Feb 22, 2014 5:26 pm
by maidy
Hello People!
how can i find a reorg pending status and advisory reorg pending status in catalog tables in db2 z/os?
tks
Re: Reorg pending status
Posted: Sat Feb 22, 2014 10:45 pm
by zprogrammer
Hi,
I don't think you can find those details in Catalog tables
You might need to use DB2 commands
Re: Reorg pending status
Posted: Mon Feb 24, 2014 3:51 pm
by 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!
Re: Reorg pending status
Posted: Mon Feb 24, 2014 4:05 pm
by 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 ??
Re: Reorg pending status
Posted: Mon Feb 24, 2014 4:19 pm
by maidy
not, sorryyyyy.... How do I find the status REORG PENDING using the Db2 commands. For tbs and indexes.
tks
Re: Reorg pending status
Posted: Mon Feb 24, 2014 6:20 pm
by zprogrammer
Re: Reorg pending status
Posted: Thu Feb 27, 2014 3:07 am
by maidy
Thank you Pandora. With your help, I got what I needed.
Re: Reorg pending status
Posted: Thu Feb 27, 2014 11:52 am
by zprogrammer
Glad it helped