In a HADR setup, transaction log files should be archived only
by the primary server. Due to an internal logic error, a log
file could be archived by the standby server when a deactivate
database command is issued.
Here's an example of the db2diag.log entries from the primary
HADR server i.e.
<snip>
2011-04-14-13.15.06.020862-240 E57184A373 LEVEL: Info
PID : 3109096 TID : 2315 PROC : db2sysc
INSTANCE: xxxxxxx NODE : 000
EDUID : 2315 EDUNAME: db2logmgr (xxxxxx)
FUNCTION: DB2 UDB, data protection services,
sqlpgArchiveLogFile, probe:3108
DATA #1 : <preformatted>
Started archive for log file S0028570.LOG.
2011-04-14-13.15.06.030289-240 E57558A494 LEVEL: Info
PID : 3109096 TID : 2315 PROC : db2sysc
INSTANCE: xxxxxxx NODE : 000
EDUID : 2315 EDUNAME: db2logmgr (xxxxxx)
FUNCTION: DB2 UDB, data protection services,
sqlpgArchiveLogFile, probe:3180
DATA #1 : <preformatted>
Completed archive for log file S0028570.LOG to
/xxxx/xxxx/archive/xxxxxxx/xxxxxx/NODE0000/C0000000/ from
/xxxxx/xxxxxxx/xxxxxxx/NODE0000/SQL00001/SQLOGDIR/.
...
Here's an example of the db2diag.log entries from the standby
server (Note: S00285709.LOG should not be archived on the
standby) i.e.
<snip>
2011-04-14-13.15.19.997444-240 I66548A466 LEVEL: Warning
PID : 954478 TID : 1801 PROC : db2sysc
INSTANCE: xxxxxxx NODE : 000 DB : xxxxxx
APPHDL : 0-29 APPID:
*xxxxx.xxxxxxx.xxxxxxxxxxxx
AUTHID : xxxxxxx
EDUID : 1801 EDUNAME: db2agent (xxxxxx)
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrEduShutdown, probe:29002
MESSAGE : Info: HADR Shutdown has completed.
2011-04-14-13.15.19.998278-240 E67015A373 LEVEL: Info
PID : 954478 TID : 2368 PROC : db2sysc
INSTANCE: xxxxxxx NODE : 000
EDUID : 2368 EDUNAME: db2logmgr (xxxxxx)
FUNCTION: DB2 UDB, data protection services,
sqlpgArchiveLogFile, probe:3108
DATA #1 : <preformatted>
Started archive for log file S0028570.LOG.
2011-04-14-13.15.20.019806-240 E67389A494 LEVEL: Info
PID : 954478 TID : 2368 PROC : db2sysc
INSTANCE: xxxxxxx NODE : 000
EDUID : 2368 EDUNAME: db2logmgr (xxxxxx)
FUNCTION: DB2 UDB, data protection services,
sqlpgArchiveLogFile, probe:3180
DATA #1 : <preformatted>
Completed archive for log file S0028570.LOG to
/xxxx/xxxx/archive/xxxxxxx/xxxxxx/NODE0000/C0000000/
from /xxxxx/xxxxxxx/xxxxxxx/NODE0000/SQL00001/SQLOGDIR/. |
****************************************************************
* USERS AFFECTED: *
* DB2 HADR users on all platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* log archive can happen on HADR standby. This usually does *
* not cause any trouble for customer, but may lead to some *
* unpredictable issues. *
* When hitting this, customer can see the symptoms described *
* in "Error Description" *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v97fp5 *
**************************************************************** |
