ibmdu - IBM DB2 Disk Usage
ibmdu [csw] [nx]bx [-u DBloginname] [-p password] dataarea [tablespace ...]
(online mode)
ibmdu o[sw] [nx]bx
dataarea [tablespace ...]
(offline mode)
This utility provides an estimate (plus or minus ten percent) of the amount of disk space required for the table and index data in a given data area. Used during initial setup or when migrating from another database.
In online mode, the utility:
-
Checks the IBM DB2 database to determine how much space you have available in your table space.
-
Reads the Lawson dictionary to find the initial and incremental record counts for each table and index listed in the dictionary. From the record counts and row sizes, the utility estimates the actual physical size required.
| Program Option | Description |
|---|---|
c
|
Show information about the existing table spaces. (Online mode only.) |
o
|
Run in offline mode. |
s
|
Show table space summary. |
w
|
Show detailed warning messages for tables and indexes. |
nx
|
Use a record count of
x
.
|
bx
|
Use a block size of x KB. This must be the last specified option in the command line. |
u
DBloginname
|
The database user as specified in the database configuration file. |
p
password
|
The password for the database user. |