News and tips on Db2 v12 migration : Episode 4

17 July 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.
 

New parameters

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.
 

Deprecated parameters

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