Quantitative Ressources Deletion

Taouche · Post by **Taouche** » 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

Taouche · Post by **Taouche** » 26 Jan 2012 4:29

Anyone can help me ?

sukie · Post by **sukie** » 02 Feb 2012 1:55

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.

Taouche · Post by **Taouche** » 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.