help with informix on windows oncheck -pr error
Posted in 2012
User running oncheck -pr on Informix 11.50 for Windows received an error about invalid characters in DBSERVERNAME/DBSERVERALIASES, citing a hostname with hyphens (HVGREYST19.st-network.maf.govt.nz). Respondents identified that hyphens are not allowed in Windows Informix server names, unlike on Unix. Suggestion was to use underscores instead of hyphens or avoid special characters entirely when naming instances.
Topics: Installation, Setup & Upgrades, Server Administration, Networking & sqlhosts Configuration, Third-Party Tools & Monitoring, Versions, Editions & End-of-Life
IBM Informix Dynamic Server Version 11.50.FC9DE
I am installing informix on windows for first time / I assume oncheck performs
ok on windows as on Unix.
When running oncheck -pr i get following message.
>
C:\\\\Users\\\\oliverk-admin>oncheck -pr
Invalid character(s) in DBSERVERNAME or DBSERVERALIASES
HVGREYST19.st-network.maf.govt.nz).
Error in value of a parameter in the ONCONFIG file.
Yet instance is up and running so is this a misleading message ?
How do people mange informix on windows besides command line - OAT ?
For purposes of communication, you cannot had hyphens in the name of a =
Windows Informix engine.
j.
On Aug 12, 2012, at 9:28 PM, KARL OLIVER wrote:
> IBM Informix Dynamic Server Version 11.50.FC9DE=20
>=20
> I am installing informix on windows for first time / I assume oncheck =
performs=20
> ok on windows as on Unix.=20
> When running oncheck -pr i get following message.=20
>>=20
> C:\\\\Users\\\\oliverk-admin>oncheck -pr=20
> Invalid character(s) in DBSERVERNAME or DBSERVERALIASES=20
> HVGREYST19.st-network.maf.govt.nz).=20
>=20
> Error in value of a parameter in the ONCONFIG file.=20
>=20
> Yet instance is up and running so is this a misleading message ?=20
> How do people mange informix on windows besides command line - OAT ?=20=
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
we have underscore _ they ok in names?
Sorry - bad eyes. I would try creating an instance without underscores = - or any "special" characters and see how uncheck works. j. On Aug 12, 2012, at 9:46 PM, KARL OLIVER wrote: > we have underscore _ they ok in names?=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20
On Sun, Aug 12, 2012 at 6:46 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > we have underscore _ they ok in names? > Your previous email mentioned: > HVGREYST19.st-network.maf.govt.nz). That looks more like a hyphen than an underscore. My standard naming convention on Unix-like systems is host_NN where NN is the server number; underscores on Unix are fine in the server name. I also work on a few machines where the host name contains a hyphen: xyzvm-a123, etc. On those machines, I can't use the dash in the hostname; I map it to underscore (so xyzvm_a123_13, etc). -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --14dae9d717be816fc904c7200fe5
What do you have on DBSERVERNAME and DBSERVERALIAS?
Can you make sure the %ONCONFIG% file doesn't have any strange character
near those parameters?
Regards.
On Mon, Aug 13, 2012 at 2:28 AM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote:
> IBM Informix Dynamic Server Version 11.50.FC9DE
>
> I am installing informix on windows for first time / I assume oncheck
> performs
> ok on windows as on Unix.
> When running oncheck -pr i get following message.
> >
> C:\\\\Users\\\\oliverk-admin>oncheck -pr
> Invalid character(s) in DBSERVERNAME or DBSERVERALIASES
> HVGREYST19.st-network.maf.govt.nz).
>
> Error in value of a parameter in the ONCONFIG file.
>
> Yet instance is up and running so is this a misleading message ?
> How do people mange informix on windows besides command line - OAT ?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--485b397dd7292b1db404c7234707