Configuration Database

Use

The configuration database is used to save settings of the SAP-DB2admin tool permanently. In R/3 versions prior to 4.0x, some of these tool parameters were defined in the file /db2/<SID>/dbs/init<SID>.sap . In case of an upgrade to 4.0x, it could make sense to use this file as a template for the settings in the configuration database.

The configuration database can be managed using the DB2 Control Center. Currently only changes are allowed; parameters cannot be removed. To change values, select the SAP-DB2admin: Options function of the db2<sid> R/3 database and change the values as required.

Parameter:

backup_dev_type

Default:

tape

Options:

tape|adsm

Purpose:

Archiving target

Recommendation:

Not applicable

Operating system

AIX and NT

Parameter:

cpio_in_flags

Default:

-iduvB

Options:

Valid cpio options

Purpose:

Copy files on tape

Recommendation:

Do not change

Operating system

AIX and NT

Parameter:

cpio_flags

Default:

-ovB

Options:

Valid cpio options

Purpose:

Copy files from tape

Recommendation:

Do not change

Operating system

AIX and NT

Parameter:

rewind

Default:

tctl -f $ rewind

Options:

Valid tctl options

Purpose:

Rewind tape

Recommendation:

Do not change

Operating system

AIX

Parameter:

rewind_offline

Default:

tctl -f $ rewoffl

Options:

Valid tctl options

Purpose:

Rewind tape and eject

Recommendation:

Do not change

Operating system

AIX

Parameter:

tape_pos_cmd

Default:

tctl -f $ fsf $

Options:

Valid tctl options

Purpose:

Position on a tape / skip file marks

Recommendation:

Do not change

Operating system

AIX

Parameter:

rewind

Default:

mt -f $ rewind

Options:

Valid tctl options

Purpose:

Rewind tape

Recommendation:

Do not change

Operating system

NT

Parameter:

rewind_offline

Default:

mt -f $ rewoffl

Options:

Valid tctl options

Purpose:

Rewind tape and eject

Recommendation:

Do not change

Operating system

NT

Parameter:

tape_pos_cmd

Default:

mt -f $ fsf $

Options:

Valid tctl options

Purpose:

Position on a tape / skip file marks

Recommendation:

Do not change

Operating system

NT

Parameter:

tape_size

Default:

3500M

Options:

Tape-device-dependent

Purpose:

Size available on tape medium

Recommendation:

Varies according to your hardware capabilities

Operating system

AIX and NT

Parameter:

tape_address

Default:

/dev/rmt0.1

Options:

System-dependent

Purpose:

Device address of non-rewind tape

Recommendation:

To have one tape drive exclusively reserved for log file archiving.

Operating system:

AIX

Parameter:

tape_address_rew

Default:

/dev/rmt0

Options:

System-dependent

Purpose:

Device address of automatically rewinding tape

Recommendation:

To have one tape drive exclusively reserved for log file archiving.

Operating system:

AIX

Parameter:

tape_address

Default:

/dev/nmt0

Options:

System-dependent

Purpose:

Device address of non-rewind tape

Recommendation:

To have one tape drive exclusively reserved for log file archiving.

Operating system:

NT

Parameter:

tape_address_rew

Default:

/dev/mt0

Options:

System-dependent

Purpose:

Device address of automatically rewinding tape

Recommendation:

To have one tape drive exclusively reserved for log file archiving.

Operating system:

NT

Parameter:

tape_pool

Default:

<SID>A01, <SID>A02, <SID>A03, <SID>A04, <SID>A05, <SID>A06, <SID>A07, <SID>A08, <SID>A09, <SID>A10

Options:

List can be changed

Purpose:

List of valid tape labels

Recommendation:

Very much dependent on a customer’s recovery procedure and recovery requirements

Operating system:

AIX and NT

Parameter:

expir_period

Default:

6

Options:

Any other number of weeks

Purpose:

Number of weeks a tape must not be overwritten

Recommendation:

Very much dependent on a customer’s recovery procedure and recovery requirements

Operating system:

AIX and NT

Parameter:

tape_use_count

Default:

100

Options:

Any value of your choice

Purpose:

Allowed number of reuses of a tape

Recommendation:

The fewer times used, the safer the medium

Operating system:

AIX and NT