IBM Db2
IBM Db2 | IBM Db2 Developer-C 11.1.4.4Linux/Unix, Red Hat Enterprise Linux 7.6 - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
An excellent database, but difficult to study...
What do you like best about the product?
It is a robust, reliable database designed to support large workloads.
What do you dislike about the product?
Extremely difficult to learn. All companies I've met that use DB2 use it in Mainframe environments, which is practically impossible to replicate on a small scale to study. And all training I've seen for DB2+Mainframe, are absurdly expensive, because the professional who can teach is expensive and the environment to study too. That's why I see few professionals working with this technology. To be honest, I don't remember any DBA my age who paid to learn DB2; the few I met, already worked in a company and received the training.
What problems is the product solving and how is that benefiting you?
The last project I worked on directly with DB2 was in 2011. As I couldn't learn the technology, I focused my studies on competing databases such as Oracle and MSSQL.
Recommendations to others considering the product:
You have to calculate very well the financial cost of using IBM. When I had access to the costs, compared to Oracle and MSSQL, it was the highest.
Whether in licenses, hardware and especially professionals.
Whether in licenses, hardware and especially professionals.
- Leave a Comment |
- Mark review as helpful
Not functional on EC2 Instance type t2.micro
When you use this image in combination with an EC2 Instance type t2.micro, the resulting instance is not functional :
$ db2 connect to sample
SQL1084C The database manager failed to allocate shared memory because an
operating system kernel memory limit has been reached. SQLSTATE=57019
$
It becomes functional from the t2.small EC2 Instance type onwards.
Better alternative available
What do you like best about the product?
It is compatible with various ERP systems which are used by organizations. Software is effective
What do you dislike about the product?
Not enough resources around available who are trained in it and the training new ones is very expensive since it is not in demand in market
What problems is the product solving and how is that benefiting you?
We use it as the database for our PeopleSoft system
Recommendations to others considering the product:
Check out alternatives,
Very Old DB tool
What do you like best about the product?
Nothing much, pretty much old tool and complex for new user
What do you dislike about the product?
not simpler as compare to other DB available in the market. Need more infrastructure to support
What problems is the product solving and how is that benefiting you?
no benefits, Infact we are moving out from DB2
Recommendations to others considering the product:
There are better DB application available in the market than this product
Used datastage for ETL process
What do you like best about the product?
It offers many features and does the ETL process relatively well
What do you dislike about the product?
The whole interface is outdated, due a update to modern gui expectations.
What problems is the product solving and how is that benefiting you?
Extracting data from SAP to SQL server
Recommendations to others considering the product:
I wouldn't recommend datastage.
Stone age relic that is barely trying to look modern. (DB2 LUW)
What do you like best about the product?
It's being replaced at our shop gradually and will likely be pushed out the door. That's about it.
What do you dislike about the product?
Wow! Where to start? The stone age interface at operating system level? The many kludges and signs of neglect? The lack of support in the community and the vendor? The horrid documentation by IBM? The ridiculous backup and restore procedures? I guess the biggest problem is that it's an IBM product. The vendor has a horrible track record with in-house and acquired software that's been Blue-washed.
What problems is the product solving and how is that benefiting you?
This was originally sold to the business as a cheaper (and better) solution to the rising prices that Oracle was invoicing. It was cheap for a few years and then the prices for the product started increasing. One of the issues we've seen is that UPGRADES TO A NEW FULL VERSION LEAVE REMNANTS OF THE OLD VERSION AND IBM CONTINUES TO CHARGE FOR BOTH VERSIONS. We haven't found the mechanism to clean this up as yet due to the convoluted licensing.
Recommendations to others considering the product:
Run away . Consider something else. IBM is not a vendor you would want on your site in any case.
DB2 Review
What do you like best about the product?
DB2 is a very performant database system. I've used it on mainframes mostly which has it's own set of idiosyncrasies compared to a normal server version. It stores data quickly and uses a very standard set of SQL unlike Oracle who has tried to get everyone on their version SQL forever.
What do you dislike about the product?
It's old, which in a lot of cases makes it preferred, especially in DB's, you want all of the bugs worked out. In this case though, it's behind the times on a lot of newer features. It's only for enterprise customers, there is no way to work it into a small budget company's app. There is no auto sequence for id's, you have to query some sequence table and put it in the id column, you could use a trigger I guess but it could easily be done for you like oracle or others.
What problems is the product solving and how is that benefiting you?
Used to store data on a mainframe for a bunch of internal app. Very big metal operation.
Recommendations to others considering the product:
Build a set of utilities in your app to handle commonly used tasks, it will speed up further development.
showing 1 - 7