DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
$0
IBM Z
Score 9.3 out of 10
N/A
IBM Z is the company's mainframe enterprise server solution product line.
These are not that effective when there is a lot of data, and the outage is more in other products as compared to the IBM Z. The processing Capabilities of the Z OS are much better than these products since, in my organization, the processing data is huge, and the IBM Z is best …
IBM/IMS Tools compare favorably in use and performance against other vendors such as BMC. We support both within all our mainframe/zOS products so our users have the flexibility to choose the tools that work best for them and their users and budgets.
IBM Z is the winner when dealing with enormous transactions In terms of security as well IBM Z is a better option compared to other alternatives Excellent is dealing with large batch processing in multiple environments.
ICP from IBM is one product that excels on System Z. The technology called secured LPAR we are able to encrypt not only the data but the whole machine so that it can not be broken into. Also, ICP product is the same as it is for any other platform so developers are able to pick …
I have been working with Z Enterprise Servers for 30 years and they have been called many different things over those years: mainframe being the name I am still most comfortable with. I choose to work with them because of their high availability, transaction processing …
I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
Most of the time, server utilization is reliable and stable during peak times. Truly amazing, this product offers a lot and gets it done in no time without any confusion.It is reliable, too accurate and the performance is top-notch. It seems to be competitive in all virtual energy systems and its connectivity is also good. It's available at a low cost, but it's enough to have as many low-cost, more efficient systems as possible. It's a minor thing, but very rarely, it can cause work interruptions while it can get stuck due to more frequent use such as restless work. These power servers are very efficient and really help when things go wrong. I am using this product to retrieve data much faster.
The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
The IBM Z mainframe capabilities are unmatched for cloud readiness and optimization the learning capabilities are matched perfectly with Watson and the expandability of the cloud makes it a perfect choice.
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.
I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Performance is a major part when you configure your system. IBM has many tools to study your system and suggest the appropriate configuration. With the right contract, you can add processing power dynamically and remove it when no longer needed
Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
Support is usually superb, only occasionally dropping to very good. We participate in some of the CD (Continuous Delivery) aspects of z/OS, IMS, MQ, and DB2.
DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out better than other similar products.
IBM Z is the best storage solution as it provides the best in class data protection with the cryptographic hardware keys, no loss in data while migration, and a user-friendly interface that makes it easy for develops to understand and has less of a learning curve. This makes it well above the competition.
By using DB2 only to support my IzPCA activities, my knowledge here is somewhat limited.
Anyway, from what I was able to understand, DB2 is extremely scallable.
Maybe the information below could serve as an example of scalability.
Customer have an huge mainframe environment, 13x z15 CECs, around 80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this last figure...)
Today we have 7 IzPCA databases, each one in a distinct Syplex.
Plans are underway to have, at the end, an small LPAR, with only one DB2 sub-system, and with only one database, then transmit the data from a lot of other LPARs, and then process all the data in this only one database.
The IzPCA collect process (read the data received, manipulate it, and insert rows in the tables) today is a huge process, demanding many elapsed hours, and lots of CPU.
Almost 100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7 database, it is a really a huge and long process.
Combining the INSERTs loads from the 7 databases in only one will be impossible.......,,,,
But, IzPCA recently introduced a new feature, called "Continuous Collector".
By using that feature, small amounts of data will be transmited to the central LPAR at every 5 minutes (or even less), processed immediately,in a short period of time, and withsmall use of CPU, instead of one or two transmissions by day, of very large amounts of data and the corresponding collect jobs occurring only once or twice a day, with long elapsed times, and huge comsumption of CPU
I suspect the total CPU seconds consumed will be more or less the same in both cases, but in the new method it will occur insmall bursts many times a day!!
If you need more processing power, just add more CPU's or memory. The largest system can have close to 200 CPU's and 40 TB of memory. If that is not enough, you can add more physical computers, and connect them using a sysplex
There is great value the solution brings when it comes to building stored procedures and ongoing tasks that allows our team to streamlines processes.
The platform has allowed us to see value by providing a solution for data structuring and data hygiene which prevents deduplication of data and lowers costs
With the integration capabilities it allows our analytics team to more seamlessly create highly visible dashboards that see directly into the data and pinpoint areas that need attention.
