|
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
|
 |
