DESCRIBE command
Related topics
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.)
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
Command ===> Scroll ===> PAGE
Table = QCT.QCTTSTAFF
------------------------------------------------------------------------------
FROM SYSIBM.SYSTABLES
------------------------------------------------------------------------------
Creator. . . . . QCT Type . . . . . . T
Table Name . . . QCTTSTAFF Status . . . . . X
Database . . . . QCTDBSTF Checkflag. . . .
Tablespace . . . QCTSTAFF Checkrid . . . . X'40404040'
Editproc . . . . Validproc. . . .
Audit. . . . . . Parents. . . . . 0
Pctpages . . . . 1 Children . . . . 0
Colcount . . . . 3 DBID . . . . . . 304
Record Length. . 89 OBID . . . . . . 3
Key Columns. . . 1 Key OBID . . . . 4
Createdby. . . . MVSJXL3 Label. . . . . .
Remarks. . . . . Createdts. . . . ..-05-11.31.07.165938
Alteredts. . . . ..-05-11.31.07.165938 Datacapture. . .
Rba1 . . . . . . ..A8017996ED53800' Rba2 . . . . . . ..A8017996ED53800'
Pctrowcomp . . . 0 Statstime. . . . ..-05-11.31.10.304024
Clustertype. . . IBM reqd . . . . H
Checks . . . . . 0 Cardf. . . . . . 7
Checkrid5b . . . X'4040404040' Encoding scheme. E
Tbcreator. . . . Tbname . . . . .
Npagesf. . . . . 1 Spacef . . . . . 240
Avgrowlen. . . . 87 Relcreated . . . Q
Tablestatus. . . Number dep MQTs. 0
Version. . . . . 0 Partkeycolnum. . 0
Split Rows . . . Security Label .
Owner. . . . . . QCT Append . . . . . N
Ownertype. . . . VersionSchema. .
VersionTable . . Hashkeycolumns . 0
------------------------------------------------------------------------------
TABLE CONSTRAINTS
Constraint Name Type Enforcing Index Creator Colcount
QCTSTAFF_PK P QCT.QCTIXSTAFF MVSJXL3 1
------------------------------------------------------------------------------
TABLE INDEXES
Index Name Clus PgSz Uniq Rule Key Column Col# Key Ord
seq
QCT.QCTIXSTAFF N 4 PRI KEY
NAME 1 1 Asc
------------------------------------------------------------------------------
TABLE COLUMNS
Num Column Name Coltype Length Nl Up Pkey Dfl Bit Length2
1 NAME CHAR 25 N Y 1 Y S
2 JOB CHAR 50 N Y Y S
3 SALARY DECIMAL 10,5 N Y Y
Row length - maximum 89 - minimum 89 including eight byte header
------------------------------------------------------------------------------
--------------------------- END OF DATA ---------------------------