Re: Starting a incremental backup from the Server GUI??
Pending state means that the schedule will start soon. This state is entered when schedule time is passed but the schedule will start with random delay within startup window. If you want to change this behavior look for SET RANDOMIZE command. For example if the server is with default randomization of 25% and you have a schedule at 23:00 with default duration of 1 hour: - before 23:00 the schedule will be Future - after 23:00 but before actual start the schedule will be Pending - after actual start it will become Started and upon end will become Failed or Completed - if the client did not contacted the server between 23:00 and 23:15 the schedule will be Missed Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: Starting a incremental backup from the Server GUI?? Niklas Defining an immediate ClientAction should be the way to go! If it is showing 'pending' make sure the SCHEDULER service/daemon is running and if writing straight to tape that you have a drive free. It should be as simple as that! Also, try SCHEDMode PRompted as well! Regards, Demetrius Malbrough UNIX/TSM Administrator -Original Message- From: Niklas Lundstrom [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 4:05 AM To: [EMAIL PROTECTED] Subject: Starting a incremental backup from the Server GUI?? Hello Is it possible to start a client backup from the server? Now I have schedmode set to polling, but if the client misses the schedule I want to start a backup from the server instead of going to the client and starting it there. I've been looking at the immediate action schedules but the schedule don't seem to start, the schedule status is pending Regards Niklas Lundström
Re: TSM TDP for MS-SQL return codes
Hi ANR2579E is not a TDP SQL error, is a TSM server error and means: Schedule schedule name in domain domain name for node node name failed (return code return code). Explanation: This message is displayed when a client reports failure in executing a scheduled action. The return code reported by the client is displayed. System Action: Server operation continues. User Response: Examine the node's schedule log to determine the cause for the failure. There is a manual for these messages called Tivoli Storage Manager Message Version 4 Release 2. It located under manuals on Tivoli's site. Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Bergkällavägen 31D 192 79 SOLLENTUNA Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Zoltan Forray/AC/VCU [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2002-03-26 15:29 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:TSM TDP for MS-SQL return codes Got the following message: 03/25/2002 21:58:16 ANR2579E Schedule BACKUP.VCUCARD2.SQL in domain ADMINSYS for node VCUCARD2 failed (return code 402). Where do I find the explaination for these return codes ? I didn't see them in the TDP for MS-SQL book ? Haven't gotten the DS?ERROR.LOG files yet. Waiting for the user to send them to me ! Zoltan Forray Virginia Commonwealth University - University Computing Center e-mail: [EMAIL PROTECTED] - voice: 804-828-4807
Re: Starting a incremental backup from the Server GUI??
Hi Niklas A prerequisite to using immediate actions schedules are that you're using prompted mode on the scheduler, as the server has to contact the client. Immediate action schedules won't work with polling mode on the client. Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Bergkällavägen 31D 192 79 SOLLENTUNA Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Niklas Lundstrom [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2002-03-26 11:04 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Starting a incremental backup from the Server GUI?? Hello Is it possible to start a client backup from the server? Now I have schedmode set to polling, but if the client misses the schedule I want to start a backup from the server instead of going to the client and starting it there. I've been looking at the immediate action schedules but the schedule don't seem to start, the schedule status is pending Regards Niklas Lundström
TDP for Informix 4.1.3 - Errors when restoring Point-in-Time
Hi All, We use Informix 7.31UC7, TDP for Informix 4.1.3 and TSM Server 4.1 When we do a cold full resore (onbar -r -f dbslist) everything goes fine and after an onmode -m we restored the complete database. But when we do a cold point-in-time restore (onbar -r -n 20 -f dbsfile) the restore fails at the moment that onbar starts to restore the logical logs. Please help !! Thanks in Advance, Maurice van ´t Loo The Netherlands bar_act.log: 2002-03-26 17:41:31 17202 15856 Completed cold level 0 restore llog. 2002-03-26 17:41:31 17202 15856 Process 17202 15856 completed. 2002-03-26 17:42:30 19920 15856 Completed cold level 0 restore catdbs. 2002-03-26 17:42:30 19920 15856 Process 19920 15856 completed. 2002-03-26 17:42:30 15856 28438 ERROR: Unable to start the logical restore: A Point-In-Time Logical Restore is only permitted during a Full Restore. DBSpace 'blob_preview' was not recovered during this restore.. 2002-03-26 17:42:30 15856 28438 SQL -408 Invalid message type received from the sqlexec process. 2002-03-26 17:42:31 15856 28438 SQL -27002 No connections are allowed in Dynamic Server quiescent mode. 2002-03-26 17:42:33 15856 28438 SQL -27002 No connections are allowed in Dynamic Server quiescent mode. 2002-03-26 17:42:35 15856 28438 SQL -27002 No connections are allowed in Dynamic Server quiescent mode. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. **
Re: Documentation needed: Backing up through a firewall
Hi All you have to think about is the ports that has to be open. The ports used for TSM are 1500 for the server, 1501 for the client. These ports can be changed using the opt/sys file on your client/server. This would mean Allow from secure to non-secure 1501 Allow from non-secure to secure 1500 (if the client are located in the non-secure network). Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Bergkällavägen 31D 192 79 SOLLENTUNA Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Douglas Currell [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2002-03-26 11:41 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Documentation needed: Backing up through a firewall I need someone to point in the direction of documentation about configuring TSM to backup through a firewall. Installing the Clients and Using the BA Client have scant information about the process other than identifying the ports that need to be opened Thank you. - File your taxes online! Yahoo! Canada Tax Centre
Antwort: Elapsed processing time.
Do an search: q act search=ANE4964I begind=today-1 endd=today Oliver Zosimo Noriega znoriega@ADNOC. An: [EMAIL PROTECTED] COM Kopie: Gesendet von:Thema: Elapsed processing time. ADSM: Dist Stor Manager [EMAIL PROTECTED] T.EDU 27.03.02 07:13 Bitte antworten an ADSM: Dist Stor Manager Hi All, How can i find the Elapsed Processing Time of nodes instead from the dsmsched.log file? Are those related information stored in the database? Thanks for your help in advance. Zosi Noriega ADNOC - UAE
test - ignore this
sorry ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. **
Re: Backup failure msg=ans4028e
Hi Joni! If I remember correctly I have seen this error when the permissions on the root of the F: drive are gone. Check whether the SYSTEM account (or whatever other account you use for TSM) has read permission on F:\. I've had a drive with the permissions removed from just the root of the drive, not from the subdirectories. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 19:58 To: [EMAIL PROTECTED] Subject: Backup failure msg=ans4028e Hello, A client is trying to do an incremental backup and part of the way through backing up the F drive it receives the message ans4028e 03/25/2002 23:16:06 ANS1898I * Processed 366,500 files * 03/25/2002 23:16:14 ANS1898I * Processed 367,000 files * 03/25/2002 23:16:19 ANS4028E Error processing 'F:': cannot create file/directory entry 03/25/2002 23:16:19 Incremental backup of volume 'X:' 03/25/2002 23:16:21 ANS1898I * Processed 367,500 files * 03/25/2002 23:16:27 ANS1898I * Processed 368,000 files * 03/25/2002 23:16:40 ANS1898I * Processed 368,500 files * 03/25/2002 23:16:40 ANS1898I * Processed 369,000 files * 03/25/2002 23:16:41 Successful incremental backup of 'X:' It then stops backing up the F drive and continues on with other backups. The message manual says: ANE4028E Error processing 'filespace namepath-namefile-name': cannot create file/directory entry Explanation: The directory path for files being restored or retrieved cannot be created. Does anyone know what may be causing this error to occur? Thanks!! Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338 ** 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. **
Who needs TDP for Oracle on Linux ?
Hi TSM'ers Our Company needs the TDP Module for Oracle on (SuSE-) Linux urgently. All that I#ve heard from Tivoli is, that the product is part of the planned 2.2.2 release which is currently targeted for 1Q03. Please can everybody reply to this mail who has the same needs. Iwould like to collect the answers and forward it to TIVOLI, to increase the pressure... -- With regards / Mit freundlichen Grüßen Leopold Hameder | Heinrich Bauer Produktions KG PSC | email: [EMAIL PROTECTED]| | Abteilung Server Concepts| phone: 040 - 3019 - 5675 | | Burchardstr. 11, 20077 Hamburg | fax: 040 - 3019 - 5668 |
3583 LTO drive time out
Has anyone seen any problems on the 3583 using the SDG module. I connect fine using the TSM drivers but when I try to label a tape it loads and then times out after a minute or 2. Are there any special parms that anyone is aware of. I have had no problems with the SCSI attached 3583.
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Matt, What do you do to execute the select command in the z/OS environment? -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:15 AM To: [EMAIL PROTECTED] Subject: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Hello all, I am trying to write a simple script that shows the nodes that were not accessed by TSM for more than x days and then do an E-mail notification from there. I AM RUNNING TSM 4.1.5 on z/OS 1.1. The select command to get the node name, last access date, and contact name (the e-mail address) seems easy enough. BUT I want the output from this to be in one line, preferably with fixed position or filed lengths. ( I will be using SAS processing to setup the job that will actually do the EMAIL). I have tried the approach documented in the 3rd chapter of the TSM Refernece manual but I can not get the desired results. It always comes back with the output for 1 node with last access and contact name using two lines. Has anyone ever had any success with this in OS390 environment? I could go a long way with an example . Thanks Matt Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Hello all, I am trying to write a simple script that shows the nodes that were not accessed by TSM for more than x days and then do an E-mail notification from there. I AM RUNNING TSM 4.1.5 on z/OS 1.1. The select command to get the node name, last access date, and contact name (the e-mail address) seems easy enough. BUT I want the output from this to be in one line, preferably with fixed position or filed lengths. ( I will be using SAS processing to setup the job that will actually do the EMAIL). I have tried the approach documented in the 3rd chapter of the TSM Refernece manual but I can not get the desired results. It always comes back with the output for 1 node with last access and contact name using two lines. Has anyone ever had any success with this in OS390 environment? I could go a long way with an example . Thanks Matt
TSM Crashed
I'm running TSM 4.1.3.2 on AIX 4.3.3 ML8. Last night TSM crashed with this error in the dsmserv.err: 03/26/2002 20:07:07 ANR7838S Server operation terminated. 03/26/2002 20:07:08 ANR7837S Internal error TMTXN008 detected. 03/26/2002 20:07:08 ANR7834S Thread 88 (tid 5800) terminating on signal 11 (Segmentation violation). 03/26/2002 20:07:08 ANR7834S GPR 0: 0xd0019580, 1: 0x44d51fb0, 2: 0x301976a0, 3: 0x 03/26/2002 20:07:08 ANR7834S GPR 4: 0x44d533c8, 5: 0x0008, 6: 0x0003, 7: 0x 03/26/2002 20:07:08 ANR7834S GPR 8: 0x1000733b, 9: 0x1000733b, 10: 0xf0045e04, 11: 0x43dc6ae4 03/26/2002 20:07:08 ANR7834S GPR 12: 0x1000f10c, 13: 0x43c53820, 14: 0x0170, 15: 0x 03/26/2002 20:07:08 ANR7834S GPR 16: 0x, 17: 0x000a, 18: 0x0004, 19: 0x0018 03/26/2002 20:07:08 ANR7834S GPR 20: 0x0002, 21: 0xf0004800, 22: 0x0006, 23: 0x81810174 03/26/2002 20:07:08 ANR7834S GPR 24: 0x44d52068, 25: 0x1e9d, 26: 0x44d52068, 27: 0x1004a294 03/26/2002 20:07:08 ANR7834S GPR 28: 0x0001, 29: 0x0053, 30: 0x, 31: 0x300356c0 03/26/2002 20:07:08 ANR7834S IAR: 0x1000f11c LR: 0x1000f10c CONTEXT: 0x44d51c30 03/26/2002 20:07:08 ANR7833S Server thread 1 terminated in response to program abort. Any ideas what this means why it happened? Thanks, Bruce Kamp Network Analyst II Memorial Healthcare System Ph: (954) 987-2020 x4597 Fax: (954) 985-1404 E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
4.2.1.8 Server core dump
Hi *SM-ers! My TSM server (4.2.1.8 on AIX 4.3.3 ml8)crashed after running stable for a month. It just stopped with no info in the actlog. I just see a core and this error in the dsmserv.err: ANR7834S Thread 49 (tid 3151) terminating on signal 11 (Segmentation violation). ANR7834S GPR 0: 0x0020, 1: 0x366ac1e0, 2: 0x30214148, 3: 0x ANR7834S GPR 4: 0x366ac349, 5: 0x, 6: 0x0052, 7: 0x366ac5c0 ANR7834S GPR 8: 0x, 9: 0x, 10: 0x7f7f7f7f, 11: 0x0003 ANR7834S GPR 12: 0x, 13: 0x35c6d8f0, 14: 0x366ad20c, 15: 0x0005 ANR7834S GPR 16: 0x0004, 17: 0x301fb450, 18: 0x0001, 19: 0x3000502c ANR7834S GPR 20: 0x, 21: 0x0001, 22: 0x, 23: 0x0001 ANR7834S GPR 24: 0x, 25: 0x, 26: 0x0001, 27: 0x366ac654 ANR7834S GPR 28: 0x366ac658, 29: 0x, 30: 0x366ac660, 31: 0x300c16a8 ANR7834S IAR: 0x1000603c LR: 0x101053c8 CONTEXT: 0x366abe60 I know there is a higher server level available, but I cannot find any indication that my crash is related to any of the listed fixed APAR's. Anybody seen this too? Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** 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. **
Re: Backup failure msg=ans4028e
Thanks for your help Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338 Loon, E.J. van - SPLXM To: [EMAIL PROTECTED] Eric-van.Loon cc: @KLM.COMSubject: Re: Backup failure msg=ans4028e Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 03/27/2002 05:42 AM Please respond to ADSM: Dist Stor Manager Hi Joni! If I remember correctly I have seen this error when the permissions on the root of the F: drive are gone. Check whether the SYSTEM account (or whatever other account you use for TSM) has read permission on F:\. I've had a drive with the permissions removed from just the root of the drive, not from the subdirectories. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 19:58 To: [EMAIL PROTECTED] Subject: Backup failure msg=ans4028e Hello, A client is trying to do an incremental backup and part of the way through backing up the F drive it receives the message ans4028e 03/25/2002 23:16:06 ANS1898I * Processed 366,500 files * 03/25/2002 23:16:14 ANS1898I * Processed 367,000 files * 03/25/2002 23:16:19 ANS4028E Error processing 'F:': cannot create file/directory entry 03/25/2002 23:16:19 Incremental backup of volume 'X:' 03/25/2002 23:16:21 ANS1898I * Processed 367,500 files * 03/25/2002 23:16:27 ANS1898I * Processed 368,000 files * 03/25/2002 23:16:40 ANS1898I * Processed 368,500 files * 03/25/2002 23:16:40 ANS1898I * Processed 369,000 files * 03/25/2002 23:16:41 Successful incremental backup of 'X:' It then stops backing up the F drive and continues on with other backups. The message manual says: ANE4028E Error processing 'filespace namepath-namefile-name': cannot create file/directory entry Explanation: The directory path for files being restored or retrieved cannot be created. Does anyone know what may be causing this error to occur? Thanks!! Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338 ** 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. **
Re: Patch levels.. Confused..
IC29368 was fixed in both 4.1.3 and 4.2.0. 4.2.0. If you scroll to to the top of the APARs fixed section in the 4.2.1.15 (and 4.2.1.28) README files, you'll see that it says something like, APARs resolved in 4.2.0. Apparently the README file for the 4.2.1.x patches got mixed up (at least in part) with the 4.2.0 README file content. Check the 4.2.1.0 README for the correct list of APARs fixed at the 4.2.1.0 level. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Bob Booth - UIUC [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/26/2002 21:29 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Patch levels.. Confused.. I had a user come to me today with an error message. On a Solaris 5.8 system running 4.2.1 client code, they get a ANS1074I *** User Abort *** After the backup is completed (after the statistics line). I looked at the patches, and in 4.2.1.15 I found references to in APARS resolved from 4.1.2 code. One of the APARS referenced erroneous ANS1074I messages. I went to tivoli support, and referenced APAR IC29368 Error Description: At the 4.1.2 Client an 'User Abort' message is issued in error after an error message is generated by the client. The message is not specific to a certain error. This problem does not occur on previous level of client code. In the example below a 'User Abort' message is being generated after each error. In previous version of the client the 'User Abort' was not generate. *text deleted* (that is some of the actual text from cut and paste). So my question is this, what code base is 4.2.1.15 based on? Is this actually a patch to 4.2.1 code, or is it a repatch of 4.1.2 code, or did tivoli interpose 4.1.2 with 4.2.1 throughout the readme and APAR references? Can someone explain what I should tell my clients? Actually, I am not even sure if this APAR addresses our problem, but I pretty sure, this is not a serious issue. thanks, bob
Re: Who needs TDP for Oracle on Linux ?
Add me to the list. However, I heard that it is target to be included in the TSM 5.x announcement, coming up soon ! Zoltan Forray Virginia Commonwealth University - University Computing Center e-mail: [EMAIL PROTECTED] - voice: 804-828-4807 Leopold Hameder [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/27/2002 07:24 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Who needs TDP for Oracle on Linux ? Hi TSM'ers Our Company needs the TDP Module for Oracle on (SuSE-) Linux urgently. All that I#ve heard from Tivoli is, that the product is part of the planned 2.2.2 release which is currently targeted for 1Q03. Please can everybody reply to this mail who has the same needs. Iwould like to collect the answers and forward it to TIVOLI, to increase the pressure... -- With regards / Mit freundlichen Grüßen Leopold Hameder | Heinrich Bauer Produktions KG PSC | email: [EMAIL PROTECTED]| | Abteilung Server Concepts| phone: 040 - 3019 - 5675 | | Burchardstr. 11, 20077 Hamburg | fax: 040 - 3019 - 5668 |
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Ike, I am running the following batch job. I added the -TAB and tried -OUTFILE with a redirect in the macro to the data set and that didn't work either. So I tried a few different variation of the above and even went back to adding a / after the ADSMC as the book says. None of it made a difference. It always came back with the output looking the same. Ideally I would want just the needed fields, with fixed length 1 per line. Matt THE JOB. //TSMJOB1 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=SYS1.CEE.SCEERUN, // DISP=SHR //DSCLANG DD DSN=SYS1.TSM.SANSMSG(ANSMENU),DISP=SHR //DSCOPT DD DSN=AGPP.TSM.TSOADMIN.OPTIONS,DISP=SHR //SYSHELP DD DSN=SYS1.TCPIP.SEZAHELP,DISP=SHR //SYSIN DD DUMMY //D1 DD DSN=AGPP.TSM.INACTIVE.NODES,DISP=SHR //SYSTSIN DD * DSMADMC -ID=ADMINJOB -PASSWORD= -OUTFILE=DD:D1 MACRO DD:D2 -TAB //D2 DD * select node_name,lastacc_time,contact from nodes where - cast((current_timestamp-lastacc_time)days as - decimal) = 7 /* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* THE OUTPUT FILE ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.7 (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved. ANS8000I Server command: 'select node_name,lastacc_time,contact from nodes where NODE_NAMELASTACC_TIMECONTACT ---- -- DTE-1710 2002-03-15Dan 09:28:26.00 Harrison/Desktop DTE-1720 2002-03-15SUE 23:27:49.00NEBINGER/DESKTOP -Original Message- From: Hunley, Ike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Matt, What do you do to execute the select command in the z/OS environment? -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:15 AM To: [EMAIL PROTECTED] Subject: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Hello all, I am trying to write a simple script that shows the nodes that were not accessed by TSM for more than x days and then do an E-mail notification from there. I AM RUNNING TSM 4.1.5 on z/OS 1.1. The select command to get the node name, last access date, and contact name (the e-mail address) seems easy enough. BUT I want the output from this to be in one line, preferably with fixed position or filed lengths. ( I will be using SAS processing to setup the job that will actually do the EMAIL). I have tried the approach documented in the 3rd chapter of the TSM Refernece manual but I can not get the desired results. It always comes back with the output for 1 node with last access and contact name using two lines. Has anyone ever had any success with this in OS390 environment? I could go a long way with an example . Thanks Matt Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: 4.2.1.8 Server core dump
E.J. I assume that it is back up and running now, but check in the actlog to see what process were running right before the crash (expiration, reclamation, migration, etc...). Also, check the size of your recovery log db to make sure they are NOT reaching the MAXIMUM % UTIL! Regards, Demetrius Malbrough UNIX/TSM Administrator -Original Message- From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:54 AM To: [EMAIL PROTECTED] Subject: 4.2.1.8 Server core dump Hi *SM-ers! My TSM server (4.2.1.8 on AIX 4.3.3 ml8)crashed after running stable for a month. It just stopped with no info in the actlog. I just see a core and this error in the dsmserv.err: ANR7834S Thread 49 (tid 3151) terminating on signal 11 (Segmentation violation). ANR7834S GPR 0: 0x0020, 1: 0x366ac1e0, 2: 0x30214148, 3: 0x ANR7834S GPR 4: 0x366ac349, 5: 0x, 6: 0x0052, 7: 0x366ac5c0 ANR7834S GPR 8: 0x, 9: 0x, 10: 0x7f7f7f7f, 11: 0x0003 ANR7834S GPR 12: 0x, 13: 0x35c6d8f0, 14: 0x366ad20c, 15: 0x0005 ANR7834S GPR 16: 0x0004, 17: 0x301fb450, 18: 0x0001, 19: 0x3000502c ANR7834S GPR 20: 0x, 21: 0x0001, 22: 0x, 23: 0x0001 ANR7834S GPR 24: 0x, 25: 0x, 26: 0x0001, 27: 0x366ac654 ANR7834S GPR 28: 0x366ac658, 29: 0x, 30: 0x366ac660, 31: 0x300c16a8 ANR7834S IAR: 0x1000603c LR: 0x101053c8 CONTEXT: 0x366abe60 I know there is a higher server level available, but I cannot find any indication that my crash is related to any of the listed fixed APAR's. Anybody seen this too? Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** 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. **
Re: TSM Crashed
Bruce, I'm running TSM 4.1.3.2 on AIX 4.3.3 ML8. Last night TSM crashed with this error in the dsmserv.err: Any ideas what this means why it happened? We had the same problems with 4.1.3.X, server crashed nearly every day, sometimes every 4 hours, and went immediatly to 4.2.1.X. We'r now on 4.2.1.11 and our server is now running quite well. Cheers, Henk ten Have.
Re: LANFREE Backups - Feedback?
If a customer wants to buy AIX box or ESS most of the times he/she will prefer to get the other instead of going into multi-vendor implementation. If Sun allow customers to get ESS attached to their boxes too often they may also loose box sales. For this reasons AIX/ESS and Sun/EMC are usually bundled together. AIX/EMC or Sun/ESS are much more rarely used. I've not seen any market research what is the percentage of AIX/ESS vs. Sun/ESS or Sun/EMC vs. Sun/ESS but would expect it can be 8:1 or similar. It was already pointed in this thread that sales of TDP for EMC/Sun or TDP for ESS/AIX are not so high. And we cannot expect efforts to be wasted on less prospective area. Paul, had you any success with product development manager ? Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: LANFREE Backups - Feedback? Tivoli has sold so few copies of this that they have no justification to develop the other options right now. I need the ESS/Solaris option. Maybe the prevalence of SAN now will change this story. I will talk to the product development manager again tomorrow about this issue. -Original Message- From: Bill Mansfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 11:05 PM To: [EMAIL PROTECTED] Subject: Re: LANFREE Backups - Feedback? I thought the restriction was that both the Production database server and Backup server (where the BCVs get mounted) had to be Solaris, but that the TSM server could be on a third server of any type. _ William Mansfield Senior Consultant Solution Technology, Inc Denis L'Huillier [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/05/2002 09:29 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: LANFREE Backups - Feedback? Jason, I completely agree with you. The majority of our databases are running on Solaris attached to EMC. But, I think that the percentage of TSM Servers running on Solaris versus running on AIX is a lot more for AIX. I would venture to say that AIX is the preferred operating system for TSM. This, I feel is the limitation. Not the fact that it's Solaris only, but the fact that TSM will not work with TDP for EMC if TSM is running on AIX. It has to be running on Solaris. Regards, Denis L. L'Huiller 973-360-7739 [EMAIL PROTECTED] Enterprise Storage Forms - http://admpwb01/misc/misc/storage_forms_main.html J Bamford tsmtech@BLUEYONTo: [EMAIL PROTECTED] DER.CO.UK cc: Sent by: ADSM: Subject: Re: LANFREE Backups - Feedback? Dist Stor Manager [EMAIL PROTECTED] T.EDU 03/05/2002 10:18 AM Please respond to ADSM: Dist Stor Manager Yes I believe when Tivoli looked at the development of the Timefinder function they looked at the market first. It was concluded that an EMC/Sun solution represented the larger market share of what customer have installed. ie there are more EMC/Sun installed sites than there are EMC/Aix sites.Mainly because Aix sites tend to be IBM disk solutions. Therefore if you wnat to sell a product, develop for the majority first. If people like it and want it so make some more ! Vendors do make software for there own products, so hopefully I see you purchasing lots of ESS soon then !! There's little point in doing costly developing for a product that no one wants. Yes the TDP for EMC has a VERY limited scole for configuration, and no RS/6000 isn't in there I believe. Specific products like this tend to be demand driven. From what I understand the current TDP/EMC saw a very limited uptake by customers. There has also been little demand to expand is platform coverage in this space. The TDP for EMC was also on the market before the TDP for ESS/Flashcopy. Thinking back I believe that is because EMC had the timefinder on the market before IBM/ESS and flashcopy. It was a while after before Tivoli got it's hands on working Flashcopy to do any sort of development, and these thing take time. Back to the original point LAN-Free with TSM works backup and restore apart from the above, and I'm running a 2 day workshop in the UK next week to show it working and give hands on to those who want to know more. Jason PS. These are my personal views and not that of IBM or Tivoli Corp. - Original Message - From: Denis L'Huillier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 2:37 PM Subject: Re: LANFREE Backups - Feedback? Also, as an fyi... Tivoli also informed us that TDP for oracle on EMC is not supported when TSM
Re: TSM Crashed
Hi Bruce 1 here is an extract from ADSM/TSM Quick Facts by Richard Sims (http://people.bu.edu/rbs/ADSM.funcdir) Segmentation violation (Segfault) Also known as Signal 11 (SIGSEGV). Program failure in Unix caused a programming error: the program attempts to write to a region of memory to which it does not have access, as in writing past the end of an array due to failure to check bounds. You need to upgrade to a level of the program where the defect is fixed. You may be able to temporarily avoid the failure if you can identify the circumstances under which it occurs and stay away from that scenario. Bruce Kamp wrote: I'm running TSM 4.1.3.2 on AIX 4.3.3 ML8. Last night TSM crashed with this error in the dsmserv.err: 03/26/2002 20:07:07 ANR7838S Server operation terminated. 03/26/2002 20:07:08 ANR7837S Internal error TMTXN008 detected. 03/26/2002 20:07:08 ANR7834S Thread 88 (tid 5800) terminating on signal 11 (Segmentation violation). 03/26/2002 20:07:08 ANR7834S GPR 0: 0xd0019580, 1: 0x44d51fb0, 2: 0x301976a0, 3: 0x 03/26/2002 20:07:08 ANR7834S GPR 4: 0x44d533c8, 5: 0x0008, 6: 0x0003, 7: 0x 03/26/2002 20:07:08 ANR7834S GPR 8: 0x1000733b, 9: 0x1000733b, 10: 0xf0045e04, 11: 0x43dc6ae4 03/26/2002 20:07:08 ANR7834S GPR 12: 0x1000f10c, 13: 0x43c53820, 14: 0x0170, 15: 0x 03/26/2002 20:07:08 ANR7834S GPR 16: 0x, 17: 0x000a, 18: 0x0004, 19: 0x0018 03/26/2002 20:07:08 ANR7834S GPR 20: 0x0002, 21: 0xf0004800, 22: 0x0006, 23: 0x81810174 03/26/2002 20:07:08 ANR7834S GPR 24: 0x44d52068, 25: 0x1e9d, 26: 0x44d52068, 27: 0x1004a294 03/26/2002 20:07:08 ANR7834S GPR 28: 0x0001, 29: 0x0053, 30: 0x, 31: 0x300356c0 03/26/2002 20:07:08 ANR7834S IAR: 0x1000f11c LR: 0x1000f10c CONTEXT: 0x44d51c30 03/26/2002 20:07:08 ANR7833S Server thread 1 terminated in response to program abort. Any ideas what this means why it happened? Thanks, Bruce Kamp Network Analyst II Memorial Healthcare System Ph: (954) 987-2020 x4597 Fax: (954) 985-1404 E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- With regards / Mit freundlichen Grüßen Leopold Hameder | Heinrich Bauer Produktions KG PSC | email: [EMAIL PROTECTED]| | Abteilung Server Concepts| phone: 040 - 3019 - 5675 | | Burchardstr. 11, 20077 Hamburg | fax: 040 - 3019 - 5668 |
Re: TSM Crashed
Hi Bruce! This could be APAR IC30942/PQ48666. This one is fixed in 4.1.4.0 and higher. 4.1.4.5 is the highest 4.1 level available for download. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Bruce Kamp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 14:41 To: [EMAIL PROTECTED] Subject: TSM Crashed I'm running TSM 4.1.3.2 on AIX 4.3.3 ML8. Last night TSM crashed with this error in the dsmserv.err: 03/26/2002 20:07:07 ANR7838S Server operation terminated. 03/26/2002 20:07:08 ANR7837S Internal error TMTXN008 detected. 03/26/2002 20:07:08 ANR7834S Thread 88 (tid 5800) terminating on signal 11 (Segmentation violation). 03/26/2002 20:07:08 ANR7834S GPR 0: 0xd0019580, 1: 0x44d51fb0, 2: 0x301976a0, 3: 0x 03/26/2002 20:07:08 ANR7834S GPR 4: 0x44d533c8, 5: 0x0008, 6: 0x0003, 7: 0x 03/26/2002 20:07:08 ANR7834S GPR 8: 0x1000733b, 9: 0x1000733b, 10: 0xf0045e04, 11: 0x43dc6ae4 03/26/2002 20:07:08 ANR7834S GPR 12: 0x1000f10c, 13: 0x43c53820, 14: 0x0170, 15: 0x 03/26/2002 20:07:08 ANR7834S GPR 16: 0x, 17: 0x000a, 18: 0x0004, 19: 0x0018 03/26/2002 20:07:08 ANR7834S GPR 20: 0x0002, 21: 0xf0004800, 22: 0x0006, 23: 0x81810174 03/26/2002 20:07:08 ANR7834S GPR 24: 0x44d52068, 25: 0x1e9d, 26: 0x44d52068, 27: 0x1004a294 03/26/2002 20:07:08 ANR7834S GPR 28: 0x0001, 29: 0x0053, 30: 0x, 31: 0x300356c0 03/26/2002 20:07:08 ANR7834S IAR: 0x1000f11c LR: 0x1000f10c CONTEXT: 0x44d51c30 03/26/2002 20:07:08 ANR7833S Server thread 1 terminated in response to program abort. Any ideas what this means why it happened? Thanks, Bruce Kamp Network Analyst II Memorial Healthcare System Ph: (954) 987-2020 x4597 Fax: (954) 985-1404 E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ** 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. **
win2k tsm client 4.2.1.30 bug
Hi, The tsm client for windows 2000 4.2.1.30 is crashing when i try to backup a folder or volume that has drive shortcuts example D: Are you having the same problem? Is there a cure for it? Regards, Burak
Re: RH Linux 7.1 automounted filespaces
What type of filesystem are you automounting? ( NFS, CDs? ) -ed [EMAIL PROTECTED] 2002/03/26 05:41:37 PM ...excuse me, I forgot to mention the TSM client level is 4.2.1 and Server AIX 4.3 TSM 4.1.4.0. Thanks.
Re: TSM Crashed
FYI At 05:04 PM 3/27/2002 +0100, you wrote: Hi Bruce 1 here is an extract from ADSM/TSM Quick Facts by Richard Sims (http://people.bu.edu/rbs/ADSM.funcdir) Segmentation violation (Segfault) Also known as Signal 11 (SIGSEGV). Program failure in Unix caused a programming error: the program attempts to write to a region of memory to which it does not have access, as in writing past the end of an array due to failure to check bounds. You need to upgrade to a level of the program where the defect is fixed. You may be able to temporarily avoid the failure if you can identify the circumstances under which it occurs and stay away from that scenario. Bruce Kamp wrote: I'm running TSM 4.1.3.2 on AIX 4.3.3 ML8. Last night TSM crashed with this error in the dsmserv.err: 03/26/2002 20:07:07 ANR7838S Server operation terminated. 03/26/2002 20:07:08 ANR7837S Internal error TMTXN008 detected. 03/26/2002 20:07:08 ANR7834S Thread 88 (tid 5800) terminating on signal 11 (Segmentation violation). 03/26/2002 20:07:08 ANR7834S GPR 0: 0xd0019580, 1: 0x44d51fb0, 2: 0x301976a0, 3: 0x 03/26/2002 20:07:08 ANR7834S GPR 4: 0x44d533c8, 5: 0x0008, 6: 0x0003, 7: 0x 03/26/2002 20:07:08 ANR7834S GPR 8: 0x1000733b, 9: 0x1000733b, 10: 0xf0045e04, 11: 0x43dc6ae4 03/26/2002 20:07:08 ANR7834S GPR 12: 0x1000f10c, 13: 0x43c53820, 14: 0x0170, 15: 0x 03/26/2002 20:07:08 ANR7834S GPR 16: 0x, 17: 0x000a, 18: 0x0004, 19: 0x0018 03/26/2002 20:07:08 ANR7834S GPR 20: 0x0002, 21: 0xf0004800, 22: 0x0006, 23: 0x81810174 03/26/2002 20:07:08 ANR7834S GPR 24: 0x44d52068, 25: 0x1e9d, 26: 0x44d52068, 27: 0x1004a294 03/26/2002 20:07:08 ANR7834S GPR 28: 0x0001, 29: 0x0053, 30: 0x, 31: 0x300356c0 03/26/2002 20:07:08 ANR7834S IAR: 0x1000f11c LR: 0x1000f10c CONTEXT: 0x44d51c30 03/26/2002 20:07:08 ANR7833S Server thread 1 terminated in response to program abort. Any ideas what this means why it happened? Thanks, Bruce Kamp Network Analyst II Memorial Healthcare System Ph: (954) 987-2020 x4597 Fax: (954) 985-1404 E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- With regards / Mit freundlichen Grüßen Leopold Hameder | Heinrich Bauer Produktions KG PSC | email: [EMAIL PROTECTED]| | Abteilung Server Concepts| phone: 040 - 3019 - 5675 | | Burchardstr. 11, 20077 Hamburg | fax: 040 - 3019 - 5668 |
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Hello Matt, remove the -TAB and use -DISPLAY=LIST instead. I believe this is what you are looking for. - Rejean Larivee IBM TSM/ADSM Level 2 Support MC Matt Cooper (2838) To: [EMAIL PROTECTED] Matt.Cooper@AMGREcc: ETINGS.COM Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] EDU 03/27/2002 11:00 AM Please respond to ADSM: Dist Stor Manager Ike, I am running the following batch job. I added the -TAB and tried -OUTFILE with a redirect in the macro to the data set and that didn't work either. So I tried a few different variation of the above and even went back to adding a / after the ADSMC as the book says. None of it made a difference. It always came back with the output looking the same. Ideally I would want just the needed fields, with fixed length 1 per line. Matt THE JOB. //TSMJOB1 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=SYS1.CEE.SCEERUN, // DISP=SHR //DSCLANG DD DSN=SYS1.TSM.SANSMSG(ANSMENU),DISP=SHR //DSCOPT DD DSN=AGPP.TSM.TSOADMIN.OPTIONS,DISP=SHR //SYSHELP DD DSN=SYS1.TCPIP.SEZAHELP,DISP=SHR //SYSIN DD DUMMY //D1 DD DSN=AGPP.TSM.INACTIVE.NODES,DISP=SHR //SYSTSIN DD * DSMADMC -ID=ADMINJOB -PASSWORD= -OUTFILE=DD:D1 MACRO DD:D2 -TAB //D2 DD * select node_name,lastacc_time,contact from nodes where - cast((current_timestamp-lastacc_time)days as - decimal) = 7 /* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* THE OUTPUT FILE ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.7 (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved. ANS8000I Server command: 'select node_name,lastacc_time,contact from nodes where NODE_NAMELASTACC_TIMECONTACT ---- -- DTE-1710 2002-03-15Dan 09:28:26.00 Harrison/Desktop DTE-1720 2002-03-15SUE 23:27:49.00NEBINGER/DESKTOP -Original Message- From: Hunley, Ike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Matt, What do you do to execute the select command in the z/OS environment? -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:15 AM To: [EMAIL PROTECTED] Subject: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Hello all, I am trying to write a simple script that shows the nodes that were not accessed by TSM for more than x days and then do an E-mail notification from there. I AM RUNNING TSM 4.1.5 on z/OS 1.1. The select command to get the node name, last access date, and contact name (the e-mail address) seems easy enough. BUT I want the output from this to be in one line, preferably with fixed position or filed lengths. ( I will be using SAS processing to setup the job that will actually do the EMAIL). I have tried the approach documented in the 3rd chapter of the TSM Refernece manual but I can not get the desired results. It always comes back with the output for 1 node with last access and contact name using two lines. Has anyone ever had any success with this in OS390 environment? I could go a long way with an example . Thanks Matt Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Mount point reserved
I have fairly new TSM server 4.2.1.9 on AIX 4.3.3. with 3584 library. I just did first ARCHIVE from a client. Doing a q mount now shows: ANR8376I Mount point reserved in device class LTO, status: RESERVED. at end of display. Archive is finished over an hour now and this message still shows up. I only have a ONE minute mount retention set up for tape. How do I get rid of the RESERVED mount point? I didn't have this with old 3.7.4.0 server. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5525 [EMAIL PROTECTED] MMS health-first.org made the following annotations on 03/27/02 11:26:40 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
That will help, but you can also do the AS [ lots of spaces ] to lengthen the output field. What we really need is a set displaymode=fixedraw. This is an example of something that I do: select stgpool_name as Storage Pool Name , cast(sum(est_capacity_MB*pct_utilized/100/1024) as decimal(7,3)) as Total GB in Pool, cast(avg(est_capacity_MB*pct_utilized/100/1024) as decimal(7,3)) as AVG GB / Tape, cast(count(volume_name) as decimal(4,0)) as Tapes from volumes where stgpool_name like 'CPY%' or stgpool_name like 'TAPE%' group by stgpool_name Notice that he stgpool_name field is lenghtened to prevent the wrap by adding the spaces. -Original Message- From: Rejean Larivee/Quebec/IBM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 10:46 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Hello Matt, remove the -TAB and use -DISPLAY=LIST instead. I believe this is what you are looking for. - Rejean Larivee IBM TSM/ADSM Level 2 Support MC Matt Cooper (2838) To: [EMAIL PROTECTED] Matt.Cooper@AMGREcc: ETINGS.COM Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] EDU 03/27/2002 11:00 AM Please respond to ADSM: Dist Stor Manager Ike, I am running the following batch job. I added the -TAB and tried -OUTFILE with a redirect in the macro to the data set and that didn't work either. So I tried a few different variation of the above and even went back to adding a / after the ADSMC as the book says. None of it made a difference. It always came back with the output looking the same. Ideally I would want just the needed fields, with fixed length 1 per line. Matt THE JOB. //TSMJOB1 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=SYS1.CEE.SCEERUN, // DISP=SHR //DSCLANG DD DSN=SYS1.TSM.SANSMSG(ANSMENU),DISP=SHR //DSCOPT DD DSN=AGPP.TSM.TSOADMIN.OPTIONS,DISP=SHR //SYSHELP DD DSN=SYS1.TCPIP.SEZAHELP,DISP=SHR //SYSIN DD DUMMY //D1 DD DSN=AGPP.TSM.INACTIVE.NODES,DISP=SHR //SYSTSIN DD * DSMADMC -ID=ADMINJOB -PASSWORD= -OUTFILE=DD:D1 MACRO DD:D2 -TAB //D2 DD * select node_name,lastacc_time,contact from nodes where - cast((current_timestamp-lastacc_time)days as - decimal) = 7 /* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* THE OUTPUT FILE ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.7 (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved. ANS8000I Server command: 'select node_name,lastacc_time,contact from nodes where NODE_NAMELASTACC_TIMECONTACT ---- -- DTE-1710 2002-03-15Dan 09:28:26.00 Harrison/Desktop DTE-1720 2002-03-15SUE 23:27:49.00NEBINGER/DESKTOP -Original Message- From: Hunley, Ike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Matt, What do you do to execute the select command in the z/OS environment? -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:15 AM To: [EMAIL PROTECTED] Subject: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Hello all, I am trying to write a simple script that shows the nodes that were not accessed by TSM for more than x days and then do an E-mail notification from there. I AM RUNNING TSM 4.1.5 on z/OS 1.1. The select command to get the node name, last access date, and contact name (the e-mail address) seems easy enough. BUT I want the output from this to be in one line, preferably with fixed position or filed lengths. ( I will be using SAS processing to setup the job that will actually do the EMAIL). I have tried the approach documented in the 3rd chapter of the TSM Refernece manual but I can not get the desired results. It always comes back with the output for 1 node with last access and contact name using two lines. Has anyone ever had any success with this in OS390 environment? I could go a long way with an example . Thanks Matt Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
I think u need to set the format in SQL for o/p. That will solve ur problem. U need to write sql script and then call it from the connect string on shell script. Balanand -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 9:01 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Ike, I am running the following batch job. I added the -TAB and tried -OUTFILE with a redirect in the macro to the data set and that didn't work either. So I tried a few different variation of the above and even went back to adding a / after the ADSMC as the book says. None of it made a difference. It always came back with the output looking the same. Ideally I would want just the needed fields, with fixed length 1 per line. Matt THE JOB. //TSMJOB1 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=SYS1.CEE.SCEERUN, // DISP=SHR //DSCLANG DD DSN=SYS1.TSM.SANSMSG(ANSMENU),DISP=SHR //DSCOPT DD DSN=AGPP.TSM.TSOADMIN.OPTIONS,DISP=SHR //SYSHELP DD DSN=SYS1.TCPIP.SEZAHELP,DISP=SHR //SYSIN DD DUMMY //D1 DD DSN=AGPP.TSM.INACTIVE.NODES,DISP=SHR //SYSTSIN DD * DSMADMC -ID=ADMINJOB -PASSWORD= -OUTFILE=DD:D1 MACRO DD:D2 -TAB //D2 DD * select node_name,lastacc_time,contact from nodes where - cast((current_timestamp-lastacc_time)days as - decimal) = 7 /* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* THE OUTPUT FILE ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.7 (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved. ANS8000I Server command: 'select node_name,lastacc_time,contact from nodes where NODE_NAMELASTACC_TIMECONTACT ---- -- DTE-1710 2002-03-15Dan 09:28:26.00 Harrison/Desktop DTE-1720 2002-03-15SUE 23:27:49.00NEBINGER/DESKTOP -Original Message- From: Hunley, Ike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Matt, What do you do to execute the select command in the z/OS environment? -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:15 AM To: [EMAIL PROTECTED] Subject: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Hello all, I am trying to write a simple script that shows the nodes that were not accessed by TSM for more than x days and then do an E-mail notification from there. I AM RUNNING TSM 4.1.5 on z/OS 1.1. The select command to get the node name, last access date, and contact name (the e-mail address) seems easy enough. BUT I want the output from this to be in one line, preferably with fixed position or filed lengths. ( I will be using SAS processing to setup the job that will actually do the EMAIL). I have tried the approach documented in the 3rd chapter of the TSM Refernece manual but I can not get the desired results. It always comes back with the output for 1 node with last access and contact name using two lines. Has anyone ever had any success with this in OS390 environment? I could go a long way with an example . Thanks Matt Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Try the -commadelimited parameter. This gives a single line of output per row in the table. It's in standard comma-delimited format, which is understood by most PC spreadsheets, although not easily by humans. I'm not sure about SAS. Regards Richard Foster
Re: LANFREE Backups - Feedback?
I discussed this further at Share with the Product Manager. There is still not a market there for this functionality in the SUN/ESS combination. In fact, there is little market for the SUN/EMC and AIX/ESS combinations. That is why they have not pursued. Veritas only has EMC Timefinder support and only then because apparently EMC wrote it. The bottom line, if you want it you need to contact your Tivoli Marketing Rep. -Original Message- From: Zlatko Krastev [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 4:23 AM To: [EMAIL PROTECTED] Subject: Re: LANFREE Backups - Feedback? If a customer wants to buy AIX box or ESS most of the times he/she will prefer to get the other instead of going into multi-vendor implementation. If Sun allow customers to get ESS attached to their boxes too often they may also loose box sales. For this reasons AIX/ESS and Sun/EMC are usually bundled together. AIX/EMC or Sun/ESS are much more rarely used. I've not seen any market research what is the percentage of AIX/ESS vs. Sun/ESS or Sun/EMC vs. Sun/ESS but would expect it can be 8:1 or similar. It was already pointed in this thread that sales of TDP for EMC/Sun or TDP for ESS/AIX are not so high. And we cannot expect efforts to be wasted on less prospective area. Paul, had you any success with product development manager ? Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: LANFREE Backups - Feedback? Tivoli has sold so few copies of this that they have no justification to develop the other options right now. I need the ESS/Solaris option. Maybe the prevalence of SAN now will change this story. I will talk to the product development manager again tomorrow about this issue. -Original Message- From: Bill Mansfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 11:05 PM To: [EMAIL PROTECTED] Subject: Re: LANFREE Backups - Feedback? I thought the restriction was that both the Production database server and Backup server (where the BCVs get mounted) had to be Solaris, but that the TSM server could be on a third server of any type. _ William Mansfield Senior Consultant Solution Technology, Inc Denis L'Huillier [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/05/2002 09:29 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: LANFREE Backups - Feedback? Jason, I completely agree with you. The majority of our databases are running on Solaris attached to EMC. But, I think that the percentage of TSM Servers running on Solaris versus running on AIX is a lot more for AIX. I would venture to say that AIX is the preferred operating system for TSM. This, I feel is the limitation. Not the fact that it's Solaris only, but the fact that TSM will not work with TDP for EMC if TSM is running on AIX. It has to be running on Solaris. Regards, Denis L. L'Huiller 973-360-7739 [EMAIL PROTECTED] Enterprise Storage Forms - http://admpwb01/misc/misc/storage_forms_main.html J Bamford tsmtech@BLUEYONTo: [EMAIL PROTECTED] DER.CO.UK cc: Sent by: ADSM: Subject: Re: LANFREE Backups - Feedback? Dist Stor Manager [EMAIL PROTECTED] T.EDU 03/05/2002 10:18 AM Please respond to ADSM: Dist Stor Manager Yes I believe when Tivoli looked at the development of the Timefinder function they looked at the market first. It was concluded that an EMC/Sun solution represented the larger market share of what customer have installed. ie there are more EMC/Sun installed sites than there are EMC/Aix sites.Mainly because Aix sites tend to be IBM disk solutions. Therefore if you wnat to sell a product, develop for the majority first. If people like it and want it so make some more ! Vendors do make software for there own products, so hopefully I see you purchasing lots of ESS soon then !! There's little point in doing costly developing for a product that no one wants. Yes the TDP for EMC has a VERY limited scole for configuration, and no RS/6000 isn't in there I believe. Specific products like this tend to be demand driven. From what I understand the current TDP/EMC saw a very limited uptake by customers. There has also been little demand to expand is platform coverage in this space. The TDP for EMC was also on the market before the TDP for ESS/Flashcopy. Thinking back I believe that is because EMC had the timefinder on the market before IBM/ESS and flashcopy. It was a while after before Tivoli got it's hands on working Flashcopy to do any sort of
Re: Server Return Code 11
The message says highest return code. So if you get one higher than 11 it will show as well. Actually you can get a -50 which is higher. This is a session died. The return code returned to a script is 255 for this instance (at least on windows). -Original Message- From: Michael Benjamin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 8:30 PM To: [EMAIL PROTECTED] Subject: Re: Server Return Code 11 Cute behaviour, maybe check for 11 and 0 if 11 is not a dangerous return code. tsm: ADSM_BBSquit ANS8002I Highest return code was 11. Tivoli Storage Manager Command Line Administrative Interface - Version 4, Release 2, Level 0.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Session established with server ADSM_BBS: AIX-RS/6000 Server Version 4, Release 2, Level 0.0 Server date/time: 03/27/02 09:17:32 Last access: 03/27/02 09:01:38 tsm: ADSM_BBSquit ANS8002I Highest return code was 0. -Original Message- From: Denis L'Huillier [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:30 AM To: [EMAIL PROTECTED] Subject: Server Return Code 11 Hello, I was looking on the list to see if this had come up before but couldn't find anything.. Nothing earth shattering.. Anyone notice that sometimes when you issue 'quit' from an admin command line it doesn't always quit with a return code of '0'. Many time I get a return code of '11'... tsm: TSM_C01quit ANS8002I Highest return code was 11. After the latest postings of tsm scripts to check that the server is up and running and email if it isn't I wrote a simple script that did a 'dsmadmc -id= -pa= quit' and then did a: if [[ ! $? -eq '0' ]]; then sendmail [EMAIL PROTECTED] serverdown.msg else exit 0 fi Well, I had cron run it 4 times a day.. and of course when I left for the day my pager goes off. I go home, dial in and all is okay.. Couldn't figure it out for the life of me. Now it finally hit me... return code 11!!! Anybody know what return code 11 is and why 'quit' would cause it sometimes??? Regards, Denis L. L'Huiller 973-360-7739 [EMAIL PROTECTED] Enterprise Storage Forms - http://admpwb01/misc/misc/storage_forms_main.html ** Bunnings Legal Disclaimer: 1) This document is confidential and may contain legally privileged information. If you are not the intended recipient you must not read, copy, distribute or act in reliance on it. If you have received this document in error, please telephone us immediately on (08) 9365-1555. 2) All e-mails sent to and sent from Bunnings Building Supplies are scanned for content. Any material deemed to contain inappropriate subject matter will be reported to the e-mail administrator of all parties concerned. **
Re: win2k tsm client 4.2.1.30 bug
I am not sure what you mean by drive shortcut. How do you create this? I am not aware of this problem. Can you please provide a step-by-step recreate scenario, i.e. how to create the drive shortcut, and how to reproduce the problem? In addtion, please provide a drwtsn32.log file showing the crash. To do this, you will need to: a) Configure Dr. Watson. Run drwtsn32.exe. In the configuration dialog, make sure the following items are checked: - Dump Symbol Table - Dump all Thread Contexts - Append To Existing Log File - Visual Notification Also make sure that Number of Instructions is set to at least 20. After verifying these settings, click OK. b) Configure Dr. Watson as the default debugger. To do this, run the following from an OS prompt: drwtsn32 -i Recreate the problem. When the crash occurs, make sure to record the information in the pop-up, including the error type (i.e. access violation) and, most important, the address. Be sure to provide support the Send the pop-up information, drwtsn32.log file, and recreate scenario to me, and I will see what I can see. Please be aware that I will probably ask you to also open a problem report with IBM support, as the diagnosis may be beyond the scope of what I can do on this informal support basis. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Burak Demircan [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/27/2002 08:20 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:win2k tsm client 4.2.1.30 bug Hi, The tsm client for windows 2000 4.2.1.30 is crashing when i try to backup a folder or volume that has drive shortcuts example D: Are you having the same problem? Is there a cure for it? Regards, Burak
Re: Reclamation of Offsite Pool
Did this say the input volume was UNAVAILBLE? If so, it is probably the primary tape volume that has gotten marked that way during a dismount error. There are a number of fixes for this that have been released. All you have to do is do an update command against that primary tape and change its access to READONLY and you are set. -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 7:52 AM To: [EMAIL PROTECTED] Subject: Reclamation of Offsite Pool Hello, I think I finally understand the process of reclamation on copy pools and how it is done on tapes that are offsite in the vault. I was just looking through all of the messages associated with the reclamation of offsite volumes and I received the message ANR1163W (That an offsite volume still contains files which could not be moved) which I am assuming that since it was a reclamation it could not be copied from available onsite volumes. In the message book it gives 3 different methods of fixing this problem. I was just wondering what everyone thinks would be the best action to take? 1. Bring the volume back onsite and issue a MOVE DATA command to reclaim the volume. 2. Make teh primary volumes available and reissue a MOVE DATA command to reclaim the volume. (How do I know what the primary volumes are associated with the offsite tape in the vault? 3. Delete the files by using the DELETE VOLUME command. (Not an option at this point in time) One last question... When reclamation runs for offsite tapes, how do I know where the information is located in the primary volumes? How do I know what information is on that tape? I tried a Q CON, but apparently it only works on volumes that are onsite? Thanks so much for your help Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338
Re: win2k tsm client 4.2.1.30 bug
Have you opened a problem record with Tivoli? -Original Message- From: Burak Demircan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 10:21 AM To: [EMAIL PROTECTED] Subject: win2k tsm client 4.2.1.30 bug Hi, The tsm client for windows 2000 4.2.1.30 is crashing when i try to backup a folder or volume that has drive shortcuts example D: Are you having the same problem? Is there a cure for it? Regards, Burak
Re: RH Linux 7.1 automounted filespaces
NFS At 09:29 AM 3/27/02 -0600, you wrote: What type of filesystem are you automounting? ( NFS, CDs? ) -ed [EMAIL PROTECTED] 2002/03/26 05:41:37 PM ...excuse me, I forgot to mention the TSM client level is 4.2.1 and Server AIX 4.3 TSM 4.1.4.0. Thanks.
Re: Here's a new one - 4.2.0 client on WinNT SP 6..
Every time I have seen something like this it is a corrupt file in the file system. Run CHKDSK. -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: Here's a new one - 4.2.0 client on WinNT SP 6.. Anybody ever seen this one? Scheduler appears to back up C drive ok, then just locks up sometime during the backup of D: dsmsched.log: 02/25/2002 03:01:48 ANS1898I * Processed73,000 files * 02/25/2002 03:01:51 ANS1898I * Processed73,500 files * 02/25/2002 03:01:54 ANS1898I * Processed74,000 files * 02/25/2002 03:01:58 ANS1898I * Processed74,500 files * 02/25/2002 03:02:01 ANS1898I * Processed75,000 files * 02/25/2002 03:02:05 ANS1898I * Processed75,500 files * 02/25/2002 03:02:09 ANS1898I * Processed76,000 files * (nothing further) Messages in dsmerror.log: 02/25/2002 02:54:10 ANS1802E Incremental backup of '\\slbmpst4\c$' finished with 11 failure 02/25/2002 03:02:11 Mutex lock failed: 6. 02/25/2002 03:02:11 Release mutex failed; reason 6. 02/25/2002 03:02:12 Mutex lock failed: 6. 02/25/2002 03:02:12 Release mutex failed; reason 6. 02/25/2002 03:02:13 Mutex lock failed: 6. etc. . These Mutex errors continued for hours until the scheduler was stopped. Any idea what causes this? Hasn't recurred since the scheduler was restarted. This is WinNT 4.0, SP 6 Client is 4.2.0.0 Thanks.
Re: Elapsed processing time.
q act search=ANE4964I begint=-24 You can also do a select against the actlog table and extract fields from the text. -Original Message- From: Zosimo Noriega [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 1:14 AM To: [EMAIL PROTECTED] Subject: Elapsed processing time. Hi All, How can i find the Elapsed Processing Time of nodes instead from the dsmsched.log file? Are those related information stored in the database? Thanks for your help in advance. Zosi Noriega ADNOC - UAE
Re: Elapsed processing time.
In addition to the accounting log and actlog, you can also check the summary table for recent entries (in 3.7 and later, I believe). select entity, start_time, end_time-start_time as elapsed_time from summary where select colname, remarks from syscat.columns where tabname='SUMMARY' COLNAMEREMARKS -- -- START_TIME Start time END_TIME End Time ACTIVITY Process or Session Activity Name NUMBER Process or Session Number ENTITY Associated user or storage pool(s) associated with the activity COMMMETH Communications Method Used ADDRESSCommunications Address SCHEDULE_NAME Schedule Name EXAMINED Number of objects (files and/or directories) examined by the process/session AFFECTED Number of objects affected (moved, copied or deleted) by the process/session FAILED Number of objects that failed in the process/session BYTES Bytes processed IDLE Seconds that the session/process was idle MEDIAW Seconds that the session/process was waiting for access to media (volume mounts) PROCESSES Number of processes used for process SUCCESSFUL Successful ? VOLUME_NAMEVolume Name DRIVE_NAME Drive Name LIBRARY_NAME Library Name LAST_USE Last Use -Original Message- From: Zosimo Noriega [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:14 PM To: [EMAIL PROTECTED] Subject: Elapsed processing time. Hi All, How can i find the Elapsed Processing Time of nodes instead from the dsmsched.log file? Are those related information stored in the database? Thanks for your help in advance. Zosi Noriega ADNOC - UAE
Re: Select statement for finding damaged files.
Andy, Recently we are seeing that quite a few tapes are going in to the error state and having damaged files. (Even before I can complete the stgpool backup.) Now these files need to be regenerated.Now, If I had a lookup table I could create a list of the damaged files thru one command instead of making a list of damaged tapes and running a q content on each one. But thanks anyways and I can definitely live with the q content command !! Sumitro Chowdhury. From: Andrew Raibeck <[EMAIL PROTECTED]> Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Select statement for finding damaged files. Date: Tue, 26 Mar 2002 19:09:27 -0500 I don't believe that the necessary TSM database tables are exposed to do what you are asking. What is the difficulty in using the QUERY CONTENT command? Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. ADSM ADSMuser <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 03/26/2002 15:22 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Select statement for finding damaged files. Select Gurus, Please suggest a select statement for finding damaged files in a particular volser. I need to avoid "q content volser damaged=yes". Thanks. Sumitro Chowdhury. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. Join the world s largest e-mail service with MSN Hotmail. Click Here
Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
I have tried everyone's suggestions. I believe the fact that I have one AS statement in the script that it will ignore the attempts of fixing the output into a 1 line per node output. The -COMMAdelimited , -TABdelimited, -OUT didn't work. I was able to get a 1 line output, with a title line and some other 'extra' lines of TSM header and msgs. The only way I seem to have in controlling this is with the suggestion from Paul, using an AS big area . This whole 'programming' area seems to go by a lot of undocumented rules. Why don't they document them somewhere? Or give a direct reference to which other product doc to look at? I am able to directly control the length of a numeric output with 'decimal(xx)' statement. What about character output? I am still disappointed that I can not seem to get an output that would be nothing more than what I really want 12 character node name delimiter 4 digit number of days since last access delimiter contact field name of 20 characters,then the next line . The best I came up with is as follows. SCRIPT... select node_name as NODE, - cast((current_timestamp-lastacc_time)days as decimal(4)) as DAYS, - contact asCONTACTfrom nodes where - cast((current_timestamp-lastacc_time)days as decimal) = 7 OUTPUT FILE . ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.7 (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved. ANS8000I Server command: 'select node_name as NODE, cast((current_timestamp- NODEDAYSCONTACT -- -- AG570 58 Elliott/desktop DEFIANT 12 R.Schulte, D.Harrison DSS1OLD343 Connie Brooks WIN2KAD 34 Karlene Michael ANS8000I Server command: 'COMMIT' ANS8002I Highest return code was 0. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS That will help, but you can also do the AS [ lots of spaces ] to lengthen the output field. What we really need is a set displaymode=fixedraw. This is an example of something that I do: select stgpool_name as Storage Pool Name , cast(sum(est_capacity_MB*pct_utilized/100/1024) as decimal(7,3)) as Total GB in Pool, cast(avg(est_capacity_MB*pct_utilized/100/1024) as decimal(7,3)) as AVG GB / Tape, cast(count(volume_name) as decimal(4,0)) as Tapes from volumes where stgpool_name like 'CPY%' or stgpool_name like 'TAPE%' group by stgpool_name Notice that he stgpool_name field is lenghtened to prevent the wrap by adding the spaces. -Original Message- From: Rejean Larivee/Quebec/IBM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 10:46 AM To: [EMAIL PROTECTED] Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Hello Matt, remove the -TAB and use -DISPLAY=LIST instead. I believe this is what you are looking for. - Rejean Larivee IBM TSM/ADSM Level 2 Support MC Matt Cooper (2838) To: [EMAIL PROTECTED] Matt.Cooper@AMGREcc: ETINGS.COM Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] EDU 03/27/2002 11:00 AM Please respond to ADSM: Dist Stor Manager Ike, I am running the following batch job. I added the -TAB and tried -OUTFILE with a redirect in the macro to the data set and that didn't work either. So I tried a few different variation of the above and even went back to adding a / after the ADSMC as the book says. None of it made a difference. It always came back with the output looking the same. Ideally I would want just the needed fields, with fixed length 1 per line. Matt THE JOB. //TSMJOB1 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=SYS1.CEE.SCEERUN, // DISP=SHR //DSCLANG DD DSN=SYS1.TSM.SANSMSG(ANSMENU),DISP=SHR //DSCOPT DD DSN=AGPP.TSM.TSOADMIN.OPTIONS,DISP=SHR //SYSHELP DD DSN=SYS1.TCPIP.SEZAHELP,DISP=SHR //SYSIN DD DUMMY //D1 DD DSN=AGPP.TSM.INACTIVE.NODES,DISP=SHR //SYSTSIN DD * DSMADMC -ID=ADMINJOB -PASSWORD= -OUTFILE=DD:D1 MACRO DD:D2 -TAB //D2 DD * select node_name,lastacc_time,contact from nodes where - cast((current_timestamp-lastacc_time)days as - decimal) = 7 /* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* THE OUTPUT FILE ADSTAR Distributed Storage Manager Command Line
Re: Windows NTFS last accessed date set by TSM client
Andy, What exactly is the issue? Personally, during my testing, it looked like the TSM client maintained the last access date and NTFS didn't automatically update the Last Access date as you describe when TSM accessed the file (on WinNT4 SP6, I think). The updated access time issues I encountered had to do with interoperability with the McAfee virus scan software. Here is the message I posted with one of my actual tests copied and pasted in it. http://msgs.adsm.org/cgi-bin/get/adsm0109/460.html I believe your statement that NTFS updates the Access Date when TSM access the file possibly occurs under situations I didn't test. Could you give us more detail? Thanks, Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 4:32 PM To: [EMAIL PROTECTED] Subject: Re: Windows NTFS last accessed date set by TSM client This is a known issue, and we are working on a solution. For what it is worth, TSM does not *actively* change the last access date; this is a property of how the file system works, that any application that touches a file will update the last access date. Applications that don't change the last access date are almost certainly implicitly changing it when they touch the file, but then resetting it when they are done. As I mentioned above, we are working on resolving this ourselves. For now, there isn't anything that can really be done about this. However, TSM should normally only be touching files that have actually changed (assuming that you do regular incremental backups). If that is the case, then it can be assumed that if TSM is backing it up, it must have been changed, and thus accessed by some other application; so it would not be subject to your purge by last access date rule, anyway. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Allan Kelly [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/26/2002 16:20 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Windows NTFS last accessed date set by TSM client We have a couple of Windows file servers that we back up with the TSM Windows client 4.1.2.14 to our TSM Windows 4.1.3.0 server. The file last accessed date is set during the scheduled backup run and we do not know how to stop it. We want to run purges based on the last accessed date but we are stymied. Any useful suggestion are most urgently needed. Thanks. Allan Kelly.
Re: Windows NTFS last accessed date set by TSM client
The last access date/time of an NTFS file is only updated if the file is backed up, it isn't updated during incremental backup scan processing. Most virus protection software modifies the last access while scanning the file system for viruses but resets it to the original value unconditionally. The TSM backup client currently doesn't reset the last access time but development is considering adding an option to allow it to be reset to the original value prior to backup. The attached program will dump out the time stamps of an ntfs file. Running this program against an ntfs file before and after backing up the file should demonstrate the last access date changing. Hope this helps . Pete #include windows.h #include stdio.h static TCHAR * getLocalTimestamp (FILETIME *ftP, TCHAR *buff); void wmain (int argc, wchar_t *argv[]) { WIN32_FIND_DATA fd; HANDLE hFind; TCHAR buff[100]; if (argc 1) return; if ( (hFind=FindFirstFile(argv[1], fd)) == INVALID_HANDLE_VALUE ) { wprintf(L\n\nFindFirstFile: Win32 RC=%d.\n\n, GetLastError()); return; } FindClose(hFind); wprintf(L\n%s :\n, argv[1]); wprintf(L CreationTime: %s\n , getLocalTimestamp ((fd.ftCreationTime), buff)); wprintf(L Last Access Time: %s\n , getLocalTimestamp ((fd.ftLastAccessTime), buff)); wprintf(L Last Write Time: %s\n\n , getLocalTimestamp ((fd.ftLastWriteTime), buff)); return; } static TCHAR * getLocalTimestamp (FILETIME *ftP, TCHAR *buff) { FILETIMEftLocal; SYSTEMTIME stLocal; FileTimeToLocalFileTime(ftP, ftLocal); FileTimeToSystemTime(ftLocal, stLocal); wsprintf(buff, L%04d %02d/%02d %02d:%02d:%02d:%03d, stLocal.wYear, stLocal.wMonth, stLocal.wDay, stLocal.wHour, stLocal.wMinute, stLocal.wSecond, stLocal.wMilliseconds); return buff; } --- Pete Tanenhaus Tivoli Storage Solutions Software Development email: [EMAIL PROTECTED] tieline: 320.8778, external: 607.754.4213 Those who refuse to challenge authority are condemned to conform to it -- Forwarded by Pete Tanenhaus/San Jose/IBM on 03/27/2002 03:03 PM --- Alex Paschal [EMAIL PROTECTED]@VM.MARIST.EDU on 03/27/2002 01:54:02 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:Re: Windows NTFS last accessed date set by TSM client Andy, What exactly is the issue? Personally, during my testing, it looked like the TSM client maintained the last access date and NTFS didn't automatically update the Last Access date as you describe when TSM accessed the file (on WinNT4 SP6, I think). The updated access time issues I encountered had to do with interoperability with the McAfee virus scan software. Here is the message I posted with one of my actual tests copied and pasted in it. http://msgs.adsm.org/cgi-bin/get/adsm0109/460.html I believe your statement that NTFS updates the Access Date when TSM access the file possibly occurs under situations I didn't test. Could you give us more detail? Thanks, Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 4:32 PM To: [EMAIL PROTECTED] Subject: Re: Windows NTFS last accessed date set by TSM client This is a known issue, and we are working on a solution. For what it is worth, TSM does not *actively* change the last access date; this is a property of how the file system works, that any application that touches a file will update the last access date. Applications that don't change the last access date are almost certainly implicitly changing it when they touch the file, but then resetting it when they are done. As I mentioned above, we are working on resolving this ourselves. For now, there isn't anything that can really be done about this. However, TSM should normally only be touching files that have actually changed (assuming that you do regular incremental backups). If that is the case, then it can be assumed that if TSM is backing it up, it must have been changed, and thus accessed by some other application; so it would not be subject to your purge by last access date rule, anyway. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Allan Kelly
Tape retention after restores
We have been seeing a recurrent problem with GUI restores under Windows NT. A system administrator will start a restore and walk away from his disk. When the restore finishes, the session will stay open and the last tape used in the restore will remain mounted. We have sometimes had a tape drive tied up for hours before getting the person who started the restore to respond to a telephone call or a page. We have occasionally seen a similar problem with command line restores under HP-UX. A batch mode dsmc restore will relinquish the tape drive when the restore ends, but a restore run from a loop mode dsmc session will not. Our server runs under OS/390 and is currently at level 4.2.1.9. The last Windows NT client to monopolize a tape drive was at level 4.1.2.12. The last HP-UX client to do so was at level 4.1.2.0. Is there any way to get TSM to take a more rational approach to tape drive retention in this situation?
Re: Windows NTFS last accessed date set by TSM client
Zoinks. What kind of stupid filesystem is that? Back to testing. Thanks for the info, Andy. Alex -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Windows NTFS last accessed date set by TSM client Hi Alex, I believe that on NTFS, last access time has a resolution of 1 hour. Thus if the file was accessed within the last hour, accessing it again won't change the last access time. If the file was accessed over an hour ago, then accessing the file will change the last access time. So in some cases, yes, it is possible that if TSM access the file, it won't cause the last access time to change. It depends on when the file was last accessed prior to the TSM backup. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Alex Paschal [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/27/2002 11:54 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Windows NTFS last accessed date set by TSM client Andy, What exactly is the issue? Personally, during my testing, it looked like the TSM client maintained the last access date and NTFS didn't automatically update the Last Access date as you describe when TSM accessed the file (on WinNT4 SP6, I think). The updated access time issues I encountered had to do with interoperability with the McAfee virus scan software. Here is the message I posted with one of my actual tests copied and pasted in it. http://msgs.adsm.org/cgi-bin/get/adsm0109/460.html I believe your statement that NTFS updates the Access Date when TSM access the file possibly occurs under situations I didn't test. Could you give us more detail? Thanks, Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 4:32 PM To: [EMAIL PROTECTED] Subject: Re: Windows NTFS last accessed date set by TSM client This is a known issue, and we are working on a solution. For what it is worth, TSM does not *actively* change the last access date; this is a property of how the file system works, that any application that touches a file will update the last access date. Applications that don't change the last access date are almost certainly implicitly changing it when they touch the file, but then resetting it when they are done. As I mentioned above, we are working on resolving this ourselves. For now, there isn't anything that can really be done about this. However, TSM should normally only be touching files that have actually changed (assuming that you do regular incremental backups). If that is the case, then it can be assumed that if TSM is backing it up, it must have been changed, and thus accessed by some other application; so it would not be subject to your purge by last access date rule, anyway. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Allan Kelly [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/26/2002 16:20 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Windows NTFS last accessed date set by TSM client We have a couple of Windows file servers that we back up with the TSM Windows client 4.1.2.14 to our TSM Windows 4.1.3.0 server. The file last accessed date is set during the scheduled backup run and we do not know how to stop it. We want to run purges based on the last accessed date but we are stymied. Any useful suggestion are most urgently needed. Thanks. Allan Kelly.
Re: Mount point reserved
If you are using a gui or command line...archive...and go back to the gui or command line...you will HOLD that mount. In our dsmserv.opt we now have: IDLETIMEOUT 15 so when a user does not get all the way out of tsm after an archive, retrieve, or whatever we will terminate the session (idletimeout 15 minutes). Of course, holding a tape and tape drive is very expensive dsmc archive file archmc=whatever as opposed to dsmc archive whatever DOES make a difference... dsmc archive...blah blah...will return you back to your operating system prompt after the archive dsmc (then enter or return) then...archive will hold the drive... -Original Message- From: David Longo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Mount point reserved I have fairly new TSM server 4.2.1.9 on AIX 4.3.3. with 3584 library. I just did first ARCHIVE from a client. Doing a q mount now shows: ANR8376I Mount point reserved in device class LTO, status: RESERVED. at end of display. Archive is finished over an hour now and this message still shows up. I only have a ONE minute mount retention set up for tape. How do I get rid of the RESERVED mount point? I didn't have this with old 3.7.4.0 server. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5525 [EMAIL PROTECTED] MMS health-first.org made the following annotations on 03/27/02 11:26:40 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==
Problems with the TSM TSO Client...
Here's the clist I execute PROC 0 PROFILE PROMPT PRE(SYSUID) CONTROL NOLIST NOCONLIST MSG FLUSH PROMPT /* IT IS IMPORTANT TO INCLUDE THE PARAMETER PROMPT */ /* IN THE PROFILE AND CONTROL STATEMENTS TO ALLOW*/ /* DSMADMC (TSO ADMIN CLIENT MODULE) TO PROMPT FOR */ /* INPUT (E.G. PASSWORD).*/ ALLOC F(DSCOPT) DA('SYS2.TSMTSO.$ADSM.OPTIONS') SHR REU ALLOC F(DSCLANG) DA('SYS1.SANSMSG(ANSMENU)') SHR REU CALL 'SYS2.TSM.V4219.LOADLIB(DSMADMC)' FREE F(DSCOPT DSCLANG ) PROFILE NOPRE Here's what I get... ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.7 (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved. Enter your user id: o8x ANS8059E The TCP/IP functions have not been linked into this module. ANS8023E Unable to establish session with server. ANS8002I Highest return code was -224. We created a job to link TSM and TCPIP(attached as tsmtcpip.txt) I also attached the options file. Can someone out there make point me in the direction I need to solve this problem? Thank you in advance... Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc. //O48JOB JOB (8218,08017,48,G),'R.JUSTICE-X56351',CLASS=U,MSGCLASS=H, 0010 // NOTIFY=O48 0020 //** //* //* THE FOLLOWING JOB WAS GENERATED FROM THE REPORT CALLLIBS COMMAND //* FOR TARGET ZONE ZOSE01 ON 02.079 AT 11.55.49. //* //** //LINK0001 EXEC PGM=HEWLH096, // PARM=('NCAL,LIST,LET,CALL') //** //* //* LMODS LINKED IN THIS STEP: //* //*ANSADM //* //** //SYSLIB DD DSN=SYS1.SANSINC2, //UNIT=3390,VOL=SER=ZOSE01, //DISP=(SHR) // DD DSN=SYS1.SEZACMTX, //UNIT=3390,VOL=SER=ZOSE01, //DISP=(SHR) // DD DSN=SYS1.SANSINC1, //UNIT=3390,VOL=SER=ZOSE01, //DISP=(SHR) // DD DSN=SYS1.SCEELKED, //UNIT=3390,VOL=SER=ZOSE01, //DISP=(SHR) //SYSPRINT DD SYSOUT=* //SYSLMOD DD DSN=SYS2.TSM.V4219.LOADLIB, //DISP=(SHR) //SYSUT1 DD UNIT=3390, //SPACE=(CYL,(600,100)) //SMPLTS DD DSN=SMPE.ZOS120.ZOSE01.SMPLTS, //DISP=(SHR) //SYSLIN DD * ALIAS DSMADMC MODEAMODE(31),RMODE(ANY) SETCODE AC(0) ENTRY SVMSTART INCLUDE SMPLTS(ANSADM) NAME ANSADM(R) /* ** ***Tivoli Storage Manager *** ***Product Number 5697-TS9/5698-TSM*** ***Contains Restricted Materials of IBM *** ***(c) Copyright IBM Corporation 1990,2001 *** ***Refer to copyright instructions *** ** * ** * Sample Options for TSO Admin Client Version 3 Release 1 ** * ** * COMMMethod * * Format * +--+--+ * | COMMMethod | IUCV | SNAlu6.2 | TCPip | * +--+--+ * System defaults: * * TSO: IUCV * * Option file examples: * * COMMMethod IUCV * COMMMethod SNALU6.2 COMMMethod TCPIP * * CPICBUffersize * * +--+--+ * | CPICBUffersize | cpic_buffer_size | * +--+--+ * Default: 15 (Kbytes) * Min: 1 (Kbytes) * Max: 31 (Kbytes) * * Option file example: * * CPICBUffersize 31 * * SYMbolicdestination *for APPC - Advanced Program-to-Program Communication * * +--+--+ * | SYMbolicdestination | sym_dest_name| * +--+--+ * Default: none *This statement is required if the COMMmethod SNAlu6.2 is *used and if a
Re: Windows NTFS last accessed date set by TSM client
I don't know why it is designed as it is. Perhaps the overhead in a more granular resolution would affect performance (imagine if several apps were repeatedly hammering away at the same file over an extended period of time). But that is just a guess. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Alex Paschal [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/27/2002 14:27 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Windows NTFS last accessed date set by TSM client Zoinks. What kind of stupid filesystem is that? Back to testing. Thanks for the info, Andy. Alex -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Windows NTFS last accessed date set by TSM client Hi Alex, I believe that on NTFS, last access time has a resolution of 1 hour. Thus if the file was accessed within the last hour, accessing it again won't change the last access time. If the file was accessed over an hour ago, then accessing the file will change the last access time. So in some cases, yes, it is possible that if TSM access the file, it won't cause the last access time to change. It depends on when the file was last accessed prior to the TSM backup. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Alex Paschal [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/27/2002 11:54 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Windows NTFS last accessed date set by TSM client Andy, What exactly is the issue? Personally, during my testing, it looked like the TSM client maintained the last access date and NTFS didn't automatically update the Last Access date as you describe when TSM accessed the file (on WinNT4 SP6, I think). The updated access time issues I encountered had to do with interoperability with the McAfee virus scan software. Here is the message I posted with one of my actual tests copied and pasted in it. http://msgs.adsm.org/cgi-bin/get/adsm0109/460.html I believe your statement that NTFS updates the Access Date when TSM access the file possibly occurs under situations I didn't test. Could you give us more detail? Thanks, Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 4:32 PM To: [EMAIL PROTECTED] Subject: Re: Windows NTFS last accessed date set by TSM client This is a known issue, and we are working on a solution. For what it is worth, TSM does not *actively* change the last access date; this is a property of how the file system works, that any application that touches a file will update the last access date. Applications that don't change the last access date are almost certainly implicitly changing it when they touch the file, but then resetting it when they are done. As I mentioned above, we are working on resolving this ourselves. For now, there isn't anything that can really be done about this. However, TSM should normally only be touching files that have actually changed (assuming that you do regular incremental backups). If that is the case, then it can be assumed that if TSM is backing it up, it must have been changed, and thus accessed by some other application; so it would not be subject to your purge by last access date rule, anyway. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Allan Kelly [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03/26/2002 16:20 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Windows NTFS last accessed date set by TSM client We have a couple of Windows file servers that we back up with the TSM Windows client 4.1.2.14 to our TSM Windows 4.1.3.0 server. The file last accessed date is set during the scheduled backup run and we do not know how to stop it. We want to run purges based on the last accessed date but we are stymied. Any useful suggestion are most urgently needed.
Re: Q VOL Shows tapes FULL at less than 100% utilized
Clive I user the following as a script from the command line! easier to see what is where #!/bin/ksh ADSM='dsmadmc -id=X -pa=X' $ADSM 'SELECT left(V.volume_name,7) as TAPE, left(V.stgpool_name,4) as STG, left(varchar(V.pct_utilized),4) as USED, left(varchar(V.pct_reclaim),4) as RECL, left(V.location,6) as LOCAT, left(V.access,5) as ACC, L.home_element as SL FROM volumes V, libvolumes L where V.volume_name=L.volume_name ORDER by SL' sorted.txt cat sorted.txt You may have to play with field sizes but this goes for 80 cols Allan Clive Johnson clive.johnson To: [EMAIL PROTECTED] @DB.COM cc: Sent by: Subject: Q VOL Shows tapes FULL at less than 100% utilized ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 03/28/2002 10:54 AM Please respond to ADSM: Dist Stor Manager All, I am experiencing a problem when queering the volume, please see below: Using TSM ver 4 release 2 level 1.7 on NT4 SP6 Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status (MB) --- -- - - 01L1 TAPE LTO 102,110.9 49.6Full 02L1 TAPECOLL LTO 200,000.09.6 Filling 03L1 TAPECOLL LTO 101,700.5 100.0Full 05L1 TAPE LTO 102,780.8 29.8Full 06L1 TAPE LTO 101,664.4 29.7Full 07L1 TAPECOLL LTO 200,300.2 95.1Full 08L1 TAPECOLL LTO 223,004.3 71.5 Filling 11L1 TAPEARCH LTO 200,000.0 15.2 Filling 12L1 TAPE-S2S LTO 200,000.00.0 Filling 13L1 TAPE LTO 101,488.87.0Full 14L1 TAPE LTO 101,138.1 71.5Full 15L1 TAPE LTO 101,492.5 59.8Full 16L1 TAPE LTO 101,793.8 74.2Full 17L1 TAPE LTO 101,622.4 33.1Full One problem is that the tapes are showing full at a capacity of 100Gb and pct util is all over the place. There has been no change to compression settings. This has only just started to happen. I have tried to reclaim the stgpool but when I update the stg pool reclamation value that would envoke reclamation but nothing happens. q pro - no processes are active, q mount - nothing is mounted. If anyone has any ideas they would be much appreciated as I am having to throw tapes into our library daily. Clive -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Q VOL Shows tapes FULL at less than 100% utilized
All, I am experiencing a problem when queering the volume, please see below: Using TSM ver 4 release 2 level 1.7 on NT4 SP6 Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status (MB) --- -- - - 01L1 TAPE LTO 102,110.9 49.6Full 02L1 TAPECOLL LTO 200,000.09.6 Filling 03L1 TAPECOLL LTO 101,700.5 100.0Full 05L1 TAPE LTO 102,780.8 29.8Full 06L1 TAPE LTO 101,664.4 29.7Full 07L1 TAPECOLL LTO 200,300.2 95.1Full 08L1 TAPECOLL LTO 223,004.3 71.5 Filling 11L1 TAPEARCH LTO 200,000.0 15.2 Filling 12L1 TAPE-S2S LTO 200,000.00.0 Filling 13L1 TAPE LTO 101,488.87.0Full 14L1 TAPE LTO 101,138.1 71.5Full 15L1 TAPE LTO 101,492.5 59.8Full 16L1 TAPE LTO 101,793.8 74.2Full 17L1 TAPE LTO 101,622.4 33.1Full One problem is that the tapes are showing full at a capacity of 100Gb and pct util is all over the place. There has been no change to compression settings. This has only just started to happen. I have tried to reclaim the stgpool but when I update the stg pool reclamation value that would envoke reclamation but nothing happens. q pro - no processes are active, q mount - nothing is mounted. If anyone has any ideas they would be much appreciated as I am having to throw tapes into our library daily. Clive -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Re: Q VOL Shows tapes FULL at less than 100% utilized
This does not necessarily look wrong to me. I have 3584 library and old 3575 library. Tape fills to 100% , then expiration expires some files and pct util drops. You say this has just started to happen, how long had you been operating normally? What reclamation pct do you use? When you update stg pool reclamation and nothing happens, look at actlog for last few minutes and you will most likely see some hint of why nothing happened. I use compression on tape only (no client compression). I setup LTO class as 200GB. I am getting 250 to 300GB on a tape. IBM tapes with variety of data types/sizes. David Longo [EMAIL PROTECTED] 03/27/02 06:54PM All, I am experiencing a problem when queering the volume, please see below: Using TSM ver 4 release 2 level 1.7 on NT4 SP6 Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status (MB) --- -- - - 01L1 TAPE LTO 102,110.9 49.6Full 02L1 TAPECOLL LTO 200,000.09.6 Filling 03L1 TAPECOLL LTO 101,700.5 100.0Full 05L1 TAPE LTO 102,780.8 29.8Full 06L1 TAPE LTO 101,664.4 29.7Full 07L1 TAPECOLL LTO 200,300.2 95.1Full 08L1 TAPECOLL LTO 223,004.3 71.5 Filling 11L1 TAPEARCH LTO 200,000.0 15.2 Filling 12L1 TAPE-S2S LTO 200,000.00.0 Filling 13L1 TAPE LTO 101,488.87.0Full 14L1 TAPE LTO 101,138.1 71.5Full 15L1 TAPE LTO 101,492.5 59.8Full 16L1 TAPE LTO 101,793.8 74.2Full 17L1 TAPE LTO 101,622.4 33.1Full One problem is that the tapes are showing full at a capacity of 100Gb and pct util is all over the place. There has been no change to compression settings. This has only just started to happen. I have tried to reclaim the stgpool but when I update the stg pool reclamation value that would envoke reclamation but nothing happens. q pro - no processes are active, q mount - nothing is mounted. If anyone has any ideas they would be much appreciated as I am having to throw tapes into our library daily. Clive -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. MMS health-first.org made the following annotations on 03/27/02 20:26:11 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==
Re: TSM Crashed
I agree with that this is fixed in 4.1.4. Still you need to be careful whats causing the problem. I too have experienced the same problem and ended-up in rebuilding TSM again. Have you seen actlog message that report ANRE or ANRW before and after crash. try capture and send it , hopefully i can help you in this regard. If your database is not big enough and if u have no time contraint, then do auditdb without fixing it. dsmserv auditdb detail=yes fix=no this will tell you whats wrong with you TSM database , if any. thanks and regards sreekumar. Loon, E.J. van - SPLXM To: [EMAIL PROTECTED] Eric-van.Loon cc: @KLM.COMSubject: Re: TSM Crashed Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 03/27/2002 22:49 Please respond to ADSM: Dist Stor Manager Hi Bruce! This could be APAR IC30942/PQ48666. This one is fixed in 4.1.4.0 and higher. 4.1.4.5 is the highest 4.1 level available for download. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Bruce Kamp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 14:41 To: [EMAIL PROTECTED] Subject: TSM Crashed I'm running TSM 4.1.3.2 on AIX 4.3.3 ML8. Last night TSM crashed with this error in the dsmserv.err: 03/26/2002 20:07:07 ANR7838S Server operation terminated. 03/26/2002 20:07:08 ANR7837S Internal error TMTXN008 detected. 03/26/2002 20:07:08 ANR7834S Thread 88 (tid 5800) terminating on signal 11 (Segmentation violation). 03/26/2002 20:07:08 ANR7834S GPR 0: 0xd0019580, 1: 0x44d51fb0, 2: 0x301976a0, 3: 0x 03/26/2002 20:07:08 ANR7834S GPR 4: 0x44d533c8, 5: 0x0008, 6: 0x0003, 7: 0x 03/26/2002 20:07:08 ANR7834S GPR 8: 0x1000733b, 9: 0x1000733b, 10: 0xf0045e04, 11: 0x43dc6ae4 03/26/2002 20:07:08 ANR7834S GPR 12: 0x1000f10c, 13: 0x43c53820, 14: 0x0170, 15: 0x 03/26/2002 20:07:08 ANR7834S GPR 16: 0x, 17: 0x000a, 18: 0x0004, 19: 0x0018 03/26/2002 20:07:08 ANR7834S GPR 20: 0x0002, 21: 0xf0004800, 22: 0x0006, 23: 0x81810174 03/26/2002 20:07:08 ANR7834S GPR 24: 0x44d52068, 25: 0x1e9d, 26: 0x44d52068, 27: 0x1004a294 03/26/2002 20:07:08 ANR7834S GPR 28: 0x0001, 29: 0x0053, 30: 0x, 31: 0x300356c0 03/26/2002 20:07:08 ANR7834S IAR: 0x1000f11c LR: 0x1000f10c CONTEXT: 0x44d51c30 03/26/2002 20:07:08 ANR7833S Server thread 1 terminated in response to program abort. Any ideas what this means why it happened? Thanks, Bruce Kamp Network Analyst II Memorial Healthcare System Ph: (954) 987-2020 x4597 Fax: (954) 985-1404 E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ** 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. **