@botname db2
This command is used to operate on Db2
to show the status or buffer
pools.
Syntax
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.