Determining the amount of TTM blocks in use
search cancel

Determining the amount of TTM blocks in use

book

Article ID: 10610

calendar_today

Updated On: 03-31-2025

Products

Datacom Datacom/DB Datacom/AD

Issue/Introduction

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.

Resolution

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;

Additional Information

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