Table 9.9: Pool table layout

Column Name

Data Type

Remark

PoolId

integer

Primary Key

Name

Tinyblob

Pool Name

NumVols

Integer

Number of Volumes in the Pool

MaxVols

Integer

Maximum Volumes in the Pool

UseOnce

tinyint

Use volume once

UseCatalog

tinyint

Set to use catalog

AcceptAnyVolume

tinyint

Accept any volume from Pool

VolRetention

bigint

64 bit seconds to retain volume

VolUseDuration

bigint

64 bit seconds volume can be used

MaxVolJobs

integer

max jobs on volume

MaxVolFiles

integer

max EOF marks to put on Volume

MaxVolBytes

bigint

max bytes to write on Volume

MaxPoolBytes

bigint

max bytes to write on the Pool

AutoPrune

tinyint

<yes/no> for autopruning

Recycle

tinyint

<yes/no> for allowing auto recycling of Volume

ActionOnPurge

tinyint

Default Volume ActionOnPurge

PoolType

enum

Backup, Copy, Cloned, Archive, Migration

LabelType

tinyint

Type of label ANSI / Bacula

LabelFormat

Tinyblob

Label format

Enabled

tinyint

Whether or not Volume can be written

ScratchPoolId

integer

Id of Scratch Pool

RecyclePoolId

integer

Pool ID where to recycle Volume

NextPoolId

integer

Pool ID of next Pool

MigrationHighBytes

bigint

High water mark for migration

MigrationLowBytes

bigint

Low water mark for migration

MigrationTime

bigint

Time before migration