dbamdevinfo
Purpose
Displays information about the capacity of the logical and the attribute index specific devices of the database.
Options
-V
-
Displays the DirX Directory product version, in the format:
product_version build_id date time
For example:
DirX Directory V9.0 9.4.428 2023:03:23 20:10 64-Bit
-v
-
Enables verbose output.
Description
Specified without any options the dbamdevinfo command displays information on how much of the reserved space is in use on each logical device and on each attribute index specific device of the database. It also displays the fragmentation ratio of each logical device. The fragmentation is reported in percent and indicates the chance to run into allocation problems for the largest possible block in the specific logical device. A value of 0% is the best case and means no fragmentation at all. That is, the complete remaining free space can be allocated for the largest possible block size. A value of 100% is the worst case and means total fragmentation. That is, within the remaining free space no block with the largest possible size can be allocated at all. Since REAL and AVIDX devices always work with blocks of the same size the fragmentation of these devices is always 0%. If a logical device has a high fragmentation level of 50% or higher proceed as described in the dirxadm db purge operation.
If you are building up your database you should enhance the devices if they start to use 80 % through 90 %. (See section titled Extending the Directory Database in the DirX Directory Disc Dimensioning Guide for details.)
While the dbamdevinfo command is in progress the database is set to READONLYWAIT mode.
It is not possible to perform the dbamdevinfo command while restoring a database.
Examples
dbamdevinfo
The sample output is as follows:
DSA profile: profile, ID=1
Real object block size: 4 KB
AVIDX cluster size: 32 MB
Maximum number of indices: 880
Logical device: GENERAL | BITSTR | PSEUDO | TREE
In use: 4.96 % (711.606 MB of 13.997 GB)
Fragmentation: 3.19 %
Logical device: REAL
In use: 11.98 % ( 3.355 GB of 27.998 GB)
Fragmentation: 0.00 %
Logical device: AVIDX
In use: 13.64 % ( 3.819 GB of 28.000 GB)
Fragmentation: 0.00 %
Attribute index specific device info:
Attr id LDAP name Index type Size
0 objectClass INITIAL 0.266 MB ( 1 cluster)
0 objectClass PRESENT 0.844 MB ( 1 cluster)
...
Number of indices: 106 (maximum 880)
Cluster usage: 25.36 % (227 of 895)
In the sample output the administrator can see that there are enough disc space, index entries and clusters available. If for example the use of one or more logical devices tend towards 100 % the administrator should take into consideration to enhance the database. In section titled Extending the Directory Database in the Dirx Disc Dimensioning Guide he finds details how to perform this process.