Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC99512 Status: Closed

AN ATTEMPT TO ATTACH LOCAL NODE BY DATA SERVER CLIENT MIGHT THROW SQL1032N.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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 Summary:
**************************************************************** 
* 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.
Solution
Problem was first fixed in Version 9.7 Fix Pack 10.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.02.2014
29.12.2014
29.12.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.