0C4 or 0C6 abend in FASTSCAN collection
search cancel

0C4 or 0C6 abend in FASTSCAN collection

book

Article ID: 271242

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS

Issue/Introduction

Extract Procedures may abend with either an S0C4 or S0C6.

SYSTEM COMPLETION CODE=0C4  REASON CODE=00000010
TIME=13.48.27  SEQ=08386  CPU=0000  ASID=00CA
PSW AT TIME OF ERROR  078C2000   C040C3C8  ILC 2  INTC 10
  NO ACTIVE MODULE FOUND
  NAME=UNKNOWN

SYSTEM COMPLETION CODE=0C6  REASON CODE=00000006          
 TIME=13.23.10  SEQ=20210  CPU=0000  ASID=021E            
 PSW AT TIME OF ERROR  078C2000   A51F973B  ILC 2  INTC 06
   NO ACTIVE MODULE FOUND                                 
   NAME=UNKNOWN                                           

The abend occurs during collection processing for a FASTSCAN and one of the following messages is issued for the object being processed.

Collection of XP - creator.indexname                - Abend0C4
Collection of XP - creator.indexname                - Abend0C6

The following messages may also be issued.

Storage acquisition failed processing   RALSIX2             
Collection of XP - creator.indexname                - RC0016

When the job is restarted it completes successfully.

Environment

Release : 20.0

Cause

The FASTSCAN is requesting too much storage.

Resolution

Review the Fastscan settings, in particular the number of Buffers and Scans.

COLLECTION - FASTSCAN                                
STATS ID: ssid    BUFFERS: 0480    ERRORS : 0001  
  WTOR CD : 00      SCAN   : 0010    ACCESS : V/EXCP 

The recommended setting for the number of scans is between 3 and 5.

The recommended setting for the Buffers is dependent on the DASD device but this would normally be 360 at the most.

The number of buffers requested affects the amount of memory needed for the extract. The more buffers you assign, the less physical I/O Database Analyzer performs.

Entering a high number of scans does not reduce CPU time, but could reduce elapsed time. Scan values above 5 can severely impact other address spaces depending on hardware and software limitations, current workload, and so forth.

In this particular job, with Buffers set to 480, and Scan set to 10, (10*480) buffers are allocated.

To reduce the amount of virtual storage required for the extract and to resolve the problem:

1. Reduce the buffer amount from 480 to 360
2. Reduce the number of scans from 10 to 5

If this does not work, reduce them further.

Note reducing these values will have a negative impact on the elapsed time.

Additional Information

For further details please refer to Techdocs.