Results 1 to 7 of 7
  1. #1
    Join Date
    May 2003
    Posts
    57

    Question Unanswered: changing db cfg parameter

    Hello all!

    Does someone knows how I can change MIRRORLOGPATH db cfg parameter form something to nothing?

    This is what I have.

    $db2 get db cfg for mydb
    Path to log files = /home/db2inst1/NODE0000/SQL00001/SQLOGDIR/
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) = /mydb_copy_logs/MYDB/NODE0000/
    First active log file = S0001339.LOG

    I want to set this parameter to "nothing" but when I do this I receive error:

    $ db2 update db cfg using mirrorlogpath
    SQL0104N An unexpected token "END-OF-STATEMENT" was found following
    "MIRRORLOGPATH". Expected tokens may include: "<identifier>".
    SQLSTATE=42601

    I have to put some identifier, but which one?

    DB2 v.8 , AIX

    Thank you in advance...

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

    Have you tried to write:
    db2 update db cfg using mirrorlogpath =

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    May 2003
    Posts
    57
    Unfortunetly - still the same error...

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would try =NO or =NULL
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow ''

    update db cfg using MIRRORLOGPATH '' (two single quotes)

    should do the trick (I hope :-))

    BOW
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  6. #6
    Join Date
    May 2003
    Posts
    57
    Quote Originally Posted by Tank
    update db cfg using MIRRORLOGPATH '' (two single quotes)

    should do the trick (I hope :-))

    BOW
    Thank you ... This works!!

    NNicole

  7. #7
    Join Date
    Mar 2011
    Posts
    41
    Below is the right way of doing it .

    DB2 update db cfg using MIRRORLOGPATH DEFAULT

    Regards
    Sam

Posting Permissions

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