need help for db2 tuning at beginner..
- Dieses Thema hat 1 Antwort und 1 Teilnehmer, und wurde zuletzt aktualisiert vor 19 Jahren, 1 Monat von Anonym.
3. November 2004 um 13:32 Uhr #2472
I installed DB2 V7.2 on Linux 7.3 and create 2 databases.
As of now my database is performing very slow. Sql query took time to load.
database size and user access is almost growing regularly.
I have planning to tune my database using performance and tuning.
But I am very beginner in database performance and tuning.
I don’t know which parameter need to set for tuning and which existing parameters need to take screeshot to get idea.
Can anybody guide me about performance tuning atleast begineer level. If u have any docs or links pls. send me.
Your help will be appreciate me.
3. November 2004 um 15:50 Uhr #2940
first look at your bufferpool size. The standard is 4 MB (1000 blocks) for each database. Depending on your needs and your memory size you should enlarge it to a reasonable size. Use control center to do this.
Later, it makes sense to separate data an indexes into different bufferpools. Read the manual, how to do this (you need new bufferpools, tablespaces related to the bufferpools and table definitions with an index clause).
Use design wizard for tuning all the other parameters, but have a careful look on the proposed changes!
You must be logged in to reply to this topic.