IBM DB2 for i is an advanced, 64-bit relational database management system that supports a broad range of applications at a lower cost of ownership due to its unique autonomic computing (self-managing) features on IBM i.
- Get a picture of your IBM i environment with DB2 catalog
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
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
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
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
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.