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 > Database Archive log error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-28-11, 04:41
alwayssathya alwayssathya is offline
Registered User
 
Join Date: Aug 2010
Location: Chennai India
Posts: 161
Wink Database Archive log error

Hi experts,

I have configured archieve logging. But the logs are not moved to my arhieve log location automatically.

The command i used to enable archive logging.

db2 update db cfg for reporter using logarchmeth1 disk:/OBJ_DATA/OMNITDW/Archive_Log_reporter
update db cfg for reporter using LOGRETAIN YES
update db cfg for reporter using USEREXIT ON
update db cfg for reporter using LOGBUFSZ 4096
update db cfg for reporter using LOGprimary 100
update db cfg for reporter using LOGsecond 50



Help me as what would be the issue why logs are not moved to the path.
Reply With Quote
  #2 (permalink)  
Old 01-28-11, 04:56
nvk@vhv nvk@vhv is offline
Registered User
 
Join Date: Jan 2010
Posts: 294
Check
logarchmeth1 - Primary log archive method configuration parameter - IBM DB2 9.7 for Linux, UNIX, and Windows
->
2. If you update the userexit or logretain configuration parameters logarchmeth1 will automatically be updated and vice versa. However, if you are using either userexit or logretain, logarchmeth2 must be set to OFF.

What setting do you have for logarchmeth1? If you issued the commands in the given order logarchmeth1 is USEREXIT. Do you have a userexit program?
I'ld recommend to just update logarchmeth1 and don't update LOGRETAIN and USEREXIT. If you set logarchmeth1, then LOGRETAIN will be set automatically.

Also if you set logarchmeth1 for the first time the databases needs to be deactivated and you have to take an offline backup of the database.
Reply With Quote
  #3 (permalink)  
Old 01-28-11, 05:27
alwayssathya alwayssathya is offline
Registered User
 
Join Date: Aug 2010
Location: Chennai India
Posts: 161
Thanks nvk.

As it was a permission issue. which the log path was owned by root.

now it is working...
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