467,161 Members | 850 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

Is db2uext2 archiving directly to tape?

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
  • viewed: 1482
Share:
5 Replies
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
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
Thanks m and DJ. I shall ask the TSM admin bods for their help.

Mar 30 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Norm Wong | last post: by
1 post views Thread by richardshen@canada.com | last post: by
1 post views Thread by Kevin | last post: by
2 posts views Thread by Peter | last post: by
4 posts views Thread by Paul H | last post: by
4 posts views Thread by Gladiator | last post: by
1 post views Thread by Akaketwa | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.