Re: TSM Accounting
==> On Thu, 12 May 2005 11:30:14 -0500, Rob Hefty <[EMAIL PROTECTED]> said: > Hello all, > > After flipping through manuals I stumbled upon this option and I am > curious how many other admins were using it and what > benefits\ramifications it may present? Is it an option usually left > turned "on" or is this used only as a troubleshooting device? Use it all the time: it's some of the most detailed data you're going to get on session-by-session performance. Easy to parse, too. ;) - Allen S. Rout
Re: 2 Media Changer
What an excellent answer, the library is partioned for sure. My question is: how do I know which media changer I should use for configuration on TSM Server? tapeutil -f /dev/smc0 elementinfo Getting element information... Number of Robots .. 2 First Robot Address ... 1 Number of Slots ... 879 First Slot Address 1025 Number of Import/Exports .. 30 First Import/Export Address ... 769 Number of Drives .. 32 First Drive Address ... 257 tapeutil -f /dev/smc1 elementinfo Getting element information... Number of Robots .. 2 First Robot Address ... 1 Number of Slots ... 968 First Slot Address 1904 Number of Import/Exports .. 30 First Import/Export Address ... 769 Number of Drives .. 16 First Drive Address ... 289 On 5/12/05, Sung Y Lee <[EMAIL PROTECTED]> wrote: > Assuming that configured correctly, I can think of 2, maybe 3rd reasons why > you would see smc0 and smc1 from the OS. > > 1)3584 library is partitioned. > > One can check by issuing for AIX. > tapeutil -f /dev/smc0 elementinfo > tapeutil -f /dev/smc1 elementinfo > > If command returns same values, then smc0 and smc1 are pointing to the same > changer physically this one library > if command returns different values, then the library has been partitioned > > 2)3584 multi-path architecture without automatic control path failover > configured > > If you have two partitioned library then in TSM server you can define two > media changers or two libraries. > If you have only one partiioned library regardless of multi or single path > architecture you can only define one media changer or one library. > > 3)SAN Zoning > > > > Will TSM automatically use the second Media Changer? > > > Yes, assuming you have 3584 with multi-path architechure, if configured > correctly, the TSM will automatically use the second media changer. > There are many configuration, right version of TSM server which need to be > taken care of before automatic failover will work. > > Here's a link to a very good redbook titled Implementing IBM tape in UNIX > Systems that describes multi path/libraries/setup for automatic > failover/SAN zoning. > > http://www.redbooks.ibm.com/abstracts/sg246502.html?Open > > Sung Y. Lee > > "ADSM: Dist Stor Manager" wrote on 05/12/2005 > 10:52:27 AM: > > > I just checked one of TSM Server, it has 2 Media Changer: > > > > smc0 Available 0D-08-02 IBM 3584 Library Medium Changer (FCP) > > smc1 Available 0H-08-02 IBM 3584 Library Medium Changer (FCP) > > > > From TSM Server, it only defines one Media Changer: > > DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY > > DEVICE=/dev/smc1 ONLINE=YES > > > > My question is: > > If only define 1 Media Changer, TSM Server can't use the second Media > > Changer, then why does it need 2 Media Changer? If it define the > > second Media Changer as following: > > > > DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY > > DEVICE=/dev/smc0 ONLINE=YES > > > > Will TSM automatically use the second Media Changer? > > > > TIA >
Re: Restoring Netware File System Data to Windows 2000?
Thats only partially true. Restoring Unix file system data to another flavor of unix works. Restoring different flavors of windows to one another typically works too. On 5/11/05, Stapleton, Mark <[EMAIL PROTECTED]> wrote: > As is stated in the list's FAQ, you cannot restore one OS's files onto > another OS. > > -- > Mark Stapleton ([EMAIL PROTECTED]) > IBM Certified Advanced Deployment Professional > Tivoli Storage Management Solutions 2005 > Office 262.521.5627 > > >-Original Message- > >From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > >Behalf Of Gerald > >Sent: Wednesday, May 11, 2005 5:11 PM > >To: ADSM-L@VM.MARIST.EDU > >Subject: Restoring Netware File System Data to Windows 2000? > > > >Is it possible? > > > >My initial attempt says no.. I tried running the BA client 5.2.4, > >configured it to a node that was a backup of a netware file server, > >and couldn't get it to display any files such that i could select and > >restore them. > > > >That surprises me a bit since I figured both OS's are essentially DOS > >based - though I didn't try configuring a FAT32 file system. > > > >Thanks! > > > -- -Gerald
Re: 2 Media Changer
Assuming that configured correctly, I can think of 2, maybe 3rd reasons why you would see smc0 and smc1 from the OS. 1)3584 library is partitioned. One can check by issuing for AIX. tapeutil -f /dev/smc0 elementinfo tapeutil -f /dev/smc1 elementinfo If command returns same values, then smc0 and smc1 are pointing to the same changer physically this one library if command returns different values, then the library has been partitioned 2)3584 multi-path architecture without automatic control path failover configured If you have two partitioned library then in TSM server you can define two media changers or two libraries. If you have only one partiioned library regardless of multi or single path architecture you can only define one media changer or one library. 3)SAN Zoning > > Will TSM automatically use the second Media Changer? > Yes, assuming you have 3584 with multi-path architechure, if configured correctly, the TSM will automatically use the second media changer. There are many configuration, right version of TSM server which need to be taken care of before automatic failover will work. Here's a link to a very good redbook titled Implementing IBM tape in UNIX Systems that describes multi path/libraries/setup for automatic failover/SAN zoning. http://www.redbooks.ibm.com/abstracts/sg246502.html?Open Sung Y. Lee "ADSM: Dist Stor Manager" wrote on 05/12/2005 10:52:27 AM: > I just checked one of TSM Server, it has 2 Media Changer: > > smc0 Available 0D-08-02 IBM 3584 Library Medium Changer (FCP) > smc1 Available 0H-08-02 IBM 3584 Library Medium Changer (FCP) > > From TSM Server, it only defines one Media Changer: > DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY > DEVICE=/dev/smc1 ONLINE=YES > > My question is: > If only define 1 Media Changer, TSM Server can't use the second Media > Changer, then why does it need 2 Media Changer? If it define the > second Media Changer as following: > > DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY > DEVICE=/dev/smc0 ONLINE=YES > > Will TSM automatically use the second Media Changer? > > TIA
Re: TSM Accounting
We pull this in daily and append a SQL database - excellent for reports and trending. Definitely worth doing if you've got a few minutes to put it to good use. Luke Rob Hefty wrote: Hello all, After flipping through manuals I stumbled upon this option and I am curious how many other admins were using it and what benefits\ramifications it may present? Is it an option usually left turned "on" or is this used only as a troubleshooting device? Thanks, Rob
Re: TSM Accounting
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rob Hefty >After flipping through manuals I stumbled upon this option and I am >curious how many other admins were using it and what >benefits\ramifications it may present? Is it an option usually left >turned "on" or is this used only as a troubleshooting device? Yes! It's my favorite for tracking client backups/archives/restores etc. It contains information such as commwaits, and (the best use for me) it allows me to track trends. It can be dropped into a spreadsheet, which means you can make pretty pictures for the PHB to legitimate requests for additional resources. I turn it on for all the customers that will let me. -- Mark Stapleton ([EMAIL PROTECTED]) IBM Certified Advanced Deployment Professional Tivoli Storage Management Solutions 2005 Office 262.521.5627
TSM Accounting
Hello all, After flipping through manuals I stumbled upon this option and I am curious how many other admins were using it and what benefits\ramifications it may present? Is it an option usually left turned "on" or is this used only as a troubleshooting device? Thanks, Rob
Advice required for server\library upgrade
Hi all, I would really appreciate any help with the following: We currently have a Windows 2000 server running TSM server 5.2.2.4 (also using DRM) with a SCSI attached PV210 disk array for disk pools, and SCSI attached 3583 library with 4x SCSI LTO1 drives. We are planning to purchase new hardware for the server (dual processor, 2gb RAM, Windows server 2003, 2x local 146gb drives RAID1 for mirroring local OS and TSM db) and an ADIC i2000 library with 4x LTO2 tape drives (SCSI). We currently have no plans to upgrade to TSM server 5.3 and the reason for upgrade is primarily due to lack of storage capacity for onsite tape pools. We will also be retiring the PV210 disk array and configuring the disk pools to live on a huge SAN attached disk array (the library and TSM server will not be SAN attached). I have the following overall plan to migrate to the new setup and would appreciate any comments on whether I am heading in the right direction. Has anyone out there completed such an upgrade? Is there any documentation/papers/weblinks with info? Is it advisable to run mixed media or should we move all data from our LTO1 media to LTO2 bearing in mind we currently have a reasonable amount of LTO1 media (appx. 150 units)? 1. Build new TSM server. 2. Take a db backup of existing TSM server. 3. Attach new library and drives to existing TSM server and define new devclass for LTO2. Create new copy storage pool for LTO2. 4. Checkin/label LTO2 volumes. 5. Either: issue a backup command to backup existing tape pools to new tape pools (i.e. 'backup existing_tape_pool new_tape_pool'). 6. Or: Change 'next storage pool' for disk pools to point to new library and issue a 'move data' command on a volume-by-volume basis. This would move data from tape volumes back to disk pool and then: 7. Set migration threshold to 0/0 on disk pool to force migrations to new tape storage pool. 8. As existing tape volumes become empty set to READO or checkout. 9. Backup db, halt server, copy db to new TSM server. 10. Attach new library to new server and start TSM server on new box. 11. Redefine library, drives and paths. 12. Create new storage pools on SAN drive array and check mgmclass destinations. 13. Cross fingers. Any ideas what is missing? Our primary onsite pools currently look like this: Primary_Pool GB Files -- - --- ARCHIVE_TAPE0.407191 BACKUP_TAPE 1303.37 2846356 BACKUP_TAPE_COL 1170.64 2849721 DIR_FILE0.26 171262 DIR_POOL0.90 558979 EXCH_TAPE 715.56 315 Many thanks for any advice. This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Any views or opinions presented or expressed are those of the author(s) and may not necessarily represent those of the Company or of any WWAV Rapp Collins Group Company and no representation is given nor liability accepted for the accuracy or completeness of any information contained in this email unless expressly stated to the contrary. If you are not the intended recipient or have received this e-mail in error, you may not use, disseminate, forward, print or copy it, but please notify the sender that you have received it in error. Whilst we have taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses, we cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer systems may be viewed by other company personnel and agents. Registered Office: 1 Riverside, Manbre Road, London W6 9WA
Re: TSM5.2 support on AIX4.3.3
The server requires AIX 5.1, but AIX 4.3 systems can be backed up to a TSM 5.2 >>> [EMAIL PROTECTED] 05/12/2005 11:30:05 AM >>> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of steve freeman >Is TSM v5.2 (32bit) supported on AIX4.3.3 with the latest maintenance >(last). We cannot upgrade to AIX5.1 due to an application No. TSM 5.2 requires a minimum of AIX 5.1. -- Mark Stapleton ([EMAIL PROTECTED]) IBM Certified Advanced Deployment Professional Tivoli Storage Management Solutions 2005 Office 262.521.5627
Re: column width
Just put
SET SQLDISPLAYMODE WIDE
Before your select command.
Bill Boyer
"Some days you're the bug, some days you're the windshield" - ??
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer
Sent: Thursday, May 12, 2005 11:21 AM
To: ADSM-L@VM.MARIST.EDU
Subject: column width
Hello Everyone!
I have issued a command to find the error and warning messages and have emailed
it to myself. Here is the command:
select date_time,msgno,message from actlog where date_time>current_timestamp -
1 day and severity in ('E', 'W')
Is there a way to make the message column wider so that it isn't several lines
long? Thank you!
DATE_TIME MSGNO MESSAGE
-- --- --
2005-05-112035 ANR2035E RUN:
10:45:55.00 Administrator
PMSTORAGE is not
authorized to
issue this
command.
(SESSION: 320563)
2005-05-112035 ANR2035E RUN:
10:45:55.00 Administrator
PMSTORAGE is not
authorized to
issue this
command.
(SESSION: 320563)
2005-05-111423 ANR1423W Scratch
10:46:17.00 volume T00953 is
empty but will
not be deleted -
volume access
mode is "offsite-
".
2005-05-112035 ANR2035E RUN:
10:49:28.00 Administrator
ADMQ is not
authorized to
issue this
command.
(SESSION: 320568)
2005-05-112035 ANR2035E RUN:
10:49:28.00 Administrator
ADMQ is not
authorized to
issue this
command.
(SESSION: 320568)
2005-05-11 480 ANR0480W Session
11:00:21.00 320586 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320586)
2005-05-11 480 ANR0480W Session
11:00:21.00 320588 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320588)
2005-05-11 480 ANR0480W Session
11:00:21.00 320590 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320590)
2005-05-11 480 ANR0480W Session
11:00:21.00 320592 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320592)
2005-05-11 480 ANR0480W Session
11:00:21.00 320594 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320594)
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(71
Re: TSM5.2 support on AIX4.3.3
Thanks for the info. A supplementary question, Will IBM still offer telephone based support on TSM 5.1? -Original Message- From: Stapleton, Mark [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 16:30 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM5.2 support on AIX4.3.3 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of steve freeman >Is TSM v5.2 (32bit) supported on AIX4.3.3 with the latest maintenance >(last). We cannot upgrade to AIX5.1 due to an application No. TSM 5.2 requires a minimum of AIX 5.1. -- Mark Stapleton ([EMAIL PROTECTED]) IBM Certified Advanced Deployment Professional Tivoli Storage Management Solutions 2005 Office 262.521.5627
Re: TSM5.2 support on AIX4.3.3
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of steve freeman >Is TSM v5.2 (32bit) supported on AIX4.3.3 with the latest maintenance >(last). We cannot upgrade to AIX5.1 due to an application No. TSM 5.2 requires a minimum of AIX 5.1. -- Mark Stapleton ([EMAIL PROTECTED]) IBM Certified Advanced Deployment Professional Tivoli Storage Management Solutions 2005 Office 262.521.5627
TSM5.2 support on AIX4.3.3
Hi TSMers, Is TSM v5.2 (32bit) supported on AIX4.3.3 with the latest maintenance (last). We cannot upgrade to AIX5.1 due to an application That is running on the server. Thanks in adv
column width
Hello Everyone!
I have issued a command to find the error and warning messages and have
emailed it to myself. Here is the command:
select date_time,msgno,message from actlog where
date_time>current_timestamp - 1 day and severity in ('E', 'W')
Is there a way to make the message column wider so that it isn't several
lines long? Thank you!
DATE_TIME MSGNO MESSAGE
-- --- --
2005-05-112035 ANR2035E RUN:
10:45:55.00 Administrator
PMSTORAGE is not
authorized to
issue this
command.
(SESSION: 320563)
2005-05-112035 ANR2035E RUN:
10:45:55.00 Administrator
PMSTORAGE is not
authorized to
issue this
command.
(SESSION: 320563)
2005-05-111423 ANR1423W Scratch
10:46:17.00 volume T00953 is
empty but will
not be deleted -
volume access
mode is "offsite-
".
2005-05-112035 ANR2035E RUN:
10:49:28.00 Administrator
ADMQ is not
authorized to
issue this
command.
(SESSION: 320568)
2005-05-112035 ANR2035E RUN:
10:49:28.00 Administrator
ADMQ is not
authorized to
issue this
command.
(SESSION: 320568)
2005-05-11 480 ANR0480W Session
11:00:21.00 320586 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320586)
2005-05-11 480 ANR0480W Session
11:00:21.00 320588 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320588)
2005-05-11 480 ANR0480W Session
11:00:21.00 320590 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320590)
2005-05-11 480 ANR0480W Session
11:00:21.00 320592 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320592)
2005-05-11 480 ANR0480W Session
11:00:21.00 320594 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320594)
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
Re: 2 Media Changer
William, It depends on the library. The library has the ability to announce the Changer through more than one fibre-channel. You should modify the setting on the library and run cfgmgr again on AIX, one of the smc's will become defined. Richard. William <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 12-05-2005 16:52 Please respond to William To: ADSM-L@VM.MARIST.EDU cc: Subject:2 Media Changer I just checked one of TSM Server, it has 2 Media Changer: smc0 Available 0D-08-02 IBM 3584 Library Medium Changer (FCP) smc1 Available 0H-08-02 IBM 3584 Library Medium Changer (FCP) >From TSM Server, it only defines one Media Changer: DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/smc1 ONLINE=YES My question is: If only define 1 Media Changer, TSM Server can't use the second Media Changer, then why does it need 2 Media Changer? If it define the second Media Changer as following: DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/smc0 ONLINE=YES Will TSM automatically use the second Media Changer? TIA
2 Media Changer
I just checked one of TSM Server, it has 2 Media Changer: smc0 Available 0D-08-02 IBM 3584 Library Medium Changer (FCP) smc1 Available 0H-08-02 IBM 3584 Library Medium Changer (FCP) >From TSM Server, it only defines one Media Changer: DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/smc1 ONLINE=YES My question is: If only define 1 Media Changer, TSM Server can't use the second Media Changer, then why does it need 2 Media Changer? If it define the second Media Changer as following: DEFINE PATH TSMSERVER LTO3584 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/smc0 ONLINE=YES Will TSM automatically use the second Media Changer? TIA
Re: Tape Encryption Appliances
This has not generated any response, and there is nothing in the archive, so I thought I might try once more. I'm looking for experiences/comments using TSM with a "tape encryption appliance" that sits between the TSM server and the tape drives. The appliance provides "transparent" compression and encryption. The two products I have found are NeoScale's CryptoStor Tape 700 and Decru's "DataFort T-Series" products. Any comments about these or another product would be appreciated. Thanks, H. Milton Johnson -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Johnson, Milton Sent: Thursday, May 05, 2005 8:19 AM To: ADSM-L@VM.MARIST.EDU Subject: Tape Encryption Appliances Has anyone had any experience with tape compression/encryption appliances such as the NeoScale CryptoStor Tape 700 (http://www.neoscale.com/English/Products/CryptoStor.html)? It is an appliance that sits between the TSM Server and the Tape Drives and transparently provide compression and encryption of tapes. We are using 3590E1A drives and comments from anyone using such a device with or without 3590E1A drives would be appreciated. Thanks, H. Milton Johnson
AW: [ADSM-L] Re Windows 2000 client reconfiguration
Have a look at "Performing an incremental, selective, or incremental-by-date backup" in manual "IBM Tivoli Storage Manager for Windows - Backup-Archive Clients Installation and User's Guide" or have a look at Richard Sims marvelous TSM website - topic "backup" etc. http://people.bu.edu/rbs/ADSM.funcdir HTH Thomas Rupp -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Charlie Hurtubise Gesendet: Donnerstag, 12. Mai 2005 15:29 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] Re Windows 2000 client reconfiguration Hi Win200x Server Backup Techs, I'd be interested in info on this too. I just went through this, forced to move NT disks around. Our one big shared network disk on Win2003 Server filled up and first we split off to a 2nd disk, then moved to a much larger single disk chunk again, all on an IBM SAN. I kept the disk id E: the same on the same server name etc, but just couldn't stop Tivoli from backing up the whole thing again and again. After doing our normal 6 week incremental and an image backup in case etc, I created a FLUSH domain with 2 day retention and smaller version settings etc, moved the Win2003 server to that domain, and flushed out the older FULL backups. I then moved it back to the domain it was in. So what "flag" does the Win200n Tivoli client use to backup a file again, besides update date or archive flag? Thanks.. Charlie Hurtubise Tecsys Inc.
Re: Windows 2000 client reconfiguration
On May 12, 2005, at 4:08 AM, Farren Minns wrote: ...From what I have been told, early tests have not been promising and TSM still thinks files have changed even if the last change date/time etc has not altered. Does anyone have any experience with this or any advice they can give that may help us avoid a long backup that will hog system resources? ... IBM site Technote 1154307 notes that prevailing Windows settings can cause restored objects to inherit parental permissions, to the exclusion of the permissions they had at backup time. This may or may not be a factor. Given that you have both the production and test restoral file systems in place, you have the ideal opportunity to conduct detailed comparisons of the same objects and directories in the two cases, and discern differences, potentially leading to resolution of your issue. It will be valuable to identify restored files which TSM does *not* deem subsequent candidates for backup, as a further source of information. Be sure to reference the client manual's summary of backup criteria. Where TSM 5.3 is used, the new PREview command may be helpful. Richard Simshttp://people.bu.edu/rbs
Re: Re Windows 2000 client reconfiguration
Hi Win200x Server Backup Techs, I'd be interested in info on this too. I just went through this, forced to move NT disks around. Our one big shared network disk on Win2003 Server filled up and first we split off to a 2nd disk, then moved to a much larger single disk chunk again, all on an IBM SAN. I kept the disk id E: the same on the same server name etc, but just couldn't stop Tivoli from backing up the whole thing again and again. After doing our normal 6 week incremental and an image backup in case etc, I created a FLUSH domain with 2 day retention and smaller version settings etc, moved the Win2003 server to that domain, and flushed out the older FULL backups. I then moved it back to the domain it was in. So what "flag" does the Win200n Tivoli client use to backup a file again, besides update date or archive flag? Thanks.. Charlie Hurtubise Tecsys Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David McClelland Sent: Thursday, May 12, 2005 6:32 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Re Windows 2000 client reconfiguration Hi Farren, Been here before ourselves... might be interesting/useful to work out why the TSM client believes the file has changed. Run a backup of the files that you believe it should *not* be backing up but is, but with a trace enabled (hmn, I forget the exact traceflag we used now - might be worth you taking a look at Richard Sims' (not-so!)Quick Facts for the correct one) and this will tell you which attribute it is that it thinks has changed, be it NT permissions, modified date etc... I remember uncovering a somewhat undocumented '-testflag SKIPNTSECURITYCHANGES' during this saga last year which did exactly what the name suggests... Hope that helps point you in the right direction... Rgds, David McClelland Shared Infrastructure Development Reuters 85 Fleet Street London EC4P 4AJ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Farren Minns Sent: 12 May 2005 09:08 To: ADSM-L@VM.MARIST.EDU Subject: Re Windows 2000 client reconfiguration Morning all TSMers Running TSM 5.1.6.2 on a Solaris server. Attached to 1*3494 library with two*3590H1A drives. I have a possible problem here. One of the sys admins for the Windows 2000 servers has informed me that they are going to need to replace an entire Windows 2000 server due to severe hardware issues that they have been experiencing. No amount of support has fixed the problem and hence the drastic move. The server has got some 820,000 files on it amounting to approximately 450GB. Here is what we want to do. Configure a new server and copy the data across in such a way that it doesn't look like it's changed. The new server will have the exact same Node name, file system layout etc. I don't really want to be faced with backing up the entire server all over again as we are getting low on both tape space in the library and database space. This was not something I had foreseen. >From what I have been told, early tests have not been promising and TSM still thinks files have changed even if the last change date/time etc has not altered. Does anyone have any experience with this or any advice they can give that may help us avoid a long backup that will hog system resources? Many thanks in advance Farren Minns Solaris System Admin / Oracle DBA IT - Hosting Services John Wiley & Sons, Ltd ## The information contained in this e-mail and any subsequent correspondence is private and confidential and intended solely for the named recipient(s). If you are not a named recipient, you must not copy, distribute, or disseminate the information, open any attachment, or take any action in reliance on it. If you have received the e-mail in error, please notify the sender and delete the e-mail. Any views or opinions expressed in this e-mail are those of the individual sender, unless otherwise stated. Although this e-mail has been scanned for viruses you should rely on your own virus check, as the sender accepts no liability for any damage arising out of any bug or virus infection. ## - Visit our Internet site at http://www.reuters.com To find out more about Reuters Products and Services visit http://www.reuters.com/productinfo Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
Re: TSM Database
On May 12, 2005, at 6:43 AM, Birgit Sievers wrote: Hello, for creating my own select-statements in TSM i need information about tables, fields, types ... Do: SELECT * FROM SYSCAT.TABLES SELECT * FROM SYSCAT.COLUMNS See also: http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/ tips0010.html and Appendix A of the TSM 5.1 Technical Guide redbook. Richard Sims
TSM Database
Hello, for creating my own select-statements in TSM i need information about tables, fields, types ... Thanks in advance Regards Birgit Sievers Universität Dortmund Hochschulrechenzentrum Abteilung S2 August-Schmidt-Str. 12 Germany 44227 Dortmund Tel.: 0231/755-2052 Fax: 0231/755-2731 email: [EMAIL PROTECTED]
TSM Database - unused space question
Hi all I have a question regarding database fragmentation. At present we have a 14GB database that is 74% utilised. However, we have been running TSM for a few years now and as such I was wondering how accurate that percentage utilization figure really is. Is there a way to tell how much of the database is just fragmented unused space? Is it necessary to do periodic unload/load/audit procedures? I am a bit concerned about doing a full unload/load etc as I assume it can take a very long time to run, and indeed that there is a possibility of running into severe problems. Any ideas, tips, thoughts on this subject would be very much appreciated. Many thanks Farren Minns Solaris System Admin / Oracle DBA IT - Hosting Services John Wiley & Sons, Ltd ## The information contained in this e-mail and any subsequent correspondence is private and confidential and intended solely for the named recipient(s). If you are not a named recipient, you must not copy, distribute, or disseminate the information, open any attachment, or take any action in reliance on it. If you have received the e-mail in error, please notify the sender and delete the e-mail. Any views or opinions expressed in this e-mail are those of the individual sender, unless otherwise stated. Although this e-mail has been scanned for viruses you should rely on your own virus check, as the sender accepts no liability for any damage arising out of any bug or virus infection. ##
Re: Re Windows 2000 client reconfiguration
Hi Farren, Been here before ourselves... might be interesting/useful to work out why the TSM client believes the file has changed. Run a backup of the files that you believe it should *not* be backing up but is, but with a trace enabled (hmn, I forget the exact traceflag we used now - might be worth you taking a look at Richard Sims' (not-so!)Quick Facts for the correct one) and this will tell you which attribute it is that it thinks has changed, be it NT permissions, modified date etc... I remember uncovering a somewhat undocumented '-testflag SKIPNTSECURITYCHANGES' during this saga last year which did exactly what the name suggests... Hope that helps point you in the right direction... Rgds, David McClelland Shared Infrastructure Development Reuters 85 Fleet Street London EC4P 4AJ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Farren Minns Sent: 12 May 2005 09:08 To: ADSM-L@VM.MARIST.EDU Subject: Re Windows 2000 client reconfiguration Morning all TSMers Running TSM 5.1.6.2 on a Solaris server. Attached to 1*3494 library with two*3590H1A drives. I have a possible problem here. One of the sys admins for the Windows 2000 servers has informed me that they are going to need to replace an entire Windows 2000 server due to severe hardware issues that they have been experiencing. No amount of support has fixed the problem and hence the drastic move. The server has got some 820,000 files on it amounting to approximately 450GB. Here is what we want to do. Configure a new server and copy the data across in such a way that it doesn't look like it's changed. The new server will have the exact same Node name, file system layout etc. I don't really want to be faced with backing up the entire server all over again as we are getting low on both tape space in the library and database space. This was not something I had foreseen. >From what I have been told, early tests have not been promising and TSM still thinks files have changed even if the last change date/time etc has not altered. Does anyone have any experience with this or any advice they can give that may help us avoid a long backup that will hog system resources? Many thanks in advance Farren Minns Solaris System Admin / Oracle DBA IT - Hosting Services John Wiley & Sons, Ltd ## The information contained in this e-mail and any subsequent correspondence is private and confidential and intended solely for the named recipient(s). If you are not a named recipient, you must not copy, distribute, or disseminate the information, open any attachment, or take any action in reliance on it. If you have received the e-mail in error, please notify the sender and delete the e-mail. Any views or opinions expressed in this e-mail are those of the individual sender, unless otherwise stated. Although this e-mail has been scanned for viruses you should rely on your own virus check, as the sender accepts no liability for any damage arising out of any bug or virus infection. ## - Visit our Internet site at http://www.reuters.com To find out more about Reuters Products and Services visit http://www.reuters.com/productinfo Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
Re Windows 2000 client reconfiguration
Morning all TSMers Running TSM 5.1.6.2 on a Solaris server. Attached to 1*3494 library with two*3590H1A drives. I have a possible problem here. One of the sys admins for the Windows 2000 servers has informed me that they are going to need to replace an entire Windows 2000 server due to severe hardware issues that they have been experiencing. No amount of support has fixed the problem and hence the drastic move. The server has got some 820,000 files on it amounting to approximately 450GB. Here is what we want to do. Configure a new server and copy the data across in such a way that it doesn't look like it's changed. The new server will have the exact same Node name, file system layout etc. I don't really want to be faced with backing up the entire server all over again as we are getting low on both tape space in the library and database space. This was not something I had foreseen. >From what I have been told, early tests have not been promising and TSM still thinks files have changed even if the last change date/time etc has not altered. Does anyone have any experience with this or any advice they can give that may help us avoid a long backup that will hog system resources? Many thanks in advance Farren Minns Solaris System Admin / Oracle DBA IT - Hosting Services John Wiley & Sons, Ltd ## The information contained in this e-mail and any subsequent correspondence is private and confidential and intended solely for the named recipient(s). If you are not a named recipient, you must not copy, distribute, or disseminate the information, open any attachment, or take any action in reliance on it. If you have received the e-mail in error, please notify the sender and delete the e-mail. Any views or opinions expressed in this e-mail are those of the individual sender, unless otherwise stated. Although this e-mail has been scanned for viruses you should rely on your own virus check, as the sender accepts no liability for any damage arising out of any bug or virus infection. ##
Re: ANR0481W and COMMTIMEOUT setting
Neil, Rob et al, Similarly with MSSQL, particularly during restores of large databases where SQL Server (completely aside from TDPS) goes away and formats its database files leaving the TDPS session open and idle - I tend to recommend an hour (3600) for COMMTIMEOUT for this reason. Shame we can't have a 'global' COMMTIMEOUT setting which can be overridden by a node, group or domain level COMMTIMEOUT setting - that way I could have all of my 'TDPS_DOMAIN' nodes with a longer timeout that my normal BA client backups... Rgds, David McClelland Shared Infrastructure Development Reuters 85 Fleet Street London EC4P 4AJ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Neil Rasmussen Sent: 11 May 2005 21:08 To: ADSM-L@VM.MARIST.EDU Subject: Re: ANR0481W and COMMTIMEOUT setting I noticed that the node in your example is a TDP SQL node (if I am reading correctly). It is not uncommon for nodes that are TDPs to require longer timeouts. What happens is that databases will start up a session with the TSM Server and then will go off and collect the information to send - depending on the amount of processing that occurs, which quite often correlates to the size of the database, can take a *very* long time. For instance, I know that with Oracle/TDP Oracle during an incremental of larger databases, Oracle may spend a long time trying to locate changed blocks. I have seen these times take longer than 30 minutes (although not common). The short of it is that you may need a time out of 1800+ to accomodate these databases. Regards, Neil Rasmussen Software Development Data Protection for Oracle Andrew Raibeck/Tucson/[EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" 05/11/2005 12:49 PM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject Re: ANR0481W and COMMTIMEOUT setting 1800 seconds is a *very* long commtimeout setting. Assuming the clients in question are on relatively fast networks (e.g., not dial-up), I would tend to suspect that a problem in the network (though I could not tell you what that problem is), especially if it continues to occur. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2005-05-11 12:29:27: > Thanks John, appreciate the info. > > John Naylor wrote, on 05/11/05 01:42: > > Robert, > > My commtimeout is set 3600 with no problems Where you are seeing > > hits where you had none before you may want to consider/alleviate > > the cause per the description in Admin Ref > > > > Specifies how long the server waits for an expected client message during > > an > > operation that causes a database update. If the length of time > > exceeds this time-out, the server ends the session with the client. > > You may want to increase the > > time-out > > value to prevent clients from timing out. Clients may time out if there is > > a heavy > > network load in your environment or they are backing up large files > > John > > > > > > > > > > > > robert moulton <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor > > Manager" > > 10/05/2005 20:07 > > Please respond to > > "ADSM: Dist Stor Manager" > > > > > > To > > ADSM-L@vm.marist.edu > > cc > > > > Subject > > ANR0481W and COMMTIMEOUT setting > > > > > > > > > > > > > > Greetings ADSM List - Seeking your advice and/or a nudge toward applicable > > documentation ... > > > > TSM Version 5, Release 2, Level 4.0 > > AIX 5.2 > > > > We're seeing an increasing number of these ANR0481W messages in > > server > > logs: > > > > ANR0481W Session 38 for node M_SQLSAN01_CL_U (WinNT) terminated > > - client did not respond within 1800 seconds. > > > > As you can see our COMMTIMEOUT setting is 1800 seconds. Are there risks > > involved with boosting it even higher? > > > > Thanks in advance for your advice. > > > > Robert Moulton > > University of Washington > > Computing & Communications > > > > > > > > > > ** The information in this E-Mail is confidential and may be legally > > privileged. It may not represent the views of Scottish and Southern > > Energy Group. > > It is intended solely for the addressees. Access to this E-Mail by > > anyone else is unauthorised. If you are not the intended recipient, > > any disclosure, copying, distribution or any action taken or omitted > > to be taken in reliance on it, is prohibited and may be unlawful. > > Any unauthorised recipient should advise the sender immediately of > > the error in transmission. Unless specifically stated otherwise, > > this email (or any attachments to it) is not an offer capable of > > acceptance or acceptance of an offer and it does not
