Re: [ADSM-L] DB2 backup defaults?

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