Command changes in Db2 13

You can use this information to plan for changes in Db2 and related commands at migration to Db2 13 and in continuous delivery.

Command changes in function levels 502 and higher

The following changes to commands take effect when you activate the specified function level in Db2 13. The changes are listed in function level order with the highest at the top.

Function level Command Change introduced Incompatible change?
FL 508 -DISPLAY BLOCKERS command (Db2) New options: TABLE, INDEX, SPACENAM, and DDLONLY.  
FL 508 -DISPLAY DATABASE command (Db2) New type values for table spaces in the work file database: WD, WF, WS Yes
FL 506 -DISPLAY TRACE command (Db2) The number of traces that can be active concurrently is increased from 32 to 64. Valid values of integer in the -DISPLAY TRACE option TNO(integer,...) are increased from 1 through 32 to 1 through 64. No
FL 506 -MODIFY TRACE command (Db2) The number of traces that can be active concurrently is increased from 32 to 64. Valid values of integer in the -MODIFY TRACE are increased from 1 through 32 to 1 through 64. No
FL 506 -START TRACE command (Db2) The number of traces and audit policies that can be active concurrently is increased from 32 to 64. No
FL 506 -STOP TRACE command (Db2) The number of traces that can be active concurrently is increased from 32 to 64. Valid values of integer in the -STOP TRACE option TNO(integer,...) are increased from 1 through 32 to 1 through 64. No

FL 505

-START TRACE command (Db2) New DEST option keyword: ZAI No

FL 505

-STOP TRACE command (Db2) New DEST option keyword: ZAI No

FL 505

-DISPLAY TRACE command (Db2) New DEST option keyword: ZAI No
FL 504 -DISPLAY TRACE command (Db2),-START TRACE command (Db2), -STOP TRACE command (Db2) The value of DEST(OPn) can be OP1 through OP16. No

FL 502

BIND PACKAGE subcommand (DSN) New DEPLEVEL option, which determines if the current copy of a package records statement-level dependencies in addition to package-level dependencies. No

FL 502

BIND SERVICE subcommand (DSN) New DEPLEVEL option, which determines if the current copy of a package records statement-level dependencies in addition to package-level dependencies. No

FL 502

REBIND PACKAGE subcommand (DSN) New DEPLEVEL option, which determines if the current copy of a package records statement-level dependencies in addition to package-level dependencies. No
FL 502 -MODIFY DDF command (Db2) New option keywords: RQSTWLB, DFLTWLB for Db2 controlled sysplex workload balancing. No

Command changes in function level 500

The following changes to commands take effect when you activate function level 500 in Db2 13. Activating function level 500 (V13R1M500) prevents coexistence with and fallback to Db2 12. Function level 500 is also the first opportunity for applications to use many of the new capabilities in Db2 13. However, new capabilities that depend on Db2 13 catalog changes remain unavailable.

If an APAR is listed, the described change takes affect when you apply the PTF in each Db2 subsystem or data sharing member.

Command Change introduced Incompatible change?
-ALTER BUFFERPOOL command (Db2) New options: REFPF, VPCLOSET No
BIND PACKAGE(DSN), BIND PLAN(DSN), BIND SERVICE(DSN), REBIND PACKAGE(DSN), REBIND PLAN(DSN) New options: OWNERTYPE(ROLE) or OWNERTYPE(USER) on the OWNER bind option. No
-DISPLAY LOG command (Db2) New option: DETAIL.

The command output in message DSNJ375I is updated to include the cdds-mode value of SOURCE_ONLY.

 No
-SET LOG command (Db2) New option: REMOVELOG. No
-START CDDS command (Db2)

This command originally applied only to a data sharing group that participates in a GDPS® Continuous Availability with zero data loss environment. The command is extended to apply also to a Db2 subsystem in a non-data sharing environment, or to a data sharing group that does not participate in a GDPS Continuous Availability with zero data loss environment.

 No
-STOP CDDS (Db2)

This command originally applied only to a data sharing group that participates in a GDPS Continuous Availability with zero data loss environment. The command is extended to apply also to a Db2 subsystem in a non-data sharing environment, or to a data sharing group that does not participate in a GDPS Continuous Availability with zero data loss environment.

 No

For more information about these changes, see Function level 500 (for migrating to Db2 13 - May 2022).

Command changes in function level 100

The following changes to commands take effect when you migrate to function level 100 in Db2 13. Db2 starts at function level 100 (V13R1M100) during migration to Db2 13, and fallback and coexistence with Db2 12 in data sharing remain possible. Many new capabilities in Db2 13 remain unavailable.

If an APAR is listed, the described change takes affect when you apply the PTF in each Db2 subsystem or data sharing member.

Command Change introduced Incompatible change?
-DISPLAY ACCEL command (Db2)
  • If the DETAIL keyword is specified for multiple accelerators, Db2 13 issues a separate DSNX830I message is issued for each accelerator (PH55472).
 No
-DISPLAY DDF command (Db2)
  • If the DETAIL option is specified, the command output includes the DSNL095I message, which displays information about DBAT processing for connection allocation requests (PH67087).
 No
-DISPLAY DYNQUERYCAPTURE command (Db2)
  • Users with the DISPLAY privilege have authority to issue this command (PH56996, PH56997).
 No
-DISPLAY GROUP command (Db2)
  • New option keyword: UTSCONVERSION (PH67554)
 No
-DISPLAY ML command (Db2)
  • Displays an explanation for SYSTEM ASSESSMENT status (PH66471).
  • This epic introduces a new option for the -DISPLAY ML command to provide Db2ZAI level information in the command output (PH68316).
 No
-DISPLAY OTEL command (Db2) New command (PH67971) No
-DISPLAY PROFILE command (Db2) Users with the DISPLAY privilege have authority to issue this command (PH56996, PH56997). No
-DISPLAY STATS command (Db2)

  • The command output in message DSNT830I is updated such that TRAV. COUNT field returns a calculated traverse count value. (PH51565)

    A new FTB FACTOR field is added to return the calculated value that was previously returned in the TRAV. COUNT field, which can sometimes be negative if when index page-splits occur or index look-aside is used.

    If the output returns information about multiple indexes, descending order is used starting with the index with the highest FTB factor.

 No
FREE PACKAGE subcommand (DSN)

  • This DSN subcommand can be used to free the inactive package copies of native REST services if an option other than ALL is specified for PLANMGMTSCOPE (PH54129).

    Freeing of active packages for native REST services remains blocked with message DSNT264I.

No
-MODIFY DDF command (Db2)
  • The ACCTNG option is supported to specify the granularity of accounting trace records for distributed applications (PH55241). ACCTG(ALLCOMMIT) can be specified for additional granularity or ACCTG can be specified to return to the default behavior.
 No
REBIND PACKAGE subcommand (DSN)

  • The EXPLAIN(ONLY) option is supported for advanced triggers (PH61970).

    When the EXPLAIN(ONLY) option is specified in this DSN subcommand, the PLANMGMT(EXTENDED) and PLANMGMT(BASIC) options allow the OWNER and OWNERTYPE values to be changed.

 No
-START ML command (Db2) New options: SA, REFRESH_SQLOPT_STATIC_SCOPE, and REFRESH_SQLOPT_DYNAMIC_SCOPE (PH66471). No
-START OTEL command (Db2) New command (PH67971) No
-START TRACE command (Db2)
  • IFCID 0369 is added to statistics trace class 1. When -START TRACE (STAT) is issued without the CLASS parameter or with the CLASS(1) parameter, IFCID 0369 is activated by default. For compatibility with previous Db2 releases, statistics class 9, which contains IFCID 0369, is still available.
 No
-STOP ML command (Db2) New option: SA (PH66471). No
-STOP OTEL command (Db2) New command (PH67971) No

For more information about these changes, see Function level 100 (for migrating to Db2 13 - May 2022).