Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013

    Unanswered: help required on performance tuning?

    i am newbie to Db2....
    i have some questions on performance tuning...
    1.i am coordinating with java team and they used only select queries with where clause. How can i improve performance for those tables which are calling in java pages?

    2. in one table , we used CLOB (800000) as datatype for one column. is CLOB datatype reduce performance and what is memory it takes?

    Thanks in advance...

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    as db2level/platform are not indicated : no link to infocenter can be provided
    in the db2 library there is a special book about performance tuning.
    I would strongly recommend you to :
    - learn first db2
    - tune a db (after having read some books)
    lobs, usually to do go to bufferpool .....
    tuning a db2 system should be done with care and well examined before changing any setting/defining any index.......
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    1. tables do not call in java pages.
    2. depending on what the processing is with this clob it may or may not affect performance.

    There are tons of implications in performance tuning. You really can't just say what do I do. You have to have a specific question for us to be able to help you or provide specific information about your systems and applications and cut us in on a paycheck.

Posting Permissions

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