Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008

    Unanswered: What LOGPRIMARY means ?

    My DB2 database have these configuration parameters :

    Log file size (4KB) (LOGFILSIZ) = 1024 1024
    Number of primary log files (LOGPRIMARY) = 13 13
    Number of secondary log files (LOGSECOND) = 4 4

    However, initially, there was only 1 log file. Its file size is just 36864.
    A new log file will be generated when I did online full backup and online incremental backup but 13 is not an upper limit.

    I am confused about these 3 parameters, what do they mean ?

  2. #2
    Join Date
    Jan 2009
    No of primary log files is the logfiles which will be allocated during the db activation and the secondary logs are when a transaction requires beyond the no of primary logs secondary logs will be allocated on by one on need basis. the limit to no of logs is logprimary + log secondary. Each log file will be of the file size mentioned in the log file size parameter. Changing teh value of logsecond is dynamic where as logprimary needs a db restart. the max logprimary+log second can be is 256. Let me know if ur doubts are still not clarified.


  3. #3
    Join Date
    Mar 2012
    Canberra, Australia
    This is basic Db2 info that can be readily obtained from the Db2 doco. before asking questions it would be really good to read the doco
    logprimary - Number of primary log files configuration parameter - IBM DB2 9.7 for Linux, UNIX, and Windows

Posting Permissions

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