Solved: At my version of NBU 7.6,

Eric_Zhang · ‎11-26-2013

Dear all

before I always thought that the Activity monitor information will be stored somewhere under : /usr/openv/netbackup/db/jobs

however today I did a test , I shutdown the Netbackup on the master server . and then deleted all the files\folder under ../db/jobs,

start the Netbackup services . you know what ? I still can see the old jobs information in the Activity Monitor .

ummm , confusing !

Any idea ? much appreciated !

Eric

mph999 · ‎11-26-2013

At my version of NBU 7.6, this is file 857.dat from a NBDB unload.

"JOBD_MAIN"."JOBD_Job"

It's a bit difficult to read ... (this is just x1 row)

'1000002','194','0','20126','0','0','17','0','0','','0','','','','root','','','','','','','','','0','0','0','85000','0','0','1','3','1','1','0','0','0','0','0','0','','0','0','0','1','0','0','0','0','-1','','','','','0','0','0','0','','','','0','',0xC50243001C04020100800000,'2013-11-19 00:56:21.000000','2013-11-19 00:56:37.000000','2013-11-19 00:56:21.000000','2013-11-20 00:00:03.293983'

The fileds are defined (so 1000002 is master server key, 194 is jobid and so on ...)

1 "MasterServerKey" unsigned int NOT NULL CONSTRAINT "CKC_MASTERSERVERKEY_JOBD_JOB" check(MasterServerKey between 1000001 and 2000000)

2 ,"JobId" integer NOT NULL DEFAULT autoincrement CONSTRAINT "CKC_JOBID_JOBD_JOB" check(JobId >= 1)

3 ,"ParentJobId" integer NOT NULL DEFAULT 0

4 ,"ActiveProcessId" integer NOT NULL DEFAULT 0

5 ,"MainProcessId" integer NOT NULL DEFAULT 0

6 ,"ProductType" integer NOT NULL DEFAULT 0

7 ,"JobType" integer NOT NULL

8 ,"JobSubType" integer NOT NULL

9 ,"PolicyType" integer NOT NULL DEFAULT 0

10 ,"PolicyName" varchar(256) NOT NULL DEFAULT ''

11 ,"ScheduleType" integer NOT NULL DEFAULT 0

12 ,"ScheduleName" varchar(256) NOT NULL DEFAULT ''

13 ,"ClientName" varchar(1024) NOT NULL DEFAULT ''

14 ,"ControlHost" varchar(1024) NOT NULL DEFAULT ''

15 ,"JobOwner" varchar(32) NOT NULL DEFAULT 'root'

16 ,"JobGroup" varchar(32) NOT NULL DEFAULT 'root'

17 ,"BackupId" varchar(256) NOT NULL DEFAULT ''

18 ,"SourceMediaId" varchar(32) NOT NULL DEFAULT ''

19 ,"SourceStorageUnitName" varchar(128) NOT NULL DEFAULT ''

20 ,"SourceMediaServerName" varchar(1024) NOT NULL DEFAULT ''

21 ,"DestinationMediaId" varchar(32) NOT NULL DEFAULT ''

22 ,"DestinationStorageUnitName" varchar(128) NOT NULL DEFAULT ''

23 ,"DestinationMediaServerName" varchar(1024) NOT NULL DEFAULT ''

24 ,"DataMovement" integer NOT NULL DEFAULT 0

25 ,"StreamNumber" integer NOT NULL DEFAULT 0

26 ,"CopyNumber" integer NOT NULL DEFAULT 0

27 ,"Priority" integer NOT NULL DEFAULT 0

28 ,"Retention" integer NOT NULL DEFAULT 0

29 ,"Compression" integer NOT NULL DEFAULT 0

30 ,"Status" integer NOT NULL DEFAULT 0

31 ,"State" integer NOT NULL DEFAULT 0

32 ,"Done" integer NOT NULL DEFAULT 0

33 ,"Try" integer NOT NULL DEFAULT 0

34 ,"NumberOfFiles" unsigned int NOT NULL DEFAULT 0

35 ,"EstimatedFiles" unsigned int NOT NULL DEFAULT 0

36 ,"KilobytesTransfered" unsigned bigint NOT NULL DEFAULT 0

37 ,"KilobytesToTransfer" unsigned bigint NOT NULL DEFAULT 0

38 ,"TransferRate" unsigned int NOT NULL DEFAULT 0

39 ,"PercentComplete" integer NOT NULL DEFAULT 0

40 ,"CurrentFile" varchar(1024) NOT NULL DEFAULT ''

41 ,"Restartable" integer NOT NULL DEFAULT 0

42 ,"Suspendable" integer NOT NULL DEFAULT 0

43 ,"Resumable" integer NOT NULL DEFAULT 0

44 ,"Killable" integer NOT NULL DEFAULT 0

45 ,"FrozenImage" integer NOT NULL DEFAULT 0

46 ,"TransportType" integer NOT NULL DEFAULT 0

47 ,"DedupRatio" float NOT NULL DEFAULT 0

48 ,"CurrentOperation" integer NOT NULL DEFAULT 0

49 ,"QReasonCode" integer NOT NULL DEFAULT 0

50 ,"QResource" varchar(1024) NOT NULL DEFAULT ''

51 ,"RobotName" varchar(256) NOT NULL DEFAULT ''

52 ,"VaultName" varchar(256) NOT NULL DEFAULT ''

53 ,"ProfileName" varchar(256) NOT NULL DEFAULT ''

54 ,"SessionId" integer NOT NULL DEFAULT 0

55 ,"NumberOfTapeToEject" integer NOT NULL DEFAULT 0

56 ,"SubmissionType" integer NOT NULL DEFAULT 0

57 ,"AcceleratorOptimization" integer NOT NULL DEFAULT 0

58 ,"InstanceDatabaseName" varchar(1024) NULL

59 ,"AuditUserName" varchar(128) NOT NULL DEFAULT ''

60 ,"AuditDomainName" varchar(256) NOT NULL DEFAULT ''

61 ,"AuditDomainType" integer NOT NULL DEFAULT 0

62 ,"RestoreBackupIDs" varchar(1024) NOT NULL DEFAULT ''

63 ,"BitField" binary(12) NOT NULL DEFAULT 0

64 ,"StartTime" timestamp NOT NULL DEFAULT '1970-01-01 00:00:00'

65 ,"EndTime" timestamp NOT NULL DEFAULT '1970-01-01 00:00:00'

66 ,"ActiveTryStartTime" timestamp NOT NULL DEFAULT '1970-01-01 00:00:00'

67 ,"LastUpdateTime" timestamp NOT NULL DEFAULT utc timestamp

68 ,CONSTRAINT "PK_JOBD_JOB" PRIMARY KEY CLUSTERED ("MasterServerKey" ASC,"JobId" ASC)

Or in a easier format ...

---< Row 1 >---------------------------------------------------------------

1: "MasterServerKey" unsigned int = '1000002'

2: "JobId" integer = '194'

3: "ParentJobId" integer = '0'

4: "ActiveProcessId" integer = '20126'

5: "MainProcessId" integer = '0'

6: "ProductType" integer = '0'

7: "JobType" integer = '17'

8: "JobSubType" integer = '0'

9: "PolicyType" integer = '0'

10: "PolicyName" varchar(256) = ''

11: "ScheduleType" integer = '0'

12: "ScheduleName" varchar(256) = ''

13: "ClientName" varchar(1024) = ''

14: "ControlHost" varchar(1024) = ''

15: "JobOwner" varchar(32) = 'root'

16: "JobGroup" varchar(32) = ''

17: "BackupId" varchar(256) = ''

18: "SourceMediaId" varchar(32) = ''

19: "SourceStorageUnitName" varchar(128) = ''

20: "SourceMediaServerName" varchar(1024) = ''

21: "DestinationMediaId" varchar(32) = ''

22: "DestinationStorageUnitName" varchar(128) = ''

23: "DestinationMediaServerName" varchar(1024) = ''

24: "DataMovement" integer = '0'

25: "StreamNumber" integer = '0'

26: "CopyNumber" integer = '0'

27: "Priority" integer = '85000'

28: "Retention" integer = '0'

29: "Compression" integer = '0'

30: "Status" integer = '1'

31: "State" integer = '3'

32: "Done" integer = '1'

33: "Try" integer = '1'

34: "NumberOfFiles" unsigned int = '0'

35: "EstimatedFiles" unsigned int = '0'

36: "KilobytesTransfered" unsigned bigint = '0'

37: "KilobytesToTransfer" unsigned bigint = '0'

38: "TransferRate" unsigned int = '0'

39: "PercentComplete" integer = '0'

40: "CurrentFile" varchar(1024) = ''

41: "Restartable" integer = '0'

42: "Suspendable" integer = '0'

43: "Resumable" integer = '0'

44: "Killable" integer = '1'

45: "FrozenImage" integer = '0'

46: "TransportType" integer = '0'

47: "DedupRatio" float = '0'

48: "CurrentOperation" integer = '0'

49: "QReasonCode" integer = '-1'

50: "QResource" varchar(1024) = ''

51: "RobotName" varchar(256) = ''

52: "VaultName" varchar(256) = ''

53: "ProfileName" varchar(256) = ''

54: "SessionId" integer = '0'

55: "NumberOfTapeToEject" integer = '0'

56: "SubmissionType" integer = '0'

57: "AcceleratorOptimization" integer = '0'

58: "InstanceDatabaseName" varchar(1024) = ''

59: "AuditUserName" varchar(128) = ''

60: "AuditDomainName" varchar(256) = ''

61: "AuditDomainType" integer = '0'

62: "RestoreBackupIDs" varchar(1024) = ''

63: "BitField" binary(12) = 0xC50243001C04020100800000

64: "StartTime" timestamp = '2013-11-19 00:56:21.000000'

65: "EndTime" timestamp = '2013-11-19 00:56:37.000000'

66: "ActiveTryStartTime" timestamp = '2013-11-19 00:56:21.000000'

67: "LastUpdateTime" timestamp = '2013-11-20 00:00:03.293983'

View solution in original post

sri_vani · ‎11-26-2013

to manage activity monitor---u can use bpdbjobs command (to delete..)

Job info stored in job database.

Ref:http://www.symantec.com/business/support/index?page=content&id=HOWTO72644

Db/jobs---It will have job details like job id,active jobs...etc

revarooo · ‎11-26-2013

New database table called JOBD_Job stores this information in the NBDB database.

mph999 · ‎11-26-2013