| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT02783 | Status: Closed |
THE USE OF NUMERIC SCALAR FUNCTIONS PUSHING NUMERIC ARGUMENT TYP ES THROUGH A JOIN OR UNION MAY PRODUCE A FODC_APPERR DIRECTORY. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
THE USE OF NUMERIC SCALAR FUNCTIONS (LIKE ABS, COS, SIN, MOD,
POWER, ETC) PUSHING NUMERIC ARGUMENT TYPES (DECIMAL, FLOAT, ETC)
THROUGH A JOIN OR UNION MAY PRODUCE A FODC_APPERR DIRECTORY.
A -901 error may be observed in the db2diag.log file during
execution of queries that use numeric scalar functions (like
ABS, COS, SIN, MOD, POWER, etc). For a complete list of the
numeric scalar functions search the DB2 10.5 information center
for "Built-in functions".
An example of select using the ABS function is shown:
2014-06-13-17.42.14.166246-240 I43171A890 LEVEL:
Severe
PID : 7995792 TID : 71522 PROC :
db2sysc 0
INSTANCE: db2inst NODE : 000 DB :
SAMPLE
APPHDL : 0-37526 APPID: *N0.db2inst.140613213958
AUTHID : DB2INST HOSTNAME: hostname
EDUID : 71522 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 28
sqlerrmc: Invalid operand type for ABS
sqlerrp : SQLRI007
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFFCE (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * USERS OF NUMERIC SCALAR FUNCTIONS IN JOINS OR UNION. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Possible workaround is to rewrite the query and remove the * * numeric scalar function. * **************************************************************** | |
| Local Fix: | |
Possible workaround is to rewrite the query and remove the numeric scalar function. | |
| Solution | |
Upgrade to DB2 UDB Version 10.1 FP5. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.06.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 |
|
