Archiwa

DB2 storage de-mystified. DMS, SMS, Automatic Storage table space internals. Default table space types across different DB2 editions and versions. Best practices. Container structure, naming conventions, internal architecture. Buffer pool considerations. Storage paths, auto-extend mechanisms, automatic striping. Parallelism vs. performance discussions. Common high watermark issues, reclaimable (object-relative) vs. non-reclaimable (pool-relative). Explanation on current deprecation statements, … Czytaj dalej

Presentation will cover how plan stability for static and dynamic SQL can help protect you from access path regressions. For static SQL that means taking advantage of the plan management feature – with the various options available, that apply to both REBIND and to BIND. Stability for Dynamic SQL is evolving more rapidly, with new … Czytaj dalej

DB2 optimizer relies on statistics about tables and indexes. In most cases, if optimizer could exploit more complete and accurate statistics, queries would perform better. While, DB2 users often only gather standard or default statistics. It’s a challenge for users to identify what detailed statistics should be gathered for the specific queries. This is a … Czytaj dalej

This double session will: share lessons learned, surprises, pitfalls; provide hints and tips; address some myths; provide additional planning information; provide usage guidelines and positioning on new enhancements; Help customers migrate to Db2 z/OS 12 as fast as possible, but safely.  

This session will introduce and discuss the features and functions of Db2 11 and 12 for z/OS for system running which involve a trade off of using larger size real memory allocation in order to reduce CPU resource consumption.  

In the modern days, we expect the database to do majority of the operations in-memory. In reality though, very often the performance and effectiveness of input-output operations is crucial for the throughput of the system. DB2 database does IO operations in multiple ways: doing direct reads/writes, asynchronously via prefetches and page cleaners, skipping or not … Czytaj dalej