How to resolve DDOL000047C - DDOFILE VLS FILE IS FULL

Document ID : KB000010219
Last Modified Date : 14/02/2018
Show Technical Document Details

When using DDOL (CA Datacom/DB Datadictionary Online) functionality, if you receive a message like this:


you can check the DDOL1 and DDOL2 files allocated to the DDnames in CICS as DDOFILE and DDOFIL2, and see the percentage full for these files. If there are no online users and the percentage is higher than expected, you might have some members that were not removed from the work file because a user online session ended unexpectedly.


As described in the CA Datacom/DB Database and System Administration Guide, in the section "Implementing and Maintaining Virtual Library System Files › VLS Files," DDOFILE is 

A work file for online Datadictionary. The Datadictionary Online Work File (DDOFILE) stores session dependent information over a logical process which can span the processing of several panels of information. DDOFILE is the default name for the Datadictionary online work file. This name can be changed in the DDOLLIB= parameter in the DDSYSTBL macro. For details on specifying a different name for this file, see DDOLLIB=. 

Because it is a work file, and is session-based, every user that enters and exits a DDOL session will cause this file's utilization to grow and shrink. It's size or contents depends on the Datadictionary online activity taking place at that moment. During the online sessions, it is not unexpected to see one value at one point, and then see that the file is much more full or less full minutes later.

The description of the DDOL000047A and 47C message says 

When a logical unit of work (LUW) in CA Datacom Datadictionary online is completed successfully, any VLS member associated with the LUW is deleted. However, if the LUW ends with an ABEND, the VLS member remains on the VLS work file until the same user starts another similar LUW. It is conceivable that a series of ABENDS could cause the VLS work file to fill. 


In order to keep these workfiles operating at their best, our recommendation is to periodically initialize/reformat the DDOL1 and DDOL2 files to clear out any leftover VLS work members that are not needed or are orphaned. Obviously, this should be done at a time when no one is using DDOL, so that you don't affect current processing.

To reformat these files, you can use the DDVLSUTL program, and a sample job can be found in CABDSAMP(BDNEW02) - you would extract only those parts pertaining to the DDOL1 or DDOL2 file as needed. If you find that this situation occurs frequently, you can allocate and format a new, larger file to address your problem.

Additional Information:

As always, please contact CA Technologies support for CA Datacom if you have further questions.