Re: Occupancy discrepancy between 6.1.5.10 and 6.2.3.0 server
Jim, Re: I found I had to run 'audit licenses' to update the occupancy values. I have no idea why this would be the case. One always has to run 'audit lic' to update the auditoccupancy table. Keith
Re: TSM 6.2 SQL statement
TimeStampDiff is unknown... ANR2944E The reference 'TIMESTAMPDIFF' is an unknown SQL scalar function name. | .V. IZED , EST_CAPACITY_MB , TIMESTAMPDIFF ( 16 , CHAR ( current_ti This is the sql statement I tried: select SUBSTR(CAST(VOLUME_NAME AS char(10)),1,10) as VOLUME_NAME, \ SUBSTR(CAST(stgpool_name AS char(18)),1,18) as STG, PCT_UTILIZED, \ EST_CAPACITY_MB, \ TIMESTAMPDIFF(16,CHAR(current_timestamp-date(last_write_date))) as xdays, \ SUBSTR(CAST(status AS char(10)),1,10) as status, SUBSTR(CAST(access AS char(10)),1,10) as access, date(last_write_date) as Last_Write \ from volumes where status = 'FILLING' and access != 'UNAVAILABLE' and access = 'OFFSITE' and \ TIMESTAMPDIFF(16,CHAR(current_timestamp-date(last_write_date))) \ 60 order by last_write_date Thank you, Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ankur Patel Sent: Wednesday, March 07, 2012 7:35 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM 6.2 SQL statement Andy, Try this: select SUBSTR(CAST(VOLUME_NAME AS char(10)),1,10) as VOLUME_NAME, SUBSTR(CAST(stgpool_name AS char(18)),1,18) as STG, PCT_UTILIZED, EST_CAPACITY_MB, TIMESTAMPDIFF(16,CHAR(current_timestamp-date(last_write_date))) as xdays, SUBSTR(CAST(status AS char(10)),1,10) as status, SUBSTR(CAST(access AS char(10)),1,10) as access, date(last_write_date) as Last_Write from volumes where status = 'FILLING' and access != 'UNAVAILABLE' and access = 'OFFSITE' and TIMESTAMPDIFF(16,CHAR(current_timestamp-date(last_write_date))) \ 60 order by last_write_date regards, Ankur Patel -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Huebner,Andy,FORT WORTH,IT Sent: Thursday, 8 March 2012 8:40 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM 6.2 SQL statement We run this and other SQL statements that return dates in the form of days. This SQL query works on 5.4, but does not work on 6.2. I am hoping one of the more SQL savvy admins can quickly help me with this so I can fix the rest of the queries we use. The lines that don't work and I do not know how to translate are: (current_timestamp - last_write_date)days as Days and cast((current_timestamp - last_write_date)days as decimal(6,0)) \ 60 \ select volume_name, \ stgpool_name, PCT_UTILIZED, EST_CAPACITY_MB, \ (current_timestamp - last_write_date)days as Days, \ status, access, last_write_date, \ cast ((last_write_date) as date) as Last Write \ from volumes \ where status = 'FILLING' \ and access != 'UNAVAILABLE' and access = 'OFFSITE' \ and cast((current_timestamp - last_write_date)days as decimal(6,0)) \ 60 \ order by last_write_date Thanks, Andy Huebner This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you. This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.
Re: Occupancy discrepancy between 6.1.5.10 and 6.2.3.0 server
Do a set lic 1 - then your query auditoccupancy numbers a current to within 1 day as opposed to the default 30 days. That way, don't bother doing a manual audit lic. Also, the server option AUDITSTORAGE needs to be set to YES, which is the default (if you did nothing with this option, you did it right). Joerg Pohlmann +1-250-585-3711 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Keith Arbogast Sent: Thursday, March 08, 2012 05:31 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Occupancy discrepancy between 6.1.5.10 and 6.2.3.0 server Jim, Re: I found I had to run 'audit licenses' to update the occupancy values. I have no idea why this would be the case. One always has to run 'audit lic' to update the auditoccupancy table. Keith
tsm 6.3 server to server db bacvkup
Can one TSM 6.3 server send its DBBACKUP file to another server And vice versa. Thanks, Tim Brown Systems Specialist - Project Leader Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please notify the sender immediately by replying to this note and deleting all copies and attachments.
Re: TSM 6.2 SQL statement
This works on 6.2.3.1: select volume_name,stgpool_name,access,pct_utilized,est_capacity_mb, cast(day(current_timestamp-last_write_date) as decimal) as Days, status,access,last_write_date,substr(char(last_write_date),1,19) as Last Write from volumes where status='FILLING' and access!='UNAVAILABLE' and access='OFFSITE' and 60 cast(day(current_timestamp-last_write_date) as decimal) - Margaret -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Huebner,Andy,FORT WORTH,IT Sent: Wednesday, March 07, 2012 1:40 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM 6.2 SQL statement We run this and other SQL statements that return dates in the form of days. This SQL query works on 5.4, but does not work on 6.2. I am hoping one of the more SQL savvy admins can quickly help me with this so I can fix the rest of the queries we use. The lines that don't work and I do not know how to translate are: (current_timestamp - last_write_date)days as Days and cast((current_timestamp - last_write_date)days as decimal(6,0)) \ 60 \ select volume_name, \ stgpool_name, PCT_UTILIZED, EST_CAPACITY_MB, \ (current_timestamp - last_write_date)days as Days, \ status, access, last_write_date, \ cast ((last_write_date) as date) as Last Write \ from volumes \ where status = 'FILLING' \ and access != 'UNAVAILABLE' and access = 'OFFSITE' \ and cast((current_timestamp - last_write_date)days as decimal(6,0)) \ 60 \ order by last_write_date Thanks, Andy Huebner This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.
Re: tsm 6.3 server to server db bacvkup
yes, virtual volumes, just like tsm 5.5 On 8 mrt. 2012, at 20:12, Tim Brown wrote: Can one TSM 6.3 server send its DBBACKUP file to another server And vice versa. Thanks, Tim Brown Systems Specialist - Project Leader Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please notify the sender immediately by replying to this note and deleting all copies and attachments. -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
Server to server export problem
I'm having an issue with a server-server export from 5.4 on AIX to 6.3 on Linux. I'm getting verb errors. I probably need to either upgrade the source server or downgrade the destination. Does anyone know if server to server export from 5.5 to 6.3 works properly? The documentation on export compatibility is really lacking. Daniel Murphy-Olson Systems Administrator Mathematics Computer Science Division Argonne National Laboratory 630-252-0055
AW: [ADSM-L] Server to server export problem
After upgradng TSM V5 servers to lstest maintenance level including The Server Update package we have found no problems at all on exporting data to TSM V6.x servers. Without having the server upgrade package installed, in one situation I've got an error transferring non-unicode data. Ullrich Mänz Teamleader IBM System z FRITZ MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil: +49 170 7678434 Fax: +49 69 38013500 10 Web: http://www.fum.de Amtsgericht Ulm, Handelsregister-Nummer: HRB 1936 Geschäftsführer: Heribert Fritz, Frank Haines Inhaber: Imtech N.V., Gouda, Niederlande - Originalnachricht - Von: Dan Olson [dol...@mcs.anl.gov] Gesendet: 08.03.2012 23:03 CST An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] Server to server export problem I'm having an issue with a server-server export from 5.4 on AIX to 6.3 on Linux. I'm getting verb errors. I probably need to either upgrade the source server or downgrade the destination. Does anyone know if server to server export from 5.5 to 6.3 works properly? The documentation on export compatibility is really lacking. Daniel Murphy-Olson Systems Administrator Mathematics Computer Science Division Argonne National Laboratory 630-252-0055
