Fix Sql6031n Error In The Db2nodes Cfg File Reason Code 11 (Solved)

Home > Reason Code > Sql6031n Error In The Db2nodes Cfg File Reason Code 11

Sql6031n Error In The Db2nodes Cfg File Reason Code 11

Contents

For example, if you use extended operating system security, you may also need to set the db2accountname and db2instowner parameters. Top This thread has been closed due to inactivity. Similar topics Publishing web site wipes out my web services How to use MS Access DB for ASPNET Application Services (membership, profile, etc) calling a dot net web services from unix Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. http://nssse.com/reason-code/sql6031n-error-in-the-db2nodes-cfg-file-reason-code-10.html

Guy Przytula replied May 11, 2010 have you changed the file, while db2 was running is the data in this file correct ? So each db2 instance requires at least two entries in the /etc/services file The first entry corresponds with SVCENAME. Local fix There are two Local Fixes for this issue: 1) Manually insert entries on /etc/services file and re-run db2icrt 2) Please check and correct /etc/hosts file as per the following Hope this will help. news

Sql6031n Error In The Db2nodes.cfg File At Line Number "0". Reason Code "3"

The actual file is binary rather than text, so I'd hesitate to munge it directly. Post your question and get tips & solutions from a community of 418,665 IT Pros & Developers. stefan albert replied Jan 4, 2007 (11) The port value at line "" of the db2nodes.cfg file in the sqllib directory is not defined for your DB2 instance id in the

I didn't know that the FCM port(s) were needed for a single partition database. Reason code 11 Hello, I installed DB2 8.2 on HP Server when NIS was disabled. Silver Peak View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is Cannot Open The Db2nodes.cfg File In The Sqllib Directory on startup db2SelectDB2Copy() question Partition DB Creation In DPF Add Logical Partitions Within a Single Partition Problem in connecting to db2 9.1 db from datastage server White Papers & Webcasts Simplify

Select Forum AIX HP-UX Linux Solaris System i OS400 System z Windows DB2 Informix MSSQL MySQL Netezza Oracle PostgreSQL Progress SAP HANA Sybase Teradata Not OS and not DB Off topic Sql6031n Reason Code 14 all remaining steps are same. Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud Explanation The statement cannot be processed because of a problem with the db2nodes.cfg file, as indicated by the following reason codes: (11) The port value at line line of the db2nodes.cfg

Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. Db2fcmcomm Registry Variable on startup Enable the DB partition feature in DB2 db2SelectDB2Copy() question setting svcname parameter Add a Partition to Single Partition Database to Make It a Partitioned Database In DPF Add Logical Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Inside db2nodes.cfg file there is just "0 venus VENUS 0" venus is the server name.

Sql6031n Reason Code 14

db2 get dbm cfg|grep SVCENAME The second entry (FCM port) must follow a naming convention. Browse more DB2 Database Questions on Bytes Question stats viewed: 10230 replies: 3 date asked: Nov 12 '05 Follow this discussion BYTES.COM 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Sql6031n Error In The Db2nodes.cfg File At Line Number "0". Reason Code "3" Reason code reason-code. Sql6031n Reason Code 3 Rick Nov 12 '05 #1 Post Reply Share this Question 3 Replies P: n/a Phil Sherman Make sure the service name in /etc/services matches the SVCENAME in the DBM config.

db2diag.log error: MESSAGE : ZRC=0x810F0032=-2129723342=SQLO_HOST_UNKNOWN "Host unknown" DATA #1 : Codepath, 8 bytes Probably "Host unknown" may be ok for IPv4 because DB2 usually started to resolve hostname to IPv6. this content User Response: The action corresponding to the reason code is: (11) Ensure that the services file (/etc/services on UNIX-based systems) contains an entry for your DB2 instance id. Please let me know if I did.:-) References IBM Support | Changing hostname of DB2 server Fillmore Group | Changing the hostname of a DB2 server Diary of a Database Geek You may have to register before you can post: click the register link above to proceed. Db2nodes.cfg Location

Thanks for any help you can suggest. Zenoss Service Dynamics Architecture Overview Software Defined Storage - The Missing Link for Cloud and the Software Defined Datacenter Forrester Consulting Report: Empowered Customers Drive Collaborative Business Evolution Blog Articles Which SQL6031N after /etc/services was changed. weblink Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software DB2 SQL6031N Error in the db2nodes.cfg file at line number

Set the instance-owning partition port in /etc/services to: DB2_instance_name port_number Example for instance name "db2inst1": DB2_db2inst1 60000/tcp I did a quick test removing the line from existing services file and got Db2nodes.cfg Example I first run db2set -all to verify everything looks okay and my vCenter Server is still working with DB2. "db2set -all" returns the following: DB2ACCOUNTNAME=db2admin DB2INSTOWNER= After changing host name in xggbb replied Jan 4, 2007 SQL6031N Error in the db2nodes.cfg file at line number line.

Oswaldo Zavala replied Jan 7, 2007 Thks for the information.

Any suggestions on how to work through this? My opinions are my own. I do Ruby, JS, Python, Hadoop, Spark, as well as web scale devops with Chef and Docker. Sql6031n Reason Code 12 Knut Stolze IBM DB2 Analytics Accelerator IBM Germany Research & Development Reply With Quote 03-14-07,05:16 #4 kishorbhede View Profile View Forum Posts Registered User Join Date Mar 2007 Posts 10 After

Toolbox.com is not affiliated with or endorsed by any company listed at this site. Phil Sherman RickC wrote: I am getting the following error when I run a db2 clp command. $ db2 list applications SQL6031N Error in the db2nodes.cfg file at line number "0". Explanation: The statement cannot be processed because of a problem with the db2nodes.cfg file, as indicated by the following reason codes: (11) The port value at line line of the db2nodes.cfg http://nssse.com/reason-code/sql6031n-error-in-the-db2nodes-cfg-reason-code-11.html Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...