By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

SQL0901N on CONNECT

P: n/a
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.
Sep 22 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
Sep 22 '06 #2

P: n/a
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/
Sep 22 '06 #3

P: n/a
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.
Sep 22 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.