The GLOBALTEMPBLKSUSED parameter displays the number of temporary global variable blocks in use. The temporary global variable database is divided into 256-byte segments. Each temporary global variable and each row of a relational table that was defined as a GLOBAL TEMPORARY table requires at least one block and may require a number of additional contiguous blocks to hold all of the data. Most of the first block is not used to contain data, but instead contains information associated with the variable (for example, the name of the variable). The value of the GLOBALTEMPBLKSUSED parameter is greater than or equal to the value of the GLOBALTEMPUSED parameter.
|
Copyright © 2014 CA.
All rights reserved.
|
|