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) | [email protected] | 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:[email protected]] On Behalf > Of BEYERS Kurt > Sent: Wednesday, September 11, 2013 5:26 AM > To: [email protected] > 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:[email protected]] Namens > Stackwick, Stephen > Verzonden: dinsdag 10 september 2013 23:53 > Aan: [email protected] > 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) | > [email protected]<mailto:[email protected]> | > 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
