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:

All files in the database (Not Recommended)
Select Accounts/Files in the database

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.

Procedure

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.

Tip: To change multiple accounts, build a list containing the account names that you wish to process and run the set-dptr command on the active select-list. For example:

: 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
:_