Hi all

When I try to connect to an remote database I get the following error
message:

"The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "Invalid Request type
for
DB2 Admin Server".)"

I had cataloged it before with
'db2 Catalog database <db> at <remotenode>'
db2 terminate
db2stop
db2start

Both, remote and local database are an old version 6.1.0 on Linux.

Thanks for any hint
Stefan

Stefan Amann wrote:
> Hi all
>
> When I try to connect to an remote database I get the following error
> message:
>
> "The SQL statement failed because of a non-severe system error.
> Subsequent SQL statements can be processed. (Reason "Invalid Request type
> for
> DB2 Admin Server".)"
>
> I had cataloged it before with
> 'db2 Catalog database <db> at <remotenode>'
> db2 terminate
> db2stop
> db2start
>
> Both, remote and local database are an old version 6.1.0 on Linux.
>
> Thanks for any hint
> Stefan
>
>
Hi Stefan,

try using this->

catalog tcpip node yourDatabase remote 192.168.1.1 server 50003
then
catalog database aliasyourDatabase(can be anything you want) at node
yourDatabase
then
connect to yourDatabase user USERNAME using PASSWORD

I hope i could help you.

Cya,

Fabian

Hello Fabian

I already had cataloged the tcpip node before to catalog another database,
but someone had changed the node name meanwhile. That was the problem. I now
uncataloged the DB and cataloged it with the new nodename and now it works
fine.

Thank you for help
Stefan


"hauger" <F.Knopf@gmx.de> wrote in message
news:2v0r8dF2fj8u3U1@uni-berlin.de...
> Stefan Amann wrote:
> > Hi all
> >
> > When I try to connect to an remote database I get the following error
> > message:
> >
> > "The SQL statement failed because of a non-severe system error.
> > Subsequent SQL statements can be processed. (Reason "Invalid Request
type
> > for
> > DB2 Admin Server".)"
> >
> > I had cataloged it before with
> > 'db2 Catalog database <db> at <remotenode>'
> > db2 terminate
> > db2stop
> > db2start
> >
> > Both, remote and local database are an old version 6.1.0 on Linux.
> >
> > Thanks for any hint
> > Stefan
> >
> >
> Hi Stefan,
>
> try using this->
>
> catalog tcpip node yourDatabase remote 192.168.1.1 server 50003
> then
> catalog database aliasyourDatabase(can be anything you want) at node
> yourDatabase
> then
> connect to yourDatabase user USERNAME using PASSWORD
>
> I hope i could help you.
>
> Cya,
>
> Fabian