Warehouse DB maintenance

Technote (FAQ)


Question

What tasks should we have to perform in order to maintain our Datawarehouse DB on DB2 ?

Cause

The S&P agent only remove Data of tables without performing an allocation of the space released. Therefore a reorganisation of data in tables and indexes needs be performed.

Answer

A. we can schedule the reorg automatically as it is indicated in the url:

http://www.ibm.com/developerworks/data/library/techarticle/dm-0707tang/

B. we can do it manually running the commands:

1. db2 connect to warehous user <user> using <password>

2. db2 reorgchk on table all (the output will tell us what tables are asking for a reorg)

then for each of these tables we are going to run:

3. db2 reorg table <schema>.<table_name>

4. db2 reorg indexes all for table <schema>.<table_name>

5. db2 runstats on table <table> with distribution and detailed indexes all db2 terminate


Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Monitoring All Platforms 6.2.1, 6.2, 6.1, 6.2.2

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Data Warehouse

Software version:

1.1.1

Operating system(s):

AIX, Windows

Reference #:

1586550

Modified date:

2013-03-07

Translate my page

Machine Translation

Content navigation