I apologize.
You'd think I'd read the whole thread before replying.
One option would be:
Create a file class (for speed. Tape would work)
GENERATE BACKUPSET to this fileclass
This would pull only the active files for that node,
and you could specify to restore from that backupset.
Another wou
If you don't know the tape the most current data is on,
and don't feel like pulling the list of tapes (or can't per the length
of query)...
You could also use MOVE NODEDATA, but it would be more than just the last
version.
-Josh
On 06.03.03 at 16:53 [EMAIL PROTECTED] wrote:
Date: Fri, 3 Mar 2
mysqldump sent through adsmpipe is common and free.
On 06.02.28 at 09:38 [EMAIL PROTECTED] wrote:
Date: Tue, 28 Feb 2006 09:38:36 +1100
From: Paul Ripke <[EMAIL PROTECTED]>
Reply-To: "ADSM: Dist Stor Manager"
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Backing up a MySQL database
On Tuesday, Feb 28
I've run into the same issue alot. It's just a TSM limitation.
TSM is not smart enough to reorder any queue based on tape availability.
IE, if proc 1 is using tape 1,
and proc 2 needs data from tapes 1-5,
TSM won't do 2-5 while waiting for access to 1.
It'll simply go into media wait.
happens a
It's still there. Here's what I wrote up about it in 2001:
FLUSH
This causes a database buffer writers to flush, which would be used to
test for buffer-writer starvation. Use this command when SHOW BUFVARS has
a dpDirty (dirty pages) value in the thousands. Then check log
utilization to see if
Je serai absent(e) du bureau à partir du 2006-03-04 et je serai de retour
le 2006-03-07.
ci-dessous differents contacts
TL Air Canada : Mario Marineau (514) 964-2397
FBN DBA : contact Michel Ouellet (514-964-2225)
BNC DBA : CSP (Pollus Brodeur 514-964-1152 ),
ICE (Mustapha Hamdoun 514
Today, I was reminded why to be careful with SHOW commands during
production workloads and thought I'd share (and archive across the
Internet at large) by posting here:
03/04/06 10:44:46 ANR4391I Expiration processing node NODE, filespace
/oracle, fsId 141, domain STANDARD, and management clas
