10 Nov 2011 — Show descriptions | Hide descriptions

• Accelerate Hibernate and iBATIS applications using pureQuery, Part 3: Auto-tune data fetch strategies in Hibernate applications with pureQuery

  Significantly improve Hibernate system performance by automatically optimizing database access patterns across all use cases of the application.

• Integrate the rich Internet application framework ZK with Informix to build real-world applications

  Use sample data and the easy steps in the tutorial to see how ZK easily interfaces with Informix to create a feature-rich web application.

• Understanding the new JVM exit property in the latest DB2 Universal JDBC driver

  Trap JVM exit or System.exit() upon completion of SQLJ tools using the DB2 Universal JDBC Driver. A sample Java application illustrates how to set the new property.

• End-to-end database monitoring with Optim Performance Manager Extended Insight

  Monitor database response time for Java and CLI applications with Extended Insight, which extends monitoring to show DBAs where workloads, transactions, and SQL requests are occurring.

• Transliteration as an ETL job using InfoSphere DataStage Java stages and ICU4J

  Solve the challenges you face when cleansing data that exists in multiple languages. Learn how to design an ETL job to read your data and then use a Java transformer to make your data consistent before cleansing it.

• Integrate MATLAB code into InfoSphere Streams

  Use the included sample code to develop and execute MATLAB functions from within InfoSphere Streams applications. Also use the MATLAB compiler to create a C++ shared library and write an SPL application.

• Managing pureQuery-enabled applications efficiently, Part 3: Automate client optimization with WebSphere apps

  Learn how pureQuery client optimization can provide useful diagnostic information and increase performance for your web app. You will also use Apache Ant to automate the pureQuery client optimization process.

• Improve SQL execution times using the DB2 statement concentrator feature and the DB2 statement reoptimization feature

  Find out when to use parameter markers or literals in SQL statements, and how to work around it when the default is not optimal for your DB2 LUW configuration.

• OpenJPA caching with WebSphere eXtreme Scale, Informix, and DB2, Part 1

  Learn how to use caching techniques with IBM WebSphere eXtreme Scale and OpenJPA to speed up your lookups and reduce the load on back-end databases without changing your code.

• Set up an SQL management repository using an ANT script

  Automate common administration tasks using Optim Development Studio to manage the repository so that other applications, such as the pureQuery Runtime, can retrieve and update stored information.

• Use Java in IMS dependent regions

  Understand the steps needed to set up, run, and troubleshoot Java in IMS dependent regions, including Java Batch Processing (JBP), Java Message Processing (JMP), and Message Processing Program (MPP) regions.

• A Java solution to use regular expressions and pattern matching in DB2 for Linux, UNIX, and Windows 9.7

  Explore some examples and sample code that show you how to write Java-based DB2 user-defined functions for pattern matching.