- Performance-analysis and optimization of DB2-applications
Client: KKH Hannover
The KKH looks after nearly 2 million insured clients across all 16 states via 114 KKH-service centers with approximately 4,500 employees. It is the fourth largest statewide health insurer in Germany.
Goals of the project were the analysis and correction of run-time problems in applications systems, and the support of database administration and applications development.
The KKH looks after nearly 2 million insured clients across all 16 states via 114 KKH-service centers with approximately 4,500 employees. It is the fourth largest statewide health insurer in Germany.
Goals of the project were the analysis and correction of run-time problems in applications systems, and the support of database administration and applications development.
Project Details
Duration: 01/2002 - 07/2002
Task
- Analysis of the DB-design
- Performance analysis of DB2-applications
- Analysis of the access logic in the applications (Explain and Monitoring)
- Execution and control of optimization measures
- Inclusion of the procedures in the Scheduler OPC/ESA
- DB-Objects (Indexes, Tables etc.)
- SQL-Statements
- Program logic
- Construction of quality back-up systems for testing of SQL-statements
- Conception of extensive program expirations from a performance perspective
IT-Technology
- OS/390
- DB2 for OS/390
- CISC
- COCOL II
- SQL
