Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2017
    Posts
    3

    Answered: Database parameters

    Hi. Sorry, i'm new in db2. I can't find answer for next question. what parameters in databases needs tuning for small or large databases. for size 10gb, 30gb and 68gb.

  2. Best Answer
    Posted by schor

    "I would agree that all those sizes of database are very small. What type of workload are you running? Did you run the configuration advisor?

    db2 is mostly self tuning and can get you very good performance once you run the config advisor."


  3. #2
    Join Date
    Oct 2007
    Posts
    153
    Provided Answers: 9
    will take a lot more room than this page to discuss. If you have more specific questions we can help more. Also, you should provide what platform you are running on and version/level of your DB.

    As a side note and should help you those sizes are all very small databases. Most of us have single tables that are many times larger. One of the systems I'm supporting right now is at 2TB.

  4. #3
    Join Date
    Jun 2017
    Posts
    3
    thanks a lot.your sarcasm is great
    Last edited by freedom12; 06-07-17 at 09:21.

  5. #4
    Join Date
    Jun 2017
    Posts
    9
    Provided Answers: 1
    I would agree that all those sizes of database are very small. What type of workload are you running? Did you run the configuration advisor?

    db2 is mostly self tuning and can get you very good performance once you run the config advisor.

  6. #5
    Join Date
    Oct 2007
    Posts
    153
    Provided Answers: 9
    no sarcasm intended

  7. #6
    Join Date
    Jun 2017
    Posts
    3
    Sorry guys. I'm really new in databases and db2 makes me crazy. Config advisor is a good choise. db2 9.7.5 express. Thanks
    Last edited by freedom12; 06-15-17 at 07:52. Reason: add db2 version

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •