Why does RC/Update generate RC/Alter Analysis when altering COMPRESS clause?
book
Article ID: 100814
calendar_today
Updated On:
Products
RC Compare for DB2 for z/OS
Issue/Introduction
Why does RC/Update generate RC/Alter Analysis when altering the Tablespace COMPRESS clause?
Environment
Release: Component: RCU
Resolution
When altering the COMPRESS clause, RC/Update should always generate an RC/Alter Analysis. This is because although the change can be accomplished by a DB2 ALTER statement, a Reorg utility also needs to be executed for the change to take affect.
For this reason RC/Update will perform an Analysis that will generate an ALTER statement and a Reorg utility.
The actual utility is only generated if it has been requested using Analysis option, 'REORG TS/IX/B/N ==> TS'.
If you do not request the Reorg utility then we will issue warning message RMA401W.
RMA401W THE REORG UTILITY HAS NOT BEEN REQUESTED. ALTERATIONS TO TABLESPACE dbname.tsname MAY NOT BE GENERATED. A REORG IS REQUIRED FOR ALTERATIONS TO TAKE EFFECT. dbname.tsname WILL BE ALTERED VIA THESE NATIVE DB2 COMMANDS.
With regards to whether during the above Analysis, RC/Update generates an ALTER or a DROP/CREATE depends on whether RC/Update Analysis Option 'DROP & RE-CREATE' has been set to 'N' or 'Y' respectively.