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