Subscribe

DB2 Archive Log Management

[ Edited ]

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

Re: DB2 Archive Log Management

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

Re: DB2 Archive Log Management

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.