Db2

Powerful database platform in the central system of the organization, allowing the storage of data from many suppliers and other departments. IBM DB2 is an ingenuity tool that's easy to install, run and learn, plus technical support is there for you right out of the box. It is multi-functional with many platforms and fits with any necessary tools; on the other hand, this software is necessary flexible with document backup and recovery.

Proprietary relational database product for the storage and retrieval of all enterprise-powered data; It is compatible with other highly useful work tools for professional and business growth. IBM DB2 has an automated system that makes everything possible in less time than normal and in a perfect way since it is a very solid and robust platform that helps in the recovery of business data. It has the best technical team of any other product, always willing to collaborate.

An essential part used in the company is the IBM Db2 software to provide the database management cloud solution on our mainframe infrastructure. Super reliable and integrates exceptionally with the Cobol language, offering excellent performance in queries that require a large workload on the DBMS. We've tested several and it was the only one that could handle our data stream and responses in milliseconds. IBM still provides support for the tool, which also has a large community, mainly banks, which help and contribute to solving doubts and programming.

Inventory, ingest and question open information designs utilizing a solitary stage that upholds tight joining with your information lake over cloud object capacity. While implementing of the data over cloud for analytics the queries, the implementation of data analytics over cloud is much simpler and efficient here. Provides a stage that limited grating for clients by being exceptionally viable with existing SQL code, and simple to incorporate with SAP applications.

DB2 HADR feature is widely used in our applications as continuous availability is utmost important for the business.
As finance institution we have high workload of transactions which cannot have downtime and HADR feature meets our goal.

We use DB2 as a generic database for a wide range of front end employee facing applications - HTML and non HTML based (proprietary user interface). We extensively use DB2 for our Lotus Notes application. This application is used for task tracking, logging, project management, change control requests, incident tracking and response tracking on those said incidents.

<div>I support the product IzPCA ("IBM z Performance and Capacity Analytics"). <br></div><div>DB2 have a <b><u>symbiotic</u></b> relation with IZPCA! Without DB2, IzPCA is nothing. <br></div><div><br></div><div>IzPCA continuously insert/alter/update data in <u>600+ DB2 table</u>s, inside each one of the IzPCA DB2 databases.</div><div>That data contains <b><u>important technical information</u></b> about a lot of products/processes in the mainframe environment (eg, CPU, storage, DASD, channels, MVS, TSO, DB2, CICS, IMS, DCOLLECT, WLM, Applications, Job accounting, System Performance, System Capacity Planning (Forecast and Simulation), z/VM, zLinux, z/TPF, and many others). <br></div><div><br></div><div>People from the many teams supporting these products/processes, use that data to execute <b><u>fundamental, and complex analysis/studies</u></b> about how the products are performing, about how the systems, as a whole, are performing too, as well as <b><u>forecast studies</u></b>, and <b><u>simulation studies ("what if" analysis)</u></b>. <br></div><div><br></div><div>These studies/processes, are <b><u>fundamental and critical</u></b> for the installation. <br></div><div>The support teams needs to execute them continuously, in order to have mainframes environments always in a <b><u>good shape</u></b>. <br></div><div>By consequence, DB2 is too, <b><u>fundamental and critical</u></b>, to allow the execution of all these important processes/analysis. </div>

We are using Db2 for very critical applications where we need high availability and robustness. We are a retail and online business, biggest in Australia so the application demands a backend database which is able to handle such load and data. Using Db2 we are able to provide customers better satisfaction while shopping.

As a Db2 admin, among the projects I’ve handled that involved Db2 are:

• Setup of HADR Table Partitioning Upgrade of Db2 from 10.5 to 11.5 and Fix
• Pack Applications Database Replication using IBM WebSphere MQ
• Installation and setup of Db2 databases and client servers

Most of the issues I’ve encountered were related to:

• Restoration of local backup from one server to another
• Long duration of local backups HADR Replication

<ul><li>From the perspective of the engineer who designs the common infrastructure for our usage of Db2:</li></ul><ul><li>We use Db2 mostly for OLTP applications, some of them business critical with multi-million transactions per day</li><li>We also see increasing analytical workloads on these OLTP databases</li></ul>Underpinning infrastructure is IaaS VMs built on RHEL and deployed on:<br><ul><li>on-prem cloud platform (based on VMWare stacks)</li><li>public clouds like Azure, AWS, GCP</li></ul>

I'm a fan of IBM technology, I'm currently studying systems analysis and development, as I'm studying data science I needed to look for a relational database based on SQL where I could store my data. At the moment I use DB2 for studies so I opted for the DB2 Community license, it is simple and free.

We develop administration, performance and monitoring software for Db2 customers around the world, enabling them to become autonomous digital enterprises.

Db2 is a great database for large datasets. We use the DB2 database to manage our membership and other data. It is reliable and has a fast query response over a large amount of data. We use either native IBM systems to consume the data or connect to it from PC-based applications like PowerBI or node js programs.

It is used widely company wise by different department and different applications, mostly it is lagacy system, created in house or vendors. DB2 have very important company data, transnational and reporting.

We use Db2 and LUW in our environment for almost everything; about a 90/10 split with some form of Db2 vs SQL Server. We use it exclusively for its horsepower, especially on z, leaving the smaller workloads to MsSS. We run our large, demanding OLTP applications on Db2 and it never seems to break a sweat.

I mostly work on javascript applications working WebSphere, and the integration of DB2 with both the software is quite easy and effective. We have never faced trouble with this. It is also supported for mainframe programs which give the added benefit that we can do batch processing on the mainframe.

DB2 Data Warehouse and OLTP systems. LUW and Z/OS.

The project I am currently involved in implies retrieving data from multiple source systems from many companies in order to integrate them into a Corporate Data Warehouse. Some of the companies use systems that have their data stored on DB2, so we need to generate ETL processes against DB2 to obtain the data.

We used IBM Db2 on Cloud in one of our projects based on dynamic requirements. Early we were using Microsoft SQL Server for database management and [maintaining] transaction history. We needed one solution that helps us to resolve manual management of storage size and server configuration. We came to a solution and we have integrated IBM Db2 on Cloud to fulfill our requirements.

My experience using IBM Db2 on Cloud is very good as retrieving data from the database is very fast and can store large files in the database in an easy way. We are able to store data in a different locations and access it from another different location in an easy and smooth way.

We are implementing it on a personal level with systems and applications projects under development in order to have a broad first-hand view of the user experience and to be able to recommend the implementation in our department and in the future throughout the organization.

It is being used by our research and development department. We are working on improving our IoT based ERP system. We want our system to have multiple database integrations so IBM Db2 on Cloud is one of them. We are storing the machine-generated data which comes directly from [the] production site.

We have been using IBM Db2 on Cloud as our development & testing database which is used across different projects spanning multiple clients. Our development teams make use of this fully managed database as a service solution to store critical test data and also to fetch data for multiple applications.
IBM Db2 on Cloud is a very robust and versatile solution [that] doesn't need any prior hard core db knowledge to use it, so this was a clear choice when deciding to opt for a seamless database solution.

We are using In memory BLU processing and in-database analytics, able to scale through MPP architecture. The flexibility of being in the cloud without giving up on control, suitable for the hybrid model. Security features can provide row and column level controls. For fine-grained access control to a data warehouse, we can create and use our own user-defined user roles to accommodate the special needs of our organization. Admin should be able to manage how access controls for the organization have to be managed. An audit policy is there to enable monitor unwanted access. Encryption is possible using the master key in DB2 Data Warehouse. DB2 warehouse also has integrated Spark.