Increase VIRTUAL TTM size to avoid -560

Document ID : KB000109695
Last Modified Date : 06/08/2018
Show Technical Document Details
Question:
How to address CA Datacom when VIRTUAL TTM Area becomes full (SQL -560)?

DBSQLPR request fails with:
___________SQL ERROR SUMMARY START___________   
                                                
SQLCODE = -560, SQLSTATE=57S05                  
MESSAGE = TEMPORARY TABLE AREA (TTM) FULL       
____________SQL ERROR SUMMARY END____________   
Environment:
z/OS
Answer:
In this example, this Datacom MUF has these related SQL startup options:

DB01900I -  SQLOPTION  YES,017,DATACOM,120,NO  SQL,TTM DBID,MODE,TIMEOUT,
DB01900I - *                                   VIEW SECURITY             
DB01900I - VIRTUAL    IXX017,32K         TEMP WORK INDEX FOR SQL REQUESTS 
DB01900I - VIRTUAL    TTM017,48K         TEMP WORK AREA FOR SQL REQUESTS 
 

One way to increase the VIRTUAL TTM017 without having the cycle the MUF is to use the directed VIRTUAL_DYNAMIC_EXTEND issued as a console command to the MUF... 

    /f mufstc,VIRTUAL_DYNAMIC_EXTEND 17,TTM,1M,22  

The MUF jes log will show...

DB01311I - VIRTUAL_DYNAMIC_EXTEND 17,TTM,1M,22                                 
DB01325I - CONSOLE COMPLETE, VIRTUAL_DYNAMIC_EXTEND 17,TTM,1M,22               
DB01705I - DYNAMIC EXTEND START TTM017 TRK 1 *** VIRTUAL AREA ***              
DB01706I - DYNAMIC EXTEND END TTM017 TRK 26        VOL 1 VOLS 22 EXT 1 TRK +25 
 
Additional Information:
Refer to CA Datacom Core - 15.1 section “Extending the Temporary Table Manager (TTM)”
https://docops.ca.com/ca-datacom/15-1/en/release-notes-and-product-information/ca-datacom-features/new-and-enhanced-features-for-15-0#NewandEnhancedFeaturesfor15.0-ExtendingtheTemporaryTableManager(TTM)