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

    Unanswered: URGENT! db2set problems

    Hello all!

    I have DB2 EEE v.8 installed on AIX v. 5
    I'm trying to set DB2 enviroment variable DB2_NEWLOGPATH2 but things look more difficult than I have expected.

    First I've listed all variables that I already have (DB2COMM and DB2AUTOSTART), and than I try to set new one. I've read the manual and I'm sure that syntax that I use to set it is OK ($ db2set DB2_NEWLOGPATH2=1) but it doesn't work. But when I try to change DB2COMM variable to something else (whatever) - it works, as you can see at the end.


    $ db2set
    DB2COMM=tcpip
    DB2AUTOSTART=YES
    $
    $
    $ db2set DB2_NEWLOGPATH2=1
    DBI1302E Invalid parameter detected.
    Explanation:
    An invalid parameter was used.
    User Response:
    Use the -? option for the usage help message.
    $
    $ db2set DB2_NEWLOGPATH2 1
    DBI1302E Invalid parameter detected.
    Explanation:
    An invalid parameter was used.
    User Response:
    Use the -? option for the usage help message.
    $
    $ db2set DB2COMM=asdf
    $
    $ db2set
    DB2COMM=asdf
    DB2AUTOSTART=YES
    $


    Than I was looking for place where DB2 writes its eviroment variables and found this:

    $ pwd
    /home/db2inst1/db2inst1/sqllib/profile.env
    $
    $ cat profile.env
    DB2COMM='tcpip'
    DB2AUTOSTART='YES'
    $

    Than I added my new variable in it at the end, log out, log in again, stoped db2instance, started it again and wanted to see is everithing OK but it is not, again:

    $ db2set
    DB2COMM=tcpip
    DB2AUTOSTART=YES
    $

    All of this works perfectly on DB2 v7.2 that I have too on another place.

    Please if you can give me some advice ....
    Thank you in advance!!

    Nicole

  2. #2
    Join Date
    May 2003
    Posts
    57
    I'm sorry for writting URGENT in subject... I'm in a hurry this morning so I didn't even think about nam I gave to the topic.

    Thank you for understanding

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: URGENT! db2set problems

    This is no more (from V8) a registry variable ,,,

    It is a db cfg mirrorlogpath

    Cheers

    Sathyaram

  4. #4
    Join Date
    May 2003
    Posts
    57
    Sathyaram,thank you very much!

    I've found db2_newlogpath2 in IBM documentation for V8 so didn't even think that it could be different.

    Thank you again.

Posting Permissions

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