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

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

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:

SV: Invisible node???

? 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

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

SV: Unable to delete all filespaces for a node

: 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

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

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

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

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

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

SV: TDP SQL sessions wants to write to same tape...

: 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

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

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

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

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

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?

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

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

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 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

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,

Re: Informix backup

: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

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.

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]

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

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]

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

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

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:

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

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]

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

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

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

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

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-

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:

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

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

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

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

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

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

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

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

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