recover SQLHOSTS file
A user's SQLHOSTS file became zero-sized, losing all 21 instance entries on Informix 9.40.FC9. Initial suggestion was to manually recreate the file or check client machines for backups. A proposed solution was querying sysmaster:syssqlhosts table, but this was corrected—that table only reads from the current SQLHOSTS file, so it cannot recover lost entries. No complete resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, We have Informix Dynamic Server Version 9.40.FC9 running on HP-UX B.11.23. We have 21 instances running on the server. All of a sudden the SQLHOSTS file has turned to zero size (not sure how), all the entries are lost. we are not able to access any of the databases. Is there any way by which these entries can be recovered apart from the usual file level restore. Thanks in advance. Regards, Sushant
Determine the servernames and port numbers for each server and rewrite the sqlhosts file manually or shutdown (ie kill) all of the servers and create a new sqlhosts file with possibly new ports and restart everything using that. See if any client machines have an sqlhosts file you can steal! 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 Tue, Jul 16, 2013 at 10:15 AM, SUSHANT KODE <ksushants@gmail.com> wrote: > Hi, > > We have Informix Dynamic Server Version 9.40.FC9 running on HP-UX B.11.23. > We > have 21 instances running on the server. All of a sudden the SQLHOSTS file > has > turned to zero size (not sure how), all the entries are lost. we are not > able > to access any of the databases. Is there any way by which these entries > can be > recovered apart from the usual file level restore. > > Thanks in advance. > > Regards, > Sushant > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c356e2082a0e04e1a206a7
Thanks Art for the response. Is there any way by which sqlhosts file can also be backed up with the dbspaces? Also are there any tables in sysmaster database to recover the values in sqlhosts file?
Ooo, yes! I always forget about that. Look at:
Select * from sysmaster:syssqlhosts;
It definitely exists in v12.10, don't remember when it first showed up.
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 Tue, Jul 16, 2013 at 11:58 AM, SUSHANT KODE <ksushants@gmail.com> wrote:
> Thanks Art for the response.
>
> Is there any way by which sqlhosts file can also be backed up with the
> dbspaces?
> Also are there any tables in sysmaster database to recover the values in
> sqlhosts file?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01493380d6673b04e1a32722
the sysmaster:syssqlhosts reads and present the data from the
current sqlhost file. So if the current sqlhost file is of zero size this
table will not show any rows.
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 07/16/2013 09:06:25 AM:
> From: "Art Kagel" <art.kagel@gmail.com>
> To: ids@iiug.org,
> Date: 07/16/2013 09:08 AM
> Subject: Re: recover SQLHOSTS file [30853]
> Sent by: ids-bounces@iiug.org
>
> Ooo, yes! I always forget about that. Look at:
>
> Select * from sysmaster:syssqlhosts;>
> It definitely exists in v12.10, don't remember when it first showed up.
>
> 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 Tue, Jul 16, 2013 at 11:58 AM, SUSHANT KODE <ksushants@gmail.com>
wrote:
>
> > Thanks Art for the response.
> >
> > Is there any way by which sqlhosts file can also be backed up with the
> > dbspaces?
> > Also are there any tables in sysmaster database to recover the values
in
> > sqlhosts file?
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e01493380d6673b04e1a32722
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Do the onconfig files also have that info?