Do a select statement form the TSM console -
select NODE_NAME, FILESPACE_NAME, LL_NAME, ARCHIVE_DATE,
CLASS_NAME from archives where NODE_NAME='DBSP0075-DB2'
Results
Do you wish to proceed? (Yes (Y)/No (N)) y
NODE_NAME FILESPACE_NAME LL_NAME
ARCHIVE_DATE CLASS_NAME
------------------ ------------------ ------------------
------------------ ------------------
DBSP0075-DB2 /ADREPTPR C0000001_S0000200-
2007-09-05 DB2
.LOG
00:14:39.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000201-
2007-09-05 DB2
.LOG
00:15:09.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000202-
2007-09-06 DB2
.LOG
00:13:14.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000203-
2007-09-06 DB2
.LOG
00:13:45.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000204-
2007-09-07 DB2
.LOG
00:13:14.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000205-
2007-09-07 DB2
.LOG
00:13:43.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000206-
2007-09-08 DB2
.LOG
00:13:14.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000207-
2007-09-08 DB2
.LOG
00:13:43.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000208-
2007-09-09 DB2
.LOG
00:20:46.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000209-
2007-09-09 DB2
.LOG
00:21:20.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000210-
2007-09-10 DB2
.LOG
00:13:18.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000211-
2007-09-10 DB2
.LOG
00:13:50.000000
DBSP0075-DB2 /ADREPTPR C0000001_S0000212-
2007-09-11 DB2
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Sandeep Jain
Sent: Thursday, October 04, 2007 12:41 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] DB2 Logs in TSM
Hi
Is you're your DB2 data base on AIX.
( o )
-------
I,I ' ' I,I
"(("
))
With Best Regards,
Sandeep Jain
********************** Legal Disclaimer
*****************************************
"This email may contain confidential and privileged material for the
sole use of the intended recipient. Any unauthorized review, use or
distribution by others is strictly prohibited. If you have received the
message in error, please advise the sender by reply email and delete the
message. Thank you."
************************************************************************
****
*********
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Collins, Brenda
Sent: Monday, October 01, 2007 7:47 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] DB2 Logs in TSM
Thanks for the help!
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bob Booth
Sent: Thursday, September 27, 2007 10:02 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] DB2 Logs in TSM
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
________________________________________________________________________
____
_______________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is
addressed, and may contain information that is private, privileged,
confidential or exempt from disclosure under applicable law. If you are
not the intended recipient or it appears that this mail has been
forwarded to you without proper authority, you are notified that any use
or dissemination of this information in any manner is strictly
prohibited. In such cases, please delete this mail from your records.
To view this notice in other languages you can either select the
following link or manually copy and paste the link into the address bar
of a web
browser: http://emaildisclaimer.medtronic.com
DISCLAIMER "The information contained in this e-mail is intended only
for the person or entity to whom it is addressed and may contain
confidential or privileged information.
If you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of information in this e-mail is
strictly prohibited, and you are requested to contact the sender by
reply e-mail and destroy all copies of the original message.Thank you"
This email has been scanned for any virus infection at the sending end.
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
|