DB2 - Problembeschreibung
Problem IC99512 | Status: Geschlossen |
AN ATTEMPT TO ATTACH LOCAL NODE BY DATA SERVER CLIENT MIGHT THROW SQL1032N. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Server Client will throw SQL1032N for scenario where client instance and server instance resides on the same platform. clientInst1> ps -ef | grep db2sysc serverInst1 7521 7519 0 Feb19 ? 00:00:33 db2sysc 0 clientInst1> db2 list db directory Database 1 entry: Database alias = SAMPLE Database name = SAMPLE Node name = LOCAL_NODE Database release level = d.00 Comment = Directory entry type = Remote Catalog database partition number = -1 Alternate server hostname = Alternate server port number = clientInst1> db2 list node directory Node Directory Number of entries in the directory = 2 Node 1 entry: Node name = LOCAL_NODE Comment = Directory entry type = LOCAL Protocol = LOCAL Instance name = serverInst1 clientInst1> db2 attach to LOCAL_NODE SQL1032N No start database manager command was issued. SQLSTATE=57019 You may receive SQL1224N or SQL30040N when connecting to the database: clientInst1> db2 connect to SAMPLE user xxxx using xxxx 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 or SQL30040N Execution failed because of unavailable resources that will not affect the successful execution of subsequent commands and SQL statements: Reason "0x0", Type of Resource "MEMORY", Resource Name "", Product ID "SQL09079 ". SQLSTATE=57012 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Client instance users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade Data Server Client to DB2 9.7 Fix Pack 10. * **************************************************************** | |
Local-Fix: | |
Please catalog tcpip node instead of local node. | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.02.2014 29.12.2014 29.12.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP10 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |