ADSM-L

Re: Handling spikes in storage transfer

2002-01-14 11:16:32
Subject: Re: Handling spikes in storage transfer
From: "Cook, Dwight E (SAIC)" <cookde AT BP DOT COM>
Date: Mon, 14 Jan 2002 10:12:54 -0600
Try this... but alter the "<1" to fit your need... maybe need <2 etc...

select * from adsm.backups where (node_name='YOUR_NODE' and
cast((current_timestamp-backup_date)day as decimal(18,0))<1)