Backup only DB6 archive log

[Former Member]

Dear All

How to backup only db6 archive log when I use DB2 on windows

Thanks

[Former Member]

Dear Thomas Matthae

I understand it,I will configure LOGARCHMETH1 locate on disk and configure LOGARCHMETH2 with OFF value.

My requirement is only backup all archive log which contain into LOGARCHMETH1,This backup is created db2 tool

Thanks

[Thomas_Matthä]

Hi,

I don't understand, what should be a big mistake.

Of cause you have LOGARCHMETH1 set to disk, OK you also have LOGARCHMETH2 set to another disk. But normally, log files should be archived to both disk locations,

meaning the content of LOGARCHMETH2 is only a copy of LOGARCHMETH1.

Perhaps you refer to the statement, that db2tapemanager cannot backup log files stored in LOGARCHMETH2. This sould not

be a problem because LOGARCHMETH1 contains everything you need.

kind regards

Thomas

[Former Member]

Dear Thomas Matthae

And this backup image only backup archive log.

Thanks

[Former Member]

Dear Thomas Matthae

This is big mistake,Now LOGARCHMETH1 and LOGARCHMETH2 are located on disk.I need backup all archive log of LOGARCHMETH1,This backup image is store on disk.

Thanks

[Thomas_Matthä]

Hi,

take a look at page 93.

"For tape support, you have to set the database configuration parameter LOGARCHMETH1 to a disk location..."

kind regards

Thomas

[Former Member]

Dear Thomas Matthae

Please help me.I can't find it.

Thanks

[Thomas_Matthä]

Hi,

I just found in the Admin Guide, that with the "new logfile management" using db2tapemgr is is really possible to use it to also transfer files from a archive destination "disk" to type. For details please refer to the admin guide.

kind regards

Thomas

[Thomas_Matthä]

Hi

then you would need to have a simple filesystem backup solution to backup

filesystems to tape. I think I have read that you ar eon Windows. So you can

use the Windows built-in backup utility or third party solutions to backup your

archive directory to tape.

kind regards

Thomas

[Former Member]

Dear Thomas Matthae

I want to backup all archive log of LOGARCHMETH1.Because I don't use TSM.

Thanks

[malte_schuenemann]

Then, one way is to save the contents of that directory using OS means. DB2 is already out of the game at this point.

Malte

[Thomas_Matthä]

Hi,

NO, as Malte said, archiving is the process of moving logfiles from the log directory to an archive. From this point, they are out of the scope of DB2.

When you archive to TSM, this might be a "final" archive destination, compared with your case, using a local directory for archiving. What you need to do is backup these files to somewhere, where you can get them back when needed. This is a process outside of DB2. You canot use Db2 Tapemanager for that ! Db2 Tapemanager's purpose is to use it for archiving, so the movement process from the log directory directly to tape !!

For details on how to configure DB2 archiving, see the SAP DB2 Database Administration guide at:

https://www.sdn.sap.com/irj/sdn/db6?rid=/library/uuid/f03d5fb8-b619-2b10-c383-c6d56872829e

kind regrds

Thomas

[Former Member]

Dear Malte Schuenema...

When database has archive two directories LOGARCHMETH1 and LOGARCHMETH2,I use db2tapemgr backup archive log to tape ???

Thanks

[Former Member]

Dear Malte Schuenema...

But I want backup all archive log LOGARCHMETH1 to a backup image disk(only all archive log), when a archive log is damage I will use backup image of archive log.

Thanks

[Former Member]

Dear Malte Schuenema...

But I want backup all archive log LOGARCHMETH1 to a backup image disk(only all archive log), when a archive log is damage I will use backup image of archive log.

Thanks

[malte_schuenemann]

I understand this question the way that you want to save the logfiles that have been moved to the locations specified by LOGARCHMETH1 and LOGARCHMETH2. This task is up to you - once the database has archive the logfiles to these locations, they are out of the hands of DB2.

Further processing depends on you.

Options are e.g. tape, external storage system (e.g. TSM), ... As for TSM, you can configure logs to be archive directly to TSM as well (instead of first going to disk.

Malte

[Former Member]

Dear Thomas Matthae

I config LOGARCHMETH1 on local disk

First log archive method (LOGARCHMETH1) = DISK:J:\LOGARCHMETH1\ DISK:J:\LOGARCHMETH1\

Options for logarchmeth1 (LOGARCHOPT1) =

Second log archive method (LOGARCHMETH2) = DISK:K:\LOGARCHMETH2\ DISK:K:\LOGARCHMETH2\

Now I need to only backup archive log to disk

Thanks

[malte_schuenemann]

You should be able to archive logs using

db2 archive logs for database <dbname>

The logfiles will be put (archived) to the two disk locations you configured.

[malte_schuenemann]

sorry - the command is

db2 archive log for database <dbname>

[Thomas_Matthä]

Hi,

when you have DB2 9.1, you should use the new DB2 built in archiving

method. Your logfiles are automatically moved to the location specified

in the LOGARCHMETH1 database configuration parameter.

A usual way to do this log archiving is to use Tivoli storage manager.

Then you can configure DB2 to automatically store the log files in TSM.

Another possibility, but not that simple and convenient is archiving to

a local directory on disk.

Can you tell us the value of your db cfg parameter LOGARCHMETH1 ?

kind regards

Thomas

[Former Member]

Dear Malte Schuenema

This is information of parameter db2level and archivelog

DB21085I Instance "DB2TST" uses "64" bits and DB2 code release "SQL09014" with

level identifier "01050107".

Informational tokens are "DB2 v9.1.400.2873", "SAP_19276", "WR21398_19276", and

Fix Pack "4".

Product is installed at "F:\db2\db2tst\db2_software\" with DB2 Copy Name

"SAPDB2TST".

Thanks

[malte_schuenemann]

Unfortunately, I do not know how your database is configured.

o what is your current version / Fix Pack level of DB2 (output of db2level) ?

o what is your current configuration for log archival (contents of DB CFG)

If everything is configured correctly, you can archive a logfile using

db2 archive log ...

see http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0004476.htm

If this does not help, please provide above information.

Malte