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
Index selectivity & queries with multiple equality conditions
Performance of a query having multiple equality type predicates improves as it switches from using the index on an unselective column to a selective one. It is very common to issue queries with multi...
Using Toad® for Oracle to Query Multiple Tables
The SELECTstatement is used to query Oracle Database table data, whether from a single table, or when used to query multiple tables. To query multiple tables, the tables are specified in the FROMclaus...
Oracle System Global Area (SGA) – Overview
SGA refers to a Shared Global Area. As the term global implies, this area is accessible to all Oracle processes and users. Each instance will have its own SGA. Oracle processes and users must share la...
