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
Using Toad Data Modeler with Toad Edge for MySQL 5.x – I
Toad Data Modeler and Toad Edge are two tools that complement each other’s functionality very well. Toad Data Modeler provides all the features needed to model data and generate DDL from a model but d...
Cómo crear una instancia de la Base de Datos Oracle en Amazon RDS – Parte 1
En los tiempos en que vivimos, conocer los avances de la tecnología y cómo todo está orientado a la nube, me hizo pensar que es momento de empezar a incursionar en este tema y por ello he tenido la op...
The performance teeter-totter part 3: Toad® Turnpike [Finding indexes]
Part three in a blog series about SQL optimization, index tuning and yes … the quiz answers! Optimizing indexes? It’s hard. Really, really hard. At the end of my previous blog post, I gave you a po...
