ADMS-L - DB2 backup

2014-03-10 Thread Trimark, Jerry R
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

Re: DB2 backup defaults?

2013-09-19 Thread Karel Bos
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

Re: DB2 backup defaults?

2013-09-19 Thread Rick Adamson
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 reads config

Re: DB2 backup defaults?

2013-09-11 Thread BEYERS 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 in a DB2 GET DB

Re: DB2 backup defaults?

2013-09-11 Thread Stackwick, Stephen
-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 -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick

Re: DB2 backup defaults?

2013-09-11 Thread Gopikrishna Muppidi
: 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 -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick, Stephen

Re: DB2 backup defaults?

2013-09-11 Thread Stackwick, Stephen
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 , For DB2 backups for any systems via TSM,the below mentioned

DB2 backup defaults?

2013-09-10 Thread Stackwick, Stephen
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 and darned if it doesn't work. Am I missing something

TSM database backup versus db2 backup of TSM database

2012-11-06 Thread Meuleman, Ruud
All, One can make TSM database backups within the TSM application (ba db dev=devclass 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

Re: TSM database backup versus db2 backup of TSM database

2012-11-06 Thread Steven Langdale
dev=devclass 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, Ruud Meuleman

Re: TSM database backup versus db2 backup of TSM database

2012-11-06 Thread Remco Post
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 perfectly functional 'backup

Re: Deleted DB2 backup still in TSM

2007-10-09 Thread Ken Chamberlain
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 database you run the DB2 command

Re: Deleted DB2 backup still in TSM

2007-10-09 Thread Daad Ali
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 12:36:01 -0400 From: Daad Ali Subject: Re: Deleted DB2

Re: Deleted DB2 backup still in TSM

2007-10-07 Thread Daad Ali
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

Deleted DB2 backup still in TSM

2007-10-06 Thread Daad Ali
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 ,

Re: Deleted DB2 backup still in TSM

2007-10-06 Thread Richard Sims
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

Re: DB2 Backup on tsm error.

2007-04-02 Thread Murugan_Pachamallayan
: [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 /home/db2inst1/sqllib/libtsm.a

Re: DB2 Backup on tsm error.

2007-04-01 Thread Richard Sims
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

Re: DB2 Backup on tsm error.

2007-04-01 Thread Murugan_Pachamallayan
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 accessing media

Re: DB2 Backup on tsm error.

2007-04-01 Thread Richard Sims
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. Don't be shy

Re: DB2 Backup on tsm error.

2007-04-01 Thread Murugan_Pachamallayan
Hi Richard, Very Good morning.. i have read this support document about db2 backup .. I have update the same... 1. Update db cfg for dbname using TSM_OWNER NULL 2. Update db cfg for dbname using TSM_NODENAME NULL 3. Update db cfg for dbname using TSM_PASSWORD NULL dbname : entis TSM_OWNER

DB2 Backup on tsm error.

2007-03-31 Thread Murugan_Pachamallayan
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:admin123 Enter your new

Re: DB2 Backup on tsm error.

2007-03-31 Thread Richard Sims
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 your current password

Re: DB2 Backup on tsm error.

2007-03-31 Thread Pahari, Dinesh P
again on the client 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

Help required with TSM DB2 backup

2007-03-28 Thread Bill Dourado
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 !

Help required with TSM DB2 backup - UPDATE

2007-03-28 Thread Bill Dourado
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 !

TSM DB2 backup problems

2006-12-28 Thread Farren Minns
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

Re: TSM DB2 backup problems

2006-12-28 Thread BEYERS Kurt
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 DB_ALIAS online use tsm include logs

Re: TSM DB2 backup problems

2006-12-28 Thread Farren Minns
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

Re: TSM DB2 backup problems

2006-12-28 Thread Richard Sims
seconds. Hi, Farren - In DB2 backup cases where the backup has not gotten as far as using TSM, and the message is from DB2 itself, talking of a DB2-specific issue, I believe that the negative return code value is the SQLCODE value from the DB2 Administrative API, and the number itself has

Re: TSM DB2 backup problems

2006-12-28 Thread Farren Minns
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

DB2 backup - connection unstable ?

2006-01-24 Thread Brian Ipsen
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

Re: DB2 backup - connection unstable ?

2006-01-24 Thread Allen S. Rout
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 server

Re: DB2 backup - connection unstable ?

2006-01-24 Thread Brian Ipsen
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,

Re: DB2 backup - connection unstable ?

2006-01-24 Thread Allen S. Rout
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 isn't

Re: DB2 Backup offline on Winnt

2004-11-03 Thread Sandra
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

Re: DB2 Backup offline on Winnt

2004-11-03 Thread Sandra
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

Re: DB2 Backup offline on Winnt

2004-11-02 Thread Steve Harris
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.

DB2 Backup offline on Winnt

2004-11-01 Thread Sandra
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

Re: checkout DB2 backup [Virus checked]

2004-04-20 Thread Prather, Wanda
] 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

checkout DB2 backup [Virus checked]

2004-04-19 Thread Frank Mueller
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

Re: checkout DB2 backup [Virus checked]

2004-04-19 Thread MUSTAFA BAYTAR
Subject 19.04.2004 16:14checkout DB2 backup [Virus checked

DB2 backup environment variables

2004-03-16 Thread Paul Genest
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

Re: DB2 backup environment variables

2004-03-16 Thread Bill Boyer
- 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.2 TSM api

DB2 backup

2004-03-11 Thread Nicolas Launay
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 think that I've made all

Re: DB2 backup

2004-03-11 Thread Lambelet,Rene,VEVEY,GLOBE Center CSC
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 my backup (db2 backup db

Re: DB2 backup

2004-03-11 Thread Crawford, Lindy
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 backup db

Re: DB2 backup

2004-03-11 Thread Thanh Nguyen Duc
: www.fpt.com.vn -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Crawford, Lindy Sent: 11 thang 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:[EMAIL

Réf. : Re: DB2 backup

2004-03-11 Thread Nicolas Launay
: | | Objet : Re: DB2 backup | --| Are you

Re: DB2 backup

2004-02-17 Thread Rosa Leung
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]

Re: DB2 backup

2004-02-17 Thread French, Michael
: 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-490-5283 E-Mail: [EMAIL

micrsoft cluster and db2 backup problems

2003-06-25 Thread TSM
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

LAN-free DB2 backup : low performance

2003-03-13 Thread Davide Giacomazzi
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

DB2 backup problem

2003-01-22 Thread Lars Bebensee
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

Re: DB2 backup problem

2003-01-22 Thread Gyula Bereczky
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

Re: DB2 backup on AIX

2002-12-16 Thread Garrison, Tony
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. It also explains

DB2 backup on AIX

2002-12-11 Thread Tom Hrouda
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

Re: DB2 backup on AIX

2002-12-11 Thread Daniel Sparrman
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

Re: DB2 backup on AIX

2002-12-11 Thread Tomás Hrouda
- 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 it in Backing

R: DB2 backup on AIX

2002-12-11 Thread Davide Giacomazzi
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

Re: DB2 backup on AIX

2002-12-11 Thread Kolbeinn Josepsson
Tomas Hrouda [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: Re: DB2 backup on AIX Manager [EMAIL PROTECTED

Re: DB2 backup on AIX

2002-12-11 Thread Tomás Hrouda
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

Re: DB2 backup on AIX

2002-12-11 Thread Richard Sims
... 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

DB2 backup problem

2002-12-09 Thread Lars Bebensee
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

Re: DB2 Backup using different node names

2002-11-18 Thread Jozef Zatko
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

Re: DB2 Backup using different node names(MORE)

2002-11-18 Thread Zig Zag
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 the values you have specified in your script. You would have to move in a different DSM.OPT file referencing a different

DB2 Backup using different node names

2002-11-15 Thread Eduardo Martinez
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

Re: DB2 backup

2002-10-17 Thread MUSTAFA BAYTAR
\dsm.opt and at db2 command promt isue db2 backup db your_db online use adsm open (session numbers) sessions Mario Behring mariobehring@YA To: [EMAIL PROTECTED] HOO.COM cc: (bcc: MUSTAFA BAYTAR

DB2 backup

2002-10-16 Thread Mario Behring
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

Re: DB2 backup

2002-10-16 Thread Mario Behring
Stor Manager 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

Re: DB2 backup

2002-10-16 Thread Zlatko Krastev/ACIT
: 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 machine = TSM Backup-Archive Client 4.1.2.14 running

Re: (Silly?) DB2 Backup question

2002-09-21 Thread MUSTAFA BAYTAR
one offline backup per week. Bill Boyer bill.boyer@VERI To: [EMAIL PROTECTED] ZON.NET cc: Sent by: ADSM: Subject: Re: (Silly?) DB2 Backup question

(Silly?) DB2 Backup question

2002-09-20 Thread Lars Bebensee
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

Re: (Silly?) DB2 Backup question

2002-09-20 Thread Levinson, Donald A.
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: Lars

Re: (Silly?) DB2 Backup question

2002-09-20 Thread Bill Boyer
, 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 occur during

DB2 backup problem..

2002-05-31 Thread Gerald Wichmann
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 code: 2032. db2 = ? sql2062n

Re: DB2 backup problem..

2002-05-31 Thread Dave Canan
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 accessing media /opt/db2udb/sqllib/adsm/libadsm.a

Re: DB2 backup problem..

2002-05-31 Thread Gerald Wichmann
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

DB2 backup problem

2002-05-31 Thread Gerald Wichmann
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:

Re: DB2 backup problem..

2002-05-31 Thread Gerald Wichmann
. 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 : 20020531164955 db2 = Thus why it was gripping RC 2032 complaining about

Re: DB2 backup RC=157

2002-05-28 Thread Thomas, Matthew
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 seen these errors before when TSM

DB2 backup RC=157

2002-05-15 Thread Thomas, Matthew
is 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 be aborted: In dsmrc.h

Re: DB2 backup RC=157

2002-05-15 Thread Dave Canan
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: *SMers

Compression with DB2 Backup and TDP for Informix

2002-01-16 Thread Gerhard Wolkerstorfer
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

2001-11-27 Thread Bert Gringhuis
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

AIX DB2 backup problem with 4.2.0 client

2001-09-07 Thread Zoltan Forray/AC/VCU
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

Re: AIX DB2 backup problem with 4.2.0 client

2001-09-07 Thread Francisco Molero
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 error

Expire invetory doesn't work for DB2 backup set

2001-09-06 Thread Davide Fanizzo
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 Network

db2 backup to tsm fails

2001-02-22 Thread Richard Bates
-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

db2 backup to tsm fails

2001-02-21 Thread Richard Bates
ot; 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 dbname use tsm" command we immediately get a Dr Watson message on db2syscs.exe. A backup session does not start wi

what is the size and transfer rate of DB2 backup?

2001-01-03 Thread MC Matt Cooper (2838)
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

Re: inclexcl list for DB2 backup

2000-07-25 Thread Gyula Bereczky
On Tue, Jul 25, 2000 at 12:43:46PM +0800, Eric Tang wrote: I have config db2 backup by ADSM. In order to exclude db2 files from filesystem incremental backup, how can I get the list of directories/files to be coded in the exclude list. Eric, you did not mention the operating system etc. things