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

DB2

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.

DB2 for z/OS Database Recovery - Get it Right 01/14
Database backup copies may not be enough to ensure data recoverability. The DBA must "bake" recoverability into the database design process; additionally, for current systems, the DBA needs to know whether current backup processes support recovery procedures that will meet application recovery objectives.

GRC 101 for DB2 LUW DBAs 01/13
Rebecca Bond attended IOD recently where the "hall conversation" centered on Governance, Risk Management and Compliance (GRC) and the potential impact for DB2 DBAs. Read what she discovered as she researched answers to some basic GRC questions.

PureScale Performance Proven 12/28
DB2 for z/OS provides mainframe users with unmatched levels of resilience and scalability through technology known as data sharing. IBM announced that similar capabilities would be delivered for DB2 for LUW, in an optional facility dubbed pureScale. Read on to learn whether DB2 pureScale has met or exceeded expectations.

Dynamic SQL Performance Tuning Techniques for IBM DB2 z/OS 12/20
Applications running with dynamic SQL are ever-increasing. Without some methods to contain the onslaught of queries, performance drops and phone calls increase. What can a DBA do to remain sane and avoid a visit from the head of IT?