Forum Discussion

Tabriz's avatar
Tabriz
Level 5
4 years ago

Netbackup 7.7.3 Database

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? 

 

Thanks