In PTIMSG output from a Database Analyzer for Db2 statistics collection the ACCESS parameter is listed 3 times

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

Example Database Analyzer for Db2 for z/OS (PDA) output as follows. Values can be different and cause confusion over there meaning.

1. Options specified when procedure was SUBMITted:

   COLLECTION - FASTSCAN
   STATS ID: ssid BUFFERS: 0360 ERRORS : 0010
   WTOR CD : 00 SCAN : 0006 ACCESS : VSAM

2. PTIIPT input control cards:
   
   check the first control card, in column 32
   
   e.g. x'88' this means use VSAM access, extract procedure.
   
   
   
   
3. Collection of data statistics Started - Subsystem - ssid
   
   Access: V/EXCP Buffers: 0360 Scans: 0006 Scantype: FASTSCAN

Resolution

The first two values listed represent the "Obj Read Access" value of the user's PDA Profile at the time the extract JCL was created.

The third value actually represents the access method used.

This can be different (as in the example given) as the value of EXCP_READ_ACCESS in the PDA member of the users PARMLIB can affect the ACCESS used.

In this case EXCP_READ_ACCESS is set to TS_COLL so overrides the value of VSAM that was defined in the profile.