Counting items
The COUNT command is valid with table spaces, tables, views, aliases, and synonyms. It displays the number of rows in the source objects.
Enter COUNT in the Cmd ( C) column of a list panel beside a valid object type.
DEFF-R ----------------------- TABLE COUNT LIST ----------------- ROW 1 OF 7
Command ===> Scroll ===> CSR
02
CMD will show commands for this list. Type command and press ENTER
Lists:
QUALIFIER: TABLESPACE=QZUDRR.QZUS34RR
Cmd Table Name Rows
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
QZU.QZUT01_DRRS34 5000
QZU.QZUT02_DRRS34 5000
QZU.QZUT03_DRRS34 5000
QZU.QZUT04_DRRS34 5000
QZU.QZUT05_DRRS34 5000
QZU.QZUT06_DRRS34 5000
QZU.QZUT07_DRRS34 5000
****************************** BOTTOM OF DATA *******************************
Command ===> Scroll ===> CSR
02
CMD will show commands for this list. Type command and press ENTER
Lists:
QUALIFIER: TABLESPACE=QZUDRR.QZUS34RR
Cmd Table Name Rows
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
QZU.QZUT01_DRRS34 5000
QZU.QZUT02_DRRS34 5000
QZU.QZUT03_DRRS34 5000
QZU.QZUT04_DRRS34 5000
QZU.QZUT05_DRRS34 5000
QZU.QZUT06_DRRS34 5000
QZU.QZUT07_DRRS34 5000
****************************** 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.
DEFF-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 . . . : 538
AuxRels . . : 11809
Database . . : 3124
Datatypes . : 855
Collection . : 993
Columns . . : 720625
DBRM . . . . : 4962
Indexes . . : 53465
Package . . : 38042
Plan . . . . : 2939
Routines . . : 2920
Stogroup . . : 542
Strings . . : 1380
Synonyms . . : 11670
Tables . . . : 49249
Tablespace . : 34884
Triggers . . : 602
Userauth . . : 1364
Views . . . : 8789
******************************* 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 . . . : 538
AuxRels . . : 11809
Database . . : 3124
Datatypes . : 855
Collection . : 993
Columns . . : 720625
DBRM . . . . : 4962
Indexes . . : 53465
Package . . : 38042
Plan . . . . : 2939
Routines . . : 2920
Stogroup . . : 542
Strings . . : 1380
Synonyms . . : 11670
Tables . . . : 49249
Tablespace . : 34884
Triggers . . : 602
Userauth . . : 1364
Views . . . : 8789
******************************* Bottom of data ********************************
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*