LXX log is full after a log spill was cancelled

book

Article ID: 127820

calendar_today

Updated On:

Products

CA Datacom CA DATACOM - AD CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

For my QA environment the LXX log filled up, the job to spill was cancelled because we didn't have any spare scratch tapes. I now have many tasks in a waiting state until the LXX log can be cleared. Wondering if I should run a RESET of the LXX, or other? 

Cause

Spill full cancelled while executing.

Environment

z/os, CA Datacom/DB 15.1

Resolution

I was able to get a SPILLOPT SPILL=MAX to run...

Specifying SPILLOPT SPILL=MAX indicates that you want the spill to contain the maximum number of blocks including pipeline index/data blocks. If performing a spill specifically to recover a job executed improperly, use SPILL=MAX in case the job recently finished.


See below link for more info:
https://docops.ca.com/ca-datacom/15-1/en/reference/dbutlty-reference/utility-function-summary/spillopt-transfer-data-to-rxx-using-max-min

Additional Information

from docops link related to LXX RESET: 

https://docops.ca.com/ca-datacom/15-1/en/reference/dbutlty-reference/utility-function-summary/reset-reset-area/reset-lxx-reset-log-area-to-empty 

"...If this function is being considered, review the MUF startup options DORESTART and NORESTART to see if they would provide resolution without resetting the LXX." 

RESET needs the MUF down. 

"This function of DBUTLTY updates the Log Area control record to indicate the Log Area is empty and ready for use."