Increase VIRTUAL TTM size to avoid -560

book

Article ID: 109695

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction



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

Resolution

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)