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

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.