extrange problem with star
Related threads
- SESSION_LIMIT_MEMORY
- System Or Internal Error InterruptedIOException
- 25582 error on high volume of short live trans
- Error communicating IDS with ONLINE
- ASF Echo-Thread Server: asfcode = -25582 oserr = 4
Posted in 2003
Topics: Server Administration
Hi all,
Im using remote conections from a Server A (solaris 8, informix
7.31.UD1) to an other server B (SCO Unix 5.0.5, informix 5.10.UC1)
The conection between both server is working
Connected (loged) in the server A,
case 1) I run dbaccess, select a database "datos" and
execute the next sql statement:
select * from base@confdb:printers
The sql work showing the results...
base is the name of a database on the server B
confdb is the name of the "star" conection.
Then, I run the next sql statement
select * from confina@confdb:clientes
they show the results....
case 2) I exit from dbaccess, run it again, select the
database "datos" and try to run the next sql
select * from confina@confdb:clientes (witch work in case 1)
they show
936: Error on remote connection, confdb, conerr=-25582, oserr=8,
errstr=.
If I runn the case 1 again, still work.
Some idea? thank's
Gustavo Tobares
Administrador de Sistemas y DBA
Centro de Computos - Red Megatone
TE: 0342-4500972 - Fax: 0342-4500940
Gustavo Tobares wrote:
> Im using remote conections from a Server A (solaris 8, informix
> 7.31.UD1) to an other server B (SCO Unix 5.0.5, informix 5.10.UC1)
>
> The conection between both server is working
>
> Connected (loged) in the server A,
>
> case 1) I run dbaccess, select a database "datos" and
> execute the next sql statement:
>
> select * from base@confdb:printers>
> The sql work showing the results...
>
> base is the name of a database on the server B
> confdb is the name of the "star" conection.
>
> Then, I run the next sql statement
>
> select * from confina@confdb:clientes>
> they show the results....
>
> case 2) I exit from dbaccess, run it again, select the
> database "datos" and try to run the next sql
>
> select * from confina@confdb:clientes (witch work in case 1)>
> they show
>
> 936: Error on remote connection, confdb, conerr=-25582, oserr=8,
> errstr=.>
> If I runn the case 1 again, still work.
>
>
> Some idea? thank's
Pretty weird. oserr = 8 => ENOEXEC, which might mean that there is a
problem with some program being in the wrong format. I'm not sure why
that would be happening every other time - I'm clutching at straws
here. Any chance you have two sqlexecd processes running, and one has
the wrong configuration? I don't think it should be possible, but
then neither should the scenario you're seeing, yet you are seeing it.
> Gustavo Tobares
> Administrador de Sistemas y DBA
> Centro de Computos - Red Megatone
> TE: 0342-4500972 - Fax: 0342-4500940
>
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.