@botname db2

This command is used to operate on Db2 to show the status or buffer pools.

Syntax

Read syntax diagramSkip visual syntax diagram@ botnamedb2liststatusdb2_idbuffer-poolbppool_id--db2-id--didb2_id--smf-id--sismf_id--limitnumber--json-format--jf

Usage

list
Shows Db2® status or buffer pools. If you do not specify any action, this action is the default action.
status
Shows the status or details of Db2. If you do not specify any object, this object is the default object. To narrow down returned results, you can specify the following positional argument.
db2_id
This argument is OPTIONAL. It specifies the ID of the target Db2 that you want to show. Wildcard character * is supported.
buffer-pool|bp
Shows the buffer pools on Db2. To narrow down returned results, you can specify the following positional argument.
pool_id
This argument is OPTIONAL. It specifies the ID of the target pool that you want to show. Wildcard character * is supported.
You can also specify the following option.
--db2-id|--di db2_id
This option is REQUIRED. It specifies the Db2 ID of target resource to narrow down the result.
--smf-id|si smf_id
This option is REQUIRED. It specifies the SMF ID of target resource to narrow down the result.

Examples

@bnz db2
Shows the status of Db2.
@bnz db2 list
Shows the status of Db2.
@bnz db2 list status
Shows the status of Db2.
@bnz db2 list status DSNT
Shows the status of the Db2 whose ID is DSNT.
@bnz db2 list status DSNT --jf
Shows the status of the Db2 whose ID is DSNT in JSON format.
@bnz db2 list status D*T
Shows the status of the Db2 whose ID starts with D and ends with T.
@bnz db2 list buffer-pool --db2-id DSNT --smf-id MVST
Shows all the buffer pools on the Db2 whose ID is DSNT on the system node MVST.
@bnz db2 list bp BP32K --di DSNT --si MVST
Shows the buffer pool whose ID is BP32K on the Db2 whose ID is DSNT on the system node MVST.
@bnz db2 list bp BP32K --di DSNT --si MVST --jf
Shows the buffer pool whose ID is BP32K on the Db2 whose ID is DSNT on the system node MVST in JSON format.
@bnz db2 list bp BP32* --di DSNT --si MVST
Shows the buffer pool whose ID starts with BP32 on the Db2 whose ID is DSNT on the system node MVST.