* PPADB2 ERROR: NO TARGET SPECIFIED. CURRENT TARGET = ( ) * using quick explain

book

Article ID: 140365

calendar_today

Updated On:

Products

CA SQL-Ease for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Database Management for DB2 for z/OS - Performance Suite CA Database Management for DB2 for z/OS - SQL Performance Suite

Issue/Introduction

The following error message was displayed when doing a quick explain of a package:

* ERROR: NO TARGET SPECIFIED. CURRENT TARGET = ( ) *       

 

Environment

Release : 19.0

Component : CA Plan Analyzer for DB2 for z/OS

Resolution

The problem is caused by missing TARGET control card which defaults to TARGET = ( ) *   causing the error. To resolve the error message add the following card to the control cards after ISOLATE before resubmitting the explain job:

TARGET = (D11A(@@RULDBA))