Command changes in Db2 12

Db2 12 introduces new commands and changes to existing commands.

End general-use programming interface information.
Important: Db2 12 introduces continuous delivery of new capabilities and enhancements in function levels. Most new capabilities become available only after activation of the Db2 12 function level that introduces them, or when applications run with the corresponding application compatibility level. For more information, see Activating Db2 12 function levels.

Command changes in function level 501 and higher

The following changes to commands take effect when you activate function level 501 or higher in Db2 12.

Function level Command Change introduced Incompatible change?
FL 502 -DISPLAY ARCHIVE command (Db2) The DISPLAY ARCHIVE command displays the current key label information for active logs and archive logs. No
FL 502 -DISPLAY GROUP command (Db2) The DISPLAY GROUP command output now provides the current ENCRYPTION_KEYLABEL system parameter value. No
FL 502 -DISPLAY LOG (Db2) The DISPLAY LOG command now displays the current key label information for active logs and archive logs. No

Command changes in function level 500

The following changes to commands take effect when you activate function level 500 in Db2 12.

Command Change introduced Incompatible change?
-ACCESS DATABASE command (Db2) If the externalization of real-time statistics (RTS) fails, Db2 now issues message DSNT538I. Yes
-ALTER BUFFERPOOL command (Db2) The meaning of the existing PGSTEAL(NONE) option is changed. As in previous versions, Db2 pre-loads the data for assigned objects when they are opened and keeps the data resident until the objects are closed.

However, in Db2 12, Db2 creates an overflow area within the VPSIZE of the buffer pool. If all open assigned objects do not fit into the main part of the buffer pool, pages are allocated to the overflow area. Page stealing is possible in the overflow area. After pages are allocated in the overflow area, you must close the object to move the pages back to the overflow area.

No
-ALTER GROUPBUFFERPOOL command (Db2) The maximum value that can be specified for the RATIO keyword is now increased to 1024. No
BIND PACKAGE subcommand (DSN) The following new option is added: CONCENTRATESTMT. No
BIND QUERY subcommand (DSN) Support is added for processing the following SQL statement types:
  • INSERT
  • UPDATE WHERE CURRENT OF
  • DELETE WHERE CURRENT OF
No
-DISPLAY DYNQUERYCAPTURE command (Db2) New command. No
-DISPLAY GROUP command (Db2) The DSN7100I message output is modified to indicate information about the code, catalog, and function levels of the Db2 subsystem or data sharing group. No
-DISPLAY ML command (Db2) New command. 1 No.
-DISPLAY STATS command (Db2) New command.

New options:

  • INDEXTRAVERSECOUNT is used to display the index traverse counts for a specific index, or for a specified number of indexes with the highest traverse counts, in descending order. Output is returned by message DSNT830I.
  • LOGREADERTASKS and LOGREADERTASKS SCOPE(GROUP) options are used to display statistics about any log reading tasks that are currently running. Output is returned by message DSNT788I.
No
-DISPLAY UTILITY command (Db2) The output now includes message DSNU285I. Yes
FREE STABILIZED DYNAMIC QUERY subcommand (DSN) New command. No
FREE PACKAGE subcommand (DSN) If you specify INACTIVE, PREVIOUS, ORIGINAL for the PLANMGMTSCOPE option, FREE PACKAGE processing can now complete while applications that use the package are running.

New values are added for an existing option: PLANMGMTSCOPE(PREVIOUS|ORIGINAL).

A new option is added: INVALIDONLY

A new value is added to an existing option: PLANMGMTSCOPE(PHASEOUT).

No
FREE SERVICE command (DSN) New command.

SERVICE now supports specifying location-name and version-id.

No
-MODIFY DDF command (Db2)

After the PTF for APAR PH08188 is applied, PORT and SECPORT can now have the name value.

A new option is added: SESSIDLE.

No
REBIND PACKAGE subcommand (DSN)

This command can be used to rebind a package for an advanced trigger.

The following new options are added:

  • APREUSESOURCE
  • CONCENTRATESTMT

If the SWTICH option is specified with an invalid package, the command now fails.

Yes
REBIND TRIGGER PACKAGE command (DSN) This command can be used to rebind a package for a basic trigger, including any trigger that was created prior to the activation of function level 500 or higher.

A new option is added: APREUSESOURCE.

If the SWTICH option is specified with an invalid package, the command now fails.

Yes
-START DB2 command (Db2) You cannot start Db2 at any code level that is lower than the catalog level or the highest activated function level. No
-START PROFILE command (Db2) If the PROFILE_AUTOSTART subsystem parameter is set to YES, this command is now issued automatically when Db2 starts. No
-START ML command (Db2)

New command. 1

New options added: *, SQLOPT, and SA_DCC.

No
-START RLIMIT command (Db2) Certain previously supported resource limit table formats are deprecated or unsupported in Db2 12. Resource limits are not activated for tables with unsupported formats. No
-STOP ML command (Db2)

New command. 1

New options added: *, SQLOPT, and SA_DCC.

No
-TERM UTILITY command (Db2) The TERM UTILITY command can be used for the MODIFY RECOVERY utility. No
-START CDDS command (Db2) New command. No
-STOP CDDS command (Db2) New command. No
-START DYNQUERYCAPTURE command (Db2) New command. No
-STOP DYNQUERYCAPTURE command (Db2) New command. No
Notes:
  1. With IBM Db2 AI for z/OS Version 1.1.0.1 or later and APAR PH05323.

Command changes in function level 100

The following changes to commands take effect when you migrate to function level 100 in Db2 12 from Db2 11.

Command Change introduced Incompatible change?
-ACTIVATE command (Db2) New command. No
BIND SERVICE subcommand (DSN) New command.

The following options are added:

  • ACCELERATIONWAITFORDATA
  • COPY
  • COPYVER
  • OPTIONS
  • VERSION
No
-DISPLAY ACCEL command (Db2) If the DETAIL keyword is specified for multiple accelerators, Db2 12 issues a separate DSNX830I message is issued for each accelerator. No
-DISPLAY BLOCKERS command (Db2) New command. No
-DISPLAY LOCATION command (Db2) New option: INCOMPLT No
-DISPLAY RESTSVC command (Db2) New command. No
FREE SERVICE command (DSN) New command. No
-MODIFY DDF command (Db2) New option: ACCTG No
REBIND PACKAGE subcommand (DSN)

The following options are added:

  • RESTSERVICEDEFAULT
No
-START RLIMIT command (Db2) Resource limits that apply to existing threads can now be modified by issuing the START RLIMIT command.

A new option is added: SCOPE.

No
-START RESTSVC command (Db2) New command. No
-STOP RESTSVC command (Db2) New command. No
End general-use programming interface information.