Optimising enterprise database models on DB2 along with deployment of Tivoli Access Manager and DataPower security gateway
System and area breakdown
Various IBM enterprise software, viz. DB2 v 9.7, Tivoli Access Manager, DATAPOWER security gateway
IBM DB2, IBM Optim Data Studio, IBM - InfoSphere Optim Performance Manager
1x Solution Architect
1x Scrum Master
2x Database Administrator
The database had not been optimised for a long time with query complexity being common. The database was marked by huge tables and SQL queries that needed urgent optimisation. The incumbent database was marred with poor indexing along with lack of resource monitoring. Moreover, the SQL queries were not optimised for faster performance.
Technical challenge was to integrate in short time number of on premise banking systems.
Our database administrators examined the database and optimised the SQL statements. The database was administered, and the health was monitored using the IBM Data Studio. It also helped in the process of tuning the database originally running on IBM DB2.
The team also used the IBM Optim Performance Manager to isolate and analyse any problems in the performance of the database. We also aided in formalising a backup and recovery policy for the client. We also helped in the deployment of Tivoli Access Manager components with LDAP integration for the Collaborative Lifecycle Management.
The client faced operational issues due to the database not performing to its full potential. Our team optimised the database and ensured improvement in the database performance by almost 40%.
After utilising the services from Atinolix, we could understand the difference in the performance of the database. We were enthralled with the expertise of the experts and also requested them to help us in a few other small projects parallelly.