Skip to content

Success Stories

October 19, 2021

For the last 19 years Gunning Technology Solutions, LLC has been providing a myriad of services for Db2 on Linux, UNIX and Windows…This year with COVID and it’s impact on the workforce we have been extremely busy helping clients succeed with Db2. We have a very large financial services client for 15 years running that continues to meet business objectives running Db2 on a large Windows Server, running over 10 billion transactions a year with zero downtime in an HADR environment with Reads-On-Standby.

Another client uses Db2 to store analytical data regarding Wi-Fi quality of service data for large hospitals and financial services companies. A plethora of analytics are provided to the clients to understand and review all aspects of there wireless network infrastructure. We have done lots of SQL tuning, index redesign, Db2 configuration updates and improved their ability to purge obsolete data using Db2 Stored Procedures and referential integrity with cascade deletes. We also right-sized there Db2 versions which were a mixture of Db2 Express-C, Db2 Express and DB2 Workgroup Server Edition.

We have a client that is very large in the music business, offering sheet music worldwide. This offering uses Db2 on Linux RedHat to provide clients with access to music products worldwide. Most of our work here has been upgrading to a supported release of Db2, firefighting (tuning problematic SQL) in real-time, and educating the client support personnel on Db2 operations and support. We provide support on a retainer basis for this client.

Another client uses Db2 on AIX as there platform of choice for Healthcare benefits enrollment. This client has in-house servers and also installed software clients on premises. Major work here has been providing 24×7 support for the production environment which consists of Power9 servers running AIX 7.2 with many LPARS. We’ve tuned SQL, conducted extensive index redesign, fixed DB2 configuration problems, automated reorgs for only those objects that need it and continue to provide Db2 database administration support for production.

So this year we haven’t been as visible on social media because we are just busy doing Db2. And, all Db2 and Security related conferences which were initially planned for onsite were changed to virtual conferences due to the ongoing COVID issues.

We participated in calls with the IBM Db2 Toronto Lab team, Customer Advisory Councils for both Db2 on LUW and z/OS and other IBM product offerings that are of interest to our clients.

In summary, we continue to help people succeed with Db2!!!

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: