ChannelDB2

Emmanuel Garcia
  • Male
  • DF
  • Mexico
Share on Facebook Share on Facebook Share
  • Blog Posts
  • Discussions (3)
  • Events
  • Groups
  • Photos
  • Photo Albums
  • Videos

Emmanuel Garcia's Friends

  • Cindy Russell

Emmanuel Garcia's Discussions

Error query db2 BLU with java
5 Replies

Hello:I have a java application to query db2 blu but I get the following error:com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-955, SQLSTATE=57011, SQLERRMC=3The java connection and code…Continue

Started this discussion. Last reply by Joachim Müller May 13, 2014.

 

Emmanuel Garcia's Page

Gifts Received

Gift

Emmanuel Garcia has not received any gifts yet

Give Emmanuel Garcia a Gift

Latest Activity

Joachim Müller replied to Emmanuel Garcia's discussion Error query db2 BLU with java
"Please run "db2 autoconfigure apply none" for a suggestion what DB2 tries to set. Best regards Joachim"
May 13, 2014
Emmanuel Garcia replied to Emmanuel Garcia's discussion Error query db2 BLU with java
"I've changed SHEAPTHRES_SHR but the error occure when i execute query from java or data studio. If I execute query from command line in the datbase server, it is ok. Regards."
May 13, 2014
Joachim Müller replied to Emmanuel Garcia's discussion Error query db2 BLU with java
"Hi Emmanuel, you have not enough memory. Please look at db2 '? SQL0955' for further Information. Best regards Joachim"
May 13, 2014
Emmanuel Garcia replied to Emmanuel Garcia's discussion Error query db2 BLU with java
"Thanks Joachim: Execution is OK but fails if I do it for my database with column organized tables."
May 13, 2014
Joachim Müller replied to Emmanuel Garcia's discussion Error query db2 BLU with java
"Hi Emmanuel, try this: String query = "SELECT COUNT(*) FROM SYSCAT.TABLES"; rs = stmt.executeQuery(query); Best regards Joachim"
May 13, 2014
Emmanuel Garcia posted a discussion

Error query db2 BLU with java

Hello:I have a java application to query db2 blu but I get the following error:com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-955, SQLSTATE=57011, SQLERRMC=3The java connection and code is:String url;Connection con = null; Statement stmt; ResultSet rs = null;url = "jdbc:db2://localhost:50001/testdb:user=userdb2;password=4&DDSG%;specialRegisters=CURRENT QUERY ACCELERATION=ELIGIBLE;";try {      Class.forName("com.ibm.db2.jcc.DB2Driver");      con = DriverManager.getConnection(url); …See More
May 13, 2014

Profile Information

Full Name:
Emmanuel Garcia
Job Title:
DBA
Company:
HS
Platforms of Interest:
Linux/UNIX/Windows

Comment Wall

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

  • No comments yet!
 
 
 

Featured Downloads

Try BLU Acceleration on Cloud

© 2017   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service