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____________
z/OS
Datacom 15.1
Run directed VIRTUAL_DYNAMIC_EXTEND command as a console command to the MUF or run the console-like command via DBUTLTY.
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