IBM Db2 Database Initial Setup
SH
reviewer1715946
Mainframe Technical Manager/Service Integration Lead at a tech services company with 10,001+ employees
The mainframe environment does not that often require that we have to set up another Db2. If you're creating a brand new Db2 cluster or data sharing group, then there is a bit of work in that.
The IBM manuals for this and our localized documentation assist the engineers and consultants in building a Db2. I don't consider any issues regarding a build of a Db2.
The mainframe environment from a security perspective is one of the key fundamental selling points of the mainframe environment. It is relatively secure assuming that the security people that administer the RackF database, the external security database, are actually configuring it right. Then we deploy role-based access controls. When they're doing this sort of activity database, people would have to liaise with other areas within the infrastructure and support to configure that Db2. Obviously, with any Db2 you need security permissions. They would need to discuss with the storage team how much disc space they're going to need and to discuss with the performance team and capacity team to make sure that they're going to profile that environment. They would need to discuss with the automation team to make sure that the Db2 is shut down when we need to shut the system down and that it's started up properly when the system's reloaded, or if it is in an unplanned activity, that we can restart it in light mode. Furthermore, the automation tool is monitoring that Db2 instance to make sure that it's healthy. Ultimately, there are lots of different teams that would be involved in this.
For the most part, the setup is simple. If somebody wants a new database or schema, we could just quickly do that within that environment. If we need a brand new, separate Db2 environment, that would be more complicated, however, we have the procedures and processes in place for that.
We could have just one systems programmer doing that maintenance. That said, from my perspective, I engage a lot of the teams. Once we've put that maintenance into the development environment and we leave it for a week against one member and leave the other member back level, we would do full performance analysis to see that, with all the transactions that are running there, there's no additional CPU and there's no deterioration in response time and that the Db2 member itself is looking healthy, it's not having any resource shortages, there's no virtual memory or physical memory increases or deviations or anomalies.
We'd engage with the performance and capacity team. I recently engaged with the distributed team, for example, the middleware teams, to make sure that if anything is coming off the web through the web servers, they are aware of our change so that they can monitor and support us.
While it's one person that's doing the change, he might be working with a few junior engineers to do training. We tend to engage a lot of teams across the activity to make sure that everything looks okay and we're not impacting SLAs.
Furthermore, we have a 24 by seven operations team and they do all the operational side. You wouldn't get a Db2 systems programmer in production stopping and starting the Db2. That would be done by the operators.
DD
Devashish Dutta.
Senior project manager (APAC region) at FreeBalance
The deployment time and complexity totally depend on the solution we're implementing during this initial setup. It could be for one organization, maybe three or four. For another organization, maybe a seven or eight. So, it completely depends on what type of setup you want for the specific organization.
Where I work, the deployment model is always on the government's premises or their government cloud. It's never on public cloud platforms like AWS or GCP.
Recently, we did some data center migration. It's not a quick job because it's government resource planning. We need to involve all the ministries in the data center, which requires a complete plan.
Last time, it took around two and a half months, ten to be exact, for me to roll it out with my whole system team involved.
View full review »The initial setup of Db2 Database is straightforward. Any complexity is due to the seriousness of the case.
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,667 professionals have used our research since 2012.
BN
reviewer1420620
Product Development Manager at a tech services company with 11-50 employees
The ease of setup depends on the instances. In some instances, it's quite complex. Compared to SQL Server, MySQL, and PostgreSQL, Db2 is not easy to deploy. It is quite complex compared to other databases. However, the complexity comes with the territory. Companies that have complex requirements benefit from it.
View full review »MK
Madhav Kondapalli
Solutions Architect at a retailer with 10,001+ employees
The setup wasn't part of my job. We had a team that handled it. However, my understanding is it was straightforward.
View full review »The initial setup was straightforward, especially if we compare IBM Db2 Database's setup phase with Toad for Oracle's setup process.
View full review »NG
Nanthagopal G
DB2LUW and Couchbase ADMINISTRATOR at HCL Technologies
It's hard to set up the solution. The setup could be easier in Db2. However, we have to work with the AX engineers to set up the Db2 file system. For that, we have to install the Db2 binaries, and we have to create the instance and create the databases. It takes around 30 to 45 minutes to deploy. That's pretty fast, at least.
View full review »MR
Michael-Raz
DBA at a tech vendor with 201-500 employees
It is quite complex. It is not a simple installation. If the installation is done by a specialist, it takes a few hours.
It's not easy to set up. It takes a long time, especially compared to other solutions.
MR
Michael Raz
DA / DBA at Discount Bank
It must be done by a professional. It is not a simple task. Somebody with quite significant experience must do the initial setup. It is difficult.
View full review »The initial setup is straightforward. We have to install and register. The deployment process includes downloading the software from the vendor's website, having a customer account, copying the downloaded file to the machine, and executing the installation. It takes five to ten days to complete. We have around 50 executives working in the database administration team.
View full review »RD
RamneshDubey
Senior Cyber Security Specialist at a tech vendor with 10,001+ employees
Setting up Db2 is straightforward. Most IBM products I've used aren't complex to integrate or deploy. We deploy it on-premise and in the cloud.
View full review »When I worked within Db2, I didn't set up the Db2. I just used it. I didn't do any tuning or anything like that. I only performed some database management.
The initial setup was quite simple because we've been working in this area for more than 40 years.
It took about a year and a half to develop and deploy the whole application.
View full review »S-
Suhendri -
Department Head of Big Data and Analytic Solutions at a tech services company with 501-1,000 employees
The initial setup was straightforward.
It took four months to deploy this solution.
View full review »SK
SamirKhodair
Implemenation Specialist at a engineering company with 10,001+ employees
The initial setup has recently become easier and more straightforward. A lot of enhancements have happened here. Still, it is a bit complex.
View full review »FM
FarhanFarhan
Database Engineer at Habib Bank
The initial setup is complex. Since the database has various types of data, we must integrate it with the audit server. An expert in Linux can easily manage the integration.
View full review »MS
reviewer1812633
System Administrator at a financial services firm with 1,001-5,000 employees
I rate the initial setup of the IBM Db2 Database a seven out of ten.
The deployment of the database took one day and the application took some time because of the testing and integration.
View full review »AA
Amr-Ahmed
CIO at Mobica
The setup is very easy and we accomplished it through self education.
View full review »JH
JurajHrapko
Solution Architect at a insurance company with 10,001+ employees
The initial setup is straightforward. I think that installing the Db2 is not that complex and it should not be a problem for a skilled DBA.
View full review »SP
reviewer1932312
Architect at a wellness & fitness company with 1-10 employees
The monolithic application is hosted on-premises.
We installed the system in 2001 and have been using it ever since.
The maintenance and support staff is quite small. We have a dedicated database team, we can support multiple database products in addition to Db2.
View full review »The initial setup is not easy but can be completed with the assistance of the IBM technicians. It took us about four to five months to complete deployment.
View full review »BN
reviewer1420620
Product Development Manager at a tech services company with 11-50 employees
It is very technical to deploy, but once you configure and make it work, it is a perfect solution for an environment where scalability is going to be an issue.
View full review »SM
reviewer1031649
Senior Systems Architect/Analyst/Developer at a logistics company with 1,001-5,000 employees
The initial setup is very straightforward. Due to the fact that it's bundled inside of the system, you don't have to do any special implementation. As soon as you have the system up and running, and the operating system running, Db2 is already running. There was an instance of it running on the architecture at that moment. There's absolutely zero setup in that environment.
View full review »YS
reviewer1432260
Global Infrastructure service manager at a manufacturing company with 10,001+ employees
The initial setup was complex altogether. It was complex because we were moving from Oracle Database to Db2 Database. A lot of code changes were required.
View full review »HV
HenrikVester
Test lead at Percik Consulting
The solution's initial setup is straightforward. The deployment process involves requesting access to different test environments and productions. It takes a couple of hours to complete.
View full review »NG
NAVEEN GROVER
Solution Director at HCL Technologies
The solution's initial setup process has medium complexity. It takes a few days to complete. I rate the process as a seven.
View full review »The initial setup for Db2 is really straightforward. Their deployment and integration are very easy and straightforward. The environment takes a maximum of 40 minutes for installation. I have done it by myself. The complete deployment is not so easy that it is a simple repetition to do the same way on every site, but two or three weeks will be all that you need for an enterprise installation.
The setup was straightforward. However, the Linux setup can be improved.
View full review »PK
reviewer1378284
Solutions Architect at a financial services firm with 10,001+ employees
The initial setup is complex and not easy to do. It was handled by the database administrators so I do not remember exactly how long the deployment took.
View full review »MR
Michael Raz
DA / DBA at Discount Bank
The initial setup is quite complex. Nothing is simple on the platform. Deployment times depend on the extent of the organization. Different tests need to be done: unique tests, integration tests, user acceptance, performance, etc.
View full review »The initial setup of the IBM Db2 Database is straightforward. The full implementation took approximately one month.
View full review »SA
SAMI ABOU KARAM
Technical support manager IBM Power systems at a computer software company with 51-200 employees
The initial setup is very easy.
View full review »HB
reviewer1264416
Domain architect at a financial services firm with 10,001+ employees
The installation on our side is automated, we can have a database up and ready within a day. Since we have started using automation, the installation has been very easy.
View full review »AV
AlessioVilla
System Administrator at a tech services company with 51-200 employees
The initial setup is simple and straightforward. It's easy to install with no special configuration for a big data database. They make things simple.
It took less than an hour to deploy.
View full review »GD
SecAnalyst3477
Security Analyst at a insurance company with 1,001-5,000 employees
The initial setup of the automated security products like Administrator and or Advisor is straightforward. I highly recommend a Systems Programmer install the products to maximize the software investment a company makes.
View full review »DL
Derez Lusk
Mainframe Application Analyst / Developer at a insurance company with 10,001+ employees
Not involved.
View full review »WC
Wira Chinwong
Service Director at scsi co.,ltd
The initial setup was easy. I rate the setup an eight out of ten.
View full review »NI
NikolayIgnatovich
Software architect at Bergen
The initial setup was quick and easy.
View full review »WC
Wira Chinwong
Service Director at scsi co.,ltd
The solution is very easy to set up. It's not complex at all.
Deployment takes about one to two hours or so. It's not a long or arduous process by any means.
You only need one person to deploy and maintain it.
View full review »GN
Giancarlo Nocerino
Consultant at a tech services company
We did an installation 20 or 50 years ago. It's an old installation. The database engineer has a good level of competency in Db2 installation, it's very easy. They normally upgrade Db2 without any problem.
View full review »The tool's time length for deployment depends on the design and can take around two days to three weeks to complete.
View full review »The initial setup was very straightforward.
View full review »EC
Evaristo Carvalho
IT Director at BISTP
The initial setup of this solution was very complex.
Our deployment took one or two days.
View full review »DB2 is easy to install. You just need to run the installer, and that is all. In AIX, it runs smoothly.
In Linux, it requires some libraries. Sometimes in 32 bits they are not easy to get, but once you got them, the installation is normal.
In Windows, it is just next, next. Once the binaries are installed, the instance is created in less than a minute, and it is only necessary to know what an instance means in DB2.
Finally, the database is just a command, that in some very specific cases it need extra parameters. If not, it creates a database in two minutes, and then, you have a powerful database ready to receive your data.
View full review »I can't comment. I have no experience here.
View full review »SM
Businessbc72
Business Intelligence Consultant at a university with 10,001+ employees
The initial setup of this solution is straightforward.
There are between ten and fifteen staff that maintain this solution.
View full review »
It was straightforward and easy. Many of the utilities provided by the vendor functioned very well. We were able to upgrade the Gen Encyclopedia easily.
View full review »
ME
solution259344
Enterprise Solutions Architect at a computer software company with 201-500 employees
The initial setup is straightforward, but securing your environment is a bit more complex.
View full review »DD
Don Denoncourt
Lead Code Wisperer at a tech vendor
It was integrated with the IBM i OS.
View full review »IS
IrfanSaeed
Managing Director, North America at Business Consultants, Inc.
The setup is quite complex. The solution and the hardware build are two different events. The deployment itself doesn't take more than two weeks, followed by the setup which can take, depending on the organization and its processes, a few months to a year. It varies from client to client.
View full review »The initial setup was complex. There are InfoCenter Pages and TechNotes, but these only cover the "usual" cases. You need a lot of experience and/or support.
View full review »It was very simple to get up and running. The documentation is very good and the user forums, including IBM wikis, make it very easy to find out most things we did to it as far as setup/tuning are concerned.
View full review »It's quite complex. It cannot be done without reference.
View full review »JK
JReviewer312
CTO at Jutel
The initial set up was complex, but that was a long time ago.
View full review »The installation process and setup is fairly straightforward (assuming that you have a good working knowledge of the underlying OS and basic DB2 concepts).
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,667 professionals have used our research since 2012.