SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:17 AM
| ||||
| ||||
 SQL0901N on CONNECT 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.      |
|
02-27-2008, 08:17 AM
| |||
| |||
| Re: SQL0901N on CONNECT 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. |
|
02-27-2008, 08:17 AM
| |||
| |||
| Re: SQL0901N on CONNECT 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/ |
|
02-27-2008, 08:17 AM
| ||||
| ||||
| Re: SQL0901N on CONNECT 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. |
 |
« Update with join statement not working in DB2
|
Lock mode converting from NS to X, when will this happen? »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:03 AM.
