Error On Db2nodes.cfg
AN INSTANCE WITH DB2ICRT. z/os Fixes are available DB2 Version 9.5 Fix Pack 6afor Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 7for Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 8for Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 9for Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 10for Linux, UNIX, and Windows Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description User's may face the SQL6031N (reason code 11) error message when running db2icrt. Here is the description of this error: SQL6031N Error in the db2nodes.cfg file at line number line. Reason code reason-code. 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 file in the sqllib directory is not defined for your DB2 instance id in the services file (/etc/services on UNIX-based systems). 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 article: db2icrt failed due to a mis-configured /etc/hosts file on AIX http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21306113 After correcting /etc/hosts, re-issue the db2icrt command. Problem summary **************************************************************** * USERS AFFECTED: * * Unknown * **************************************************************** * PROBLEM DESCRIPTION: * * User's may face the SQL6031N (reason code 11) error * * messagewhenrunning db2icrt. Here is the description of this * * error:SQL6031NError in the db2nodes.cfg file at line number * * line. Reasoncodereason-code.ExplanationThe statement cannot * * be processed because of a problem withthedb2nodes.cfg file, * * as indicated by the following reasoncodes:(11)The port value * * at line line of the db2nodes.cfg file inthesqllib directory * * is not defined for your DB2 instance id intheservices file * * (/etc/services on UNIX-based systems). * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 6 or use one of * * thefollowing Local Fixes:1) Manually insert entries on * * /etc/services file and re-rundb2icrt2) Please check and * * correct /etc/hosts file as per thefollowingarticle:db2icrt * * failed due to a mis-configured /etc/hosts file * * onAIXhttp://www-01.ibm.com
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: Problem with "db2nodes.cfg" file Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-26-09,06:55 http://www.ibm.com/support/docview.wss?uid=swg1IC67141 #1 prashant44 View Profile View Forum Posts Registered User Join Date Feb 2008 Posts 62 Unanswered: Problem with "db2nodes.cfg" file Hello, I am using db2 v9.1 on windows. I could not start or update the db2 instance; even for any db2 command it is giving the same following error: SQL6031N Error in the db2nodes.cfg file at line number http://www.dbforums.com/showthread.php?1641636-Problem-with-quot-db2nodes-cfg-quot-file "0". Reason code "3". I checked the file db2nodes.cfg file in ...\sqllib\db2\ directory & its permission, its all seems to be correct. Correct Hostname and node number is properly specified there. I am not able to get the solution. For me its all seems to be fine. Can you please help me or give some clue for finding the solution? Regards, Prashant Reply With Quote 04-26-09,15:00 #2 db2dummy1 View Profile View Forum Posts Registered User Join Date Feb 2009 Posts 114 SQL6031N Error in the db2nodes.cfg file at line number "
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing https://scn.sap.com/thread/3323926 and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket error on with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices error on db2nodes.cfg ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData ManagementEnterprise ManagementFinancial ManagementHuman Capital Manage