News and tips on Db2 v12 migration : Episode 3

03 juni 2019

Space allocation information is now available in SYSINDEXES

  • PQTY
  • SECQTYI
  • FREEPAGE
  • PCTFREE
  • DSSIZE
  • STORNAME
  • STORTYPE
  • VCATNAME
Those columns contain a null value for objects created prior to Db2 12.
 

New column ‘IMPLICIT’

Applies to XML and DOCID columns. It can be useful to distinguish pure technical indexes.
 

New column KEYLABEL (introduced with Level 502)

Enable the management of z/OS encryption.
 

Added columns for new features support

  • ENFORCED_CONS
  • GBPCACHE
  • PAGENUM
  • REGENERATETS

New columns ready for future use 

  • INDEXSTATUS
  • PARTITIONS
  • PARTKEYCOLNUM
  • STATUS
Those columns will be used with a future LEVEL activation
 
 
Probably you can take benefit of those columns to review your catalog queries ... 
 
 
 
The next episode will talk about v12 options impacting utilities