Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Safe to PRUNE "leftover" logs?

    DB2 8.2 AIX for SAP
    I'm investigating the space usage in the log_file directory. There are 20 Primary logfiels defined and I see those in directory but I alos see some older out of sequence logfiles from about a month ago. Now we are using TSM for backup adn log archiving. I've looked in the History file and the db2diag and it looks like these files have been sucessfuly archived, but I don't know where/how to visually verify their existence as I assume they are on a tape somewhere.

    Here is some relevant CFG info:

     User exit for logging status                            = YES
     Number of primary log files                (LOGPRIMARY) = 20
     Number of secondary log files               (LOGSECOND) = 40
     Path to log files                                       = /db2/GM1/log_dir/NODE0000/
     Overflow log path                     (OVERFLOWLOGPATH) =
     Mirror log path                         (MIRRORLOGPATH) =
     First active log file                                   = S0003189.LOG
     Block log on disk full                (BLK_LOG_DSK_FUL) = NO
     Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
     Percent log file reclaimed before soft chckpt (SOFTMAX) = 300
     User exit for logging enabled                (USEREXIT) = OFF
     HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC
     First log archive method                 (LOGARCHMETH1) = VENDOR:/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
     Options for logarchmeth1                  (LOGARCHOPT1) =
     Second log archive method                (LOGARCHMETH2) = OFF
     Options for logarchmeth2                  (LOGARCHOPT2) =
     Failover log archive path                (FAILARCHPATH) =
     Number of log archive retries on error   (NUMARCHRETRY) = 5

    My question, is it safe to PRUNE these files since I can't verify they are in an archive somewhere?

  2. #2
    Join Date
    Jan 2003
    try this out:
    db2 get db cfg for databas_name | grep "First active log file"
    As seen from you sample data the result should be: S0003189.LOG
    Hope this helps,

  3. #3
    Join Date
    Jun 2006


    db2adutl query logs... can show the logs that are available in tsm.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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