Counting items
Enter COUNT in the Cmd ( C) column of a list panel beside a valid object type.
DNK -R ----------------------- TABLE COUNT LIST ----------------- ROW 1 OF 2
Command ===> Scroll ===> PAGE
02
CMD will show commands for this list. Type command and press ENTER
Lists:
QUALIFIER: TABLESPACE=QCTHS01.QCTS0101
Cmd Table Name Rows
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
QCT.QCTT01_HS01S01 397
QCT.QCTT02_HS01S01 498
****************************** BOTTOM OF DATA *******************************
Command ===> Scroll ===> PAGE
02
CMD will show commands for this list. Type command and press ENTER
Lists:
QUALIFIER: TABLESPACE=QCTHS01.QCTS0101
Cmd Table Name Rows
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
QCT.QCTT01_HS01S01 397
QCT.QCTT02_HS01S01 498
****************************** BOTTOM OF DATA *******************************
Catalog Manager also provides catalog count statistics that show the number of a given object type in the catalog. To display catalog count statistics, enter the CATSTATS command on the Command line of the Primary Menu panel or an object list panel. The Db2 Catalog Counts panel is displayed.
DNK-R --------------------- DB2 Catalog Counts ---------- Row 1 to 21 of 21
Command ===> Scroll ===> PAGE
01
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---
Object Type Row Count
----------- ---------
Alias . . . : 3591
AuxRels . . : 786
Database . . : 541
Datatypes . : 5
Collection . : 0
Columns . . : 79946
DBRM . . . . : 0
Indexes . . : 6777
Package . . : 8007
Plan . . . . : 353
Routines . . : 254
Stogroup . . : 293
Strings . . : 1370
Synonyms . . : 56
Tables . . . : 3932
Tablespace . : 4557
Triggers . . : 150
Userauth . . : 537
Views . . . : 256
******************************* Bottom of data ********************************
Command ===> Scroll ===> PAGE
01
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---
Object Type Row Count
----------- ---------
Alias . . . : 3591
AuxRels . . : 786
Database . . : 541
Datatypes . : 5
Collection . : 0
Columns . . : 79946
DBRM . . . . : 0
Indexes . . : 6777
Package . . : 8007
Plan . . . . : 353
Routines . . : 254
Stogroup . . : 293
Strings . . : 1370
Synonyms . . : 56
Tables . . . : 3932
Tablespace . : 4557
Triggers . . : 150
Userauth . . : 537
Views . . . : 256
******************************* Bottom of data ********************************
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*