Oninit cdi / Archive
Talk to an expert →

DBSERVERALIASES entries not displaying correctly

Posted in 2016

Topics: Stored Procedures & SPL, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues

MURALI — — source: IIUG Forums & Mailing Lists

I added two new entries to DBSERVERALIASES ( both wtn_* are new). They were also added to /etc/services and sqlhosts. I restarted the instance after this. The Informix client would not connect to the wtn_ connection. Upon doing 'onstat -c | grep -i dbserver' I do not see the 'wtn_' entries. Here's what it looks like in the onconfig file: DBSERVERNAME nike_ST ##DBSERVERALIASES nike_STTCP DBSERVERALIASES nike_STTCP,nike_sttcp,nike_STTCP_DRDA,wtn_STTCP,wtn_STTCP_DRDA on the onstat -c: uxdev:TESTFC11.7> onstat -c | grep -i dbserver # DBSERVERNAME - The name of the default database server # DBSERVERALIASES - The list of up to 32 alternative dbservernames, DBSERVERNAME nike_ST ##DBSERVERALIASES nike_STTCP DBSERVERALIASES nike_STTCP,nike_sttcp,nike_STTCP_DRDA# DBSERVERNAME or DBSERVERALIASES that uses a select * from sysconfig where cf_name = 'DBSERVERALIASES': cf_id 77 cf_name DBSERVERALIASES cf_flags 0 cf_original nike_STTCP,nike_sttcp,nike_STTCP_DRDA cf_effective nike_STTCP,nike_sttcp,nike_STTCP_DRDA cf_default System: Informix 11.70.FC7, HP-UX ia64 Why am I not seeing the wtn_ entries despite restarting the instance. Thanks.

↪ replying to MURALI
Mike Walker — — source: IIUG Forums & Mailing Lists

Very weird. Silly question, but are you 100% certain that the file that you changed is the one referred to by $ONCONFIG? Check the Informix log file on startup to see if there was something that it didn't like in the config. Mike Walker Advanced DataTools -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MURALI PAZHAYANNUR Sent: Tuesday, March 01, 2016 1:44 PM To: ids@iiug.org Subject: DBSERVERALIASES entries not displaying correctly [36680] I added two new entries to DBSERVERALIASES ( both wtn_* are new). They were also added to /etc/services and sqlhosts. I restarted the instance after this. The Informix client would not connect to the wtn_ connection. Upon doing 'onstat -c | grep -i dbserver' I do not see the 'wtn_' entries. Here's what it looks like in the onconfig file: DBSERVERNAME nike_ST ##DBSERVERALIASES nike_STTCP DBSERVERALIASES nike_STTCP,nike_sttcp,nike_STTCP_DRDA,wtn_STTCP,wtn_STTCP_DRDA on the onstat -c: uxdev:TESTFC11.7> onstat -c | grep -i dbserver # DBSERVERNAME - The name of the default database server # DBSERVERALIASES - The list of up to 32 alternative dbservernames, DBSERVERNAME nike_ST ##DBSERVERALIASES nike_STTCP DBSERVERALIASES nike_STTCP,nike_sttcp,nike_STTCP_DRDA # DBSERVERNAME or DBSERVERALIASES that uses a select * from sysconfig where cf_name = 'DBSERVERALIASES': cf_id 77 cf_name DBSERVERALIASES cf_flags 0 cf_original nike_STTCP,nike_sttcp,nike_STTCP_DRDA cf_effective nike_STTCP,nike_sttcp,nike_STTCP_DRDA cf_default System: Informix 11.70.FC7, HP-UX ia64 Why am I not seeing the wtn_ entries despite restarting the instance. Thanks. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to MURALI
Art Kagel — — source: IIUG Forums & Mailing Lists

Post the sqlhosts entries. Also, look through the online message log (MSGPATH) at around the time you restarted the instance. If it ignored these entries for some valid reason then there should be a note in the message log. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Mar 1, 2016 at 3:44 PM, MURALI PAZHAYANNUR <pmurali@ftportfolios.com > wrote: > I added two new entries to DBSERVERALIASES ( both wtn_* are new). They were > also added to /etc/services and sqlhosts. I restarted the instance after > this. > The Informix client would not connect to the wtn_ connection. > > Upon doing 'onstat -c | grep -i dbserver' I do not see the 'wtn_' entries. > > Here's what it looks like in the onconfig file: > > DBSERVERNAME nike_ST > ##DBSERVERALIASES nike_STTCP > DBSERVERALIASES > nike_STTCP,nike_sttcp,nike_STTCP_DRDA,wtn_STTCP,wtn_STTCP_DRDA> > on the onstat -c: > > uxdev:TESTFC11.7> onstat -c | grep -i dbserver > # DBSERVERNAME - The name of the default database server > # DBSERVERALIASES - The list of up to 32 alternative dbservernames, > DBSERVERNAME nike_ST > ##DBSERVERALIASES nike_STTCP > DBSERVERALIASES nike_STTCP,nike_sttcp,nike_STTCP_DRDA> # DBSERVERNAME or DBSERVERALIASES that uses a > > select * from sysconfig where cf_name = 'DBSERVERALIASES':> > cf_id 77 > cf_name DBSERVERALIASES > cf_flags 0 > cf_original nike_STTCP,nike_sttcp,nike_STTCP_DRDA > cf_effective nike_STTCP,nike_sttcp,nike_STTCP_DRDA > cf_default > > System: Informix 11.70.FC7, HP-UX ia64 > > Why am I not seeing the wtn_ entries despite restarting the instance. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113f8f8e4e0318052d02ffaa

↪ replying to Mike Walker
MURALI — — source: IIUG Forums & Mailing Lists

Thank you, Mike. That was it. We have two versions of Informix in the same box and I was updating the wrong onconfig file and looking at the system table. (I could slap myself for this silly mistake). Thank you for pointing it out.

Related threads

Glossary