sqlhosts file
A DBA asked how to see the sqlhosts connectivity settings an already-running UNIX instance actually started with, since the file (location possibly overridden by INFORMIXSQLHOSTS) had been edited afterwards. The answer given: query sysmaster:syssqlhosts, which the poster accepted as what she needed, though Art Kagel cautioned that this pseudo-table simply reads the current sqlhosts file like an external table, so post-startup edits show up and the original values are not recoverable. A follow-up question about whether IDS caches sqlhosts (and about onmode -q and DS_TOTAL_TMPSPACE documentation) got only a suggestion to test it empirically, with no definite answer.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
On UNIX, the sqlhosts file contains connectivity information that is loaded from the default location in $INFORMIXDIR/etc/sqlhosts, when the database server is started. My problem is, the sqlhosts file gets changed after the server is started, and I do not know where or how I can find the "currently used" sqlhost information. Is there a command that will allow me to view the values in the sqlhosts file when the server was started and the values currently in use? (I need this info to see what Connection Manager groups are set up on the server.) Thanks in advance.
Hello. If your sqlhosts default file was renamed, or located to a new path/file, you should see an INFORMIXSQLHOSTS environment variable, pointing to it´s actual path and file. In sysmaster:syssqlhosts table, you can see your actual configurations. I just don´t know if they are loaded when sysmaster is build (instance creation), or as soon as you start your engine... maybe some friend can clarify this information. Hope this helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: uricha@mcao.maricopa.gov > Subject: sqlhosts file [31121] > Date: Fri, 9 Aug 2013 12:24:10 -0400 > > On UNIX, the sqlhosts file contains connectivity information that is loaded > from the default location in $INFORMIXDIR/etc/sqlhosts, when the database > server is started. > > My problem is, the sqlhosts file gets changed after the server is started, and > I do not know where or how I can find the "currently used" sqlhost > information. > > Is there a command that will allow me to view the values in the sqlhosts file > when the server was started and the values currently in use? (I need this info > to see what Connection Manager groups are set up on the server.) > > Thanks in advance. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
The sysmaster:syssqlhosts pseudo table just reads the sqlhosts file as if it is an external table, so if someone modified the file after the server started you will only see the new version, not the original. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Aug 9, 2013 at 2:33 PM, Alexandre Marini <alexandre@briug.org>wrote: > Hello. > If your sqlhosts default file was renamed, or located to a new path/file, > you > should see an INFORMIXSQLHOSTS environment variable, pointing to it actual > path and file. > > In sysmaster:syssqlhosts table, you can see your actual configurations. I > just > don know if they are loaded when sysmaster is build (instance creation), > or > as soon as you start your engine... maybe some friend can clarify this > information. > > Hope this helps. > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 > > IBM Information Management Informix Technical Professional > > IBM Infosphere DataStage Technical Professional > Informix Senior DBA - Orizon Brasil > BRIUG website administrator > Informix independent consultant > > > To: ids@iiug.org > > From: uricha@mcao.maricopa.gov > > Subject: sqlhosts file [31121] > > Date: Fri, 9 Aug 2013 12:24:10 -0400 > > > > On UNIX, the sqlhosts file contains connectivity information that is > loaded > > from the default location in $INFORMIXDIR/etc/sqlhosts, when the database > > server is started. > > > > My problem is, the sqlhosts file gets changed after the server is > started, > and > > I do not know where or how I can find the "currently used" sqlhost > > information. > > > > Is there a command that will allow me to view the values in the sqlhosts > file > > when the server was started and the values currently in use? (I need this > info > > to see what Connection Manager groups are set up on the server.) > > > > Thanks in advance. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c365a61e439304e388365c
Thank you! Exactly what I needed. I didn't think it was available in the sysmaster database... :)
Art,
Do you know if IDS does any caching of sqlhosts or does it reread sqlhosts for
every new remote connection?
Whilst IDS 12 does have NS_CACHE for caching OS lookups there is nothing for
sqlhosts caching.
IBM,
Checking the onstat -g env documentation for IDS 12.10 it mentions "onmode -q
pdqpriority sessionid" to change the PDQPRIORITY but this is documented or
listed
in the output of onmode --. Are there plans to document this?
Are there plans to add DS_TOTAL_TMPSPACE functionality from XPS into IDS?
Regards,
David.
On 09 August 2013 at 19:47 Art Kagel <art.kagel@gmail.com> wrote:
> The sysmaster:syssqlhosts pseudo table just reads the sqlhosts file as if
> it is an external table, so if someone modified the file after the server
> started you will only see the new version, not the original.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Aug 9, 2013 at 2:33 PM, Alexandre Marini <alexandre@briug.org>wrote:
>
> > Hello.
> > If your sqlhosts default file was renamed, or located to a new path/file,
> > you
> > should see an INFORMIXSQLHOSTS environment variable, pointing to it actual
> > path and file.
> >
> > In sysmaster:syssqlhosts table, you can see your actual configurations. I
> > just
> > don know if they are loaded when sysmaster is build (instance creation),
> > or
> > as soon as you start your engine... maybe some friend can clarify this
> > information.
> >
> > Hope this helps.
> > Regards.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Infosphere DataStage Technical Professional
> > Informix Senior DBA - Orizon Brasil
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: uricha@mcao.maricopa.gov
> > > Subject: sqlhosts file [31121]
> > > Date: Fri, 9 Aug 2013 12:24:10 -0400
> > >
> > > On UNIX, the sqlhosts file contains connectivity information that is
> > loaded
> > > from the default location in $INFORMIXDIR/etc/sqlhosts, when the database
> > > server is started.
> > >
> > > My problem is, the sqlhosts file gets changed after the server is
> > started,
> > and
> > > I do not know where or how I can find the "currently used" sqlhost
> > > information.
> > >
> > > Is there a command that will allow me to view the values in the sqlhosts
> > file
> > > when the server was started and the values currently in use? (I need this
> > info
> > > to see what Connection Manager groups are set up on the server.)
> > >
> > > Thanks in advance.
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c365a61e439304e388365c
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Most of the onmode environment changing options are not well documented.
The entire -wm/-wf suite of options isn't well documented for example.
Don't know what their plans are for fixing this, but you can write to the
documentation team, they are very responsive in my experience. On the XPS
config parameter, I have no idea.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Aug 12, 2013 at 7:31 PM, david@smooth1.co.uk
<david@smooth1.co.uk>wrote:
> **
>
> Art,
>
> Do you know if IDS does any caching of sqlhosts or does it reread
> sqlhosts for every new remote connection?
>
> Whilst IDS 12 does have NS_CACHE for caching OS lookups there is nothing
> for sqlhosts caching.
>
> IBM,
>
> Checking the onstat -g env documentation for IDS 12.10 it mentions
> "onmode -q pdqpriority sessionid" to change the PDQPRIORITY but this is
> documented or listed
> in the output of onmode --. Are there plans to document this?
>
> Are there plans to add DS_TOTAL_TMPSPACE functionality from XPS into IDS?
>
> Regards,
> David.
>
> On 09 August 2013 at 19:47 Art Kagel <art.kagel@gmail.com> wrote:
> > The sysmaster:syssqlhosts pseudo table just reads the sqlhosts file as
> if
> > it is an external table, so if someone modified the file after the
> server
> > started you will only see the new version, not the original.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Aug 9, 2013 at 2:33 PM, Alexandre Marini
<alexandre@briug.org>wrote:
>
> >
> > > Hello.
> > > If your sqlhosts default file was renamed, or located to a new
> path/file,
> > > you
> > > should see an INFORMIXSQLHOSTS environment variable, pointing to it
> actual
> > > path and file.
> > >
> > > In sysmaster:syssqlhosts table, you can see your actual
> configurations. I
> > > just
> > > don know if they are loaded when sysmaster is build (instance
> creation),
> > > or
> > > as soon as you start your engine... maybe some friend can clarify this
> > > information.
> > >
> > > Hope this helps.
> > > Regards.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Infosphere DataStage Technical Professional
> > > Informix Senior DBA - Orizon Brasil
> > > BRIUG website administrator
> > > Informix independent consultant
> > >
> > > > To: ids@iiug.org
> > > > From: uricha@mcao.maricopa.gov
> > > > Subject: sqlhosts file [31121]
> > > > Date: Fri, 9 Aug 2013 12:24:10 -0400
> > > >
> > > > On UNIX, the sqlhosts file contains connectivity information that is
> > > loaded
> > > > from the default location in $INFORMIXDIR/etc/sqlhosts, when the
> database
> > > > server is started.
> > > >
> > > > My problem is, the sqlhosts file gets changed after the server is
> > > started,
> > > and
> > > > I do not know where or how I can find the "currently used" sqlhost
> > > > information.
> > > >
> > > > Is there a command that will allow me to view the values in the
> sqlhosts
> > > file
> > > > when the server was started and the values currently in use? (I need
> this
> > > info
> > > > to see what Connection Manager groups are set up on the server.)
> > > >
> > > > Thanks in advance.
> > > >
> > > >
> > > >
> > >
> > >
> >
>
*******************************************************************************
>
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
*******************************************************************************
>
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c365a61e439304e388365c
> >
> >
> >
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
--001a1133f7267a8c1104e3c91e26
Oh, easy enough to test the caching of sqlhosts. Start the server, add a
new entry for a remote server, try a distributed query that includes that
entry.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Aug 12, 2013 at 7:31 PM, david@smooth1.co.uk
<david@smooth1.co.uk>wrote:
> Art,
>
> Do you know if IDS does any caching of sqlhosts or does it reread sqlhosts
> for
> every new remote connection?
>
> Whilst IDS 12 does have NS_CACHE for caching OS lookups there is nothing
> for
> sqlhosts caching.
>
> IBM,
>
> Checking the onstat -g env documentation for IDS 12.10 it mentions "onmode
> -q
> pdqpriority sessionid" to change the PDQPRIORITY but this is documented or
> listed
> in the output of onmode --. Are there plans to document this?
>
> Are there plans to add DS_TOTAL_TMPSPACE functionality from XPS into IDS?
>
> Regards,
> David.
>
> On 09 August 2013 at 19:47 Art Kagel <art.kagel@gmail.com> wrote:
> > The sysmaster:syssqlhosts pseudo table just reads the sqlhosts file as if
> > it is an external table, so if someone modified the file after the server
> > started you will only see the new version, not the original.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Aug 9, 2013 at 2:33 PM, Alexandre Marini <alexandre@briug.org
> >wrote:
> >
> > > Hello.
> > > If your sqlhosts default file was renamed, or located to a new
> path/file,
> > > you
> > > should see an INFORMIXSQLHOSTS environment variable, pointing to it
> actual
> > > path and file.
> > >
> > > In sysmaster:syssqlhosts table, you can see your actual
> configurations. I
> > > just
> > > don know if they are loaded when sysmaster is build (instance
> creation),
> > > or
> > > as soon as you start your engine... maybe some friend can clarify this
> > > information.
> > >
> > > Hope this helps.
> > > Regards.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Infosphere DataStage Technical Professional
> > > Informix Senior DBA - Orizon Brasil
> > > BRIUG website administrator
> > > Informix independent consultant
> > >
> > > > To: ids@iiug.org
> > > > From: uricha@mcao.maricopa.gov
> > > > Subject: sqlhosts file [31121]
> > > > Date: Fri, 9 Aug 2013 12:24:10 -0400
> > > >
> > > > On UNIX, the sqlhosts file contains connectivity information that is
> > > loaded
> > > > from the default location in $INFORMIXDIR/etc/sqlhosts, when the
> database
> > > > server is started.
> > > >
> > > > My problem is, the sqlhosts file gets changed after the server is
> > > started,
> > > and
> > > > I do not know where or how I can find the "currently used" sqlhost
> > > > information.
> > > >
> > > > Is there a command that will allow me to view the values in the
> sqlhosts
> > > file
> > > > when the server was started and the values currently in use? (I need
> this
> > > info
> > > > to see what Connection Manager groups are set up on the server.)
> > > >
> > > > Thanks in advance.
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c365a61e439304e388365c
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0158cb92feeda604e3c92125