Reorg pending status
Reorg pending status
Hello People!
how can i find a reorg pending status and advisory reorg pending status in catalog tables in db2 z/os?
tks
how can i find a reorg pending status and advisory reorg pending status in catalog tables in db2 z/os?
tks
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Reorg pending status
Hi,
I don't think you can find those details in Catalog tables
You might need to use DB2 commands
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)
zprogrammer
Re: Reorg pending status
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!
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!
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Reorg pending status
You mean you wanted to know how to make the Tablespace back to RW ??Do You know how I do for 'REORG PENDING STATUS'? for tablespaces and indexes?
zprogrammer
Re: Reorg pending status
not, sorryyyyy.... How do I find the status REORG PENDING using the Db2 commands. For tbs and indexes.
tks
tks
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Reorg pending status
Try this command
Also check this link
http://publibz.boulder.ibm.com/cgi-bin/ ... 0609173250
Code: Select all
-DIS DB(*) SPACENAM(*) RES(REORP)
http://publibz.boulder.ibm.com/cgi-bin/ ... 0609173250
zprogrammer
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute