Re: TDP for SQL Server question
Hi Del! That's clear, but I found no way to overrule the NODENAME, which is specified in the option file, through the GUI. How can one do that? Thank you very much for you reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 03:26 To: [EMAIL PROTECTED] Subject: Re: TDP for SQL Server question Eric, You no longer need direct query because when you enter the TSM Server using the NODENAME that contains the backup, the SQL Server name will automatically appear in the tree view. In other words, DP for SQL will query the TSM Server for all backups under the NODENAME as opposed to just the SQL server that you are running DP for SQL on. Thanks, Del Hi *SM-ers! Our SQL Server department is slowly migrating from TDP for SQL 2.x to 5.2.1. They used to use the version 2 option called Direct Query to restore a database from a different SQL Server node to the target node, but this option is no longer available in the 5.2 version. What's the best way to restore a database from a different TDP node using 5.2? Thank you very much for your reply in advance! ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
SQL query
Hallo TSMers, I think I've mentioned before, my SQL's not so hot. I'm practising all I can, although, I can't seem to crack this one, or others like it; I would like to find out (with SQL if possible, I could do it via script etc.. easy enough) ; For every stgpool that has a device class of ultrium1; the stgpool name, the maxscratch value for the stgpool and how many volumes are in that stgpool. I'm incredibly hazy on things like joins, despite having read around the subject, and TSM only implements a cut-down SQL. It is, to get technical, doing my head in. Thanks, Matt. ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore the Powergen Group does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Powergen Group. Registered addresses: Powergen UK plc, 53 New Broad Street, London, EC2M 1SL Registered in England Wales No. 2366970 Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
TDP SQL logs expiration...
Hi All, Why is't only the full version of TDP SQL backup, there is deleted after expiration??? All the log backups, 30 days back, is still available, when I query the TSM server. The full exist version match the MC - 15 1 15 60. TSM server z/os version until last monday 5.1.6.5 now 5.2.1.3, TDP SQL version 5.1.5.0 Regards Bo Nielsen * +45 4386 4671 COOP Danmark A/S* (Internt postcenter): 6230 IT-Driftscenter * [EMAIL PROTECTED] Remember, a dead fish can float downstream, But it takes a live one to svim upstream. - W.C. Fields.
SV: SQL query
Hi Matt! Im not sure what you looking for. But maybe this helps you... Replace YOUR LTOCLASS NAME with the real Device class name. select stgpool_name,count(*) as Maxscratch from volumes where devclass_name='YOUR LTOCLASS NAME' /Christian -Ursprungligt meddelande- Fran: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Warren, Matthew (Retail) Skickat: den 16 januari 2004 13:03 Till: [EMAIL PROTECTED] Amne: SQL query Hallo TSMers, I think I've mentioned before, my SQL's not so hot. I'm practising all I can, although, I can't seem to crack this one, or others like it; I would like to find out (with SQL if possible, I could do it via script etc.. easy enough) ; For every stgpool that has a device class of ultrium1; the stgpool name, the maxscratch value for the stgpool and how many volumes are in that stgpool. I'm incredibly hazy on things like joins, despite having read around the subject, and TSM only implements a cut-down SQL. It is, to get technical, doing my head in. Thanks, Matt. ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore the Powergen Group does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Powergen Group. Registered addresses: Powergen UK plc, 53 New Broad Street, London, EC2M 1SL Registered in England Wales No. 2366970 Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
Re: SQL query
Hi Christian, Sorry, I may not have worded my problem very clearly. Using the follwing tables and columns; TABLENAMECOLNAME -- -- STGPOOLS STGPOOL_NAME STGPOOLSDEVCLASS STGPOOLS MAXSCRATCH VOLUMESSTGPOOL_NAME I would like to find out; For every stgpool that has a device class of ultrium1, I need to know the stgpool name, the maxscratch value ((IE: the maximum number of scratch tapes alolwed for use in the pool)) for the stgpool and a count of how many volumes are in the stgpool In case it helps (I doubt it :/ ) heres a copy of the latest attempt I made at trying to work it out; tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes where stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2940E The reference 'STGPOOLS.STGPOOL_NAME' is an unknown SQL column name. | ...V... select stgpools.stgpool_name, stgpools.maxscratch, count(*) fro ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2941E The column reference 'STGPOOL_NAME' matches more than one SQL column name. | .V. m volumes,stgpools where stgpool_name in (select stgpool_name f ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2941E The column reference 'STGPOOL_NAME' matches more than one SQL column name. | ...V... from stgpools where devclass='ULTRIUM1' ) group by stgpool_name ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpools.stgpool_name ANR2938E The column 'MAXSCRATCH' is not allowed in this context; it must either be named in the GROUP BY clause or be nested within an aggregate function. | ..V select stgpools.stgpool_name, stgpools.maxscratch, count(*) fro ANS8001I Return code 3. tsm: CARSINGTONpull hair, gnash teeth -Original Message- From: Christian Svensson [EMAIL PROTECTED]@EME Sent: Friday, January 16, 2004 1:06 PM To: [EMAIL PROTECTED] Subject: SV: SQL query Hi Matt! Im not sure what you looking for. But maybe this helps you... Replace YOUR LTOCLASS NAME with the real Device class name. select stgpool_name,count(*) as Maxscratch from volumes where devclass_name='YOUR LTOCLASS NAME' /Christian -Ursprungligt meddelande- Fran: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Warren, Matthew (Retail) Skickat: den 16 januari 2004 13:03 Till: [EMAIL PROTECTED] Amne: SQL query Hallo TSMers, I think I've mentioned before, my SQL's not so hot. I'm practising all I can, although, I can't seem to crack this one, or others like it; I would like to find out (with SQL if possible, I could do it via script etc.. easy enough) ; For every stgpool that has a device class of ultrium1; the stgpool name, the maxscratch value for the stgpool and how many volumes are in that stgpool. I'm incredibly hazy on things like joins, despite having read around the subject, and TSM only implements a cut-down SQL. It is, to get technical, doing my head in. Thanks, Matt. ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission
Re: TDP for SQL Server question
Eric, The only way I've found to do this is to create another options file for each sql node that needs to be restored. Then enter TDPSQL with the /tsmoptfile= switch. For example: On nodea: dsm_nodeb.opt ... nodename nodeb_sql ... Create a shortcut for your users with an appropriate name containing C:\Program Files\tivoli\tsm\tdpsql\tdpsql /tsmoptfile=dsm_nodeb.opt Then you will be able to see nodeb's sql databases on the TSM server in the restore screen. Bill Smoldt STORServer, Inc. -Original Message- From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 2:05 AM To: [EMAIL PROTECTED] Subject: Re: TDP for SQL Server question Hi Del! That's clear, but I found no way to overrule the NODENAME, which is specified in the option file, through the GUI. How can one do that? Thank you very much for you reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 03:26 To: [EMAIL PROTECTED] Subject: Re: TDP for SQL Server question Eric, You no longer need direct query because when you enter the TSM Server using the NODENAME that contains the backup, the SQL Server name will automatically appear in the tree view. In other words, DP for SQL will query the TSM Server for all backups under the NODENAME as opposed to just the SQL server that you are running DP for SQL on. Thanks, Del Hi *SM-ers! Our SQL Server department is slowly migrating from TDP for SQL 2.x to 5.2.1. They used to use the version 2 option called Direct Query to restore a database from a different SQL Server node to the target node, but this option is no longer available in the 5.2 version. What's the best way to restore a database from a different TDP node using 5.2? Thank you very much for your reply in advance! ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
SV: SQL query
Hi Matt! I try your last select command but just only add stgpools.maxscratch in the end of your line. select stgpools.stgpool_name, stgpools.maxscratch,count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpools.stgpool_name, stgpools.maxscratch Result : STGPOOL_NAMEMAXSCRATCH Unnamed[3] -- --- --- ARCHIVEPOOL 11 BACKUPPOOL 11 COPYPOOL 3 11 DISKPOOL11 SPACEMGPOOL 11 TAPEPOOL11 11 /Christian -Ursprungligt meddelande- Fran: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Warren, Matthew (Retail) Skickat: den 16 januari 2004 14:30 Till: [EMAIL PROTECTED] Amne: Re: SQL query Hi Christian, Sorry, I may not have worded my problem very clearly. Using the follwing tables and columns; TABLENAMECOLNAME -- -- STGPOOLS STGPOOL_NAME STGPOOLSDEVCLASS STGPOOLS MAXSCRATCH VOLUMESSTGPOOL_NAME I would like to find out; For every stgpool that has a device class of ultrium1, I need to know the stgpool name, the maxscratch value ((IE: the maximum number of scratch tapes alolwed for use in the pool)) for the stgpool and a count of how many volumes are in the stgpool In case it helps (I doubt it :/ ) heres a copy of the latest attempt I made at trying to work it out; tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes where stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2940E The reference 'STGPOOLS.STGPOOL_NAME' is an unknown SQL column name. | ...V... select stgpools.stgpool_name, stgpools.maxscratch, count(*) fro ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2941E The column reference 'STGPOOL_NAME' matches more than one SQL column name. | .V. m volumes,stgpools where stgpool_name in (select stgpool_name f ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2941E The column reference 'STGPOOL_NAME' matches more than one SQL column name. | ...V... from stgpools where devclass='ULTRIUM1' ) group by stgpool_name ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpools.stgpool_name ANR2938E The column 'MAXSCRATCH' is not allowed in this context; it must either be named in the GROUP BY clause or be nested within an aggregate function. | ..V select stgpools.stgpool_name, stgpools.maxscratch, count(*) fro ANS8001I Return code 3. tsm: CARSINGTONpull hair, gnash teeth -Original Message- From: Christian Svensson [EMAIL PROTECTED]@EME Sent: Friday, January 16, 2004 1:06 PM To: [EMAIL PROTECTED] Subject: SV: SQL query Hi Matt! Im not sure what you looking for. But maybe this helps you... Replace YOUR LTOCLASS NAME with the real Device class name. select stgpool_name,count(*) as Maxscratch from volumes where devclass_name='YOUR LTOCLASS NAME' /Christian -Ursprungligt meddelande- Fran: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Warren, Matthew (Retail) Skickat: den 16 januari 2004 13:03 Till: [EMAIL PROTECTED] Amne: SQL query Hallo TSMers, I think I've mentioned before, my SQL's not so hot. I'm practising all I can, although, I can't seem to crack this one, or others like it; I would like to find out (with SQL if possible, I could do it via script etc..
Nearline Storage
Hello, can anybody tell me where to find interesting information about nearline storage. Is anybody using nearline storage for novell by tsm? TSM = Novell Thx, Peter Schrijvers BASF-IT-Services NV
database restore
I'm about to restore a tsm database from one physical site to another. Now on the source/current site the tsm and database log volumes are on AIX raw logical volumes/lv's/non-fs. Now I want to restore this database to the target tsm server at the target site. I assume that all I have to do is create the logical volumes without a filesystem of equal or more size on the target system's disk. Then just type in the restore command as if I do when there file volumes? When I issue the dsmserv format command before the restore to initialize the volumes I usually type in a path of the file of the database and log volumes. I'm assuming all I have to do is replace those filenames with: /dev/rlvname for the database and log?. Is this a correct assumption?. Does anyone have any commands/docs on restoring a tsm database when it's on raw logical volumes? I can't find docs anywhere for that situation. Also if I decided I wanted the volumes to be files on mounted filesystems instead of rlvs, I'm assuming I just specify the volume destination as the mounted filesystem, during the actual database restore?. Thanks in advance.. --Justin Richard Bleistein
Re: SQL query
Thanks for the help :-), although the volumes count (unnamed[3] in your example output) is a total volume count, rather than a count of the volumes in that storage pool. But.. as I was reading your reply a friendly DBA came over with this piece of SQL; select a.stgpool_name,a.maxscratch,count(*) from stgpools a, volumes b where a.stgpool_name = b.stgpool_name and a.devclass = 'ULTRIUM1' group by a.stgpool_name,a.maxscratch To produce this output; STGPOOL_NAMEMAXSCRATCH Unnamed[3] -- --- --- ONSITE 30 4 ONSITE_MNT 150 90 ONSITE_MNT_OFF 20 9 PERFTEST20 6 RMM_ARCH_SHWD 20 6 RMM_COPY_SHWD 100 57 RMM_UNIX_SHWD 70 55 UKS_ARCH_SHWD 10 5 UKS_ONSITE 60 26 UKS_ONSITE_COLL 60 12 Just for comparison, this is what my previous SQL gives (with maxscratch in the group by clause as you added it) STGPOOL_NAMEMAXSCRATCH Unnamed[3] -- --- --- ONSITE 30 270 ONSITE_MNT 150 270 ONSITE_MNT_OFF 20 270 PERFTEST20 270 RMM_ARCHIVE270 RMM_ARCH_PHNX 20 270 RMM_ARCH_SHWD 20 270 RMM_COPY_PHNX 25 270 RMM_COPY_SHWD 100 270 RMM_DISKPOOL 270 RMM_RMAN_PHNX 40 270 RMM_RMAN_SHWD 40 270 RMM_UNIX_DISK 270 RMM_UNIX_PHNX 70 270 RMM_UNIX_SHWD 70 270 TEMP_DELPOOL 999 270 UKS_ARCHIVE270 UKS_ARCH_PHNX 10 270 UKS_ARCH_SHWD 10 270 UKS_COPY_PHNX 100 270 UKS_DISKPOOL 270 UKS_DISKPOOL_COLL 270 UKS_OFFSITE_COLL60 270 UKS_ONSITE 60 270 UKS_ONSITE_COLL 60 270 UNBOUND_DATA 270 You learn something new every day - I never knew you could get friendly DBA's ;P Thanks , Matt . -Original Message- From: Christian Svensson [EMAIL PROTECTED]@EME Sent: Friday, January 16, 2004 1:45 PM To: [EMAIL PROTECTED] Subject: SV: SQL query Hi Matt! I try your last select command but just only add stgpools.maxscratch in the end of your line. select stgpools.stgpool_name, stgpools.maxscratch,count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpools.stgpool_name, stgpools.maxscratch Result : STGPOOL_NAMEMAXSCRATCH Unnamed[3] -- --- --- ARCHIVEPOOL 11 BACKUPPOOL 11 COPYPOOL 3 11 DISKPOOL11 SPACEMGPOOL 11 TAPEPOOL11 11 /Christian -Ursprungligt meddelande- Fran: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Warren, Matthew (Retail) Skickat: den 16 januari 2004 14:30 Till: [EMAIL PROTECTED] Amne: Re: SQL query Hi Christian, Sorry, I may not have worded my problem very clearly. Using the follwing tables and columns; TABLENAMECOLNAME -- -- STGPOOLS STGPOOL_NAME STGPOOLSDEVCLASS STGPOOLS MAXSCRATCH VOLUMESSTGPOOL_NAME I would like to find out; For every stgpool that has a device class of ultrium1, I need to know the stgpool name, the maxscratch value ((IE: the maximum number of
Re: database restore
You can use raw devices for DB, log or stg volumes and there is no dsmserv format command needed. Just create the raw devices and then start to use them. No long wait to do format them... Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Justin Bleistein Sent: Friday, January 16, 2004 7:14 AM To: [EMAIL PROTECTED] Subject: database restore I'm about to restore a tsm database from one physical site to another. Now on the source/current site the tsm and database log volumes are on AIX raw logical volumes/lv's/non-fs. Now I want to restore this database to the target tsm server at the target site. I assume that all I have to do is create the logical volumes without a filesystem of equal or more size on the target system's disk. Then just type in the restore command as if I do when there file volumes? When I issue the dsmserv format command before the restore to initialize the volumes I usually type in a path of the file of the database and log volumes. I'm assuming all I have to do is replace those filenames with: /dev/rlvname for the database and log?. Is this a correct assumption?. Does anyone have any commands/docs on restoring a tsm database when it's on raw logical volumes? I can't find docs anywhere for that situation. Also if I decided I wanted the volumes to be files on mounted filesystems instead of rlvs, I'm assuming I just specify the volume destination as the mounted filesystem, during the actual database restore?. Thanks in advance.. --Justin Richard Bleistein
1 node, 2 servernames?
We have a situation where we are trying to use a single node name to access two differerent servername stanzas in dsm.sys. Both stanzas specify passwordaccess generate and use the same tcpserveraddress. This works fine until the password is automatically updated. Apparently there is a different password entry for each stanza and only one of them gets updated. So when an access is attempted using the other stanza, a password failure occurs. Anyone see a way around this other than using two different node names? David
Re: SQL query
Not sure if you noticed or not... you are trying to select columns in the stgpool table from the volumes table. select stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes where stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name try this one... SELECT STGPOOLS.STGPOOL_NAME, STGPOOLS.DEVCLASS, STGPOOLS.MAXSCRATCH, Count(VOLUMES.VOLUME_NAME) AS CountOfVOLUME_NAME FROM STGPOOLS LEFT JOIN VOLUMES ON STGPOOLS.STGPOOL_NAME = VOLUMES.STGPOOL_NAME GROUP BY STGPOOLS.STGPOOL_NAME, STGPOOLS.DEVCLASS, STGPOOLS.MAXSCRATCH HAVING (((STGPOOLS.DEVCLASS)='ULTRIUM1)); hope that helps, Cory *E-Mail Confidentiality Notice* This message (including any attachments) contains information intended for a specific individual(s) and purpose that may be privileged, confidential or otherwise protected from disclosure pursuant to applicable law. Any inappropriate use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalty. If you have received this transmission in error, please reply to the sender indicating this error and delete the transmission from your system immediately. [EMAIL PROTECTED] 01/16/04 08:29AM Hi Christian, Sorry, I may not have worded my problem very clearly. Using the follwing tables and columns; TABLENAMECOLNAME -- -- STGPOOLS STGPOOL_NAME STGPOOLSDEVCLASS STGPOOLS MAXSCRATCH VOLUMESSTGPOOL_NAME I would like to find out; For every stgpool that has a device class of ultrium1, I need to know the stgpool name, the maxscratch value ((IE: the maximum number of scratch tapes alolwed for use in the pool)) for the stgpool and a count of how many volumes are in the stgpool In case it helps (I doubt it :/ ) heres a copy of the latest attempt I made at trying to work it out; tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes where stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2940E The reference 'STGPOOLS.STGPOOL_NAME' is an unknown SQL column name. | ...V... select stgpools.stgpool_name, stgpools.maxscratch, count(*) fro ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2941E The column reference 'STGPOOL_NAME' matches more than one SQL column name. | .V. m volumes,stgpools where stgpool_name in (select stgpool_name f ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpool_name ANR2941E The column reference 'STGPOOL_NAME' matches more than one SQL column name. | ...V... from stgpools where devclass='ULTRIUM1' ) group by stgpool_name ANS8001I Return code 3. tsm: CARSINGTONselect stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes,stgpools where volumes.stgpool_name in (select stgpool_name from stgpools where devclass='ULTRIUM1') group by stgpools.stgpool_name ANR2938E The column 'MAXSCRATCH' is not allowed in this context; it must either be named in the GROUP BY clause or be nested within an aggregate function. | ..V select stgpools.stgpool_name, stgpools.maxscratch, count(*) fro ANS8001I Return code 3. tsm: CARSINGTONpull hair, gnash teeth -Original Message- From: Christian Svensson [EMAIL PROTECTED]@EME Sent: Friday, January 16, 2004 1:06 PM To: [EMAIL PROTECTED] Subject: SV: SQL query Hi Matt! Im not sure what you looking for. But maybe this helps you... Replace YOUR LTOCLASS NAME with the real Device class name. select stgpool_name,count(*) as Maxscratch from volumes where devclass_name='YOUR LTOCLASS NAME' /Christian -Ursprungligt meddelande- Fran: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Warren, Matthew (Retail) Skickat: den 16 januari 2004 13:03 Till: [EMAIL PROTECTED] Amne: SQL query Hallo TSMers,
Re: No Userids for Web Client
Thank you very much for the ideas on how to tackle this. Group admins would work best in our environment. On 1/15/04 1:54 PM, Prather, Wanda [EMAIL PROTECTED] wrote: The userid is not part of the client definition. (If you don't believe me, try: q node xxx, f=d). When you specify a userid during registration, in addition to registering the node, it creates an admin id. So for node 123456, which already exists: register admin 123456 password grant authority 123456 authority=owner node=123456 But you probably don't want to really do that. Who is doing the web based backup? If it is a PERSON who is going to be driving the backup for , say, server8 and server9 and server10, it's easier to register that PERSON as admin, and grant access authority to server8, server9, and server10. Then that person uses 1 id to do web backups restores. Hope that helps... -Original Message- From: Renee Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 2:17 PM To: [EMAIL PROTECTED] Subject: No Userids for Web Client In registering over 600 nodes for TSM, we registered them with userid=none. Years later, we now wish to implement the web based backup strategy, but that requires that each node have a userid. Is there anyway to update the existing nodes with userids? The update node command does not have that option. Renee Davis University of Houston
problem with drive
Hi what issue with drive state =UKNOWN ? all checkin and checkout operations failed (TSM V5.1 library 3583) please help me b.rds Joseph * Ce message et toutes les pieces jointes (ci-apres le message) sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. *
Re: TSM Connectivity issue
Mohan! Just to verify that your registry password has not expired, can you go to the command line and from the TSM prompt do: tsm q fi If it prompts you for a password or comes back with an error that would at least get this piece out of the way. HTH -- Aamir Subbu, Mohan (OFT) wrote: One of my tsm client(10.66.81.67) is able to ping the tsm server(10.70.113.60).But Iit is not able to connect with the TSM server using the TSM BA GUI.Till yesterday it was working fine. My dsm.opt file is configured correctly and no configurations were changed. I have the follwing errors in my tsm schedule log. What could be the problem? 01/15/2004 11:21:37 Querying server for next scheduled event. 01/15/2004 11:21:37 Node Name: OWANYSM0A1AB 01/15/2004 11:22:19 ANS1017E Session rejected: TCP/IP connection failure 01/15/2004 11:22:19 Will attempt to get schedule from server again in 10 minutes. 01/15/2004 11:32:19 Querying server for next scheduled event. 01/15/2004 11:32:19 Node Name: OWANYSM0A1AB 01/15/2004 11:33:01 ANS1017E Session rejected: TCP/IP connection failure 01/15/2004 11:33:01 Will attempt to get schedule from server again in 10 minutes. Thanks, Mohan
Re: 1 node, 2 servernames?
David! On UNIX clients there is a PASSWORDDIR directive which can be used in the dsm.sys to specify the location of the generated password. That way you will have files of your choice to store the generated password as opposed to using the default /etc/adsm/TSM.PWD file. HTH -- Aamir David E Ehresman wrote: We have a situation where we are trying to use a single node name to access two differerent servername stanzas in dsm.sys. Both stanzas specify passwordaccess generate and use the same tcpserveraddress. This works fine until the password is automatically updated. Apparently there is a different password entry for each stanza and only one of them gets updated. So when an access is attempted using the other stanza, a password failure occurs. Anyone see a way around this other than using two different node names? David
Problem retaining full path name with retrieve
I'm probably missing something obvious, but I can't figure out how to retrieve a file to a new directory while retaining the full path name, when the beginning of the path name is a mount point. (I don't know if my terminology is right--I'm new to the unix world). For example, I want to retrieve /usr/local/test2 to /export/home/usr/local/test2. If /usr is not a mount point, and the file is in the root filesystem, everything works fine. But if a filesystem is mounted on /usr, the retrieved file drops the /usr: dsmc retrieve -preser=complete -filelist=restflst /export/home/ Retrieving 24,968 /usr/local/test2 -- /export/home/local/test2 [Done] Client is TSM 5.1.1 on Solaris 8, server is ADSM 3.1.2.1 on OS/390. Thanks for any help.
RMAN type sbt_tape?
Hi, I am taking backup from tdp client of Oracle database,RMAN type should be sbt_tape? is it possible to I can specify type DISK.I want backup should go to diskpool and then data should migrate to tapepool.My copygroup- copy distination is pointing diskpool,but at the time of backup,it is asking tape?
Re: RMAN type sbt_tape?
You can set it type DISK but you will not get the results that you desire. Rman has no concept of TSM diskpool vs. tape - if you were to use type DISK the backup would go to your local disk (probably not what you want). I would recheck your management class settings for Oracle backups and make sure that they are indeed using the diskpool for it's destination, otherwise I would question your existing copygroup settings. Hi, I am taking backup from tdp client of Oracle database,RMAN type should be sbt_tape? is it possible to I can specify type DISK.I want backup should go to diskpool and then data should migrate to tapepool.My copygroup- copy distination is pointing diskpool,but at the time of backup,it is asking tape? Regards, Neil Rasmussen Software Development
Re: RMAN type sbt_tape?
I have two mgmt class in one policy domain,one is use for tdp for oracle(1,0,0,0)other mgmt is use for backup-archive client(7,1,60,90). If I change copygroup copy destination to tapepool,tdp backup works fine.but if i points it to diskpool,it still looks for tape and backup dont go on diskpool. may I need to change include parameter on dsm.sys. at present is is include * tdpmgmt On Sat, 17 Jan 2004 Neil Rasmussen wrote : You can set it type DISK but you will not get the results that you desire. Rman has no concept of TSM diskpool vs. tape - if you were to use type DISK the backup would go to your local disk (probably not what you want). I would recheck your management class settings for Oracle backups and make sure that they are indeed using the diskpool for it's destination, otherwise I would question your existing copygroup settings. Hi, I am taking backup from tdp client of Oracle database,RMAN type should be sbt_tape? is it possible to I can specify type DISK.I want backup should go to diskpool and then data should migrate to tapepool.My copygroup- copy distination is pointing diskpool,but at the time of backup,it is asking tape? Regards, Neil Rasmussen Software Development