The following fuzzy search query using some specific keyword for
fuzzy option may have an internal error CTE0103. The keyword
depends on the environment.
(Fuzzy Search Example)
SELECT COUNT(*) FROM TABLE1 WHERE CONTAINS(COMMENT,'FUZZY FORM
OF 90 \"indin\" ')=1
SQL0443N Routine "*ARCH_8K64" (specific name "") has returned
an error
SQLSTATE with diagnostic text "CTE0103 An internal error
occurred.
Location:
"361", "10". SQLSTATE=38703
db2diag.log may generate the following message from NSE and GTR.
2011-12-05-14.15.10.039901+540 I193655A440 LEVEL: Error
PID : 811136 TID : 36462 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
EDUID : 36462 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging fu, probe:0
MESSAGE : Message
DATA #1 : String, 58 bytes
CTE0103 An internal error occurred. Location: "361", "10".
2011-12-05-14.15.10.040244+540 I194096A451 LEVEL: Error
PID : 811136 TID : 36462 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
EDUID : 36462 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging func, probe:0
MESSAGE : GTR data
DATA #1 : Hexdump, 4 bytes
0x0000000118875AD0 : 0000 0005
....
2011-12-05-14.15.10.040554+540 I194548A451 LEVEL: Error
PID : 811136 TID : 36462 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
EDUID : 36462 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging func, probe:0
MESSAGE : GTR data
DATA #1 : Hexdump, 4 bytes
0x0000000118875AD4 : 0000 0D1A
.... |
