Handle OM View Reports with a Location of OPEN in processing loop
search cancel

Handle OM View Reports with a Location of OPEN in processing loop

book

Article ID: 46348

calendar_today

Updated On:

Products

View

Issue/Introduction

During report collection, if a report gets stuck in a processing loop, the View database data space can become quickly filled. 

The report will show to have a Location of OPEN, and it will need to be stopped and deleted from the database. 

The Resolution below shows how to reclaim the space used for the report in OPEN status.

Environment

  • View®
  • OM View for z
  • Output Management View® for z/OS

Resolution

  •  First, address the report with the Location of OPEN by stopping the report in the spool.
  •  Stop the job that is creating the report and then go to the JES spool and either place the report in a held status, or delete the report altogether
  •  If needed, add data space to the database by running SARDBASE ADDDS DATA.
  •  If the View SARSTC task stopped and will not start again:
    •  Change SARINIT to have FORM=9999 (or some other bogus value), to temporarily stop report collection.
    •  Start SARSTC with "/S sarstc,OPT=STOPBU"
  •  If you changed the SARINIT FORM value:
    •  Stop the View task with "/P sarstc".
    •  Change SARINIT FORM=... back to its previous value.
    •  Start SARSTC with "/S sarstc,OPT=STOPBU", to resume report collection
  •  In the View database, find the report in OPEN status, and type a "C" to the left of the report, for an initial cleaning.
  •  Have a View backup run, either automatically (from SARINIT DAYS and TIME) or by issuing a backup ("/F sarstc,NEW").
  •  Type a "C" to the left of the report again, a minimum of 4 hours after the first issuing of the "C" above.  At that point, the report will be given either a DISK or PERM location.
  •  Delete the report from the database, using either the View online or using SARBCH "/DELETE ID=... GEN=... SEQ=..." .