IBM Db2 Database Benefits

DD
Senior project manager (APAC region) at FreeBalance

This is the solution developed for IMF, where whatever funds they're giving to a particular country, all the grants are coming from the IMF using the Db2 server. So once they transfer the amount, the information comes into Db2 against a particular project, like for education or healthcare. 

So, the IMF grants a specific amount for a specific project in a country. Now, that country likely has various projects running under that department. Our GRP system manages those projects for that particular country. We take the base information – what money is coming in – and based on daily transactions, we update Db2 database to report back to the IMF. This report details all expenditures, including who approved them and which ministry was involved.

So, IBM Db2 database has been particularly effective for the data management requirements.

View full review »
Balamurugan Ramalingam - PeerSpot reviewer
Senior Quality Assurance Consultant at Public and Business Service Delivery

Considering the day-to-day activities in my company, around 30% of my work's contribution is possible because of IBM Db2 Database.

View full review »
BN
Product Development Manager at a tech services company with 11-50 employees

One of the benefits of the solution is efficiency. One of our biggest clients is a bank based out of Brazil. As their data grew, fetching data became slow, and they did not have a good banking experience. By moving to Db2, they get better efficiency in managing and accessing the data. They have a good experience with the application.

View full review »
Buyer's Guide
IBM Db2 Database
March 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
MK
Solutions Architect at a retailer with 10,001+ employees

We rely on it for our data transfers. If we need to send an invoice, for example, we'd use this product. 

View full review »
Siddharth Matalia - PeerSpot reviewer
Senior Technical Specialist at a manufacturing company with 10,001+ employees

The past year has been much easier and has required minimal downtime. We can take a snapshot of the database and restore it quickly if needed, offering added convenience to our organization.

View full review »
MR
DBA at a tech vendor with 201-500 employees

Its performance is great. In my case, half a million transactions per second are using the DB services of the Db2 mainframe. So, it provides a great ability to support logical units of work.

For every big organization or big site, such as a bank or a credit card company, the most important asset is data. An organization puts all its business data and manages it in Db2 because it trusts that Db2 will be able to provide all the necessary services, such as:

  • Business continuation
  • The ability to process a large amount of data
  • The ability to maintain a large amount of data
  • The ability to execute DB services in a fraction of a second
View full review »
Md Al-Amin - PeerSpot reviewer
Senior System Analyst at Thakral

The value and impact of using IBM Db2 Database lie in its essential role in storing data. The benefits include enhanced performance, reliability, and effective data management compared to other databases.

View full review »
MS
System Administrator at a financial services firm with 1,001-5,000 employees

Has a very good RDBMS with high throughput, customizable security features, and a reasonable licensing price.

View full review »
JH
Solution Architect at a insurance company with 10,001+ employees

Db2 enables us to analyze big amounts of structured data in DataWarehouse solutions.

View full review »
it_user700098 - PeerSpot reviewer
Project Manager at a tech services company with 10,001+ employees

We have moved a lot of our applications off zOS to distributed platforms and IBM UDB DB2 has been extremely critical in our solution to provide for a scale-able, cost-effective and reliable DBMS solution on distributed platform.

The other advantage is we don't have to make lot of changes in the application DB2 access layer in order for it to work with IBM DB2 UDB. These applications have been originally designed to work with the host database (IBM DB2 zOS).

View full review »
SA
Technical support manager IBM Power systems at a computer software company with 51-200 employees

We propose DB2 and other IBM products to our customers.

View full review »
GD
Security Analyst at a insurance company with 1,001-5,000 employees

When new DB2 resources are introduced into the environment, the Vanguard Administrator product allows us to quickly build the required RACF security rules and access lists. There are features in the Administrator product that automate the tedious security administration efforts. The Vanguard Advisor product provides a mechanism for monitoring the RACF/DB2 environment, identifying and reviewing security violations that occur, etc. As stated earlier, we also use Vanguard Integrity Professional’s “Security Center” product for RACF DB2 administration. The Security Center has a direct GUI interface to RACF. As such, it does not require the RACF administrator to use TSO to define or change RACF security profiles associated with DB2.

View full review »
DL
Mainframe Application Analyst / Developer at a insurance company with 10,001+ employees

All parts of storage mediums, including VSAM and sequential files to make the system work.

View full review »
it_user698637 - PeerSpot reviewer
DB2 DBA at a financial services firm with 10,001+ employees

Due to the stability, the applications can have a very long uptime, even with modifications in the application.

I have never needed to install a fix pack because there is a problem on the engine where new functions are used. Users forget to know that a DB2 is supporting the data.

View full review »
it_user75351 - PeerSpot reviewer
VP of IT at a financial services firm

Compared to Oracle, it is so much cheaper.

View full review »
it_user121524 - PeerSpot reviewer
Sr. System Architect at a tech services company with 1,001-5,000 employees
The product has improved our organization in many ways. IBM DB2 has been used in many client projects. These projects are used for a number of years (more than 20-30). Entire Enterprise Applications in the IBM Mainframes have been built with the capability of IBM DB2. Many applications have thousands of DB2 tables and millions of rows. These are accessed for Batch Programming via COBOL, for online / CICS programming via COBOL. Some entries can be accessed by IBM Websphere for Web Programming. This has provided the organization the ability to implement millions of business functions through online / batch / web programs. View full review »
ME
Enterprise Solutions Architect at a computer software company with 201-500 employees

Our software products have to be PCI-DSS compliant, so encryption of customers' credit card numbers is a must-have feature. Using DB2 AWSE v11 enables us to do out-of-the-box encryption with ease.

View full review »
DD
Lead Code Wisperer at a tech vendor

DB2 was always there, so I can't answer that. Know that I've used MySQL, PostgreSQL, and SQL Server extensively as well, and always missed DB2 for i.

View full review »
it_user77925 - PeerSpot reviewer
Engineer at a tech services company

We replicate TSM servers' databases to the other sites with the HADR feature. We use HADR takeover to switch the TSM service to the other site.

View full review »
it_user442923 - PeerSpot reviewer
VMware & Storage Design Lead at a university with 1,001-5,000 employees

Not one that is relevant, it is used purely in a “systems infrastructure” setting rather than as a “business application system”.

View full review »
it_user700107 - PeerSpot reviewer
DBA with Oracle Database, IBM DB2 and Cloudera Hadoop project at a financial services firm with 5,001-10,000 employees

The old system (Wealth Management) was on Microsoft SQL Server platform, however, the performance and stability couldn't meet our requirements. After migrating to DB2, it's much better.

View full review »
it_user700134 - PeerSpot reviewer
SAP Basis Administrator at a pharma/biotech company

We use IBM DB2 as part of a SAP implementation. DB2's performance and stability has been a key factor in the success of the SAP rollout.

View full review »
Buyer's Guide
IBM Db2 Database
March 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.