Equivalent of UNIX tail/head in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
Hi, I am trying to make some useful reports by queryring the TSM database, but I can not find out how to fetch the first N rows in that query. In the DB2-manuals I find the fetch command, but it does not seem to work here. Also tried googling and searching the archives here. Example where I

Re: Equivalent of UNIX tail/head in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
Install Perl on your (I assume) Windows machine and imbed your select statement within a Perl script that does what you want. Welcome to an operating system that doesn't come with anything resembling a decent scripting language. Usually Perl is what I use on all platforms, but in this

Re: Equivalent of UNIX tail/head in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
Thank you for the information! Since it doesn't work I limit the searches by a 'where' statement. (Btw. any reason for the limitations? Are they afraid we're going to use the TSM-database for other purposes?) Best regards Hans Chr. --- Hans - The TSM database is not an SQL db. The SQL

Re: Equivalent of UNIX tail/head in TSM SQL query

2004-10-13 Thread Hans Christian Riksheim
PROTECTED] On Behalf Of Hans Christian Riksheim Sent: Wednesday, October 13, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Re: Equivalent of UNIX tail/head in TSM SQL query Install Perl on your (I assume) Windows machine and imbed your select statement within a Perl script that does what you

Re: New Linux server issues

2007-06-08 Thread Hans Christian Riksheim
The cost of IBM-boxes, which you base your whole argument on, is listed on www.ibm.com. If you had taken a few minutes to check it out you would have found that the cost has been reduced significantly the last couple of years. In our TSM environment the cost and maintenance of the AIX

SV: TSM performance very poor, Recovery log is being pinned

2007-07-31 Thread Hans Christian Riksheim
Hi, you say you are experiencing no difference in performance between raw and ufs volumes on Solaris. I don't know which TSM version you are using but there is a problem with TSM utilizing raw volumes which is fixed in 5.2.8/5.3.4. Check out APAR IC49036 at IBM support. BTW, I am also in

Re: DB Backup to tape affect AIX Performance

2007-09-13 Thread Hans Christian Riksheim
Hi! I'm almost certain that you have a memory problem. The high rootvg activity indicates swapping. Either you have too little memory or your AIX system is not properly tuned(or not tuned at all). My experience is that the last one is most frequent. You should get an experienced AIX sysadmin

Library sharing over FCIP

2008-01-03 Thread Hans Christian Riksheim
Hi! Does anybody have any experience with library sharing over FCIP. I am involved in a setup where the copypool is located far awyay from the primary backup. I am not happy with using Virtual Volumes so I want to explore the possibility of mounting the tape drives directly over the SAN.

Re: ANS1030E The operating system refused a TSM request form memory allocation

2008-01-24 Thread Hans Christian Riksheim
Hi! Several possibilites here. First find out if the AIX error log tells you something. Limits: Check in /etc/security/limts if there are any restrictions on memory usage. I usually set all to -1(unrestricted) to be sure. Memory leak in 'dsmc schedule': After a while this process tends to

Re: TSM has built-in encryption?

2008-03-10 Thread Hans Christian Riksheim
A lot of people opt for the transparent encryption scheme where the key is held in the TSM database and it seems that IBM is moving in that direction with this feature being the only option in 5.5 for the BA-client. It seems that I am the only one who wants it the other way around. As I see

Re: TSM being abandoned?

2008-04-17 Thread Hans Christian Riksheim
We look at dedup VTL as a possible target for active storage pools containing ordinary file backup. This way we don't risk very much if the VTL breaks or the VTL's dedup index goes corrupt. I am a little sceptical about the robustness of these products so I will not let these VTL's play a too

Re: What to dedup.. was TSM being abandoned?

2008-04-17 Thread Hans Christian Riksheim
with your opinion about performance. //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hans Christian Riksheim Sent: den 17 april 2008 14:32 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM being abandoned? We look at dedup VTL as a possible

SV: Fantasy TSM

2008-05-05 Thread Hans Christian Riksheim
And me: On the client: * Client-key encryption for all TDP's. * Setting in dsm.sys/opt that makes it impossible for the TSM-server to override any security settings on the client. * Client having an option to choose another compression algorithm(ZLIB for example) that is faster and less

Strange web admin behavior after upgrade from AIX5.2 to AIX5.3

2006-04-10 Thread Hans Christian Riksheim
in the command line. Before the upgrade, the contents of Object View or a command was displayed in the same window. Anyone experienced the same thing or have suggestions here? It is not super critical, but any help is appreciated. Regards Hans Christian Riksheim

SV: Preventive Action : Upgradation from 5.2 -- 5.3

2006-04-11 Thread Hans Christian Riksheim
Hi, I just received and implemented a tip from Timothy Hughes. Make sure you have a recent fixpack for TSM 5.2 when you are going to AIX5.3 or else you will encounter the problem described in IC47636(TSM web interface starts popping up new windows when it shouldn't). For me, upgrading to

Re: poor performance

2006-08-22 Thread Hans Christian Riksheim
Hi, before seriously looking into your HW-configuration and disk layout you should rule out any paging space issues and lack of I/O-tuning. Check paging space activity with vmstat or nmon. Consistant activity to and from paging space during dbbackup/expiration indicates you have a memory/tuning

Reclamation and large files

2006-11-07 Thread Hans Christian Riksheim
Hi, I am trying to understand what TSM does with reclamation of large files. We have a filepool of 10G-volumes and I see the TSM-server moving a 64G file during reclamation. This file is from an Exchange-backup. It seems to me that TSM moves the whole file to other volumes and not just the

Re: Spreading load across SAN Arrays

2006-11-09 Thread Hans Christian Riksheim
Hi, you have not told the type of TSM-server you are using, but I guess it maybe is AIX since you already have purchased the disk system from IBM. If you use another OS, ignore the rest of this e-mail as other methods for spreading IO apply(methods I know little about). However, for AIX you can

Using the DBI::TSM module, memory problem

2006-12-04 Thread Hans Christian Riksheim
Hi, anybody else using the perl module DBI::TSM? I've recently been using it for reporting purposes and find it quite useful. However I have some problems with the perl memory consumption. This may very well be caused by my lack of knowledge of DBI, but I haven't found a remedy yet. The

Re: Using the DBI::TSM module, memory problem

2006-12-04 Thread Hans Christian Riksheim
regards Hans Christian Riksheim Fra: ADSM: Dist Stor Manager på vegne av Richard Sims Sendt: ma 04.12.2006 15:46 Til: ADSM-L@VM.MARIST.EDU Emne: Re: Using the DBI::TSM module, memory problem On Dec 4, 2006, at 9:21 AM, Hans Christian Riksheim wrote

Re: Using the DBI::TSM module, memory problem

2006-12-07 Thread Hans Christian Riksheim
Hi, I have now tried different approaches for my large TSM query: DBI: Allen Rout confirmed my suspicions in a previous post. This one loads the whole output of the sql into memory before processing. For my large query I killed the program when it reached 1GB. ODBC: This one seems to kick off

TDPO and encryption

2007-03-22 Thread Hans Christian Riksheim
Hi, does anyone have any experience with rman/tdpo and encryption? I have not found any detailed information on how to implement it and the redbook from 2001(Backing up Oracle using TSM) does not mention it. I have learned that there are two ways of doing it: Client handles encryption through

Re: TDPO and encryption

2007-03-27 Thread Hans Christian Riksheim
/adsmorc/.../* This assumes that your TDPO_FS is 'adsmorc' (the default) and that you want all Oracle backups to be encrypted. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Hans Christian Riksheim [EMAIL PROTECTED] Sent by: ADSM: Dist Stor

Trouble when TSM-database reaches 100Gb?

2005-09-01 Thread Hans Christian Riksheim
Hello, we are experiencing throughput problems on our TSM-installation. Apart from he obvious that we have too few tape drives, bottlenecks in our LAN and an old AIX-box, we got a suggestion to add another TSM-server. The reason was that the performance degrades when the TSM-database reaches

SV: Trouble when TSM-database reaches 100Gb?

2005-09-06 Thread Hans Christian Riksheim
Hello, I just want to thank you all for the input. It has been really valuable in my discussion with the money people at my work place. Right now we're running TSM on a Bull Esala PL220(power3, 2CPU 2GB memory) and use some left-over Sun jbods disk rack for the database. Expiration takes

SUN CMT servers vs UltraSPARC for TSM

2008-11-19 Thread Hans Christian Riksheim
Hello, list. We are speculating whether we should employ the latest CMT-server from SUN as TSM-servers. The CMT-servers are many cores/many threads but each thread is relatively slow(1,2/1,4 GHz) compared to Ultra Sparc(2,3Ghz). My question is if TSM benefits from many threads or if we should go

Re: SUN CMT servers vs UltraSPARC for TSM

2008-11-19 Thread Hans Christian Riksheim
UltraSPARC for TSM Could you specify which server you are looking at ? We are running all our tsm servers on SUN and FJ PrimePower -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hans Christian Riksheim Sent: Wednesday, November 19, 2008 3:55 PM To: ADSM-L

Re: SUN CMT servers vs UltraSPARC for TSM

2008-11-19 Thread Hans Christian Riksheim
Subject: Re: SUN CMT servers vs UltraSPARC for TSM On Wed, 19 Nov 2008 15:54:39 +0100, Hans Christian Riksheim [EMAIL PROTECTED] said: We are speculating whether we should employ the latest CMT-server from SUN as TSM-servers. The CMT-servers are many cores/many threads but each thread

Re: Where is the missing 38GB?

2008-12-03 Thread Hans Christian Riksheim
Shoot me if I am wrong, but isn't this a correct result? The database uses 0,001 times the assigned capacity, that is around 50 Megabytes. Of these 50 Megabytes, zero MB is recoverable by a dbreorg. As of my knowledge estimate dbreorg operates on how much is actually utilized. So if you dump it

Re: TSM 6.1 Installation Problems

2009-06-04 Thread Hans Christian Riksheim
Thanks for the pioneer work with 6.1! Myself and other free riders are in deep gratitude to those contributing to making version 6 stable and useful. When the dust settles in a year or so I too may choose to upgrade knowing that others have taken the risk of losing their data and personal sanity

Re: File Device class question

2009-06-19 Thread Hans Christian Riksheim
Hi, could you tell us more about that SAN meltdown. It is a rather rare occurence. Best regards Hans Chr. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rodney Luk Sent: Thursday, June 18, 2009 8:24 PM To: ADSM-L@VM.MARIST.EDU Subject: Re:

Re: Some advice about compression=yes to perform IMAGE backup

2009-09-20 Thread Hans Christian Riksheim
In my experience client side compression on W2K/Intel is quite fast but on AIX it is very slow. I have no idea why the difference is so huge. This poses a problem on AIX when we do client side encryption since compression must be done before encryption. Oracle RMAN has two alternate

Tuning 6.2 on AIX

2010-08-26 Thread Hans Christian Riksheim
Hello. We are in the process of upgrading our TSM-servers on AIX(5,.3/6.1) to TSM 6.2. We have always used raw devices for disk stgpools, db and logs but with 6.2 jfs2 is the rule. Any tip on mount options? Should cio be used anywhere? I understand that the application will take care of caching

SV: Determining devclass FILE values (a.k.a. New Server - Part Deux)

2010-09-21 Thread Hans Christian Riksheim
I had the same problem and then I just kept the low maxcap and set reclaim=100 for the stgpool that housed most of the large files with simlilar retention(Exchange, Oracle). Not sure if this is applicable to your setup. HC Fra: ADSM: Dist Stor Manager på

AIX JFS2 tuning with DB2 on TSM6.2

2010-10-24 Thread Hans Christian Riksheim
Hi! I have not found any recommended settings for JFS2 for the database in TSM6.2. Should I mount the db filesystems cio or dio or leave them with default mount options? Hans Chr. This email originates from Steria AS, Biskop Gunnerus' gate 14a, N-0051 OSLO, http://www.steria.no. This email

Re: tsm v6 mem requirements for dedicated library manager instance

2010-11-04 Thread Hans Christian Riksheim
I have an AIX-server with 8G RAM and two TSMv6 instances, one of them a library manager. The library manager has capped DBMEMPERCENT=12. I have also set up a dedicated configuration manager(which should be comparable to a lib manager) in a VM with 2008R2 with 2G of RAM. Both works fine. Hans

Re: ULTRIUM4C but not 1.6TB

2010-12-09 Thread Hans Christian Riksheim
If a LTO4 tape holds more than 800GB compression is on. At our place, file data only has a 1.1:1 compression while Oracle data and mail is 2.5:1. Overall it is 2:1. Hans Chr. On Thu, Dec 9, 2010 at 9:18 AM, Mehdi Salehi ezzo...@gmail.com wrote: Hi, Drives are LTO4, devclass is ULTRIUM4C,

Re: Anybody not happy with TSM V6?

2011-01-21 Thread Hans Christian Riksheim
We are mostly happy with our upgrade to 6.2.2 on AIX, but keep in mind that 6.2.2 likes to have a lot of CPU so maybe an upgrade to Power7 should be considered. Expiration is normally run much quicker in v6 but it varies a lot. Esepcially after a TSM restart it seems to be slow like DB2 has to

Re: 1024 DB2 database connection limit on AIX

2011-03-14 Thread Hans Christian Riksheim
I expect IBM to make a fix very soon that will up this limit. If not we will seriously consider other architectures. We prefer AIX for a number of reasons. Long, tedious and risky procedures to circumvent artificial limits is not one of them. For me TSM v6 has failed to live up to its

Expiration causes backups to hang

2011-04-13 Thread Hans Christian Riksheim
Hi, anyone else have this problem? Running 6.2.2 on AIX 6.1. Submitting a PMR on this in parallell. When I say hang I mean a complete hang. All incoming backups stops. Traffic is resumed when we cancel expiration. Hans Chr.

Re: Expiration causes backups to hang

2011-04-24 Thread Hans Christian Riksheim
Problem is resolved. We upgraded from 6.2.2.0 to 6.2.2.25(6.2.2.2 patch + efix) and expiration rates are 5-10 times higher and no hangs yet. We observe that System State expirations from 2008 servers are much faster now. Hans Chr. On Wed, Apr 13, 2011 at 10:17 AM, Hans Christian Riksheim bull

TSM client security question

2011-06-15 Thread Hans Christian Riksheim
Hi, If I have two customers connected to the same TSM-server, customer A can retrieve the data of customer B if he gets hold of a TSM admin password. Besides client side encryption, any method to prevent that? Regards Hans Chr. Riksheim

Re: TSM client security question

2011-06-15 Thread Hans Christian Riksheim
On Wed, Jun 15, 2011 at 4:30 PM, Thomas Denier thomas.den...@jeffersonhospital.org wrote: I have done cross-system restores using a TSM administrator account with system privilege, and the TSM client documentation indicates that I could have done the same thing if my account had policy

How to completely get rid of TSM6.2/DB2 on AIX

2011-08-22 Thread Hans Christian Riksheim
Hi, I've got a problem. An installation failed when creating an instance and I decided to uninstall and start over. I removed the installation using the uninstall script provided. But when I ran install.bin the next time it asked for the password of the instance owner and then failed. So it

Re: Ang: [ADSM-L] How to completely get rid of TSM6.2/DB2 on AIX

2011-08-23 Thread Hans Christian Riksheim
Christian Riksheim bull...@gmail.com Sänt av: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Datum: 08/22/2011 20:41 Ärende: [ADSM-L] How to completely get rid of TSM6.2/DB2 on AIX Hi, I've got a problem. An installation failed when creating an instance and I decided to uninstall and start over

Re: Ang: Re: [ADSM-L] Ang: Re: [ADSM-L] vtl versus file systems for pirmary pool

2011-09-28 Thread Hans Christian Riksheim
This 6 TB supported limit for deduplicated FILEPOOL does this limit apply when one does client side deduplication only? Just wondering since I have just set up a 30 TB FILEPOOL for this purpose. Regards Hans Chr. On Tue, Sep 27, 2011 at 8:44 PM, Daniel Sparrman daniel.sparr...@exist.se wrote:

Re: Data change rate

2011-10-12 Thread Hans Christian Riksheim
What about just finding the ratio between the numbers in the tables SUMMARY and AUDITOCC? Hans Chr. On Wed, Oct 12, 2011 at 2:53 PM, Ehresman,David E. deehr...@louisville.edu wrote: Is there any way from the server side to get an estimate of overall client data change rate?

Re: Data change rate

2011-10-12 Thread Hans Christian Riksheim
Sorry, summary and FILESPACES. Hans Chr. On Wed, Oct 12, 2011 at 5:51 PM, Hans Christian Riksheim bull...@gmail.com wrote: What about just finding the ratio between the numbers in the tables SUMMARY and AUDITOCC? Hans Chr. On Wed, Oct 12, 2011 at 2:53 PM, Ehresman,David E. deehr

Re: Can a TSM server admin purloin client backups?

2011-10-25 Thread Hans Christian Riksheim
I think the real problem is not with the administrator. The real problem is that an owner of client A can restore data from client B only by knowing the TSM admin password. Think many customers hooked up to the same TSM server. And how often is that particular password changed in a lib/config

Re: When hours become seconds

2011-11-02 Thread Hans Christian Riksheim
Yes, this was finally fixed for the UNIX platforms in 6.2.3. This update was released just in time for me when I had to format 40 TB of disk/file on a new server. Would have taken a week otherwise. I guess it does the same as on the windows platform so no need to write zeros on all blocks on

Windows 6.3 client install problem

2011-11-03 Thread Hans Christian Riksheim
Hi, anybody else having trouble installing the 6.3 x64 client? Getting MSVC100.DLL missing when I try to start it. Win2008 R2. Hans Chr.

Re: Windows 6.3 client install problem

2011-11-03 Thread Hans Christian Riksheim
installed it on Win 2008 R2 without issue. Started the GUI fine, scheduled backup ran last night. Harold Vandeventer -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans Christian Riksheim

Re: Migrating from AIX to Linux (again)

2011-11-16 Thread Hans Christian Riksheim
I am not of any help here but you say you are moving to Linux because it is cheaper. Our Power servers running TSM accounts for less than 3% of the yearly total cost for our backup infrastructure. Then we include licenses and man hours in addition to hardware and data center costs(floor space,

Collocaton by group

2011-11-30 Thread Hans Christian Riksheim
By default a stgpool has Collocaton=group. Does that mean it does no collocation if no collocaton groups are defined? Or does it collocate by node? We have a stgpool with collocaton=group but no collocaton groups defined and tape utilization is very low. Should we set collocation=no? Hans Chr.

Re: Collocaton by group

2011-11-30 Thread Hans Christian Riksheim
online. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans Christian Riksheim Sent: Wednesday, November 30, 2011 11:23 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Collocaton by group By default a stgpool has Collocaton=group. Does

Re: Collocaton by group

2011-11-30 Thread Hans Christian Riksheim
On Wed, Nov 30, 2011 at 8:16 PM, Allen S. Rout a...@ufl.edu wrote: How many tapes do you have? Now envision _all_ of them being mounted for any restore, even a relatively small one.  That's the end state of colloc=no: to a first approximation, every node, every filespace, every directory, is

Re: Collocaton by group

2011-12-07 Thread Hans Christian Riksheim
On Wed, Nov 30, 2011 at 6:43 PM, Ehresman,David E. deehr...@louisville.edu wrote: You could make two stgpools, one collo and the other not. Thanks, I think that is a good idea so we have made one collopool per TSM server for select clients. At least as a temporary solution until we decide on our

Mix tape and disk on the same HBA port

2012-01-24 Thread Hans Christian Riksheim
I usually separate disk and tape but now I have a customer with a very small system and another two port HBA for a small Power-server does not come cheap. So I am wondering if this rule still holds true or is it something for Mythbusters to take care of? What are the consequences of mixing them?

Re: Be Aware: TSM 6.2.3 AIX 7 TL2 FP2 don't mix

2012-01-31 Thread Hans Christian Riksheim
What to expect when we have products from two totally different companies. Thanks for the tip! Hans Chr. On Tue, Jan 31, 2012 at 2:54 PM, Ehresman,David E. deehr...@louisville.edu wrote: Oscar, Before you upgrade TSM or AIX, check out the level of bos.mp64 and bos.iocp.rte.  They need to

Journal backup

2012-02-08 Thread Hans Christian Riksheim
Is it still a requirement that an incremental -nojournal backup should be run once in a while to pick up the pieces left from the daily journal backup? In which case if I run a -nojournal every week, what I can tell the customer what the expected RPO is? One week? One day if lucky? Regards,

Cleaning up after library manager issues

2012-02-20 Thread Hans Christian Riksheim
Hi, once in a while the network connecting the library manager with the clients goes down and often this means we have to do a synchronization(audit). Any tricks out there so we won't have to dismount and shut down everything to do an audit? Any way to make the library manager function more

Re: Admin Center Issues

2012-06-25 Thread Hans Christian Riksheim
Admin Center is slow, the interface is clunky and annoying, the look and feel is anything but modern and it is riddled with bugs and dependencies to browser versions etc. Last time I tried it was 6.2 on a brand new two socket HP DL380 with 48GB of RAM. Slow. 7 years of development and still in a

Occupancy for each platform type

2012-08-20 Thread Hans Christian Riksheim
Hi, in the old days I could keep track of the total BACKUP_MB for each platform, how much was Oracle, Exchange, SQL and so on by looking at PLATFORM_NAME. But with VSS and proxy backup of Exchange these Exchange-nodes have platform_name=WinNT and not 'TDP MSExchg'. Any tip? I could of course go

Re: Occupancy for each platform type

2012-08-26 Thread Hans Christian Riksheim
, I used to back up Exchange data under a different nodename from the OS data, e.g. node1 and node1_exc. Could you use nodename patterns to help with your reporting? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans Christian Riksheim

Mix PVU and Terabyte licensing

2012-12-04 Thread Hans Christian Riksheim
We are on a volume licensing scheme but we are considering PVU licensing for a new project since the volume/CPU ratio there is very high. As I understand we can do this as long as the two different environments are separate. I haven't yet got a definitive answer on what IBM means by separate

Re: Calculate PVUs for NDMP-backups

2012-12-11 Thread Hans Christian Riksheim
, Remco Post r.p...@plcs.nl wrote: On 4 dec. 2012, at 12:01, Hans Christian Riksheim bull...@gmail.com wrote: What should one use to calculate the needed PVUs for NDMP backups? Type and #cores in the NAS box? yes. Regards Hans Chr. -- Met vriendelijke groeten/Kind Regards

Re: Mix PVU and Terabyte licensing

2012-12-11 Thread Hans Christian Riksheim
. Regards, - Bent -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans Christian Riksheim Sent: Tuesday, December 04, 2012 11:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Mix PVU and Terabyte licensing We

Re: Calculate PVUs for NDMP-backups

2012-12-11 Thread Hans Christian Riksheim
cores in the NAS. You need to have the PVU licenses for these cores too. Regards, Maurice van 't Loo http://mvantloo.nl/ 2012/12/11 Hans Christian Riksheim bull...@gmail.com I have asked around and it seems that TSM only needs a license for those nodes that have TSM software installed

Re: TSM for VE 6.4 Questions/Recommendations

2013-01-25 Thread Hans Christian Riksheim
Hi, good tips. Any way of excluding backup of those machines that are not running(guestState: notRunning) with any rule? Regards, Hans Chr. On Wed, Jan 23, 2013 at 4:20 PM, Arbogast, Warren K warbo...@indiana.eduwrote: Hi Ken, We have been using TSMVE 6.4 for a couple months, I

State of TSM Reporting

2013-04-04 Thread Hans Christian Riksheim
Hi. we are going away from perl and want to install a reporting feature for our TSM servers. What is the current state of TSM Reporting? I got burned the last time I touched this but that was some years ago. Is it of acceptable quality today or is something new and better around the corner? Or

Re: Script for automated config of TDP for MSSQL (fcm based)

2013-04-21 Thread Hans Christian Riksheim
It seems that C:\Program Files\Tivoli\tsm\TDPExchange is not populated before one has run through the wizard, which creates a lot of useless services that I need to remove afterwards anyway. Please IBM, let us have the option to choose whether we want to run this wizard or not. Hans Chr. On

TSM Client Solaris 11.1 and local zones

2013-05-02 Thread Hans Christian Riksheim
Hi. With Solaris 10 we installed the TSM client in global zone and it was accessible in the local zones. With Solaris 11.1 /opt is not found in the local zones and the symlink from /usr/bin is also missing. Anyone has any tip here before we try to hack it together? Regards, Hans Chr.

Re: TSM Client Solaris 11.1 and local zones

2013-05-22 Thread Hans Christian Riksheim
with Global zone,that's why you are unable to see the /opt in the local zones as the tsm client packages not yet installed on local zones. Regards, Gopi On Thu, May 2, 2013 at 1:24 PM, Hans Christian Riksheim bull...@gmail.comwrote: Hi. With Solaris 10 we installed the TSM client in global

Which files have I restored

2013-07-08 Thread Hans Christian Riksheim
This may sound like a dumb question. I did a file system restore with replace=no. Of about 20 000 files, 2333 were restored. Total number of objects restored: 2,333 Total number of objects failed: 0 Total number of bytes transferred: 832.31 MB Data transfer time:

Re: Which files have I restored

2013-07-08 Thread Hans Christian Riksheim
Manager ADSM-L@vm.marist.edu wrote on 2013-07-08 06:43:37: From: Hans Christian Riksheim bull...@gmail.com To: ADSM-L@vm.marist.edu, Date: 2013-07-08 06:44 Subject: Which files have I restored Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu This may sound like a dumb question. I did

ibm.com rant

2013-07-21 Thread Hans Christian Riksheim
Hi IBM! I know this new World Wide Web thing is hard and I can understand that you have problems constructing a web site that is possible to navigate without being a puzzle master, not so slow that one gets the impression that it is trained monkeys serving the web pages and with links that work

Manual or redbook for TDP for MSSQL

2013-09-02 Thread Hans Christian Riksheim
Hi, anyone know if there is a manual or redbook for configuring TDP for MSQQL 2012. I find the section on manual install in the information center confusing. Regards, Hans Chr.

Re: How to track transaction stats for TSMVE backups?

2013-09-27 Thread Hans Christian Riksheim
We also see a high change rate and we think the reason for that is the Windows pagefile. Some trickery to exclude that would be welcome but since this is block based I guess it is not possible. Hans Chr. On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon erwann.si...@free.fr wrote: See that page

Clear DB2-logs

2013-10-03 Thread Hans Christian Riksheim
If I understand correctly there is no way of getting rid of the logs without doing a full dbbackup. Is this a DB2 deficiency or is it TSM(--RFE)? Reason I ask is that when logs are filling up when expiring unnormal amounts of data, automatic dbbackup does not finish in time. Which again is due to

Re: Clear DB2-logs

2013-10-03 Thread Hans Christian Riksheim
multistream db backs to reduce db backup time? Op 3 okt. 2013 16:39 schreef Hans Christian Riksheim bull...@gmail.com : If I understand correctly there is no way of getting rid of the logs without doing a full dbbackup. Is this a DB2 deficiency or is it TSM(--RFE)? Reason I ask

how is memoryefficient diskcachemethod supposed to work

2013-10-14 Thread Hans Christian Riksheim
We have a memory starved Windows 2003 server and incremental fails with ANS1030E The operating system refused a TSM request for memory allocation. So we try memoryefficient diskcachemethod. What we see is that dsmc reports diskcachemethod is in use for all filesystems. We also see that the

Uninstall of TSM Operations Center

2013-11-07 Thread Hans Christian Riksheim
Hi, I have just tried TSM Operations Center and then uninstalled it from a Windows box. However how do I remove the repositories this product has left behind on our TSM servers? Or did the uninstall job do this behind the scenes? Regards, Hans Chr.

Re: Uninstall of TSM Operations Center

2013-11-08 Thread Hans Christian Riksheim
Thanks! Hans Chr. On Fri, Nov 8, 2013 at 11:48 AM, Neil Schofield neil.schofi...@yorkshirewater.co.uk wrote: Hans I think most of the information you're looking for is here: http://www-01.ibm.com/support/docview.wss?uid=swg21651364 Regards Neil Neil Schofield Infrastructure

Exclude client disk and TSM stgpools in performance testing

2013-11-14 Thread Hans Christian Riksheim
Hi! When we have performance problems with backups there is always a lot of finger pointing. Disk/network/TSM is to blame dependant on which group you belong to. What I would like to do is to use the TSM client-server infrastructure to test performance but exclude from the equation any disk

TDP for SQL 7.1

2014-01-14 Thread Hans Christian Riksheim
Hi, can anyone be so kind to point me in the direction of the documentation of this product. Trying to understand the basics of backing up a alwayson cluster and the information center is of little help. Thanks. Hans Chr.

Re: TDP for SQL 7.1

2014-01-14 Thread Hans Christian Riksheim
27703 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 01/14/2014 07:52:59 AM: Hans Christian Riksheim bull...@gmail.com Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 01/14/2014 07:52 AM

Re: TDP for SQL 7.1

2014-01-14 Thread Hans Christian Riksheim
09:39:05 AM: Hans Christian Riksheim bull...@gmail.com Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 01/14/2014 09:39 AM Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To ADSM-L@vm.marist.edu, cc Subject Re: [ADSM-L] TDP for SQL 7.1

TSM 7.1 Silent install

2014-02-07 Thread Hans Christian Riksheim
I can not get silent install to work. with the 7.1 BA client for Windows. When I look into the information center for 7.1, the procedure is exactly the same as for version 6 although the paths after unpacking the 7.1 client is vastly different from unpacking version 6. Is the procedure in the

Re: Exchange 2010 backup performance

2014-02-10 Thread Hans Christian Riksheim
In my experience there is nothing wrong with the TCP stack in Windows. Especially Windows2008R2 performs very well. For a single stream from a 2008R2 client (dsm sel big file of zeroes) to an AIX TSM-server 500km away over 10Gig directly to LTO5 has a speed of around 200MB/ at our setup.

Re: Exchange 2010 backup performance

2014-02-12 Thread Hans Christian Riksheim
] On Behalf Of Hans Christian Riksheim Sent: Monday, February 10, 2014 9:04 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Exchange 2010 backup performance In my experience there is nothing wrong with the TCP stack in Windows. Especially Windows2008R2 performs very well. For a single stream from

Re: TSM 7.1 Silent install

2014-02-20 Thread Hans Christian Riksheim
-35ca-4324-bbc6-ba5db9072dae} x64: TSMCLI_WIN\tsmcli\x64\client\Disk1\ISSetupPrerequisites\{7f66a156-bc3b-479d-9703-65db354235cd Hans Chr. On Fri, Feb 7, 2014 at 2:25 PM, Hans Christian Riksheim bull...@gmail.comwrote: I can not get silent install to work. with the 7.1 BA client for Windows

Re: Redbooks for TSM 6.X or 7.X

2014-03-25 Thread Hans Christian Riksheim
It seems IBM has halted the production of TSM redbooks. Also the Certification guides and Technical guides exist no more for the newer versions. The reason for this is that TSM in the recent years has become so easy, intuitive and self explanatory. That was a joke. Hans Chr. Riksheim On Tue,

TDP for Exchange error code

2014-04-03 Thread Hans Christian Riksheim
I use 7.1. With /PREFERDAGPASSIVE set it correctly skips the mailboxes on the active node but the return code is 1829. Could this safely be ignored that is if the backup command has RC=1829 I can force the script to return with RC=0? Another thing, should /PREFERDAGPASSIVE not be used when doing

SQL-backup with no config file

2014-06-02 Thread Hans Christian Riksheim
I noticed that if someone(usually a DBA) accidentally renames or deletes a tdpsql_.cfg file the command still runs and just uses the default config. it will return with no errors. Example: Someone has deleted a configfile which points to a specific instance. tdpsqlc backup * full

Re: SQL-backup with no config file

2014-06-05 Thread Hans Christian Riksheim
@vm.marist.edu wrote on 06/02/2014 07:50:08 AM: From: Hans Christian Riksheim bull...@gmail.com To: ADSM-L@vm.marist.edu Date: 06/02/2014 07:51 AM Subject: [ADSM-L] SQL-backup with no config file Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu I noticed that if someone(usually

Re: Restoration Issue in TSM 5.5...

2014-06-10 Thread Hans Christian Riksheim
My advice is to not use the GUI. Until IBM eventually decides to make a working GUI there should be a big red warning stating that if you are going to restore more than a few files the CLI must be used. (And not even then can the GUI be trusted [1] ) I experienced the same as you. Used the GUI

Re: SQL-backup with no config file

2014-06-10 Thread Hans Christian Riksheim
ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 06/05/2014 05:45:50 AM: From: Hans Christian Riksheim bull...@gmail.com To: ADSM-L@vm.marist.edu Date: 06/05/2014 05:46 AM Subject: Re: SQL-backup with no config file Sent by: ADSM

Re: Exchange and client compression

2014-06-27 Thread Hans Christian Riksheim
I also wonder about the integrity checker. With DAG isn't the integrity guranteed if replication is working fine and thus integrity check in TSM can be skipped? Regards, Hans Chr. On Fri, Jun 27, 2014 at 7:08 AM, Steven Harris st...@stevenharris.info wrote: Hi All I'm working on a backup

TSM BA installer rant

2014-07-04 Thread Hans Christian Riksheim
As many has experienced the 7.1 BA client for Windows not only requires a reboot, it will in the middle of the install reboot right into your face without any warning or prompt. On top of this it will do so despite you telling it not to. The same goes for the TDP SQL client btw. Cause is some C++

Re: TSM BA installer rant

2014-08-07 Thread Hans Christian Riksheim
random guesses or no replies at all.” - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans Christian Riksheim Sent: Friday, July 04, 2014 7:55 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM BA installer rant As many

  1   2   >