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
Creating and Managing PostgreSQL in Amazon RDS
Introduction PostgreSQL, or Postgres, has proven to be a powerful open source RDBMS with lightweight software which is free of charge. Postgres is supported in nearly all operating systems including L...
Hot and Cold Backups – Overview
Normal system backups, referred to as either Hot or Cold backups, are used to protect from media failure. A Cold backup, that is, one done with the database in a shutdown state, provides a complete co...
Variables and flow control in Toad for SQL Server Automation
This video by Toad Expert Robert Pound demonstrates how to use variables and flow controls in the Automation feature within Toad for SQL Server....
