Zeljen Stanic

How to predict performance problem in design phase. This presentation will address DB2 for z/OS management and tuning. Should we start with the SLA expectations in design phase?. We will start with data modeling, database design, testing ... and what DB2 has with ITIL.

How to predict performance problem in design phase. This presentation will address DB2 for z/OS management and tuning. Should we start with the SLA expectations in design phase?. We will start with data modeling, database design, testing ... and what DB2 has with ITIL.

Many times if you ask how to fix the performance problem the answer is “It depends”. This presentation will address DB2 for z/OS performance management and tuning. We will start with data modeling, database design, testing ….. and end with performance monitoring suggestions. We will touch areas of application, database and system performance. Some aspects of data quality aspects will be mentioned too.

Objectives:

Outline:

Full Abstract:
Creating indexes on DB2 tables is one of the simplest ways to enhance performance.
It is also one of the easiest things to do - you just type CREATE INDEX right?
The skill is in knowing WHICH indexes to create - after all, too many indexes can degrade application performance.
Unicenter Index Expert from CA makes it easy to determine WHICH indexes are RIGHT for your table.
By taking into account statement execution frequency, a set of indexes that are optimized for your workload are recommended.
Index Expert will determine the ideal set of indexes for any given DB2 table
A number of events could trigger a need to consider or reconsider the current indexing strategy
The development or purchase of a new application
The discovery of a performance issue (such as might be highlighted by CA Plan Analyzer, CA Detector or CA Insight for DB2)
A need for a ‘health check’ of an existing application to ensure that the assumptions made during the database design are still valid 

The IT Infrastructure Library (ITIL) was first developed in the late 1980s and has become the de facto standard for IT Service Management and the delivery of IT services to the business.
There is a growing awareness of this standard among IT organizaions many of whom are now adopting the practices defined by ITIL and as a result are looking for tools to support their adoption of ITIL processes. There is also a growing interest around the world in the adoption of the best practices defined by ITIL for Service Management.
This presentation will outline basic ITIL processes and present how DB2 solutions can support those ITIL practices. In some cases the solutions directly assist in the implementation of the processes defined by ITIL, in other cases the solutions provide the support that staff following the ITIL processes would use to make the process more efficient and effective.