How to determine amount of TTM blocks in use?

Document ID : KB000010610
Last Modified Date : 14/02/2018
Show Technical Document Details
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.

Instructions:

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"
      ,TTM_BLKS_IN_USE   AS "TTM In Use"
      ,TTM_BLKS_MAX_USE  AS "TTM Max Used"
FROM SYSADM.SQL_STATUS;

Additional Information:

For more information about the Temporary Table Manager (TTM), please refer to the following documentation:

For CA Datacom/DB version 15.1, in the webpage Administrating / CA Datacom/DB Database and System Administration / Creating and Maintaining The Temporary Table Manager Area

For CA Datacom/DB version 15.0, in the webpage Administrating / CA Datacom/DB Database and System Administration / Creating and Maintaining The Temporary Table Manager Area

As always, please contact CA Technologies support for CA Datacom if you have further questions.