Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: changing log path

    DB2 EEE v7.2 FP6 on AIX 5.1

    I am trying to move the primary log files from the default location, however I am unable to do so.

    db2 update db cfg for arcprodb using NEWLOGPATH /lib1/archive/prodb/arsdb_primarylog
    SQL5099N The new path to the log (newlogpath) in the database configuration
    file is not valid.

    The path does exist and the permissions on the directories are correct and the size of the filesystem is large enough to hold them.

    /dev/lib1lv21 31457280 30469864 4% 18 1% /lib1/archive/prodb/arsdb_primarylog

    So I am at a loss as to how to move them (I need them moved as my userexit will be pointing to the new location

    thanks for any help

    Mark

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    Not quite sure of what you are trying to do. It looks like you are trying to change the logdir and thne you mention that the userexit will point to this directory.

    First, if you are trying to change the log directory, then the manner in which you're doing it is correct. However, as instanceowner, can you touch a file in this directory? Go up a level from the current log directory and check it's permissions - does the new directory have the same set of permissions?

    If you are trying to specify this path as the new archive log directory, then you do not need to specify newlogpath for that. The update to db2's db2uext2 should do that. However the permissions issue will need to be addressed.

    Hope this helps

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    Thanks for your advice, however it still does not help the situation.

    I was able to touch a file into that directory:

    $ touch test
    $ ls -ltr
    total 8
    drwxrws--- 2 arcprodb db2iadm1 512 Jun 30 20:55 lost+found
    -rw-r--r-- 1 arcprodb db2iadm1 0 Jul 25 09:40 test

    And what I am trying to do is move the primary logs from the default path to this new path.

    thanks

    Mark

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Try to maximize the priorities in this directory.
    Try using: chmod 777 it may help.

    Hope this helps,
    Grofaty


    Originally posted by mark_maz
    Thanks for your advice, however it still does not help the situation.

    I was able to touch a file into that directory:

    $ touch test
    $ ls -ltr
    total 8
    drwxrws--- 2 arcprodb db2iadm1 512 Jun 30 20:55 lost+found
    -rw-r--r-- 1 arcprodb db2iadm1 0 Jul 25 09:40 test

    And what I am trying to do is move the primary logs from the default path to this new path.

    thanks

    Mark

Posting Permissions

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