What users are saying about

1010data

5 Ratings

DB2

64 Ratings

1010data

5 Ratings
Score 5.2 out of 101

DB2

64 Ratings
Score 8.3 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

DB2

DB2 is suitable for any use. The main one is certainly the creation of an online database that can be queried online through TP queries and through batch reports. It is necessary to take care of the database maintenance to allow maximum performance, for this, there are the utilities that help the system operators to do it.

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
  • Easy to use with SQL programming
  • High availability
  • An extreme certainty of the data

Cons

  • The ten.do interface could use more detailed documentation
  • You cannot run multiple secondary nodes or cluster without additional software purchases; in some cases third party tools. This drastically increases your overall capital investment. The only way to accomplish a true HADR scenario is to set up NEARSYNC in one datacenter and do logshipping to another datacenter. Downside: You have to wait for the final log ship to complete before your DB is back up.
  • Licensing is prohibitively expensive! If you are not grandfathered in, IBM licensing for a multi-datacenter, PRIMARY, SECONDARY, and Disaster Recovery (DR) setup can be in the multiple $100,000 range.
  • Data Studio is built on IBM's Rapid Application Development (RAD) tool, built on Eclipse. So the download is in the multi-GB range and it includes a ton of bloatware not needed for your standard database maintenance. Control Center is a simple, powerful tool at a quarter of the disk space.
  • Support for DB2 is very hard to come by without paid IBM support. Even then, opening PMRs does not solve problems as the response time for any PMR is always more than two (2) hours, even for enterprise-level paying customers. They always want the most inane log files that have nothing to do with DB2 or its operation, or they want core dumps during the issue. This becomes useless when the issue is "our database just crashed and you can't get those logs right now because I do not want to replicate the cause!"
  • DB2's SQL syntax, while ANSI in CRUD opertaions, is different than Oracle. PostgreSQL, MySQL, and even MS SQL. One must become accustomed to a different syntax for LIMITs, cursors, record counting, stored procedures, user-defined functions, and even table / index creation or altering.

Likelihood to Renew

No score
No answers yet
No answers on this topic
DB28.0
Based on 2 answers
Because it is required to support our business unit

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
DB25.0
Based on 1 answer
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.

Reliability and Availability

No score
No answers yet
No answers on this topic
DB29.6
Based on 8 answers
Very stable in AIX and Purescale cluster and can still be up when parts still fail. We have had db2 instances up for years, without any issues.

Performance

No score
No answers yet
No answers on this topic
DB29.2
Based on 8 answers
I have not noticed any performance issues with the software. When you are trying to pull a massive query, it can take a minute or so, but otherwise, it works well.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
DB2 is much more robust than Oracle or mySQL when used in the Z/OS or Linux platform as it has the best error detection/warning system and also is very fast when accessed over the LAN in remote branch locations. It is scalable to a limited extent though as is the case in all relational database management systems. It is a high availability data base that can support mission critical applications in an enterprise and has had a proven track record over the last 30 years.

Scalability

No score
No answers yet
No answers on this topic
DB29.2
Based on 8 answers
It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
  • It is very robust and hence [provides] value for money
  • Also has a free version that is very robust for a smaller organization
  • Used a centralized DB2 database across the organization and hence saved infra investments

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

1010data More Information

DB2

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

DB2 More Information