DESCRIBE command - Documentation for BMC AMI Catalog Manager for Db2 12.1

To generate a detailed description of a list object, type DESCRIBE in the Cmd column next to the source object.

The DESCRIBE command displays detailed information that is stored in the Db2 catalog about a specific object, including structure and dependencies. Describe Table panel generated from DESCRIBE command shows a sample report that is displayed when the DESCRIBE command is applied to a table. Information in the report is dependent upon the source object type. You can specify your options for displaying the report for plans and packages on the Describe Options panel. (For more information, see Setting DESCRIBE options.)

Note

DESCRIBE TRIGGER is not supported.

Note

In the Describe Database panel, Catalog Manager displays the number of partitions and the segment size for a table space in the ObjInfo column.

The DESCRIBE command also displays detailed information about Catalog Manager log entries for the Audit, Session, and Drop Recovery Logs.

Describe Table panel generated from DESCRIBE command

 Table: QZU.QZUT01_DEBS01 Line 1 of 53 Col 1 80
Command ===> Scroll ===> PAGE
Table = QZU.QZUT01_DEBS01
------------------------------------------------------------------------------
FROM SYSIBM.SYSTABLES
------------------------------------------------------------------------------
Creator. . . . . QZU Type . . . . . . T
Table Name . . . QZUT01_DEBS01 Status . . . . . X
Database . . . . QZUDEB Checkflag. . . .
Tablespace . . . QZUS01EB Checkrid . . . . X'40404040'
Editproc . . . . Validproc. . . .
Audit. . . . . . Parents. . . . . 0
Pctpages . . . . 75 Children . . . . 0
Colcount . . . . 12 DBID . . . . . . 1204
Record Length. . 86 OBID . . . . . . 3
Key Columns. . . 5 Key OBID . . . . 6
Createdby. . . . RDABKH1 Label. . . . . .
Remarks. . . . . Createdts. . . . ..-06-10.40.20.849236
Alteredts. . . . ..-06-10.40.20.849236 Datacapture. . .
Rba1 . . . . . . X'006009FB9000' Rba2 . . . . . . X'006009FB9000'
Pctrowcomp . . . 70 Statstime. . . . ..-07-09.12.32.710646
Orphan . . . . . Clustertype. . .
IBM reqd . . . . I Checks . . . . . 0
Viewdeps . . . . Cardf. . . . . . 988013
Checkrid5b . . . X'4040404040' Encoding scheme. E
Tbcreator. . . . Tbname . . . . .
Npagesf. . . . . 14768 Spacef . . . . . 79920
Avgrowlen. . . . 60 Relcreated . . . O
Tablestatus. . . Number dep MQTs. 0
Version. . . . . 0 Partkeycolnum. . 0
Split Rows . . . Security Label .
Owner. . . . . . QZU Append . . . . . N
Ownertype. . . .
------------------------------------------------------------------------------
TABLE CONSTRAINTS
Constraint Name Type Enforcing Index Creator Colcount
DATE P QZU.QZUX02_DEBS01T01 RDABKH1 5
------------------------------------------------------------------------------
TABLE COLUMNS
Num Column Name Coltype Length Nl Up Pkey Dfl Bit Length2
1 DATE DATE 4 N Y 1 N
2 AUTHID CHAR 8 N Y 2 N S
3 TBCREATOR CHAR 8 N Y 3 N S
4 TBNAME CHAR 18 N Y 4 N S
5 PLAN CHAR 8 N Y 5 N S
6 LAST_MNT_DATE_TIME TIMESTMP 10 N Y N
7 NTRANS INTEGER 4 N Y N
8 INSERTS INTEGER 4 N Y N
9 UPDATES INTEGER 4 N Y N
10 DELETES INTEGER 4 N Y N
11 MIN_TIME TIME 3 N Y N
12 MAX_TIME TIME 3 N Y N Row length - maximum 86 - minimum 86 including eight byte header
------------------------------------------------------------------------------ --------------------------- END OF DATA ---------------------------

Related topic