On Thu, Sep 27, 2007 at 09:23:33AM -0500, Collins, Brenda wrote: > Good morning! > > Does anyone have a select command that would let me see all the archive logs > that exist within TSM for a DB2 node ? Somehow they have logs for a > particular database under two different node names. They don't know when it > was changed but need to know how many logs are out there under the old node > name. (Of course, they need a restore from one of them as well.) > > TSM Server 5.4.0.2 > TSM Client 5.4.0.0 > DB2 8.0
Select * from archives where node_name="XXXXXX" That is usually what I use on our DB2 nodes. hth, bob
