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
Toad Data Point Cross-Platform Compare and Synch
In this episode of the Toad Tips and Tricks series, you'll learn how to verify data across different database platforms using the compare and sync wizard found in Toad Data Point. After you've migrate...
IMPDP Hangs, or Appears to Hang – But Has it?
You know the score, you are running an impdp and it looks to have hung up. You’ve watched the log file (or on screen messages) and it’s sitting at something like: Processing object type TABLE_EXPORT/...
What are database management tools and what features are must-have?
Data is the raw material for the information age, and database management tools are the hammer, furnace, anvil, saw, lathe and paint brush you use to make data useful. The simplest functions of datab...
