TrustRadius
DB2 is a relational database software solution offered by IBM.https://dudodiprj2sv7.cloudfront.net/product-logos/Pl/TO/6MZVJJK89QMG.PNGIBMA business must have DB2 as their DB to be always up and running.....2018-06-21T15:08:15.470ZWe use DB2 as a database for our enterprise customers as part of their SAP system landscape. One of our Diamond clients uses it for their critical landscape and we provide the implementation and support for the landscape. DB2 is best suited to enterprise businesses who want a low cost, low maintenance solution for improved transnational DB queries to fulfill the business requirement on a frequent basis.,It's best for use in a BW landscape for reporting purposes where you need fast data fetching. As compared to other traditional DBs, I feel DB2 is lightweight and less complicated.
Easy DB administration, and requires less administration.
Easy in version as well as FP upgrades.,Our DB is almost 4 TB in size. So we feel that to manage such a huge DB, DB2 should provide some more user friendly and easier GUI base administrative tool, looking at the current competition in market for their DBs.
There is definitely a bit more improvement required in data manipulation and query languages.
Stability for an HA kind of environment is one of the key areas for improvement.,9,Positive - Very good performance as compared to other traditional DBs.
Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.,10,9,9,Microsoft SQL Server, Oracle Database and SAP Sybase IQ,SAP CRM, SAP HANA, SAP S/4HANA, AWS Lambda, Amazon S3 (Simple Storage Service)Pradeep BeleDB2 is great for BI2018-04-03T22:25:39.924ZDB2 is being used as the database software for our financial core software. We also use it to query data for business intelligence. This is used by the whole organization and will allow us to pull reports based on requests. The software is easy enough to use for anyone that has SQL experience and I feel like it is responsive and quick.,Business intelligence - Allows for querying of the data to create reports
Flexibility - It scales based on your need
Robust - Can connect with reporting software such Crystal Reports to build even prettier reports.,For those unfamiliar with SQL, it will be a sharp learning curve,8,Makes my executive team happy because we can get the data out of the DB
Has allowed us to pursue targeted marketing the because the data is there.,8,9,10Josh Rice, MBA, ACSPA database that guarantees the company for the future2018-03-26T22:56:55.886ZCertainly from the whole organization: the product is used by all the ICT departments, by the departments that develop the applications and by the departments that manage the systems. Business departments use data to create dashboards or reports using Cognos automatically. The fact that it is multiplatform allows us to decide from time to time at what level the database must reside.,Easy to use with SQL programming
High availability
An extreme certainty of the data,High consumption of mainframe processor
Use of the plan for data access too rigid
Use of very limiting DRDA gateways,10,high quality cpu consumption
delicate management of recovery through the log
necessity of constant maintenance through utilities,10,10,10,oracle, vsam and dl1,IBM CICS, IBM Tivoli OMEGAMON, WebSphere Application ServerVerified UserDB2 easy access2018-06-27T15:05:24.822ZWe are using DB2 in our IT department. It's used as a back-end tool and specifically, we highly leverage the DB2 client tool to connect to IBM IAccess to do data connections to feed other inventory tools.,DB2 provides a strong command line interface
Very resilient DB connection
Integrated very well with IBM product,Maybe they could have a simple UI interface similar to MSSQL management studio,8,Positive, as it provides simple and stable data access to multiple other systems.,9,9,9,Microsoft SQL Server,Microsoft SQL Server, Microsoft Azure,100,2,Data access
Data portability
Data Availability,Standard use,For us, the use case is pretty set.,8,No,Product Features,Do it in-house instead of relying to a greater extent on the consultant recommendation.Verified UserDB2 does what it needs to do2018-04-03T21:29:01.718ZIt is used as the database for our ERP system that is utilized by the entire company. It addresses our need for stability and performance from our main source of data.,It is stable
It runs well without active DBA management
It performs well when we need it to,Does not have the most sophisticated features
At its core it utilizes IMB "green screen" interface,9,We do not have downtime related to database issues,9,9,10,,Oracle JD Edwards EnterpriseOne, Microsoft Project, Microsoft Office 2016, ConnectWise Control (formerly ScreenConnect), OneNoteVerified User
Unspecified
DB2
64 Ratings
