Results 1 to 3 of 3

Thread: Db2

  1. #1
    Join Date
    Aug 2012

    Unanswered: Db2


    I have created the database under the folder of /home/ question here is my home local mount point is getting full frequently may be the application users are doing could you please suggest me how to remove my environment the log files are occupied by more space in this path.

    Do i need to remove the log files as mentioned above or any other process i have to do.the log file starts with like S0000205.LOG to my home mount point reaches 95%.

    db2 get db cfg for testdb | grep 'LOG'
    Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
    Log buffer size (4KB) (LOGBUFSZ) = 2150
    Log file size (4KB) (LOGFILSIZ) = 3000
    Number of primary log files (LOGPRIMARY) = 13
    Number of secondary log files (LOGSECOND) = 100
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =
    First active log file = S0003953.LOG
    Block log on disk full (BLK_LOG_DSK_FUL) = NO
    Block non logged operations (BLOCKNONLOGGED) = NO
    Percent max primary log space by transaction (MAX_LOG) = 0
    Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
    First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/
    Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
    Options for logarchmeth1 (LOGARCHOPT1) =
    Second log archive method (LOGARCHMETH2) = OFF
    Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF
    Options for logarchmeth2 (LOGARCHOPT2) =
    Log pages during index build (LOGINDEXBUILD) = OFF
    Log DDL Statements (LOG_DDL_STMTS) = NO
    Log Application Information (LOG_APPL_INFO) = NO

    so please do the needful ASAP.

  2. #2
    Join Date
    Dec 2012
    You may want to change this parameter to other dir path:

    First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/

  3. #3
    Join Date
    Apr 2006
    Provided Answers: 11
    better would be to move the logs completely
    update db cfg for xx using newlogpath /yyyy
    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

Posting Permissions

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