DB2 - Problem description
Problem IT21084 | Status: Closed |
SQL0901N-The SQL statement or command failed because of a database system error. Reason-Unsupported date format for function 331 | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Root cause of it: There is a date format error for en_GB. We should block pushdown for char(current date) under such situation. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 V10.5 FP5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Development fixed this issue and delivered it into * * db2_v105fp9 using defect wsdbu01349611 together with other * * issues. * **************************************************************** | |
Local Fix: | |
Workaround: Disable the pushdownable for this function:char(date) using the following command: CREATE FUNCTION MAPPING MY_ORACLE_FUN2 FOR SYSIBM.CHAR(SYSIBM.DATE) SERVER stpfed OPTIONS (DISABLE 'Y') | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.06.2017 12.07.2017 12.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |