Articles & Content


Java DB2 Performance with Data Studio and pureQuery (H13)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2009

DATE: 2009-5-15 (09:15 AM - 10:15 AM)
SPEAKERS: David Beulke (Pragmatic Solutions Inc)

In this presentation the many advantages of pureQuery and Data Studio will be discussed and demonstrated. Generating inLine statements, Java methods, object relational mapping or named queries through Data Studio offers the java architect and programmer the flexibility to match their coding style with the application requirements. Data Studio and pureQuery offers the ability to code your java database access in many different fashions to match whatever application requirements are necessary. pureQuery also has the capability to statically bind java SQL applications. With static SQL java applications, security, debugging capabilities and performance are tremendously enhanced. Static java applications reduce object verification, security checks, authorization and locks in access paths for improved performance. Through this presentation you can learn how to speed up your Java application development and its overall performance through this pureQuery and Data Studio presentation.

EXP. LEVEL: Beginner


Data Studio is a free download for all your development and application support personnel.

Data Studio generates all types of object access methods inLine statements, Java methods, object relational mapping or named queries

pureQuery can also be used in Capture mode so that the captured SQL statements can be statically bound

Statically bound java applications can be used to trace back SQL to the Java module class, method and line number with the source code.

Statically bound java applications perform better because they donít have the overhead of verifying objects, security or generating an access path.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.