473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
5 1686
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: geo | last post by:
hi, we have a problem with the db2uext2.exe under W2000 SP4 and DB2 V8 FP 4a. We copy the sample db2uext.cdisk to db2uext.c, compiled it with Microsoft Visual C++ Toolkit 2003 without errors....
0
by: Norm Wong | last post by:
If anyone is interested in using db2uext2 with Cygwin gcc compiler on Windows, I've modified the IBM provided sample with the attached file. There are two main modifications. The mkdir command...
1
by: richardshen | last post by:
Hi, anybody has an example to combine db2uext2.cdisk & db2uext2.ctsm together, so that db2 log can be keeped into hard drive & tsm? Thanks
1
by: Kevin | last post by:
Hello - Quick question - does anyone know of a good way to archive a blob? Some background - Our application (Java Web Application) uses a DB2 table with a blob column of length 75000 to store...
2
by: Peter | last post by:
Hi, I was trying to do the following: update db cfg for oltprd using VENDOROPT "'-SErvername=aixstl20'" update db cfg for oltprd using LOGARCHMETH1 TSM update db cfg for oltprd using...
4
by: Paul H | last post by:
Could some one give me some pointers on basic archiving techniques? I have developed several databases but never been faced with this issue. Here is the basic scenario.. Suppose I have the...
4
by: Gladiator | last post by:
hai everyone ... can anyone tell me how to compile db2uext2.cdisk file inorder to make use of it.......... Pls send me the link frm where i can download the compiler if any.......... ...
1
by: Akaketwa | last post by:
Guys may yu assist me am stuck. Am using v8.1 db2 database on Suse Linux running on an IBM pSeries server. I am aware of the backup utility in db2. I would like to back up the my db2 database to a...
3
bvdet
by: bvdet | last post by:
Following is an example that may provide a solution to you: """ Function makeArchive is a wrapper for the Python class zipfile.ZipFile 'fileList' is a list of file names - full path each name...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.