need help for db2 tuning at beginner..

Ansicht von 2 Beiträgen - 1 bis 2 (von insgesamt 2)
  • Author
    Posts
  • 3. November 2004 um 13:32 Uhr #2472

    Anonym
    Gast

    Hello

    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.

    Regards
    Uday

    3. November 2004 um 15:50 Uhr #2940

    Anonym
    Inaktiv

    Hi Uday,

    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!

    Regards,

    AxelP

  • Author
    Posts
Ansicht von 2 Beiträgen - 1 bis 2 (von insgesamt 2)

You must be logged in to reply to this topic.