Mixing Db2 Database Administration with DevOps - Part 5: SQL Performance Testing
The DB2 Portal Blog
by Craig S. Mullins
8h ago
Although implementing database schema changes is the most important component when incorporating database structures into your DevOps pipeline, it is not the only thing to consider. It is also important to be able to analyze and optimize SQL performance within your application code. As anyone who has written SQL knows, it is a very flexible language. There are multiple ways to write SQL queries to achieve the same results. For example, you can combine multiple tables using a join or a subselect and achieve the same results. But each SQL formulation is likely to perform differently, one better ..read more
Visit website
Mixing Db2 Database Administration with DevOps - Part 4: Database Schema Change and DevOps
The DB2 Portal Blog
by Craig S. Mullins
1w ago
Traditionally, the DBA is the custodian of database changes. But the DBA typically is not the one requesting the change. Usually, a programmer does that. There are times when the DBA requests changes, such as to improve performance or to utilize new features, but this is not as common as development changes. Regardless of who requests the change, the DBA must be involved to ensure that each change is performed successfully and with no impact on the rest of the database.  After moving to a DevOps approach, there is a shift that places more of the responsibility for database change on the d ..read more
Visit website
Mixing Db2 Database Administration with DevOps - Part 3: Automating DevOps Toolchain
The DB2 Portal Blog
by Craig S. Mullins
2w ago
Understanding what is meant by DevOps and the many requisite pieces of the DevOps toolchain is just the first step in adopted DevOps. The key to success with automating DevOps is a well-constructed toolchain for automating all of the afore-mentioned processes in an integrated and cooperative manner. If you have been an IT professional for any length of time most of the categories we just discussed will not be new to you. What is new, however, is likely the integration of the tools hooked up together to work in concert for the purpose of delivering application software quickly and accurately. A ..read more
Visit website
Mixing Db2 Database Administration with DevOps - Part 2: The DevOps Toolchain
The DB2 Portal Blog
by Craig S. Mullins
3w ago
Adopting a DevOps approach to application development is all about moving faster. Automating the multitude of processes required during software development and management is a core part of increasing speed and enabling faster development. As mentioned in the first part of this series, a DevOps toolchain is used to automate the development process. A toolchain is a set of software tools used to perform a complex development task... or to create a software product. The software tools that comprise a toolchain typically are executed sequentially with the output or state of one tool becoming the ..read more
Visit website
Mixing Db2 Database Administration with DevOps - Part 1: Intro to DevOps
The DB2 Portal Blog
by Craig S. Mullins
1M ago
Organizations of all types are being impacted by the transformation to the modern digital economy. This digital transformation, driven by the 24/7 expectations of users and customers to access data and apps at any time, from any device, requires the ability to rapidly change technology and software. This means that today’s businesses have to deliver and improve the services and software used by their customers faster than ever before. To survive and thrive in the new digital economy requires that organizations adopt new and faster methods of developing, testing and delivering application sof ..read more
Visit website
Happy Holidays 2023
The DB2 Portal Blog
by Craig S. Mullins
3M ago
Did you know that there are over two dozen holidays celebrated across the world between November 1st and January 15th?      So in the spirit of the season, I want to wish all of my readers everywhere a Happy Holiday season.   This will be the last post I make here this year. I hope that you will take some time to celebrate whichever holidays you observe... and that you enjoy this time of year with your family and friends.    And let's meet back here next year to talk some more about our favorite DBMS... Db2 ..read more
Visit website
Understanding Db2 Messages
The DB2 Portal Blog
by Craig S. Mullins
3M ago
Have you ever been confronted with a Db2 message and needed help deciphering what it is trying to tell you?  I'm sure most of us have. But let's back up a moment and define what a Db2 message actually is. In Db2 for z/OS, a message refers to a notification from the Db2 subsystem that is conveying information about the status, events, errors, or other conditions within the Db2 environment. Db2 for z/OS generates messages to report various aspects of its operation, and these messages can be critical for monitoring, diagnosing, and resolving issues in the database system. There is an entire ..read more
Visit website
My Top Ten Db2 Performance Posts
The DB2 Portal Blog
by Craig S. Mullins
4M ago
Regular readers of this blog will notice that the past few months have been consumed by my posts outlining my Top Ten Db2 Performance tips. So, it being December and the end of the year, I thought it would be a good idea to publish a post with links to each of the Top Ten tips... so here it is! Number 1 - Analyze Query Execution Plans Number 2 - Optimize Your Database Design Number 3 - Efficient Indexing Strategies Number 4 - Effective Memory Configuration Number 5 - Workload Management and Query Optimization Number 6 - Monitoring and Performance Metrics Number 7 - Configuration Parameters and ..read more
Visit website
Top Ten Db2 Performance Tips - No. 10 Stay Up to Date
DB2PORTAL Blog - Craig S. Mullins
by Craig S. Mullins
4M ago
Keeping Db2 up to date is of paramount importance for ensuring the security, stability, and optimal performance of your database environment. For Db2 for z/OS this means formulating a plan for applying PTFs (Program Temporary Fixes) and correlating your DB2 fixes with your system, ideally following IBM's RSU (Recommended Service Upgrade) preventive service philosophy. For Db2 for LUW it means keeping up with fix packs. Why is it important to stay current with maintenance? And what are the benefits of doing so? Security: Cyber threats and vulnerabilities are ever-evolving, and database sy ..read more
Visit website
Top Ten Db2 Performance Tips – No. 9 Regular Maintenance and Housekeeping
The DB2 Portal Blog
by Craig S. Mullins
5M ago
When thinking about the performance characteristics of your Db2 databases and applications keep in mind the routine maintenance that can help or hinder your performance. Regular maintenance and housekeeping tasks are essential for ensuring the optimal performance and stability of your Db2 environment.  By performing routine maintenance activities, database administrators can proactively address performance degradation, optimize query execution, and maintain a healthy database environment. In today’s post, we will highlight the importance of regular maintenance tasks and discuss key activi ..read more
Visit website

Follow The DB2 Portal Blog on FeedSpot

Continue with Google
Continue with Apple
OR