Deleted server commands, utilities, and options

Some commands, utilities, and options are deleted because their function is no longer needed. In some cases, new commands replace deleted commands.

Deleted commands

Table 1. Deleted commands
Deleted command Comments
CONVERT ARCHIVE The operation that this command performed is no longer needed.

DEFINE DBBACKUPTRIGGER
DELETE DBBACKUPTRIGGER
QUERY DBBACKUPTRIGGER
UPDATE DBBACKUPTRIGGER

 Ensure that you schedule backups of the database to occur at least once per day.
DEFINE DBCOPY Database volumes are no longer used.

DEFINE DBVOLUME
QUERY DBVOLUME

 Space allocation is done automatically in the directory locations specified for the database.
DEFINE LOGCOPY Instead of log volume copies, you can specify a log mirror to have the active log protected by a mirror copy.

DEFINE LOGVOLUME
DELETE LOGVOLUME
QUERY LOGVOLUME

 The database manager automatically manages space in the recovery log directories.

For information about the directories that are used for the logs, use the QUERY LOG command.
ESTIMATE DBREORGSTATS Collecting and resetting database statistics occurs automatically.

Database-reorganization operations are done automatically by the database manager as needed.
EXTEND DB Space allocation is done automatically in the directory locations specified for the database. If the server needs additional space, you can add directory locations by using the EXTEND DBSPACE command.
EXTEND LOG Server options are available for increasing the size of recovery logs.
QUERY SQLSESSION The information that this command supplied is no longer in the server database. SQL SELECT settings are replaced by syntax options that are available in a DB2® SELECT command.
REDUCE DB Space allocation is done automatically in the directory locations specified for the database. You cannot adjust the assigned capacity of the database.
REDUCE LOG The database manager automatically manages space in the recovery log directories.
RESET BUFPOOL The BUFPOOLSIZE option is eliminated; therefore, this command is not needed.

RESET DBMAXUTILIZATION
RESET LOGCONSUMPTION
RESET LOGMAXUTILIZATION

 Collecting and resetting database statistics occurs automatically.
SET LOGMODE Logging mode for the database is now always roll-forward mode.

SET SQLDATETIMEFORMAT
SET SQLDISPLAYMODE
SET SQLMATHMODE

 The commands are replaced by options in the DB2 SELECT command syntax.
UNDO ARCHCONVERSION The operation that this command performed is no longer needed.
UPDATE ARCHIVE The operation that this command performed is no longer needed.

Deleted utilities

Table 2. Deleted utilities
Deleted utility Comments
DSMFMT Space allocation is done automatically in the directory locations specified for the database.
DSMSERV AUDITDB Offline database audits are no longer required.

As data is added to the server database, the database manager automatically checks data constraints and data types. The online integrity checks prevent problems for which offline audits were required in earlier releases.
DSMSERV DISPLAY DBBACKUPVOLUME Information about volumes used for database backup is available from the volume history file. The volume history file is now required to restore the database.
DSMSERV DISPLAY DBVOLUMES Use DSMSERV DISPLAY DBSPACE to view information about database space when the server is not running.
DSMSERV DISPLAY LOGVOLUMES Use DSMSERV DISPLAY LOG to display information about recovery logs including the active log, the mirror for the active log, the failover directory for the archive log, and the overflow location for logs.
DSMSERV DUMPDB The operation that this utility performed is no longer needed.
DSMSERV EXTEND LOG This utility is replaced by the following server options:
  • ACTIVELOGSIZE
  • ACTIVELOGDIRECTORY
  • MIRRORLOGDIRECTORY
With these options, you can add recovery log space if the log is full when the server is down.
DSMSERV LOADDB The operation that this utility performed is no longer needed.
DSMSERV RESTORE DB
  • Restore a single database volume to its most current state
  • Restore a database to a point in time when a volume history file is unavailable
 The server does not track individual database volumes in V7.1.1.

The volume history file is required to perform database restore operations.
DSMSERV UNLOADDB The operation that this utility performed is no longer needed.

Deleted server options

When you start the server, you might receive warning messages about server options that are not supported, but that cannot be found in this list of deleted options. V5 releases tolerated the presence of some server options that were not supported by the server. The V7.1.1 server flags such options by issuing warning messages. You can ignore the error, or update the server options file and restart the server.

Table 3. Deleted server options
Deleted option Comments
BUFPOOLSIZE The server adjusts the value of buffer pool size dynamically.
DBPAGESHADOW The option is no longer needed.
DBPAGESHADOWFILE The option is no longer needed.
LOGPOOLSIZE The server uses its own fixed-size recovery log buffer pool.
LOGWARNFULLPERCENT The option is no longer needed.

MIRRORREAD
MIRRORWRITE

 Mirroring of the active log is supported, but not of the database. Provide availability protection for the database by locating the database on devices that have high availability characteristics.
SELFTUNEBUFPOOLSIZE The server adjusts the buffer pool size dynamically.