How to shrink DB2E tables DSY.SYNC_STATS and DSY.SYNC_SUBS_STATS

Technote (FAQ)


Question

How can I shrink the size of DSY.SYNC_STATS and DSY.SYNC_SUBS_STATS tables used by DB2E (DB2 Everyplace)?

Cause

The size of the DB2 Everyplace (DB2E) tables DSY.SYNC_STATS and DSY.SYNC_SUBS_STATS can grown quite large over time. There is not a scheduled task which will automatically prune the client sync statistics tables.

Answer

There is not a scheduled task to automatically prune the client sync statistics tables. Therefore, you must delete/move outdated data from the tables according to your business needs.

The following links show the table structures, etc. Once you know what the data is, you can decide how to prune the tables manually.

Client synchronization statistics table structures
http://publib.boulder.ibm.com/infocenter/db2e/v9r1f1/index.jsp?topic=/com.ibm.db2e.doc/sag/sync_stats_tables.htm

Querying client synchronization information tables
http://publib.boulder.ibm.com/infocenter/db2e/v9r1f1/index.jsp?topic=/com.ibm.db2e.doc/sag/sync_stats_query.htm

If you want to keep the current sync data, you could create a query which deletes the records older than <timestamp> (you would have to pick a time stamp).

For example:

Connect to DSYCSTAT

Delete from DSY.SYNC_STATS where SERVERTS < '2012-05-15 12:00:00.000'

This would delete things older than noon on the 15th of May, 2012

If you do not care about the information in these tables, there is no reason why you could not clear the contents of these tables.

However, do not drop the tables, as they are needed.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 Everyplace
General Issues

Software version:

9.1.0, 9.1.1, 9.1.2, 9.1.3, 9.1.4, 9.1.5

Operating system(s):

AIX, Linux, Windows

Software edition:

Edition Independent

Reference #:

1594861

Modified date:

2012-06-25

Translate my page

Machine Translation

Content navigation