IBM Db2 Database Stability
SH
reviewer1715946
Mainframe Technical Manager/Service Integration Lead at a tech services company with 10,001+ employees
Sometimes it's how you go about system management processes within the environment, and not always the product itself. If, for example, we're going to put maintenance onto the Db2, we would do that in a sandbox environment first. We would test that the Db2 that we've put the maintenance on can exist or coexist in the same cluster as the ones we haven't put the maintenance on. That's the first thing.
We would test functionally and can regress that maintenance in case we introduce a defect, or it causes an application defect. Coexistence and regression are very important in the sandbox.
After we've signed that off, we would move it into the development environment where they've got all the different development services, integration, UAT, dev-test, pre-production, model production, et cetera. We would let the development workloads test the Db2 instance there and see that that's working. If that's okay, then we upgrade the other Db2 instance in the cluster. Finally, we put it into the production environment.
Therefore, you're not going to do a big thing. You're putting your maintenance in on 50% of the database environment so that you've got ability and capacity on the other side where you haven't made that change. And you've already proved coexistence and regression, should there be a defect identified through the application.
I like the way that Db2 allows us to do that. Certain DBMS environments, you have to upgrade them all to the same level. Some of them have to be patched quite regularly due to security. However, in the mainframe, it's not too bad.
When I first came here, they were putting the maintenance and the new release, they would do it across the whole cluster. Which, if we had a problem with some of the applications that are running in there, we would have to regress that, which would probably mean an outage. There are operational or system management processes that we've tuned and we've improved so that we're mitigating against any service disruption.
The way the IBM z/OS Db2 environment's designed does allow coexistence. It does allow us to upgrade 50% of it, or 25% of it, and leave it running alongside one that's back level - as long as we've proven our coexistence.
DD
Devashish Dutta.
Senior project manager (APAC region) at FreeBalance
It is a stable solution. It offers good stability.
View full review »The solution is very stable. In the past three years, we have only experienced one crash.
View full review »Buyer's Guide
IBM Db2 Database
March 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Stability-wise, I rate the solution an eight and a half out of ten.
View full review »BN
reviewer1420620
Product Development Manager at a tech services company with 11-50 employees
The solution is quite stable. It's not a simple database, but it comes with the territory. The product has existed for a long time, since the late 80s. The team has experience in databases, and maintaining them is a breeze for them. The tool is a futuristic database. I witnessed teams in IBM do time travel queries in 2012. The tool’s version 10 had already implemented time travel queries. Years later, we saw the features in other databases.
The product is years ahead of technology and architecture. It helps software developers have very good features that are years ahead. Now people are really focusing on the cloud. I'm sure they have features that help software engineers or developers work or code with the cloud in mind.
MK
Madhav Kondapalli
Solutions Architect at a retailer with 10,001+ employees
It's a stable solution. It's been around for quite some time and is very mature. It's reliable. There are no bugs or glitches, and it doesn't crash or freeze.
View full review »I rate the stability of the IBM Db2 Database a nine out of ten.
View full review »NG
Nanthagopal G
DB2LUW and Couchbase ADMINISTRATOR at HCL Technologies
This is a stable product. It doesn't crash or freeze.
View full review »MR
Michael-Raz
DBA at a tech vendor with 201-500 employees
It is very stable.
View full review »It is a stable solution.
View full review »MR
Michael Raz
DA / DBA at Discount Bank
It is very stable. There are organizations where Db2 has been working for more than a year and sometimes, for many years without going down. The operating system as well as Db2 work for a long time. There is no downtime at all.
View full review »The platform is stable. I rate the stability an eight out of ten.
View full review »RD
RamneshDubey
Senior Cyber Security Specialist at a tech vendor with 10,001+ employees
I rate Db2 eight out of 10 for stability.
View full review »IBM Db2 Database was stable, we didn't have any issues.
View full review »It's very stable, and the performance is very good.
View full review »S-
Suhendri -
Department Head of Big Data and Analytic Solutions at a tech services company with 501-1,000 employees
This solution is stable. It's good.
View full review »SK
SamirKhodair
Implemenation Specialist at a engineering company with 10,001+ employees
The solution is stable. Even if there are a large number of records, the performance stays the same. There are no bugs or glitches and it doesn't crash or freeze.
View full review »FM
FarhanFarhan
Database Engineer at Habib Bank
The tool is stable. I rate the tool's stability an eight out of ten.
View full review »AA
Amr-Ahmed
CIO at Mobica
The solution is very, very stable.
View full review »SP
reviewer1932312
Architect at a wellness & fitness company with 1-10 employees
IBM products are very nice and perform very well.
IBM Db2 Database is a stable product.
View full review »The solution is stable.
View full review »BN
reviewer1420620
Product Development Manager at a tech services company with 11-50 employees
It is stable. The 10.5 Fix Pack One was not very stable. We also had Fix Pack 4, also called Cancun Release, which was very stable. As the product has evolved, it is more stable now than it was a couple of years ago.
SR
Solomon Rundasa
System engineer at a financial services firm with 10,001+ employees
There are no real issues with the overall stability of IBM Db2 Database.
View full review »KK
KamleshKhollam
Managing Consultant at a computer software company with 501-1,000 employees
The stability of IBM Db2 Database is stable. We have not faced any downtime in one year. Our work is mostly during business hours and during that time, we haven't faced any downtime. However, we did see some performance issues when we are running multiple queries. The client's setup could be causing these performance issues. We are pushing that client to have the environment ready for multiple users so that they can query the database easily and faster data travel.
View full review »SM
reviewer1031649
Senior Systems Architect/Analyst/Developer at a logistics company with 1,001-5,000 employees
The solution is stable and reliable. The hardware does not fail, the software does not fail, and so the reliability is there, however, the reliability isn't necessarily Db2, it's the fact that it's the IBM i that has the reliability. Db2 is inheriting that, and again, is staying up and running because of that.
View full review »YS
reviewer1432260
Global Infrastructure service manager at a manufacturing company with 10,001+ employees
Initially, there were hiccups, but now, it is a robust database. The only limitation that we have found is crash recovery. In terms of bugs, every database will have some bugs that will hit you. I don't see much in terms of bugs in Db2 Database. Whatever known bugs are there, we get those issues.
View full review »HV
HenrikVester
Test lead at Percik Consulting
It is a stable solution. I rate its stability nine out of ten.
View full review »NG
NAVEEN GROVER
Solution Director at HCL Technologies
It is quite a stable solution. I rate its stability as an eight.
View full review »The stability of Db2 is good. It is very stable. Once we have the installation complete and the team is done with the job, there are some customers who go five years without having to do anything to Db2. It is very stable and runs smoothly for them the entire time.
View full review »There were no issues with stability.
View full review »PK
reviewer1378284
Solutions Architect at a financial services firm with 10,001+ employees
We have observed some glitches with the database when the amount of data is growing quickly. This is why we are moving toward a microservices architecture, where each service has its own database.
At this time, because our data is growing, the glitches are frequent.
View full review »MR
Michael Raz
DA / DBA at Discount Bank
The solution is stable. No technical issues have ever occured.
View full review »IBM Db2 Database is stable.
View full review »SA
SAMI ABOU KARAM
Technical support manager IBM Power systems at a computer software company with 51-200 employees
The solution is stable.
View full review »HB
reviewer1264416
Domain architect at a financial services firm with 10,001+ employees
I have found the solution to be scalable.
View full review »SK
SamirKhodair
Implemenation Specialist at a engineering company with 10,001+ employees
In terms of stability, I have some issues, but I cannot figure out if this is due to the database or the platform in the engine itself.
Additionally, sometimes I find the response is not good, meaning a reasonable response time. For a while the team was working fine in another engine. What I look for is the design and whether the syntax is different. I don't know. I'm really not certain about the holes.
AV
AlessioVilla
System Administrator at a tech services company with 51-200 employees
This solution is stable.
View full review »GD
SecAnalyst3477
Security Analyst at a insurance company with 1,001-5,000 employees
There were no stability issues.
View full review »DL
Derez Lusk
Mainframe Application Analyst / Developer at a insurance company with 10,001+ employees
Very rarely.
View full review »WC
Wira Chinwong
Service Director at scsi co.,ltd
It is a stable solution.
View full review »NI
NikolayIgnatovich
Software architect at Bergen
Db2 is stable and reliable.
View full review »MR
reviewer909060
IT Developer at a financial services firm with 10,001+ employees
IBM Db2 Database is stable.
View full review »WC
Wira Chinwong
Service Director at scsi co.,ltd
The solution is stable so long as you don't have to make any changes to it. I haven't seen any bugs, or glitches on it. I haven't experienced crashes either.
View full review »The solution is stable.
View full review »There were a few hiccups directly after installation, but Db2 has been very stable since then.
View full review »EC
Evaristo Carvalho
IT Director at BISTP
This solution is very stable. We have had no problems since it was set up.
View full review »Not at all.
View full review »Not very solid compared to its competitors' products.
View full review »SM
Businessbc72
Business Intelligence Consultant at a university with 10,001+ employees
This is definitely a stable solution. I would rate the stability a nine out of ten.
View full review »ME
solution259344
Enterprise Solutions Architect at a computer software company with 201-500 employees
DD
Don Denoncourt
Lead Code Wisperer at a tech vendor
Hah! You kidding. DB2 for i? No. Never.
View full review »IS
IrfanSaeed
Managing Director, North America at Business Consultants, Inc.
The solution is very stable.
View full review »There were no issues with stability.
View full review »No, I had a DB2 instance running on an old IBM x3650 with Windows 2003, which ran continuously for eight years.
It was a performance data repository for our storage and fabric switches, with an average insert activity of several 1,000 per minute (had automatic record pruning setup).
View full review »Yes. We even encountered DB2 bug on the Version 9.7.0.9 and it's the reason why we upgraded to Version 9.7.0.11 .
View full review »IF
reviewer1593270
CEO at a tech services company with 51-200 employees
In my experience, it has been stable.
View full review »JK
JReviewer312
CTO at Jutel
It has been very stable.
View full review »There were no stability issues.
View full review »Buyer's Guide
IBM Db2 Database
March 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.