Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Db2 creates an instance The host name & quot;fordatabase" is invalid. Specify a valid host name.

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

There is such a phenomenon that after DB2 installation, when using db2icrt to create an instance, the host name is invalid, and the prompt is as follows:

[plain] view plain copy

[root@centos-0 instance]# ./ db2icrt -u db2inst1 db2inst1

The host name "centos-0.msdomain" is invalid. Specify a valid host name.

DBI1922N The host name is not valid.

Explanation:

The TCP/IP host name parameter is not valid or does not exist.

User response:

Ensure that TCP/IP is operational on the system. If a domain name server

is used, ensure that the domain name server machine is active. Issue the

command again using the correct TCP/IP host name.

DBI1079I Output is saved in the log file /tmp/db2icrt.log.2816.

Explanation:

All processed and failed operations have been saved into this log file.

User response:

Do not modify this file in any way. This file is for IBM Technical

Support reference.

/opt/ibm/db2/V9.7/instance/db2iutil: line 2528: DB2INSTVER: parameter null or not set

Check the/opt/ibm/db2/V9.7/instance/db2iutil file (unprompted line 2528) and find the following

[plain] view plain copy

${DB2DIR?}/ instance/db2isrv -addfcm -i ${INSTNAME?} ${DB2ISRVOPTS?}

if [ $? -eq 3 ]; then

db2isrv

${DB2DIR?}/ instance/db2isrv -addfcm -i ${INSTNAME?} ${DB2ISRVOPTS?}

if [ $? -eq 3 ]; then

display_msg ${DB2CAT?} 922 \

'DBI1922N The host name is not valid.\ n' stop_prog 1 fi

is when db2isrv -addcfm -i ${INSTNAME?} ${DB2ISRVOPTS?} The host name is incorrect when 3 is returned.

This db2isrv looked for a lot of things, did not find specific content, see the name is to add a service to the system. This is followed by addfmc, which is DB2's fault daemon.

This is to monitor the normal operation of the DB2 instance, and when the instance is down abnormally, it will automatically start the instance. The above errors can be linked:

Adding another DB2 daemon to the system failed because the hostname was incorrect.

Okay, look at the hostname definition.

[root@centos-0 instance]# hostname

centos-0.msdomainThis is OK

look at

[root@centos-0 instance]# vi /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

I don't know why this place has not been modified after CENTOS is installed. Modify it. read along the following lines

[root@centos-0 instance]# vi /etc/hosts

127.0.0.1 localhost centos.msdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

Save Executes Create Instance Again, OK

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report