DB2 management, tutorials, scripts, coding, programming and tips for database administrators

DB2

The Silent Problem of Data 04/25

There is a silent problem in many organizations and that problem is data, or more specifically, the lack of governance over data. The penalty for lack of data governance is permanent and pervasive; the negative consequences can vary from merely annoying to facilitating the downfall of an organization. Read on to learn more.

DB2 Application Design for Big Data 04/18

A big data environment means a change in the way database administrators design and manage corporate data. These changes will affect the way applications must be coded and tested in order to ensure data availability and application performance.

Tuning the DB2 on z/OS Data Warehouse 03/21

Data warehouses are different. They are not a system of record, they are designed for data availability, database recovery has a low priority, and the physical database design is typically non-relational. Consequently the database administrator tends not to implement things such as referential integrity, triggers, and regular backups, forcing the DBA to look at performance tuning the data warehouse in a different way.

DB2 for z/OS Version Migration - Top 10 Issues 02/21

Thinking about upgrading to a new version of DB2 for z/OS? Of course you are! What are the biggest migration concerns? Lockwood Lyon shares the top ten migration issues.

DB2 z/OS Systems Tuning Tactics 02/01

In the z/OS environment, tuning a DB2 subsystem may require the DBA and systems programmers to wear multiple hats and approach overall performance tuning from several different angles. What approaches are best in which situations?

Thoughts on Improving DBA Productivity 11/18

Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.

Database Buyer's Guide Conclusion: Which Database Is Best for You? 10/27

Desktop databases, server databases, the Cloud or open source – which route is the right one for your organization?

Managing a Data Warehouse with DB2 on z/OS 09/02

Data warehouses pose unique management challenges for DBAs, business analysts and others. Here's a template for getting everyone to work together for the good of your organization.

IBM DB2 Database Buying Guide 08/25

IBM DB2 remains one of the top relational database management systems (RDBMS).

Four Strategies That Every DB2 z/OS DBA (or any DBA) Should Know 06/02

Here are the best strategies that define a successful and competent database administrator (DBA). They are presented in the context of DB2 on z/OS, but are applicable across all hardware platforms and database management systems.

Tuning Your ERP System for DB2 03/28

Poor performance or response time could mean that your ERP system needs tuning. Here are some things to look at.

Top 10 DB2 Support Issues 03/03

Here are 10 DB2 disasters - and how to avoid them.

Monitoring an ERP Application in DB2 for z/OS 02/15

Monitoring an ERP application suite involves using several basic measurement techniques - and separating ERP package performance measures from those of other applications.

A Guide to Better Risk Management for DB2 LUW DBAs 02/10
IBM DB2 DBAs intuitively deal with risk identification and management every day, yet they may still be impacted by risk management in ways that they may not recognize. Rebecca Bond discusses seven steps to help DB2 LUW DBAs better understand Risk Management.

Data in Memory 01/28
In-memory databases are becoming increasingly popular and an ever-more important factor in performance-critical activities such as stream processing and deep data analytics. Join Julian Stuhler as he delves into the world of in-memory databases: a technology that’s both reassuringly familiar and intriguingly novel at the same time.