DB2 - Problembeschreibung
Problem IT02596 | Status: Geschlossen |
RECEIVE SQL0901N WITH ERROR MESSAGE "MSSQL3 UNKNOWN VERSION" WHEN INSERTING NICKNAME FOR 2012 SQL SERVER | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Here is a sample reproducing flow. - create wrapper MSSQLODBC3 - create server <your_server_name> type MSSQLSERVER version 2012 wrapper MSSQLODBC3 options (DB2_IUD_ENABLE 'Y', node '<your_2012_dsn>', dbname '<your_dbname>') - create user mapping for user server <your_server_name> options (remote_authid '<user>', remote_password '<password>') - create nickname TN for <your_server_name>."<user>"."T1" - insert into TN values(2) DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0901N The SQL statement or command failed because of a database system error. (Reason "MSSQL3 Unknown version ".) SQLSTATE=58004 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * MSSQL server 2012 user * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Release 9.7.0.10 (also known as v9.7 Fix Pack * * 10) or higher * **************************************************************** | |
Local-Fix: | |
Use 2008 version number as work around like below: - db2 "alter server <your_server_name> version 2008" | |
Lösung | |
Fixed in DB2 Release 9.7.0.10 (also known as v9.7 Fix Pack 10) | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.06.2014 17.11.2014 17.11.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.0.10, 9.7.FP*, 9.7.FP10 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |