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____________
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