Database Analyzer Extract Collection finished with RC=08 and a EXCP I/O error messages

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

Running a Database Analyzer for Db2 for z/OS (PDA) Extract Collection and it finished with RC=08 and the following I/O error messages:
 
Collection of TS - dbname.tsname - Started 19:12:27
MMgr-EXCP I/O error. Call Technical Support . RC=0016 RS=0000 ..
Collection of TS - dbname.tsname - Incomplete RC=8
 
There were no additional messages in the output to know the cause of the problem and there was not any reported error in the access to the table space by Db2.

Resolution

Db2 uses a data set naming convention of VCAT.DSNDBx.DBNAME.TSNAME.y0001.znnn in which the low level qualifier znnn is incremented starting with A001.
In the data set to define this table space TSNAME there was a data set with prefix A000, the presence  of the A000 data set interferes with the ability of opening
a multi-data set table space or non-partition index data set. Apparently, neither Db2 nor Database Analyzer's VSAM access method has a problem with this
non-Db2 data set but other related Db2 services (Utilities, Media Manager access method, etc,  ...) can. Using A000 for a non-DB2 data set seems a bit dangerous.

So, unless there is a very compelling reason for using a z000 low level qualifier for a non-DB2 data set, we strongly recommend against doing so, since it interferes
with Db2's best practices naming convention.