Data Backup and Recovery

DB2 Archive Log Management

michaelalbers
3,350 Views

Hi all,

we configured db2 database writing archivelogs to two different NFS destinations. Db2 server is linux-based only with NFS connectet database and log locations.

Is it possible to configure the archive log management feature in SnapCreator 3.5.0 to handle 2 different locations?

Here the settings:

ARCHIVE_LOG_ENABLE=Y

ARCHIVE_LOG_RETENTION=9

ARCHIVE_LOG_DIR=/media/nfs/archlog/XX/db2e10/E10

ARCHIVE_LOG_EXT=LOG

ARCHIVE_LOG_RECURSIVE_SEARCH=Y

Thanks,

Michael

2 REPLIES 2

michaelalbers
3,350 Views

Hi all,

the following configuration is working:

Mounting the two NFS exports with this way:

1.1.1.1:/vol/vol_archlog1/archlog1      /media/nfs/archlog/XX

2.2.2.2:/vol/vol_archlog2/archlog2      /media/nfs/archlog/YY

Archivelog management settings:

ARCHIVE_LOG_ENABLE=Y

ARCHIVE_LOG_RETENTION=9

ARCHIVE_LOG_DIR=/media/nfs/archlog

ARCHIVE_LOG_EXT=LOG

ARCHIVE_LOG_RECURSIVE_SEARCH=Y

Michael

kevinp
3,350 Views

If it helps, I just found the following from the SC 3.6 IAG, page 51.

ARCHIVE_LOG_DIR: Path to the directory that contains the archive logs. Optionally, for multiple archive log directories, ARCHIVE_LOG_DIR<##> can be used.

Public