3583 Inventory Command
Is there any way to report the barcodes of tapes physically in a 3583? I'm able to see the barcodes one at a time, using the Remote Management Unit (web interface), but I'd prefer a comman-line approach. Using tapeutil (under Solaris) doesn't quite cut it, unless there is something I'm not seeing. The command: tapeutil -f /dev/rmt/1smc -o inv reports all the cells, and whether media is present, but not the barcode label. Any suggestions? Thanks, Mike
Storage Agent User Guides?
Hi Can any one help me out in finding Tivoli Storage Agent Users guides (v5.1.x) for Windows/HP-UNIX servers, I tried a lot searching in ibm.com, but still not able to find. Thanks, CRC, C.R.Chandrasekhar. Systems Analyst. Tivoli Certified Consultant (TSM). TIMKEN Engineering Research - INDIA (P) Ltd., Bangalore. Phone No: 91-80-5536113 Ext:3032. Email:[EMAIL PROTECTED] ** PLEASE NOTE: The above email address has recently changed from a previous naming standard -- if this does not match your records, please update them to use this new name in future email addressed to this individual. This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
AW: Storage Agent User Guides?
Hi Can any one help me out in finding Tivoli Storage Agent Users guides (v5.1.x) for Windows/HP-UNIX servers, I tried a lot searching in ibm.com, but still not able to find. Thanks, CRC, C.R.Chandrasekhar. For HP-Unix: http://publib.boulder.ibm.com/tividd/td/IBMStorageManagerforHP-UX5.1.html For Windows: http://publib.boulder.ibm.com/tividd/td/IBMTivoliStorageManagerforWindows5.1.html Documentation index (use the TSM for platform links): http://publib.boulder.ibm.com/tividd/td/tdprodlist.html greetings, Thomas Systems Analyst. Tivoli Certified Consultant (TSM). TIMKEN Engineering Research - INDIA (P) Ltd., Bangalore. Phone No: 91-80-5536113 Ext:3032. Email:[EMAIL PROTECTED] ** PLEASE NOTE: The above email address has recently changed from a previous naming standard -- if this does not match your records, please update them to use this new name in future email addressed to this individual. This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
Re: Storage Agent User Guides?
CRC, try the following links: http://publib.boulder.ibm.com/tividd/td/IBMStorageManagerforHP-UX5.1.html http://publib.boulder.ibm.com/tividd/td/IBMTivoliStorageManagerforWindows5.1.html Best regards, Wolfgang Bayrhof - Original Message - From: Chandrashekar, C. R. (Chandrasekhar) [EMAIL PROTECTED] Date: Mon, 15 Dec 2003 15:20:48 +0530 To: [EMAIL PROTECTED] Subject: Storage Agent User Guides? Hi Can any one help me out in finding Tivoli Storage Agent Users guides (v5.1.x) for Windows/HP-UNIX servers, I tried a lot searching in ibm.com, but still not able to find. Thanks, CRC, C.R.Chandrasekhar. Systems Analyst. Tivoli Certified Consultant (TSM). TIMKEN Engineering Research - INDIA (P) Ltd., Bangalore. Phone No: 91-80-5536113 Ext:3032. Email:[EMAIL PROTECTED] ** PLEASE NOTE: The above email address has recently changed from a previous naming standard -- if this does not match your records, please update them to use this new name in future email addressed to this individual. This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
Re: 3583 Inventory Command
Mike, The unsupported TSM command dsmadmc SHOW SLOTS library_name -id=admin -password=password will normally show the slots, element numbers, and barcodes. However, I've notice that it sometimes shows barcodes and sometimes doesn't, just as the lbtest utility. I've never discovered what the difference is when it works. Do you need to include volumes that aren't checked into TSM? If not, Q LIBVOL will show the barcode and home element number of each volume that is checked into the library via TSM, although it doesn't show the slot number or tapes that aren't yet checked in. Bill Smoldt STORServer, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mike Crawford Sent: Sunday, December 14, 2003 10:36 PM To: [EMAIL PROTECTED] Subject: 3583 Inventory Command Is there any way to report the barcodes of tapes physically in a 3583? I'm able to see the barcodes one at a time, using the Remote Management Unit (web interface), but I'd prefer a comman-line approach. Using tapeutil (under Solaris) doesn't quite cut it, unless there is something I'm not seeing. The command: tapeutil -f /dev/rmt/1smc -o inv reports all the cells, and whether media is present, but not the barcode label. Any suggestions? Thanks, Mike
Re: Anyone running TSM on Linux
We are using 5.2.1.x on RedHat 8.0 . We were using RedHat 7.2 since it is supported in versions up to 5.1.7.x but I could not upgrade from 5.1.6.x to 5.1.7.x or 5.2.x.x because none of my NFS mounted volumes would vary online. I kept getting this error for all my volumes. /var/tsm/tsmnfs5/backup13/netwaredisk240.dsm is in use by another server Been running smooth on RedHat 8.0 though. And I could upgrade TSM version after upgrading from RedHat 7.2 to 8.0 :-) Kevin Godfrey wrote: I have a test server running on Red Hat 9. It is very stable, even though my particular version of Red Hat is not officially supported by IBM. Performance is at least as good as on a similar spec'd production machine running Windows 2000 Server. The only difference that I have noticed is that formatting disk volumes always seems to go faster on Windows than *nix - can anyone explain why? Alas I have only DASD available for storage in the Linux machine so I can't commit on the tape drives you mentioned. Also, I've had no need (as yet ;-) to call support, but I guess it's as good as IBM support usually is. No reason to expect any different, especially taking into account IBM's focus on Linux. Or did you mean device/kernel support? I found a list of that on the 'net: http://www-1.ibm.com/support/docview.wss?rs=0uid=swg21107360 Kind regards Kevin Godfrey (IT Support) Caths Co. U.K. Hello all - We currently have TSM running on Solaris and have had it for about 6 years now. We are thinking about switching to Linux - Does anyone have answers to the following: 1. Anyone running TSM on Red Hat Linux AS 2.1? 2. Anyone running TSM on a X360? 3. How is the performance, stability? 4. How is the TSM support for Linux? 5. TSM on Red Hat with AIT2 or AIT3 tape drives? Any help will be much appreciated. Thanks!
AIX 64bit and TDP oracle????
Hi every one What version of TDP oracle can i use whith AIX 5.1 64bit and TSM client 5.1. ?? With the TDP 5.1.5 i have a lot of problems on AIX 64bit. thank you more Youssef * Ce message et toutes les pieces jointes (ci-apres le message) sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. *
Re: AIX 64bit and TDP oracle????
Youssef, You should use Data Protection for Oracle 5.2. Can you be a bit more specific about the problems you are encountering? Regards, Neil Rasmussen Software Development Data Protection for Oracle AMHOUCHE Youssef [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 12/15/2003 06:09 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:AIX 64bit and TDP oracle Hi every one What version of TDP oracle can i use whith AIX 5.1 64bit and TSM client 5.1. ?? With the TDP 5.1.5 i have a lot of problems on AIX 64bit. thank you more Youssef * Ce message et toutes les pieces jointes (ci-apres le message) sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. *
Netware Cluster config question
I have TSM server 4.2.3.4 and am setting up a Netware 6.0 Cluster with TSM client 5.1.6.0. The Netware Admin is doing most of this. He says that he needs to unload dsmc in a NCF file. However it prompts you if you really want to do this etc. The NCF script doesn't allow passing parameters to the unload command. How should he do this? Thanks, 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.5509 [EMAIL PROTECTED] ## 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: Netware Cluster config question
Hi David, you shouldn't execute unload dsmc by a ncf-batch, because there's a good chance to crash the NetWare server with this command. That's probably the reason for the prompt. Additionally all DSMC stanzas of all cluster-resources on the corresponding node would be unloaded by the ncf-file of one cluster-resource. However, we run several cluster configurations with NetWare 6.0 and use the recommended way by using DSMCAD.NLM. You can copy this NLM and use one copy for each cluster-resource. By unloading the correct DSMCADxx.NLM you get just the right stanza down. The loaded DSMCADxx.NLM will load the DSMC.NLM, when it is needed and unload it, when not. Best regards, Wolfgang Bayrhof
Re: Netware Cluster config question
This is exactly the procedure we use. Works beautifully. Wolfgang Bayrhof wrote: Hi David, you shouldn't execute unload dsmc by a ncf-batch, because there's a good chance to crash the NetWare server with this command. That's probably the reason for the prompt. Additionally all DSMC stanzas of all cluster-resources on the corresponding node would be unloaded by the ncf-file of one cluster-resource. However, we run several cluster configurations with NetWare 6.0 and use the recommended way by using DSMCAD.NLM. You can copy this NLM and use one copy for each cluster-resource. By unloading the correct DSMCADxx.NLM you get just the right stanza down. The loaded DSMCADxx.NLM will load the DSMC.NLM, when it is needed and unload it, when not. Best regards, Wolfgang Bayrhof -- Jim Kirkman AIS - Systems UNC-Chapel Hill 966-5884
Java errs on Red Hat / Windows XP Pro?
We have a Red Hat Linux 8.0 web server with / Tivoli 5.2. Backups and dsmc work, but accessing Tivoli's web client from a Windows XP Pro SP1 desktop doesn't work. The error points to Java, and at someone's suggestion we've tried downgrading the desktop (using IE 6.0 SP1) from JRE 1.4.2+ to 1.3.1_01 - with difficulty and no luck. We would like to talk with someone that has been through this. Thanks!
Réf. : Java errs on Red Hat / Windows XP Pro?
Try to disable JAVA2.2 in your internet explorer options. I had this on W2K. Wishes, Magalie Siaud. David Menges [EMAIL PROTECTED] Envoyé par : ADSM: Dist Stor Manager [EMAIL PROTECTED] 16/12/03 08:57 Veuillez répondre à ADSM: Dist Stor Manager Pour : [EMAIL PROTECTED] cc : Objet : Java errs on Red Hat / Windows XP Pro? We have a Red Hat Linux 8.0 web server with / Tivoli 5.2. Backups and dsmc work, but accessing Tivoli's web client from a Windows XP Pro SP1 desktop doesn't work. The error points to Java, and at someone's suggestion we've tried downgrading the desktop (using IE 6.0 SP1) from JRE 1.4.2+ to 1.3.1_01 - with difficulty and no luck. We would like to talk with someone that has been through this. Thanks!
Exchange backup performance
Hello all, I am trying to see if anyone has any quick suggestions on backing up Exchange 2000. I am seeing some horrible performance as you can see from the below stats. This server has never had speedy TDP backups, BAclient backups normally are in the 10MB/sec range. The connection is a gigabit connection, from the tcp transfer tests I have done with WSTTCP I should be able to hit 18MB/sec. My Domino servers with 350Gb of data on the same network hit upwards of 14MB/sec. One thing that I am noticing is that store.exe is consuming 90% of the cpu. These stats are from a full backup taken when no-one else was using the TSM server or the exchange server. 12/15/2003 14:23:34 Total storage groups requested for backup: 1 12/15/2003 14:23:34 Total storage groups backed up: 1 12/15/2003 14:23:34 Total storage groups expired: 8 12/15/2003 14:23:34 Total storage groups excluded: 0 12/15/2003 14:23:34 Throughput rate:2,956.63 Kb/Sec 12/15/2003 14:23:34 Total bytes transferred: 55,004,847,682 12/15/2003 14:23:34 Elapsed processing time: 18,167.84 Secs Does anyone have any suggestions? Maybe exchange tuning? Anything is appreciated. Environment server Windows 2000 SP3 5.1.6.2 Client Windows 2000 SP3 Client BA 5.1.5.15 Client TDP 5.1.5.0 Exchange Server Version: 6.0.6396.1 BUFFers 3 BUFFERSIze 64
Re: Exchange backup performance
Did you try adjusting your buffersize. We have ours set at 1024 and see pretty good performance. -Original Message- From: Redell, Greg S. [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 5:59 PM To: [EMAIL PROTECTED] Subject: Exchange backup performance Hello all, I am trying to see if anyone has any quick suggestions on backing up Exchange 2000. I am seeing some horrible performance as you can see from the below stats. This server has never had speedy TDP backups, BAclient backups normally are in the 10MB/sec range. The connection is a gigabit connection, from the tcp transfer tests I have done with WSTTCP I should be able to hit 18MB/sec. My Domino servers with 350Gb of data on the same network hit upwards of 14MB/sec. One thing that I am noticing is that store.exe is consuming 90% of the cpu. These stats are from a full backup taken when no-one else was using the TSM server or the exchange server. 12/15/2003 14:23:34 Total storage groups requested for backup: 1 12/15/2003 14:23:34 Total storage groups backed up: 1 12/15/2003 14:23:34 Total storage groups expired: 8 12/15/2003 14:23:34 Total storage groups excluded: 0 12/15/2003 14:23:34 Throughput rate:2,956.63 Kb/Sec 12/15/2003 14:23:34 Total bytes transferred: 55,004,847,682 12/15/2003 14:23:34 Elapsed processing time: 18,167.84 Secs Does anyone have any suggestions? Maybe exchange tuning? Anything is appreciated. Environment server Windows 2000 SP3 5.1.6.2 Client Windows 2000 SP3 Client BA 5.1.5.15 Client TDP 5.1.5.0 Exchange Server Version: 6.0.6396.1 BUFFers 3 BUFFERSIze 64
Re: ATA random versus sequential access pool
We have been using random access storage pools on ATA drives for almost 3 years now. Works well. Bob Barden wrote: We are currently looking at utilizing ATA disk for our TSM onsite inventory. The question at this point is do we utilize a Random access pool or a Sequential access pool for our backups. We see potential Pro's and Con's for both. Any real life experiences that you could share would be most appreciated. Bob Barden Technical Systems Analyst Storage Services 920-628-2487 [EMAIL PROTECTED] Thrivent Financial for Lutherans 4321 N. Ballard Road Appleton, Wi. 54919 http://www.thivent.com
SNMP Setup for TSM 5.1.8.0 on Win2K Server
Following the instructions in http://support.ipswitch.com/kb/WG-20020522-DM01.htm I was able to get SNMP resource monitoring functioning on my Win2K box which acts as my TSM Server. Now I'd like to be able to access the TSM SNMP functions through the subagent, but am somewhat at a loss. The Admin Guide isn't very clear about a number of aspects of this process but it suggests that it can't use the W2K SNMP agent. Has anyone tried this interface for other than Netview? I'd like to use it with What's Up Gold or MRTG and could use some guidance. I found nothing in the ADSM archives or Redbooks ... perhaps I missed it? TIA, -- Dwight McCann Computer and Network Technologist, UCSB Info Systems Computing [EMAIL PROTECTED], [EMAIL PROTECTED] http://borg.isc.ucsb.edu/dmm/ - office: 805-893-3113
Re: Intermittant TSM Server - Database stops
Hi all, Sorry to trouble all of you. Here is an event that happened last week during normal operations, while a large query was being run on the TSM database. 12/11/03 01:08:13 ANR2561I Schedule prompter contacting ICMC02RPA (session 4174) to start a scheduled operation. 12/11/03 01:08:32 ANR2017I Administrator OPS issued command: FETCH NEXT 50 12/11/03 01:08:37 ANR2958E SQL temporary table storage has been exhausted. The explanation seems pretty self explanantory. The server was restarted all seemed ok for about 12 hours. We have added another extended the database by means of another dataase volume and refrained from performing any major SQL queries etc.. Since then, TSM Server stops at random times. (no messages in the actlog) The server just falls and has to be restarted. The only clue something has happened is in the errpt -a LABEL: CORE_DUMP IDENTIFIER: 1F0B7B49 Date/Time: Mon Dec 15 23:33:11 WAUS Sequence Number: 40038 Machine Id: D62A4C00 Node Id: rsfm014 Class: S Type:PERM Resource Name: SYSPROC Description SOFTWARE PROGRAM ABNORMALLY TERMINATED Probable Causes SOFTWARE PROGRAM User Causes USER GENERATED SIGNAL Recommended Actions CORRECT THEN RETRY Failure Causes SOFTWARE PROGRAM Recommended Actions RERUN THE APPLICATION PROGRAM IF PROBLEM PERSISTS THEN DO THE FOLLOWING CONTACT APPROPRIATE SERVICE REPRESENTATIVE Detail Data SIGNAL NUMBER 6 USER'S PROCESS ID: 44974 FILE SYSTEM SERIAL NUMBER 2 INODE NUMBER 215060 PROCESSOR ID 0 PROGRAM NAME dsmserv ADDITIONAL INFORMATION pthread_k A8 ?? _p_raise 64 raise 34 abort B8 AbortServ 80 TrapHandl 13C ?? ?? Symptom Data REPORTABLE 1 INTERNAL ERROR 0 SYMPTOM CODE PCSS/SPI2 FLDS/dsmserv SIG/6 FLDS/AbortServ VALU/80 End result is that TSM has gone very flakey and falls over a odd times. Has anyone encounter this before. If so what are my options? We are looking at doing an unloaddb then reload etc... (If I can get my head around the procedure).. Any help would be greatly appreciated Thanks in advance TSM'ers! Cheers Stephen Pole WA Dept of Health [EMAIL PROTECTED]
Re: Intermittant TSM Server - Database stops
SQL Query using TSM Log, it happed with us, and solve with extend TSM Log size. Before normal operation, please run TSM Server in console mode, this is the best way troubleshooting after TSM Server crash SN - Original Message - From: Pole, Stephen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 11:36 AM Subject: Re: Intermittant TSM Server - Database stops Hi all, Sorry to trouble all of you. Here is an event that happened last week during normal operations, while a large query was being run on the TSM database. 12/11/03 01:08:13 ANR2561I Schedule prompter contacting ICMC02RPA (session 4174) to start a scheduled operation. 12/11/03 01:08:32 ANR2017I Administrator OPS issued command: FETCH NEXT 50 12/11/03 01:08:37 ANR2958E SQL temporary table storage has been exhausted. The explanation seems pretty self explanantory. The server was restarted all seemed ok for about 12 hours. We have added another extended the database by means of another dataase volume and refrained from performing any major SQL queries etc.. Since then, TSM Server stops at random times. (no messages in the actlog) The server just falls and has to be restarted. The only clue something has happened is in the errpt -a LABEL: CORE_DUMP IDENTIFIER: 1F0B7B49 Date/Time: Mon Dec 15 23:33:11 WAUS Sequence Number: 40038 Machine Id: D62A4C00 Node Id: rsfm014 Class: S Type:PERM Resource Name: SYSPROC Description SOFTWARE PROGRAM ABNORMALLY TERMINATED Probable Causes SOFTWARE PROGRAM User Causes USER GENERATED SIGNAL Recommended Actions CORRECT THEN RETRY Failure Causes SOFTWARE PROGRAM Recommended Actions RERUN THE APPLICATION PROGRAM IF PROBLEM PERSISTS THEN DO THE FOLLOWING CONTACT APPROPRIATE SERVICE REPRESENTATIVE Detail Data SIGNAL NUMBER 6 USER'S PROCESS ID: 44974 FILE SYSTEM SERIAL NUMBER 2 INODE NUMBER 215060 PROCESSOR ID 0 PROGRAM NAME dsmserv ADDITIONAL INFORMATION pthread_k A8 ?? _p_raise 64 raise 34 abort B8 AbortServ 80 TrapHandl 13C ?? ?? Symptom Data REPORTABLE 1 INTERNAL ERROR 0 SYMPTOM CODE PCSS/SPI2 FLDS/dsmserv SIG/6 FLDS/AbortServ VALU/80 End result is that TSM has gone very flakey and falls over a odd times. Has anyone encounter this before. If so what are my options? We are looking at doing an unloaddb then reload etc... (If I can get my head around the procedure).. Any help would be greatly appreciated Thanks in advance TSM'ers! Cheers Stephen Pole WA Dept of Health [EMAIL PROTECTED]
Intermittant TSM Server - Database stops
TSM'ers Being the first time attempting such as process here is a plan 1. Perform database backup 2. Copy to another location (other machine) a) dsmserv.opt b) dsmserv.dsk c) volhist (volume history file) d) devconfig ( device config file) 3. Set the server to start in quiet mode. Modify the server dsmserv.opt a) change client ports to 15000 (Stops client from logging on) b) set expinterval to 0 as this prevents inventory from expiring starting immediately after a server startup. c) add NOMIGRRECL to prevent TSM from starting space reclamation or migration. d) Set DISABLESCHEDS to YES (this prevents any TSM Schedules from running 4. Edit devconfig file to contain file deveice class to store the unloaded database on it. define declass fileclass devtyep=file mountlimit=5 maxcap=5G dir=/tsmtemp 5. From Server directory run DSMSERV UNLOADDB DEVclass=fileclass Then we will perform the following steps after a successful UNLOADDB. This is to ensure that the files created for the database and recovery logvolumes do not exist on the system otherwise LOADFORMAT process will fail. 6. Create file called /usr/temp/LOGVOL.TXT. Edit the file to contain the following:- var/tsm/tsmlog/log01.dsm 512 var/tsm/tsmlog/log02.dsm 512 var/tsm/tsmlog/log03.dsm 512 var/tsm/tsmlog/log04.dsm 512 7. Create a file called /usr/temp/DBVOL.TXT, edit the file to contain the following:- /var/tsm/tsmdb1/db01.dsm 5000 /var/tsm/tsmdb1/db02.dsm 5000 /var/tsm/tsmdb1/db03.dsm 5000 /var/tsm/tsmdb1/db04.dsm 5000 8. From server directory issue DSMSERV loadformat 4 FILE:/usr/temp/LOGVOL.TXT 4 FILE:/usr/temp/DBVOL.TXT 9. DSMSERV LOADDB DEVclass=fileclass VOLumenames=/tsmtemp/volname1,/tsmtemp/volname2, /tsmtemp/volname3,/tsmtemp/volname4 If LOADDB spits up any errors then run AUDITDB eg DSMSERV AUDITDB FIX=YES DETAIL=YES FILE=/usrtemp/AUDITDB.TXT 10. After finshing the above. Restore the orginal devconfig.out to original settings 11 Start TSM Server from commandline 12. Perform a Full DB Backup 13 HALT the TSM Server 14. Restore the orginal DSMSERV.OPT file 15. Define mirror volumes (db and log vols using the dsmfmt command) Define the group of mirrored volumes 16 Restart the TSM Server Any comments or gottcha's would be greatly appreciated. Thanks in advance Stephen - - Original Message - From: Pole, Stephen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 11:36 AM Subject: Re: Intermittant TSM Server - Database stops Hi all, Sorry to trouble all of you. Here is an event that happened last week during normal operations, while a large query was being run on the TSM database. 12/11/03 01:08:13 ANR2561I Schedule prompter contacting ICMC02RPA (session 4174) to start a scheduled operation. 12/11/03 01:08:32 ANR2017I Administrator OPS issued command: FETCH NEXT 50 12/11/03 01:08:37 ANR2958E SQL temporary table storage has been exhausted. The explanation seems pretty self explanantory. The server was restarted all seemed ok for about 12 hours. We have added another extended the database by means of another dataase volume and refrained from performing any major SQL queries etc.. Since then, TSM Server stops at random times. (no messages in the actlog) The server just falls and has to be restarted. The only clue something has happened is in the errpt -a LABEL: CORE_DUMP IDENTIFIER: 1F0B7B49 Date/Time: Mon Dec 15 23:33:11 WAUS Sequence Number: 40038 Machine Id: D62A4C00 Node Id: rsfm014 Class: S Type:PERM Resource Name: SYSPROC Description SOFTWARE PROGRAM ABNORMALLY TERMINATED Probable Causes SOFTWARE PROGRAM User Causes USER GENERATED SIGNAL Recommended Actions CORRECT THEN RETRY Failure Causes SOFTWARE PROGRAM Recommended Actions RERUN THE APPLICATION PROGRAM IF PROBLEM PERSISTS THEN DO THE FOLLOWING CONTACT APPROPRIATE SERVICE REPRESENTATIVE Detail Data SIGNAL NUMBER 6 USER'S PROCESS ID: 44974 FILE SYSTEM SERIAL NUMBER 2 INODE NUMBER 215060 PROCESSOR ID 0 PROGRAM NAME dsmserv ADDITIONAL INFORMATION pthread_k A8 ?? _p_raise 64 raise 34 abort B8 AbortServ 80 TrapHandl 13C ?? ?? Symptom Data REPORTABLE 1 INTERNAL ERROR 0 SYMPTOM CODE PCSS/SPI2 FLDS/dsmserv SIG/6 FLDS/AbortServ VALU/80 End result is that TSM has gone very flakey and falls over a odd times. Has anyone encounter this before. If so what are my options? We are looking at doing an unloaddb then reload etc... (If I can get my head around the procedure).. Any help would be greatly appreciated Thanks in advance TSM'ers! Cheers Stephen Pole WA Dept of Health [EMAIL PROTECTED] -Original Message- From: Sony Priyambodo [mailto:[EMAIL PROTECTED] Sent: 16 December, 2003