Database Configuration

The database accounts and files to be backed up with a Hot Backup configuration must be specified. There are two options for this specification:

It is recommended that you only log those files that need to be logged to the slave server. To specify the account and files to log, the D-Pointers on these accounts and files must be changed using the set-dptr command.

Various attribute types can be set and unset using the set-dptr command. The L attribute instructs the database to log the file.

To turn the logging attribute on for an account:

  1. Enter:

set-dptr +L accountname (A

where accountname is the name of the account.

The example below illustrates running the set-dptr command on the hbtest account. Attribute 1 in all D-Pointers in the hbtest account is changed from D to DL for both dictionary and data levels.

set-dptr +L hbtest (A

Selecting files in account 'hbtest' ...

hbtest

 

:

D —> DL

 

bp

:

D —> DL

 

 

bp

:

D —> DL

 

hbdata

:

D —> DL

 

 

hbdata

:

D —> DL

5 file(s) changed

 

NOTE

  • The set-dptr command changes any item in the MD or dictionary level of a file whose attribute 1 value starts with a D.

  • The (d option of the set-dptr command (when used with the +l attribute) ensures that newly logged files are synchronized with the Hot Backup slave or a Transaction Log tape.

To change multiple accounts, you can:

or

:get-list acclist

>set-dptr +L (A

The example below illustrates the set-dptr command working with an active select-list containing file names.

List 'filelist' in file 'pointer-file' saved.

:get-list filelist

 

[404] 9 items selected out of 1 items.

set-dptr +L (P

 

data5

:

D —> DL

 

 

data5

:

D —> DL

 

data6

:

D —> DL

 

 

data6

:

D —> DL

 

data7

:

D —> DL

 

 

data7

:

D —> DL

 

data8

:

D —> DL

 

 

data8

:

D —> DL

 

bp

:

D —> DL

 

 

bp

:

D —> DL

 

hbdata

:

D —> DL

 

 

hbdata

:

D —> DL

 

data2

:

D —> DL

 

 

data2

:

D —> DL

 

data3

:

D —> DL

 

 

data3

:

D —> DL

 

data4

:

D —> DL

 

 

data4

:

D —> DL

18 file(s) changed

:_

See Also

Configuring Hot Backup

Hot Backup Master Server Configuration

Hot Backup Slave Server Configuration

Synchronizing the Servers