It is currently 12 Dec 2017 7:12


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:


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

:P


Top
   
 Post subject:
PostPosted: 02 Feb 2012 1:55 
Offline
Nouveau
Nouveau
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.


Top
   
 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.




:?


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

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 1 guest


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 Scheduler-Usage.com. All Rights Reserved