RC/Query panel fails during package list for plan with SQLCODE = -918 or -900

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

Within RC/Query for Db2 for z/OS (RCQ) Plan List encountering the following when attempting to obtain PK Package list:       
                                                                               
DSNT408I SQLCODE = -918, ERROR:  THE SQL STATEMENT CANNOT BE EXECUTED         
         BECAUSE A CONNECTION HAS BEEN LOST                                   
DSNT418I SQLSTATE   = 51021 SQLSTATE RETURN CODE                              
DSNT415I SQLERRP    = DSNXERT SQL PROCEDURE DETECTING ERROR                   
DSNT416I SQLERRD    = -601  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION         
DSNT416I SQLERRD    = X'FFFFFDA7'  X'00000000'  X'00000000'                   
         X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC                 
         INFORMATION              


DSNT408I SQLCODE = -900, ERROR:  THE SQL STATEMENT CANNOT BE EXECUTED
         BECAUSE THE APPLICATION PROCESS IS NOT CONNECTED TO A SERVER

Resolution

This problem happens when all remote locations are NOT active.

Setting 'All Locations' to 'N' stops the problem.

Solution:
On any RC/Query panel, enter the PROFILE line command.
2 -  RC/QUERY Profile Variables
ALL LOCATIONS       ==> N    (Y/N)   - For searches in Plan/Package Report.


There is no global change parameter.  Each user will required the PROFILE modification.