[Veritas-bu] BBDBJOBS

Here's a list posted by Rob Worman quite some time ago.  Nothing obvious for
"active start".  IIRC, the bpdbjobs -all_columns output doesn't have a field
for this, it may be a GUI construction.

-M

===
The sample set below are the default columns for 4.5

Note that if you add one entry only, you will only get one column 
from bpdbjobs -report, i.e. adding at least one entry to bp.conf will 
remove all defaults in favor of your bp.conf COLDEFS list. Therefore 
you must specify all columns you desire. If you comment out or delete 
all COLDEF lines - the default values will be back in place.

BPDBJOBS_COLDEFS = JobID 5 true
BPDBJOBS_COLDEFS = Type 4 true
BPDBJOBS_COLDEFS = State 5 true
BPDBJOBS_COLDEFS = Status 6 true
BPDBJOBS_COLDEFS = Policy 6 true
BPDBJOBS_COLDEFS = Schedule 8 true
BPDBJOBS_COLDEFS = Client 6 true
BPDBJOBS_COLDEFS = DstMedia_Server 12 true
BPDBJOBS_COLDEFS = ActPID 10 true

The numerical value indicates how many characters wide you wish the 
column to be.

A complete list of available parameters follows:

JOBID
VERSION
ACTPID
MAINPID
RQSTPID
PARENTJOBID
PRODUCT
TYPE
BACKUPTYPE
STATUS
POLICY
POLICYTYPE
SCHEDULE
SCHEDULETYPE
CLIENT
PRIORITY
OWNER
GROUP
RETENTION
COMPRESSION
LASTBACKUP
STATE
OPERATION
STREAMNUMBER
SRCSTORAGE_UNIT
SRCMEDIA_SERVER
SRCMEDIAID
DSTSTORAGE_UNIT
DSTMEDIA_SERVER
DSTMEDIAID
STARTED
ENDED
TRY
KILOBYTES
FILES
KBPERSEC
PATHNAME
COMPLETION
ESTKB
ESTFILE
ROBOT
VAULT
PROFILE
SESSIONID
NUMTAPESEJECT
JOBSTVERSION
ELAPSED
ACTIVEELAPSED

The following parameters don't actually work unless NetBackup 4.5 is 
patched to MP1 (patch 1) or above.:

BackupType, ClassType, Retention, Estfile, Estkb, Completion, and Pathname
===========

HTH
rob



-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Bob Stump
Sent: Tuesday, December 27, 2005 10:29 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] BBDBJOBS_COLDEFS table


The BPDBJOBS_COLDEFS entry for "Active Start Time" is not defined in the NB
5.1 Sysadmin Guide II chapter 3.
Does anyone know of the values for the missing entries in this table?


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