Flexible Grid and ER

I'm getting the error "Define ER server.... command failed -- SQLHOSTS file has a problem with (g=) or (i=) option. (119)" my sqlhosts file is as follows g_batman group - - i=487 lintest onsoctcp tfx3 8785 g=g_batman lintest onipcshm tfx3 lintest g_waynemanor group - - i=488 batcave onsoctcp tfx3 5857 g=g_waynemanor batcave onipcshm tfx3 batcave any ideas? both are on a linux box running IDS Verson 11.70.FC4

Original post: I'm getting the error "Define ER server.... command failed -- SQLHOSTS file has a problem with (g=) or (i=) option. (119)" my sqlhosts file is as follows g_batman group - - i=487 lintest onsoctcp tfx3 8785 g=g_batman lintest onipcshm tfx3 lintest g_waynemanor group - - i=488 batcave onsoctcp tfx3 5857 g=g_waynemanor batcave onipcshm tfx3 batcave any ideas? both are on a linux box running IDS Verson 11.70.FC4 Response: Well, I don't think it's going to work if you have duplicate dbservernames for different protocols on the same machine. I didn't set up a test to see if that's the same error I'd get if I tried to do something with the way you have it configured. But I think that is going to be a problem at some point...so you are going to need to change 1 of the 2 lintest lines and 1 of the 2 batcave lines so that all the 1st columns are unique...so maybe just go lintest and lintest2/batcave and batcave2...just make sure you also update the dbservername/dbserveralias values in your onconfig files as well. Jacques Renaut IBM Informix Advanced Support APD Team

Check your environment variable for $INFORMIXSQLHOSTS value - see if it matches your sqlhosts file (the one you altered). Post your complete "cdr define server" command, it´s easier for us to help you.... Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: nathaniel.hicks@trnswrks.com > Subject: Flexible Grid and ER [28028] > Date: Wed, 15 Aug 2012 09:29:44 -0400 > > I'm getting the error "Define ER server.... command failed -- SQLHOSTS file > has a problem with (g=) or (i=) option. (119)" my sqlhosts file is as follows > > g_batman group - - i=487 > lintest onsoctcp tfx3 8785 g=g_batman > lintest onipcshm tfx3 lintest> > g_waynemanor group - - i=488 > batcave onsoctcp tfx3 5857 g=g_waynemanor > batcave onipcshm tfx3 batcave> > any ideas? both are on a linux box running IDS Verson 11.70.FC4 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Another great tip: check the connection between them through dbaccess first, using Connection-> Connect option, the groups must appear there, choose one of them, and see if it works. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant From: alexandre@briug.org To: ids@iiug.org Subject: RE: Flexible Grid and ER [28028] Date: Wed, 15 Aug 2012 09:46:41 -0400 Check your environment variable for $INFORMIXSQLHOSTS value - see if it matches your sqlhosts file (the one you altered). Post your complete "cdr define server" command, it´s easier for us to help you.... Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: nathaniel.hicks@trnswrks.com > Subject: Flexible Grid and ER [28028] > Date: Wed, 15 Aug 2012 09:29:44 -0400 > > I'm getting the error "Define ER server.... command failed -- SQLHOSTS file > has a problem with (g=) or (i=) option. (119)" my sqlhosts file is as follows > > g_batman group - - i=487 > lintest onsoctcp tfx3 8785 g=g_batman > lintest onipcshm tfx3 lintest> > g_waynemanor group - - i=488 > batcave onsoctcp tfx3 5857 g=g_waynemanor > batcave onipcshm tfx3 batcave> > any ideas? both are on a linux box running IDS Verson 11.70.FC4 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Jacques --- You're batting 1000. From: Jacques Renaut/Lenexa/IBM@IBMUS To: ids@iiug.org, Date: 08/15/2012 07:46 AM Subject: Re: Flexible Grid and ER [28029] Sent by: ids-bounces@iiug.org Original post: I'm getting the error "Define ER server.... command failed -- SQLHOSTS = file has a problem with (g=3D) or (i=3D) option. (119)" my sqlhosts file is = as follows g_batman group - - i=3D487 lintest onsoctcp tfx3 8785 g=3Dg_batman lintest onipcshm tfx3 lintest g_waynemanor group - - i=3D488 batcave onsoctcp tfx3 5857 g=3Dg_waynemanor batcave onipcshm tfx3 batcave any ideas? both are on a linux box running IDS Verson 11.70.FC4 Response: Well, I don't think it's going to work if you have duplicate dbserverna= mes for different protocols on the same machine. I didn't set up a test to see = if that's the same error I'd get if I tried to do something with the way y= ou have it configured. But I think that is going to be a problem at some point.= ..so you are going to need to change 1 of the 2 lintest lines and 1 of the 2= batcave lines so that all the 1st columns are unique...so maybe just go= lintest and lintest2/batcave and batcave2...just make sure you also upd= ate the dbservername/dbserveralias values in your onconfig files as well. Jacques Renaut IBM Informix Advanced Support APD Team ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

I removed the SHM connection for lintest and batcave and left the TCP connection to no avail. Still the same error but I'll be leaving them out since I really don't need them anyway. Thanks

The connecting from one to the other works both ways(which I never thought to check :)). The $INFORMIXSQLHOSTS though I tried echo $INFORMIXSQLHOSTS and got nothing so I'm not sure what you were meaning here. Thank you for your help though :)

original post: I removed the SHM connection for lintest and batcave and left the TCP connection to no avail. Still the same error but I'll be leaving them out since I really don't need them anyway. Thanks Response: So am I correct in saying your $INFORMIXDIR/etc/sqlhosts file only contains the following lines now? g_batman group - - i=487 lintest onsoctcp tfx3 8785 g=g_batman g_waynemanor group - - i=488 batcave onsoctcp tfx3 5857 g=g_waynemanor If that's not all that in the file, can you include the whole file? Also, can you include your cdr define server command as well? Jacques Renaut IBM Informix Advanced Support APD Team

Ok if your INFORMIXSQLHOSTS is not set, and your dbaccess is connecting from both sides, you should be doing something wrong in your cdr define server. Please post your command here, with server and group real names defined, so that we could try to see what is going on. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: nathaniel.hicks@trnswrks.com > Subject: Re: RE: Flexible Grid and ER [28035] > Date: Wed, 15 Aug 2012 11:46:13 -0400 > > The connecting from one to the other works both ways(which I never thought to > check :)). The $INFORMIXSQLHOSTS though I tried echo $INFORMIXSQLHOSTS and got > nothing so I'm not sure what you were meaning here. Thank you for your help > though :) > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

yeah that's what's in there. I can cross connect to select/update/insert but cannot add replication.

In OAT it's one of the few screens that doesn't give me the option to see the SQL unfortunately. The group and real names are the ones listed in the sqlhosts. g_batman group - - i=487 lintest onsoctcp tfx3 8785 g=g_batman g_waynemanor group - - i=488 batcave onsoctcp tfx3 5857 g=g_waynemanor

Original Post: eah that's what's in there. I can cross connect to select/update/insert but cannot add replication. Response: Ok from another 1 of your posts it seems you are using OAT to define the server. Can you try it again, and as soon as you get the error, on whatever server you tried to define, can you run onstat -m and post that output? It seems from the code if that error is coming from the server, then there should be an associated error in onstat -m output as well. Also, if OAT is submitting this via the SQL api, which I'd think it would (sorry not a lot of experience using OAT personally), you might do a select * from sysadmin:command_history and that might show the command it tried to run...so see if you have anything in that command_history table with cdr define server in it and post that output if there is any. Jacques Renaut IBM Informix Advanced Support APD Team

If INFORMIXSQLHOSTS is not set to a specific file path then the file $INFORMIXDIR/etc/sqlhosts is used by default, so make sure that your entries are in that file. 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 Wed, Aug 15, 2012 at 11:46 AM, NATE HICKS <nathaniel.hicks@trnswrks.com>wrote: > The connecting from one to the other works both ways(which I never thought > to > check :)). The $INFORMIXSQLHOSTS though I tried echo $INFORMIXSQLHOSTS and > got > nothing so I'm not sure what you were meaning here. Thank you for your help > though :) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae93411196bdb2a04c752383f

Also post the DBSERVERNAME and DBSERVERALIASES lines from the ONCONFIG files from both servers. 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 Wed, Aug 15, 2012 at 12:02 PM, JACQUES RENAUT <jrenaut@us.ibm.com> wrote: > original post: > I removed the SHM connection for lintest and batcave and left the TCP > connection to no avail. Still the same error but I'll be leaving them out > since I really don't need them anyway. Thanks > > Response: > > So am I correct in saying your $INFORMIXDIR/etc/sqlhosts file only contains > the following lines now? > > g_batman group - - i=487 > lintest onsoctcp tfx3 8785 g=g_batman > > g_waynemanor group - - i=488 > batcave onsoctcp tfx3 5857 g=g_waynemanor > > If that's not all that in the file, can you include the whole file? Also, > can > you include your cdr define server command as well? > > Jacques Renaut > IBM Informix Advanced Support > APD Team > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f839b2384a31004c7523d58

'cdr define server', '--ats=/tmp/ats', '--ris=/tmp/ris', '--atsrisformat=text', ' --init g_batman' 'cdr', 'define grid Gotham g_batman ' 'cdr define server', '--ats=/tmp', '--ris=/tmp', '--atsr isformat=text', '--leaf', '--sync=g_batman --init g_waynemanor' 'cdr define server', '--ats=/tmp', '--ris=/tmp', '--atsr isformat=text', '--nonroot', '--sync=g_batman --init g_wayneman or' cmd_ret_status 119 cmd_ret_msg command failed -- SQLHOSTS file has a problem with (g=) or (i=) option. (119) command_history worked and thank you for that one! the first two were from lintest which will be the source the second two were from batcave and the exit/error code is underneath. Thank you

Original post: cdr define server', '--ats=/tmp/ats', '--ris=/tmp/ris', '--atsrisformat=text', ' --init g_batman' 'cdr', 'define grid Gotham g_batman ' 'cdr define server', '--ats=/tmp', '--ris=/tmp', '--atsr isformat=text', '--leaf', '--sync=g_batman --init g_waynemanor' 'cdr define server', '--ats=/tmp', '--ris=/tmp', '--atsr isformat=text', '--nonroot', '--sync=g_batman --init g_wayneman or' cmd_ret_status 119 cmd_ret_msg command failed -- SQLHOSTS file has a problem with (g=) or (i=) option. (119) command_history worked and thank you for that one! the first two were from lintest which will be the source the second two were from batcave and the exit/error code is underneath. Thank you Response: Hmm, I set up a 2 system test and tried to run the above 4 cdr commands and my 4th command fails as well, but I'm not failing with error 119, I'm failing with error 75 "request denied on limited server". I'm also using 11.70.FC4 on Linux. I was not using OAT, I just tried to run the above commands from the command line. Can you try that and see if you get the same error (run the 1st 2 command with env pointing to lintest and then the 2nd 2 command with your env pointing to batcave)? I'm not sure if this is an OAT bug and the commands it's trying to run are incorrect, or a server problem. At this point though, if you have support it's probably worth opening a PMR. Jacques Renaut IBM Informix Advanced Support APD Team

If this is from OAT, then OAT is not creating the correct command line= . The parameters can not start with a leading space such as ' --init...'= . That will cause problems because the cdr utility will not be able to pa= rse the input parameters. The reason that you are getting a problem is bec= ause the cdr utility is thinking that the server name is " --init g_batman"= which of course is not in your sqlhostfile. Try running the commands as user informix. cdr define server -c g_batman --ats=3D/tmp/ats --ris=3D/tmp/ris --init = g_batman cdr define server -c g_wayneman --ats=3D/tmp/ats --ris=3D/tmp/ris --sync=3Dg_batman --init g_wayneman cdr define grid -c g_batman Gotham --all From: Jacques Renaut/Lenexa/IBM@IBMUS To: ids@iiug.org, Date: 08/16/2012 07:13 AM Subject: Re: Flexible Grid and ER [28061] Sent by: ids-bounces@iiug.org Original post: cdr define server', '--ats=3D/tmp/ats', '--ris=3D/tmp/ris', '--atsrisformat=3Dtext', ' --init g_batman' 'cdr', 'define grid Gotham g_batman ' 'cdr define server', '--ats=3D/tmp', '--ris=3D/tmp', '--atsr isformat=3Dtext', '--leaf', '--sync=3Dg_batman --init g_waynemanor' 'cdr define server', '--ats=3D/tmp', '--ris=3D/tmp', '--atsr isformat=3Dtext', '--nonroot', '--sync=3Dg_batman --init g_wayneman or' cmd_ret_status 119 cmd_ret_msg command failed -- SQLHOSTS file has a problem with (g=3D) o= r (i=3D) option. (119) command_history worked and thank you for that one! the first two were f= rom lintest which will be the source the second two were from batcave and t= he exit/error code is underneath. Thank you Response: Hmm, I set up a 2 system test and tried to run the above 4 cdr commands= and my 4th command fails as well, but I'm not failing with error 119, I'm fail= ing with error 75 "request denied on limited server". I'm also using 11.70.= FC4 on Linux. I was not using OAT, I just tried to run the above commands from= the command line. Can you try that and see if you get the same error (run t= he 1st 2 command with env pointing to lintest and then the 2nd 2 command with = your env pointing to batcave)? I'm not sure if this is an OAT bug and the commands it's trying to run are incorrect, or a server problem. At this point though, if you have support it's probably worth opening a PMR. Jacques Renaut IBM Informix Advanced Support APD Team ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =