Also, make absolutely sure that the config file you located is the one DB2 is
using.
I had a similar situation on a system that many DBA's had administered one
several years and let's just say they got pretty creative.
In the end the DB2 processes was getting the parameters from another location
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 schree
I got nothing (see below). Yet, the backups are working somehow. I don't think
the DB2_VENDOR_LIB is relevant, since the end user is not using BACKOM.
> db2 get db cfg for pe1 | grep -i tsm
First log archive method (LOGARCHMETH1) = TSM
Second log archive method(L
Hello ,
For DB2 backups for any systems via TSM,the below mentioned environment
variables has to be define on the db2 level,then only backup to tsm will be
possible,see the below example.
:db2sap 10> db2 get db cfg for sap|grep -i tsm
First log archive method (LOGARCHMETH1) =
TSM
Thanks, Kurt. The file exists, but is empty. I ran "ps -ef | grep db2", found
the instance owner (and indeed, he's the one running the backups), and "su -"
to him, found the empty userprofile. TSM must be using defaults of some kind
STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
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
Verzonden: dinsdag 10 september 2013 23:53
Aan: ADSM-L@VM.MA
Hi Richard,
Thanks for your support. Now its working fine.. sorry for inconvenience..
Thanks of lots to you.
Thanks and Regards
Murugan
From: ADSM: Dist Stor Manager on behalf of Richard Sims
Sent: Sun 4/1/2007 7:04 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re:
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".
Don't be shy
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
"/
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 file and dsm.sys file
dsm
Hi Murugan,
Looking at the errors reported, this is most definitely a password or
username issue. Check your dsm.sys and dsm.opt file for username entered
there.
Secondly, update your new password from your TSM sever as well. (update
). Then try to change your password again
on the client server
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:
>> 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
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.
Get the redbook on "Backing up DB2 using TSM". I believe in there they
suggest that any changes be made to the file userprofile instead of the
.profile for the instance. You also need to stop and start the instance for
the changes to take effect.
Bill Boyer
DSS, Inc.
-Original Message-
Fr
One of the problems I have run into is the settings in the database
itself
TSM management class(TSM_MGMTCLASS) = DB2
TSM node name(TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (
|
| 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 backup db DBNAM
Hi Nicolas,
you might have to reinstall the APi code, but think about stopping DB2
during reinstallation,
yours
René LAMBELET
NESTEC SA
GLOBE - Global Business Excellence
Central Support Center
SD/ESN
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]
_
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
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
Verona
-Messaggio originale-
Da: Tomas Hrouda [mailto:[EMAIL PROTECTED]]
Inviato: mercoledl 11 dicembre 2002 13.45
A: [EMAIL PROTECTED]
Oggetto: Re: DB2 backup on AIX
Thanks Daniel,
I'll try to contact him (if any exists :-)). But I have one more question
... is any redbo
Tomas Hrouda
<[EMAIL PROTECTED]> To: [EMAIL PROTECTED]
Sent by: "ADSM: cc:
Dist Stor Subject: Re: DB2 backup on AIX
Manager"
&
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
; Bill Boyer
> DSS, Inc.
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Jozef Zatko
> Sent: Monday, November 18, 2002 2:59 AM
> To: [EMAIL PROTECTED]
> Subject: Re: DB2 Backup using different node names
>
>
Assuming Unix.
Bill Boyer
DSS, Inc.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Jozef Zatko
Sent: Monday, November 18, 2002 2:59 AM
To: [EMAIL PROTECTED]
Subject: Re: DB2 Backup using different node names
Hi Eduardo,
could you please provide the
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
Hi Mario ,
First define DSMI_DIR , DSMI_CONFIG as sistem environment parameters in NT client
for example : DSMI_DIR C:\Programfiles\tivoli\tsm\client\api\bin (this is your
TSM
installition api\bin directory)
DSMI_CONFIG
C:\Programfiles\tivoli\tsm\client\api\bin\
Redbook SG24-6247-00 "Backing Up DB2 Using Tivoli Storage Manager"
Zlatko Krastev
IT Consultant
Mario Behring <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
17.10.2002 00:25
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc
Thanks !!
--- Zlatko Krastev/ACIT <[EMAIL PROTECTED]> wrote:
> Redbook SG24-6247-00 "Backing Up DB2 Using Tivoli Storage Manager"
>
> Zlatko Krastev
> IT Consultant
>
>
>
>
>
>
> Mario Behring <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> 17.10.2002 00:25
> Please
31, 2002 2:32 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup problem..
Gerald,
The return codes for tsm products that use the api are in the
api folder, include folder, dsmrc.h file. TDPO and db2/udp use the
api. In this case rc=2032 means --
#define DSM_RC_NO_OWNER_REQD 2032 /* o
Gerald,
The return codes for tsm products that use the api are in the
api folder, include folder, dsmrc.h file. TDPO and db2/udp use the
api. In this case rc=2032 means --
#define DSM_RC_NO_OWNER_REQD 2032 /* owner not allowed. Allow default */
Exactly what to change to fix this? I hav
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
These return codes are documented in the dsmrc.h file, located in the
tsm\api\include directory. The return code here means:
#define DSM_RC_NO_OWNER_REQD 2032 /* owner not allowed.
Allow default */
Do you have an "owner" specified in the dsm.sys file stanza? You need to
remove it.
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:
>*SMers,
>
>
47 matches
Mail list logo
