08-21-13, 21:10 #1Registered User
- Join Date
- May 2012
Unanswered: SQL6031N Error in the db2nodes.cfg file at line number "1". Reason code "10"
I got this error; and followed the instructions in this technote: IBM Changing hostname of the DB2 server - United States (Seems to me that technote may be for pre-v10.)
Anyway, I am still getting the above error when I issue a db2start,
even though I have the hostname in db2nodes.cfg, /etc/HOSTNAME, /etc/hosts AND DB2SYSTEM set to the same name. The name is an alias for the complete name (x.y.com).
db2licm -l shows:
Product name: "DB2 Advanced Enterprise Server Edition"
License type: "Authorized User Single Install"
Expiry date: "Permanent"
Product identifier: "db2aese"
Version information: "10.5"
Enforcement policy: "Soft Stop"
Number of licensed authorized users: "25"
db2level does not run. I get
SQL10003C There are not enough system resources to process the request. The request cannot be processed.
I am using a Linux SUSE 64-Bit VM image. I checked, I have enough memory and storage. All was right until I changed the hostname.
08-21-13, 23:21 #2Registered User
- Join Date
- May 2003
If at all possible, take a database backup, delete the instance, create a new instance, and restore the database.M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390