Command changes in Db2 11

Use this information to plan for changes to commands in Db2 11.

New commands in Db2 11

Begin general-use programming interface information.

Table 1. New commands
Command Description
BIND SERVICE (DSN) The BIND SERVICE subcommand builds an application package that represents a Db2 REST service.
-DISPLAY BLOCKERS (Db2) The DISPLAY BLOCKERS command displays locks and claims that active threads hold against specified databases.
FREE SERVICE (DSN) The FREE SERVICE subcommand deletes an application package that represents a Db2 REST service.
-START CDDS (Db2) The START CDDS command directs all members of a data sharing group to allocate and open the compression dictionary data set (CDDS).
-STOP CDDS (Db2) The STOP CDDS command directs all members of a data sharing group to close and deallocate the CDDS.
-DISPLAY RESTSVC (Db2) The DISPLAY RESTSVC command displays the status of REST services that exist in Db2.
-START RESTSVC (Db2) The START RESTSVC command activates the definition of a REST service that is stopped.
-STOP RESTSVC (Db2) The STOP RESTSVC command prevents Db2 from accepting any new discover details or invoke requests for one or more REST services. .

Changed commands in Db2 11

The following table shows the existing commands that have new and changed options. For information about an option with a changed default value, see Command release incompatibilities.

Begin general-use programming interface information.

Table 2. Changes to existing commands
Command Description of enhancements and notes
-ACCESS DATABASE (Db2) Additional option values:
  • MODE (STATS)
-ALTER BUFFERPOOL (Db2) Additional options:
  • FRAMESIZE(4K|1M|2G)
  • SPSIZE(integer)
  • SPSEQT(integer)
  • VPSIZEMAX(*|integer)
  • VPSIZEMIN(*|integer)
PGFIX and FRAMESIZE at migration: Buffer pools that are set to PGFIX(YES) during migration to Db2 11 can use FRAMESIZE(1M) by default in Db2 11. However, buffer pools that are set to PGFIX(NO) during migration use 4 KB frames in Db2 11 even if altered to PGFIX(YES), unless you explicitly specify a different FRAMESIZE value.
-ALTER GROUPBUFFERPOOL (Db2) Additional option values:
  • CLASST(class-threshold1,class-threshold2)
BIND PACKAGE and REBIND PACKAGE: Additional options:
  • APPLCOMPAT
  • APREUSE(WARN)
  • ARCHIVESENSITIVE(YES|NO)
  • BUSTIMESENSITIVE(YES|NO)
  • DBPROTOCOL(DRDACBF)
  • DESCSTAT(NO|YES)
  • SYSTIMESENSITIVE(YES|NO)
BIND PACKAGE: The following option values can be delimited. If they are delimited, they can contain mixed-case characters.
  • collection-id
  • dbrm-member-name
  • dbrm-library-name
  • package-id
BIND PLAN and REBIND PLAN: Additional options:
  • PROGAUTH(DISABLE|ENABLE)
REBIND TRIGGER PACKAGE: Additional options:
  • APPLCOMPAT
  • ARCHIVESENSITIVE(YES|NO)
  • BUSTIMESENSITIVE(YES|NO)
  • SYSTIMESENSITIVE(YES|NO)
-START DB2 (Db2) Additional options:
  • LIGHT(CASTOUT)
-START PROFILE If the PROFILE_AUTOSTART subsystem parameter value is YES, this command is issued automatically when you start Db2.

End general-use programming interface information.