RECOVER-TOOL Recovery Estimator EST2023E - Stored procedure call failed.

Products

• Recovery Analyzer for DB2 for z/OS

Issue/Introduction

Working with Recovery Estimator and the following EST2023E error is returned:

********************************* TOP OF DATA **********************************
PUT0000I - Database Management for Db2 Utilities 20.0.nn - Started            
PUT3520I - 1 zIIP processors currently online                                 
            Activating zIIP services                                           
PUT0006I - Initialization Complete  -  dd mmm yyyy hh:mm:ss
 -- To estimate to the current point:                                          
PUT0018I - Invoking Utility RECOVER-TOOL - Statement Number:      001         
EST0010I - RECOVERY ESTIMATION REPORT:                                        
EST0020I - RECOVERY ESTIMATOR VERSION: 20.0.nn EXECUTING ON                   
           DB2 SUBSYSTEM: ssid  RELEASE: nnnn  MODE: xxx                      
EST1010I - CONTROL STATEMENT USED:                                            
EST1011I - RECOVER-TOOL ESTIMATE-RECOVERY TABLESPACE dbname.tsname             
EST7010I - ERRORS REPORT:                                                     
EST2023E - Stored procedure call failed. Procedure:                           
            'SYSPROC.ADMIN_COMMAND_DB2'. Return code: '0'. Error message: '' SQL
            code: '-471'.  (QuerryObjectStatus)                             
PUT0136I - Primary restart rows deleted                                    
******************************** BOTTOM OF DATA *****************************

Environment

Release : 20.0

Resolution

This issue is due to the fact that the Recovery Estimator uses two Db2 stored procedures:

SYSPROC.ADMIN_COMMAND_DB2
SYSPROC.ADMIN_DS_LIST

These two stored procedures are supplied with Db2. It appears that these stored procedures are not set up correctly on the Db2 subsystem being used.
There is a process that must be followed in order to install those stored procedures.

Find more details: Installing Db2-supplied routines during installation and Installation information for procedures and functions that are supplied with Db2.

Have these two correctly installed as per the instructions from IBM above.