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
Working With Date Ranges in Toad Data Point
Often when writing a query you need to get data from a range of dates; when you start thinking about automating the SQL query it’s even more important. In this post I’ll show you a quick trick to let ...
Using Application Variables for Naming Relationships and Entities
Introduction Toad Data Modeler by default sets the name for relationships to "RelationshipX", where X is the unique number in the model. This behavior guarantees that all relationships will have a un...
Using Code Analysis with PowerShell in Toad DevOps ToolKit
This video demonstrates the use of the Code Analysis feature in the Toad DevOps Toolkit. The demo covers the basics features and function utilizing PowerShell. Sample script used in this video: Demo_C...
