dbTalk Databases Forums  

EVMON_FORMAT_UE_TO_TABLES

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss EVMON_FORMAT_UE_TO_TABLES in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Damir
 
Posts: n/a

Default EVMON_FORMAT_UE_TO_TABLES - 03-04-2010 , 08:40 AM






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

Reply With Quote
Reply




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.