Is db2uext2 archiving directly to tape?

pike

Hi

Single partition DB2v8.1 FP7 on AIX 5.2.

I'm trying to determine whether we're archiving logs directly to tape
(and not to disk) using TSM. Without knowing from which sample it was
compiled, is there an easy way to find out how db2uext2 is configured
in this regard?

Many thanks.

Bruce

Mar 29 '06 #1

m

pike wrote:

Hi

Single partition DB2v8.1 FP7 on AIX 5.2.

I'm trying to determine whether we're archiving logs directly to tape
(and not to disk) using TSM. Without knowing from which sample it was
compiled, is there an easy way to find out how db2uext2 is configured
in this regard?

Many thanks.

Bruce

There are at least two ways - that I can think of...

1. See if the ARCHIVE.LOG file exists - its location is dependant on
what chanes to source were made. It will show what log archiving history

2. Use dsmc (TSM utility) to see whats been copied to tape.

Mar 29 '06 #2

pike

Thanks m. The ARCHIVE.LOG shows that log files are being archived 'to
ADSM' and that the 'Media Type' is 'ADSM'. I'm just not sure whether
this means that the logs are being archived DIRECTLY to tape or disk.

Mar 29 '06 #3

m

pike wrote:

Thanks m. The ARCHIVE.LOG shows that log files are being archived 'to
ADSM' and that the 'Media Type' is 'ADSM'. I'm just not sure whether
this means that the logs are being archived DIRECTLY to tape or disk.

ADSM (TSM) is a whole backup/restore system unto itself. There is
usually a disk pool attached to ADSM that collects backup data and then
it rolls to tape based on a whole lot of ADSM configuration settings. If
you have questions about how your ADSM is set up - you'll need to talk
to the folks that maintain it. But, logically, your DB2 backups are
indeed going to 'tape'.

Mar 29 '06 #4

DJ

pike wrote:

Hi

Single partition DB2v8.1 FP7 on AIX 5.2.

I'm trying to determine whether we're archiving logs directly to tape
(and not to disk) using TSM. Without knowing from which sample it was
compiled, is there an easy way to find out how db2uext2 is configured
in this regard?

Many thanks.

Bruce

You need to talk to the folks that setup your TSM client on your AIX
system. The "exclude/include" list will show the management class your
backups are going to. That will tell you where the backups and logs are
ending up at.

Mar 30 '06 #5

pike

Thanks m and DJ. I shall ask the TSM admin bods for their help.

Mar 30 '06 #6