Command changes in Db2 11
Use this information to plan for changes to commands in Db2 11.
New commands in Db2 11
| 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.
| Command | Description of enhancements and notes |
|---|---|
| -ACCESS DATABASE (Db2) | Additional option
values:
|
| -ALTER BUFFERPOOL (Db2) | Additional
options:
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:
|
| BIND PACKAGE and REBIND PACKAGE: | Additional
options:
|
| BIND PACKAGE: | The following option values can be delimited. If they are delimited, they
can contain mixed-case characters.
|
| BIND PLAN and REBIND PLAN: | Additional options:
|
| REBIND TRIGGER PACKAGE: | Additional
options:
|
| -START DB2 (Db2) | Additional options:
|
| -START PROFILE | If the PROFILE_AUTOSTART subsystem parameter value is YES, this command is issued automatically when you start Db2. |