Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2011
    Location
    Delhi
    Posts
    24

    Unanswered: problem in updating logarchmeth1

    Hello,

    I am trying to update the LOGARCHMETH1 path to enable the archive logs so that to free the logs and free some space but getting the error:

    C:\Documents and Settings\Administrator>db2 update db cfg for cognos using LOGARCHMETH1 DISK:"F:\Program Files\IBM\archive_logs"
    SQL0104N An unexpected token "Files\IBM\archive_logs" was found following
    "<identifier>". Expected tokens may include: "ALT_COLLATE". SQLSTATE=42601

    The path do exists..

    db2level: Informational tokens are "DB2 v9.5.500.784", "s091123", "WR21457", and Fix Pack "5".
    Product is installed at "F:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".

    Can someone help asap.. Thanks in advance..!

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I would try
    LOGARCHMETH1 "DISK:F:\Program Files\IBM\archive_logs"
    is the directory existing and accessible ?
    the same as the install directory ?
    for a test : try DISK:c:\temp or any other path without spaces and different from installdir
    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
    Sep 2011
    Location
    Delhi
    Posts
    24
    yes the directory is accessible..

    as you said i tried for C:\test instead of F directory
    and its updated .. strange...

    Cant i set this F directory path as LOGARCHMETH1 ?????

  4. #4
    Join Date
    Sep 2011
    Location
    Delhi
    Posts
    24
    after trying C directory i also tried F directory with path

    F:\DB2\archive_logs
    and able to update the parameter.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Based on the error message, I am guessing that it doesn't like spaces in path name. Not sure if you can use quotes or double-quotes to get around that. But it sounds like a bad place for archive logs anyway, so I would use that path.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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