The following snapshots will fail if federated applications
exist on more than one member in DPF or SD environments:
get snapshot for all remote_databases global
get snapshot for all remote_applications global
get snapshot for remote_databases on <databaseAlias> global
get snapshot for remote_applications on <databaseAlias>
global
The snapshot fails with this SQLCODE:
SQL1042C An unexpected system error occurred. SQLSTATE=58004
and probes similar to the following are written to the
db2diag.log:
2013-04-23-15.42.53.548687-240 I609423E707 LEVEL:
Severe
PID : 23146 TID : 46912841443648 PROC :
db2sysc 1
INSTANCE: jwr NODE : 001 DB :
APPHDL : 1-106 APPID: *N1.jwr.130423194316
AUTHID : JWR HOSTNAME: hotel38
EDUID : 194 EDUNAME: db2agent (instance) 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging function), probe:50
MESSAGE : No aggregation rule. Element1 (232) is:
DATA #1 : Hexdump, 32 bytes
0x00002AAB265393FC : 1800 0000 0100 E800 0400 0000 3800 2C01
............8.,.
0x00002AAB2653940C : 0100 0000 0400 0000 3800 2D01 68A0 0A00
........8.-.h...
2013-04-23-15.42.53.548942-240 I610131E707 LEVEL:
Severe
PID : 23146 TID : 46912841443648 PROC :
db2sysc 1
INSTANCE: jwr NODE : 001 DB :
APPHDL : 1-106 APPID: *N1.jwr.130423194316
AUTHID : JWR HOSTNAME: hotel38
EDUID : 194 EDUNAME: db2agent (instance) 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging function), probe:50
MESSAGE : No aggregation rule. Element2 (232) is:
DATA #1 : Hexdump, 32 bytes
0x00002AAB264E92EF : 1800 0000 0100 E800 0400 0000 3800 2C01
............8.,.
0x00002AAB264E92FF : 0000 0000 0400 0000 3800 2D01 3813 0000
........8.-.8...
2013-04-23-15.42.53.549130-240 I610839E614 LEVEL:
Severe
PID : 23146 TID : 46912841443648 PROC :
db2sysc 1
INSTANCE: jwr NODE : 001 DB :
APPHDL : 1-106 APPID: *N1.jwr.130423194316
AUTHID : JWR HOSTNAME: hotel38
EDUID : 194 EDUNAME: db2agent (instance) 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging function), probe:50
MESSAGE : No aggregation rule. Parent (34) is:
DATA #1 : Hexdump, 8 bytes
0x00002AAB26469254 : 0000 0000 0100 2200
......".
2013-04-23-15.42.53.549283-240 I611454E499 LEVEL:
Severe
PID : 23146 TID : 46912841443648 PROC :
db2sysc 1
INSTANCE: jwr NODE : 001 DB :
APPHDL : 1-106 APPID: *N1.jwr.130423194316
AUTHID : JWR HOSTNAME: hotel38
EDUID : 194 EDUNAME: db2agent (instance) 1
FUNCTION: DB2 UDB, database monitor,
sqm_aggr_snapshot_buffer::aggregate, probe:65
RETCODE : ZRC=0x000000E8=232 |
