Increase VIRTUAL TTM size to avoid -560

Products

• Datacom
• DATACOM - AD

Issue/Introduction

How to address -560 error when the Datacom Multi-User (MUF) VIRTUAL TTM Area becomes full?

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

Datacom 15.1

Resolution

Run directed VIRTUAL_DYNAMIC_EXTEND command as a console command to the MUF or run the console-like command via DBUTLTY.

Additional Information

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  

After /f mufstc,VIRTUAL_DYNAMIC_EXTEND 17,TTM,1M,22 the MUF jes log shows 

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 

See the online documentation on this command VIRTUAL_DYNAMIC_EXTEND