It is currently 25 Sep 2018 1:07

Post new topic  Reply to topic  [ 6 posts ] 
Author Message
PostPosted: 25 Jan 2012 11:43 
Hi all,

I have an issue when i try to delete some quantitative ressources.

When I delete one of them, i have a request rejected by datacenter. because some ressources are used by jobs.

But when, i search the jobs using the QR, i found nothing.

Could you give me a solution (control-m utility, command or sql request) to liberate the QR or force deletion.

Thanks in advance.

regards :wink:

 Post subject:
PostPosted: 26 Jan 2012 4:29 
Anyone can help me ?


 Post subject:
PostPosted: 02 Feb 2012 1:55 
User avatar

Joined: 15 Nov 2011 12:00
Posts: 11
open a sql session to your database.

select * from CMR_QRTAB where QRESNAME='qresourcename'

This lists all the quantative resources on the QR resource table - this will show how many are reserved, in use etc.

select * from CMR_QRUSE where QRESNAME='qresourcename'

Will show resources actually in use and what is using them.

Hope that helps a little.

 Post subject:
PostPosted: 10 Feb 2012 12:05 
Many thanks for your reply.

But I can show the QR in use, and i would like to delete it.

When i try to delete with ecaqrtab utility, i have the same message :

QRINUSE. Unable to delete the reserved/used QR.

But i don't have job using this QR.


Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 6 posts ] 

All times are UTC+02:00

Who is online

Users browsing this forum: Google [Bot] and 2 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by All Rights Reserved