|
Case studies and Successes
In the time it has been available, DB2CPI has
become the ‘tool of choice’ for many IT professionals
working in the DB2 environment. Here are two case studies that illustrate
the power and versatility of the DB2CPI product.
A large European bank
During the implementation of Siebal Financials
and mid-way through the project roll out (to 100 branches, comprising
5000 live users) both a network router and a failover router failed.
The resulting effect was that a Siebel production
system (running DB2 data-sharing on two of the biggest IBM servers)
uncounted a flood of database access threads (DBATs) that quickly
reached the maximum DBAT parameter on both database systems.
The DBA using DB2CPI managed to terminate multiple
DBATs with a single command, enabling him to terminate over 2000
DBATs in under two minutes.
Another DBA (using alternative tools) only managed
to terminate 200 DBATs in the same timeframe. This resulted in a
memory abend and a subsystem failure.
The DBA using DB2CPI rapidly reduced the backlog
of DBATs, keeping the first subsystem running. He commented later
‘Without DB2CPI I wouldn’t have been able to rescue
the situation and reduce the backlog of DBATs so quickly’
A major UK bank
This customer had a requirement to migrate multiple
test environments containing thousands of DB2 database objects.
The project was attempted using existing alternative tools, but
without success – the consensus was that existing tools could
not efficiently handle the scale of the operation.
It was suggested that DB2CPI could help. The customer
used a DB2CPI utility (CPIDDL) to reverse-engineer all database
objects of interest. The task was completed in just a few minutes.
An additional problem was encountered when migrating
a large number of objects in batch using the conventional DSNTEP2
batch utility program. The utility caused problems as, after a number
of failures with a parsed script, DSNTEP fails and is out of the
DBA’s control.
Another DB2CPI utility (CPITEP2) was used
to replace IBM’s conventional batch utility program (DSNTEP2)
to provide complete control over failure and rollback scenarios.
|