Db2 commands supported by CLPPlus
The CLPPlus interface supports a subset of Db2 commands for database and database manager administration, tuning, and maintenance.
The following
Db2 commands are supported in the CLPPlus interface:
- GET DATABASE CONFIGURATION
- GET DATABASE MANAGER CONFIGURATION
- UPDATE DATABASE CONFIGURATION
- UPDATE DATABASE MANAGER CONFIGURATION
- RESET DATABASE CONFIGURATION
- RESET DATABASE MANAGER CONFIGURATION
- LIST PACKAGES
- IMPORT
- EXPORT
- LOAD
- REORG, supported when connected to Db2 and Db2 for z/OS®.
- RUNSTATS, supported when connected to Db2 and Db2 for z/OS.
- REORGCHK, for more information see the related reference.
- Limited support for CREATE DATABASE, also supported when connected to IBM® Informix®. For more information about restrictions see the related reference.
- DROP DATABASE, also supported when connected to IBM Informix.
Note: For Db2, the
CREATE DATABASE and DROP DATABASE commands fail if connected
to a remote database manager instance. You must be connected to a local database manager
instance
Note: IMPORT, EXPORT and LOAD commands have a restriction that processed files must
be on the server