Veritas-bu

Re: [Veritas-bu] Veritas Netbackup Report Status by each mountpoint.

2009-12-18 13:25:51
Subject: Re: [Veritas-bu] Veritas Netbackup Report Status by each mountpoint.
From: A Darren Dunham <ddunham AT taos DOT com>
To: veritas-bu AT mailman.eng.auburn DOT edu
Date: Fri, 18 Dec 2009 18:25:40 +0000
On Fri, Dec 18, 2009 at 12:31:12PM -0500, Martin, Jonathan wrote:
> What version of NBU are you using?  I dump this data regularly using the
> -all_columns and write it to a SQL database, and while I get a last path
> backed up field, I do not get a path field.  Here's a single line of
> output from my NBU 6.5 MP3 on Windows 2003 master.

Here's a description of the output:

http://mailman.eng.auburn.edu/pipermail/veritas-bu/2005-January/077450.html

Because you can have multiple files listed in the policy, the job has a
field that contains the number.  This is field 32.  The file list starts
at the next field (33) for the number given in field 32.

Here's the output from a windows 6.5.3 master server.  Note that because
perl indexes are from 0, not 1, we subtract one number from the field
position.

$ bpdbjobs -jobid 557172 -all_columns | perl -F, -lane 'print $F[31]'
1

$ bpdbjobs -jobid 557172 -all_columns | perl -F, -lane 'print $F[32]'
ALL_LOCAL_DRIVES


> 793383,0,3,0,__DSSU_POLICY_pbcobk02-dssu-onsite,-,pbcobk02,pbcobk01,1261
> 155624,0000000082,1261155706,
> ,1,,,,,100,,root,1,34,0,0,root,pbcobk01,2,2,0,,,1,pbcobk02-dssu-onsite,1
> ,0,,pbcobk01,1261155626,0000000080,1261155706,0,the requested operation
> was successfully completed,21,12/18/2009 12:00:24 PM - requesting
> resource pbcobk01.NBU_CLIENT.MAXJOBS.pbcobk02,12/18/2009 12:00:24 PM -
> requesting resource

This job appears to be for policy type 34 (field 22).  I can't find that
policy type mentioned in the docs, and I don't have it in my server (0
is standard, 13 is Windows, 19 is NDMP, and 35 is hot-catalog backups).
So this particular job doesn't appear to have a backup list associated
with it.  Can you tell me what type of policy is responsible for the
job?

> Why does yours look so different?  I've been thinking about writing the
> bpflist option Mark mentioned below, but if I could get output like
> yours I would be set.

Looks like a policy type difference at first glance.

(I continue to use bpflist just so I can capture data after it's fallen
out of the job database).

-- 
Darren
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu