47

In the NLB for many years, especially recently, much attention is paid to the management of IT (” IT Governance “). We strive to systematically upgrade and improve our management system as the foundation for effective implementation of IT processes, high qualification and motivation of employees, cost-effectiveness of IT and, most importantly, higher customer satisfaction with our products and services. In doing so, we rely on international best practice models such as: ISO 9001, ISO 27001, COBIT framework, Balanced Scorecard – BSC and others. We clearly define all the key processes of our work within which the central place occupies the »Development and change methodology of information systems«. One of the major steps of this methodology is definitely the »Release Management Process”, for which we formally define the “Procedure for Introducing Changes into the Production IT Environment.” The operation of this procedure is controlled by so-called “Group for IT Changes,” which is responsible for correct implementation of the defined process from the announcement of the proposal to implement the change, over its treatment in view of interdependence with other upcoming operations and systems, review the prepared changes in the light of different professional services (quality, security, architecture, …), the final approval or rejection of the proposal and finaly a feedback on the effectiveness of intervention performed. Interventions are performed on the basis of an annual calendar prepared. For each activity in the defined process there are clearly defined responsibilities of all participants.

Dynamic world of business needs to better define data. There’s a critical need for data architecture and blueprint. We often forget that it is a living framework. An accurate, transparent and accessible view of metadata should be created. The value of data modeling is expanding. Both logical and physical data models can support more than databases.

A DBA is not always just a DBA. DBA’s are frequently called for all kinds of issues, required to know enough about all aspects of DB2 to track down the root-cause of problems . DSNZPARM is just one of these aspects. Today, both Systems programmers and DBA’s need to know and agree on DSNZPARM settings as some have direct impact on the application and the performance of it, some may have unintended consequences. Let’s explore some of those parameter controls that may affect application behavior.

Index compression was announced as part of DB2 9 for z/OS, but it remains a mystery to many users. Is it the same as tablespace compression? If not, how is it different? How do I take advantage of it, and how can I know which indexes to compress? This presentation will cover some of the internals of index compression, and then it will answer your questions about when and how to most effectively use the feature.

You may have heard that Enhanced Statistics were added to DB2 for z/OS with DB2 9, and you probably wondered what they are and how they can help. This presentation will answer your questions about what the statistics are, how they are enabled, how they get collected, and what effect they will have on your SQL execution.
Disclaimer: I do not work for IBM, and the conclusions in this document are resolved from research done by my colleagues and myself. There is no guarantee of the correctness of any statement in this presentation, although I have done as much as I can to verify my conclusions.