Veritas-bu

[Veritas-bu] loadvmmedia.ctl and loadbpmedia.ctl in goodies

2005-11-03 17:19:26
Subject: [Veritas-bu] loadvmmedia.ctl and loadbpmedia.ctl in goodies
From: jon_bousselot AT sd.vrtx DOT com (Jon Bousselot)
Date: Thu, 03 Nov 2005 14:19:26 -0800
FYI,

Anybody who is using NB 5.x and is using the DIY database features found 
in /usr/openv/netbackup/goodies/mediascripts may have found this already.

In my config, using an Oracle database, I had to amend two of the lines 
in the loadvmmedia.ctl script to properly insert the data from the 
vmquery.out file.  The README file in this directory explains what all 
this does and how you could use it.  The loadvmmedia.ctl and 
loadbpmedia.ctl scripts also explain what each one does. 

 From the loadvmmedia.ctl file:

 off_slot POSITION(351:356) NULLIF (351:351)='-',
 off_ses_id POSITION(359:364) NULLIF (359:359)='-',


While running the loadvmmedia.ctl script, it would fail on these two 
fields, and I had to add the NULLIF statements.
After that, it all works fine.
I'm running NB 5.1 on Solaris 9, and the database is Oracle 10g on 
Solaris 10.

-Jon


<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] loadvmmedia.ctl and loadbpmedia.ctl in goodies, Jon Bousselot <=