DHCP.MDB fails to archive
Hi All when I run an archive on a windows 2000 machine that host my DHCP server the dchp.mdb file fails with an error. (in used by another process) how can I backup / archive this file. Below is my archive copy group. I currently run TSM 5.1.5 on windows 2000 platform and the clients are also 5.1.5 This is just something I'm doing as a trial to market the product and the customer is not impressed with this failure. Everything else has worked great. Active directory backup and restore, SAP/R3 backup and restore etc etc... just this one hurdle. Policy Domain Name WINDOWS_TEMP Policy Set Name ACTIVE Mgmt Class Name WINDOWS_TEMP Copy Group Name STANDARD Retain Version 28 Copy Serialization DYNAMIC Copy Destination WINDOWS_TEMP Last Update Date/Time2003-01-31 08:23:54.00 Last Update by (administrator) YANDA Managing profile - Kind Regards LAWRIE SCOTT For: Persetel/Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Notice: This message and any attachments are confidential and intended solely for the addressee. If any have received this message in error, please notify Lawrie Scott at Comparex Africa (Pty) Ltd immediately, telephone number +27 (0) 31 5609222. Any unauthorised use, alteration or dissemination is prohibited. Comparex Africa (Pty) Ltd accepts no liability whatsoever for any loss whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
Backup of Windows DHCP.mdb
Hi All I have TSM 5.1.5 both server and client for windows 2000. When I back up my one server with the DHCP.mdb file on it this file fails as it is an open file. How can I back up this file or at least ensure that it is getting backed up in some other way. Kind Regards LAWRIE SCOTT For: Persetel/Q Vector KZN Company Registration Number: 1993/003683/07 E-mail: [EMAIL PROTECTED]
SAP Timeout
Hi All I run TSM Server 5.1.5 on Windows 2000 and SAP/R3 on Tru64/UNix using the TSM SAP TDP. I wish to know if there is a timeout value that can used to cancel a backup if not completed within a specified time. I schedule the backups then using a script begin the backups, which in turn perform all the needed steps to backup my databases. However if there is a storage shortage or some other error that causes the TDP to wait for the TSM Server, I would like to be able to timeout the script and fail the schedule. Otherwise the operators have to manually cancel each session as it starts up and only when there are no more sessions will the script end and return a failure code. Kind Regards LAWRIE SCOTT For: Persetel/Q Vector KZN E-mail: [EMAIL PROTECTED]
Re: Oracle scheduler fails if started in background
Not sure But the response of Completed comes from the fact that the script is completed. I get a completed status from my TDP's as long as the script completes, even if no tablespaces were backed up. Lawrie -Original Message- From: Kolbeinn Josepsson [mailto:[EMAIL PROTECTED]] Sent: 17 January 2003 01:21 To: [EMAIL PROTECTED] Subject: Oracle scheduler fails if started in background Hi everyone, We have strange behavior on TDP Oracle backup (TSM scheduled), we installed exactly same configuration on another Solaris box where the scheduled backup (in backround) completed sucessfully, as far as I know the only difference is Solaris version 8. All comments are welcome. TSM Server 5.1.5.2 on W2K platform TSM BA Client 5.1.5.0 and TDPO 5.1.5 on Solaris 2.6 If we start the scheduler in foreground, the backup completes whithout error. We use this command: /opt/tivoli/tsm/client/ba/bin/dsmc sched -se=tsm1_sched If we start the scheduler in background, the backup fails, but Q EVENTS says Completed, RMAN dos not start (no records in the RMAN Log). We use the "at" command to start the scheduler in background: at now /opt/tivoli/tsm/client/ba/bin/dsmc sched -se=tsm1_sched "ctrl-D" Following are records from actlog, schedlog and q events, when backup fails (shedule started in background). Also the dsm.sys file. actlog: 08-01-2003 04:20:00 for node E450_ORA completed successfully at 08-01-2003 04:58:51. 08-01-2003 04:58:51 ANR0403I Session 1401 ended for node E450_ORA (SUN dsmsched.log: Executing scheduled command now. 01/08/03 04:58:39 Node Name: E450_ORA 01/08/03 04:58:39 Session established with server TSM1: Windows 01/08/03 04:58:39 Server Version 5, Release 1, Level 5.2 01/08/03 04:58:39 Server date/time: 01/08/03 04:58:51 Last access: 01/08/03 03:27:51 01/08/03 04:58:39 Executing Operating System command or script: /u01/app/oracle/local/bin/hotrman.sh 01/08/03 04:58:39 Finished command. Return code is: 1 01/08/03 04:58:39 ANS1909E The scheduled command failed. 01/08/03 04:58:39 ANS1512E Scheduled event 'DAYLY_ORA' failed. Return code = 1. 01/08/03 04:58:39 Sending results for scheduled event 'DAYLY_ORA'. 01/08/03 04:58:39 Results sent to server for scheduled event 'DAYLY_ORA'. q event: 08-01-2003 04:20:00 08-01-2003 04:58:51 DAYLY_ORA E450_ORA Completed dsm.sys: SERVERNAME tsm1_ba nodename e450 commmethod TCPIP tcpport1500 tcpserveraddress tsm1.zzz.is tcpbuffsize32 tcpnodelay yes tcpwindowsize 1023 largecommbuffers yes schedlogname /var/log/tivoli/ba/dsmsched.log schedlogretention 10,d errorlogname /var/log/tivoli/ba/dsmerror.log errorlogretention 10,d passwordaccess generate SERVERNAME tsm1_ora nodename e450_ora commmethod TCPIP tcpport1500 tcpserveraddress tsm1.zzz.is tcpbuffsize32 tcpnodelay yes tcpwindowsize 1023 largecommbuffers yes schedlogname /var/log/tivoli/ora/dsmsched.log schedlogretention 10,d errorlogname /var/log/tivoli/ora/dsmerror.log errorlogretention 10,d passwordaccess prompt SERVERNAME tsm1_sched nodename e450_ora commmethod TCPIP tcpport1500 tcpserveraddress tsm1.zzz.is tcpbuffsize32 tcpnodelay yes tcpwindowsize 1023 largecommbuffers yes schedlogname /var/log/tivoli/ora/dsmsched.log schedlogretention 10,d errorlogname /var/log/tivoli/ora/dsmerror.log errorlogretention 10,d passwordaccess generate Best regards, Kolbeinn Josepsson 7 Systems Engineer www.nyherji.is
Re: On which volumes are my files?
Hi I generally use the following select statement, however if there is an easier way please let me know. select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='nodename' and stgpool_name='storage pool' Lawrie -Original Message- From: Werner Baur [mailto:[EMAIL PROTECTED]] Sent: 03 January 2003 09:33 To: [EMAIL PROTECTED] Subject: On which volumes are my files? Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. Thanks for any ideas, Werner -- Werner BaurTel.:++49-89-28928781 Leibniz-Rechenzentrum Fax:++49-89-2809460 Barer Str. 21mailto:[EMAIL PROTECTED] D-80333 Muenchen, Germany http://www.lrz.de
SAP TDP Restore
Hi All I am running TSM 5.1.5 on Windows 2000 and SAP/R3 using Oracle on a TRU64 Unix Cluster. I backup the SAP Databases using the SAP/R3 TDP for Tivoli on Tru64 Unix. I wish to restore the SPP (Production Database) to the SPQ (QA Database) location, overwriting the SPQ database with SPP's database. However when I use the SAPDBA tools it does not allow me to point SPP restores to a new location. The only way I can see roumd this is to stop SPP rename it to SPQ and then Restore SPP, or modify the *.anf File from SPP's backup with SPQ's location. I am not very knowledgeable on SAP/R3, so any help will be greatly appreciated. This has been requested for test purposes and will not be the normal practice. With the cluster consiting of 4 Compaq GS80 Servers these databases can be running on any of the four machine, as the cluster software points to a primary machine however if it fails the databases, applications etc. etc. get failed over to one of the other 3 machines. So while there are 4 CPU's the is not physical distinction as to where the databases and applications are running. Therefore all 4 CPU's share the same directory structure on a set of SAN disks aswell. Kind Regards LAWRIE SCOTT For: Persetel/Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED]
Re: Expiring Of Data
Hi I have tried another file and below is the result. Operation Results NODE_NAME: ALSBCK FILESPACE_NAME: \\alsbck\c$ FILESPACE_ID: 1 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: DSM.OPT OBJECT_ID: 22617845 BACKUP_DATE: 2002-11-05 19:03:11.00 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: \\alsbck\c$ FILESPACE_ID: 1 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \PROGRAM FILES\TIVOLI PATCHES\SCRIPTS\ LL_NAME: DSM.OPT OBJECT_ID: 10712409 BACKUP_DATE: 2002-08-13 20:27:40.00 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: \\alsbck\c$ FILESPACE_ID: 1 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \PROGRAM FILES\TIVOLI PATCHES\WINDOWS2000\ LL_NAME: DSM.OPT OBJECT_ID: 9981973 BACKUP_DATE: 2002-08-09 20:52:09.00 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: \\alsbck\c$ FILESPACE_ID: 1 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \RECYCLER\S-1-5-21-1614895754-176339-725345543-1396\DC1\ LL_NAME: DSM.OPT OBJECT_ID: 25990473 BACKUP_DATE: 2002-11-29 09:23:28.00 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT -Original Message- From: John Naylor [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 10:36 To: [EMAIL PROTECTED] Subject: Have you got this with anything other than system objects. If not you need to have a look back at this years www.adsm.org for problem expiring system objects and action to take, Lawrie Scott - Persetel Q Vector <[EMAIL PROTECTED]> on 12/20/2002 06:04:40 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Hi All I am trying to expire all my data except the latest active version. My backup copy group settings are as follows:- Policy Domain Name WINDOWS Policy Set Name ACTIVE Mgmt Class Name WINDOWS Copy Group Name STANDARD Versions Data Exists 1 Versions Data Deleted 0 Retain Extra Versions 0 Retain Only Version 0 Copy Mode MODIFIED Copy Serialization DYNAMIC Copy Frequency 0 Copy Destination WINDOWS Last Update Date/Time 2002-12-20 07:52:24.00 Last Update by (administrator) ADMIN Managing profile - However when I use a select statement just to look at one file to see its status this is what I see:- select * from backups where node_name='ALSBCK' and ll_name='BOOT.INI' Operation Results NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 28209279 BACKUP_DATE: 2002-12-20 00:10:03.00 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 21347128 BACKUP_DATE: 2002-10-29 19:41:41.00 DEACTIVATE_DATE: 2002-11-04 23:57:37.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22179567 BACKUP_DATE: 2002-11-04 23:57:37.00 DEACTIVATE_DATE: 2002-11-05 21:13:14.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22618038 BACKUP_DATE: 2002-11-05 21:13:14.00 DEACTIVATE_DATE: 2002-11-06 19:36:13.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22875347 BACKUP_DATE: 2002-11-06 19:36:13.00 DEACTIVATE_DATE: 2002-11-11 19:41:46.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 23481388 BACKUP_DATE: 2002-11-11 19:41:46.00 DEACTIVATE_DATE: 2002-11-19 17:15:50.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 24304303 BACKUP_DATE: 2002-11-19 17:15:50.00 DEACTIVATE_DATE: 2002-11-29 09:41:35.00 OWNER: CLASS_NAME: DEFAUL
[no subject]
Hi All I am trying to expire all my data except the latest active version. My backup copy group settings are as follows:- Policy Domain Name WINDOWS Policy Set Name ACTIVE Mgmt Class Name WINDOWS Copy Group Name STANDARD Versions Data Exists 1 Versions Data Deleted 0 Retain Extra Versions 0 Retain Only Version 0 Copy Mode MODIFIED Copy Serialization DYNAMIC Copy Frequency 0 Copy Destination WINDOWS Last Update Date/Time 2002-12-20 07:52:24.00 Last Update by (administrator) ADMIN Managing profile - However when I use a select statement just to look at one file to see its status this is what I see:- select * from backups where node_name='ALSBCK' and ll_name='BOOT.INI' Operation Results NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 28209279 BACKUP_DATE: 2002-12-20 00:10:03.00 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 21347128 BACKUP_DATE: 2002-10-29 19:41:41.00 DEACTIVATE_DATE: 2002-11-04 23:57:37.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22179567 BACKUP_DATE: 2002-11-04 23:57:37.00 DEACTIVATE_DATE: 2002-11-05 21:13:14.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22618038 BACKUP_DATE: 2002-11-05 21:13:14.00 DEACTIVATE_DATE: 2002-11-06 19:36:13.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 22875347 BACKUP_DATE: 2002-11-06 19:36:13.00 DEACTIVATE_DATE: 2002-11-11 19:41:46.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 23481388 BACKUP_DATE: 2002-11-11 19:41:46.00 DEACTIVATE_DATE: 2002-11-19 17:15:50.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 24304303 BACKUP_DATE: 2002-11-19 17:15:50.00 DEACTIVATE_DATE: 2002-11-29 09:41:35.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 25991488 BACKUP_DATE: 2002-11-29 09:41:35.00 DEACTIVATE_DATE: 2002-11-29 23:46:42.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 26097958 BACKUP_DATE: 2002-11-29 23:46:42.00 DEACTIVATE_DATE: 2002-12-01 21:59:49.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 26259332 BACKUP_DATE: 2002-12-01 21:59:49.00 DEACTIVATE_DATE: 2002-12-02 23:07:36.00 OWNER: CLASS_NAME: DEFAULT NODE_NAME: ALSBCK FILESPACE_NAME: SYSTEM OBJECT FILESPACE_ID: 3 STATE: INACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: BOOT.INI OBJECT_ID: 26442741 BACKUP_DATE: 2002-12-02 23:07:36.00 DEACTIVATE_DATE: 2002-12-05 12:05:07.00 OWNER: CLASS_NAME: DEFAULT There is still a whole lot of inactive files available some as far back as a month. The expire command i'm using is and some files where delete according to the query process however nowhere near enough as can be seen from the select statement. Help I need to get this done to restructure our TSM server:- Kind Regards LAWRIE SCOTT
Re: Non IBM Libarary for TSM
Hi I'm not sure about the pricing but HP have good small libraries. I use an old DLT7000 system that works great. Maybe look at some libraries and then check the TSM site for compatibility. Lawrie -Original Message- From: Raghu S [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 01:45 To: [EMAIL PROTECTED] Subject: Non IBM Libarary for TSM Hi I work on TSM soluion design. Most of the time i see customer unhappy with the price of 3583 LTO. ( I stopped suggesting single drive libraries for TSM ). I found Magstar 3570 MP is a suitable one for medium sized corporates.I have no idea on Non IBM libraries.Can anybody suggest me Non IBM libraries and corresponding URLs ( Should work with TSM as efficient as IBM libraries and cheaper). Thanks in advance Regards Raghu. Richard Foster cc: Sent by: "ADSM: Subject: Re: timeout value for processes Dist Stor Manager" <[EMAIL PROTECTED] T.EDU> 12/18/2002 04:20 PM Please respond to "ADSM: Dist Stor Manager" The Mountwait parameter only specifies how long the process will wait for a tape to be mounted after the process has been allocated the necessary drive(s). If I understand Henrik's question, there doesn't appear to be a parameter which governs how long a process will wait for the tape drives to become available. We just run a script which cancels all Reclaim processes, whether they are active, waiting for tape mounts or waiting for drives. Richard Foster Norsk Hydro mountwait parameter in devclass definition regds Raghu Hi all! Is there a server option or a another why to specify for how long a process will be active? Example, If all drives are busy I might not want reclamation to be pending for hours until two drive becomes available. Henrik.Wahlstedt
Expiring Data / Versioning
Hi All Thanx in advance, new to this and not sure I've set this up correctly. I originally wanted to keep 7 versions and delete after 30 days any deleted files. I run TSM Server 5.1 and I'm trying to expire all my data down to only one copy of the data. My versions were set to 7 and the rest as shown, I changed it down to 3 and ran an inventory expire this made no changes. Have I setup my copy group incorrectly. I wish to finally setup the copy group to have seven days(not versions) backups and to only keep deleted files for a max of 30 days. Copy Group Name STANDARD Versions Data Exists 3 Versions Data Deleted 1 Retain Extra Versions 0 Retain Only Version 30 Copy Mode MODIFIED Copy Serialization DYNAMIC Copy Frequency 0 Kind Regards LAWRIE SCOTT For: Persetel/Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] Notice: This message and any attachments are confidential and intended solely for the addressee. If any have received this message in error, please notify Lawrie Scott at Comparex Africa (Pty) Ltd immediately, telephone number +27 (0) 31 5609222. Any unauthorised use, alteration or dissemination is prohibited. Comparex Africa (Pty) Ltd accepts no liability whatsoever for any loss whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
Re: Microsoft SQL Hot/Backup
Hi We use Microsoft SQL's Tools and TSM to back up the flat file it creates. Otherwise you could use the TSM TDP for SQL to script these backups. Lawrie - Original Message - From: "Camilo A. Marrugo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 6:33 PM Subject: Microsoft SQL Hot/Backup Good Morning TSM'ers, I am sure some of you are using some type of setting or software to backup your SQL databases in windows 2k. If you could share some names of software, or knowledge about this it will be apreciated. Thanks, Camilo M. -- Camilo A. Marrugo Data Storage Manager Dialtone Interland [EMAIL PROTECTED] - http://www.dialtone.com Voice: (954) 581-0097 - Fax: (954) 581-7629
Session Not Completing
Hi All I have 30 Windows 2000 Servers backing up to a Windows TSM 5.1 Server. One of the servers when scheduled to backup begins its schedule and backup then just sits doing nothing, it never comes back to the server with a status and you have to cancel the session manually then it reports back a ? which is very informative. When you look in the dsmerror and dsmsched logs there is nothing to indicate an error, other than the cancelled session. This seems to happen on only this server and we have tried re-installing the software modifying the dsm.opt file, re-installing the schedule service with no change. Any help greatly appreciated. Thanx in advance. Lawrie Scott For: Persetel / Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Compaq Network Settings
Hi All I have a compaq Proliant 370 with 2 750Mhz CPU's With 2Gig of Memory and 2 1Gigabit Network Cards, teamed with 1 active and the other is a failover standby card. Does anyone have some info on how best to setup these cards for the best performance. I have a number of errors where I get timeouts on these cards and they both show Receive Overruns when this happens. If anyone has an answer on how best to setup these cards I would be really grateful as, I have tried just about everything and the only thing I can get to work is by reducing max sessions to 40 and increasing the network card setting for receiving to the max of 768, also running only one card the other one has been removed. Lawrie Scott For: Persetel / Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Re: Poor Performance
Hi all Thanx for all the replies some of the tricks have helped a bit. However the TCPWindowsSize of 16 is set as CISCO has a limitation of TCPwindowsize of 16 and whenever we increase it to 63 the server then begins to timeout server requests and no backups happen. Lawrie Scott For: Persetel / Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] <mailto:lawries@;comparexafrica.co.za> Notice: This message and any attachments are confidential and intended solely for the addressee. If any have received this message in error, please notify Lawrie Scott at Comparex Africa (Pty) Ltd immediately, telephone number +27 (0) 31 5609222. Any unauthorised use, alteration or dissemination is prohibited. Comparex Africa (Pty) Ltd accepts no liability whatsoever for any loss whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
Poor Performance
SEVERITY: I MESSAGE: ANE4961I Total number of bytes transferred:43.63 GB ORIGINATOR: CLIENT NODENAME: ALSFS OWNERNAME: SCHEDNAME: TEST DOMAINNAME: WINDOWS SESSID: 25866 SERVERNAME: ALSBCK DATE_TIME: 2002-11-03 22:54:31.00 MSGNO: 4963 SEVERITY: I MESSAGE: ANE4963I Data transfer time:276,802.50 sec ORIGINATOR: CLIENT NODENAME: ALSFS OWNERNAME: SCHEDNAME: TEST DOMAINNAME: WINDOWS SESSID: 25866 SERVERNAME: ALSBCK DATE_TIME: 2002-11-03 22:54:31.00 MSGNO: 4966 SEVERITY: I MESSAGE: ANE4966I Network data transfer rate: 165.31 KB/sec ORIGINATOR: CLIENT NODENAME: ALSFS OWNERNAME: SCHEDNAME: TEST DOMAINNAME: WINDOWS SESSID: 25866 SERVERNAME: ALSBCK DATE_TIME: 2002-11-03 22:54:31.00 MSGNO: 4967 SEVERITY: I MESSAGE: ANE4967I Aggregate data transfer rate:115.76 KB/sec ORIGINATOR: CLIENT NODENAME: ALSFS OWNERNAME: SCHEDNAME: TEST DOMAINNAME: WINDOWS SESSID: 25866 SERVERNAME: ALSBCK DATE_TIME: 2002-11-03 22:54:31.00 MSGNO: 4968 SEVERITY: I MESSAGE: ANE4968I Objects compressed by: 37%% ORIGINATOR: CLIENT NODENAME: ALSFS OWNERNAME: SCHEDNAME: TEST DOMAINNAME: WINDOWS SESSID: 25866 SERVERNAME: ALSBCK DATE_TIME: 2002-11-03 22:54:31.00 MSGNO: 4964 SEVERITY: I MESSAGE: ANE4964I Elapsed processing time:109:48:05 ORIGINATOR: CLIENT NODENAME: ALSFS OWNERNAME: SCHEDNAME: TEST DOMAINNAME: WINDOWS SESSID: 25866 SERVERNAME: ALSBCK Lawrie Scott For: Persetel / Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] <mailto:lawries@;comparexafrica.co.za>
SAP TDP on TSM 5.1 Open Sessions
Hi TSM 5.1.1 running on a Compaq Proliant 2gig Mem 2 750Mhz Processor with 2 TL891 Libraries with 2 Drives each. The SAP/R3 on Oracle runs on Compaq Alpha Server running Tru64 Unix with 4 Processors in a 4 machine cluster. I run a SAP Log backup at 13:00 and a Full backup of the three (SPP, SPQ, PSD) databases at 21:00. Generally these run fine and I receive and e-mail upon completion showing the completion status. However now again the job fails for whatever error, and then leaves open sessions on the Tru64 Unix servers, which I then have to manually go and cancel to get the job to complete. These session are not displayed as sessions on the TSM server but only in the background on the Tru64 Server. Once I have manually cancelled these sessions the script running the backup completes and I get an e-mail notification showing a failed status. Is there something I can set to get these session to cancel automatically if a certain time period has passed. The only way I can currently identify these session is with the ps -ef |grep command then kill the session. Sometimes this error goes unnoticed and sits in this state for a few days. It has no impact on future scheduled backups. Thanx for the help in advance Lawrie Scott For: Persetel / Q Vector KZN South Africa Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] <mailto:lawries@;comparexafrica.co.za>
SAP TDP Multiple Storage Pools
Hi Running Server 5.1 and the latest TDP for SAP/R3 using Oracle on a Compaq Tru64 Unix Platform. I have been asked to do a weekly backup to a separate storage pool, a monthly to its own storage pool. Currently I run a daily backup with 14 versions and this is a full backup each day to a storage pool called SAP. How would I set it up to look at different storage pool depending on the backup type specified. Setting up the scripts to run the backup is not the issue but rather how would the dsm files and SAP config files be set to handle multiple storage pools, and schedules. Lawrie Scott For: Persetel / Q Vector KZN Company Registration Number: 1993/003683/07 Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: <mailto:lawries@;comparexafrica.co.za> [EMAIL PROTECTED] Notice: This message and any attachments are confidential and intended solely for the addressee. If any have received this message in error, please notify Lawrie Scott at Comparex Africa (Pty) Ltd immediately, telephone number +27 (0) 31 5609222. Any unauthorised use, alteration or dissemination is prohibited. Comparex Africa (Pty) Ltd accepts no liability whatsoever for any loss whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
Re: Testing the day of week in a script ....
Hi Where can one find this manual. Lawrie - Original Message - From: "Steve Harris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 1:56 AM Subject: Re: Testing the day of week in a script Arnaud, TSM comes with a rich set of SQL functions. Get a hold of Andy Raibeck's "Using the SQL Interface" manual, it is very useful (search the archives to find where it is) Date functions include Day - Day of month dayname dayofweek - 1..7 Sunday..Saturday dayofyear daysinmonth daysinyear Monthname I've just been reviewing the manual and there are some neat ones that I'm going to try coalesce(value,value,value...) returns the first non-null in the list of values nullif(expression1,expression2) returns null if the expressions are equal or expression1 otherwise Andy, your manual is great, but its a bit out of date. Any chance of an up to date version or even better making it a part of the shipped manual set? Steve Harris AIX and TSM Admin Queensland Health, Brisbane Australia >>> [EMAIL PROTECTED] 21/10/2002 19:39:12 >>> Hi *SM'ers, I'm looking for an SQL command to check the current day of week, before starting the conditional excution of a subsequent script. I already found something that seems to work, looking like : Script blah ... select date_time, message from actlog where cast((current_timestamp-date_time) minutes as decimal(8,0)) < 1 and dayname(date_time) = 'Tuesday' if(rc_ok) goto tuesday If (rc_notfound) goto restofweek tuesday : run script1 exit restofweek : run script2 exit Unfortunately this kind of select statement take ages to complete, because it has to go through all the activity log to find the last lines written, as we keep one month of it ! Does anybody have a faster way doing this kind of query/test ? (without calling an AIX script) Thanks in advance Cheers. Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. **
Re: Monitoring oracle Backups
HI Joe I do an Oracle backup and SAP backups the Unix staff have done a whole lot of fancy scripting for me and extract data to a log file which is then e-mailed to all the relevant people each day. Possibly you could get some scripting done for this. I have incled a sample output below from our daily SAP backups. If you require the script used maybe I can arrange a copy. *=== *Date: Mon Oct 21 20:00:18 SAST 2002 *=== ** * Starting backup of SPP * ** BKI1215I: Average transmission rate was 40.181 GB/h (11.429 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 21:35:49 2002 . BKI0021I: Elapsed time: 35 min 24 sec . BKI0024I: Return code is: 0. BKI1215I: Average transmission rate was 0.019 GB/h (0.005 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 21:36:22 2002 . BKI0021I: Elapsed time: 29 sec . BKI0024I: Return code is: 0. ** * Backup of SPP complete * ** ** *Starting backup of redo logs* ** BKI1215I: Average transmission rate was 12.054 GB/h (3.429 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 21:37:04 2002 . BKI0021I: Elapsed time: 40 sec . BKI0024I: Return code is: 0. BKI1215I: Average transmission rate was 11.124 GB/h (3.164 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 21:37:35 2002 . BKI0021I: Elapsed time: 30 sec . BKI0024I: Return code is: 0. BKI1215I: Average transmission rate was 0.082 GB/h (0.023 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 21:38:13 2002 . BKI0021I: Elapsed time: 38 sec . BKI0024I: Return code is: 0. *=== *Date: Mon Oct 21 20:38:15 SAST 2002 *=== *=== *Commence SPD backup at 20:38:15 *=== ** * Shutdown Appl & db for SPD * ** ** * Starting backup of SPD * ** BKI1215I: Average transmission rate was 40.049 GB/h (11.392 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 22:19:55 2002 . BKI0021I: Elapsed time: 40 min 43 sec . BKI0024I: Return code is: 0. BKI1215I: Average transmission rate was 0.016 GB/h (0.004 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 22:20:54 2002 . BKI0021I: Elapsed time: 35 sec . BKI0024I: Return code is: 0. ** * Backup of SPD complete * ** ** *Start up SAP for SPD* ** *=== *Commence SPQ backup at 21:22:20 *=== ** * Shutdown Appl & db for SPQ * ** ** * Starting backup of SPQ * ** BKI1215I: Average transmission rate was 49.056 GB/h (13.954 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 23:00:59 2002 . BKI0021I: Elapsed time: 37 min 39 sec . BKI0024I: Return code is: 0. BKI1215I: Average transmission rate was 0.020 GB/h (0.006 MB/sec). BKI0020I: End of backint program at: Mon Oct 21 23:01:43 2002 . BKI0021I: Elapsed time: 29 sec . BKI0024I: Return code is: 0. ** * Backup of SPQ complete * ** ** *Start up SAP for SPQ* ** - Original Message - From: "Wholey, Joseph (TGA\MLOL)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 3:26 PM Subject: Monitoring oracle Backups Recently installed TDP for Oracle. DBA's would like to be paged "real time" if a database backup fails. Aside from the paging part, does anyone know where I can pull the status of an Oracle database backup as soon as it completes. I don't want to extract from the client logs (when would I start looking?) And the Activity log does not supply all that much useful information. Any help would be greatly appreciated. thx. -joe-
Re: More on Repeat Backups...
Hi Jerry I'm new to this list but your problem sounds like a problem I have where the system objects fail. On further investigation I discovered it was only the event logs, which are no use if the system crashses and needs a full restore anyway. So with the authority of my desktop guys I excluded the event logs directory from the backup and from then on my system Objects passed. I found this only to be a problem on servers where the event log was very busy. Lawrie Scott For: Persetel / Q Vector KZN South Africa Tel: +27 (0) 31 5609222 Fax: +27 (0) 31 5609495 Cell: +27 (0) 835568488 E-mail: [EMAIL PROTECTED] - Original Message - From: "Lawson, Jerry W (ETSD, IT)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 1:47 PM Subject: More on Repeat Backups... Date: October 16, 2002Time: 7:31 AM From: Jerry Lawson The Hartford Insurance Group 860 547-2960[EMAIL PROTECTED] - First - let me thank you all for the responses to my original question. Your answers have gotten me thinking some - I say some, because at my age, it's hard to get everything going again, and I suffer from "senior moments" too often. Most of the answers revolved around the suggestion that I could exclude something - either the files themselves, or the System Object itself if I get the newest client. This seems to me to be treating the symptom, rather than the problem - if I exclude them, obviously, I can never restore them (DUH!). If these do get corrupted or deleted, it would appear that I could be in for another bout with my desktop support folks - they just had my Laptop for 3 weeks - I'm not eager to deal with them again. Now I will be the first to admit that I'm not MS Certified on any OS, and so the idea of excluding the whole System Object is scary as well - doesn't that include a big portion of registry information if I need to do a complete restore? Or is the idea of a Bare Metal restore with TSM one that has died? In my (sometimes overly simplistic) mind, I remember the ADSM class I attended where the instructor identified how a file was determined to have changed - either the date, the time, or the size has changed. Has TSM changed this philosophy? After all, I look at the files in question, and nothing has changed that I can see externally. Shouldn't there be a better approach than to say "well, they're a part of the system object, and therefore you need to exclude them." Shouldn't the software be smart enough to figure this out? - Jerry (still tilting at windmills) This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies.
