17 juillet 2019
V12 impacts on Utilities
Every release implies changes for utilities, here is some new options and some deprecated ones. This list is not exhaustive, it points to some interesting ones.
INVALIDATECACHE YES/NO can be used in all utilities generating statistics : RUNSTATS or INLINE STATS
DELETEDS and NOCOPYPEND can be used in MODIFY utility to delete the copy dataset and to avoid a COPYPEND status after scratching all entries in the syscopy.
SCOPE UPDATE specifies that unchanged objects are to be skipped during recovery. However, you can explicitly specify SCOPE ALL to indicate that all objects are to be processed by the RECOVER utility, regardless of whether they have changed since the recovery point.
CHANGELIMIT can no more be used to trigger an incremental copy.
KEYCARD has no more effects in RUNSTATS but can stay in your control statement without error message issues.
REORG with UNLOAD PAUSE/ONLY/EXTERNAL options : also deprecated, alternatives are suggested in the utility guide.
Following statement must be replaced by the use of the Stored Procedure DSNACCOX:
• REORG INDEX with LEAFDISTLIMIT
• REORG TABLESPACE with INDREFLIMIT and REPORT ONLY
• REORG TABLESPACE with OFFPOSLIMIT and REPORT ONLY
Next episode: LEVEL501 activation and client/driver compatibility