IBM Db2 Database Stability

SH
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.

View full review »
DD
Senior project manager (APAC region) at FreeBalance

It is a stable solution. It offers good stability. 

View full review »
Daniel Tamiru - PeerSpot reviewer
Manager, Database & System Administration at Awash International Bank

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.
Balamurugan Ramalingam - PeerSpot reviewer
Senior Quality Assurance Consultant at Public and Business Service Delivery

Stability-wise, I rate the solution an eight and a half out of ten.

View full review »
BN
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.

View full review »
MK
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 »
Siddharth Matalia - PeerSpot reviewer
Senior Technical Specialist at a manufacturing company with 10,001+ employees

I rate the stability of the IBM Db2 Database a nine out of ten.

View full review »
NG
DB2LUW and Couchbase ADMINISTRATOR at HCL Technologies

This is a stable product. It doesn't crash or freeze. 

View full review »
MR
DBA at a tech vendor with 201-500 employees

It is very stable.

View full review »
Cosmin CIobanica - PeerSpot reviewer
Global Solutions Architect at a tech vendor with 10,001+ employees

It is a stable solution.

View full review »
MR
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 »
Md Al-Amin - PeerSpot reviewer
Senior System Analyst at Thakral

The platform is stable. I rate the stability an eight out of ten.

View full review »
RD
Senior Cyber Security Specialist at a tech vendor with 10,001+ employees

I rate Db2 eight out of 10 for stability. 

View full review »
Luigi Notarantonio - PeerSpot reviewer
DevOps Engineer at Cy4gate srl

IBM Db2 Database was stable, we didn't have any issues.

View full review »
Georges BOMBOH - PeerSpot reviewer
Director at Pharos Consulting

It's very stable, and the performance is very good.

View full review »
S-
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
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
Database Engineer at Habib Bank

The tool is stable. I rate the tool's stability an eight out of ten.

View full review »
AA
CIO at Mobica

The solution is very, very stable. 

View full review »
SP
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 »
Giuseppe Innamorato - PeerSpot reviewer
Senior Client Director at Alkemy digital_enabler

The solution is stable.

View full review »
BN
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.

View full review »
SR
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
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
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
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
Test lead at Percik Consulting

It is a stable solution. I rate its stability nine out of ten.

View full review »
NG
Solution Director at HCL Technologies

It is quite a stable solution. I rate its stability as an eight.

View full review »
Md Al-Amin - PeerSpot reviewer
Senior System Analyst at Thakral

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 »
it_user700098 - PeerSpot reviewer
Project Manager at a tech services company with 10,001+ employees

There were no issues with stability.

View full review »
PK
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
DA / DBA at Discount Bank

The solution is stable. No technical issues have ever occured.

View full review »
DipenMehta - PeerSpot reviewer
Team Lead at ATOS

IBM Db2 Database is stable.

View full review »
SA
Technical support manager IBM Power systems at a computer software company with 51-200 employees

The solution is stable. 

View full review »
HB
Domain architect at a financial services firm with 10,001+ employees

I have found the solution to be scalable.

View full review »
SK
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.

View full review »
AV
System Administrator at a tech services company with 51-200 employees

This solution is stable.

View full review »
GD
Security Analyst at a insurance company with 1,001-5,000 employees

There were no stability issues.

View full review »
DL
Mainframe Application Analyst / Developer at a insurance company with 10,001+ employees
WC
Service Director at scsi co.,ltd

It is a stable solution.

View full review »
NI
Software architect at Bergen

Db2 is stable and reliable.

View full review »
MR
IT Developer at a financial services firm with 10,001+ employees

IBM Db2 Database is stable.

View full review »
WC
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 »
Ahmed Ashmawy - PeerSpot reviewer
Data Practice Lead at Hyve Technology Consulting

The solution is stable. 

View full review »
Md Al-Amin - PeerSpot reviewer
Senior System Analyst at Thakral

There were a few hiccups directly after installation, but Db2 has been very stable since then.

View full review »
EC
IT Director at BISTP

This solution is very stable. We have had no problems since it was set up.

View full review »
it_user698637 - PeerSpot reviewer
DB2 DBA at a financial services firm with 10,001+ employees
it_user75351 - PeerSpot reviewer
VP of IT at a financial services firm

Not very solid compared to its competitors' products.

View full review »
SM
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 »
it_user121524 - PeerSpot reviewer
Sr. System Architect at a tech services company with 1,001-5,000 employees
ME
Enterprise Solutions Architect at a computer software company with 201-500 employees
DD
Lead Code Wisperer at a tech vendor

Hah! You kidding. DB2 for i? No. Never.

View full review »
IS
Managing Director, North America at Business Consultants, Inc.

The solution is very stable.

View full review »
it_user77925 - PeerSpot reviewer
Engineer at a tech services company

There were no issues with stability.

View full review »
it_user442923 - PeerSpot reviewer
VMware & Storage Design Lead at a university with 1,001-5,000 employees

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 »
it_user700107 - PeerSpot reviewer
DBA with Oracle Database, IBM DB2 and Cloudera Hadoop project at a financial services firm with 5,001-10,000 employees

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
CEO at a tech services company with 51-200 employees

In my experience, it has been stable.

View full review »
JK
CTO at Jutel

It has been very stable.

View full review »
it_user700134 - PeerSpot reviewer
SAP Basis Administrator at a pharma/biotech company

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.