search cancel

CA 7 - Reg (#RQ) Deleting the DSN

book

Article ID: 200350

calendar_today

Updated On:

Products

CA 7 Workload Automation Automic Automation Intelligence Unicenter Job Management Option iDash Workload Automation

Issue/Introduction

There is a release DSN which is RELEASE.EBISDATA.EB00001 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

Component : CA-7

Resolution

LDSN/LIST=USERS will show all DSN's for "J-USE" and "J-CRT", but when a DSN rqmt was manually added to a job via panel DB.3.1, then only "#RQ" will be increased, and you have for example to use "LJOB,JOB=*,LIST=RQDSN" to find the job, to which this DSN was added.

If it's 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 cmd via BTI to reset "#RQ" to zero:

DSN

UPD,DSN=,NUMRQ=0

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