This one day seminar is a number of best practices in many areas. It is a great resource for experienced DBA’s how question themselves if they are doing the right thing. Topics: - Configuring your server - Fix packs and upgrades - Table space and bufferpool strategy - Security and audit - Collecting performance data / tuning - Runstats and Reorg - Your recovery strategy
This one-day class is designed to describe the major technical features and enhancements provided by DB2 for Linux, UNIX and Windows database 10.5 software. A key feature of DB2 LUW 10.5 is new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration. Additional new features in DB2 LUW 10.5 will also be covered. After completing this class, you should be able to: • Implement column-organized table support for a new or existing DB2 database • Describe how the column dictionaries used to provide extreme compression of column-organized tables are built and utilized • Explain the impact of setting the DB2 registry variable DB2_WORKLOAD to ANALYTICS • List the seven ‘big ideas’ that work together to provide DB2 BLU acceleration • Describe the different storage used for column-organized table compared to row-organized tables • Explain how DB2 uses a synopsis table to support data skipping with column-organized tables • Monitor a DB2 database or application that uses column-organized tables • Use db2convert or ADMIN_MOVE_TABLE to convert row-organized tables to column-organized tables • Explain the support for large row sizes with DB2 10.5 • Use DB2 Version 10.5 create an index that contains an expression-based key • Monitor DB2 10.5 databases and instances using SQL table functions MON_GET_DATABASE and MON_GET_INSTANCE • Recovery enhancements will also be discussed.
This class will consist of a comprehensive look at the architecture, management and performance tuning issues associated with DB2 for z/OS system storage, and is aimed at DB2 for z/OS Systems Programmers and DBAs wishing to enhance their knowledge of DB2 memory management and tuning in V9, V10 and beyond. Attendees will leave with a good understanding of how to monitor and tune critical storage areas including Bufferpools, the EDM Pool, the Dynamic Statement Cache and the Coupling Facility. Both Virtual and Real Storage tuning will be covered in-depth and at the end we’ll peek into the near future with a look at how DB2 11 and zEC12 hardware improvements will impact DB2 memory management.
More automated install Catalog restructure (to UTS) Deprecation of Plans with DBRMs, old plan_table formats, DB2 Private Protocol, classic partitioned table spaces Performance Out of the box up to 10% cpu savings Hash access to data Include columns in indexes In-line LOBs Dynamic statement cache improvements Dynamis SQL stability and the access path repository Availability On-line schema evolution and deferred alter Data "as of" last commit Reorg Aux table improvements Recover backout Security Row and column level access control Finer administrator privileges Administrator privileges without data access New audit abilities Productivity Immediate compression LISTDEF partition range support REORG SHRLEVEL CHANGE enhancements Temporal data SQL PL improvements Moving sum and average XML XML schema validation in z/OS Multi versioning of XML data XML update, insert and delete XML schema as column modifier CHECK DATA for XML And much MUCH more
Is it wise to turn on STMM? Why not? How does it work and what are its limitations? Instead of looking at it as on/off we look at a hybrid solution
With the comprehensive features for temporal data management in DB2, database administrators and application developers face numerous choices in database and application design. They also encounter new situations for the maintenance of database objects and historic data.
This session describes best practices for designing temporal databases, managing temporal database objects, and developing temporal applications. The guidelines also cover topics such as temporal data modeling, schema design, temporal performance, and tips for coding efficient temporal queries and temporal updates.
DB2 Workload Manager (WLM) is not very popular. Maybe because most people don’t know what it can do or how to use it. We will discuss it features and how it can be implemented
The HADR feature in DB2 LUW is very popular. IBM has added some new features in 10.1. We will discuss what is possible and what is wise. We also have a look at how it impacts licensing.
European SQLAdria Seminar – Vodice 2024
SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.
8 reasons to come Speakers Events Contact
VODICE - 12th - 15th June 2023