Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: Basic doubts about db2 logs

    In db2 environment,
    there are two types of logs namely PRIMARY and SECONDARY

    1q)i know secondary can allocated dynamically, then what is the need of primary??

    2q) Apart from above point what is the difference between primary and secondary
    3q) what is the specific need of primary and secondary
    4q)what we have 2 types of logs

    As per my knowledge,
    primary + secondary = 256

    (secondary =-1 <=> infinity , i dont have clear idea whether we can use this option in real time or not)


    4q)in my environment,

    Log file size (4KB) (LOGFILSIZ) = AUTOMATIC
    Number of primary log files (LOGPRIMARY) = AUTOMATIC
    Number of secondary log files (LOGSECOND) = AUTOMATIC
    In this case,
    if total of both primary and secondary exceeds 256 , what type of error we ca get, simple moving commited log files to another location will solve the issue??

    (because in my log path, already 158 logs are there)

    pls let me know ...

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    a lot of basic questions - a lot of reading todo...
    as usual see the doc :
    logprimary - Number of primary log files configuration parameter - IBM DB2 9.7 for Linux, UNIX, and Windows
    I have never seen these settings :
    Log file size (4KB) (LOGFILSIZ) = AUTOMATIC
    Number of primary log files (LOGPRIMARY) = AUTOMATIC
    Number of secondary log files (LOGSECOND) = AUTOMATIC

    according the doc : this is not correct
    logfilsiz can not be changed dynamically - deactivate - activate is needed for primary logs..
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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