DB2 restore question

Gents, Is there any information on the detail which is returned from a 'list history'? I'm attempting to document the restore of a TPC DB2 database, but my results are different from the manuals. My query is about the Comment field - the manual indicates that the comment field is used to

5.4 AIX API client install oddities

Hi, I'm experiencing some strange inconsistencies when trying to install the 5.4.3.3 API client on AIX 5.3 LPARS in a P550 where I'm trying to backup a TPC DB2 database. On some instances the /usr/tivoli/tsm/client/ba/bin64 directory is created, and on these machines the documented process res

WysDM/DPA TSM queries

Hi, Does anyone here use DPA? Trying to get to grips with it but it's not obvious.. I'd like to query the libvolumes table to determine scratch levels (just to begin with) but I can't see how to do it. Any help greatly appreciated. Cheers, Matthew Matthew Large Group IT Service D

ANR9999D Too many links followed for

The Drive path was initially offline, so I issued the UPD PATH with the same parameters as below, and got 'Unable to find path to match serial number for drive PTL_DRIVE_1 in library ', so I ran the same command with AUTODETECT=YES, and got the same result. Then deleted the path, issued the define

Re: Looooooooooong distance backups

I came across an article in the symposium archives which discussed long distanced backups, though it might have been only a couple of thousand miles.. I'll see if I can find it when I get some time. -- Matthew Large TSM Consultant -Original Message- From: ADSM: Dist Stor Manager [mailt

Re: Is 'Cache Migrate Files' immediate?

I thought I'd summarize the problem I had and how it was resolved. Problem: Diskpool is at 100% Util with 0% migratable, MigDelay=0, MigCont=yes, CacheMigFiles=no. Updating stgpool hi/lo threshold to 0 or issuing 'migrate stgpool' command results in ANR4972i "migration is not needed for the stor

Quantum VTL not returning tapes to scratch?

To any other Quantum DXi5500/3500 users: TSM seems unable to return expired dbbackups and tapes whose data has been 'move data'd off to scratch - we have to check them out and in again with a label overwrite=yes. This doesn't seem right, so I'm wondering if all other Quantum VTL users experience

Re: Is 'Cache Migrate Files' immediate?

Interesting - no results from that Q OCC. That would say to me that there are no references for any files, from any client, in that pool. Where is the 100% Util worked out? -- Matthew Large TSM Consultant -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On B

Re: Is 'Cache Migrate Files' immediate?

All online: Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status --- -- - - /tsmdata/server/stg/dir- D_DIR_UTLDISK

Re: Is 'Cache Migrate Files' immediate?

-L] Is 'Cache Migrate Files' immediate? On Mar 13, 2008, at 8:26 AM, Large, Matthew : Barclays Wealth wrote: > If that's the case, then I can understand why these files might not > migrate, > but if not, how on earth do I clear this disk? What is your MIGContinue set

Re: Is 'Cache Migrate Files' immediate?

e Migrate Files' immediate? Is it %util, or %migr that is 100%? If caching is on, % util will always be high around 100% and the % migratable is the actual utilisation by unmigrated data. Ian Smith - Forwarded by Ian-IT Smith/ext/dbcom on 13/03/2008 12:11 ----- "Large, Matthew :

Is 'Cache Migrate Files' immediate?

I have a diskpool at 100% and attempts to migrate the data to its Next Pool are failing saying that there is nothing to migrate. Setting 'Cache migrated Files' to NO from YES should, in my book, enable the migration to start, but it's not - I'm getting ANR4972i "migration is not needed for the stor

Re: Adding Encrypted stgpool

Just to summarize the answer from the technote page.. 'Data is encrypted during WRITE operations, when the encryption key is passed from the server to the drive. Data is decrypted on READ operations.' I will not need to relabel the volumes since the label is not encrypted, just data written in th

Adding Encrypted stgpool

Fellows, We have a Scalar library with LTO4 which was initially configured with the TSM device drivers; in order to utilize the drive level encryption function we have had to move data to a vtl, delete the devs in TSM, install the IBM device drivers (to support drive level encryption) on Sol10 and

Re: Win32 client won't start

ext=SSGSG7&dc=DB520&dc=DB 560&uid=swg21296891&loc=en_US&cs=UTF-8&lang=en&rss=ct663tivoli Harry "Large, Matthew : Barclays Wealth" <[EMAIL PROTECTED]> wrote: Hi Harry, Absolutely, one of the first things I check! That's why I ran the trace, I just co

Re: Win32 client won't start

To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Win32 client won't start On Windows there is a tool called Process Explorer- it breaks down the svchost process and you can work out what sub service is taking all the CPU. "Large, Matthew : Barclays Wealth" <[EMAIL PROTECTED

Re: Win32 client won't start

able? correct permissions? Harry "Large, Matthew : Barclays Wealth" <[EMAIL PROTECTED]> wrote: I only ran the tracing for one execution (I've seen multiGB filesystems fill up quite quickly with traceflags active - haven't you ;) ) TaskManager shows svhost.exe eating 99% It&

Re: Win32 client won't start

tion is allowed under the Windows execution prevention tab- this can cause issues with java based applications. "Large, Matthew : Barclays Wealth" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 11/03/2008 11:46 Please respond to "ADSM: Dist Stor Manager&qu

Re: Win32 client won't start

Andy, I'm not getting much of a response from anything you mentioned, but I noticed the machine is running at 100% cpu constantly, so I'm guessing that might be causing this apparent 'hang'. Once I've eliminated that, I'll continue with your suggestions. Cheers, Matthew -Original Message---

Re: seemless migration to new schedule

Surely as long as you restart the scheduler, after the association has been made, to ask the server what the next schedule is, and check the dsmsched.log's last entries reflect what you expect, I can't see a problem. Server prompted schedules might behave differently but I rarely use them so I cou

Win32 client won't start

Hi ADSMers, I've not seen this kind of problem before - I have a Win32 client (5.4.1.0) which can ping it's Solaris10 TSM server (5.4.1.2), but fails to connect. Starting dsmc from the command line brings me no prompt, TSM appears to deliver nothing to the screen, or the dsmerror.log. So I ran a

mtlib - how many frames?

All, I've been digging around trying to find a command that will tell me how many D12's we've got attached to the library, with little success. Am I searching for something which does not exist? Thanks, Matthew Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 20

Informix LAN-free

TSMers, I'm not able to locate any information confirming backup of Informix DB's over the Storage Agent. Is anyone else doing this, and is it supported? Links to docs would be appreciated. Cheers, Matthew Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 90

Re: File scan takes ages during backup

>>21-03-2003 11:41:45 ANS1898I * Processed 599.000 files *<< Are you sure that figure isn't nearer six HUNDRED thousand? (600,000 in british money) Like bruce said, you might be better off with Journal Based backups. Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430

Re: Database page size?

tsm> q db f=d Available Space (MB): 4,000 Assigned Capacity (MB): 4,000 Maximum Extension (MB): 0 Maximum Reduction (MB): 2,032 >>>Page Size (bytes): 4,096<<< Total Usable Pages: 1,024,000 Used Pages: 501,832

Re: /VAR skipped during incremental

I'm sure /var is one of the directories TSM excludes by default (as is /tmp), and always has been. You will probably need to use an include/exclude list to include it in your backup. Although I could be wrong.. Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207

tsmjbbd.exe default location

All, I'm trying to design a Journal based backup solution, without ever having used it! no problem.. there's loads of docs, but none of them document where the tsmjbbd.exe file is installed. can someone who used the default settings please tell me where it resides as I need to place the tsmjbbd.i

Re: preschedulecmd problem

I don't wish to point out errors, but- on page 193 of TSM UNIX b/a 5.1: Command line: (Initial command line only) -preschedulecmd="quiesce database" what happens if you move the option into the dsm.opt file rather than have it as part of the command execution? Large Ma

Re: Procedures to follow after a drive with a stuck tape is repla ced -- 3584 library

tsm> help restore volume Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 -Original Message- From: Thach, Kevin [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:26 To: [EMAIL PROTECTED] Subject: Procedures to follow after a drive with a

Re: Activity Log

eExit Read it up in the manual.. Hope this helps Large Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 -Original Message- From: Robert L. Rippy [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 14:54 To: [EMAIL PROTECTED] Subject: Re: Activit

JournalDBSize

Guys/Gals, I have a customer who requires me to give an estimate of the space used, however rough, for the JournalDB on a filesystem with about 2 million files, and another with 5 million. I understand the actual size relates to the depth of the directory and the length of the directory/path names

Re: Study Guide for TSM

Lars, you could try this test exam (5.1 AND 4.2 for extra practise you'll see) http://www.tivoli.com/services/certification/exams/ I remember seeing the TSM study guide somewhere before - if I find it, I'll post it here. Regards, Matthew Matthew Large TSM Infrastructure Engineer Lavington Stree

Re: ADSMConnect Agent for Domino and 4.2 TSM Server

t it! TSM V4.2.1.15(Server) TSM V3.1.06 Client using Notes "OLD" connect agent backing up R5 Domino DBs. AIX 4.3.3 It works.... --- "Large, Matthew" <[EMAIL PROTECTED]> wrote: > Question: > > The documentation for the Connect Agent states that the agent needs ac

ADSMConnect Agent for Domino and 4.2 TSM Server

Question: The documentation for the Connect Agent states that the agent needs access to a Version 2 or 3 ADSM server. We're running 4.2.1.11 and I think it's unlikely these will work 'together', but this is just a supposition - I don't have any way of testing this. Does anyone have this old agent

ADSMConnect Agent for Domino 4.6

People with access to the IBM/Tivoli FTP site, I do not have the ability to browse the downloadable software (if it's currently available) and was hoping perhaps someone with a little time on their hands could find out if the old ConnectAgent for Domino R4 is available for download. It may not be

TDP in Extended Stored Procedures

ally I can't see why it shouldn't work, as long as all the environment variables are set. So I was just wondering if ANYONE else is doing anything REMOTELY like this? Does it work? What probelm did you have, if any? All answers gratefully received. Regards, Large Matthew Large TSM Inf

TDP for DB2 on AS/400

Chaps/Chapesses, I've been digging around trying to find one of these, with no success. I can't view the ftp servers to browse the directories, so perhaps one of you helpful chaps out there can answer my question. Does one exist? OR do we just use the standard backup commands from DB2 as one norm

Re: TDP for MS SQL

On page 37 of the 2.2 TDP for SQL you'll find your answer Regards, Matthew Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:JWholey@;EXCHANGE.ML.COM] Sent: 29 October 2002 16:18 To:

Re: Oracle and TDP issues

This page should answer some 'Does this support this' questions.. http://www1.ibmlink.ibm.com/cgi-bin/master?xh=7dxmCUAqShNLdC2USenGnN9332&req uest=announcements&parms=H%5f202%2d276&xfr=N Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 -Ori

TDP for Oracle manual for 2.1

All, We have TDP for Oracle 2.1.0.10 for our machines, and, with no chance to upgrade, I need to figure out how the old options are laid out. Does anyone know where I can find the manual for it? (2.1) I've looked here: http://www.tivoli.com/support/public/Prodman/public_manuals/td/TD_PROD_LIST. ht

Re: show logpinned

: Re: show logpinned :) it is 'show logpin', and my 4.2.2.10 server understands this perfectly. On dinsdag, oktober 15, 2002, at 02:53 , Large, Matthew wrote: > correction: > > the command is tsm> show log > > whatever is placed after the 'log' is ign

Standard Solaris Excludes

Hey all, I'm having difficulty planning a Solaris 2.8 exclude list - not sure what is ignored by TSM and what needs to be excluded. All suggestions welcome! Regards, Matthew Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 -

Re: show logpinned

correction: the command is tsm> show log whatever is placed after the 'log' is ignored. Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 -Original Message- From: Steve Roder [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:50 To: [EM

Re: Delete running schedule

perhaps cancelling the process then updating the schedule to 'inactive' beforehand might allow you to delete it. just a stab in the dark. Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 -Original Message- From: Rupp Thomas (Illwerke) [mai

ITSM Conference call

All, I spotted an interesting conference call happening this afternoon in the US on a Tivoli or IBM website, but I closed the window and now it's lost forever. It's ITSM related, possibly even ITSRM. I don't suppose anyone's on the call at the moment and would like to send me the call back number

Re: Systemobjects on WIN2K

Hi Niklas, Excerpt from TSM 5.1 BA guide for Windows.. DOMain all-local Backs up all local hard drives. For Windows 2000, XP: The systemobject domain is included in all-local processing. This is the default. domain Define

Re: DB Best Practises ?

Hi Riaan, Welcome to our 'world'... your short list covers the essentials, although the extra TSM snapshot I would deem unnecessary. I'll let a. n. other bod(s) chat about other approaches.. You cannot load in a tape and expect TSM to read it and know what to do with it. The TSM database tracks

Re: Question about Microsoft Data Engine

Greg, I found this page http://www.lyris.com/lm_help/6.0/Backing_Up_MSDE.html which talks about copying two files out while the SQL server service manager is offline. "Copy the "ListManager.mdf" and "ListManager_log.ldf" files to your backup location" and back them up with the standard B/A clie

Re: Help-new mgmt class for existing node: how to make this work?

Ken, You're on the right track here.. just missing the fact that you need to register the Oracle node (for example _ORA) in the new domain. Once you've done this, you effectively have two TSM nodes. One for your new Oracle node and one for the OS and the rest. You should be aware that the TSM se

adsm.org

I'd just like to show my gratitude to the owners of adsm.org. It spent sometime in surgery and now has a pretty face as well as useful guts ;) thanks and Regards Matthew Large TSM Infrastructure Engineer Lavington Street Int: 7430 4995 Ext: +44 207 902 4995 ---

WIN2000 size again

All, As a follow up to my last "how big is a W2000 professional install" question (and I thank you for your responses) can I now ask how many files are there on a fresh W2000 Professional install? forgive me for these mind-numbing questions - I have no kit to examine. Regards Matthew Large TSM

W2000 install size

Quite simple really, I have no boxes to examine, so I was wondering if perhaps some of you friendly guys on this list might be able to answer my question. how big is a W2000 professional install? I need this for sizing.. Cheers all. Matthew Large TSM Infrastructure Engineer Lavington Street In

Re: Moving Stgpools question

Correction: Move data works on both primary and copy storage pools, but it will only move the data to a pool in the same position in the storage hierarchy. ie primary pool to primary pool, copy pool to copy pool. just my fraction of a euro.. Matthew Large TSM Infrastructure Engineer Lavington S

Re: tsm client is down-level with this server version

Remco, I can understand IBM's desire not to have the most potentially dangerous commands available to everyone. I'm not sure they'd be too happy being expected to fix a problem that was actually created by a customers mistake(s) with these commands. Try and think about it from their point-of-view

Re: Simple Archiving question

Farren, BACKUPSETS take an image from the files the server currently has active for that client. You could use the -del option on the archive command ** Deletefiles Use the deletefiles option with the archive command to del

Re: Backupset of HSM data

Lars, The Export NODE function would seem to fit your requirements. tsm> exp no devc=3570dev usedv= A variety of FILEDATA options includes exporting ONLY the space managed files, so we would assume that by selecting FILEDATA=ALL, that would include the space managed files. Hope this helps..

Re: WIN2K-Complete-Restore

I just discovered a 'Technical Document' on the Redbooks site. http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65 f/a54d17d3ba92d77f85256bb2006678fe?OpenDocument&Highlight=0,2000 Chapter 11 maybe of interest to you Part 1. Disaster Recovery Planning Chapter 1. Introduct

Re: Restore backupset take very long

Miguel, >From what I remember, V5 backupset processing is vastly improved. >From 51 Tech Guide: 'Performance for using backup sets has been improved by optimization of device block sizes. Backup sets on portable media were introduced in client Version 3.7. The Tivoli Storage Manager V5.1 client