IDS 10
Solaris 10
Sun V480

We changed the name of our server by editing the onconfig file and changing
the user informix env var INFORMIXSERVER.

Everything works just fine.

'onstat -g env' still reports the old name for INFORMIXSERVER. As a matter
of curiosity, I'm wondering where "onstat" gets the value it reports?

Regards,

DG

"Jonathan Leffler" <jleffler@earthlink.net> wrote in message
news:Wdsnf.2409$n1.598@newsread2.news.pas.earthlin k.net...
> David E. Grove wrote:
>> IDS 10
>> Solaris 10
>> Sun V480
>>
>> We changed the name of our server by editing the onconfig file and
>> changing
>> the user informix env var INFORMIXSERVER.
>>
>> Everything works just fine.
>>
>> 'onstat -g env' still reports the old name for INFORMIXSERVER. As a
>> matter
>> of curiosity, I'm wondering where "onstat" gets the value it reports?
>
> The value of INFORMIXSERVER when you started the server.
>
> If you've not restarted the server, the value of $INFORMIXSERVER hasn't
> changed (yet) - but it sounds like it will when you restart.

And will presumably fail when you restart unless you've changed sqlhosts
also.

David E. Grove wrote:
> IDS 10
> Solaris 10
> Sun V480
>
> We changed the name of our server by editing the onconfig file and changing
> the user informix env var INFORMIXSERVER.
>
> Everything works just fine.
>
> 'onstat -g env' still reports the old name for INFORMIXSERVER. As a matter
> of curiosity, I'm wondering where "onstat" gets the value it reports?

The value of INFORMIXSERVER when you started the server.

If you've not restarted the server, the value of $INFORMIXSERVER hasn't
changed (yet) - but it sounds like it will when you restart.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

> The value of INFORMIXSERVER when you started the server.
>
> If you've not restarted the server, the value of $INFORMIXSERVER hasn't
> changed (yet) - but it sounds like it will when you restart.
>

That's sort of what made me curious, because we have bounced the server.
Bounced the box, too.

No complaints, everything is working fine. But, it made me wonder.

DG

>
> And will presumably fail when you restart unless you've changed sqlhosts
> also.
>
>

I did change sqlhosts.

Restarts just fine. Works just fine.

DG

>
> 'onstat -g env' still reports the old name for INFORMIXSERVER. As a
matter
> of curiosity, I'm wondering where "onstat" gets the value it reports?
>

Someone emailed me and suggested that the data probably came from the
reserved pages. It's got to be nonvolatile storage, so I guess that must be
it. I wonder how many INFORMIXSERVER name changes are tracked that way.

But, the real question... Even though everything seems to be OK, is there
some non-immediately-visible issue that's going to bite me in the future
when I least expect it?

DG

So you have restarted and onstat -g env still shows the old value?

And this is not in the environment of the server when it is started
Add to the startup file env > /mydir/env.$INFORMIXSERVER.date
'+whatever gives to the second accuracy'
since I assume you will not start 2 instances in the same second. Put
in a sleep 5 between instance starts
if needed since it is probably a bad idea from machine load to start
several instances in parallel.

What does oncheck -cr give? Any reserved page differences?

David.