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.

<host>: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_<host>-SAP.opt
DSM_DIR=/opt/tivoli/tsm/client/ba/bin
DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_<host>-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.Stackwick AT icfi DOT 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.Stackwick AT icfi DOT 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 AT VM.MARIST DOT EDU] On Behalf
> > Of BEYERS Kurt
> > Sent: Wednesday, September 11, 2013 5:26 AM
> > To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] Namens
> > Stackwick, Stephen
> > Verzonden: dinsdag 10 september 2013 23:53
> > Aan: ADSM-L AT VM.MARIST DOT 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.Stackwick AT icfi DOT com<mailto:sstackwick AT icfi DOT com> |
> > icfi.com<http://www.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
>