DB2 - Problembeschreibung
Problem IC96304 | Status: Geschlossen |
FED: ALTER NICKNAME IN ORA COMPATIBLE MODE, FAILED TO MAP REMOTE DATE TO LOCAL TIMESTAMP(0) | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Set DB2_COMPATIBILITY_VECTOR to enable local federated DB2 database and disable DB2 compatibility features against DRDA database. ALTER NICKNAME does not work to map remote DATE to local TIMESTAMP(0). For example: db2set DB2_COMPATIBILITY_VECTOR=ORA db2 create db testora connect to testora CREATE WRAPPER drda create server <server_name> type db2/udb version 9.7 wrapper drda authorization <user_id> password <password> OPTIONS(dbname <dbname>, password 'Y') create user mapping for user server <server_name> options( remote_authid <user_id>, remote_password <password>) set passthru <server_name> create table ltab (c1 int, c2 date) set passthru reset create nickname nck1 for <server_name>.<user_id>.ltab ALTER NICKNAME <user_id>.nck1 ALTER COLUMN C2 LOCAL TYPE TIMESTAMP(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: SQL0604N The length, precision, or scale attribute for column, distinct type, structured type, array type, attribute of structured type, routine, cast target type, type mapping, or global variable "DATE" is not valid. SQLSTATE=42611 The mapping rule refers to http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2 Fcom.ibm.swg.im.iis.db.found.conn.fw.dtm.doc%2Ftopics%2Fiiynwdtm dlf.html | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Set DB2_COMPATIBILITY_VECTOR to enable local federated DB2 * * database and disable DB2 compatibility features against DRDA * * database. * * ALTER NICKNAME does not work to map remote DATE to local * * TIMESTAMP(0). * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to 10.5.0.3 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem Fixed In 10.5.0.3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.09.2013 10.03.2014 10.03.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.3 | |
10.5.0.3 |