51

No description

For the second time in three releases of DB2 for z/OS a larger number of changes than normal have been made to the Catalog and Directory structure. At first sight the introduction of Unicode and Long Names along with DB2 V8 might appear to be more fundamental, but the improvements made in DB2 10 for z/OS are likely to yield equally important benefits. Chief among the changes are introduction of UTS objects and the removal of the internal links, but that’s not all. We will soon be able to issue SQL against some Directory objects, and the introduction of many more LOBs, some of which can be Inline, will affect the way we need to manage the Catalog. These changes are very significant in their own right and taken together are probably the second most wide ranging (at least) since DB2 was first released back in the mid-1980′s. This session describes all the changes that have been made, their benefits and how they will impact the way we need to manage the Catalog and Directory moving forwards.

How well DB2 handles Log data can be a critical factor in maximizing performance, particularly in a high transaction rate environment. There have been a number of changes in the area of Logging over recent DB2 releases. Some of these have been obvious improvements such as the ability to use DFSMS Striping for Active Log datasets, but there have been Logging implications in some other changes such as the introduction of Reordered Row Format. However, many sites I visit have not really investigated these changes in any detail and the impact they might have on their operations. This presentation provides an update on changes to how DB2 manages logging updates and some useful hints and tips you will be able to take away and use to review your logging environment. 

Stored Procedures were first added to DB2 for z/OS back in V5. Most every release of DB2 since has added additional functionality or type of stored procedures. The different types of stored procedures have strengths and weaknesses. This presentation will provide a brief history of Stored Procedures in DB2 for z/OS, along with an overview of the schema used to create stored procedures. It will discuss the different types of stored procedures, External, External SQL and Native touching on some of the advantages and disadvantages of the different types. How can you test a new version of a Native stored procedure without affecting other executions of the active version? When it comes to deploying Native Stored Procedures across your environment, what options do you have available?