How to determine amount of TTM blocks in use?

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

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.

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

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"
      ,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.