Virtual IXX for Datacom accounting at 95%

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

Datacom Multi-User (MUF)  uses VIRTUAL 005,150M , which tells that a virtual ( temporary) index and data areas are used for the accounting database .

How can the space be increased without recycling the MUF?

Environment

z/OS

 

Cause

Accounting table A02 reached 100% full. Following errors were found in the MUF:

DB01102E - UNEXPECTED 07(035) RETURN CODE ON A02 TABLE FOR ADDIT REQUEST 
DB01103I - ACCOUNTING FOR A02 TABLE DISABLED 
DB01107W - 01052 ACCOUNTING ENTRIES LOST FOR TABLE A02 DUE TO FAILURE 

Resolution

Use MUF console-like command VIRTUAL_DYNAMIC_EXTEND to increase the virtual area. 

This console-like command can be issued via MVS MODIFY, DBUTLTY CONSOLE API, or SQL CONSOLE INSERT. 

This command prepares the characteristics you want to use for the virtual dynamic extend to be used when the data area or index area becomes full. 

Unlike DASD , more than 16 extents can be used , up to 65535 extents. 

Example of this command running DBUTLTY:

COMM OPTION=CONSOLE, OPTION2='VIRTUAL_DYNAMIC_EXTEND 005,A02,1000000000,10' 

This will allow DBID 5 area A02 to grow by 1Billion bytes each time up to 10 times. Each time the additional 1Billion bytes is filled, MUF will do a dynamic extend to get another 1 billion bytes up to 10 times or until any of these values are changed by running another VIRTUAL_DYNAMIC_EXTEND command. 

This storage comes from 64 bit storage.