Resources for IBM Information Management database administrators
Use examples to help you determine when indexes become highly fragmented and how to use statistics logs to find tables with long RUNSTATS times. Then use the REORG INDEX command to rebuild indexes and remove fragmentation to improve performance. More >
- 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.
- 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.
- 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.
- 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.
- 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.
- What's new in DB2 10.5 for Linux, UNIX, and Windows
Get the key features and enhancements in IBM DB2 10.5 for Linux, UNIX, and Windows releasing in June. The new features address business needs like cost reduction, application performance, productivity, and reliability.
- Simplify backup and recovery with IBM DB2 Merge Backup for
Linux, UNIX, and Windows
Eliminate the need to take regular DB2 full backups. Create a full and a delta backup, then merge them together using the control file structure to create a new full merged backup.