SQL0901N on CONNECT

[Gregor Kova�]

Hi!

I have a database v9.1 ESE on Windows. I'm working on Linux. On Linux I have
Express-C V9.1. I have started db2ca tool to catalog the database on
Windows. The tool gives you the option to test the connection at the end of
the wizard. The connection was succesful.
But if I try to connect to it through db2cmd I get:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "".) SQLSTATE=58004
Any idea?

Best regards,
Kovi
--
----------- Gregor Kovac -----------------------------------
In A World Without Fences Who Needs Gates? Experience Linux.

[Gregor Kova�]

Gregor Kova� wrote:

Hi!

I have a database v9.1 ESE on Windows. I'm working on Linux. On Linux I
have Express-C V9.1. I have started db2ca tool to catalog the database on
Windows. The tool gives you the option to test the connection at the end
of the wizard. The connection was succesful.
But if I try to connect to it through db2cmd I get:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "".) SQLSTATE=58004
Any idea?

Best regards,
Kovi

AAAAHHHHH !!!!!

I know I shouldn't trust the GUI! Now I CATALOGed the database via command
line commands and it is working. :))

Best regards,
Kovi
--
----------- Gregor Kovac -----------------------------------
In A World Without Fences Who Needs Gates? Experience Linux.

[Serge Rielau]

Gregor Kova� wrote:

Gregor Kova� wrote:

>Hi!

I have a database v9.1 ESE on Windows. I'm working on Linux. On Linux I
have Express-C V9.1. I have started db2ca tool to catalog the database on
Windows. The tool gives you the option to test the connection at the end
of the wizard. The connection was succesful.
But if I try to connect to it through db2cmd I get:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "".) SQLSTATE=58004
Any idea?

Best regards,
Kovi

AAAAHHHHH !!!!!

I know I shouldn't trust the GUI! Now I CATALOGed the database via command
line commands and it is working. :))

Kovi,

Keep the db2dump file safe. See you Monday.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

[Gregor Kova�]

Serge Rielau wrote:

Gregor Kova� wrote:

>Gregor Kova� wrote:

>>Hi!

I have a database v9.1 ESE on Windows. I'm working on Linux. On Linux I
have Express-C V9.1. I have started db2ca tool to catalog the database
on Windows. The tool gives you the option to test the connection at the
end of the wizard. The connection was succesful.
But if I try to connect to it through db2cmd I get:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "".)
SQLSTATE=58004 Any idea?

Best regards,
Kovi

AAAAHHHHH !!!!!

I know I shouldn't trust the GUI! Now I CATALOGed the database via
command line commands and it is working. :))

Kovi,

Keep the db2dump file safe. See you Monday.

Cheers
Serge

Sorry.. To late, but I can recreate it. I think. :))

Best regards,
Kovi

P.S.: Have a great trip.
--
----------- Gregor Kovac -----------------------------------
In A World Without Fences Who Needs Gates? Experience Linux.