Hi all,
the command:
call SYSPROC.EVMON_FORMAT_UE_TO_TABLES ('LOCKING', NULL, NULL, NULL, NULL,
NULL, NULL, -1, 'SELECT * FROM DB2.ETNA_LOCKEVMON');
returns the error:
51003(-818)[IBM][CLI Driver][DB2/AIX64] SQL0818N A timestamp conflict
occurred. SQLSTATE=51003
Any ideas what package needs a rebind (or what else could be/is wrong)?
("ETNA_LOCKEVMON" event monitor for locking exists, and is setup to write to
unformatted event table, and is active, and the command'SELECT * FROM
DB2.ETNA_LOCKEVMON' works OK and returns (unformatted) rows)
The DB2DIAG.LOG dump is displayed below.
Thanks,
Damir
2010-03-04-14.28.29.738868+060 E588156A828 LEVEL: Error
PID : 1290420 TID : 24275 PROC : db2sysc
INSTANCE: db2 NODE : 000 DB : PPZTEST
EDUID : 24275 EDUNAME: db2agent (PPZTEST) 0
FUNCTION: DB2 UDB, xml decomposition, xdbGetXSRObjectData, probe:98
MESSAGE : ZRC=0xFFFFFFFF=-1
DATA #1 : String, 32 bytes
Error in preparing SQL statement
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -818 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRA145
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFD76 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 51003
2010-03-04-14.28.29.741570+060 I588985A768 LEVEL: Error
PID : 1290420 TID : 24275 PROC : db2sysc
INSTANCE: db2 NODE : 000 DB : PPZTEST
EDUID : 24275 EDUNAME: db2agent (PPZTEST) 0
FUNCTION: DB2 UDB, database application extension for syste,
monXSRObject:

ecompose, probe:996
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -818 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRA145
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFD76 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 51003