ape reclamation processes to
> make
> tape drives available for the retrieve operations. I got a response from
> Michael
> Garnebode explaining that the fix was to put "exclude logs" in the
> configuration
> files for DB2 backups. When I asked our DBAs to do this I found out
working.
Have you got a test environment you can use to convince your DBA's?
Cheers
Date: Wed, 23 Feb 2011 14:16:04 -0500
From: thomas.den...@jeffersonhospital.org
Subject: Including logs in DB2 backups
To: ADSM-L@VM.MARIST.EDU
Some months ago I reported that some of the DB2 serv
TSM are working.
Have you got a test environment you can use to convince your DBA's?
Cheers
> Date: Wed, 23 Feb 2011 14:16:04 -0500
> From: thomas.den...@jeffersonhospital.org
> Subject: Including logs in DB2 backups
> To: ADSM-L@VM.MARIST.EDU
>
> Some months ago I report
operations. I got a response from Michael
Garnebode explaining that the fix was to put "exclude logs" in the configuration
files for DB2 backups. When I asked our DBAs to do this I found out that
including
the logs in DB2 backups was a deliberate choice which they were very reluctant
to
give
Manager"
We have about a dozen TSM client systems with DB2 running under
x86 Linux. These systems use the TSM API interface built into DB2
to back up the DB2 databases. We always use separate node names
for DB2 backups and ordinary file backups. A
We have about a dozen TSM client systems with DB2 running under
x86 Linux. These systems use the TSM API interface built into DB2
to back up the DB2 databases. We always use separate node names
for DB2 backups and ordinary file backups. About half of the DB2
servers are using the 5.5.1.0 level of
lf Of
Lori Grimaldi
Sent: 03 December 2008 03:15 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Error running DB2 backups using TSM
I am trying to run DB2 backups using TSM and I am seeing this in the
db2diag.log:
2008-12-02-15.12.28.668662-300 E115842488A361 LEVEL: Error
PID : 23938
I am trying to run DB2 backups using TSM and I am seeing this in the
db2diag.log:
2008-12-02-15.12.28.668662-300 E115842488A361 LEVEL: Error
PID : 23938TID : 2199156889936PROC : db2vend
(db2logmgr.meth1 - 43 (P
"/db/db2inst1/db2dump/db2diag.log" 2093516L,
ckup logs for $db --"
>> $result
mail -s "Backup $db on $host Complete" [EMAIL PROTECTED]
< $result
echo "Backup $db on $host Complete"
else
mail -s "Backup $db on $host F
EMAIL PROTECTED] On Behalf Of
Gustavo Olivera
Sent: Thursday, November 30, 2006 12:12 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DB2 backups
Hi,
You can use the following statement from a DB2 CLP, a Command Editor,
the
Task Center or any tool:
backup database DBNAME use tsm
In order to verify
Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gustavo Olivera
Sent: Thursday, November 30, 2006 12:12 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DB2 backups
Hi,
You can use the following statement from a DB2 CLP, a Command Editor,
the
Task Center or any tool:
backup database DBNAME use
Hi,
You can use the following statement from a DB2 CLP, a Command Editor, the
Task Center or any tool:
backup database DBNAME use tsm
In order to verify the backups you can use the db2adutl utility, and can
check the syntax by typing only db2adutl from a DB2 CLP, but the first
statement that yo
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] DB2 backups
Can someone help with understanding how db2 works with the api client.
I am new to TSM and I am trying to understand how I backup the DB with
the API client.
I understand that I install the API and Configure the API. I register
the node and
Can someone help with understanding how db2 works with the api client.
I am new to TSM and I am trying to understand how I backup the DB with
the API client.
I understand that I install the API and Configure the API. I register
the node and associate it with a schedule. But how to you backup th
|
|Kopie:
|
|
Hello,
Soon , we will be backing Db2 databases, using TSM API , and I will need a
backup strategy.
We currently backup Lotus Notes Domino where we do a full Domino
(databases)
backup once a week, and incremental rest of the week.
We also backup /archiveTransaction logs every 2 hours.
Does a
Depending on your disk pool media, it is almost always faster to send a DB
backup to tape because of the size and single-threadedness of most DB
backups. All our MS-SQL and DB2 backups are in a class that forces direct to
tape and they tend to be 400-800% faster than diskpool would be for the same
Keep in mind, this system has been working flawlessly for at least two
years, which is why we don't touch it. We have enough headaches, we don't
need to create our own. :-)
At the time we noticed this problem we were doing tests before putting
this machine into production, a backup test is standa
: Re: Slow DB2 backups and IBM says I'm too old for support.
Check your network interfaces especially if they are set to autonegoiate.
-Original Message-
From: Richard Sims [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 1:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Slo
Check your network interfaces especially if they are set to autonegoiate.
-Original Message-
From: Richard Sims [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 1:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Slow DB2 backups and IBM says I'm too old for support.
>We h
>We have what appeared to be a simple problem, we installed a new DB2
>server and the backups (API) are slow, like 27 hours to backup a 100GB
>database. We have been backing up this database for years from a
>different server in less than two hours. The main difference between the
>two servers?
eff Rogers [mailto:[EMAIL PROTECTED]
Sent: 19 November 2003 04:31
To: [EMAIL PROTECTED]
Subject: Slow DB2 backups and IBM says I'm too old for support.
We have what appeared to be a simple problem, we installed a new DB2
server and the backups (API) are slow, like 27 hours to backup a 100GB
dat
We have what appeared to be a simple problem, we installed a new DB2
server and the backups (API) are slow, like 27 hours to backup a 100GB
database. We have been backing up this database for years from a
different server in less than two hours. The main difference between the
two servers? The A
-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backups with multiple DB's on one host
=> On Mon, 17 Nov 2003 09:35:50 -0500, Bill Boyer <[EMAIL PROTECTED]>
said:
&
=> On Mon, 17 Nov 2003 09:35:50 -0500, Bill Boyer <[EMAIL PROTECTED]> said:
> What I did to backup a DB2 server on AIX that had 4 instances:
[1. 2. ...] Dang, I was just going to say that.
We've got some 70 instances on two system images, in support of our PeopleSoft
installation, so we do this
--Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Zlatko Krastev
Sent: Monday, November 17, 2003 9:00 AM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backups with multiple DB's on one host
Looking at DB2 Administration Guide:
"Tivoli Storage Manager Node Nam
t; <[EMAIL PROTECTED]>
14.11.2003 02:05
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:DB2 backups with multiple DB's on one host
I have a customer who has two DB2 databases on one server and I
need to
I have a customer who has two DB2 databases on one server and I need to back
them up with TSM. Is it possible to do this with two separate node names to keep them
apart? If so, how would I do this? Since you have to define 3 environment variables
specific to DB2 for TSM and one of the
IL PROTECTED] 18/02/2003 9:19:57 >>>
Dear All,
Can anyone advise on a workable strategy for taking DB2 backups which would
be treated effectively as 'archives' ie kept for the long term.
The requirement is to take an occasional DB2 backup (online if possible)
and to keep this bac
Dear All,
Can anyone advise on a workable strategy for taking DB2 backups which would
be treated effectively as 'archives' ie kept for the long term.
The requirement is to take an occasional DB2 backup (online if possible)
and to keep this backup offsite for the long term. The DB2 ba
Hi all ,
İ have a problem with db2 backups.Last 2 days im receiving ANR0102E asalloc.c(5006):
Error 1
inserting row in table
"AS.Segments". at the end of db2 backups.I can't see them with db2adutl query
command but
db2 list history command tell me that they are successful. The meaning of ANR01
On Mon, 2002-11-18 at 19:26, Muthyam Reddy wrote:
> We have recently migrated our database to DB2 from Infromix on AIX 4.3 and TSM
>version level 5.1.0.0.
> Before migration.. Informix database use to take 7 -8 hrs for 400Gb database(RAW
>filesystems).Now same size of Database on DB2(raw filesyst
it done in 8.
All I want for xmas is a NEW TSM server. :)
--- Muthyam Reddy <[EMAIL PROTECTED]> wrote:
> ** High Priority **
>
> Hello...one and all
> subject:Slow DB2 backups on TSM.
>
> We have recently migrated our database to DB2 from Infromix on AIX 4.3 and TSM
** High Priority **
Hello...one and all
subject:Slow DB2 backups on TSM.
We have recently migrated our database to DB2 from Infromix on AIX 4.3 and TSM version
level 5.1.0.0.
Before migration.. Informix database use to take 7 -8 hrs for 400Gb database(RAW
filesystems).Now same size of Database
]
Sent: Monday, November 11, 2002 9:32 PM
To: [EMAIL PROTECTED]
Subject: DB2 Backups on Solaris 8 Wrong documentation?
According to the Backing up DB2 PDF for backing up DB2 on Solaris, on page
92 step 2 it says:
2. The /etc/system must have, as a minimum, the following values. Modify
them as
According to the Backing up DB2 PDF for backing up DB2 on Solaris, on page
92 step 2 it says:
2. The /etc/system must have, as a minimum, the following values. Modify
them as necessary, then reboot.
set lwp_default_stksize = 0x4000
set rpcmod:svc_run_stksize = 0x4000
set semsys:seminfo_semmap = 50
Hi dear colleagues,
We have a problem when two db2 64 bit databases are installed onto the same
machine, and they both run a offline or online backup "at the same time".
We get the following error reported by TSM
Starting DB2 backup with /db2/scripts/full_off_back.sh
SQL2025N An I/O error "157
I have an NT box running DB2 V6. We want to starting using the DB2 BAKCUP DB
commands, and we've been reading the redbook "Backing up DB2 using TSM".
It's all working, including the DB2ADUTL DELETE following the successfull
backups. What we're trying to figure out is the include/exclude statements
Moin Matt,
if you like to schedule the deleting of TDP Backups, use the command line
interface of TDPEXCH and the parameter
autodelete:n, where n are the number of days, you like to save. RTFM...
Mit freundlichen Gruessen - Yours sincerely
Volker Reinen
System Engineering
GE CompuNet Essen
Seve
Open System Storage Analyst
Royal Bank of Canada
315 Front St West
Toronto, On, M5V 3A4
416-348-3849
email: [EMAIL PROTECTED]
-Original Message-
From: Eduardo Martinez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 6:39 PM
To: [EMAIL PROTECTED]
Subject: Expiring DB2 backups
> Hello all,
> I am having a similar looking problem but it involves
MS-Exchange.
> I do not handle that client. But it sure would help if I can tell the NT
> administrators were to look to fix this problem. Right now it looks like
> the MS-EXCHANGE backups stay forever with a date/time s
D]]
> Sent: Wednesday, August 15, 2001 1:55 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Expiring DB2 backups/what about ms-exchange?
>
> Hello all,
> I am having a similar looking problem but it involves MS-Exchange.
> I do not handle that client. But it sure would
file name
and therefore stay ACTIVE.
Matt
-Original Message-
From: Gyula Bereczky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 8:35 PM
To: [EMAIL PROTECTED]
Subject: Re: Expiring DB2 backups
On Wed, Aug 15, 2001 at 12:39:06AM +0200, Eduardo Martinez wrote:
> As you know, w
On Wed, Aug 15, 2001 at 12:39:06AM +0200, Eduardo Martinez wrote:
> As you know, when you backup DB2 it stamps an unique id to its backup,
> making it an active version forever, then you can't expire that backup.
> Does anyone know how to expire this kind of backups?
Use db2adutl's delete command
Hi *SMers.
As you know, when you backup DB2 it stamps an unique id to its backup,
making it an active version forever, then you can't expire that backup.
Does anyone know how to expire this kind of backups?
Thanks in advance.
=
"Do or Do Not, there is no try"
-Yoda. The Empire Strikes Back
0. (We have a mgmt class set up for the DB2 backups and logs). If you
archive your logs to ADSM, then you will also have to use db2adutl to flag
them for deletion.
Glenn MacIntosh
Manager of Technical Services
Sobeys Inc.
123 Foord St.
Stellarton, Nova Scotia
(902) 752-8371 Ext. 4017
rete = 0
reto = 0
Also, this forces inactive copies to be deleted, so we don't keep 50 Gig
databases around that don't need to be.
-Matt
>Does anybody know why wouldn't db2 backups expire, when, in theory, they
>should be?
>We have an AIX-SP environment, with TSM
That will mark the DB2 backups inactive. Now the management class rules
will dictate how long you keep the files in TSM - if retain last is 90
days, you'll have the backups for 90 days.
My DB2 backups go to a special management class, which has the retain last
set to 0 days, so TSM will d
Peter logon to your aix system as user db2 or user who is owner the db2 backups
and then run command :
db2adutl query full
you will show list of your db2backups
then run command
db2adutl delete full older than XX days.
your db2 backups will not expire until you dont run this command
L PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: db2 backups not expiring
>Date: Tue, 3 Apr 2001 15:28:18 -0500
>
>All,
>Does anybody know why wouldn't db2 backups expire, when, in theory, they
>should be?
>We have an AIX-SP environment, with TSM 4.1, server and clients.
All,
Does anybody know why wouldn't db2 backups expire, when, in theory, they
should be?
We have an AIX-SP environment, with TSM 4.1, server and clients. DB2 data is
backed up via the TSM-API. The copygroup criteria for this data is: versions
exists=1; versions deleted=1; retain extra versi
Eric,
It is correct that the user exit does not get the currently active log. I'm
not sure that backing up the currently active log is useful. It may be in an
inconsistent state. This will result in the ROLLFORWARD DATABASE failing.
Which will require that you restore the database and rollforw
For a complete set of db2 online backup (v5.2 on AIX) image, should the log
currently active also be backup.
Someone told me the user exit will not pick up the log currently in use, is
it right?
As a result, our setup is to run 'db2 backup online use adsm' & 'dsmc
archive' the logs with copygroup
The logs are not picked up by the backup. The method of handling the logs, is
to compile C language the user exit program provided by DB2 to archive (not
backup) the log files.
"Collins, Brenda" wrote:
> Hi everyone,
>
> When you are backing up DB2, do the logs get picked up with the database
Hi everyone,
When you are backing up DB2, do the logs get picked up with the database
backup or are you catching them with filesystem backups? I have the
retention set for the logs to be the same as the backup, thinking that
retention was being taken care of through db2adutl by the DBA's. I am
55 matches
Mail list logo
