Add new STATUS codes to SYSIBM.SYSTABLESPACE to reflect different states of the tablespace

Hello Janet,

One final comment (request).

If a code is assigned to all the other conditions in the STATUS column; a snapshot picture can be given the various states of the tablespaces.

SELECT STATUS, COUNT (*) FROM SYSIBM.SYSTABLESPACE GROUP BY STATUS;

And you can collectively address an individual condition; such as COPY with a copy utility and a LISTDEF.

Others conditions as follows but not limited to:

ACHKP
ARBDP
AREO*
AREST
AUXW
CHKP
COPY
DBETE
GRECP
ICOPY
LPL
LSTOP
PRO
PSRBD
RBDP
RBDP*
RECP
REFP
REORP
RESTP
RO
RW
STOP
STOPE
STOPP
UT
UTRO
UTRW
UTUT
WEPR

Stephen S Kline
dba Steve Kline
Mainframe DB2 Logical Database Administrator

Hello Janet,

Guessing you would want me to add REORP in my request since it also would require a reorganization to resolve the current state. It has already been implemented for check pending status (Code ���P��� and ���S��� in the STATUS column. We currently create INCLUDES for a LISTDEF that meet SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE WHERE STATUS IN (���P���,���S���) for the Check Data Utility. Can DSNACCOX do the same and select only tablespaces that are in Check Pending Status?

My end goal is to do the same for Reorganization Pending, by reading the SYSTABLESPACE looking for code in STATUS noting need for Reorganization, and create INCLUDES for a LISTDEF for the Reorganization Utility.

While I am on a roll here; we could take it a step further and add codes for the other status and take the appropriate actions associated with the code like COPY. LISTDEF with INCLUDES that will be handled by the COPY utility.

Is there any other way to extract the statuses besides the ��� DISPLAY? Is DSNACCOX capable of doing these unique extractions?

Stephen S Kline
dba Steve Kline
Mainframe DB2 Logical Database Administrator

Hello Stephen, Please see the below response from Db2 for z/OS development and let me know if you have any questions. Thank you.

It's understood that the original request was for Advisory REORG-pending state, but providing that would presumably include both AREOR and AREO*. Those alone however would not make sense as we would then want to include REORP, and even then it would introduce an inconsistency with other states not represented. Given that the capability exists to query states today, plus the existence of DSNACCOX and automation tools which query states and provide utility recommendations, we don't see the likelihood of Db2 delivering this additional capability in the near future.

Please reread. My request was not “for every status change of an object”.

Stephen S Kline
dba Steve Kline
Mainframe DB2 Logical Database Administrator

Thank you for submitting this enhancement request. The Db2 for z/OS development has reviewed it and determined we do not plan to update the catalog for every status change of an object. Existing commands, stored procedures such as DSNACCOX, or other automation products provide support for recommendations such as REORG.

Therefore, we will not be implementing this idea

We appreciate your input to the Db2 for z/OS development team. We also hope that you will continue to submit ideas for improvements as customer feedback is a key component to shaping the future direction of Db2 for z/OS.

Sincerely,

Db2 for z/OS Development

Can this request include the RESTRICT codes too? COPY and REORP would be useful.