DB2

Automic recommends keeping the following notes in mind when installing and operating DB2 in order to achieve top performance.

It is important to reorganize the AE database including all clients on a regular basis. An extensive database affects performance negatively (prolonged access times etc.).

Notes

Table

Approximate size in percent

RT

40% - 60%

AH

20% - 30%

ABLOB ~ 19%

MELD

10% - 20%

AJPP

5%

RH

5%

Other tables

< 1%

 

See also:

Setting Up Database - DB2
Technical Maintenance of the AE database

Maintaining Data Records