Currently we are backing up daily, DB2 using TSM 6 DB2 API client LAN-Free to
our TM 6 server/Virtual tape library.
Once a week I need to do a DB2 backup with a different retention. I am looking
for options to this solution.
Here are some I have come up with, I am looking for other options
r location
that someone randomly created.
-Rick
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel
Bos
Sent: Thursday, September 19, 2013 2:23 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DB2 backup defaults?
Hi,
DB2 backup re
Hi,
DB2 backup reads config settings only at start up. Cleaning the config
files after that wont change the running setup untill db2 gets restarted.
Either check time stamp of current config files or restart db2 and see
whats going to happen :) .
Kind regards,
Karel
Op 11 sep. 2013 15:47
1202 |
410.539.1135 (o)
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf
> Of Gopikrishna Muppidi
> Sent: Wednesday, September 11, 2013 9:20 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] DB2 backup defaults?
>
> Hello ,
&
Behalf
> > Of BEYERS Kurt
> > Sent: Wednesday, September 11, 2013 5:26 AM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: Re: [ADSM-L] DB2 backup defaults?
> >
> > Stephen,
> >
> > Have a look in ~/sqllib/userprofile where ~ is the home directory of the
>
Wednesday, September 11, 2013 5:26 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] DB2 backup defaults?
>
> Stephen,
>
> Have a look in ~/sqllib/userprofile where ~ is the home directory of the DB2
> instance owner.
>
> Regards,
> Kurt
>
> -
@VM.MARIST.EDU
Onderwerp: [ADSM-L] DB2 backup defaults?
All the doc for backing up DB2 with TSM says to set the DSMI* variables. But
what if they're not set? Do they default? I'm looking at a DB2 system that is
apparently backing up, but I don't see those variables set anywhere (even i
s are all blank); "set" and "env" never
show them, for root or the DB2 user. On top of that, the ERP piece seems to be
installed, but I don't see any profile or utl file that should be configured
for that.
Every night a cron job fires off a "db2 backup db using tsm&
Ruud,
Under the hood 'ba db ' does perform a 'db2 backup db ...', but with added
features like being able to restore the TSM database while TSM is unavailable
because the database needs to be restored. I can think of no good reason to not
use the supported and perfectl
ion (ba db
> dev= t=f), since version 6 one can make also a db2 backup of it
> (db2 backup db tsminst1 online use tsm).
>
> Does anybody knows if there are advantages of making db2 backups compared
> to TSM databas
All,
One can make TSM database backups within the TSM application (ba db
dev= t=f), since version 6 one can make also a db2 backup of it (db2
backup db tsminst1 online use tsm).
Does anybody knows if there are advantages of making db2 backups compared to
TSM database backups?
Kind Regards
ntory". Both are necessary to remove
all pieces of the db2 backup. Perhaps for this database you run the DB2
command AFTER the TSM one. This would allow a not so short period of time
where you are able to display these "expire immediate" objects.
>
> Date: Sun, 7 Oct 2007
Perhaps it's a timing issue. For DB2 you have to issue "db2adutl delete
older than x days without prompting" otherwise DB2 will keep backups
forever. In TSM you run "expire inventory". Both are necessary to remove
all pieces of the db2 backup. Perhaps for this databas
Thanks Richard,
Yes, I am running expire inventory daily. And I don't see anything in the
activity log that would indicate that the expiration is not working.
DESCRIPTION: Daily Script to run Expiration process to remove expired data
COMMAND: expire inventory wait=no
PRIORIT
On Oct 6, 2007, at 7:30 AM, Daad Ali wrote:
...
1- Is there a way of restoring these database backups?
If it's expired, it's beyond your retrieval capability: the only
recourse is to restore your TSM system to some time in the past,
which is unpalatable, if even possible to the point you may
Hello TSMers,
When I run the command "show version intelsrv30db2 * " in TSM.
I get the following output.
/SESSNA : \NODE\ FULL_BACKUP.20060128210004.1 (MC: DEFAULT)
Inactive, Inserted 01/28/06 21:00:04, Deactivated ** EXPIRE IMMEDIATELY
**
ObjId: 0.2643630069, GroupMap , o
: [ADSM-L] DB2 Backup on tsm error.
On Apr 1, 2007, at 8:32 AM, Murugan_Pachamallayan wrote:
> Now all the configurations are done. Then i try to backup, one
> more error code is coming
>
> db2 backup db sample use tsm
> SQL2062N An Error occurred while accessing media
> &quo
Hi Richard,
Very Good morning.. i have read this support document about db2 backup ..
I have update the same...
1. Update db cfg for using TSM_OWNER NULL
2. Update db cfg for using TSM_NODENAME NULL
3. Update db cfg for using TSM_PASSWORD NULL
dbname : entis
TSM_OWNER=admin
TSM_NODENAME
On Apr 1, 2007, at 8:32 AM, Murugan_Pachamallayan wrote:
Now all the configurations are done. Then i try to backup, one
more error code is coming
db2 backup db sample use tsm
SQL2062N An Error occurred while accessing media
"/home/db2inst1/sqllib/libtsm.a". Reason Code: "2032&q
Hi Richard ,
Thank you for your support.. I have followed "Backing up
DB2 on AIX using Tivoli Storage Manager" redbook.
Now all the configurations are done. Then i try to backup, one more error code
is coming
db2 backup db sample use tsm
SQL2062N An Error occurred while acces
On Mar 31, 2007, at 11:42 PM, Murugan_Pachamallayan wrote:
DSMI_DIR=/usr/tivoli/tsm/client/api/
Hello, Murugan -
One issue that stands out to me is the above DSMI_DIR being used:
it needs to point to the directory where your dsmtca and dsm.sys are
located, which conventionally should be one o
Hi Dinesh and Richard,
Thanks for your support, I successfully update the password. But still I have
db2 backup db sample use tsm
SQL2062N An Error occurred while accessing media
"/home/db2inst1/sqllib/libtsm.a". Reason Code: "168".
Please find the my dsm.opt f
server.
Hope this helps.
Dinesh Pahari
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Murugan_Pachamallayan
Sent: Sunday, 1 April 2007 12:58 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] DB2 Backup on tsm error.
Hi ,
Doing the db2 backup, i got
On Mar 31, 2007, at 10:58 AM, Murugan_Pachamallayan wrote:
Hi ,
Doing the db2 backup, i got the following error message..
db2 backup db sample use tsm
SQL2062N An Error occurred while accessing media
"/home/db2inst1/sqllib/libtsm.a". Reason Code: "168".
./dsmapipw
Enter y
Hi ,
Doing the db2 backup, i got the following error message..
db2 backup db sample use tsm
SQL2062N An Error occurred while accessing media
"/home/db2inst1/sqllib/libtsm.a". Reason Code: "168".
./dsmapipw
Enter your current password: admin123
Enter your new password:adm
Hi all,
When I enter the following command I get an error message :-
C:\>db2adutl query logs db icmnlsdb
Query for database ICMNLSDB
Retrieving LOG ARCHIVE information.
Error: Unable to increase the fileIdentList structure to 396242000
bytes.
What does the error mean ? and how do I fix it !
Thank
Hi all,
When I enter the following command I get an error message :-
C:\>db2adutl query logs db icmnlsdb
Query for database ICMNLSDB
Retrieving LOG ARCHIVE information.
Error: Unable to increase the fileIdentList structure to 396242000
bytes.
What does the error mean ? and how do I fix it !
Thank
Thanks Richard, that's a great help.
And you are right, we work between xmas and new year to troubleshoot with
obscure codes! :-) Fun indeed.
Regards
Farren
--
The information contained in this e-mail and any subsequent
correspo
look as
follows :-
The task ADMINISTRATOR.Backup_RMDB_Full with status Not successful
ran on
the DB2 Administrative Server on and completed with
return code -1371. The task started on at
2006-12-27
23:00:19.0 and completed at 2006-12-27 23:00:30.0. The task lasted 11
seconds.
Hi, Farren -
In DB2
Hi
Well I have just been doing some work with the sys admin for the server in
question and it looks like there was a server related issue on the 19th (no
idea what) and for some reason all but one of the dbs was still in a
quiesced state. Very odd and slightly worrying but TSM is not at fault here
Farren,
The return codes from a DB2 backup are those from the TSM API as the backup is
done across the API. However the return code -1371 is not listed in there.
Take a manual backup from the CLI, it looks to be a DOS prompt in your case:
"db2 backup db online use tsm include logs"
TSM Server 5.2.7.2 on Solaris 2.9 - TSM Client API 5.3.4.0 on Windows 2003
Hi all, and a merry xmas/new year etc :-)
I am wondering if anyone can point me in the direction of error code
meanings for our DB2 backups. The errors we are getting look as follows :-
The task ADMINISTRATOR.Backup_RMDB_
n to the active user?
Good Luck.
Gr. Ilja
-Oorspronkelijk bericht-
Van: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Namens Nancy
L Backhaus
Verzonden: dinsdag 11 juli 2006 20:14
Aan: ADSM-L@VM.MARIST.EDU
Onderwerp: oddevaix:/home/archive>db2 backup db archive online use tsm
rd on the TSM Server, then regenerated the
password file with db2 command dsmapipw again.
ERROR:
DB2Node :/home/archive>db2 backup db archive online use tsm
SQL2062N An error occurred while accessing media
"/home/archive/sqllib/adsm/libtsm.a". Reason code: "137".
>> On Tue, 24 Jan 2006 15:22:45 +0100, Brian Ipsen <[EMAIL PROTECTED]> said:
> Digging through the documentation from Tivoli gave me a clue -
> somehow, DB2 want to put logs in the archive copy group of the
> default management class in the domain, where the node is
> registered. I wonder why it i
Hi,
Digging through the documentation from Tivoli gave me a clue - somehow,
DB2 want to put logs in the archive copy group of the default management
class in the domain, where the node is registered. I wonder why it isn't
possible to assign a management class to the logs...
Wierd - but anyway, i
>> On Tue, 24 Jan 2006 13:58:59 +0100, Brian Ipsen <[EMAIL PROTECTED]> said:
> Hi,
> I've got an issue with a DB2 database running backup towards a TSM
> > server... for some wierd reason, it keeps
> dropping/re-establishing the > connection towards the server... >
> The activity log on the
Hi,
I've got an issue with a DB2 database running backup towards a TSM
server... for some wierd reason, it keeps dropping/re-establishing the
connection towards the server...
The activity log on the server says:
01/24/06 12:57:21 ANR0406I Session 196229 started for node NODENAME
To my fellow TSm.rs out there.
I am trying to run the tsm back up on db2 ver8.
TSM client 5.2 and I am gettign the following error
Can anybody please bail me out of this .
I have tried to figure this out. It is working fine on my other systems
Regards
Paul Giglio
EMI CAp music
1212-408-8311
Para
also i have started to hear about ESS where i'll have to take flashcopy into
consideration and Server free backupss hhh !!!
Will be bugging you guys on this too later .. i wish after 1 week or so !! and not
earlier !
Sandra !
Sandra wrote:
> yes you ar
yes you are right !! and not only that .. but also Lotus .. just about to post one
question on the policy .. i am confusd in policy for retention.
Right now .. i want to just take backups of the backups taken by their application.
LAter on i will automate using TSM.
Can anyone kindly give me th
Sandra,
You really have jumped in at the deep end haven't you? DB2, Oracle, offsite all at
once.
There is no need to shy away from DB2. Its interface is reasonably straightforward,
and there is a redbook to tell you exactly how to set it up.
http://publib-b.boulder.ibm.com/abstracts/sg246247.
Dear All,
Since we don't have any DB2 Administrator therefore I am not going into taking
online backups of DB2. The application that is using DB2 taking DB2 backups by
first shutting doen the database and then taking backups using DB2 commands and
then starting the database. They keep this backedup
]
Sent: Monday, April 19, 2004 9:14 AM
To: [EMAIL PROTECTED]
Subject: checkout DB2 backup [Virus checked]
Hi *,
we want to check out a DB2-backup. We backup our DB2-DB over the DB2-api in
the TSM. The data are stored in a 3494 library. Now we want to move the
tapes in a other location (out of the
cc
Subject
19.04.2004 16:14 checkout DB2
Hi *,
we want to check out a DB2-backup. We backup our DB2-DB over the DB2-api in
the TSM. The data are stored in a 3494 library. Now we want to move the
tapes in a other location (out of the library, for example a safe).
What is the best way to move the data out of the library???
Best regards
al Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Paul Genest
Sent: Tuesday, March 16, 2004 1:04 PM
To: [EMAIL PROTECTED]
Subject: DB2 backup environment variables
I am trying to set up a DB2 backup using TSM. My test instance is db2inst1.
AIX 5.2
DB@ 8.1
TSM Client 5.2
I am trying to set up a DB2 backup using TSM. My test instance is db2inst1.
AIX 5.2
DB@ 8.1
TSM Client 5.2.2
TSM api 5.2.2
All are the 64 bit versions.
The following variables were set in the .profile of user db2inst1:
export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
export DSMI_CONFIG=/home
ate or
not.
-Original Message-
From: Nicolas Launay [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 1:08 AM
To: [EMAIL PROTECTED]
Subject: DB2 backup
Hi,
I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2).
When I launch my backup (db2 backup db DBNAME use TSM)
|
| cc :
: www.fpt.com.vn
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Crawford, Lindy
Sent: 11 tháng ba 2004 6:22 CH
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup
Are you using db2 with SAP R3 ?
-Original Message-
From: Nicolas Launay [mailto
Are you using db2 with SAP R3 ?
-Original Message-
From: Nicolas Launay [mailto:[EMAIL PROTECTED]
Sent: 11 March 2004 12:08 PM
To: [EMAIL PROTECTED]
Subject: DB2 backup
Hi,
I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2).
When I launch my backup (db2 back
information that is privileged and
confidential.
-Original Message-
From: Nicolas Launay [mailto:[EMAIL PROTECTED]
Sent: Thursday,11. March 2004 11:08
To: [EMAIL PROTECTED]
Subject: DB2 backup
Hi,
I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2).
When I launch
Hi,
I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2).
When I launch my backup (db2 backup db DBNAME use TSM), the following
message appears.
SQL2062N An error occured while accessing media "D:
\Progra~1\SQLLIB\bin\db2tadsm.dll" Reason code:"2041".
I
D]
Subject: Re: DB2 backup
Can anyone have link to understand backup DB2 using TSM?
I need to know how to backup logs using api, if it is possible?
Regards,
Rosa Leung
Integrated Storage Management Services
IBM Global Services - SDC North/Central
Tel: 416-490-5151, Fax: 416-4
Can anyone have link to understand backup DB2 using TSM?
I need to know how to backup logs using api, if it is possible?
Regards,
Rosa Leung
Integrated Storage Management Services
IBM Global Services - SDC North/Central
Tel: 416-490-5151, Fax: 416-490-5283
E-Mail: [EMAIL PROTECTED]
_
Hello,
our environment:
tsm server 5.1.1.6
tsm client 5.1.5.9
db2 version 7 , fixpack 8
api 5.1.5.9
we have some problems with implementing db2 on ms cluster in case of
failover.
First, we do not have only failover cluster, both cluster nodes have
production db2 db's, some are cluster ressourc
Hi everybody.
I'm having a problem running a DB2 LAN-free backup : normally it takes 40
minutes to save about 65 GB, but sometimes it takes more than 1 hour.
My TSM server is 4.2.1.11 (Win2K), my storage agent is 4.2.1.11 (AIX 4.3.3.
ML9).
The funny thing is that the problem disappears when I resta
On Wed, Jan 22, 2003 at 12:20:05PM +0100, Lars Bebensee wrote:
> The only hint I was able to find was in DB2's diag logs:
>
> 2003-01-19-18.02.51.509653 Instance:db2minst Node:001
> PID:51956(db2agent (DB2MPROD) 1) Appid:*N1.db2minst.030119170156
> database_utilities sqlubcka Probe:20 Da
Hi guys and girls,
we are running weekly offline backups of a DB2 database ver 7.1.0.65 EEE on
AIX. The server is a NSM at 4.1.6.0 and the clients at 3.7.2.0. The last
backup failed on one of the nodes showing lots of these entries in the
dsmerror.log:
sessInit: Starting communications initializa
r. Systems Programmer
USAA
210-913-9836
-Original Message-
From: Daniel Sparrman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 6:26 AM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX
Hi
DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin
>... is any redbook or documentation about backing up DB2 database with TSM
http://www.redbooks.ibm.com/ has a search capability, where you can enter
things like "db2 backup" and it will reveal the Redbooks and Redpieces
which contain such information.
Richard Sims, BU
Many many thanks Davide.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Davide Giacomazzi
Sent: Wednesday, December 11, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: R: DB2 backup on AIX
Hi Tom`s, you can find a redbook concerning db2 backup using
Tomas Hrouda
<[EMAIL PROTECTED]> To: [EMAIL PROTECTED]
Sent by: "ADSM: cc:
Dist StorSubject: Re: DB2 backup on AIX
Manager"
&
Hi Tomàs, you can find a redbook concerning db2 backup using tsm to the
following link :
http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65
f/ca11be93f3ae47b2852569f800819a82?OpenDocument
Best regards
Davide Giacomazzi
Information Technology - TSM manager
Tel. (+39
ssage-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Daniel Sparrman
Sent: Wednesday, December 11, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX
Hi
DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin.
It also explains how to do
Hi
DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin.
It also explains how to do it in "Backing up databases with Tivoli Storage
Manager"
Best Regards
Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervägen 6B
183 62 HÄGER
Hi all,
one of our customers wants to backup DB2 database on AIX system. I didn't
find any TSM or TDP product to use it for online backup of DB2, but I want
to be sure. Is any way to do it (except of file backup of stoped databse
using basic AIX TSM client)? Do anybody have any experience with bac
Hi guys and girls,
hope there is some kind of DB2 guru reading in this list. When doing a DB2
backup we are getting the following messages in the appropriate DB2 diag
log:
2002-12-08-18.00.35.226529 Instance:db2minst Node:001
PID:90534(db2agent (DB2MPROD) 1) Appid:C0A80196.046F
when
> that instance was started. If using the steps in the Backing up DB2 using
> TSM redbook, then the DSMI_* variables are set in the
> ~HOME/sqllib/userprofile script. The "DB2 BACKUP DB ...USE TSM" command is
> internal to the instance and uses those values. Not th
In Unix, my testing has shown that the DB2 instance uses the values set when
that instance was started. If using the steps in the Backing up DB2 using
TSM redbook, then the DSMI_* variables are set in the
~HOME/sqllib/userprofile script. The "DB2 BACKUP DB ...USE TSM" command is
inter
Hi Eduardo,
could you please provide the content of your dsm.opt and dsm.sys? Also, are
you trying to backup your database with scheduler or by hand from command
line.
When you want backup one database with two different node names, you have
to have correct environment DSMI_CONFIG,(I assume yo
I want to backup DB2 trough ADSM.
I have defined 2 different nodes, and I want to backup a DB2 database
using both of them.
I have defined 2 different option files for each of them, and I also
have defined the DSMI_LOG, DSMI_CONFIG and DSMI_DIR environment
variables.
But when I launch the backup wi
\dsm.opt
and at db2 command promt isue "db2 backup db your_db online use adsm open (session
numbers)
sessions"
Mario Behring
cc: (bcc: MUSTAFA
BAYTAR/BILSIS/ANADOLU)
Sent by: "ADSM:
r"
To: [EMAIL PROTECTED]
cc:
Subject:DB2 backup
Gentlemen,
Does anyone know or have some reliable configuration steps for DB2 for
Windows NT online backup using the TSM client ?
My environment is this:
=> TSM Server 5.1.1.0 running on a Windows 2000 Server
t Stor Manager" <[EMAIL PROTECTED]>
> 17.10.2002 00:25
> Please respond to "ADSM: Dist Stor Manager"
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject:DB2 backup
>
>
> Gentlemen,
>
> Does anyone know or have so
Gentlemen,
Does anyone know or have some reliable configuration steps for DB2 for
Windows NT online backup using the TSM client ?
My environment is this:
=> TSM Server 5.1.1.0 running on a Windows 2000 Server machine
=> TSM Backup-Archive Client 4.1.2.14 running on a Windows NT Server 4.0
SP6a ma
one offline backup per week.
Bill Boyer
cc:
Sent by: "ADSM: Subject: Re: (Silly?) DB2 Backup
question
Dist Stor
Manager"
<[EM
alf Of
Levinson, Donald A.
Sent: Friday, September 20, 2002 1:40 PM
To: [EMAIL PROTECTED]
Subject: Re: (Silly?) DB2 Backup question
Log files are absolutely required if you are performing online backups.
A. the database has to be in logretain mode to allow an online backup
B. all transactions that
llows this) and log archives whenever a log is released, the log
archives have a 30 day retention. Or you could hack together a script to
backup the released logs and then delete them after the next successful
offline DB2 backup so that TSM marks them as deleted.
-Original Message-
From:
Hi guys and girls,
this question is one of the general sort, so forgive me if it has been
answered here or in some manual I haven't red yet. Probably, I just need a
simpler description.
AFAIK, there are three ways to backup a database:
1. Offline filesystem backup
2. Offline backup in the databas
DATE DATABASE CONFIGURATION command completed successfully.
DB21026I For most configuration parameters, all applications must
disconnect
from this database before the changes become effective.
db2 => backup db ds50 use tsm
Backup successful. The timestamp for this backup image is : 20020531
have no idea.
Hope this helps,
Bill
At 01:27 PM 5/31/2002 -0700, you wrote:
>I can't find this return code anywhere.. anyone know what this means?
>DB2 7.1 EE, TSM 4.2.2 server/client.. both boxes are solaris 2.8
>
>
>db2 => backup db ds50 online use tsm
>SQL2062N An erro
More info:
In USEREXIT.ERR:
Time of Error: Thu May 30 17:35:48 2002
Parameter Count: 9
Parameters Passed:
ADSM password: fastdb
Database name: DS50
Logfile name: S024.LOG
Logfile path:
pment Engineer
Zantaz, Inc.
925.598.3099 (w)
-Original Message-
From: Dave Canan [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 2:21 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup problem..
These return codes are documented in the dsmrc.h file, located in the
tsm\api\include directory
remove it.
At 01:27 PM 5/31/2002 -0700, you wrote:
>I can't find this return code anywhere.. anyone know what this means?
>DB2 7.1 EE, TSM 4.2.2 server/client.. both boxes are solaris 2.8
>
>
>db2 => backup db ds50 online use tsm
>SQL2062N An error occurred while acces
I can't find this return code anywhere.. anyone know what this means?
DB2 7.1 EE, TSM 4.2.2 server/client.. both boxes are solaris 2.8
db2 => backup db ds50 online use tsm
SQL2062N An error occurred while accessing media
"/opt/db2udb/sqllib/adsm/libadsm.a". Reason
eOut is
also one hour.
No session lasted more than about 30 minutes.
-Original Message-
From: Dave Canan [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2002 17:00
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup RC=157
Check to see if the activity log contains any error messages. I
have see
Check to see if the activity log contains any error messages. I
have seen these errors before when TSM is trying to mount a volume for the
DB2 backup that has been marked read-only. Also, what is your DB2 fixpack
level? Your TSM level?
At 04:43 PM 5/15/2002 +0100, you wrote:
>*SM
running fine and not prodg any errors.
When our DBAs run
db2=> backup db dbtest use TSM open 2 sessions
they get an error message in the DB2 logs:
SQL2025N An I/O error '157' occurred on media 'TSM'
In the API messages it merely states that the transaction will
Hi all,
we are using TSM Server 3.7.5 on OS/390
We have Clients on Solaris 2.6/7 with the Backup Client V3.7.2 and TDP for
Informix V4.1.2.0
We have even Clients on Win 2000 with the Backup Client V3.1.8 and DB2 V7.1
using the DB2 BACKUP Command with the Option USE TSM
In the Option Files we
How to extract a db2-backup > 64Gb
Hi,
To restore our db2-db to another RS6000 (without TSM) I want to
extract a DB2/TSM backup file from TSM to a filesystem,
compress it, send to the other machine and restore it. With a
backup to disk that works ok, because the db2 backup command
splits up
Hi,
To restore our db2-db to another RS6000 (without TSM) I want to
extract a DB2/TSM backup file from TSM to a filesystem,
compress it, send to the other machine and restore it. With a
backup to disk that works ok, because the db2 backup command
splits up the file in parts of 64GB (an AIX-limit
Hi,
I am not sure if TSM support DB2 version 5 and TSM API
version 4.2. In any case TSM 4.2 can work with API
4.1.3. Then you need to uninstall the api and install
the former version.
Fran
--- Zoltan Forray/AC/VCU <[EMAIL PROTECTED]> wrote:
> My AIX person wanted me to pass on the following
> er
My AIX person wanted me to pass on the following error messages. We
started getting these when we upgraded the client to 4.2.0 from 4.1.3
(this was done to resolve some other issue. Not sure what !).
Any one see this one or have a clue what to do ? Did not see anything in
the readme's about
I do manually backup on db2/6000 db whit command db2 backup db CITY use adsm.
I do inactive the backup copy whit the command db2adutl delete, but when I do expire
inventory the process doesn't cure of this and doesn't discard data on my Cassette.
Why
Davide Fanizzo
N
-2001
22:07 ---
Richard Bates
22-02-2001 00:02
To: [EMAIL PROTECTED]
cc:
From: Richard Bates/UK/IBM@ibmgb
Subject: db2 backup to tsm fails
This is a DB2/TSM backup question (and I have appended to those newsgroups
too). Someone out there must have got this working.
We
; starts a session with the
TSM server and returns no objects backed up (as expected).
I don't think there is anything else we have missed out.
When we start the "db2 backup db use tsm" command we
immediately get a Dr Watson message on db2syscs.exe. A backup session
does not start
Hi all,
I have acidentally deactivate all the db2 backup
versions, in db2adutl show no backup.. and in BACKUPS
table shows the deactivate time of all backup files are
not null.. Is any way to reactivate the db2 backup files? Thank you .. Jenny.
Hello all,
The DB2 and ESSBASE backups are initiated at the client. I can not find
a way of getting the same type of backup information (size, transfer rate)
that is easily available for JFS backups that are initiated by the TSM
scheduler. Does anyone know where this information can be obtai
1 - 100 of 102 matches
Mail list logo
