CA 7 - Reg (#RQ) Deleting the DSN

Products

• CA 7 Workload Automation

Issue/Introduction

There is a release DSN which is OUR.RELEASE.DATASET we have defined in CA7. As per user request this is not needed now hence we tried to delete the same but got the below error message while deleting it. None of the CA7 jobs are using this file. Unable to delete the file and receive following message.

MESSAGE: DSN HAS USERS -- CANNOT DELETE

Environment

Release : 11.3

 

Resolution

LDSN,DSN=OUR.RELEASE.DATASET,LIST=USERS will show all DSN's for "J-USE" and "J-CRT".  When the DSN requirement was manually added to a job via panel DB.3.1, then only "#RQ" will be increased and the  "LJOB,JOB=*,LIST=RQDSN" to find the job, to which this DSN was added.

If found, then simply use panel DB.3.1 to manually remove the DSN rqmt.  If you cannot find it, because the job was deleted before removing the DSN rqmt, then you may use following command via BTI to reset "#RQ" to zero:

DSN

UPD,DSN=OUR.RELEASE.DATASET,NUMRQ=0

Afterwards, LDSN should show, that "#RQ" is zero now.