IBM DB2 for i

27 Sep 2012 — Show descriptions | Hide descriptions

• Get a picture of your IBM i environment with DB2 catalog views

  A new set of catalog views provide information about your IBM i system environment. See how these views make it easy to access information about Group PTFs and TCP/IP network connections.

• Introduction to IBM i OmniFind Health Checker

  Use this set of DB2 stored procedures to quickly identify and resolve common problems related to OmniFind Text Search Server for DB2 for i.

• 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.