How healthy are our DB2 catalogs?

Date: 
Monday, 27 June, 2005 - 16:30 - 17:30
Speaker: 
Andre Goetschy

This presentation shows the real and often surprising results of analysing DB2 environments in representative DB2 for OS/390 installations (Banks, Insurance, Industry and Cross Service Companies) in Europe and USA.The most common discrepancies and inconsistencies affecting the availability, the performance and  the reliability of DB2 will be reported as well as their reasons, impacts and possible ways to solve or palliate them.

PRESENTATION OUTLINE:

Part 1: BACKGROUND:
Presentation about the investigations done in order to detect discrepancies and inconsistencies affecting the following areas of concern:
 Catalog size
 Catalog  reliability and consistency  
 Space saving
 Application/utility Concurrency  
 CPU and IO performance
 Resource availability and data recoverability  
 Parallel-sysplex datasharing
 DB2 Upgrades
 Security handling
 Change management and housekeeping

Part 2: FINDINGS:
Presentation of the discrepancies and inconsistencies encountered in representative DB2 for OS/390 installations (Banks, Insurance, Industry and Cross Service Companies) in Europe and USA.

CONCLUSION/SUMMARY:
Report of 'very often', 'often' and 'rarely' encountered discrepancies and inconsistencies and a rating of the benefits of resolving them.

 

sqladria

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.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023