Why does RC/Update generate RC/Alter Analysis when altering COMPRESS clause?

Document ID : KB000100814
Last Modified Date : 31/12/2018
Show Technical Document Details
Question:
Why does RC/Update generate RC/Alter Analysis when altering the Tablespace COMPRESS clause?
Answer:
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.