Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: SQL6031N Error in the db2nodes.cfg file at line number "1". Reason code "10"

    Hi all,

    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 (

    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.


  2. #2
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts