ChannelDB2

mauro piva
  • Male
  • sao paulo, sp
  • Brazil
Share on Facebook Share on Facebook Share
  • Blog Posts
  • Discussions
  • Events
  • Groups (1)
  • Photos
  • Photo Albums
  • Videos

mauro piva's Groups

 

mauro piva's Page

Gifts Received

Gift

mauro piva has not received any gifts yet

Give mauro piva a Gift

Latest Activity

Yunfeng Sun replied to mauro piva's discussion performance issues with postgres + jdbc + InfoSphere federation Server 9.7 in the group DB2 for Linux, UNIX, Windows
"-901 is a internal error in DB2 LUW - some error condition that DB2/Federation can not assign a proper SQL code. You need to contact IBM support resolve the problem. BTW, you may use Federation ODBC wrapper to connect to postgres . That could have…"
Oct 7, 2010
Yves-Antoine Emmanuelli replied to mauro piva's discussion performance issues with postgres + jdbc + InfoSphere federation Server 9.7 in the group DB2 for Linux, UNIX, Windows
"Hello, Have you got any diagnostic message in the postgresql server diag log ? If not, it looks like a connection timeout problem. Activate JDBC trace and reissue the query. Also contact IBM support. Regards. -- Yves-Antoine Emmanuelli"
Oct 3, 2010
mauro piva replied to Rakesh Tiwari's discussion DB2 9.7.2 on Linux... in the group DB2 for Linux, UNIX, Windows
"Hi I installed it on debian without any problems, just with a few tweaks .."
Oct 3, 2010
mauro piva added a discussion to the group DB2 for Linux, UNIX, Windows
Thumbnail

performance issues with postgres + jdbc + InfoSphere federation Server 9.7

I created my DB2 (Enterprise Server (Linux DB2 v9.7.0.2) + federation Infosphere) a "wrapper" with a JDBC for postgres server. The installation was a success. I have a table in postgres with 1,000,000 records. When you run a simple "SELECT * FROM TABLE FETCH FIRST 10 ROWS ONLY" or "SELECT * FROM TABLE WHERE ID < 10 " DB2 takes almost 3 minutes and leaves from a -901 sqlcode. What can I do to improve performance. Here's my script creation wrapprer : CREATE WRAPPER JDBC LIBRARY…See More
Oct 2, 2010

Profile Information

Full Name:
mauro piva
Job Title:
analyst
Company:
SHP
Platforms of Interest:
Linux/UNIX/Windows, z/OS

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

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service