If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > problem in updating logarchmeth1

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-19-11, 02:24
Sandeep_Sharma Sandeep_Sharma is offline
Registered User
 
Join Date: Sep 2011
Location: Delhi
Posts: 17
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..!
Reply With Quote
  #2 (permalink)  
Old 10-19-11, 02:30
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
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
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 10-19-11, 03:17
Sandeep_Sharma Sandeep_Sharma is offline
Registered User
 
Join Date: Sep 2011
Location: Delhi
Posts: 17
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 ?????
Reply With Quote
  #4 (permalink)  
Old 10-19-11, 03:24
Sandeep_Sharma Sandeep_Sharma is offline
Registered User
 
Join Date: Sep 2011
Location: Delhi
Posts: 17
after trying C directory i also tried F directory with path

F:\DB2\archive_logs
and able to update the parameter.
Reply With Quote
  #5 (permalink)  
Old 10-19-11, 04:43
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On