com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

Post by xix » Wed, 12 Mar 2003 03:13:49



i am running db2 udb v8.1 on NT, somehow i got this exception when i
run an application

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031,
does anyone know how this caused? thanks

 
 
 

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

Post by Steve Toeniskoett » Thu, 13 Mar 2003 04:27:16



> i am running db2 udb v8.1 on NT, somehow i got this exception when i
> run an application

> com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031,
> does anyone know how this caused? thanks

You need to run the DB2Binder utility.  Open a DB2 Command Window and
run this command (with the proper values for server, port, dbname, and
the directory where db2jcc.jar is located):

java cp "c:\program files\ibm\sqllib\java\db2jcc.jar"
com.ibm.db2.jcc.DB2Binder url jdbc:db2://<server>:<port>/<dbname>
-user youruid -password yourpw

 
 
 

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

Post by xix » Fri, 14 Mar 2003 09:15:04


hi i am using db2 udb v8.1 on window NT,

after i execute the command i got
F:\Program Files\IBM\SQLLIB\BIN>java -cp "f:\program files\ibm\sqllib\java\db2jc
c.jar" com.ibm.db2.jcc.DB2Binder -url jdbc:db2://172.16.4.10:50000/inq3lib -user
 ddai -password maryxu
Bind to "jdbc:db2://172.16.4.10:50000/inq3lib" under collection "NULLID":
Package  "SYSSTAT": Already exists (No need to bind)
Package "SYSSH100": Already exists (No need to bind)
Package "SYSSH200": Already exists (No need to bind)
Package "SYSSH300": Already exists (No need to bind)
Package "SYSSH400": Already exists (No need to bind)
Package "SYSSN100": Already exists (No need to bind)
Package "SYSSN200": Already exists (No need to bind)
Package "SYSSN300": Already exists (No need to bind)
Package "SYSSN400": Already exists (No need to bind)
Package "SYSSH101": Already exists (No need to bind)
Package "SYSSH201": Already exists (No need to bind)
Package "SYSSH301": Already exists (No need to bind)
Package "SYSSH401": Already exists (No need to bind)
Package "SYSSN101": Already exists (No need to bind)
Package "SYSSN201": Already exists (No need to bind)
Package "SYSSN301": Already exists (No need to bind)
Package "SYSSN401": Already exists (No need to bind)
Package "SYSSH102": Already exists (No need to bind)
Package "SYSSH202": Already exists (No need to bind)
Package "SYSSH302": Already exists (No need to bind)
Package "SYSSH402": Already exists (No need to bind)
Package "SYSSN102": Already exists (No need to bind)
Package "SYSSN202": Already exists (No need to bind)
Package "SYSSN302": Already exists (No need to bind)
Package "SYSSN402": Already exists (No need to bind)
DB2Binder finished.

so why the problem still happens? thanks

 
 
 

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

Post by xix » Fri, 14 Mar 2003 09:19:04


hello

after i do the binding, i didn't find a package named SYSSH203 exists.
so is that why there is exception? how can i bind it? and why do i
need to have a package binding on DB2? i have very limited doc and
knowledge on this. thanks

 
 
 

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

Post by Steve Toeniskoett » Fri, 14 Mar 2003 23:27:10



> hello

> after i do the binding, i didn't find a package named SYSSH203 exists.
> so is that why there is exception? how can i bind it? and why do i
> need to have a package binding on DB2? i have very limited doc and
> knowledge on this. thanks

Sorry, but I missed that your database was on NT in your original
note.  You didn't need to run the DB2Binder utility against NT (or
Linux/Unix) because the packages are pre-installed.

I don't have a Windows install, but I do have a Linux V8.1 and the
SYSSH203 package is missing there too.  I don't know what this package
does or why it isn't there so I can't help you with this.  I am
curious though, what were you trying to do that returned this error?
I can access my Linux database through the jcc driver fine.

Steve

 
 
 

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

Post by xix » Sun, 16 Mar 2003 01:53:02


hi, i attach the this for your info, something happened during this
code. when i running an application, i can roll up and roll down on
different screen, the screen comes up with data, i can put an option
besides the row and there is another screen pop up. i exit, do another
row, screen pop up. when i repeat these steps and error happened.

Connection conn = DbHelper.getConnection();
int size = libraryList.size();
for (int a = 0; a < size; a++)
{
String databaseName = (String) libraryList.elementAt(a);
                                        String sqlStr =
                                                "select NAME from sysibm.systables where name='"
                                                        + tableName.toUpperCase()
                                                        + "' and creator='"
                                                        + databaseName.toUpperCase()
                                                        + "'";
        //                              System.out.println(sqlStr);
                                        Statement stmt = conn.createStatement();
                                        ResultSet rs = stmt.executeQuery(sqlStr);
                                        if (rs.next())
                                        {
                                                name = databaseName + "." + tableName;
                                                stmt.close();
                                                return name;

                                        }
                                }



> > hello

> > after i do the binding, i didn't find a package named SYSSH203 exists.
> > so is that why there is exception? how can i bind it? and why do i
> > need to have a package binding on DB2? i have very limited doc and
> > knowledge on this. thanks

> Sorry, but I missed that your database was on NT in your original
> note.  You didn't need to run the DB2Binder utility against NT (or
> Linux/Unix) because the packages are pre-installed.

> I don't have a Windows install, but I do have a Linux V8.1 and the
> SYSSH203 package is missing there too.  I don't know what this package
> does or why it isn't there so I can't help you with this.  I am
> curious though, what were you trying to do that returned this error?
> I can access my Linux database through the jcc driver fine.

> Steve

 
 
 

com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

Post by xix » Sun, 16 Mar 2003 01:55:25


sorry miss something. the getConnection() method is below

        public static Connection getConnection()
        {
                if (conn != null)
                {
                        return conn;
                }

                getProperties();
                try
                {
                        Class.forName(dbDriver);
                        conn = DriverManager.getConnection(url, username, password);
                }
                catch (Exception ex)
                {
                        System.out.println("DbHelper.getConnection(): " + ex);
                }
                return conn;
        }

i keep watching the conn, it doesn't have exception, when it return,
exception happened.

 
 
 

1. com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC:

hi, we are using db2 v8.1 fixpack 2 on NT. i have create a database
with code set UTF-8, when i try to copy the table from AS400 to DB2, i
got the error
com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -302,
SQLSTATE: 22001, SQLERRMC:

the table on AS400 contains Japanese data, i try to create the table
to store Japanese data on DB2.

But if i change the length of each field to 4 times of the original
length, i can pass and generate the table with data.

Since now on DB2 the length stored in sysibm.syscolomuns is 4 times of
the actual length, so i have to divide this length by 4 to get the
actual length of each field. But the problem is some of the fields is
substring of another field, e.g. apkey on AS400 is 8 length now, after
copy the table to DB2, it becomes 32 bytes long. i have key2
substr(apkey,1,6), then key2's actual length stored in
sysibm.syscolomuns, so looks like some of the fields are 4 times of
original field, some are the actual length. that causes my program
problem , because i assumes all the fiels definition must divide by 4
to get the right length .

i don't understand why i need to 4 times length, because as i see all
the value occupy one byte for up to 8 if the length is 8 bytes, if i
times 4 , that would be 32 length, so the rest 24 byte are space.
please help. thanks

2. SQL Server not releasing SPID

3. com.ibm.db2.jcc.b.SQLException: under construction

4. OIBKND32.DLL Installation Stack Dump error message

5. NoClassDefFoundError: com/ibm/db2/jcc/SQLJPackage

6. Include Problem

7. Differences between COM.ibm.db2.jdbc.app.DB2Driver and COM.ibm.db2.jdbc.net.DB2Driver

8. Here's the link, Shelley...

9. NULLID.SYSSH203 exception

10. COM.ibm.db2.jdbc.appDB2Exception

11. COM.ibm.db2.jdbc.app/net.DB2Driver and AIX UDB connectivity from win95 PC

12. db2java.zip crash on OS/2 (COM.ibm.db2.jdbc.app.DB2Driver)

13. COM.ibm.db2.jdbc.DB2XADataSource