Re: 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:[EMAIL PROTECTED] On Behalf Of Collins, Brenda Sent: Monday, October 01, 2007 7:47 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 Logs in TSM Thanks for the help! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bob Booth Sent: Thursday, September 27, 2007 10:02 AM To: ADSM-L@VM.MARIST.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=XX 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.
Re: DB2 Logs in TSM
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 C001_S200- 2007-09-05 DB2 .LOG 00:14:39.00 DBSP0075-DB2 /ADREPTPR C001_S201- 2007-09-05 DB2 .LOG 00:15:09.00 DBSP0075-DB2 /ADREPTPR C001_S202- 2007-09-06 DB2 .LOG 00:13:14.00 DBSP0075-DB2 /ADREPTPR C001_S203- 2007-09-06 DB2 .LOG 00:13:45.00 DBSP0075-DB2 /ADREPTPR C001_S204- 2007-09-07 DB2 .LOG 00:13:14.00 DBSP0075-DB2 /ADREPTPR C001_S205- 2007-09-07 DB2 .LOG 00:13:43.00 DBSP0075-DB2 /ADREPTPR C001_S206- 2007-09-08 DB2 .LOG 00:13:14.00 DBSP0075-DB2 /ADREPTPR C001_S207- 2007-09-08 DB2 .LOG 00:13:43.00 DBSP0075-DB2 /ADREPTPR C001_S208- 2007-09-09 DB2 .LOG 00:20:46.00 DBSP0075-DB2 /ADREPTPR C001_S209- 2007-09-09 DB2 .LOG 00:21:20.00 DBSP0075-DB2 /ADREPTPR C001_S210- 2007-09-10 DB2 .LOG 00:13:18.00 DBSP0075-DB2 /ADREPTPR C001_S211- 2007-09-10 DB2 .LOG 00:13:50.00 DBSP0075-DB2 /ADREPTPR C001_S212- 2007-09-11 DB2 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sandeep Jain Sent: Thursday, October 04, 2007 12:41 AM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of Collins, Brenda Sent: Monday, October 01, 2007 7:47 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 Logs in TSM Thanks for the help! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bob Booth Sent: Thursday, September 27, 2007 10:02 AM To: ADSM-L@VM.MARIST.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=XX 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
Re: DB2 Logs in TSM
Thanks for the help! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bob Booth Sent: Thursday, September 27, 2007 10:02 AM To: ADSM-L@VM.MARIST.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=XX 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
DB2 Logs in TSM
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 Thanks in advance for any help you can offer, it would be greatly appreciated! -- Medtronic Collins, Brenda Sr. Principle Systems Technologist [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] tel: 763-514-4969 mobile: 763-218-9596 -- ___ 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
Re: 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=XX That is usually what I use on our DB2 nodes. hth, bob
