SQLHosts File

Hi I've trying to find out the effects/impact of changing the SQLhosts file on a running engine. Background. I have a live running engine on a server and want add a second instance to undertake some testing. Obviously this will need entries in the SQLhosts file, can I make these with the live instance still running and secondly will the live instance recognize these changes (ie will I be able to access the test instance from the live instance). Keith

Yes, it is safe to add another server to the sqlhosts file while an instance is running. No, I do not believe that it will be recognized by that instance until you bounce it. 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, Nov 13, 2012 at 6:21 AM, Keith Simmons <smiley73@gmail.com> wrote: > Hi > > I've trying to find out the effects/impact of changing the SQLhosts > file on a running engine. > Background. I have a live running engine on a server and want add a > second instance to > undertake some testing. Obviously this will need entries in the > SQLhosts file, can I make > these with the live instance still running and secondly will the live > instance recognize > these changes (ie will I be able to access the test instance from the > live instance). > > Keith > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f235483f2565b04ce613a16