Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Delete Statistics
- Thread starter nukular
- Start date
Hi Lucas,
No you can't "reset" statistics.
You can "UPDATE" statistics such as:
UPDATE SYSSTAT.TABLES
SET CARD = -1
NPAGES = -1
FPAGES = -1
OVERFLOW = -1
WHERE TABSCHEMA = 'xxx'
AND TABNAME = 'yyy'
If you have DB2 for Win-Unix installed on a PC, go to the HELP -> INFORMATION Center to access almost all of DB2 for Win-Unix reference materials.
Larry Kintisch
IBM Contractor Instructor for DB2, SQl, QMF, Data modeling; [DB2 for z/OS]
No you can't "reset" statistics.
You can "UPDATE" statistics such as:
UPDATE SYSSTAT.TABLES
SET CARD = -1
NPAGES = -1
FPAGES = -1
OVERFLOW = -1
WHERE TABSCHEMA = 'xxx'
AND TABNAME = 'yyy'
If you have DB2 for Win-Unix installed on a PC, go to the HELP -> INFORMATION Center to access almost all of DB2 for Win-Unix reference materials.
Larry Kintisch
IBM Contractor Instructor for DB2, SQl, QMF, Data modeling; [DB2 for z/OS]
- Status