Whether the SQL TTM area is allocated or virtual or on DASD, it is sometimes necessary to know how full this area is at the moment. Since the CXX cannot be used in all cases, below is an alternative SQL query that will give this information.
This information about the TTM (Temporary Table Manager) is available in the Datacom System Tables, in the SQL_STATUS table (called SQS).
This query will report on the TTM usage, and other useful SQL statistics.
SELECT MUF_NAME
,LUWS AS "Work Units"
,TASKS_ACTIVE AS "SQL Act Tasks"
,TASKS_ATTACHED AS "Total Tasks"
,TTM_BLKS_ALLOC AS "TTM Blocks Alloc"
,TTM_BLKS_ALLOC * 4 / 1024 AS "TTM Meg Alloc"
,TTM_BLKS_IN_USE AS "TTM Block In Use"
,TTM_BLKS_IN_USE * 4 / 1024 AS "TTM Meg In Use"
,TTM_BLKS_IN_USE * 100 / TTM_BLKS_ALLOC AS "TTM % In Use"
,TTM_BLKS_MAX_USE AS "TTM Max Blocks Used"
,TTM_BLKS_MAX_USE * 4 / 1024 AS "TTM Max Meg Used"
,TTM_BLKS_MAX_USE * 100 / TTM_BLKS_ALLOC AS "TTM Max % Used"
FROM SYSADM.SQL_STATUS;
For more information about the Temporary Table Manager (TTM), please refer to the documentation topic Creating and Maintaining The Temporary Table Manager Area
As always, please contact Broadcom support for Datacom for any other questions