IBM Db2 Database Scalability

SH
Mainframe Technical Manager/Service Integration Lead at a tech services company with 10,001+ employees

We've got a two-way Db2 cluster at the moment. With two members in that cluster, we could have up to 32 members in that cluster. It's got outward scalability as well.

It's got the ability to have up to 32 members within that data sharing group or that cluster. So you could run one of these on a separate Z server, Z mainframe, which would give you quite a lot of CPU capacity. I don't know whether there are any environments out there that would need or have that. Some of the world's largest banks - maybe in America or in Asia - might have a configuration like that. For us, we're across multiple processes, and we've got the ability, should we enable for cloud at a later date, to be in a position where we can just scale-out with little disruption, by just adding more LPARs with Db2 members in. We just have to make sure that we've got the processing capacity on the mainframe to support the additional workload.

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

It is a very scalable solution. It offers very good scalability. 

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

Db2 Database is scalable. One terabyte is sufficient and works perfectly to meet our needs.

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.
767,995 professionals have used our research since 2012.
MK
Solutions Architect at a retailer with 10,001+ employees

It's quite scalable. We haven't had any issues. We can reuse DB2 mainframes, et cetera. We haven't had issues. 

We're not increasing usage. We're pushing towards the cloud and Azure systems. 

View full review »
Balamurugan Ramalingam - PeerSpot reviewer
Senior Quality Assurance Consultant at Public and Business Service Delivery

Scalability-wise, I rate the solution a nine out of ten. Around 50 to 100 people in our organization are using the solution. We plan to increase the use of the solution because there are always new teams in our organization who install the solution for the new joiners and any other projects or contracts.

View full review »
Siddharth Matalia - PeerSpot reviewer
Senior Technical Specialist at a manufacturing company with 10,001+ employees

IBM Db2 Database is a widely used application with over 200 regular users.

I rate the scalability of the IBM Db2 Database a seven out of ten.

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

We're currently using the solution for multiple projects. We have more than 100 people on the solution. 

It's very scalable. You can size it down or up. 

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

It is absolutely scalable. It is hard to count the number of users. For example, in a bank, each and every customer of the bank uses the product. There are hundreds of thousands or, in my case, even millions of customers. There are also people who are not customers but access the website of the banks to look at something. Those people are not registered, but they're using the product as well. So, there could be millions of users. In the banks where I work, the business is growing. With the growth of the business, the number of users is also growing every year by a small percentage.

If Db2 is properly used, an organization can build a database with thousands of tables, and it can provide the exact information for the applications within a second. We have 500,000 transactions a second, and each of them needs to get some information from the database to perform a show, insert, or delete operation for different users. In the banking or finance domain, there are a large number of transactions. Even in a small country, there would be a large number of transactions every minute or seconds of the day. Db2 is capable of providing services for each and every transaction.

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

It is a scalable solution.

It doesn't really matter whether small companies or big companies use IBM Db2 Database. Whether to choose IBM Db2 Database or not depends on a customer's preferences.

View full review »
Jørgen Espensen - PeerSpot reviewer
Project Manager at SPS

It's scalable.

View full review »
MR
DA / DBA at Discount Bank

It is very scalable. There are about 250 application systems with even more different databases on the same server with data sharing.

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

The primary concern is related to the cost implications when scaling with multiple nodes in a database. The associated costs increase when additional nodes are added, each requiring separate storage space. We have approximately four or five Db2 instances being used in the organization.

It is a scalable platform. I rate the scalability an eight out of ten.

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

I rate Db2 nine out of 10 for scalability. We have more than a thousand users. 

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

IBM Db2 Database is not scalable.

We have approximately 8, 000 clients.

View full review »
S-
Department Head of Big Data and Analytic Solutions at a tech services company with 501-1,000 employees

I don't' have any knowledge about scalability.

View full review »
SK
Implemenation Specialist at a engineering company with 10,001+ employees

We have found the solution to be scalable. If you want to expand it, you can. 

We don't really have individual users. It comes as part of a package and therefore it's hard to say who is using it and who isn't. 

View full review »
FM
Database Engineer at Habib Bank

I rate the product’s scalability an eight out of ten.

View full review »
MS
System Administrator at a financial services firm with 1,001-5,000 employees

We did not have the need to scale the solution.

We are using the solution on a daily basis.

View full review »
AA
CIO at Mobica

The scalability is an issue for us because Database Hammer does not work with IBM Power and POWER9 is too expensive. 

View full review »
JH
Solution Architect at a insurance company with 10,001+ employees

DB2 is very scalable offering multichoice of possiblities - massive parallel processing and also  clustering.

View full review »
SP
Architect at a wellness & fitness company with 1-10 employees

We use a scalable WebSphere Application Server topology, but it's a monolithic application that can only be scaled vertically, not horizontally, because it's a monolithic single database, but those limitations exist. But there are times when I believe we are pleased with the product.

We have multiple production environments and various resources, as well as separate teams to manage the database and separate teams to manage the Application Server. I believe it began with a small team, but as time passed, I believe the number of environments and teams increased. Teams are popular now. I believe we have teams dedicated to each area.

I can say that there are approximately 100 developers, both offshore and onshore.

View full review »
Giuseppe Innamorato - PeerSpot reviewer
Senior Client Director at Alkemy digital_enabler

The solution is scalable, and approximately 50 users in our organization are currently utilizing it.

View full review »
BN
Product Development Manager at a tech services company with 11-50 employees

It is a perfect solution for environments where scalability is going to be an issue. I am supporting two banks. They use Db2 for their core banking system. There are more than 500 users per bank who use this solution every single day.

View full review »
SR
System engineer at a financial services firm with 10,001+ employees

We do not have any problems with scalability. I would say give high marks for scalability.

View full review »
SM
Senior Systems Architect/Analyst/Developer at a logistics company with 1,001-5,000 employees

The system scales very well. It runs the new power nine chips and it's about to run the new power 10 chips that IBM is releasing as well. For that reason, the current systems out there are 16 CPU Power 10 processors that can have terabytes of memory associated with them. It performs extremely well in the environment. 

The system is very scalable to very large magnitudes. There are some very large Fortune 10 and Fortune 15 companies that run Db2 systems and can attest to the scalability

View full review »
HV
Test lead at Percik Consulting

Presently, we have 200 solution users in our organization.

View full review »
NG
Solution Director at HCL Technologies

We have 34 technical users and over 50 end users for the solution. I rate its scalability as an eight.

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

With scalability, I do not have as much experience as other teams in our group because I am on the sales end. I do not have experience on that side. Because we are a business partner of IBM, we all understand the use of Db2. In our company, the main focus is always on what the customer wants and what kind of applications they want to build. As we are working in the financial sector, they have DBS (Disclosure and Barring Service) and these requirements need to be fulfilled. What the customer wants ends up determining which database we suggest that they go for. In that sense, our market is mostly Oracle. But if they are trying to keep their budget concerns in check, then we will go for Db2, because it is less costly than Oracle.  

View full review »
it_user700098 - PeerSpot reviewer
Project Manager at a tech services company with 10,001+ employees

There were no issues with scalability.

View full review »
PK
Solutions Architect at a financial services firm with 10,001+ employees

We have about 4,000,000 requests daily.

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

I have found IBM Db2 Database scalable.

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

The solution is very scalable. IBM has a mid-range and a mainframe system, so every product is made with scalability in mind. 

Their main target is medium and large size business so they're not interested in small business. 

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

In my experience, the solution is able to be scaled vertically, but not horizontally. Everyone is using the solution in our organization.

View full review »
SK
Implemenation Specialist at a engineering company with 10,001+ employees

Since it's on the Cloud, it's pretty much scalable with no limits.

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

We don't have experience with scalability because the server is also a dedicated server and the physical hardware has always been dedicated from the beginning. After five years, we made a technical upgrade and have been the same since.

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

There were no real scalability issues. Features in the Vanguard RACF security products allow the installation to determine security policy for DB2 resources and build the security rules as needed.

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 scalable solution. 

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

We have not had an issue with the scalability of the IBM Db2 Database.

View full review »
WC
Service Director at scsi co.,ltd

The solution is quite scalable. A company shouldn't have issues with expanding it if they need to.

We typically implement the solution for small to medium-sized organizations.

View full review »
GN
Consultant at a tech services company

We have 2,000 ICT people and most of them are working on the operational part of the site. Minimum, there are 100 or 80 people working on the system database.

View full review »
Ahmed Ashmawy - PeerSpot reviewer
Data Practice Lead at Hyve Technology Consulting

The tool doesn't work as a distributed database based on customer needs. 

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

Db2's scalability is very good, especially when used in the IBM power system.

View full review »
EC
IT Director at BISTP

This solution is scalable. We have an infrastructure that is based on virtual machines, so we can add more to grow as we need. I am very happy about that.

We have perhaps sixty or seventy people using this solution.

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

A lot of scalability can be done in DB2, it only depends on the money you want to invest in it and on the functions that you really need. It can go from a free database to a very big infrastructure.

View full review »
it_user75351 - PeerSpot reviewer
VP of IT at a financial services firm

Scales well enough for a relational database. Not exceptional; scales at or slightly below its peers.

View full review »
SM
Business Intelligence Consultant at a university with 10,001+ employees

I would say this solution is scalable, in terms of memory.

There are approximately one thousand users.

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. Would you like a description of the IBM i Single-level Store. Add a new drive and you are good to go.

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

The solution is very scalable. We don't plan on increasing usage any time soon, however.

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

There were no issues with scalability.

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

No, but we never had it greater than 100TiB.

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. Many tables or indexes can't be scaled up without reorg step. As an unbreakable system, it's a very bad design.

View full review »
IF
CEO at a tech services company with 51-200 employees

The scalability is good. We have some clients that have over 9,000 users using this solution.

View full review »
JK
CTO at Jutel

It has been a very scalable solution for us.

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

This is not relevant for me, we have rarely needed to build on the initial server footprint.

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.
767,995 professionals have used our research since 2012.