Recently, a DB2 for z/OS professional I’ve known for some years sent to me a question about the relationship between the PGSTEAL and PGFIX options of the DB2 command -ALTER BUFFERPOOL. It took a few iterations of question and answer to get things straightened out, and I thought, “Hmm. If this person, who has lots of DB2 for z/OS experience and knowledge, needed a little help in getting PGSTEAL and PGFIX straightened out in his mind, it’s likely that other DB2 people are in the same boat.” And …read more
Related Articles
SQL PL Stored Procedures
Stored procedures can be written in a variety of languages, including C, C++, Java, and SQL PL. SQL PL is a language specifically designed for DB2 and offers a rich set of features that can make it su...
Rearranging the Driving Path
This tip covers the importance of finding the best “driving path” for retrieving rows from the database. We’ll use a simple illustration of a Nested Loop operation that retrieves data accessing 2 tab...
How to alter and drop database objects with Quest® Toad® for Oracle Pro...
The object model for developing database object types and object tables brings object-oriented data storage to Oracle Database. In a previous post, “How to create database objects with Toad for Oracle...
