Re: DB2 backup defaults?

[Rick Adamson]

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 
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 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 schreef "Stackwick, Stephen" < 
stephen.stackw...@icfi.com> het volgende:

> 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(LOGARCHMETH2) = TSM
>  TSM management class(TSM_MGMTCLASS) =
>  TSM node name(TSM_NODENAME) =
>  TSM owner   (TSM_OWNER) =
>  TSM password (TSM_PASSWORD) =
>
> > env | grep -i dsm
> > env | grep -i tsm
> DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
> > set | grep -i dsm
> > set | grep -i tsm
> >
>
> STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | 
> stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt 
> Street Suite 2214, Baltimore, MD 21202 |
> 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 ,
> >
> > 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:DB2_STD_ARCHIVE1
> >  Second log archive method(LOGARCHMETH2) =
> > TSM:DB2_STD_ARCHIVE2
> >  TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE
> >  TSM node name(TSM_NODENAME) =
> >  TSM owner   (TSM_OWNER) =
> >  TSM password (TSM_PASSWORD) =
> >
> > hostname:db2sap 11> env|grep -i dsm
> > DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
> > DSMI_LOG=/db2/db2sap/errors
> > DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
> > DSM_DIR=/opt/tivoli/tsm/client/ba/bin
> > DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
> > DSM_LOG=/db2/db2sap/errors
> >
> > host name:db2pbg 12> env|grep -i tsm
> > DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
> > DSM_DIR=/opt/tivoli/tsm/client/ba/bin
> > hostname:db2sap 13>
> >
> > Thank you!
> >
> >
> > On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen < 
> > stephen.stackw...@icfi.com> wrote:
> >
> > > 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.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. 
> > > Pratt Street Suite 2214, Baltimore, MD 21202 |
> > > 410.539.1135 (o)
> > >
> > >
> > > > -Original Message-
> > > > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 
> > > > 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
> > > 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.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 D

Re: DB2 backup defaults?

[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 schreef "Stackwick, Stephen" <
stephen.stackw...@icfi.com> het volgende:

> 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(LOGARCHMETH2) = TSM
>  TSM management class(TSM_MGMTCLASS) =
>  TSM node name(TSM_NODENAME) =
>  TSM owner   (TSM_OWNER) =
>  TSM password (TSM_PASSWORD) =
>
> > env | grep -i dsm
> > env | grep -i tsm
> DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
> > set | grep -i dsm
> > set | grep -i tsm
> >
>
> STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
> stephen.stackw...@icfi.com | icfi.com
> ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 |
> 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 ,
> >
> > 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:DB2_STD_ARCHIVE1
> >  Second log archive method(LOGARCHMETH2) =
> > TSM:DB2_STD_ARCHIVE2
> >  TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE
> >  TSM node name(TSM_NODENAME) =
> >  TSM owner   (TSM_OWNER) =
> >  TSM password (TSM_PASSWORD) =
> >
> > hostname:db2sap 11> env|grep -i dsm
> > DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
> > DSMI_LOG=/db2/db2sap/errors
> > DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
> > DSM_DIR=/opt/tivoli/tsm/client/ba/bin
> > DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
> > DSM_LOG=/db2/db2sap/errors
> >
> > host name:db2pbg 12> env|grep -i tsm
> > DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
> > DSM_DIR=/opt/tivoli/tsm/client/ba/bin
> > hostname:db2sap 13>
> >
> > Thank you!
> >
> >
> > On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen <
> > stephen.stackw...@icfi.com> wrote:
> >
> > > 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.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt
> > > Street Suite 2214, Baltimore, MD 21202 |
> > > 410.539.1135 (o)
> > >
> > >
> > > > -Original Message-
> > > > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
> > > > 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
> > > 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.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 CFG listing; the TSM variables 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" and
> > > > darned
> > > if it
> > > > doesn't work. Am I missing something?
> > > >
> > > > Steve "Confused" Stackwick
> > > >
> > > > STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
> > > > stephen.stackw...@icfi.com

Re: DB2 backup defaults?

[Stackwick, Stephen]

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(LOGARCHMETH2) = TSM
 TSM management class(TSM_MGMTCLASS) =
 TSM node name(TSM_NODENAME) =
 TSM owner   (TSM_OWNER) =
 TSM password (TSM_PASSWORD) =

> env | grep -i dsm
> env | grep -i tsm
DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
> set | grep -i dsm
> set | grep -i tsm
>

STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | 
stephen.stackw...@icfi.com | icfi.com
ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 
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 ,
> 
> 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:DB2_STD_ARCHIVE1
>  Second log archive method(LOGARCHMETH2) =
> TSM:DB2_STD_ARCHIVE2
>  TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE
>  TSM node name(TSM_NODENAME) =
>  TSM owner   (TSM_OWNER) =
>  TSM password (TSM_PASSWORD) =
> 
> hostname:db2sap 11> env|grep -i dsm
> DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
> DSMI_LOG=/db2/db2sap/errors
> DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
> DSM_DIR=/opt/tivoli/tsm/client/ba/bin
> DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
> DSM_LOG=/db2/db2sap/errors
> 
> host name:db2pbg 12> env|grep -i tsm
> DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
> DSM_DIR=/opt/tivoli/tsm/client/ba/bin
> hostname:db2sap 13>
> 
> Thank you!
> 
> 
> On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen <
> stephen.stackw...@icfi.com> wrote:
> 
> > 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.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt
> > Street Suite 2214, Baltimore, MD 21202 |
> > 410.539.1135 (o)
> >
> >
> > > -Original Message-
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
> > > 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
> > 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.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 CFG listing; the TSM variables 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" and
> > > darned
> > if it
> > > doesn't work. Am I missing something?
> > >
> > > Steve "Confused" Stackwick
> > >
> > > STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
> > > stephen.stackw...@icfi.com |
> > > icfi.com ICF INTERNATIONAL | 410 E. Pratt
> > > Street
> > Suite
> > > 2214, Baltimore, MD 21202 | 410.539.1135 (o)
> > > *** Disclaimer ***
> > > Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52,
> > > 1043 Brussel
> > >
> > > nv van publiek recht
> > > BTW BE 0244.142.664
> > > RPR Brussel
> > > http://www.vrt.be/gebruiksvoorwaarden
> >

Re: DB2 backup defaults?

[Gopikrishna Muppidi]

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:DB2_STD_ARCHIVE1
 Second log archive method(LOGARCHMETH2) =
TSM:DB2_STD_ARCHIVE2
 TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE
 TSM node name(TSM_NODENAME) =
 TSM owner   (TSM_OWNER) =
 TSM password (TSM_PASSWORD) =

hostname:db2sap 11> env|grep -i dsm
DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
DSMI_LOG=/db2/db2sap/errors
DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
DSM_DIR=/opt/tivoli/tsm/client/ba/bin
DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_-SAP.opt
DSM_LOG=/db2/db2sap/errors

host name:db2pbg 12> env|grep -i tsm
DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
DSM_DIR=/opt/tivoli/tsm/client/ba/bin
hostname:db2sap 13>

Thank you!


On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen <
stephen.stackw...@icfi.com> wrote:

> 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.stackw...@icfi.com | icfi.com
> ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 |
> 410.539.1135 (o)
>
>
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 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
> 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.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 CFG listing; the TSM variables 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" and darned
> if it
> > doesn't work. Am I missing something?
> >
> > Steve "Confused" Stackwick
> >
> > STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
> > stephen.stackw...@icfi.com |
> > icfi.com ICF INTERNATIONAL | 410 E. Pratt Street
> Suite
> > 2214, Baltimore, MD 21202 | 410.539.1135 (o)
> > *** Disclaimer ***
> > Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043
> > Brussel
> >
> > nv van publiek recht
> > BTW BE 0244.142.664
> > RPR Brussel
> > http://www.vrt.be/gebruiksvoorwaarden
>

Re: DB2 backup defaults?

[Stackwick, Stephen]

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.stackw...@icfi.com | icfi.com
ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 
410.539.1135 (o)


> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On 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 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.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 CFG listing; the TSM variables 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" and darned if it
> doesn't work. Am I missing something?
> 
> Steve "Confused" Stackwick
> 
> STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
> stephen.stackw...@icfi.com |
> icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite
> 2214, Baltimore, MD 21202 | 410.539.1135 (o)
> *** Disclaimer ***
> Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043
> Brussel
> 
> nv van publiek recht
> BTW BE 0244.142.664
> RPR Brussel
> http://www.vrt.be/gebruiksvoorwaarden

Re: DB2 backup defaults?

[BEYERS Kurt]

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.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 CFG listing; the TSM variables 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" and darned if it 
doesn't work. Am I missing something?

Steve "Confused" Stackwick

STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | 
stephen.stackw...@icfi.com | 
icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 
2214, Baltimore, MD 21202 | 410.539.1135 (o)
*** Disclaimer ***
Vlaamse Radio- en Televisieomroeporganisatie
Auguste Reyerslaan 52, 1043 Brussel

nv van publiek recht
BTW BE 0244.142.664
RPR Brussel
http://www.vrt.be/gebruiksvoorwaarden

Re: DB2 Backup on tsm error.

[Murugan_Pachamallayan]

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: [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". Reason Code: "2032".

Don't be shy about searching at the TSM Support Page
(http://www-306.ibm.com/software/sysmgmt/products/support/
IBMTivoliStorageManager.html)
for:   SQL2062N  2032


   Richard Sims





DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.

Re: DB2 Backup on tsm error.

[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  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=entisapp001
TSM_PASSWORD=admin123
 
Still i get same issue .. If anything did wrong , please make correct..
 
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: [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". Reason Code: "2032".

Don't be shy about searching at the TSM Support Page
(http://www-306.ibm.com/software/sysmgmt/products/support/
IBMTivoliStorageManager.html)
for:   SQL2062N  2032


   Richard Sims





DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.

Re: DB2 Backup on tsm error.

[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 about searching at the TSM Support Page
(http://www-306.ibm.com/software/sysmgmt/products/support/
IBMTivoliStorageManager.html)
for:   SQL2062N  2032


  Richard Sims

Re: DB2 Backup on tsm error.

[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
"/home/db2inst1/sqllib/libtsm.a". Reason Code: "2032".
 
I read the API reurn codes source file ..
 
Explanation:

PASSWORDACCESS=GENERATE establishes a session with the current login user as 
the owner. The application should set clientOwnerNameP to NULL when 
PASSWORDACCESS=GENERATE is in effect. messagemessage

System action:

The system returns to the calling procedure. Whether the application can 
continue processing depends on how the application handles the error.

User response:

This message applies to applications that utilize the TSM API, and is intended 
primarily for the vendor of the application for which the message is issued. 
Depending on the application, this could be a configuration issue.

Consult the documentation for the application and verify that the application 
is configured correctly. If the problem persists, contact the application 
vendor for further assistance.

Still i have issue , please advice how can i procees further..

Thanks and Regards \ Murugan




From: ADSM: Dist Stor Manager on behalf of Richard Sims
Sent: Sun 4/1/2007 5:08 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DB2 Backup on tsm error.



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 of:
   /usr/tivoli/tsm/client/api/bin
or
   /usr/tivoli/tsm/client/api/bin64
depending upon your OS bitmode.

Assure also that the DSMI_LOG directory is writable by those who will
invoke the client software, so that they may write a dsierror.log
file therein.  (And, if there is now such a log file there, it might
contain some helpful recordings.)

Be sure to meticulously follow the instructions in the "Backing up
DB2 on AIX using Tivoli Storage Manager" redbook.

   Richard Sims





DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.

Re: DB2 Backup on tsm error.

[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 of:
  /usr/tivoli/tsm/client/api/bin
or
  /usr/tivoli/tsm/client/api/bin64
depending upon your OS bitmode.

Assure also that the DSMI_LOG directory is writable by those who will
invoke the client software, so that they may write a dsierror.log
file therein.  (And, if there is now such a log file there, it might
contain some helpful recordings.)

Be sure to meticulously follow the instructions in the "Backing up
DB2 on AIX using Tivoli Storage Manager" redbook.

  Richard Sims

Re: DB2 Backup on tsm error.

[Murugan_Pachamallayan]

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.sys

 SERVERNAME entisck001_server1

COMMMethod TCPip

TCPPort  1500

Nodename entisdev001

Tcpserveraddress 10.0.110.50

passwordaccess generate

 

dsm.opt

SERVERNAME entisck001_server1

 

My Environment variables

/home/db2inst1/sqllib/ userprofile

DSMI_DIR=/usr/tivoli/tsm/client/api/

DSM_CONFIG=/home/db2inst1/tsm/dsm.opt

DSMI_LOG=/home/db2inst1/tsm

 

If i am doing anything is incorrect please correct me..
 
Thanks and Regards
Murugan
 



From: ADSM: Dist Stor Manager on behalf of Pahari, Dinesh P
Sent: Sun 4/1/2007 4:40 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] DB2 Backup on tsm error.



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.

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 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 password again:admin123
*** Server signon failed: (137) Authentication failure!

Please can any one help me out in this regard.

Thanks and Regards
Murugan




DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.





DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.

Re: DB2 Backup on tsm error.

[Pahari, Dinesh P]

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. 

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 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 password again:admin123
*** Server signon failed: (137) Authentication failure!
 
Please can any one help me out in this regard.
 
Thanks and Regards
Murugan
 
 


DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.

Re: DB2 Backup on tsm error.

[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: admin123
Enter your new password:admin123
Enter your new password again:admin123
*** Server signon failed: (137) Authentication failure!


Murugan -

Context for the SQL2062N message is summarized in ADSM QuickFacts.
You'll find the 168 error code in the TSM API manual, generally
referring to an issue where the client password must be stored, but
the invoker is apparently not root.

You can find more specific problem cases via the TSM Support Page,
http://www-306.ibm.com/software/sysmgmt/products/support/
IBMTivoliStorageManager.html
by searching on: SQL2062N 168

  Richard Sims

Re: DB2 backup - connection unstable ?

[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 possible to assign a management
> class to the logs...


I assign my DB2 nodes to a separate domain;  I wasn't aware of the
tendency you describe, but it would solve that problem, too.


- Allen S. Rout

Re: DB2 backup - connection unstable ?

[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, it seems to be running now...

Regards,
/Brian






>> 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 says:


What's your idle timeout?

I've seen one factor that tends to result in dropped sessions in many
environments: botched network at the client side.  If you can get full
bandwidth in and out of the client, then that's not it.

One factor relevant for DB2 is that DB2 sometimes takes a while
twiddling its thumbs between tablespaces.  If your timeout is
sufficiently small, this might give the session time to expire.  But
from your log, that'd have to be a really short time, like in the
minute range or under.  That sounds suspiciously low to me.


- Allen S. Rout

Re: DB2 backup - connection unstable ?

[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 says:


What's your idle timeout?

I've seen one factor that tends to result in dropped sessions in many
environments: botched network at the client side.  If you can get full
bandwidth in and out of the client, then that's not it.

One factor relevant for DB2 is that DB2 sometimes takes a while
twiddling its thumbs between tablespaces.  If your timeout is
sufficiently small, this might give the session time to expire.  But
from your log, that'd have to be a really short time, like in the
minute range or under.  That sounds suspiciously low to me.


- Allen S. Rout

Re: DB2 Backup offline on Winnt

[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 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 the knowledge as to what folders should i exclude from 
> backup if:
> 1- I have bd2 database backup with me.
> 2- System state backup with me.
> 3- I want to restore complete system with DB2, with DB2 database backup ONLY 
> availbale with me in a file.
> 4- What folders/files should i exclude from backup using BA Client, so that i don't 
> mess up with open databases.
>
> Kind Regards,
> Sandra
>
> Steve Harris wrote:
>
> > 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.html?Open
> >
> > Regards
> >
> > Steve
> >
> > >>> [EMAIL PROTECTED] 02/11/2004 5:39:28 >>>
> > 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 database with them on tapes
> > and then rotation of tapes start.
> >
> > Now I am going to automate only this backedup database by taking incremental
> > backups only.
> >
> > Question:
> > For Database "A", what folders should I exclude so that I get all the
> > configuration of DB2 and then restoring database from those backups.
> > Do I have to shutdown DB2 before I take incremental backups of entire WINNT
> > machine?
> >
> > How about open file support on NT since there is no wizard to configure open
> > file support, and not even an option to select for image etc.?
> >
> > Please advise and Help !
> > Kind Regards,
> > Sandra
> >
> > ***
> > This email, including any attachments sent with it, is confidential and for the 
> > sole use of the intended recipient(s).  This confidentiality is not waived or 
> > lost, if you receive it and you are not the intended recipient(s), or if it is 
> > transmitted/received in error.
> >
> > Any unauthorised use, alteration, disclosure, distribution or review of this email 
> > is prohibited.  It may be subject to a statutory duty of confidentiality if it 
> > relates to health service matters.
> >
> > If you are not the intended recipient(s), or if you have received this email in 
> > error, you are asked to immediately notify the sender by telephone or by return 
> > email.  You should also delete this email and destroy any hard copies produced.
> > ***

Re: DB2 Backup offline on Winnt

[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 the knowledge as to what folders should i exclude from 
backup if:
1- I have bd2 database backup with me.
2- System state backup with me.
3- I want to restore complete system with DB2, with DB2 database backup ONLY availbale 
with me in a file.
4- What folders/files should i exclude from backup using BA Client, so that i don't 
mess up with open databases.

Kind Regards,
Sandra

Steve Harris wrote:

> 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.html?Open
>
> Regards
>
> Steve
>
> >>> [EMAIL PROTECTED] 02/11/2004 5:39:28 >>>
> 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 database with them on tapes
> and then rotation of tapes start.
>
> Now I am going to automate only this backedup database by taking incremental
> backups only.
>
> Question:
> For Database "A", what folders should I exclude so that I get all the
> configuration of DB2 and then restoring database from those backups.
> Do I have to shutdown DB2 before I take incremental backups of entire WINNT
> machine?
>
> How about open file support on NT since there is no wizard to configure open
> file support, and not even an option to select for image etc.?
>
> Please advise and Help !
> Kind Regards,
> Sandra
>
> ***
> This email, including any attachments sent with it, is confidential and for the sole 
> use of the intended recipient(s).  This confidentiality is not waived or lost, if 
> you receive it and you are not the intended recipient(s), or if it is 
> transmitted/received in error.
>
> Any unauthorised use, alteration, disclosure, distribution or review of this email 
> is prohibited.  It may be subject to a statutory duty of confidentiality if it 
> relates to health service matters.
>
> If you are not the intended recipient(s), or if you have received this email in 
> error, you are asked to immediately notify the sender by telephone or by return 
> email.  You should also delete this email and destroy any hard copies produced.
> ***

Re: DB2 Backup offline on Winnt

[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.

http://publib-b.boulder.ibm.com/abstracts/sg246247.html?Open

Regards

Steve



>>> [EMAIL PROTECTED] 02/11/2004 5:39:28 >>>
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 database with them on tapes
and then rotation of tapes start.

Now I am going to automate only this backedup database by taking incremental
backups only.

Question:
For Database "A", what folders should I exclude so that I get all the
configuration of DB2 and then restoring database from those backups.
Do I have to shutdown DB2 before I take incremental backups of entire WINNT
machine?

How about open file support on NT since there is no wizard to configure open
file support, and not even an option to select for image etc.?

Please advise and Help !
Kind Regards,
Sandra



***
This email, including any attachments sent with it, is confidential and for the sole 
use of the intended recipient(s).  This confidentiality is not waived or lost, if you 
receive it and you are not the intended recipient(s), or if it is transmitted/received 
in error.

Any unauthorised use, alteration, disclosure, distribution or review of this email is 
prohibited.  It may be subject to a statutory duty of confidentiality if it relates to 
health service matters.

If you are not the intended recipient(s), or if you have received this email in error, 
you are asked to immediately notify the sender by telephone or by return email.  You 
should also delete this email and destroy any hard copies produced.
***

Re: DB2 backup environment variables

[Bill Boyer]

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-
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 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/db2inst1/tsm/dsm.opt
export DSMI_LOG=/home/db2inst1/tsm

As root, and with the above DSMI variables set in the environment,
db2inst1/sqllib/adsm/dsmapipw was executed without error and verified with
db2adutl query. The above environment variables were used, as confirmed by
looking at the results and a trace.

Logged in as db2inst1, and after verifying that the environment variables
are ok, I executed the "db2 backup db sample use tsm" command and the
backup was successful. The problem is that the environment DSMI variables
above were ignored and the defaults were  used. This is confirmed by a
trace.

Can anyone suggest why this is happening. Thanks in advance.

Re: DB2 backup

[Levinson, Donald A.]

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 (TSM_PASSWORD) =

if you are not using a setting make sure it is set to NULL rather than
"".

I also find that I must use dsmapipw to get the DB2 API client
synchronized with the password initially or after a server based
password change no matter whether the password is set to generate 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), 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 the configurations described in the RedBook.


Thank you.


Nicolas

Réf. : Re: DB2 backup

[Nicolas Launay]

No...



|-+>
| |   "Crawford, Lindy"|
| |   <[EMAIL PROTECTED]|
| |   P.CO.ZA> |
| |   Envoyé par : |
| |   "ADSM: Dist Stor |
| |   Manager" |
| |   <[EMAIL PROTECTED]|
| |   .EDU>|
| ||
| ||
| |   11/03/2004 12:22 |
| |   Veuillez répondre|
| |   à "ADSM: Dist|
| |   Stor Manager"|
| ||
|-+>
  
>--|
  |
  |
  |   Pour :[EMAIL PROTECTED]  
   |
  |   cc : 
              |
  |   Objet :   Re: DB2 backup 
  |
  
>--|




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 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 the configurations described in the RedBook.


Thank you.


Nicolas


This email and any accompanying attachments may contain confidential and
proprietary information.  This information is private and protected by law
and accordingly if you are not the intended recipient you are requested to
delete this entire communication immediately and are notified that any
disclosure copying or distribution of or taking any action based on this
information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The
sender does not accept any liability or responsibility for any interception
corruption destruction loss late arrival or incompleteness of or tampering
or interference with any of the information contained in this email or for
its incorrect delivery or non-delivery for whatsoever reason or for its
effect on any electronic device of the recipient.

If verification of this email or any attachment is required please request
a
hard-copy version

Re: DB2 backup

[Thanh Nguyen Duc]

Hi Linda!
Could you tell me the of your redbook ??? 


  _  

Nguyen Duc Thanh
FPT Software Solution-Government Business Unit 
Address: 3th Fl, 51th, Ledaihanh.str, Haibatrung.dst, Hanoi, Vietnam 
Tel: (84-4) 974-5451/974-5476, ext 304 
Fax: (84-4) 974-5475 
Mobile: (090) 411-9847 
Website: 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:[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 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 the configurations described in the RedBook.


Thank you.


Nicolas


This email and any accompanying attachments may contain confidential and
proprietary information.  This information is private and protected by law
and accordingly if you are not the intended recipient you are requested to
delete this entire communication immediately and are notified that any
disclosure copying or distribution of or taking any action based on this
information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The
sender does not accept any liability or responsibility for any interception
corruption destruction loss late arrival or incompleteness of or tampering
or interference with any of the information contained in this email or for
its incorrect delivery or non-delivery for whatsoever reason or for its
effect on any electronic device of the recipient.

If verification of this email or any attachment is required please request a
hard-copy version

Re: DB2 backup

[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 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 the configurations described in the RedBook.


Thank you.


Nicolas


This email and any accompanying attachments may contain confidential and
proprietary information.  This information is private and protected by law
and accordingly if you are not the intended recipient you are requested to
delete this entire communication immediately and are notified that any
disclosure copying or distribution of or taking any action based on this
information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The
sender does not accept any liability or responsibility for any interception
corruption destruction loss late arrival or incompleteness of or tampering
or interference with any of the information contained in this email or for
its incorrect delivery or non-delivery for whatsoever reason or for its
effect on any electronic device of the recipient.

If verification of this email or any attachment is required please request a
hard-copy version

Re: DB2 backup

[Lambelet,Rene,VEVEY,GLOBE Center CSC]

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
Av. Nestlé 55  CH-1800 Vevey (Switzerland) 
tél +41 (0)21 924'35'43   fax +41 (0)21 924'45'89   local
REL-5 01
mailto:[EMAIL PROTECTED]

This message is intended only for the use of the addressee
and may contain 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 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 the configurations described in the RedBook.


Thank you.


Nicolas

Re: DB2 backup

[French, Michael]

Have you tried the IBM Redbook, "Backing Up DB2 Using Tivoli
Storage Manager"?  I used to to setup mine and had no problems with it,
very straight forward.

http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006
bb65f/ca11be93f3ae47b2852569f800819a82?OpenDocument&Highlight=0,db2

Michael French
Savvis Communications
IDS01 Santa Clara, CA
(408)450-7812 -- desk
(408)239-9913 -- mobile
 


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Rosa Leung
Sent: Tuesday, February 17, 2004 11:48 AM
To: [EMAIL PROTECTED]
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-490-5283
E-Mail: [EMAIL PROTECTED] ___

Re: DB2 backup

[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 problem

[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   Database:DB2MPROD
>
>  fbf5 556e 6162 6c65 2074 6f20 6f62   Unable to ob
> 7461 696e 2073 7570 6572 2065 7863 6c75   tain super exclu
> 7369 7665 2063 6f6e 6e65 6374 696f 6e00   sive connection.
>
> Anyone there to translate??

In order to backup the database _offline_, you need a super exclusive
connection to the database, thus no other client connections are
allowed. It seems there were another connections to the database during
the attempt of the offline backup. You have two options. a. run an
online backup and save the logs, b. before the scheduled offline backup,
force all client connections off the db. (db2 force application all)

--
   bx
"Seize the day - I heard him say - life will not always be this way,
Look around, hear the sounds, cherish your life while you're still around."

Re: DB2 backup on AIX

[Garrison, Tony]

We have our important DB2 databases being backed up to local DASD then TSM backs up 
the flat files with the required management class for database retention.  This 
alleviated problems we were seeing with the db2 backups being interrupted and causing 
an "out-of-sync" condition, which only a restart of the application could fix.  This 
also enables us (TSM) to control the expiration of the database files instead of 
relying on the DBA to expire them.  This has decreased our storage requirements on 
some of these servers to a quarter of what they were using.


Tony Garrison
I/T Sr. 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. 
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ÄGERNÄS
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: DB2 backup on AIX

[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

Re: DB2 backup on AIX

[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 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) 045.8182215
Gruppo Assicurativo Arca
Via San Marco 48 - 37138 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 redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
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 up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: DB2 backup on AIX

[Kolbeinn Josepsson]

Try this link:
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246247.html?Open




  Best regards,
  Kolbeinn Josepsson  7 Systems Engineer
  Tel: +354 569-7700 7 Fax: +354 569-7799
  www.nyherji.is








  Tomas Hrouda
  <[EMAIL PROTECTED]> To:  [EMAIL PROTECTED]
  Sent by: "ADSM:  cc:
  Dist Stor    Subject: Re: DB2 backup on AIX
  Manager"
  <[EMAIL PROTECTED]
  T.EDU>


  11.12.2002 12:44
  Please respond
  to "ADSM: Dist
  Stor Manager"






Thanks Daniel,

I'll try to contact him (if any exists :-)). But I have one more question
... is any redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
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 up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: DB2 backup on AIX

[Tomás Hrouda]

Thanks Daniel,

I'll try to contact him (if any exists :-)). But I have one more question
... is any redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
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 up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: DB2 backup on AIX

[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 HÄGERNÄS
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: DB2 Backup using different node names(MORE)

[Zig Zag]

Ed - Bill,

There is a way to do this.  We have a 32way 690, only 18
partitions/nodes/clients(whatever ya wanna call em, I call virtnodez) backing up
DB2.
The 18 p/n/c have the DB2 database spread across multiple sharks adding up to about
2TB for this DB, each p/n/c has a partition at about 180GB or so.
The backups are initiated thru maestro 10 seconds apart. We Linked the
/usr/tivoli/tsm/client/*/ba/bin/dsm.opt file to a file called /tmp/dsm.opt. We gave
the DB2 instance/user "sudo" access to only modify this file when the backup
starts, the script changes the /tmp/dsm.opt to the "instance" or "desired name".
Since it is linked when the backup starts it assumes that "desired" name. We do
this on a 12TB DB2 DB as well with 25 p/n/c. It works quite well. We had to add in
another script to copy the original dsm.opt file to the /tmp/dsm.opt file, cause
/tmp filled up and someone removed the file, it now checks for the file, if it
isn't there it copies it.
You need to have the "desired" names in your dsm.sys file also.
I would give you the script, but I know it wouldn't work in your environment. Too
many oddities here. :)

If you didn't get lost in this email, GOOD LUCK!
PS- I am trying to get them to do this(NODEXXDB2LOGXX) for the archive logging that
happens periodically. Am I crazy?

ZZ
--- Bill Boyer <[EMAIL PROTECTED]> wrote:
> 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
> 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 NODENAME before each backup command.
>
> I don't quite understand why you want the same DB backed up as 2 different
> nodes??!!?!
>
> 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 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 your platform is
> Unix) for particular TSM node in user environment, who owns database
> instance. Are tou sure you are switching your environment correctly?
>
>
> Ing. Jozef Zatko
> Login a.s.
> Dlha 2, Stupava
> tel.: (421) (2) 60252618


__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com

Re: DB2 Backup using different node names

[Bill Boyer]

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
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 NODENAME before each backup command.

I don't quite understand why you want the same DB backed up as 2 different
nodes??!!?!

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 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 your platform is
Unix) for particular TSM node in user environment, who owns database
instance. Are tou sure you are switching your environment correctly?


Ing. Jozef Zatko
Login a.s.
Dlha 2, Stupava
tel.: (421) (2) 60252618

Re: DB2 Backup using different node names

[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 your platform is
Unix) for particular TSM node in user environment, who owns database
instance. Are tou sure you are switching your environment correctly?


Ing. Jozef Zatko
Login a.s.
Dlha 2, Stupava
tel.: (421) (2) 60252618

Re: DB2 backup

[MUSTAFA BAYTAR]

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\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:  Subject: DB2 b
  Dist Stor
  Manager"
  <[EMAIL PROTECTED]
  T.EDU>


  17.10.2002 00:25
  Please respond
  to "ADSM: Dist
  Stor Manager"





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 machine with 2GB RAM

The regular backup is running fine, but I need to backup the DB2 instances
without having to stop them or the DB2 services.

Thanks in advance.

Mario Behring
IT Consultant
55 11 9540-8383

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

Re: DB2 backup

[Zlatko Krastev/ACIT]

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:
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 on a Windows NT Server 4.0
SP6a machine with 2GB RAM

The regular backup is running fine, but I need to backup the DB2 instances
without having to stop them or the DB2 services.

Thanks in advance.

Mario Behring
IT Consultant
55 11 9540-8383

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

Re: DB2 backup

[Mario Behring]

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 respond to "ADSM: Dist 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 on a Windows 2000 Server machine
> => TSM Backup-Archive Client 4.1.2.14 running on a Windows NT Server 4.0
> SP6a machine with 2GB RAM
>
> The regular backup is running fine, but I need to backup the DB2
> instances
> without having to stop them or the DB2 services.
>
> Thanks in advance.
>
> Mario Behring
> IT Consultant
> 55 11 9540-8383
>
> __
> Do you Yahoo!?
> Faith Hill - Exclusive Performances, Videos & More
> http://faith.yahoo.com


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

Re: DB2 backup problem..

[Gerald Wichmann]

Well that was painful but I found the problem after digging around on my
own.. The "Backing up DB2 using Tivoli Storage Manager" redbook lacks a step
in the section "Chapter 6 : Backing up DB2 UDB on the Sun Solaris Platform".
I closely followed the steps there and did it on two different DB2
installations with the same result.. Eventually after trying to troubleshoot
and running out of ideas I read Appendix A "Quick start/checklist for
configuration" which has a Sun Solaris section. After following the steps in
there I found a section which was never mentioned in the main Installation
section in chapter 6.. mainly this at the end of the quick start:

- Get db cfg for DBNAME.
- Update db cfg for DBNAME using TSM_PASSWORD NULL. (Similar
syntax for other Tivoli Storage Manager parameters. NULL causes the
parameter to be reset to nothing.)


db2 => get db cfg for ds50

relevant portion of output:

TSM management class(TSM_MGMTCLASS) = DB2_MGMTCLASS
 TSM node name(TSM_NODENAME) = ds-s0-99-1
 TSM owner   (TSM_OWNER) = admin
 TSM password (TSM_PASSWORD) = *

db2 => update db cfg for ds50 using TSM_PASSWORD NULL
DB2I  The UPDATE DATABASE CONFIGURATION command completed successfully.
DB21026I  For most configuration parameters, all applications must
disconnect
from this database before the changes become effective.

db2 => update db cfg for ds50 using TSM_MGMTCLASS NULL
DB2I  The UPDATE DATABASE CONFIGURATION command completed successfully.
DB21026I  For most configuration parameters, all applications must
disconnect
from this database before the changes become effective.

db2 => update db cfg for ds50 using TSM_OWNER NULL
DB2I  The UPDATE DATABASE CONFIGURATION command completed successfully.
DB21026I  For most configuration parameters, all applications must
disconnect
from this database before the changes become effective.

db2 => update db cfg for ds50 using TSM_NODENAME NULL
DB2I  The UPDATE 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 : 20020531164955

db2 =>

Thus why it was gripping RC 2032 complaining about ownership.. it was a
parameter in DB2 all along..

Regards,

Gerald Wichmann
Senior Systems Development Engineer
Zantaz, Inc.
925.598.3099 (w)

-Original Message-
From: William F. Colwell [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 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 /* owner not allowed. Allow default
*/

Exactly what to change to fix this?  I 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 error occurred while accessing media
>"/opt/db2udb/sqllib/adsm/libadsm.a". Reason code: "2032".
>
>db2 => ? sql2062n
>
> SQL2062N An error occurred while accessing media "".
>  Reason code: ""
>
>Explanation:  An unexpected error occurred while accessing a
>device, file, TSM or the vendor shared library during the
>processing of a database utility.  The following is a list of
>reason codes:
>
>
>1 An attempt to initialize a device, file, TSM or the vendor
>shared library failed.
>
>2 An attempt to terminate a device, file, TSM or the vendor
>shared library failed.
>
>other If you are using TSM, this is an error code returned by
>TSM.
>
>The utility stops processing.
>
>User Response:  Ensure the device, file, TSM or vendor shared
>library used by the utility is available and resubmit the utility
>command.  If the command is still unsuccessful, contact your
>technical service representative.
>
>
>
>$ ls -l /opt/db2udb/sqllib/adsm/libadsm.a
>-r-r-r-1 bin bin 93664 Apr 17 2001 /opt/db2udb/sqllib/adsm/libadsm.a
>
>
>
>Regards,
>
>Gerald Wichmann
>Senior Systems Development Engineer
>Zantaz, Inc.
>925.598.3099 (w)

--
Bill Colwell
C. S. Draper Lab
Cambridge Ma.

Re: DB2 backup problem..

[William F. Colwell]

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 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 error occurred while accessing media
>"/opt/db2udb/sqllib/adsm/libadsm.a". Reason code: "2032".
>
>db2 => ? sql2062n
>
> SQL2062N An error occurred while accessing media "".
>  Reason code: ""
>
>Explanation:  An unexpected error occurred while accessing a
>device, file, TSM or the vendor shared library during the
>processing of a database utility.  The following is a list of
>reason codes:
>
>
>1 An attempt to initialize a device, file, TSM or the vendor
>shared library failed.
>
>2 An attempt to terminate a device, file, TSM or the vendor
>shared library failed.
>
>other If you are using TSM, this is an error code returned by
>TSM.
>
>The utility stops processing.
>
>User Response:  Ensure the device, file, TSM or vendor shared
>library used by the utility is available and resubmit the utility
>command.  If the command is still unsuccessful, contact your
>technical service representative.
>
>
>
>$ ls -l /opt/db2udb/sqllib/adsm/libadsm.a
>-r-r-r-1 bin bin 93664 Apr 17 2001 /opt/db2udb/sqllib/adsm/libadsm.a
>
>
>
>Regards,
>
>Gerald Wichmann
>Senior Systems Development Engineer
>Zantaz, Inc.
>925.598.3099 (w)

--
Bill Colwell
C. S. Draper Lab
Cambridge Ma.

Re: DB2 backup problem..

[Gerald Wichmann]

Nope.. my dsm.sys is:

SErvername  TSM
   COMMmethod TCPip
   TCPPort1500
   TCPServeraddress   dev36
   passwordaccess generate
   SCHEDMODe  PROMPT
   maxcmdretries  10
   Nodename   DB2
   schedlogname   /opt/tivoli/tsm/client/ba/bin/dsmsched.log
   schedlogretention  3
   errorlogname   /opt/tivoli/tsm/client/ba/bin/dsmerror.log
   errorlogretention  3

I notice in TSM messages theres this which is similar to what you mentioned:

2032 E DSM_RC_NO_OWNER_REQD
Explanation: PASSWORDACCESS=generate establishes a session with the current
login user as the owner.
System Action: The system returns to the calling procedure.
User Response: When using PASSWORDACCESS=generate, set clientOwnerNameP to
NULL.

Question is, why is this happening? I don't have an owner specified
anywhere..

Regards,

Gerald Wichmann
Senior Systems Development 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. 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.



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". Reason code: "2032".
>
>db2 => ? sql2062n
>
>  SQL2062N An error occurred while accessing media "".
>   Reason code: ""
>
>Explanation:  An unexpected error occurred while accessing a
>device, file, TSM or the vendor shared library during the
>processing of a database utility.  The following is a list of
>reason codes:
>
>
>1 An attempt to initialize a device, file, TSM or the vendor
>shared library failed.
>
>2 An attempt to terminate a device, file, TSM or the vendor
>shared library failed.
>
>other If you are using TSM, this is an error code returned by
>TSM.
>
>The utility stops processing.
>
>User Response:  Ensure the device, file, TSM or vendor shared
>library used by the utility is available and resubmit the utility
>command.  If the command is still unsuccessful, contact your
>technical service representative.
>
>
>
>$ ls -l /opt/db2udb/sqllib/adsm/libadsm.a
>-r-r-r-1 bin bin 93664 Apr 17 2001 /opt/db2udb/sqllib/adsm/libadsm.a
>
>
>
>Regards,
>
>Gerald Wichmann
>Senior Systems Development Engineer
>Zantaz, Inc.
>925.598.3099 (w)

Money is not the root of all evil - full backups are.

Re: DB2 backup problem..

[Dave Canan]

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.



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". Reason code: "2032".
>
>db2 => ? sql2062n
>
>  SQL2062N An error occurred while accessing media "".
>   Reason code: ""
>
>Explanation:  An unexpected error occurred while accessing a
>device, file, TSM or the vendor shared library during the
>processing of a database utility.  The following is a list of
>reason codes:
>
>
>1 An attempt to initialize a device, file, TSM or the vendor
>shared library failed.
>
>2 An attempt to terminate a device, file, TSM or the vendor
>shared library failed.
>
>other If you are using TSM, this is an error code returned by
>TSM.
>
>The utility stops processing.
>
>User Response:  Ensure the device, file, TSM or vendor shared
>library used by the utility is available and resubmit the utility
>command.  If the command is still unsuccessful, contact your
>technical service representative.
>
>
>
>$ ls -l /opt/db2udb/sqllib/adsm/libadsm.a
>-r-r-r-1 bin bin 93664 Apr 17 2001 /opt/db2udb/sqllib/adsm/libadsm.a
>
>
>
>Regards,
>
>Gerald Wichmann
>Senior Systems Development Engineer
>Zantaz, Inc.
>925.598.3099 (w)

Money is not the root of all evil - full backups are.

Re: DB2 backup RC=157

[Thomas, Matthew]

Sorry, code levels as below:

Server: TSM 4.2.0.0 on AIX 4.3.3
Client: TSM 4.2.0.0 on NT4
DB2:v7 fixpack 5
Qlogic FC catd is at firmware 1.61 and driver 8.00.08


On the client side there is nothing in the dsmerror.log other than

20-05-2002 22:33:11 sessRecvVerb: Error -72 from call to 'readRtn'.
20-05-2002 22:33:11 cuConfirm: Received rc: -72 trying to receive
ConfirmResp verb
20-05-2002 22:33:12 sessSendVerb: Error sending Verb, rc: -1
20-05-2002 22:33:12 sessRecvVerb: Error -72 from call to 'readRtn'.
20-05-2002 22:33:12 cuConfirm: Received rc: -72 trying to receive
ConfirmResp verb
20-05-2002 22:33:12 sessSendVerb: Error sending Verb, rc: -1

>From dsmrc.h:

/*--
-*/

/* Return codes (-71)-(-90) are reserved for CommTSM error codes
*/
/*--
-*/


#define DSM_RC_TSM_ABORT   -72 /* Session aborted abnormally
*/

In the dsmaccnt.log

4,0,ADSM,05/20/2002,22:34:30,DB2RSLTSBDC1001_DB2,,DB2/NT,1,Named
Pipe,0,0,0,0,0,0,0,0,0,12696744,2008,2,1731,52,4,0,0,0,0,2,0

4,0,ADSM,05/20/2002,22:35:15,DB2RSLTSBDC1001_DB2,,DB2/NT,1,Named
Pipe,0,0,0,0,0,0,0,0,0,11574426,1924,2,1655,51,4,0,0,0,0,2,0

Nothing in the dsmsched.log since the DB2 backups aren't under the
scheduler's control.


On the Server side of things:

Sessions aborted abnormally, however there are no related errors in the
server log, only the following warnings:

ate/Time Message

--
05/20/02 22:01:07 ANR0406I Session 25934 started for node
DB2RSLTSBDC1001_-
   DB2 (DB2/NT) (Tcp/Ip 10.255.128.226(4315)).
05/20/02 22:34:01 ANR0480W Session 25934 for node DB2RSLTSBDC1001_DB2
   (DB2/NT) terminated - connection with client
severed.

Sessions start then terminate some time later.
The only other error/warning in the acct log is:

05/20/02 22:35:46 ANR8264W (Session: 25948, Origin:
DB2RSLTSBDC1001_STA)
   Error reading data on Named Pipes, session 242.
ReadFile
   return code is 233.
05/20/02 22:35:46 ANR8264W (Session: 25948, Origin:
DB2RSLTSBDC1001_STA)
   Error reading data on Named Pipes, session 242.
ReadFile
   return code is 233.
05/20/02 22:35:46 ANR8264W (Session: 25948, Origin:
DB2RSLTSBDC1001_STA)
   Error reading data on Named Pipes, session 246.
ReadFile
   return code is 233.

ANR8264W (Windows NT) Error reading data on Named Pipes, session session
number. ReadFile return code is return code.

Explanation: The server experiences an error return code from the ReadFile
Windows NT API while reading data from Named Pipes in the indicated
session. This may be a normal event if either side of the connection is
ended abruptly.

System Action: The session is ended. Server operation continues.

User Response: If the session is ended as a result of intentionally
stopping either the client or server, no response is required.

This is apparently an extraneous error fixed as of clinet v4.2.1.0 (we are
at 4.2.0.0)

IC30272  ANR8264W ...ERROR READING DATA ON NAMED PIPES, SESSION 22153844

 SYSROUTES:

 An extraneous Named Pipe Read error may be reported
 when a session is cancelled for exceeding the idle time
 out period or is cancelled by administrative command.

The P3A server IdleTimeOut is currently set at 60 minutes. CommTimeOut 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 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,
>
>Our DBAs are having a few problems backing up a DB2 database to a TSM 3590
>tape pool via LANfree. There are no errors in the dsmerror.log on the
>client, nor any indicated errors in the server actlog, nor any errors in
the
>NT Event Viewer that could be related.
>The storage agent 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
> #define DSM_RC_WILL_ABORT  157 /* Transaction will be
>aborted   */
>
>Which doesn't really indicate what cause the abort. Any ideas/suggestions
>appreciated

Re: DB2 backup RC=157

[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,
>
>Our DBAs are having a few problems backing up a DB2 database to a TSM 3590
>tape pool via LANfree. There are no errors in the dsmerror.log on the
>client, nor any indicated errors in the server actlog, nor any errors in the
>NT Event Viewer that could be related.
>The storage agent 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
> #define DSM_RC_WILL_ABORT  157 /* Transaction will be
>aborted   */
>
>Which doesn't really indicate what cause the abort. Any ideas/suggestions
>appreciated?
>
>Ta,
>Matt
>
>LTSB Storage Support
>* internal.7-430-3213
>*   external.   020-7922-3213
>* fax020-7922-3302
>* e-mail[EMAIL PROTECTED]
>
>
>
>
>
>
>
>---
>This e-mail is intended only for the above addressee.  It may contain
>privileged information. If you are not the addressee you must not copy,
>distribute, disclose or use any of the information in it.  If you have
>received it in error please delete it and immediately notify the sender.
>
>evolvebank.com is a division of Lloyds TSB Bank plc.
>Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS.  Registered in
>England, number 2065.  Telephone No: 020 7626 1500
>Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
>Edinburgh EH2 4LH.  Registered in Scotland, number 95237.  Telephone
>No: 0131 225 4555
>
>Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
>Financial Services Authority and represent only the Scottish Widows
>and Lloyds TSB Marketing Group for life assurance, pensions and
>investment business.
>
>Signatories to the Banking Codes.
>---
>

Money is not the root of all evil - full backups are.