• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

the problem of DB2

 
Porky Liu
Greenhorn
Posts: 22
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Now one Java class is expected to access DB2 database through JDBC. And when I retrieve the table list, there is error existed:
SYSIBM:CLI:-954,SQLSTATE=38553
It seems related with the attribute of APPLHEAPSIZE, when it belows some degree, such as 20(I think it's related with the size of your table space), you can see the above error, but if updating it bigger, the error will disappear
So what's the key of the problem?
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
IBM says(not very descriptive!):
SQLSTATE 38553: A routine in a system schema has terminated with an error.
I'm having trouble understanding your problem. It would me if you could post the code throwing the exception ( identifying the problem line and including any other relevant lines of code ).
Jamie
 
Porky Liu
Greenhorn
Posts: 22
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think it's related code itself,and the same one just like this:
try{
rs=dmd.getTables(null,schemaName,null);
}
catch(SQLException se){
........
}
By the way, your signature is very cool!
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic