SQL query to list collocationgroup information
Hello I need to know how much data and how many volumes my collocation groups uses Does anyone have a tip on how a SQL query that provide that info? The output should be something like this: Group nameMBNo of volsNo of nodes Med vänlig hälsning Niklas Lundström Niklas Lundström Storage Administrator Swedbank AB (publ) 105 34 Stockholm Telefon: +46 (0)8 5859 5164 Mobil: +46 (0)70 24 76 345 Vi ber dig lägga märke till att detta e-postmeddelande kan innehålla konfidentiell information. Om du felaktigt blivit mottagare av detta meddelande ber vi dig informera avsändaren om felet genom att använda svara-funktionen. Vi ber dig också att radera e-postmeddelandet utan att skicka det vidare eller kopiera det. Trots att vi intygar att e-postmeddelandet och eventuella bilagor inte innehåller virus och andra fel som kan påverka datorn eller IT-systemet där det mottages och läses, öppnas det på mottagarens eget ansvar. Vi tar inte på oss något ansvar för förlust eller skada, som har uppstått i samband med att e-postmeddelandet mottagits och använts. _ Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply, then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachment are free from viruses and other errors that might affect the computer or IT system where it is received and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.
Corrupt MS-SQL backup? Can't restore
Hello My DBA tried to restore a SQL server backup yesterday but it didn't work so well. After about 7 hours this error appeared in dsierror.log: 03/21/2007 00:07:16 The 2068236851th code was found to be out of sequence. The code (506) was greater than (258), the next available slot in the string table. The dsierror.log is 14Mb and is filled with the errormessage I can't see any error in the activitylog. Is the backup corrupted somehow? We're running a new restore of an older backup now, hope that works Med vänlig hälsning Niklas Lundström Niklas Lundström Storage Administrator Swedbank AB (publ) 105 34 Stockholm Telefon: +46 (0)8 5859 5164 Mobil: +46 (0)70 24 76 345 Vi ber dig lägga märke till att detta e-postmeddelande kan innehålla konfidentiell information. Om du felaktigt blivit mottagare av detta meddelande ber vi dig informera avsändaren om felet genom att använda svara-funktionen. Vi ber dig också att radera e-postmeddelandet utan att skicka det vidare eller kopiera det. Trots att vi intygar att e-postmeddelandet och eventuella bilagor inte innehåller virus och andra fel som kan påverka datorn eller IT-systemet där det mottages och läses, öppnas det på mottagarens eget ansvar. Vi tar inte på oss något ansvar för förlust eller skada, som har uppstått i samband med att e-postmeddelandet mottagits och använts. _ Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply, then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachment are free from viruses and other errors that might affect the computer or IT system where it is received and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.
Invisible node???
Hello I've got a strange problem. I run q node and TSM says the node doesn't exist, but if I try to register the node again, TSM says it exist... Output from the command tsm: PROD-ADSM3q node askperf ANR2034E QUERY NODE: No match found using this criteria. ANS8001I Return code 11. tsm: PROD-ADSM3q file askperf ANR2034E QUERY FILESPACE: No match found using this criteria. ANS8001I Return code 11. tsm: PROD-ADSM3q occu askperf ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. tsm: PROD-ADSM3reg node askperf password ANR2147E REGISTER NODE: Node ASKPERF is already registered. WFT ANS8001I Return code 10. Med vänlig hälsning Niklas Lundström Niklas Lundström Storage Administrator Swedbank AB (publ) 105 34 Stockholm Telefon: +46 (0)8 5859 5164 Mobil: +46 (0)70 24 76 345 Vi ber dig lägga märke till att detta e-postmeddelande kan innehålla konfidentiell information. Om du felaktigt blivit mottagare av detta meddelande ber vi dig informera avsändaren om felet genom att använda svara-funktionen. Vi ber dig också att radera e-postmeddelandet utan att skicka det vidare eller kopiera det. Trots att vi intygar att e-postmeddelandet och eventuella bilagor inte innehåller virus och andra fel som kan påverka datorn eller IT-systemet där det mottages och läses, öppnas det på mottagarens eget ansvar. Vi tar inte på oss något ansvar för förlust eller skada, som har uppstått i samband med att e-postmeddelandet mottagits och använts. _ Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply, then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachment are free from viruses and other errors that might affect the computer or IT system where it is received and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.
SV: Invisible node???
Hello Ok, that worked! But this is a client node, not a TSM server. /Niklas -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] För Bos, Karel Skickat: den 4 december 2006 11:06 Till: ADSM-L@VM.MARIST.EDU Ämne: Re: Invisible node??? Q node t=server? Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Lundstrom Sent: maandag 4 december 2006 10:44 To: ADSM-L@VM.MARIST.EDU Subject: Invisible node??? Hello I've got a strange problem. I run q node and TSM says the node doesn't exist, but if I try to register the node again, TSM says it exist... Output from the command tsm: PROD-ADSM3q node askperf ANR2034E QUERY NODE: No match found using this criteria. ANS8001I Return code 11. tsm: PROD-ADSM3q file askperf ANR2034E QUERY FILESPACE: No match found using this criteria. ANS8001I Return code 11. tsm: PROD-ADSM3q occu askperf ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. tsm: PROD-ADSM3reg node askperf password ANR2147E REGISTER NODE: Node ASKPERF is already registered. WFT ANS8001I Return code 10. Med vänlig hälsning Niklas Lundström Niklas Lundström Storage Administrator Swedbank AB (publ) 105 34 Stockholm Telefon: +46 (0)8 5859 5164 Mobil: +46 (0)70 24 76 345 Vi ber dig lägga märke till att detta e-postmeddelande kan innehålla konfidentiell information. Om du felaktigt blivit mottagare av detta meddelande ber vi dig informera avsändaren om felet genom att använda svara-funktionen. Vi ber dig också att radera e-postmeddelandet utan att skicka det vidare eller kopiera det. Trots att vi intygar att e-postmeddelandet och eventuella bilagor inte innehåller virus och andra fel som kan påverka datorn eller IT-systemet där det mottages och läses, öppnas det på mottagarens eget ansvar. Vi tar inte på oss något ansvar för förlust eller skada, som har uppstått i samband med att e-postmeddelandet mottagits och använts. _ Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply, then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachment are free from viruses and other errors that might affect the computer or IT system where it is received and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.
Unable to delete all filespaces for a node
Hello I have exported a node from one TSM server to another but I never used the exported node and decided to remove it But trying to remove node SPNT350 TSM tells me: Inventory reference still exist. I the do a q occu spnt350: tsm: PROD-ADSM3q occu spnt350 ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. ok, nothing there, then a q file tsm: PROD-ADSM3q file spnt350 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Typepace(MB) Util Unicode? --- --- - - - SPNT350 SYSTEM 3 (?) SYSTEM Yes 0.0 0.0 OBJECT ok, I then run: tsm: PROD-ADSM3del file spnt350 3 namet=fsid type=any wait=yes ANR2238W This command will result in the deletion of all inventory references to the data on filespaces that match the pattern SYSTEM OBJECT (fsId=3) for node SPNT350 , whereby rendering the data unrecoverable. Do you wish to proceed? (Yes (Y)/No (N)) y ANR0984I Process 113 for DELETE FILESPACE started in the FOREGROUND at 11:49:01. ANR0800I DELETE FILESPACE SYSTEM OBJECT (fsId=3) for node SPNT350 started as process 113. ANR0802I DELETE FILESPACE SYSTEM OBJECT (fsId=3) (backup/archive data) for node SPNT350 started. ANR0806I DELETE FILESPACE SYSTEM OBJECT (fsId=3) complete for node SPNT350: 0 objects deleted. ANR0985I Process 113 for DELETE FILESPACE running in the FOREGROUND completed with completion state SUCCESS at 11:49:01. But a q file spnt350 still show the system object filespace!!! tsm: PROD-ADSM3q file spnt350 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Typepace(MB) Util Unicode? --- --- - - - SPNT350 SYSTEM 3 (?) SYSTEM Yes 0.0 0.0 OBJECT any suggestions??? MVH Niklas Lundström
SV: Unable to delete all filespaces for a node
Yes, I tried it, but with no success. It's only the System Object filespace that's impossible to delete. I renamed it to something else but it's still the same problem. /Niklas -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] För Bill Dourado Skickat: den 17 november 2004 12:04 Till: [EMAIL PROTECTED] Ämne: Re: Unable to delete all filespaces for a node Have you tried the via Storage Manager Server Web GUI ? Bill Niklas Lundstrom [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 17/11/2004 10:52 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Unable to delete all filespaces for a node Hello I have exported a node from one TSM server to another but I never used the exported node and decided to remove it But trying to remove node SPNT350 TSM tells me: Inventory reference still exist. I the do a q occu spnt350: tsm: PROD-ADSM3q occu spnt350 ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. ok, nothing there, then a q file tsm: PROD-ADSM3q file spnt350 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Typepace(MB) Util Unicode? --- --- - - - SPNT350 SYSTEM 3 (?) SYSTEM Yes 0.0 0.0 OBJECT ok, I then run: tsm: PROD-ADSM3del file spnt350 3 namet=fsid type=any wait=yes ANR2238W This command will result in the deletion of all inventory references to the data on filespaces that match the pattern SYSTEM OBJECT (fsId=3) for node SPNT350 , whereby rendering the data unrecoverable. Do you wish to proceed? (Yes (Y)/No (N)) y ANR0984I Process 113 for DELETE FILESPACE started in the FOREGROUND at 11:49:01. ANR0800I DELETE FILESPACE SYSTEM OBJECT (fsId=3) for node SPNT350 started as process 113. ANR0802I DELETE FILESPACE SYSTEM OBJECT (fsId=3) (backup/archive data) for node SPNT350 started. ANR0806I DELETE FILESPACE SYSTEM OBJECT (fsId=3) complete for node SPNT350: 0 objects deleted. ANR0985I Process 113 for DELETE FILESPACE running in the FOREGROUND completed with completion state SUCCESS at 11:49:01. But a q file spnt350 still show the system object filespace!!! tsm: PROD-ADSM3q file spnt350 Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Typepace(MB) Util Unicode? --- --- - - - SPNT350 SYSTEM 3 (?) SYSTEM Yes 0.0 0.0 OBJECT any suggestions??? MVH Niklas Lundström
SV: TDP for Exchange and B/A client exclude list
Hello We have excludeed the directory MDBDATA on our Exchange servers: Exclude.Dir *:\...\MDBDATA Regards Niklas -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] För Sandra Skickat: den 17 november 2004 07:19 Till: [EMAIL PROTECTED] Ämne: TDP for Exchange and B/A client exclude list Dear All, Can someone enlighten me on which folders should I exclude from being backedup using BA client 5.2.2 while I am taking backups of Exchange server 2000 using TDP for Exchange 5.2.2. My TSM Server is on windows 2000 and version is 5.2.2.5 and am going to upgrade to 5.2.3. Should I exclude entire directory of storage group files and transaction log files entire directory? My aim is to backup the rest of the system using TSM BA client and use TDP exchange to backup exchange and while restoring.. I will restore entire system from BA client which will include Exchange configuration and TDP exchange willl restore storage group and public folders if backed up. Thanking you in advance ,... !! Sandra!
SV: Unable to delete all filespaces for a node
Hello Well I did, but didn't find that one. Sounds like I'm going to have to wait for ver 5.1.10... Thanks anyway! Regards Niklas -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] För Richard Sims Skickat: den 17 november 2004 14:01 Till: [EMAIL PROTECTED] Ämne: Re: Unable to delete all filespaces for a node When you encounter a problem like this, which is obviously a server defect, you can search the IBM web site for an APAR. That turns up IC39957 and relatives. Richard Sims
Message if server is waiting for mount over 15 minutes?
Hello Is there a way to get a warning or a message if a session or process has waited over 15 minutes for a mount? MVH Niklas Lundström Föreningssparbanken IT 08-5859 5164
SV: INCLUDE/EXCLUDE vs NO CLUE
Hello Skip the last \ at the exclude.dir statements. Like EXCLUDE.DIR *:\Exchsrvr Not EXCLUDE.DIR *:\Exchsrvr\ I always put the domain statement under the include/excludes, but I dont't know if it does any difference.. Remember that TSM reads the optfile from the botton to the top, so if you have include-statement further down in the file they will be included even if you exclude them higher up in the optfile Regards Niklas -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] För Mark Strasheim Skickat: den 29 september 2004 10:32 Till: [EMAIL PROTECTED] Ämne: INCLUDE/EXCLUDE vs NO CLUE Hello together, i read the redbook and manpages several times, but i can't get i right. I want to exclude some directories und or some files, since this is a basic task it should be fairly simple, but i messed it up. Here is the list that i thought should work ... . -- DOMAIN ALL-LOCAL EXCLUDE *:D\Exchsrvr\mdbdata\*.log EXCLUDE *:\Exchsrvr\mdbdata\tmp.edb EXCLUDE *:\Exchsrvr\Speichergruppe GFS\MDBDATA\priv2.stm EXCLUDE *:\Exchsrvr\Speichergruppe GFS\MDBDATA\pub2.edb EXCLUDE *:\Exchsrvr\Speichergruppe GFS\MDBDATA\pub2.stm EXCLUDE *:\...\dsmsched.log EXCLUDE *:\...\Perflib_Perfdata_630.dat EXCLUDE.DIR *:\WINNT\system32\LServer\ EXCLUDE.DIR *:\Exchsrvr\ EXCLUDE.DIR *:\...\Temporary Internet Files Exclude.Dir D:\Exchsrvr\mdbdata Exclude.Dir D:\Exchsrvr\Speichergruppe GFS Exclude.Dir D:\Exchsrvr\Speichergruppe GFS\MDBDATA EXCLUDE *:\...\pagefile.sys EXCLUDE *:\WINNT\system32\CPL.CFG EXCLUDE.DIR *:\WINNT\Profiles EXCLUDE *:\MSDOS.SYS EXCLUDE *:\IO.SYS EXCLUDE *:\WINNT\system32\LServer\tmp.edb EXCLUDE *:\WINNT\system32\LServer\TLSLic.edb EXCLUDE *:\WINNT\system32\LServer\edb.log -- This ths is a task every WIN TSM Admin needs to do, what did i miss? Why does the Storage Manager still want do backup all und is complaining about the errors. -- definitiv! business applications GmbH Co. KG Fresnostrasse 14 - 18 · DE-48159 Münster Tel. +49 (0) 251 21092 - 23 · Fax +49 (0) 251 21092 - 29 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] · http://www.definitiv-ba.de/ http://www.definitiv-ba.de --
Wider columns in q event command??
Hello When I issue q event * * exceptipnsonly=yes I get tsm: SPADAB-PRODq event * * exceptionsonly=yes Scheduled Start Actual Start Schedule Name Node Name Status - - -- 09/08/2004 03:00:00 INCRBACK3 SFFPROD2DBMissed 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD- Missed 001 09/08/2004 05:00:00 09/08/2004 05:00:21 INCRBACK1 STMFSPAS01EX- Failed 002 09/08/2004 05:00:00 09/08/2004 05:33:21 INCRBACK1 STMFSPAS01EX- Failed 005 09/08/2004 05:00:00 09/08/2004 05:00:33 PRIME_POSTSC- PRIMEDB1 Failed HEDULE_CMD 09/08/2004 05:00:00 PRIME_POSTSC- PRIMEDB2 Missed HEDULE_CMD 09/08/2004 07:00:00 09/08/2004 08:33:35 REST_OBTAIN SP7WS210 Failed However some of my schedule and nodenames are too long to fit within the Schedule Name and Node Name row, so I get a line with just a few charachters in the output I want it to look something like: Scheduled Start Actual Start Schedule Name Node NameStatus - - -- 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD001 Missed 09/08/2004 05:00:0009/08/2004 05:00:21INCRBACK1 STMFSPAS01EX002 Failed 09/08/2004 05:00:0009/08/2004 05:33:21INCRBACK1 STMFSPAS01EX005 Failed 09/08/2004 05:00:0009/08/2004 05:00:33PRIME_POSTSCHEDULE_CMD PRIMEDB1 Failed I looked at select * from events but I only see the most recent events there Is there a way to increase the number of charachters in the rows? Regards Niklas Lundström Swedbank
TDP for mail 5.1.2 and Exchange2003 SP1
Hello Does anyone know if Exchange2003 with SP1 is supported? We are running Exchange2003 and TDP for mail ver 5.1.2 now and the exchange-admin wants to upgrade Exchange2003 to SP1. Regards Niklas Lundström Swedbank
TDP SQL sessions wants to write to same tape...
Hello I've been running a backup of a SQL server db but I took too long so I increased the stripe-parameter to 2 so it would utilize 2 sessions and 2 tape drives for the backup. However when the backup starts both sessions wants to write to the same volume, leaving one of the session in a media-wait state for the whole backup and the backup fails after 12h. 12,064 BPX-T- RecvW0 S 20.5 K 62.6 G Node TDP MSS- ROBUR22_SQL cp/Ip QL 12,066 BPX-T- MediaW 13.0 H 5.2 K 2.5 M Node TDP MSS- ROBUR22_SQL cp/Ip QL What can I do to fix this??? Regards Niklas Lundström Swedbank
SV: TDP SQL sessions wants to write to same tape...
Hello No problems with moutpoints ,and the pool is collocated. Perhaps I should change it to collocate by filespace instead. Thats sounds like a solution actually /Niklas -Ursprungligt meddelande- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] För goran Skickat: den 13 februari 2004 10:27 Till: [EMAIL PROTECTED] Ämne: Re: TDP SQL sessions wants to write to same tape... if its same node with collocation turned on it might be max mount points value that should be increased (im not sure if this is aplicable for SQL TDP) goran. - Original Message - From: Niklas Lundstrom [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 13, 2004 10:04 AM Subject: TDP SQL sessions wants to write to same tape... Hello I've been running a backup of a SQL server db but I took too long so I increased the stripe-parameter to 2 so it would utilize 2 sessions and 2 tape drives for the backup. However when the backup starts both sessions wants to write to the same volume, leaving one of the session in a media-wait state for the whole backup and the backup fails after 12h. 12,064 BPX-T- RecvW0 S 20.5 K 62.6 G Node TDP MSS- ROBUR22_SQL cp/Ip QL 12,066 BPX-T- MediaW 13.0 H 5.2 K 2.5 M Node TDP MSS- ROBUR22_SQL cp/Ip QL What can I do to fix this??? Regards Niklas Lundstrvm Swedbank
Unable to remove node!
Hello I am trying to remove a node. tsm: SPADAB-PRODrem node tremfk Do you wish to proceed? (Yes (Y)/No (N)) y ANR2152E REMOVE NODE: Inventory references still exist for node TREMFK. ANS8001I Return code 13. tsm: SPADAB-PRODq occu tremfk ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. So the q occu tells me that the node has no files, but the rem node says it has??! Any ideas?? Mvh Niklas Lundström Föreningssparbanken IT 08-5859 5164
SV: Unable to remove node!
Hi When i ran q file tremfk it showed a filespace, so I deleted it. Thanks /Niklas -Ursprungligt meddelande- Från: Horst Scherzer [mailto:[EMAIL PROTECTED] Skickat: den 19 december 2003 09:21 Till: [EMAIL PROTECTED] Ämne: Re: Unable to remove node! Niklas Lundstrom wrote: Hello I am trying to remove a node. tsm: SPADAB-PRODrem node tremfk Do you wish to proceed? (Yes (Y)/No (N)) y ANR2152E REMOVE NODE: Inventory references still exist for node TREMFK. ANS8001I Return code 13. tsm: SPADAB-PRODq occu tremfk ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. So the q occu tells me that the node has no files, but the rem node says it has??! Any ideas?? Mvh Niklas Lundström Föreningssparbanken IT 08-5859 5164 q fi tremfk is also empty? Gtx, -- Horst SCHERZER e-Mail: [EMAIL PROTECTED] Vienna University Computer Center Phone: (+43 1) 4 277 x14053 Cellular: (+43) 0664/60 277 14053 Universitaetsstr.7 Fax:(+43 1) 4 277 x9140 A-1010 Wien/Vienna VoIP: (+43) 59966 4 14053 Oesterreich/Austria URL: http://mailbox.univie.ac.at/~sc
SV: How to Backup Sco Unix ?
Hello There is an old client, ver 3.1.0.8 for Open Server that works. Regards Niklas -Ursprungligt meddelande- Från: Mario [mailto:[EMAIL PROTECTED] Skickat: den 16 december 2003 09:32 Till: [EMAIL PROTECTED] Ämne: How to Backup Sco Unix ? does anyone know how to backup data using tsm on sco unix openserver 5.05 ? how do you make the connection to the server? is it possible to mount the drive on sco to linux os ? any suggestion ? Mario Sunarto Engineer - Tivoli Division PT. Niaga Prima Paramitra IBM Business Partner Jakarta - Indonesia Telp: 7692918/20
Full diskpool clients to tape, but when the diskpool is migrate d the clients still goes to tape
hello I guess the subjectline says it all. When my diskpool gets full the new sessions goes directly to the tapepool, but when the diskpool is migrated and gets free space the sessions still wait for mountpoint in my tapepool. Is it normal behaviour?? Mvh Niklas Lundström Föreningssparbanken IT 08-5859 5164
SV: Teradata
Hi There is a client for Teradata, but it's only at 3.1.08 -Ursprungligt meddelande- Från: David Fainburg [mailto:[EMAIL PROTECTED] Skickat: Friday, November 28, 2003 8:57 AM Till: [EMAIL PROTECTED] Ämne: Teradata Hi all, Does anybody have experience with TSM on a NCR5300/Teradata? Kindly David
Individual file restore from image?
Is it avalible yet? If not, does anyone know when? Regards Niklas Lundström Swedbank
Re: New reporting tool in 5.2
It is still in beta... Download it from ftp://service.boulder.ibm.com/storage/tivoli-storage-management/techprev/tsm opreport/latest/ -Original Message- From: Lawrence Clark [mailto:[EMAIL PROTECTED] Sent: den 14 augusti 2003 15:39 To: [EMAIL PROTECTED] Subject: New reporting tool in 5.2 I'm looking through the 5.2 disks and I see no mention of the reporting tool people have discussed recently
Servercode down level on 5.2.0.1 client
Hello I have a tsm client, 5.2.0.1 running on Windows2003. My TSM Server is 5.1.6.0 and runs on MVS. When I start the gui and do a backup i get The server code is down-level Isn't the 5.2 client compatible with the 5.1.6.0 server?? Mvh Niklas Lundström Föreningssparbanken IT 08-58595164
Re: Exclude all?
Exclude c:\...\*.* Include c:\backup\...\*.* -Original Message- From: Henrik Wahlstedt [mailto:[EMAIL PROTECTED] Sent: den 23 juli 2003 12:01 To: [EMAIL PROTECTED] Subject: Exclude all? Hello, What is the correct exclude/include statement if I want to exclude everything files, folders and system objects on a w2k box with 5.1.6.0 client, except for C:\Backup\*. //Henrik --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: ACN5304E when I use the CLI to backup Exchange RESOLVED
Hello I was logged in as a local admin, when I logged in as a domain admin it worked fine Regards Niklas Lundström -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: den 2 juni 2003 15:42 To: [EMAIL PROTECTED] Subject: Re: ACN5304E when I use the CLI to backup Exchange Niklas, It is looking at the Information Store service. Sometimes this occurs when you are running under a Windows userid that does not have Administrator authority to view the registry. For example, this may occur when you are running from a scheduler service that is being run under a different userid. If you are still having problems, please call IBM support and a trace can be examined to find out what the problem is. Thanks, Del When I use the GUI I can backup my Exchange storage groups without problem, but when I run the CLI, tdpexcc.exe, I get ACN5304E, Unable to open service to determine if running or not Have anyone seen this??? Which service does it want to open???
Exchange 2003 + TSM for Exchange 5.1.5
Hello Has anyone tried TSM for Exchange together with Exchange 2003? Does it work? Mvh Niklas Lundström Swedbank
Re: 3000 clients bkp to TSM?
Hello Just put it on a mainframe and you're fine. That is what the mainframe is best at. We have 4 TSM servers running in one CPU and is backing 1500 clients and about 1b per night. Regards Niklas -Original Message- From: Pothula S Paparao [mailto:[EMAIL PROTECTED] Sent: den 27 maj 2003 08:27 To: [EMAIL PROTECTED] Subject: 3000 clients bkp to TSM? Hello TSM'ers, I have 3000 clients (each 5GB approx) backup proposal to TSM server. Expecting 600 to 1000 clients fire their backup to TSM concurrently. Can TSM able to handle all these session fired at a time ? If not , how to handle all my client to initiate their backup to TSM in 6Hours backup window time. Note : Network team already worked on the above solution and given green signal saying they dont have any problem. Guys, Its now time for me to decide how this solution to be worked out pls help to give best possible solution to my customer. Appreciate your help in this regard Thanks in advance Cheers, Sreekumar P.Pothula.
Re: Informix backup
Hello Sure, no problem. We use a preschedulecommand to run ontape to backup to a file and the backup tat file using TSM. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 14:39 To: [EMAIL PROTECTED] Subject: Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Re: Informix backup
Hello I'm not an Informix dba either...But it's pretty straigt forward This is the backupcommand that we run as a preschedulercommand: onmode -uy shutdown of database ontape -s -L 0 E:\server\scripts\enter.txt When you run ontape you have to press enter, the enter.txt files contain one enter onmode -mstarts the database There are more cmdfiles involved since we are renaming the backupfiles and moves them to another directory because the backup always goes to the same file, backup.bup, and to save the backup you have to copy and rename that file. The onconfig looks like this: # System Archive Tape Device #TAPEDEV\\.\TAPE0 # Tape device path TAPEDEV L:\Backserv\Backup.bup # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE200 # Maximum amount of data to put on tape (Kbytes) We used to run onbar but the dba wanted to restore single tables and to do that you had to shutdown the database and run ontape , don't ask me why it couldn't be done with onbar.. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 15:33 To: [EMAIL PROTECTED] Subject: Re: Informix backup Hi Niklas, Can you be more specific ? What is this preschedule command you use ? Sorry, I am no Informix DBA. Thanks. Best regards, Mario Niklas Lundstrom [EMAIL PROTECTED] wrote:Hello Sure, no problem. We use a preschedulecommand to run ontape to backup to a file and the backup tat file using TSM. Regards Niklas -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED] Sent: den 20 mars 2003 14:39 To: [EMAIL PROTECTED] Subject: Informix backup Hi list, Can I use the native backup from Informix, OnBar, to perform its own backup and then use the TSM Backup/Archive Client to copy this data to a tape storage pool ? Has anybody done that ? The reason I ask is because we do not have the TDP for Informix to perform online backup with TSM. Thanks. Mario - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! - Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Re: TSM ANS4023E Error processing resulting in I/O error
Hello I suspect you are using Windows2000?? I've had the same problem. Solution: Remove backupreg from dsm.opt Deleted adsm.sys Since the registry is included in the system objects backup adsm.sys is not needed Dont forget to have domain all-local or domain systemobjects in your optfile. Regards Niklas -Original Message- From: Adrian Hicks [mailto:[EMAIL PROTECTED] Sent: den 13 mars 2003 23:04 To: [EMAIL PROTECTED] Subject: FW: TSM ANS4023E Error processing resulting in I/O error Hi, Anyone ever experienced a backup reporting to fail because of a reported I/O error when accessing the C$ drive. Funny thing is, it backs up all files with in that share with no probs. ENV. AIX 4.3.3 TSM 4.2.3.3 EG. sample log DSMSCHED.log 13-03-2003 05:04:56 Successful incremental backup of \\SERVER504\d$' 13-03-2003 05:04:56 Preparing System Object - *** Unknown Object Type ***ANS1228E Sending of object \\SERVER504\c$' failed 13-03-2003 05:04:56 ANS4023E Error processing \\SERVER504\c$': file input/output error 13-03-2003 05:05:09 Normal File--99,676 \\SERVERc$\ADSM.SYS\COMPDB\COMPDBFILE [Sent] 13-03-2003 05:05:09 Successful incremental backup of 'COM+ Database' DSMERROR.log 13-03-2003 05:04:56 ANS1228E Sending of object '\\aupoza504\c$' failed 13-03-2003 05:04:56 ANS4023E Error processing '\\aupoza504\c$': file input/output error 13-03-2003 06:04:56 ANS1005E TCP/IP read error on socket = 900, errno = 10035, reason : 'A non-blocking socket operation could not be completed immediately.'. 13-03-2003 06:05:02 ANS1512E Scheduled event 'BACKUP2' failed. Return code = 12. Thanks, Adrian -- This message and any attachment is confidential and may be privileged or otherwise protected from disclosure. If you have received it by mistake please let us know by reply and then delete it from your system; you should not copy the message or disclose its contents to anyone.
Re: SV: Backup MS SQL master.mdf
Hej There is a redbook covering SQL backup/restore, http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246148.pdf Maybe ou will find something there /Niklas -Original Message- From: Christian Svensson [mailto:[EMAIL PROTECTED] Sent: den 10 mars 2003 13:22 To: [EMAIL PROTECTED] Subject: Re: SV: Backup MS SQL master.mdf Hi Bo! I´m already use the TDP for backup the data in the databas. But to recovery the databas from a disaster do I need to restore the master.mdf before I use the TDP. So I just wonder how I can backup the master.mdf. Do I realy need to use a open file manager? And is the master.mdf syncronized to another files? If I don´t backup that file(s). And the server going down some how. I need to reinstall the SQL software and the service pack. That takes to long time and everyone don´t writeing down what they have done with the SQL Software. So we realy need a Bare Metal solution for it. And I think I got a plan. But I just need answer on my questions. Med Vänliga Hälsningar/Best Regards Christian Svensson --- Cristie Nordic AB Box 2 SE-131 06 Nacka Sweden Phone : +46-(0)8-718 43 30 Mobil : +46-(0)70-325 15 77 eMail : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] Bo Nielsen Bo. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: SV: Backup MS SQL master.mdf Manager ADSM- [EMAIL PROTECTED] 2003-03-10 12:28 Please respond to ADSM: Dist Stor Manager Hi Christian, you will need TDP2.2 for SQL (Tivoli Data Protection), to backup the SQL databases. and that incl. both master and model. Med venlig hilsen/Regards Bo Nielsen * 43 86 46 71 COOP Danmark A/S* (Internt postcenter): 6230 IT-Driftscenter * [EMAIL PROTECTED] Pr. 1. januar 2002 blev COOP Danmark A/S dannet. COOP Danmark A/S er den førende udbyder af dagligvarer i Danmark og består af butikskæderne Kvickly, SuperBrugsen, Dagli'Brugsen, LokalBrugsen, Irma og Fakta samt Dansk Kaffekompagni A/S. COOP Danmark A/S er en del af virksomheden COOP Norden, der repræsenterer en samlet omsætning på ca. 100 mia. kr. og har 64.000 ansatte. Det er således Nordens største aktør på dagligvaremarkedet. Foreningerne FDB, KF (Sverige) og COOP NKL (Norge) er 100% ejer af COOP Norden. -Oprindelig meddelelse- Fra: Christian Svensson [mailto:[EMAIL PROTECTED] Sendt: 10. marts 2003 11:31 Til: [EMAIL PROTECTED] Emne: Backup MS SQL master.mdf Hi all TSMers! I got just a prodject on my desk who says that I need to found a good disaster recovery solution for Microsoft SQL 2000. And I know how to get back the system in 5 min. But I still don´t know how to get back the SQL server with out any installation CDs. I have come so far so I backup all the program files but I still have problem to backup master.mdf. So I got two questions. Do anyone know if master.mdf need to be syncronize to another files? And do master.mdf need to backup with a Open File Manager or can TSM take a backup of that file with out any Open File Manager? Med Vänliga Hälsningar/Best Regards Christian Svensson --- Cristie Nordic AB Box 2 SE-131 06 Nacka Sweden Phone : +46-(0)8-718 43 30 Mobil : +46-(0)70-325 15 77 eMail : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED]
Re: Renaming a W2K node
Hello Have you tried to remove the service and then reinstall it? The service stores the nodename to use in the Registry. Regards Niklas -Original Message- From: Todd Lundstedt [mailto:[EMAIL PROTECTED] Sent: den 6 mars 2003 01:00 To: [EMAIL PROTECTED] Subject: Renaming a W2K node AIX 4.3.3 running TSM Server 4.2.1.7. I have a few client nodes that are W2K servers. Oddly, they are named after our NT servers (NT-ServerA, NT-ServerB, etc..). The dsm.opt file contains the NT machine name as the NodeName. I would like to change the NodeName to W2K-ServerA, but not rename the machine name. ... I stopped the scheduler service on the client node. ... I modified the name in dsm.opt, and saved the file ... I renamed the node on the TSM Server (rename node nt-servera w2k-servera, or whatever the command is... I actually used the web admin GUI to do it). ... I entered dsmc query session at the command line of the client node. ... ... it indicated it was node W2K-ServerA, requested the user ID, and password.. I entered (defaulted) the ID, and keyed in the password for that node. The information was returned as expected. ... I entered dsmc query session at the command line of the client node, again. ... ... The information was returned as expected, without ID and password being required (by the way, the opt file does have passwordaccess generate), still indicating it was the new nodename, W2K-ServerA. ... I started the service up... it started and quietly failed (no GUI messages on the screen). I checked the dsmsched.log file, and it appeared that it attempted to connect using NT-ServerA instead of W2K-ServerA. Baffled.. so ... I checked to properties on the service.. I didn't see anything that indicated NT-ServerA. ... I started the Backup/Archive GUI (vers 5.1.x) and checked the preferences there. Everything was as I would have expected it to be based on the values in the dsm.opt file, including the node name being W2K-ServerA After much searching of documentation and scratching of head, I punted and changed everything (dsm.opt, nodename on TSM server, etc.) back to NT-ServerA and the service started up and stayed up. What am I missing to change the node name? Something is still using the old node name when it attempts to contact the TSM server, and of course, that nodename no longer exists on the TSM server. I did do some looking around in that quickFaQ that Richard links to all the time... didn't find anything in there that jumped out at me. Same with the last 3 months of ADSM.org archives, and IBM's horridly slow and completely non-user-friendly support pages. I am lost... Thanks in advance Todd
Re: Recovery log
Hello One gig is too small. I've had the same problem, when slow clients backed up alot of data it took several hours and the log began filling up. Regards Niklas -Original Message- From: Mark Hayden [mailto:[EMAIL PROTECTED]] Sent: den 18 februari 2003 16:06 To: [EMAIL PROTECTED] Subject: Recovery log HI all, We have had some issues with our recovery log filling up during archives. Our Db is growing at an a alarming speed , about 82 % of a 41 Gb db. Our log is only a gig in size..Is this to small This seams to happen during remote archives across the Wan...Could this play a role? Thanks, Mark Hayden Informations Systems Analyst E-Mail: [EMAIL PROTECTED]
Re: System Objects and Cleanup Backupgroups
Another dumb question...what is Orphaned system objects Regards Niklas Lunström Swedbank -Original Message- From: Hart, Charles [mailto:[EMAIL PROTECTED]] Sent: den 13 februari 2003 15:31 To: [EMAIL PROTECTED] Subject: Re: System Objects and Cleanup Backupgroups Dumb question, what version is the CLEANUP BACKUPGROUPS in? I ask because there is no output from h CLEAN BACKUPGROUPS on 4.1 or 5.1.5 Thank You! -Original Message- From: Dameon White [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 8:05 AM To: [EMAIL PROTECTED] Subject: System Objects and Cleanup Backupgroups My TSM server is at 4.2.3.0 and we want to upgrade to 5.1.x of TSM. But we have over 50 million orphaned SYSTEM OBJECTS that we have been trying to delete via the CLEANUP BACKUPGROUPS command. We tried to upgrade with the orphans and after 72 hours we backed out. Now we are tryng to delete the orphans, but the problem is that we are only cleaning up 10k-25k per night. At this rate we will not be able to upgrade to 5.1.x for at least 10-15 years. Does anyone have any idea how I can get out of this situation? Can I delete the SYSTEM OBJECT filespaces all together and gamble that I won't have to restore the registry that day? Will deleting the good system objects help with the orphans? Thanks. Dameon
ANE4034E
Hello Recently I've been getting the following errors during backup: 2003\02\11 02:36:26 ANE4023E (Session: 3219, Node: SPNT305) Error processing '\\spnt305\c$': file input/output error The backup seems to run fine. The clients are Windows 2000 and the BA client is 4.2.1.20. We are running ver 4.2.0.0 on MVS. What does the error mean and is it serious? Regards Niklas Lundström Swedbank
TDP for Exchange v2.2 and TSM for MAil 5.1.5
Is it the same thing but just another name? And yes, I know TSM for Mail requires TSM server ver 5 MVH Niklas Lundström Föreningssparbanken IT 08-5859 5164
Re: domain c: in cloptset is not excluding the d: drive
Hello Try to put overrride yes for domain in your clientopt set. How does your dsm.opt look like? Regards Niklas -Original Message- From: Lisa Cabanas [mailto:[EMAIL PROTECTED]] Sent: den 6 december 2002 14:38 To: [EMAIL PROTECTED] Subject: domain c: in cloptset is not excluding the d: drive Hello *, I have a problem with some of my NT SP5 clients (running client 4.2.1.20 mostly, with a 4.2.1.9 TSM server on 4.3 ML10 server. I am trying to only back up the c drive on a number of servers. I have tried putting the domain c: line in the dsm.opt on the client (manually and via the wizard), saving, stopping and restarting the scheduler service and it doesn't work. (I have deleted all the files spaces of the type d$ or e$, but they reappear after a plain ol' incr). I have put it in a cloptset just for those servers, and specified the cloptset for those clients, and it still backs up the d$ drive (but NOT the e$ that still physically exists). Another weird thing I have noticed, is that when I deleted the filespaces the were numbered like this: c$ fsid=1 d$ fsid=2 e$ fsid=3 But after the deletion of the fsid's 2 3 and after an incr backup, the newly backed up d$ has a fsid=4. What gives?? Here's the cloptset: (See attached file: CLOPTSET.TXT) and the scheds all run as an unspecified INCR. Also, if I browse the client thru the Web GUI or the user interface locally on the client's desktop, those drives still show up and they don't have Xs on them, either. I'm stumped. Any of you good folk have an idea??? thanks! lisa
eventlogging after installing Servergraph
Hello I did a testinstallation of Servergraph yesterday and today I get ANE events in my console It seems that Servergraph enable a lot of events to be logged. How do get rid of the ANE events from my console? MVH Niklas Lundström Swedbank
Re: Relocating TSM DB (storage)
That's interesting. Did they explain why you shouldn't use more than 10 db vols? Regards Niklas Lundström -Original Message- From: Robert L. Rippy [mailto:[EMAIL PROTECTED]] Sent: den 22 november 2002 15:35 To: [EMAIL PROTECTED] Subject: Re: Relocating TSM DB (storage) Yes, you are correct. Create the new DB's and extend the DB and then delete the old DB's. The data will migrate over to the new extended space. Any reason you had 37 1GB volumes for your DB's. IBM told me not to really go over 10 volumes on your DB and to be sure they aren't on the same drive if you can help it. I would suggest that if you could, create 5 8GB new volumes for a total of 40GB and move the DB over to the new 8GB partitions. Thanks, Robert Rippy From: Thach, Kevin [EMAIL PROTECTED] on 11/22/2002 09:30 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Relocating TSM DB (storage) I am wanting to move our TSM DB which is currently on ESS, and has 37 1GB dbvolumes, to another set of ESS disk. If I define the new dbvolumes on the new disks, do I then just extend the db, and then do a del dbvol on the old ones? Does the delete make the data migrate over? Do I have to do a reduce db for any reason before I do the delete dbvol? Can I do the delete with the server up and running? Thanks This E-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended only for the use of the Individual(s) named above. If you are not the intended recipient of this E-mail, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination or copying of this E-mail is strictly prohibited. If you have received this E-mail in error, please immediately notify us at (865) 374-4900 or notify us by E-mail at [EMAIL PROTECTED]
Re: Troubleshooting performance issues
Hello Your datatransfer rate seems low. Are you running at 100 mbit and full duplex? Try to ftp a file from the client to the server and check the transfertime, with 100mbit you should get about 10mb/sec Regards Niklas -Original Message- From: Etienne Brodeur [mailto:ebrodeur;SERTI.COM] Sent: den 5 november 2002 15:44 To: [EMAIL PROTECTED] Subject: Troubleshooting performance issues I have some major performance issues during archive operations. I also have bad performance durning backups, but the backup window is large so they complete without any problems. I can't seem to put my finger on the bottleneck and was wondering if someone had a document to recommend when looking for performance issues? Here is the scenario: TSM 4.2.2.10 server on W2K (SP2) 3 IDE drives. OS - DB - LOG 100 Mbs/Full Duplex (not auto) LTO 3583 SCSI attached to the server Server Options: CommTimeOut 60 IdleTimeOut 30 BufPoolSize 81920 LogPoolSize 512 TxnGroupMax 256 MoveBatchSize 256 MoveSizeThresh 500 UseLargeBuffers Yes NOBUFPREfetch No AuditStorage Yes SELFTUNEBUFpool Yes SELFTUNETXNsize Yes TCPWindowsize 64512 TCPNoDelay Yes There are 10 clients running 4.2.2.x (mostly 4.2.2.0). I have not set any performance settings in the DSM.OPTs. The servers have less than 10 GB of data each. I have 5 of them archiving to tape at the same time and they are all running very slowly: 05-11-2002 01:29:29 ANE4952I (Session: 5848, Node: HY-ORAPED-2000) Total number of objects inspected: 102,322 05-11-2002 01:29:29 ANE4953I (Session: 5848, Node: HY-ORAPED-2000) Total number of objects archived:86,989 05-11-2002 01:29:29 ANE4961I (Session: 5848, Node: HY-ORAPED-2000) Total number of bytes transferred: 6.46 Go 05-11-2002 01:29:29 ANE4963I (Session: 5848, Node: HY-ORAPED-2000) Data transfer time:11,875.56 sec 05-11-2002 01:29:29 ANE4966I (Session: 5848, Node: HY-ORAPED-2000) Network data transfer rate: 570.67 KB/sec 05-11-2002 01:29:29 ANE4967I (Session: 5848, Node: HY-ORAPED-2000) Aggregate data transfer rate:511.71 KB/sec 05-11-2002 01:29:29 ANE4968I (Session: 5848, Node: HY-ORAPED-2000) Objects compressed by:0% 05-11-2002 01:29:29 ANE4964I (Session: 5848, Node: HY-ORAPED-2000) Elapsed processing time:03:40:43 This was the fast one, I also have this W2K client: 05-11-2002 07:25:34 ANE4952I (Session: 5906, Node: HY-OSRV-2000) Total number of objects inspected:8,424 05-11-2002 07:25:34 ANE4953I (Session: 5906, Node: HY-OSRV-2000) Total number of objects archived: 8,364 05-11-2002 07:25:34 ANE4961I (Session: 5906, Node: HY-OSRV-2000) Total number of bytes transferred: 2.76 Go 05-11-2002 07:25:34 ANE4963I (Session: 5906, Node: HY-OSRV-2000) Data transfer time:2,871.55 sec 05-11-2002 07:25:34 ANE4966I (Session: 5906, Node: HY-OSRV-2000) Network data transfer rate:1,008.95 KB/sec 05-11-2002 07:25:34 ANE4967I (Session: 5906, Node: HY-OSRV-2000) Aggregate data transfer rate: 97.15 KB/sec 05-11-2002 07:25:34 ANE4968I (Session: 5906, Node: HY-OSRV-2000) Objects compressed by:0% 05-11-2002 07:25:34 ANE4964I (Session: 5906, Node: HY-OSRV-2000) Elapsed processing time:08:17:01 Please help me! I don't know where to look anymore. Thanks, Etienne Brodeur
Re: how many active session?
Hello The TSM Manager can provide you with this and much more. There is a free 30day trialversion to download at www.tsmmanager.com I think the product is very good Regards Niklas -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: den 16 oktober 2002 13:31 To: [EMAIL PROTECTED] Subject: how many active session? Does anyone know of a way to track the number of active sessions overnight. I know you can schedule re-occurring QUERY SESSIONs and then count them. I want to just get the number of active sessions say every 15, 30 or 60 minutes. I have to find the best place to move some backups but I don't have way of tracking this. Would that TSM MANGER product provide this? Thanks Matt
SQL command insteda of QUERY EVENT?
Hello Can I run select something from actlog command instead of q event * * ... Where are the events saved? The actlog table? Regards Niklas Lundström Swedbank
Re: sessOpen: Error 137 from signon authentication
Hi Have the same problem here, but on a Solaris client. TSM support haven't helped us, but I noticed when we changed the nodename to something shorter it worked... A workaroud is to have password in dsm.sys If you find a solution please let me know Regards Niklas -Original Message- From: Eric Winters [mailto:[EMAIL PROTECTED]] Sent: den 25 september 2002 09:58 To: [EMAIL PROTECTED] Subject: sessOpen: Error 137 from signon authentication Dear All, I have an AIX node with TSM Backup client at 4.2.1.0 and a TSM server on AIX at 4.2.1.10 I have PASSWORDACCESS GENERATE set in the dsm.sys, and I've set a PASSWORDDIR. The first time I attempt to run a dsmc command as root, I'm naturally asked to provide password details. This works fine and my command runs successfully. A TSM.PWD file is created as expected. But when I run my next dsmc command I have to provide the password all over again. And the dsmerror.log shows the following message sessOpen: Error 137 from signon authentication The baffling thing is that I have this working just fine on another node at the same level of client s/w talking to the same server. Any ideas? Thanks people, Regards, Eric Winters Sydney Australia
DiskXtender 2000 installation
Hello I will be installing DiskXtender 2000 on Friday, does anyone have some tips and hints of what to think of. I have been testing the product for a month and it works good, but now when we put it in production I want to be sure I get it right the first time. Regards Niklas Lundström Swedbank
Old client versions
Hello Where can I download clients older than ver 3.7? I can't find them anymore on the Tivoli website Regards Niklas Lundström Föreningssparbanken IT 08-5859 5164
Re: Backing Up Dir's
Define a separate management class for the directories, then use the DIRMC parameter i the OPT-file Regards Niklas -Original Message- From: Cahill, Ricky [mailto:[EMAIL PROTECTED]] Sent: den 31 juli 2002 13:04 To: [EMAIL PROTECTED] Subject: Backing Up Dir's We currently backup 12 Netware servers nightly, I also now need to backup the directory structure as a seperate backup job. The reason for this is that in a DR when you do a complete restore of a Netware server if TSM attempts to restore a file before the dir for it has been restored it skips the file, so the idea is to backup the dir's seperatly then come DR to restore all the dir's then do a normal restore over it. What I need to know is how would I got about backing up just dirs to a seperate pool? Thanks in advance. ..Rikk iTNET Rikk Cahill 3rd Line Server Support [EMAIL PROTECTED] Equitas London 0207-342-2358 Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK NOTICE: This message is intended only for use by the named addressee and may contain privileged and/or confidential information. If you are not the named addressee you should not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify [EMAIL PROTECTED] and delete the message and any attachments accompanying it immediately. Equitas reserve the right to monitor and/or record emails, (including the contents thereof) sent and received via its network for any lawful business purpose to the extent permitted by applicable law Registered in England: Registered no. 3173352 Registered address above
Re: Downlevel client code version
Hello According to Tivoli Support in UK the only way to fix this is to restore the database to a date prior than the date the NT node accessed with the Netware nodename. If you can fix this another way please share that information Regard Niklas Lundström Swedbank -Original Message- From: Henrry Aranda [mailto:[EMAIL PROTECTED]] Sent: den 23 maj 2002 21:55 To: [EMAIL PROTECTED] Subject: Downlevel client code version A have a problem: A WinNT client node (v.4.1.20) accessed the TSM server (v.4.2.1.15) using the nodename of a Netware client. Now the Netware client (v.4.1.0) can't access the server anymore. The message ANS1357S Session rejected: Downlevel client code version is displayed. The Platform in a q node changed from NetWare to WinNT. I upgraded the novell client to 4.2.1.29(greater than the WinNT client), but i receive the same message. A similar problem is described in IC32139, Does anybody know how i can resolve that? I need to restore data from my netware client. Henrry Aranda Gonzales _ Chat with friends online, try MSN Messenger: http://messenger.msn.com
Re: tsm database problem
Hello Your database needs to be reorganized, Your maximum reduction is only 60 Mb. Do a unloaddb and loaddb and after that delete the volumes Regards Niklas -Original Message- From: Burak Demircan [mailto:[EMAIL PROTECTED]] Sent: den 18 april 2002 13:51 To: [EMAIL PROTECTED] Subject: tsm database problem Hi, One of my TSM servers is TSM 4.2.2.0 on AIX 4.3.3 I have a 1.4GB database which is % 24 full as follows. --- tsm: ADSM01.MBTq db Available Assigned Maximum Maximum Page Total Used Pct Max. Space Capacity Extension Reduction Size Usable Pages Util Pct (MB) (MB) (MB) (MB) (bytes) Pages Util - - - --- - - - - 1 396 1 396 0 60 4 096 357 376 82 509 23.1 23.4 I have 7 volumes that build up the database which are consists of 200MB;100MB and xxxMB volumes. Today I tried to delete some of my volumes but I could not and it says there is not enough space. But I have ~900 MB free space on my database and it can not move the volume to other volumes. Do I miss something here? Regards, Burak
Re: retention policies
The standard management class we use for most servers is Ver data exists 3 Ver data deleted1 Retain extra ver30 Retain only ver 60 -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: den 10 april 2002 06:17 To: [EMAIL PROTECTED] Subject: Re: retention policies Ours is various, whatever the business requires related to the data. -Original Message- From: Marc Levitan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: retention policies Can I take a poll of what people are using for: versions data exists versions data deleted retain extra versions retain only version Thanks in advance! Marc Levitan Storage Manager PFPC Global Fund Services
Re: File length too long
Hello I think it is 256 characters /Niklas -Original Message- From: J. Glauer [mailto:[EMAIL PROTECTED]] Sent: den 9 april 2002 14:29 To: [EMAIL PROTECTED] Subject: File length too long Hi, Can someone tell me the maximum file length for that ? 04/09/2002 12:30:43 ANE4018E (Session: 2011, Node: SPRINZ_PC) Error processing '\\lt18\c$\Documents\Teaching_University\Inte- rnational Environmental Policy\Sem Advanced IEnvPol\Sem Climate Policy.SS2001\Student Simulations Presentations\Germany Simulations\Germany.National ER Goal.Additional Measures.1997-8\RG_Graichen.Simulation.d- oc': file name too long NT 4.0 TSM CLient 3.1 Thanks Achim Joachim Glauer Potsdam-Institut für Klimafolgenforschung (PIK) P.O. Box 60 12 03, 14412 Potsdam, Germany Phone:+49 (0)331 288 2608 Fax: +49 (0)331 288 2600 e-mail: [EMAIL PROTECTED] www:http://www.pik-potsdam.de - Note: If you need to send attachements to me, PLEASE! Avoid sending MS-Word.doc files (send *.rtf / *.pdf instead) -
Starting a incremental backup from the Server GUI??
Title: Message 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 scheduleI want to start a backup fromthe 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: Backing up a large file system for a TSM newbie
Hello Run a q db f=d What is yor cachehit%? If it is under 99 try to increase the bufpoolsize Also use resource utilization on the client: In dsm.sys add Resour=10 Journal based backup is only for Windows Regards Niklas Lundström -Original Message- From: Peter McMahon [mailto:[EMAIL PROTECTED]] Sent: den 22 mars 2002 12:10 To: [EMAIL PROTECTED] Subject: Re: Backing up a large file system for a TSM newbie Paul further info Tapes are 3590's - two of them! Disks are 18G internal SCSI Versions of TSM are 4.2.1.0 (server and client) n/w between client and server is 100BaseT Direct fibre connections between server and each tape device Other info which may help FTP'ed large (2G!) files between cleint and /dev/null on server.9000Kbytes/sec setting on server viewed thru GUI Maximum files in a client transaction = 256 (from TSM Server gui) Maximum files moved in a transaction = 500 (TSM server gui) Maximum megabytes moved in a transaction = 256 (gui again) Details of files below. TIA Peter dsm.sys on client is as follows... === SErvername tsmserv SCHEDMODE POLLING QUERYSCHEDPERIOD 1 COMMmethod TCPip TCPPort1500 TCPServeraddress tsmserv tcpnodelay no tcpwindowsize 1024 largecommbuffers yes txnbytelimit 2097152 nodename oradev1 errorlogretention 10,D passwordaccess generate schedlogname dsmsched.log schedlogretention 10,D compression no Nothing in dsm.opt == no dsmserv.sys (at least that I can find == Dsmserv.optas follows..non comment lines only included.I have never looked at the dsmserv filesthey are as was left by the 'consultants' who installed and ran away! COMMmethod TCPIP COMMmethod SHAREDMEM COMMmethod HTTP LANGuage en_US ENABLE3590LIBRARY YES HTTPPORT 1580 SHMPORT 1510 TCPBUFSIZE 32 TCPNODELAY YES TCPPORT 1500 COMMTIMEOUT 60 DISABLESCHEDS YES IDLETIMEOUT 15 MAXSESSIONS 40 USELARGEBUFFERS YES BUFPOOLSIZE 32768 SELFTUNEBUFPOOLSIZE YES LOGPOOLSIZE 2048 MIRRORREAD DB NORMAL MIRRORREAD LOG NORMAL MIRRORWRITE DB SEQUENTIAL MIRRORWRITE LOG SEQUENTIAL MOVEBATCHSIZE 500 MOVESIZETHRESH 256 TXNGROUPMAX 256 EVENTSERVER YES DEVCONFIG /usr/tivoli/tsmlog/devconfig DEVCONFIG /usr/tivoli/tsmlogmir/devconfig2 EXPINTERVAL 0 VOLUMEHISTORY /usr/tivoli/tsmlog/volumehistory VOLUMEHISTORY /usr/tivoli/tsmlogmir/volumehistory -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: 22 March 2002 01:18 To: [EMAIL PROTECTED] Subject: Re: Backing up a large file system for a TSM newbie I have file systems with 1.5TB and 9 million files. They do take a while to backup. We can save a 1 TB SAP database in about 2.5 hours. So, I think we need some more information. What kind of tape? What kind of disk? TSM server on AIX? What kind of Network interface? What does your dsmserv.sys and opt and dsm.sys and dsm.opt look like? -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:40 PM To: [EMAIL PROTECTED] Subject: AW: Backing up a large file system for a TSM newbie try with the adaptive sub-file differencing incl. in the 4.2 Client If you have enough capacity in the network components the ressourceutil param in the dsm.opt or dsm.sys may also help regards joachim -Ursprüngliche Nachricht- Von: Peter McMahon [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 21. März 2002 19:33 An: [EMAIL PROTECTED] Betreff: Backing up a large file system for a TSM newbie Hi, sorry if this is a repost! firstly let me state that I am very new to TSM and have only picked up bits and pieces from reviewing the list and some FAQ type docosso pls excuse if this is a basic question... We have several AIX boxes which have 'large' file systems...by large I mean 30Gig which contain multiple installs of Oracle sever s/w so thousands of files/directories. (NB Not the database files them selves) A selective backup of these is taking a 'significant' amount of time - approx 4 hr to do a filesystem of about 35G...I have tried going directly to tape - think it was even slower so what I am looking for is some advice on the best settings for these types of file systems TIA Peter ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. **
How long does a UNLOADDB take???
Title: Message Hello We tried to do a unloaddb this weekend to reorganise our database. Itran fine for 2 hours but then it seemed to stop after 157 million entries. ANR4013I UNLOADDB: Dumped 157654872 database entries (cumulative). But after this nothing happens, wecould see I/O activity in MVS for the task. After 6 hours we cancelled the job. I've read on the ADSM list about unload times over 20 hours, is this a normal time? q db Available Assigned Maximum Maximum Page Total Used Pct Max.SpaceCapacity ExtensionReduction Size Usable Pages Util Pct(MB) (MB) (MB) (MB)(bytes)Pages Util--- 44,868 44,868 0 6,2164,096 11,486,2089,737,49284.884.8 TSM 4.2.0 running on OS/390 MVH Niklas Lundström Föreningssparbanken IT 08-5859 5164
Re: ***The JOURNALED BACKUP saga continues...***
Hello Pete When will ver 5.1 Journal Sevice be out? Does it require ver 5.1 of TSM Server as well or does it work with 4.2.1? How do I disable logging to jbberror.log? On some servers it gets very big Regards Niklas Lundström Föreningssparbanken IT -Original Message- From: Pete Tanenhaus [mailto:[EMAIL PROTECTED]] Sent: den 10 januari 2002 21:19 To: [EMAIL PROTECTED] Subject: ***The JOURNALED BACKUP saga continues...*** Answers/Comments to questions.. I have read all of the information about Journal Backups in the Tivoli Storage Manager for Windows Using the Backup-Archive Client Manual and also the 4.2.1 READMe for NT and it seems that there is more information needed on the behavior of Journal-Based Backups! Agreed. I am working on developing a redbook with guidelines for understanding and deploying Journal Based Backup. I have an NT 4.0 client with TSM 4.2.1.15 (I will soon be upgrading to 4.1.2.20) client installed which it processes approximately 290,000 objects with about 2,200 (less than 1%) changing on a daily basis. If the amount of daily change activity is less than 5% is it still beneficial to use Journal Backups? This is an ideal environment for Journal Based Backup. The primary performance benefit over normal incremental backup is eliminating scanning the entire local file system. When I first upgraded to 4.2.1.15 from 4.1.2.0, I decided not to perform a Journal backup on this particular client, so I DISABLED the service. On Tuesday, I started the Journal Service so it could begin its journaling process and log any changed objects or its attributes in the journal database. The backup still took 9.5 hours to complete with the same behavior as without Journaling. So, I continued to let it run the next night and it still took 9.5 hours as well. It seems as if the Journal Engine Service is not working properly! I still see sessions terminating due to the extensive processing/querying that the producer thread does while in an idlewait status. Keep in mind that a normal full incremental must be done on a file system being journaled to create a valid journal before journal based backup will work. If the Journal Service is stopped all journals are deleted and obviously will no longer valid when the service is restarted so a full incremental must be performed (and completed) before journal based backup will work again. The version 5.1 journal service has a setting to override this behavior, that is to allow a journal to remain valid when the file system goes offline or the service is stopped and restarted. It seems as if the Journal Engine Service is not working properly! I still see sessions terminating due to the extensive processing/querying that the producer thread does while in an idlewait status. I think what is happening is that a full incremental is being forced because the journal was deleted when you stopped the service. Note that you can override journal based backup when a valid journal exists by using the -nojournal option in the backup client.. Also, if anyone can explain this message it would be greatly appreciated? psFsMonitorThread(tid 1044): Object 'C:\WINNT\Temp\TMP5.tmp' was deleted after notification. This message is erroneous and shouldn't be logged as an error (this is fixed in the version 5.1 journal service). Basically what it means is that a change notification was generated for an object which was deleted before journal service could process the notification. I mistakenly thought this to be an unusual type of error condition but it turns out to happen quite frequently when applications create and delete temporary files in a very short time span. Hope this answers your questions . 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 01/10/2002 03:03 PM --- Malbrough, Demetrius [EMAIL PROTECTED]@VM.MARIST.EDU on 01/10/2002 12:22:13 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:***The JOURNALED BACKUP saga continues...*** Any *SMers using NT Journal Backups **This question is posed to Tivoli Client Development [Andy Raibeck] or Tivoli Storage Solutions Software Development [Pete Tanenhaus] if possible** --- I have read all of the information about Journal Backups in the Tivoli Storage Manager for Windows Using the Backup-Archive Client Manual and also the 4.2.1 READMe for NT and it seems that there is more information needed on the behavior of Journal-Based Backups! I have an NT 4.0 client
SQL Backup Protocol error
Title: Message HelloI have a problem when running backup of my MS-SQL db.The following message is from the activity log. 01/09/2002 16:15:08 ANE4991I (Session: 17311, Node: DP4PP2SQL) TDP MSSQL NT ACO3507 Sql Application Client: Starting INCR backup of database model from server DP4-PP2. 01/09/2002 16:15:08 ANR0444W Protocol error on session 17311 for node DP4PP2SQL (TDP MSSQL NT) - out-of-sequence verb (type Data) received. 01/09/2002 16:15:08 ANR0484W Session 17311 for node DP4PP2SQL (TDP MSSQL NT) terminated - protocol violation detected. It is only incremental backups that don't work. Full backups works fine. The version is 1.1.2 of TDP, SQL 7.0 and TSM-server 4.2.1 on MVS It has stopped working yesterday and nothing has been done on the server. MVH Niklas Lundström Föreningssparbanken IT 08-5859 5164
APAR IC31313
Title: Message Hello Does anybody know if this problem has been fixed? Tivolis recommendation is to "applythe PTF when available" but in the readme's for the latest PTF it doesn't say anything about APAR IC31313. Regards Niklas Lundström Föreningssparbanken IT 08-5859 5164
Client version changed, unable to run BA Client
Title: Message Hello We're using TSM server 4.2.0 on MVS Client levels from 3.1.5 to 4.2.1.15 Yesterday I noticed that our large NT-fileserver couldn't connect to the server, ANR0428W Session 3937 for node SPNT190 (WinNT) refused client is down-level with this server version. It turned out that in the TSM server the node spnt190 showed a client version level of 4.2.1.15 but the BA Client installed is only 3.1.5. Someone had restored files from the node using a 4.2.1.15 client. How do I change the client version in the database to match the real version on the node? In this case I had to upgrade the NT server to BA Client 4.2.1.15 to get the backups running again. Regards Niklas Lundström Föreningssparbanken IT 08-5859 5164
Script to cancel certain sessions
Hello TSM:ers I'm trying to write a script that should cancel the sessions for certain servers if their backup still runs at 9 am but I'm stuck. How can I do that? It should be automated by a command script. Regards Niklas Lundström Föreningssparbanken IT 08-5859 5164