Re: SQL statement

Hi Andy! Thank you very much for this query, it shows enough information to satisfy the requesting department. Thanks!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 18:29 To: [E

Monthly TSM FAQ January 2004

This Frequently Asked Question list for the ADSM-L mailing list is posted on the first day of each month. It was created to cut down on the number of questions that are repeated regularly in the ADSM-L mailing list from vm.marist.edu. I would be grateful for any requests to include additional mater

TSM 5.2.x issue since upgrade

Upgraded my AIX TSM server to AIX 5.1 and TSM 5.2.1.3, about 3-weeks ago. I get an email from a user about the TSM server not responding, during the holidays. I checked the server Activity Log and here is what I found for the time frame in question: 01/02/04 01:33:24 ANR0403I Session 12878 ended

TDP for SQL problem ACO5091E or ACO5422E

Hi All, I have a strange problem with TDP for MS-SQL 5.2.1.0 (running on TSM Server 5.2.1.3 on Windows 2003 Server). When I put CLUSTERNode yes in the DSM.OPT I get error ACO5091E, which basically tells me that I'm using PASSWORDACCESS GENERATE but there is no password (how come that the normal B

Re: TDP for SQL problem ACO5091E or ACO5422E

I believe that for clusters you need to specify the /SQLSERVER= parameter of the virtual SQL server name in the cluster. The default is to logon to the "local" instance, which on a cluster there isn't one. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMA

Re: Upgrading to 5.2.2

Happy New Year Len, I need to upgrade itsm 4.2.1 to itsm 5.2 also. My environment is AIX 5.1. I thought I have to upgrade itsm to 5.1 first to handle the window system objects problem. So you don't need to do this first? Have you ever done a restore on the itsm database? I need to w

Re: TDP for SQL problem ACO5091E or ACO5422E

We use the /sqlserver parameter. The complete command we use is: tdpsqlc backup PRD full /tsmoptfile=dsm.opt /config=tdpsql.cfg Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant ___

Re: TDP for SQL problem ACO5091E or ACO5422E

Richard, ACO5091E also is displayed when the password stored is not correct. Try this: 1. Add "CLUSTERNODE YES" to the DSM.OPT file. 2. Reset the password on the TSM Server for the node you are using for DP for SQL. 3. Issue a command that connects to the TSM Server specifying the /TSMPASSWO

Re: TDP for SQL log backup

Hi Joe, Did you get this straightened out yet? The data to back up is sent from the SQL server to Data Protection for SQL. And so, Data Protection for SQL does not "decide" what data to back up. The SQL Server determines this. It is strange that the SQL Enterprise Manager backup tool is acting dif

Space reclamation running since 23Dec2003

Hi TSM'ers, here a sequence of what had happened with a TSM-SERVER 5.1.8.1 on an IBM H70 under AIX 4.3.3-11 and 6 months old 3584-LTO2 library with 4 drives 1. SPACE RECLAMATION started as follows: 23.12.2003 03:16:14 ANR1040I Space reclamation started for volume 373ABW, storage pool LTO_E

TSM and NETWARE 6.5

My users have recently upgraded to Novell 6.5 on many of the Novel serves and they are having problems with the backups failing to complete We are running TSM 5.2.13 on an AIX 5.1 server Is there a problem with NETWARE 6.5 and TSM at this level thanks for your help Bill William Fitzgerald

Re: Space reclamation running since 23Dec2003

Looks like there is probably some data that is lost on that tape, unless you have a copy storage pool... To get around that you will want to take the recl up to 100 to pause reclamation, then if you have a copy storage pool, and this tape is in the primary pool mark the volume destroy

Re: TSM and NETWARE 6.5

Have you tried the 5.2.2.0 client ? I just pulled them and they list Netware 6.5 as supported while 5.2.1.x does not ! Go here: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintenance/client/v5r2/Netware/v522/ Bill Fitzgerald <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Sto

update to 5.1 to 5.2 TSM server

is there any docs on the upgrade to 5.1 to 5.2 server and cleints Roland Priest email [EMAIL PROTECTED] office 856-486-4255 office 1800-767-5822 ext.4255 Cell 856-296-6086

Re: update to 5.1 to 5.2 TSM server

Yes. There are readme files associated with both server and client. Please consult the monthly TSM FAQ (which was posted this morning, BTW). -- Mark Stapleton ([EMAIL PROTECTED]) -Original Message- From: Roland Priest [mailto:[EMAIL PROTECTED] Sent: Mon 1/5/2

Re: TSM and NETWARE 6.5

There is a beta SMS patch you have to install. Here is the link. http://support.novell.com/cgi-bin/search/searchtid.cgi?/2967135.htm And you need to make sure you are running the 5.2.2 client since that is the only one IBM supports with Netware 6.5. Julian Armendariz System Engineer - UNIX H

IBM3582 library and vaulting

Anyone out there using the IBM 3582 LTO library?? How are you doing vaulting? Getting tapes into and out of the library? I'm getting ready to start a contract with this hardware and using Autovault. Bill Boyer "Some days you are the bug, some days you are the windshield." - ??

List all tapes, highlighting those in library.

Has anybody got an SQL, that can list all VOLUMES, and highlight (either showing the element number or something) those that are in the library? This report would be useful to see quickly if a list of tapes are already in the library - or which tapes in the list are not and need to be checked in.

Re: List all tapes, highlighting those in library.

Hot Diggety! Deon George was rumored to have written: > Has anybody got an SQL, that can list all VOLUMES, and highlight (either > showing the element number or something) those that are in the library? > > This report would be useful to see quickly if a list of tapes are already > in the library -

moving a primary sequential access storage pool to another library

Is it possible to move a primary sequential access storage pool from one library to another library with out having to copy the data? If so, how? I need to move my primary sequential access storage pools from one library to another. If I could update the device class name for the storage pool my

Unload/LoadDB question

System Info: Solaris 8 Sun E4500 w/ 4 processors & 4GB RAM TSM 5.1.8.1 TSM DB 119GB (37.1% utilized) I tried shrinking the DB down to 85GB and at 100GB, ran into the "your outta SQL table space" message. Guess it's time for an unloaddb/loaddb. Any ideas at all how long I can expect t

Re: Unload/LoadDB question

Another way to do it is live. If your utilization is that low AND you have the DB spread over many volumes, say 10GB in size. Then do a "reduce DB 1", takes generally less than a minute. Then delete one of the dbvols that is that size. (delete it's mirrors first). Any data on the volume is

Taking an end-of-year snapshot

All, We are running TSM 5.1.6.1 on AIX 5.1 What I want to do is to take an snapshot of our TSM data as it was at end of year 1/1/04 and archive it away for 10 years. Is this possible? I haven't found a way of doing it. We need to make an end-of-year archive each year for legal etc purposes. Ru

Re: Unload/LoadDB question

This was actually the first thing I tried. The DB was originally 177GB and 20% utilized. I reduced the DB by 50GB and then deleted volumes and mirrors. I tried to shrink it again by another 35-40GB's, but it complained saying that it could not be reduced by that much, that there was not enoug

Library upgrade 3583 -> 3584

Hi there, Recently we bought an 3584 library to replace our 3583 library. The 3583 library is LTO1 SCSI-attached, the 3584 is all LTO2 fiber-attached. I have already connected the 3584 to the AIX machine that is our TSM server, and made the library and drives available to TSM. I have checked in (a