Wise-GUYTM Tables Snapshot for TLCS

HTML Prepared: Mon Oct 7 12:39:10 EDT 2002, Auto-Refresh=60 Seconds
Server: jaxssund1, Node: 0
Snapshot Number: 19 Wise-GUY temporary license license expires on TR 20021010
Approximate Interval: 300 seconds

Most frequently READ tables

Schema
Name
Table
Name
Rows
Read
Rows
Read/TX
Rows
Read/Min
Rows
Written
Rows
Written/TX
Rows
Written/Min
Page
Overflows
Page
Reorgs
Page Reorgs
as % of Written
SYSMDB2 DMSN 383700 548 4311 0 0 0 0 0 0 %
SYSMDB2 DLR_HIER 284400 406 3195 0 0 0 0 0 0 %
SYSMDB2 DEAL_BCKT 83250 119 935 0 0 0 0 0 0 %
SYSMDB2 DEAL_PROD 72150 103 810 0 0 0 0 0 0 %
SYSMDB2 PRMV_DMSN_VAL 71250 101 800 0 0 0 0 0 0 %
SYSMDB2 STD_BCKT_PROD 70500 100 792 0 0 0 0 0 0 %
SYSMDB2 DEAL_OWNR 57450 82 645 0 0 0 0 0 0 %
SYSMDB2 DEAL_PROD_VAR 29400 42 330 0 0 0 0 0 0 %
SYSMDB2 PROD_DMSN 26850 38 301 0 0 0 0 0 0 %
SYSMDB2 PROD_ADON 22950 32 257 0 0 0 0 0 0 %
SYSMDB2 DMSN_CPNT 21150 30 237 0 0 0 0 0 0 %
SYSMDB2 DEAL_ADON 19800 28 222 0 0 0 0 0 0 %
SYSMDB2 BCKT 9150 13 102 0 0 0 0 0 0 %
SYSMDB2 ACCT_BCKT 7200 10 80 0 0 0 0 0 0 %
SYSMDB2 RULE_DMSN_CPNT 5716 8 64 0 0 0 0 0 0 %
SYSMDB2 PRCG_STAT_TYPE 3900 5 43 0 0 0 0 0 0 %
SYSMDB2 RULE 2870 4 32 0 0 0 0 0 0 %
SYSMDB2 OWNR_GRP 1650 2 18 0 0 0 0 0 0 %
SYSMDB2 RULE_ENTRY 1557 2 17 0 0 0 0 0 0 %
SYSMDB2 PRCG_VAR_TYPE 1500 2 16 0 0 0 0 0 0 %
SYSMDB2 CSTM_DMSN_TYPE 1350 1 15 0 0 0 0 0 0 %
SYSMDB2 BCKT_TYPE 1200 1 13 0 0 0 0 0 0 %
SYSMDB2 PRCG_PROD 900 1 10 0 0 0 0 0 0 %
SYSMDB2 CSTM_DMSN 900 1 10 0 0 0 0 0 0 %
SYSMDB2 DMSN_TYPE 750 1 8 0 0 0 0 0 0 %
SYSMDB2 DLR_ACCT_T 750 1 8 0 0 0 0 0 0 %
SYSMDB2 DLR_ACCT_SELLNG_T 750 1 8 0 0 0 0 0 0 %
SYSMDB2 PRMV_VAL_TYPE 450 0 5 0 0 0 0 0 0 %
SYSMDB2 PRMV_SRCE_TYPE 450 0 5 0 0 0 0 0 0 %
SYSMDB2 PRMV_DMSN 450 0 5 0 0 0 0 0 0 %
SYSMDB2 RULE_ROW 273 0 3 0 0 0 0 0 0 %
SYSIBM INTERNAL 158 0 1 0 0 0 0 0 0 %
SYSMDB2 TLC_FORM_T 150 0 1 0 0 0 0 0 0 %
SYSMDB2 TLC_FORM_INSR_T 150 0 1 0 0 0 0 0 0 %
SYSMDB2 PROD_FORM_TERM 150 0 1 0 0 0 0 0 0 %
SYSMDB2 PROD_FORM 150 0 1 0 0 0 0 0 0 %
SYSIBM INTERNAL 62 0 0 0 0 0 0 0 0 %
SYSIBM SYSTABLES 47 0 0 0 0 0 5 0 0 %
SYSIBM SYSDBAUTH 28 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 5 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 5 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 5 0 0 0 0 0 0 0 0 %
SYSIBM SYSFUNCTIONS 4 0 0 0 0 0 0 0 0 %
SYSIBM SYSEVENTMONITORS 4 0 0 1 0 0 0 0 0 %
SYSIBM INTERNAL 3 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 3 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 3 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 3 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 3 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 2 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 2 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 2 0 0 0 0 0 0 0 0 %
SYSIBM SYSPLAN 1 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 1 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 1 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 1 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 1 0 0 0 0 0 0 0 0 %
SYSIBM INTERNAL 1 0 0 0 0 0 0 0 0 %
SYSIBM SYSEVENTS 0 0 0 1 0 0 0 0 0 %


Key Links

Database-Guys.  |  International DB2 Users Group  |  IBM DB2 Home


Copyright © 2002 Database-Guys. Spencerport, New York, 14559 USA. All Rights Reserved.