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.
Overcome the challenges in setting up a connection from Information Server to DB2 i. Use the step-by-step instructions in this article to check prerequisite information and components, connect to DB2 for i, and define DataStage jobs. More >
- Using RPG to exploit IBM DB2 for i XML support
Follow examples that show how to embed SQL statements into an RPG program on IBM i to perform relational queries involving XML data and producing XML results.
- 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.