RAP165E When Excluding Objects from an Extract Procedure

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

Receive error message RAP165E - Object already included or excluded when attempting to exclude a tablespace or object from an extract procedure.

Environment

Database Analyzer for DB2 for z/OS

Cause

This issue typically occurs because the object is not currently part of the active selection list or is already implicitly included via a database-level selection (Auto-build).

Resolution

To successfully exclude an object, first ensure it is explicitly included in the selection list so the system can modify its status to "Exclude."
Follow these steps to resolve the error:

1. Navigate to the PDA Main Menu and select EP (Extract Procedure).
2. On the EXTRACT PROCEDURE SERVICES panel, enter U (Update) next to the relevant extract procedure.
3. On the BUILD EXTRACT PROCEDURES panel, enter the selection parameters for the object you wish to exclude:
   Database Level ==> #### (e.g., DBL###)
   Table Space ==> #### (e.g., TSPC### or % to list all objects)
   Press ENTER.
4. Once the object displays in the list, type E (Exclude) in the O (Option) column next to that object.
   Press PF3 to save your changes.
5. Verify the final configuration by using the EXPLODE command on the BUILD EXTRACT PROCEDURES panel. This allows you to view the full list of included and excluded objects for the procedure.