|
Problem IC86144
|
Status: Closed |
IN MULTIPLE DATABASE PARTITIONS ENVIRONMENT, SINGLE SYSTEM VIEW (SSV) BACKUP MAY RUN INTO VIOLATING NUM_LOG_SPAN PROBLEM WITH AD |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
As a rule, DB2 backup commands are excluded from the limitation
imposed by the num_log_span configuration parameter.
However, while doing the Single System View (SSV) backup in
multiple database partitions environment, violating num_log_span
problem might be raised up with ADM1541W message as belowing
db2diag.log entries:
2012-04-09-17.10.55.303124-240 E315779748E486 LEVEL: Info
PID : 7049 TID : 46916997998912PROC :
db2sysc 1
INSTANCE: Christine NODE : 001 DB : Allan
APPHDL : 1-30160 APPID: *N1.nypxt330.120411094113
AUTHID : MSDB2
EDUID : 37375 EDUNAME: db2agent (Allan) 1
FUNCTION: DB2 UDB, database utilities, sqlubMPPRequestor,
probe:543
DATA #1 : <preformatted>
Starting a multi-partition backup on 5 partitions.
...skip...
2012-04-09-23.40.39.472662-240 E355895137E710 LEVEL: Error
PID : 8048 TID : 46912925329728PROC :
db2sysc 3
INSTANCE: Christine NODE : 003 DB : Allan
EDUID : 86 EDUNAME: db2loggr (R1SCENA) 3
FUNCTION: DB2 UDB, data protection services,
sqlpScanTranTableForLowTran, probe:550
MESSAGE : ADM1541W Application "db2bp" with application handle
"1-30160" and
application id "*N1.Christine.120411094113" executing
under
authentication id "AlanDB2 " has been forced off of
the database for
violating database configuration parameter
NUM_LOG_SPAN (current
value "17"). The unit of work will be rolled back.
During SSV backups, log span immunity is set only for the
MPPRequestor agent (ie. the coordinator of all the backup
agents). However, the same immunity is not granted to the actual
backup agents spawned by the coordinator. In a non-SSV backup
there is no MPPRequestor and the backup agent itself is granted
log span immunity, thus the situation arises only in the SSV
case. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL USERS *
****************************************************************
* PROBLEM DESCRIPTION: *
* As a rule, DB2 backup commands are excluded from the *
* limitation *
* imposed by the num_log_span configuration parameter. *
* *
* However, while doing the Single System View (SSV) backup in *
* multiple database partitions environment, violating *
* num_log_span *
* problem might be raised up with ADM1541W message as belowing *
* db2diag.log entries: *
* *
* 2012-04-09-17.10.55.303124-240 E315779748E486 LEVEL: *
* Info *
* PID : 7049 TID : 46916997998912PROC : *
* db2sysc 1 *
* INSTANCE: Christine NODE : 001 DB : *
* Allan *
* APPHDL : 1-30160 APPID: *
* *N1.nypxt330.120411094113 *
* AUTHID : MSDB2 *
* EDUID : 37375 EDUNAME: db2agent (Allan) 1 *
* FUNCTION: DB2 UDB, database utilities, sqlubMPPRequestor, *
* probe:543 *
* DATA #1 : <preformatted> *
* Starting a multi-partition backup on 5 partitions. *
* *
* ...skip... *
* *
* 2012-04-09-23.40.39.472662-240 E355895137E710 LEVEL: *
* Error *
* PID : 8048 TID : 46912925329728PROC : *
* db2sysc 3 *
* INSTANCE: Christine NODE : 003 DB : *
* Allan *
* EDUID : 86 EDUNAME: db2loggr (R1SCENA) 3 *
* FUNCTION: DB2 UDB, data protection services, *
* sqlpScanTranTableForLowTran, probe:550 *
* MESSAGE : ADM1541W Application "db2bp" with application *
* handle *
* "1-30160" and *
* application id "*N1.Christine.120411094113" *
* executing *
* under *
* authentication id "AlanDB2 " has been forced off *
* of *
* the database for *
* violating database configuration parameter *
* NUM_LOG_SPAN (current *
* value "17"). The unit of work will be rolled back. *
* *
* During SSV backups, log span immunity is set only for the *
* MPPRequestor agent (ie. the coordinator of all the backup *
* agents). However, the same immunity is not granted to the *
* actual *
* backup agents spawned by the coordinator. In a non-SSV *
* backup *
* there is no MPPRequestor and the backup agent itself is *
* granted *
* log span immunity, thus the situation arises only in the SSV *
* case. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 FP8 *
* OR *
* As a workaround, do not use SSV backup if the value of *
* NUM_LOG_SPAN is not 0. *
**************************************************************** |
| Local Fix: |
Do not use SSV backup if the value of NUM_LOG_SPAN is not 0. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This problem is fixed in v9.7 FP8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.08.2012
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
