As finance institution …
- Setup of HADR Table Partitioning Upgrade of Db2 from 10.5 to 11.5 …
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Db2, and make your voice heard!
Db2 on Cloud Lite
Db2 on Cloud Standard
Db2 Warehouse on Cloud Flex One
Entry-level set up fee?
- Setup fee optional
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
- Tech Details
IBM Db2 empowers developers, DBAs, and enterprise architects to run low-latency transactions and real-time analytics equipped for the most demanding workloads.
From microservices to AI workloads, Db2 is a hybrid database providing availability, built-in refined security, scalability, and intelligent automation for systems.
Mission critical environments require continuous availability and tolerance for failure. Db2 availability enables users to run workloads without interruption.
Db2 protects data with in-motion and at-rest encryption, auditing, data masking, row and column access controls, and role-based access.
Db2 grows with users, scaling up and out as workloads evolve and performance needs change.
Built-in container operators automate time-consuming database tasks, while keeping the business running. Users can build apps while using Db2's advanced workload management automation and ML-optimized query engine.
Db2 can be run in the cloud, on-premises, or in hybrid environments.
- Supported: Data compression
- Supported: Query Compressed Data
- Supported: Elastic scaling
- Supported: Continual data ingestion
- Supported: In-memory analytics
- Supported: In-database ML
- Supported: Multi model
- Supported: Data Lake integration
- Supported: High Availability Disaster Recovery (HADR)
- Supported: Continuous availability
- Supported: In-motion and at-rest encryption
- Supported: Data auditing
- Supported: Data masking
- Supported: Row/column access controls
- Supported: Role based access
- Supported: Label-based access
|Deployment Types||On-premise, Software as a Service (SaaS), Cloud, or Web-Based|
|Operating Systems||Windows, Linux, UNIX|
SAP HANA Cloud
Microsoft SQL Server
SAP Adaptive Server Enterprise (ASE), legacy
Teradata Vantage Advanced SQL Engine (Teradata Database)
- Extremely reliable DBMS with quality support.
- It works with great encryption and decryption features.
- Easy scalability.
- Great connection between Cobol and db2
- Queries and transactions in milliseconds.
- Some query syntaxes are different, but in a short time it's easy to learn.
- Licensing can be an issue due to the high value of the premium version.
- Bind together your information.
- Interface dashboards and reports with the force of quick ingest and querying for constant bits of information.
- Enable high performance and cost predictability based on object storage
- Simple, Efficient and Reliable
- Auto querying techniques
- More enhanced dashboard features
- Simplified navigation while jumping in data
- Using the SQL SELECT Statements
- CRUD operations
- Running user-defined functions and stored procedures
- Connecting to report writer
- Connection to Visualization Tools (PowerBI, Tableau)
- Connection to Reporting Tools (JasperSoft)
- Connection to PHP
As finance institution we have high workload of transactions which cannot have downtime and HADR feature meets our goal.
- High availability of mission critical business application using HADR.
- During upgrade of OS or Db2, pretty much seamless upgrade is done.
- Overall performance is great despite of our secondary node is remotely located.
- Documentation is sometime unclear or confusing.
- Would be good idea if we can estimate the time needed for index rebuild to complete.
- Db2 primary should propagate all configs (DBM, DB, Registry) to standby automatically.
- Low latency
- Simple design
- Easy to use
- Seamless integration
- Advanced functionality
- Incorporate more Analytical functions
- INSERTs/ALTERs/DELETEs of rows in a table.
- SQL queries
- Many checks, before insering a row in a table (row duplication, data characteristics, data range, nuls, etc, etc, etc...
- Maybe the SQL Reference manual have a chapter or an appendix, clarifying for each one ot the comands/functions/processes/etc at which level they act, row, table, tablespace, indexspace, stogroup, database, DB2 sub-system, etc
- But if not, here goes the suggestion: Add it!
- I do not know if the SQL Reference, or any other manual have this kind of information.
- If not, I suspect it will be a good idea to have it.
- The correlation between the various types of DB2/SQL data and the types in all languages available at the mainframe
- I suspect a chapter, in SQL Ref manual, explaining in detail the operands working over two or more tables, will be of great help.
- I remember the JOIN operand, but have a vague recall there are others.
- You see, there is not even an small section about JOIN, with a corresponding entry in the CONTENTS list at the beginning of the manual. :(
- Making a search for the word, we only see texts on how to use JOIN in such and such situations/conditions, but NO explanation at all about it
- I made, too, a global search in most of the DB2 manuals. There are lots of rows with the word JOIN, but apparently again only to inform how to use JOIN in some situation.
- Maybe in a good class of SQL they will explain the JOIN,
- Unfortunately when I started to support IzPCA, I neede to learn DB2/SQL by myself, reading the manuals, and testing :(
- A chapter or a major section explaining in detail the JOIN (and similar operands, if they exist), certainly will be of great help.
- For me, and for the people starting now with DB2/SQL :):)
- If that chapter or section, by any chace really exists, please, inform me the manual name. Thx :)
- Handle huge data
- Robust with big data
- Huge range of application compatibilities
- Easier than others to administer issues and performance bottlenecks.
- Ability to restore tables from backups
- Availability of Db2 on public clouds other than IBM
- Setup of HADR Table Partitioning Upgrade of Db2 from 10.5 to 11.5 and Fix
- Pack Applications Database Replication using IBM WebSphere MQ
- Installation and setup of Db2 databases and client servers
- Restoration of local backup from one server to another
- Long duration of local backups HADR Replication
- Query Optimization
- HADR Replication
- Easy installation
- Message Queue Replication
- Duration of Backups
- Table Runstats & Reorg Duration
- Rock stable database engine
- Extremely consistent to deploy and operate across many major versions
- Nevertheless increasing number of good features (e.g. time travelling, compression, encryption, Graph engine, etc.)
- High level of compatibility with Db2 on zOS - easy to migrate
- Hard to tell where Db2 really NEEDS improvement - I might have been working with that DBMS for too long...
- Yes, there has been some reduction with Db2 support, but that's improved a lot again over the last year. And yes, there have been some flaws with new features and a few security vulnerabilities in the last 2 years, but that's also been stabilized quickly by Db2 development.
- One thing that comes to my mind as an improvement would be a really great and flexible function for pivoting data. There are ways to achieve it, but flexibility and simplicity would be awesome.
Plus of course the imho unique DPF setup which pushes Db2's MPP capabilities to stretch a single database across many (physical or virtual) servers and even extends such huge systems to support HA configurations.
- Storage optimization
- Rapid database development
- pureScale technology, which focuses the database on availability and scalability
- Simplicity and security when performing migrations
- Ease and flexibility in implementation
- The relational model requires a rigid schema that does not necessarily fit with some types of modern development.
- Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
- As data grows in production environment, it becomes slow.
- portability of SQL with other Db2's
- easiness of use/administration
- TSA and integration of other products
- Automated system.
- Ease of querying data.
- Easy integration with other tools.
- Intuitive features to improve integration.
- If it could work faster from the cloud, it would be much better.
- Otherwise, this platform can be used by experts and developers who are just starting out in this world.
- Easy to install and run, no subject matter expertise required.
- Great compatibility with other tools.
- Your database is quite manageable.
- Technical Service that guarantees the proper functioning of the product.
- Search speed needs to be improved, it's quite slow.
- Overall, this product has nifty features that work seamlessly with top-of-the-line technology.
- Return queries of large datasets.
- Store data
- Need options for reading in Foxpro data.
- DB2 has build in replication tools make online data replication/movement much easier and fast.
- DB2 HADR is reliable, keep Database up and running 99.99% of time, switch beween servers in seconds.
- DB2 Federation make the access to all kinds of Databases like in one.
- DB2 is stable on Linux/AIX even Windows.
- DB2 Locks is too strict, very little flexibility
- Like to more built-in function, procedure for Analysis/Reporting
- Love to see DB2 can go open source, so that it can get more developer involved
As of scalability, we can do vertically so far.
- transactional workloads at high volume
- encryption at rest and in flight
- manages large objects LOB/BLOB/XML well
- everything about Db2 is 'heavy', even the Community edition and some of the clients
- difficult to configure for beginners /option overload
- LUW and z platforms have minor inconsistencies that really should be a non-issue
- support seems to be declining in terms of quality/quickness of responses
- Easy and user friendly. Secure and productive.
- Easy connection strings via programmatic use and procs.
- Database security, own interface, SPUFI, QMF.
- On a black screen with no GUI, can explicitly go like DB2 visualizer.
- More time required to pull data and time delay.
- Not enough exposure to the product as a lead, need guidance from DBAs at times to learn.
- Costing is too high.
- Bulletproof transaction processing
- Continuous availability
- Ease of Administration
- Excellent throughput
- Version upgrades require an outage.
- Reliable and secure.
- Excellent performance.
- Cross platform.
- Lack of modern client tool to connect and query database.
- Robust Relational database.
- High Scalability.
- High Performance.
- Best Query optimizer.
- Its costing is too high.
- It can be easily scaled up
- It offers good region support
- Data is encrypted and secure
- DB2 web console is not so stable
- Not able to see long-term DB2 metrics data
In our experience, some database service offers more than one URL, so our application needs to handle the failover.
- Auto Scaling
- Optimized performance
- Import excel or csv file format
- Price difference in different regions[.]
- Could provide better Documentation[.]
- Can optimize performance matrix reports.[.]
- Very fast to retrieve data from IBM Db2 on Cloud.
- Store large files in the database in an easy way.
- Store data and access it in different locations.
- Runs and scales well on IBMs power-based platforms.
- Data recovery and back-ups can be complex to new users.
- Only runs and scales well on IBM power-based platforms.
- Can be complex to beginners when migrating XML data.