Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2007
    Posts
    2

    Unanswered: Path to Log Files?

    Take note, I am a newbie . I am encountering a low disk space alert.
    I have one instance and my DB2 UDB version is 9.1.
    Path to Log Files of the database in question shows a path which have enough disk space i.e. Path to Log Files = /db2kb7777/partX/logs/REX_db/NODE0000/, base on the Log file size (4KB) (LOGFILSIZ) = 5000, size of the log files in this directory is 20488192, and files are from
    -rw------- 1 db2kb7777 db2 20488192 Apr 29 12:59 S0000000.LOG
    to
    -rw------- 1 db2kb7777 db2 20488192 Jan 14 15:19 S0000009.LOG

    ***
    Number of primary log files (LOGPRIMARY) = 10
    Number of secondary log files (LOGSECOND) = 4
    ***

    BUT I am getting a low disk space alert on these directories (99% Used)
    /db2kb7777/partB/logs/REX_db/NODE0002
    and this directory
    /db2kb7777/partC/logs/REX_db/NODE0001

    Log files here: /db2kb7777/partB/logs/REX_db/NODE0002 are from
    -rw------- 1 db2kb7777 db2 40968192 Apr 16 22:39 S0000000.LOG
    to
    -rw------- 1 db2kb7777 db2 40968192 Apr 16 22:38 S0000024.LOG
    with
    -rw------- 1 db2kb7777 db2 40968192 Apr 29 12:59 S0000003.LOG

    Log files here: /db2kb7777/partC/logs/REX_db/NODE0001 are from
    -rw------- 1 db2kb7777 db2 40968192 Apr 29 12:59 S0000000.LOG
    to
    -rw------- 1 db2kb7777 db2 40968192 Apr 16 22:40 S0000024.LOG

    It appears that database REX_db uses these logs files but I don't see how these directories are related to the database REX_db base on the database configurations. I am wondering how come their modification date is more updated than the one listed in "Path to Log Files" of REX_db. There is no other instance here except db2kb7777 (as per db2ilist), I made sure no other databases inadvertently used these directories for their log files.

    My questions:
    How can I know for sure who owns these log files?
    Could there be some sort of replication or log shipping at work here and is utilizing these directories? and how can I find out if there are?
    Any other ideas and/or insight that can shed light on what I am missing here?

    Thanks in advance!

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have a look at db cfg for database- this indicates the logparh - if mirrored
    or achived and where to
    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

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Judging by NODE0001 and NODE0002 in your log path strings, you probably have a partitioned database. Please keep in mind that the database configuration, including the log paths, may differ between partitions.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Sep 2007
    Posts
    2
    Thanks for your response!

    Here are related db cfg for REX_db, logs are not mirrored.

    Path to log files = /db2kb7777/partX/logs/REX_db/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =
    First active log file =
    Log retain for recovery enabled (LOGRETAIN) = OFF

    How can I verify if a database is partitioned?

    Thanks in advance!

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369

Posting Permissions

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