home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList