Improvements to Db2 installation and samples

Db2 11 continues to provide improvements to installing and migrating Db2 subsystems and data sharing groups. This version of Db2 for z/OS® provides enhancements to the Db2 installation CLIST, ISPF panels, and jobs, and provides new installation verification procedures (IVPs).

The Db2 installation and migration jobs have the following enhancements:

  • You can now specify functional IDs for running the installation, migration, and verification jobs. In installation panel DSNTIPG, you can specify the following functional IDs for use in the installation and IVP jobs:
    • A functional ID that is used as the current SQLID
    • A functional ID that is used as the OWNER value for the BIND commands
    • A functional ID to which privileges are granted on objects that are used by the installation jobs
  • In installation panel DSNTIPG, you can specify an ID under which Db2-supplied routines are created and bound. You can also specify an ID that is used as the SECURITY DEFINER value for Db2-supplied routines.
  • The installation CLIST now supports a maximum length of 44 bytes for Db2 target library names.
  • BIND PLAN commands in the installation, migration, and IVP jobs now contain ACTION(REPLACE) RETAIN, so that EXECUTE privileges are preserved when the plans are bound again.