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.
DB2 is the best possible way you can integrate SQL to Mainframe
What do you like best about the product?
The best part in my experience was direct SQL integration int COBOL programs. I had prior SQL experience when I started writing COBOL programs I didn't face any difficulty whatsoever. Moreover there are regular upgrades which we handle, which adds to the stability and reliability of system.
What do you dislike about the product?
There is no way to preview a query result in DB2-Cobol environment, you have to go the output data set again and again. If there is a quick window to preview a query like in SQL Server etc, that would be great.
What problems is the product solving and how is that benefiting you?
I am working for an insurance client which maintains the insurance data in DB2 enviornment. They keep all the data like active policies, payment details, demographics, family details etc for each customer.
The data has to be really secure so that no one can alter the payment or do any insurance fraud, and DB2 provides that security along with Mainframe environment to an extent that whole system is comparatively really secure from hackers as compare to Oracle etc.
There are also computational benefits, it helps execute millions of rows of data in quick time which reduces costs.
The data has to be really secure so that no one can alter the payment or do any insurance fraud, and DB2 provides that security along with Mainframe environment to an extent that whole system is comparatively really secure from hackers as compare to Oracle etc.
There are also computational benefits, it helps execute millions of rows of data in quick time which reduces costs.
- Leave a Comment |
- Mark review as helpful
DB2 ETL tool
What do you like best about the product?
It’s is flexible in using aggregate functions For cognos it is flexible using
What do you dislike about the product?
DB2 is not compatable of joining style same like SQl
What problems is the product solving and how is that benefiting you?
Benefits I worked for cognos . It’s flexible with cognos
Recommendations to others considering the product:
Surely considering
DB2 to Oracle conversion for a product.
What do you like best about the product?
It is relational so It uses Standard SQL, which makes it easier to write queries once and done with it.
What do you dislike about the product?
GUI is not very user friendly.IBM should make some next-generation features available.
What problems is the product solving and how is that benefiting you?
Currently nothing. In the past, a client had DB2 as a backend so we had to write queries specific to DB2.
Good experience
What do you like best about the product?
1. Search options
2.BLOB viewer
3.HADR
4.Explain
2.BLOB viewer
3.HADR
4.Explain
What do you dislike about the product?
Explain could have SQL query optimization.
Auto suggests could be better.
Auto suggests could be better.
What problems is the product solving and how is that benefiting you?
Enterprise solution for Health firm, data management is easy and usage is intuitive.
We handle data for 80000 users.
We handle data for 80000 users.
Recommendations to others considering the product:
Very good tool which increase your productivity.
User experience is very intuitive
What do you like best about the product?
Using spufi to execute queries is hassle-free
What do you dislike about the product?
Too many options in a single screen. This could be laid out well
What problems is the product solving and how is that benefiting you?
I am executing queries and developing cobol-db2 programs which are very helpful
Recommendations to others considering the product:
It is easy to use and intuitive
It was nice experience to use IBM db2
What do you like best about the product?
I like the control center (DB2 client) very much.
I like XML data type very much.
I like XML data type very much.
What do you dislike about the product?
Nothing. Don’t really know the internal of DB2
What problems is the product solving and how is that benefiting you?
It’s awesome
Db2 connect
What do you like best about the product?
Db2 is really helpful and best for new comers to write down queries from their own
What do you dislike about the product?
Used DB2 for publishing records on Hadoop and don't see any issue so far
What problems is the product solving and how is that benefiting you?
Solving for migration work in Hadoop and you got data on the air everytime
IBM DB2 Review
What do you like best about the product?
Data security, reliability, efficiency, ACID properties all this in very optimal cost.
What do you dislike about the product?
The limited memory and processors. Also, most of the its brilliant features are not greatly publicized/promoted.
What problems is the product solving and how is that benefiting you?
I have worked on the settlement process of transactions from giant payment solutions, currently part of insurance business. Throughout the IBM DB2 journey was a great experience to have, I found it easy to handle besides having complex background foundations.
Recommendations to others considering the product:
It is amazing, go on try it!!
IBM DB2 Review
What do you like best about the product?
The simplicity of IBM DB2 is fantastic in the use I need.
What do you dislike about the product?
The architecture doesn't allow me to do some of the things I can do with other SQL environments.
What problems is the product solving and how is that benefiting you?
IBM DB2 allows for inputting data quickly into a green screen that cannot happen with the current GUI's.
Completely safe and faster than any other modern database
What do you like best about the product?
Non vulnerable to attack, easy to code..
What do you dislike about the product?
UI and realtime monitoring of the code..
What problems is the product solving and how is that benefiting you?
Same software to build codeand access database
Recommendations to others considering the product:
Less efforts to be given on security point of view.
showing 151 - 160