Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2008
    Posts
    62

    Unanswered: How to deside value for LOGPRIMARY?

    How can i get the recommended values for db cfg?

    I want to decide the values for LOGPRIMARY LOGSECOND LOGFILSIZ db cfg parameter.

    Is there any recommendation from DB2 for these parameters?

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You can run the DB2 Configuration Advisor to get a base line configuration. Besides that, you should understand what each parameter does and how your system behaves. Based on that, it is pretty much straight-forward to configure those parameters, i.e. set LOGFILSIZ and LOGPRIMARY to a value that all regular workload can be logged and set LOGSECOND to a value so that peaks in activities can be covered and you don't run into a log-full condition.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Feb 2008
    Posts
    62
    Configuration Advisor can only be used through control center?
    How can i use it from command prompt(CLP)?

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    There is a command line version as well.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Dec 2006
    Posts
    25
    Try the AUTOCONFIGURE command..
    eg
    "db2 autoconfigure apply none"

    That should give you a rough idea to start with. But you need to have a work load running to give the best solution. Once you get the recommendation update the db cfg using those values and run it again.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It depends on your application design and the type of database you have (OLTP, data warehouse, etc). It also helps to know your insert, update, and delete transaction rates.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Feb 2008
    Posts
    62
    Thank you All for your help. it is now clear to me.

Posting Permissions

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