10 Nov 2011 — Show descriptions | Hide descriptions

• Hierarchical queries with DB2 CONNECT BY

  Learn the syntax for the hierarchical query clause in DB2 for i, and see how to implement it with new operators, pseudo-columns, and special scalar functions.

• The effect of Max Active on DB2 for i query performance

  Get the details on how you can tune the Max Active setting to get the best possible performance from the DB2 for i query optimizer.

• Decoupling RPG database IO using Rational Open Access: RPG Edition

  Move from a DDS to SQL database on DB2 for i without changing a single line of program code or recompiling a program.

• Concurrently move DB2 for i tables and indexes to solid state disks

  Achieve significant performance benefits when you move a member or partition of an index or table to solid state disk storage. Learn what data should be moved, and how to make the move.

• Encryption enhancements: Field procedure support in DB2 for i 7.1

  Explore how to increase your security and deliver transparent column-level encryption by using a new enabling technology known as a field procedure (FieldProc) in IBM i 7.1.

• Process your DB2 for i indexes in parallel

  Check out this vintage article newly updated for the latest DB2 for i release to take advantage of parallel processing for faster batch processing, data loads, and index builds.

• Updated: Selected common SQL features for developers of portable DB2 applications

  Are you writing SQL applications that need to be portable across platforms? Here's the latest, newly updated information you need to make sure your applications are portable.

• What's new: DB2 for i 7.1

  New features such as adaptive query processing, a real-time self-tuning engine, and improved integration encryption promise to make life easier for the DB2 for i DBA.

• Maximize SQE usage with DDS-created DB2 for i databases

  Tune up your DB2 for i SQL Query Engine (SQE) with the IGNORE_DERIVED_INDEX query options attribute to get maximum performance from your IBM i applications.

• Gauge SQE use in DB2 for i 6.1

  Learn how to use new SQL monitors to better identify those queries and reports that are not taking advantage of the performance benefits of the SQL Query Engine.

• Using common connections with Data Studio Developer

  See how Data Studio Developer 2.1 gives you simple and efficient ways to manage database connections, so you can easily store and retrieve connection parameters for multiple databases.

• IBM DB2 for i 6.1 -- Sophistication simplified

  Discover the new, sophisticated technology of DB2 for i 6.1 that still maintains its easy-to-use nature, providing a great foundation to take your business solutions to new levels.