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 > Archive logs backup do not start automatically

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-14-10, 10:27
mukesh_kp mukesh_kp is offline
Registered User
 
Join Date: Apr 2010
Posts: 3
Question Archive logs backup do not start automatically

Db2 9.1
My database name is =muk
Database alias name is =mukl

I am using backup software and I configured database backup using alias name mukl

The online backup is working but archive logs do not start after the online backup.

My question is can i use Alias name for database backup or do I need to use database name for backup so that my archive logs get started
USEREXIT is set for database muk
Reply With Quote
  #2 (permalink)  
Old 04-14-10, 10:31
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
How do you know your logs are not being archived? Are there any messages in the db2diag.log file? What are your database configuration settings?


Andy
Reply With Quote
  #3 (permalink)  
Old 04-14-10, 10:54
mukesh_kp mukesh_kp is offline
Registered User
 
Join Date: Apr 2010
Posts: 3
can alias name be used for archive logs backup.
I use backup software archive log bakcup should started automatically once online backup is completed.

I have configured online backup using Alias name mukl and not the database name muk

Archive logs are there and useexit

ath to log files = /db2/muk/logs_dir1/NODE0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0008769.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = YES
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 300
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = ON

HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) =
HADR remote host name (HADR_REMOTE_HOST) =
HADR remote service name (HADR_REMOTE_SVC) =
HADR instance name of remote server (HADR_REMOTE_INST) =
HADR timeout value (HADR_TIMEOUT) = 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC

First log archive method (LOGARCHMETH1) = USEREXIT
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Reply With Quote
  #4 (permalink)  
Old 04-14-10, 11:23
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
What do you mean by "archive logs backup"?

When you set LOGARCHMETH1 to "userexit", you must place a userexit routine in the appropriate DB2 directory for this to work properly.

I assume you are trying to have your logs archived to your backup software. To do this, the backup software must supply you with the userexit routine to do this.

Are there any messages in the db2diag.log file about archiving logs (whether they are successful or not)?

Andy
Reply With Quote
  #5 (permalink)  
Old 04-21-10, 07:36
mukesh_kp mukesh_kp is offline
Registered User
 
Join Date: Apr 2010
Posts: 3
I found the solution.
We need to configure archuve logs backup with database name and Alias name.
I used muk for archive logs backup and it worked.
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