As an IT services company focused on IBM Db2, we understand the benefits and limitations of using Db2 as a database for a project. Db2 is a relational database management system (RDBMS) developed by IBM that offers robust features and capabilities for managing large...
The IBM Db2 Database is a relational database management system (RDBMS) developed by IBM in the 1980s. Since then, it has become one of the most widely used databases in the world. In this article, we will explore the history of the database, its current state, and...
Migrating to IBM Db2 offers businesses a robust and reliable database management system that can improve performance, enhance data security, and streamline operations. However, the migration process can be complex and challenging, especially for companies with limited...
The NORETRIEVE parameter of a Db2 ROLLFORWARD command is a powerful tool that can be used to recover data from a database during a disaster or other data loss event. When the NORETRIEVE parameter is specified, Db2 will roll forward the database to a defined point in...
When monitoring CPU utilization on a Db2 server, each Db2 instance generally has a single db2sysc process (per database partition) consuming CPU on the server. The db2sysc process is made up of many threads. While it's possible to see CPU utilization of each thread...
Choosing the right database for a business can be a critical decision that impacts the organization's overall success. In this blog post, we will explore the differences between Informix and Db2 databases and the factors to consider when choosing between them....
We, as DBAs, have all encountered a situation where a bad query just kept running and sucked up the database resources while holding onto logs. It's always a "simple select" that seems to run over 12 hours. Db2 used to have the governor. This nifty little tool was...
IDUG is a hugely popular Db2 conference that Db2 enthusiasts look forward to attending every year. They have several of these around the world. This year, we have IDUG events in NA, EMEA, Australasia and India. Professionals from the US and Canada often attend the...
The purpose of this article is to provide guidance on the various ways available for getting basic information about locking events in a Db2 database. Where possible the information gathered allows for targeting a specific table. The information provided by these...
I recently faced an interesting challenge. I was working to replace (rebuild) a view with updated DDL, but when executing the CREATE OR REPLACE VIEW statement, Db2 returned error code SQL0551N. This error means that the user ID doesn't have authority to perform the...