Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    35

    Unanswered: Problem changing logpath under V8 ...

    I am trying to change the logpath location on DB2 V8 FP4 Aix 5.2. I don't what I am not doing but it has no effect ... here are the commands:

    $ db2 get db cfg for db2test
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =

    $ db2 update database cfg for db2test using NEWLOGPATH /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/
    DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully

    $ db2 get db cfg for db2test
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =

    $ db2stop
    12-09-2003 12:38:37 0 0 SQL1064N DB2STOP processing was successful.
    SQL1064N DB2STOP processing was successful.
    $ db2start
    12-09-2003 12:38:40 0 0 SQL1063N DB2START processing was successful.
    SQL1063N DB2START processing was successful.

    $ db2 get db cfg for db2test
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =

  2. #2
    Join Date
    Dec 2003
    Posts
    3

    Re: Problem changing logpath under V8 ...

    DB2 adds the NODE0000 to the end of the path, so you are actually pointing the new log path to the same location where it already is.

    Originally posted by dlafreni
    I am trying to change the logpath location on DB2 V8 FP4 Aix 5.2. I don't what I am not doing but it has no effect ... here are the commands:

    $ db2 get db cfg for db2test
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =

    $ db2 update database cfg for db2test using NEWLOGPATH /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/
    DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully

    $ db2 get db cfg for db2test
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =

    $ db2stop
    12-09-2003 12:38:37 0 0 SQL1064N DB2STOP processing was successful.
    SQL1064N DB2STOP processing was successful.
    $ db2start
    12-09-2003 12:38:40 0 0 SQL1063N DB2START processing was successful.
    SQL1063N DB2START processing was successful.

    $ db2 get db cfg for db2test
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /db2/db2testlog/NODE0000/SQL00001/SQLOGDIR/NODE0000/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =

Posting Permissions

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