Hi Dear Community,
Every Monday The OpsCenter sends me a mail that you need to change some tapes in the I40 Quantum tape library. Is written some queries for this process.
The query is below
select TOP 20 START AT 1 domain_Media.barcode as "domain_Media.barcode",adjust_timestamp(domain_Media.lastWriteTime,0 ) as "domain_Media.lastWriteTime" from domain_Media , domain_MasterServer where domain_MasterServer.id = domain_Media.masterServerId and ( ( (domain_Media.volumePoolName IN ('Archives', 'CatalogBackup' )) ) AND ( (domain_Media.lastWriteTime BETWEEN '138421142769290000' AND '138423734769290000') ) AND ( ( (CASE WHEN domain_Media.isValid = 1 THEN 1 WHEN domain_Media.isValid = 0 THEN 0 ELSE 1 END) = '1') ) AND ( ( (CASE WHEN domain_Media.deleted = 1 THEN 1 WHEN domain_Media.deleted = 0 THEN 0 ELSE 1 END) = '0') ) AND ( ( (domain_MasterServer.id IN (144073 )) ) ) ) ORDER BY UPPER("domain_Media"."barcode" ) ASC , "domain_Media.lastWriteTime" ASC
How l can investigate the query in the Database? How l can log in Database? Because Duplication Type shows 96 errors (but there are active tapes in weekly pool NBU doesn;t use it) in Activity Monitor. Can l redefine the weekly volume pool tapes as scratch pool tape?