Db2 Error 1001
installation. Technote
Sqlstate=2e000
(troubleshooting) Problem(Abstract) When attempting to connect to DB2 from message: connection reset. errorcode=-4499, sqlstate=08001 my remote Modeler server located on a Unix platform I get the following error. SQLDriverConnect failed :[DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unkown error: SQLCODE -1001 How can I fix this? Resolving the problem The default odbc.ini is a template for future datasource connection information. In the case of DB2 it has entries appropriate for DB2 on z/OS as well as other platforms. If you are connecting to a non z/OS platform, then you must comment these properties out. If instead you are connecting to DB2 on z/OS you need to supply valid property values. Please edit your odbc.ini file to simply comment out these two lines in the datasource configuration: This: #Collection applies to z/OS and iSeries only Collection= needs to be this: #Collection applies to z/OS and iSeries only #Collection= and this: #Location applies to z/OS and iSeries only Location= needs to be this: #Location applies to z/OS and iSeries only #Location= Historical Number 90556 Document information More support for: SPSS Modeler Modeler Software version: 14.1 Operating system(s): AIX Reference #: 1488770 Modified date: 2014-09-26 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
all the characters must be from the database manager base character set. The command cannot be processed. Action: https://www.columbia.edu/sec/acis/db2/db2m0/sql1000.htm Resubmit the command with the correct alias. SQL1001N "" is not http://www.dbforums.com/showthread.php?974917-com-ibm-db2-jcc-b-SQLException-in-getConnection a valid database name. Cause: The syntax of the database name specified in the command is not valid. The database name must contain 1 to 8 characters and all the characters must be from the database manager base character set. The command cannot be processed. db2 error Action: Resubmit the command with the correct database name. sqlcode: -1001 sqlstate: 2E000 SQL1002N "" is not a valid drive. Cause: The drive specified in the command is not valid. The drive is a single character (A to Z) indicating the diskette drive or fixed-disk partition where the database or database directory is located. The command db2 error 1001 cannot be processed. Action: Resubmit the command with the correct drive. SQL1003N The password is not valid because the syntax is not correct or the password does not match the password of the specified database. Cause: The length of the password is expected to be 18 characters or less. However, if the password is to be verified for an APPC conversation, it must be 8 characters or less. Action: Ensure that the password is not longer than the limit allowed. sqlcode: -1003 sqlstate: 28000 SQL1004C There is not enough storage on the file system to process the command. Cause: There is not enough storage on the specified file system to process the command. In a partitioned database environment on OS/2 and Windows environments, each node in the partitioned database group must have the exact same physical hard drive specification (letter) available and useable (must contain useable space) for the CREATE DATABASE command to succeed. The physical hard drive letter is specifed in the database manager
visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: com.ibm.db2.jcc.b.SQLException in getConnection Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-17-03,11:42 #1 sdjaffar View Profile View Forum Posts Registered User Join Date Dec 2003 Posts 2 Unanswered: com.ibm.db2.jcc.b.SQLException in getConnection Hi, I'm trying to establish a connection to DB2 V8.1 in unix, but I keep getting error: com.ibm.db2.jcc.b.SQLException: DB2C_DB2INST1 at com.ibm.db2.jcc.b.l.a(l.java:1469) at com.ibm.db2.jcc.a.bb.h(bb.java:541) at com.ibm.db2.jcc.a.bb.e(bb.java:400) at com.ibm.db2.jcc.a.bb.a(bb.java:225) at com.ibm.db2.jcc.a.bb.a(bb.java:62) at com.ibm.db2.jcc.a.b.a(b.java:893) at com.ibm.db2.jcc.a.b.a(b.java:439) at com.ibm.db2.jcc.a.b.a(b.java:293) at com.ibm.db2.jcc.a.b.(b.java:207) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:2 44) at java.sql.DriverManager.getConnection(DriverManager .java:517) at java.sql.DriverManager.getConnection(DriverManager .java:199) at DBConn.getConnection(DBConn.java:141) at DBConn.execute(DBConn.java:94) at DBConn.main(DBConn.java:150) I pointed my url to port 50000 db2c_db2inst1. Any suggestion? Reply With Quote 12-17-03,12:08 #2 sdjaffar View Profile View Forum Posts Registered User Join Date Dec 2003 Posts 2 I'm using db2jcc.jar (Type 4). This is exactly what I get: com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -1001, SQLSTATE: 2E000, SQLERRMC: DB2C_DB2INST1 at com.ibm.db2.jcc.c.l.a(l.java:1546) at com.ibm.db2.jcc.a.bc.h(bc.java:541) at com.ibm.db2.jcc.a.bc.e(bc.java:400) at com.ibm.db2.jcc.a.bc.a(bc.java:225) at com.ibm.db2.jcc.a.bc.a(bc.java:62) at com.ibm.db2.jcc.a.b.a(b.java:893) at com.ibm.db2.jcc.a.b.a(b.java:439) at com.ibm.db2.jcc.a.b.a(b.java:293) at com.ibm.db2.jcc.a.b.(b.java:207) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:2 44) at java.sql.DriverManager.getConnection(DriverManager .java:517) at java.sql.DriverManager.getConnection(DriverManager .java:199) at DBConn.getConnection(DBConn.java:141) at DBConn.execute(DBConn.java:94) at DBConn.main(DBConn.java:150) Reply With Quote Quick Navigation DB2 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server So