LXX log is full after a log spill was cancelled
Article ID: 127820
Updated On:
Products
CA Datacom - DB
CA Datacom
CA Datacom - AD
CA Datacom - Server
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
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."
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."
Feedback
Yes
No
Powered by
