AW: query occupancy command - file names

2016-08-04 Thread Ullrich Mänz
Hi Paul, try out that: select file_name from contents where volume_name in (select volume_name from volumes where stgpool_name='BKPLTO6POOL') Because data is taken out of contents table, this query may run very long. Regards Ulli Maenz -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Ma

Antwort: [ADSM-L] SQL error

2013-03-12 Thread Ullrich Mänz
Hi Eric, try to add the table name as follows: select * from backups where backups.node_name='KL127EAC' and backups.type like 'IMAGE%' good luck regards Ulli Ullrich Mänz Data Center Services FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D,

Antwort: [ADSM-L] tsm reclaim of copy pool

2013-02-07 Thread Ullrich Mänz
ss again. - And check for messages just before ANR1163W. The data is taken from primary storage pools. best regards Ullrich Mänz Data Center Services FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil +49 170 7678 434 Fax: +49 69 3801

AW: [ADSM-L] Restoring for a specific date?

2013-02-03 Thread Ullrich Mänz
Hi, The option "-pitdate" is valid for the B/A client. You need to use /stopat or /stopbefore parameters instead. Good luck. Ullrich Mänz Teamleader IBM System z FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil: +49 170 7678434 Fax: +49 69

Antwort: [ADSM-L] Active log

2012-11-29 Thread Ullrich Mänz
logfile every ten minutes. After opening a call at Tivoli Support, our solutions was: upgrade server to version 6.3.2.200. Hope that helps. best regards Ullrich Mänz Data Center Services FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil

AW: [ADSM-L] Active log

2012-11-29 Thread Ullrich Mänz
Hello Bo, IG your log is growing eben IG there was a backup running - mostly started by the TSM server ordelf, check the timestamp OF the logfiles. We had a similar situation where the server creates a new logfile every ten minutes. The solution after opening a call to Tivoli: upgrade server t

Antwort: [ADSM-L] devclass definition

2012-11-01 Thread Ullrich Mänz
average size of the databases. In most cases, we use more than one devclass of type file. best regards Ullrich Mänz Data Center Services FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil +49 170 7678 434 Fax: +49 69 3801 3500 10 Web:

Antwort: [ADSM-L] question about copy activedata and pooltype=activedata

2012-08-25 Thread Ullrich Mänz
run the copy command later on on all stgpools the data from last backup sessions may reside. You need to run recalim stgpool on an actve data pool very often and you should define small volumes (i.e. 8GB), if this is a pool of devclass file. best regards Ullrich Mänz Data Center Services FRITZ &a

Antwort: [ADSM-L] dsmserv.exe 6.3.1 command line troubleshooting

2012-07-24 Thread Ullrich Mänz
pt resides, first. I've also found problems starting dsmser in the foreground if "C:\program files\tivoli\tsm\server" is part of the program path (there might be another dsmserv.opt in this path which is located/read before your instance option file). best regards Ullrich Mänz Da

Antwort: [ADSM-L] trouble starting tsm server 6.2.2

2012-07-03 Thread Ullrich Mänz
guide, look for chapter 3 "configuring the server instance manually" and chpter 10 "uninstalling and reinstalling..." for additional help / details to the commands needed) best regards Ullrich Mänz Data Center Services FRITZ & MACZIOL Software und Computervertrieb GmbH

Antwort: [ADSM-L] ANS1395E tsm restore virtialnode on linux

2012-05-17 Thread Ullrich Mänz
Hi Tiim, you need to add double quotes, so the command looks like: dsmc restore -virtualnode=... -pi -subd=y "/u01/*" /u01/ Mit freundlichen Grüßen / best regards Ullrich Mänz Data Center Services FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offe

Antwort: [ADSM-L] dedup question

2012-04-10 Thread Ullrich Mänz
a "reclaim stg" or doing backups by turning off dedup processes using command "identify duplicates numpr=". That can be scheduled by administrative commands. Mit freundlichen Grüßen / best regards Ullrich Mänz Data Center Services FRITZ & MACZIOL Software und Computerver

AW: [ADSM-L] Checking what packages are installed on suse sles10

2012-03-31 Thread Ullrich Mänz
Possibly, you've got the answer already. If not: as root run 'rpm -qa | grep -e TIV -e gsk' - that will list all TSM BA client packages. Normally, There is no need to remove the gsk packages. Ullrich Mänz Teamleader IBM System z FRITZ & MACZIOL Software und Computervertr

AW: [ADSM-L] Server to server export problem

2012-03-08 Thread Ullrich Mänz
After upgradng TSM V5 servers to lstest maintenance level including The Server Update package we have found no problems at all on exporting data to TSM V6.x servers. Without having the server upgrade package installed, in one situation I've got an error transferring non-unicode data. Ul

Antwort: Re: [ADSM-L] TSM 5.5 actlog size..

2011-11-18 Thread Ullrich Mänz
hinks about reducing it again... regards Ullrich - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil: +49 170 7678434

Antwort: [ADSM-L] rc-scripts to start and stop multiple tsm client scheduler for linux red hat

2011-06-14 Thread Ullrich Mänz
above. Regards Ulli - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil: +49 170 7678434 Fax: +49 69 38013500 10 Web: http://www.fum.de Amtsgericht Ulm, Handelsregister-Nummer: HRB 1936 Geschäftsführer: Heribert

Antwort: [ADSM-L] who makes policy for TSM?

2011-05-23 Thread Ullrich Mänz
not grant authority to your TSM server to all of them ;-) regards Ullrich - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany A

Antwort: [ADSM-L] LanFree very low performance

2010-11-23 Thread Ullrich Mänz
Ulli - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil: +49 170 7678434 Fax: +49 69 38013500 10 Web: http://www.fu

Antwort: [ADSM-L] No drives are currently available in library

2010-10-04 Thread Ullrich Mänz
Hi David,, it seems, the paths to the drives are offline. Please, run "q path" and set paths online, if necessary. regards Ulli - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ullrich Mänz System-Integration FRITZ & MACZIO

Antwort: [ADSM-L] Raid 1 vs Raid 5

2010-08-09 Thread Ullrich Mänz
Hello Dana, normally I create storage pools on RAID-5 protected disk arrays using 5 disks per RAID group for high performance on writing and short rebuild times in case of hardware failures. Using larger RAID groups with 6, 7 or more data drives were found to be very slow during RAID rebuild, som

Antwort: Re: [ADSM-L] update stg collocate=node

2010-05-17 Thread Ullrich Mänz
you can force collocation by running "move data" or "move nodedata" or wait until next reclamation is needed. regards Ulli Von:Mehdi Salehi An: ADSM-L@VM.MARIST.EDU Datum: 17.05.2010 11:30 Betreff:Re: [ADSM-L] update stg collocate=node Gesendet von: "ADSM: Dist Stor Manager"

Antwort: Re: [ADSM-L] Copy Tape pool for a selected set of tapes

2009-11-26 Thread Ullrich Mänz
Just another remark: Complex environments with many stgpools were solved by doing collocation by group. Why is it not possible to do a backup stgpool using this collocgroups? Best regards Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str.

Antwort: [ADSM-L] 2nd Instance of TSM

2009-11-26 Thread Ullrich Mänz
parallel and/or start using journal based backup (if possible). I've found that more easy than administering many instances... You will find additional tuning tipps in the TSM Performance & Tuning Guide Best regards Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computer

Antwort: [ADSM-L] TSM 6.1.2.0 - Let's reclaim...well..maybe not.

2009-09-14 Thread Ullrich Mänz
idea how to set the thresh-parm on reclaim command. Mit freundlichen Grüßen / Best regards Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil: +49 170 7678434 Fax: +49 69 38013500 10 Web: http://www

Antwort: [ADSM-L] handling mount requests

2009-09-04 Thread Ullrich Mänz
delete volume xx discard=yes" before overwriting the tape. Have you thought of using two copypools used alternativly each day or week? Best regards Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Amtsgericht Ulm,

Antwort: Re: [ADSM-L] Output manipulation on selects

2009-03-26 Thread Ullrich Mänz
Hi Kurt, many thanks for that hint. Previously we are executing the selects from a macro file (foregroud processing was for demo only). Moving the macro into a TSM server script gives the results we were looking for. It works on Linunx and Windows! Best regards Ullrich Mänz BEYERS Kurt

Output manipulation on selects

2009-03-25 Thread Ullrich Mänz
to set up the SQL statement on a Linux host? Client versions tested: Windows:5.4.1.6 and 5.5.1.6 Linux: 5.4.1.0 and 5.5.1.0 TSM servers: Windows:5.5.1.0 Linux: 5.1.5.0 (x86) and 5.3.4.0 (ppc64) Best regards Ullrich Mänz System-Integration FRITZ & MACZIOL

Antwort: [ADSM-L] Greetings & request for help

2009-01-07 Thread Ullrich Mänz
ot; formatsize=500 Best regards Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Telefon: +49 69 38013500 15 Mobil: +49 170 7678434 Fax: +49 69 38013500 10 Web: http://www.fum.de Amtsgericht Ulm, Handelsreg

Antwort: [ADSM-L] TSM systemstate backups or NTBACKUP

2008-11-28 Thread Ullrich Mänz
ackup failed TSM Schedule will not run. Delete next line if you don't want this. exit %ERRORLEVEL% The ntbackup options file C:\SysBackup\sysstate.bks contains the word "SystemState" followed by a blank line. Mit freundlichen Grüßen / Best regards Ullrich Mänz System-Integrat

Antwort: [ADSM-L] Windows 2nd instance - how to restore the DB?

2008-05-02 Thread Ullrich Mänz
log previously like you have already done with option -k in order to get a valid dsk file. Good lluck Mit freundlichen Grüßen / Best regards Ullrich Mänz System-Integration FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Office: +49 69 3801350