|
Problem IT02074
|
Status: Closed |
UPDATE STATEMENT FAILS WITH TRAP WHEN THERE IS A MISMATCH IN THE DISTRIBUTION STATISTICS COUNT VS ACTUAL VALUES COLLECTED |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
> db2 "update run.tab set c1='100' where c1='0'"
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1224N The database manager is not able to accept new
requests, has
terminated all requests in progress, or has terminated the
specified request
because of an error or a forced interrupt. SQLSTATE=55032
FODC and TRAP file will be generated..
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAB8E33A2F
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x046f
(/home/sahanant/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB8E3437F ossDumpStackTraceV98 + 0x0081
(/home/sahanant/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB8E2C817 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x0377
(/home/sahanant/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB08304B5 sqlo_trce + 0x06a3
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAB09D9539 sqloEDUCodeTrapHandler + 0x05df
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAABD5E00 address: 0x00002AAAAABD5E00 ; dladdress:
0x00002AAAAABC8000 ; offset in lib: 0x000000000000DE00 ;
(/lib64/libpthread.so.0)
0x00002AAAB185FE94 _Z27sqloUnaligned4BytesToUint32PKh + 0x0018
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAB18B924F
_Z19sqlv_longcompdfp128PK14sqlrxCollationP10sqlz_valueS3_j +
0x002b
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAB2DF0FD1
_Z8sqlrxcp2PK14sqlrxCollationP10sqlz_valueS3_j + 0x1075
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF163485
_Z21sqlno_compare_literalP13sqlno_globalsP10sqlz_valueS2_PK14sql
rxCollation + 0x003d
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF19B537
_Z25sqlno_nud_compare_literalP13sqlno_globalsP10sqlz_valuePdjS3_
j11sqlz_varlenPhP9sqlnq_cstPK14sqlrxCollationP13SQLNN_BOOLEANP19
sqlno_ff_essentials + 0x0243
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF19B687
_Z25sqlno_nud_compare_literalP13sqlno_globalsPdjP10sqlz_valueP9s
qlnq_hstP9sqlnq_cst17sqlno_prefix_typePK14sqlrxCollationP13SQLNN
_BOOLEANP19sqlno_ff_essentials + 0x00fb
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF16B795
_Z18sqlno_ff_nud_rangeP13sqlno_globalsP19sqlno_ff_essentialsP9sq
lnq_cstPdjff14sqlnq_funclassP10sqlz_value17sqlno_prefix_type13SQ
LNN_BOOLEANPfPb + 0x0811
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF179D48 address: 0x00002AAAAF179D48 ; dladdress:
0x00002AAAAACE1000 ; offset in lib: 0x0000000004498D48 ;
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF177FFF address: 0x00002AAAAF177FFF ; dladdress:
0x00002AAAAACE1000 ; offset in lib: 0x0000000004496FFF ;
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF172E32 address: 0x00002AAAAF172E32 ; dladdress:
0x00002AAAAACE1000 ; offset in lib: 0x0000000004491E32 ;
(/home/sahanant/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF17C40E
_Z16sqlno_ff_computeP13sqlno_globalsP19sqlno_ff_essentialsP16sql
no_listheader13SQLNN_BOOLEAN + 0x092e |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to v101 fp5 version *
**************************************************************** |
| Local Fix: |
execute 'RUNSTATS' command manually to overcome the
inconsistency in distribution stats |
| Solution |
v101 fp5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.05.2014
13.07.2015
13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
