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<mailto:sstackw...@icfi.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