Love Having and Working on Db2 for z/OS
February 13, 2024
Love Having and Working on Db2 for z/OS
Score 10 out of 10
Vetted Review
Verified User
Software Version
Db2 on-premise
Overall Satisfaction with Db2
We use Db2 as the Application Databases that we have and the processes that utilize them at SSE/OVO Energy. A Db2 Sub-system can itself be part of a Db2 Data Sharing Group. Db2 Data Sharing allows us to spread the workload and resources of Db2 over more than one LPAR. The assigned Application databases are accessible through the Db2 sub-systems of the group. At SSE, we have several Data Sharing Groups. Each one has two sub-systems, these sub-systems running on separate LPARs. Each Data Sharing Group has its own unique name, there are several ways to connect to Db2 when wishing to access the databases. The Application that we use here is called the Customer System (also known as the CS Database). CS comprises 17 databases totaling over 1100 tables.
- It reduced the amount of time we spend managing data
- A high degree of availability
- Data Protection and data integrity
- Exceptional scalability with a high volume of transactions
- Partition by growth tablespaces
- Data refresh
- Integration with cloud
- Fast response time by processing optimization and cost reduction by reduced CPU utilization. Nowadays, good performance is a necessary condition for the survival of a company and its sustained growth
- SQL enhancements are targeted to improve performance, simplify current and new applications, and reduce the development cycle time to market.
- A CPU reduction at peak times can immediately reduce our TCO by reducing software costs related to CPU utilization.
- Impressive reductions in memory requirements, which used to limit the concurrent database activity
- Out-of-the-box savings without changing the database or application
Do you think Db2 delivers good value for the price?
Yes
Are you happy with Db2's feature set?
Yes
Did Db2 live up to sales and marketing promises?
Yes
Did implementation of Db2 go as expected?
I wasn't involved with the implementation phase
Would you buy Db2 again?
Yes