The IBM DB2® family provides the foundation of information on demand. It's designed to meet your business needs whether large or small.
Use Snapshot monitoring views to access snapshot data from SQL-based appliations, a DB2 command line, or a command script to access your data for all database partitions of a connected database. More >
- Secure Sockets Layer (SSL) support in DB2 for Linux, UNIX,
Configure SSL protocol and use the test case verification program in this article to protect your data as it moves through a network.
- DB2 10.x certification: Everything you need to know
Learn how the IBM DB2 certification process works, how tests are developed, and whether getting certified is right for you. Review the many resources included in this article to help you in every phase of the certification process.
- Backup and restore procedures for the DB2 instance shared
directory in a DB2 pureScale environment
Use the procedures described in this article to restore a pureScale instance shared directory in a case where some or all files in that directory have become unavailable or unusable.
- Online DB2 for z/OS migration
Get hints and tips to make your online migration successful. Discover how the DB2 migration process has been designed specifically to allow the business application set to continue to run while you migrate.
- Technical tip: Maintain high availability on DB2 for z/OS on
single LPAR systems
Use a method to map your test program onto production qualifiers and retrieve data directly from production to maintain high availability during the test, development, and production cycle.
- Optim Query Tuner: Capture and tune DB2 z/OS SQL statements
using a user-defined SQL repository
Create query workloads directly from your own SQL repository, without the overhead of archiving or staging your workload data. Leverage the Query Tuner user interface to define dynamic and static SQL statement filters, and tune the saved workload without implementing your own client.
- DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX,
Get the latest DB2 10.5 capabilities in this article update, including a high-level overview of what Oracle compatibility means in DB2, and whether to switch your custom application to DB2 or extend your DBMS vendor support to DB2.
- Restrict database connections using the CONNECT_PROC
database configuration parameter in DB2
Protect data access using this simple technique that allows end users in DB2 for Linux, UNIX, and Windows to connect to the database only from a specific set of hosts or IP addresses. This article gives a practical example.
- Get the most out of DB2 optimizer: Leveraging statistical
views to improve query execution performance
Leverage statistical views to provide DB2 optimizer with information to accurately model complex relationships to choose an optimal query access plan. Use examples to identify complex relationships and create statistical views to compute more accurate cardinality estimates.