Category: Posts-By-Category

f8259cc09326948fe0d3a93567a9fcc2 0

DB2 Basics: The Role of Databases

This blog article should appeal to a wide audience. This article is not specific to DB2, but speaks to the larger role of the database in the IT organization. What is a Database? At the most basic level, a database is an organized collection of information. Technically, you could consider a filing cabinet a database. Even an MS Excel Spreadsheet...

file9551234229633 0

Licensing Your Database Software on Virtual Platforms

Disclaimer: I am not an expert on Oracle RDBMS licensing. Please verify any and all licensing statements about IBM or Oracle before relying on them. I am likely biased towards IBM, having based my career on them, but am not an IBM employee. My husband happens to be a Virtualization Architect. This is a particularly useful person to have in...

file000863593965 0

DB2 Memory Area In-Depth: The Package Cache

The package cache is just one memory area that DB2 offers to tune memory usage for a DB2 database. This article is a deep dive into this memory area. What is the Package Cache The package cache is an area of memory that DB2 uses to store access plans. Access plans are detailed strategies for how DB2 will get to...

file0001696162701 0

Static SQL vs Dynamic SQL in Stored Procedures

Updated 13 September 2016 to use more correct wording around how and when the access plan is generated and reused. As a new DB2 for LUW DBA or developer it can take a while to understand the difference between static and dynamic SQL. I’d like to use an example in a stored procedure to explain. Example The same SQL can...

file000956896813 2

Using Vendor Backup Solutions with DB2 for LUW

There are an astonishing number of vendor solutions available with specific interfaces for DB2. Working with a variety of clients, I see and help to evaluate and implement a variety of backup solutions. I thought I’d share some of the things I look for and work on as part of an implementation. Sometimes the DBA has input on a solution...