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