Re: Backup reporting

2002-09-19 Thread Rainer Wolf

Hello All,

i have two questions on this:
In our server all and only the backup-data is going through migration pools.
Comparing this size with the
"Amount of backup files, in kilobytes, sent by the client to the server"
this more real (i believe) backup-data-size_counted-by-migration
has a nearly constant difference of about 15-20 % , no matter what time-period
is selected.

for example:
tsm: ADSMAIX>select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB
Backup from backup_activity" from summary where start_time>=current_timestamp
-30 day and activity='BACKUP'

Total GB Backup from backup_activity

1928.968

tsm: ADSMAIX>select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB
Backup from migration_activity" from summary where start_time>=current_timestamp
-30 day and activity='MIGRATION'

Total GB Backup from migration_activity
---
   1631.496

Question 1 : is it ok to get the datasize of whats being backed up by
the migration ( assuming there is really nothing else doing migration,
like 'move data' ... and accepting that the time_period is slightly shifted )
 or is there another way to get the size of Backup data ?

Question 2: we are using archive writing directly onto tapes, and if using
the summary with activity='ARCHIVE' the output may be also too high.
My idea is to get the amount of archive data by the summary of
activity 'STGPOOL BACKUP' together with entity=... .
Is this ok (accepting some time_shifting ) or is there another
way to get the Numer of bytes being archived , some sql script ?


Thanks for any hint !
Rainer


"Rushforth, Tim" wrote:
>
> The "Amount of backup files, in kilobytes, sent by the client to the server"
> does include client retries (at least at 4.2.0 level).  We've just
> experienced this when a node that retries a huge file shows sending 19 GB
> instead of the normal 8 GB.
>
> Field 17 from the accounting record below shows this (19,350,787).
>
> 4,0,ADSM,09/12/2002,01:46:22,COWSVP08,,WinNT,1,Tcp/Ip,1,0,0,0,0,2569,
> 19350787,0,0,19355216,9883,205,9094,0,4,0,0,0,0,2,0
>
> Tim Rushforth
> City of Winnipeg
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Bill Boyer
> > Sent: Wednesday, September 18, 2002 3:10 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Backup reporting
> >
> >
> > There was a problem where the bytes transferred in the summary table as
> > zero. It has been fixed in later patch levels. I'm not sure what the APAR
> > number is or the level where it was fixed.
> >
> > If you need this data, turn on the accounting records. There is an
> > additional field "Amount of backup files, in kilobytes, sent by the client
> > to the server" in addition to the "Amount of data, in kilobytes,
> > communicated between the client node and the server during the
> > session". The
> > bytes communicated is the total bytes transferred and includes and
> > re-transmissions/retries. I believe the "Amount of backup files, in
> > kilobytes, sent by the client to the server" is just what was sent AND
> > stored in TSM.
> >
> > I haven't fully looked into this, but if I'm trying to get a total for the
> > amount of data backed up I would be using this field as opposed
> > to the bytes
> > transmitted field. Something for me to add to my Honey-Do list..:-)
> >
> > Bill Boyer
> > DSS, Inc.
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Mark Bertrand
> > Sent: Wednesday, September 18, 2002 2:39 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Backup reporting
> >
> >
> > Paul and all,
> >
> > When I attempt to use any of the following select statements my "Total MB"
> > returned is always 0. I get my list of nodes but there is never
> > any numbers
> > for size.
> >
> > Since this is my first attempt at select statements, I am sure I doing
> > something wrong. I have tried from command line and through macro's.
> >
> > I am trying this on a W2K TSM v4.2.2 server.
> >
> > Thanks,
> > Mark B.
> >
> > -Original Message-
> > From: Seay, Paul [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 16, 2002 11:43 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Backup reporting
> >
> >
> > See if these will help:
> >
> > /* SQL Script:   */
> > /*   */
> > /* backup_volume_last_24hours.sql*/
> > /* Date   Description*/
> > /* 2002-06-10 PDS Created*/
> >
> > /* Create Report of total MBs per each session */
> >
> > select entity as "Node Name  ", cast(bytes/1024/1024 as decimal(10,3))
> > as "Total MB  ",  cast(substr(cast(end_time-start_time as
> > char(17)),3,8) as
> > char(8)) as 

Re: TSM 5.1.1 Win2000 server reboot

2002-09-19 Thread Halvorsen Geirr Gulbrand

Thanx;
but it's funny - the last version I could find on Adaptecs website says v.
7.0.360.100 (from file information).

Rgds
Geirr G. Halvorsen

-Original Message-
From: Bill Boyer [mailto:[EMAIL PROTECTED]]
Sent: 18. september 2002 15:24
To: [EMAIL PROTECTED]
Subject: Re: TSM 5.1.1 Win2000 server reboot


>From the Drivers Detail screen:

ADPU160M.SYS

Provider: Adaptec
Version: d4.2 (4.10.4002)



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Halvorsen Geirr Gulbrand
Sent: Wednesday, September 18, 2002 9:11 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM 5.1.1 Win2000 server reboot


Hi Bill,
I would  very much like to know version data for the Adpatec driver you are
using.

Rgds
Geirr G. Halvorsen


-Original Message-
From: Bill Boyer [mailto:[EMAIL PROTECTED]]
Sent: 18. september 2002 15:03
To: [EMAIL PROTECTED]
Subject: Re: TSM 5.1.1 Win2000 server reboot


Adaptec has an updated driver on their site that works great. The default
driver delivered with Win2k has problems with LTO tape. I haven't seen
reboot problems, but severe throughput issues to where I would only get
1-2GB/hour throughput on the tape drives. Updating to the Adaptec drivers
(even though the Tivoli support pages say to use the IBM drivers) has gotten
me to 1+GB/Minute throughput.

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Halvorsen Geirr Gulbrand
Sent: Wednesday, September 18, 2002 4:37 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM 5.1.1 Win2000 server reboot


Hi Kurt,
I have had a similar problem (maybe the same) with TSM v. 4.2.2 on an IBM
x342, with adaptec 39160 SCSI controller, and LTO library IBM 3584.
In my case it rebooted 1-2 times pr. day. I bugged me alot, but seemingly it
was a problem with the SCSI Controller Driver on w2k.
To fix this I made a database backup of TSM, and installed w2k from scratch,
then installed the correct driver for the adapter-card (found on
ftp://ftp.software.ibm.com/storage/devdrvr/Win2000/adaptec_lun.zip),
reinstalled TSM, and restored the TSM database. I haven't had the problems
after that. Now, I don't think reinstalling OS should be necessary, but I
believe the problem is something related to registry settings for device
adpu160m (the adaptec controller), and when updating this driver, some
settings still are in registry or some files exist that are not replaced
when updating the driver.
Another problem is that because the server goes down unexpectedly, TSM is
likely to have a corrupted database, and when you get the server to run OK,
you should do an AUDITDB on your tsm. (Oh my, this is slow...)
The other option is to drop your database, and just do the full backup all
over again.

Hope this helps...

Rgds.
Geirr G. Halvorsen


-Original Message-
From: Kurt Beyers [mailto:[EMAIL PROTECTED]]
Sent: 17. september 2002 22:56
To: [EMAIL PROTECTED]
Subject: TSM 5.1.1 Win2000 server reboot


Hi,

I've just installed TSM 5.1.1 on a Windows 2000 Advanced Server (SP2)

The hardware of the TSM server is:

IBM Netfinity X232 8668 (Pentium 4, 1133 MHz)
512 MB RAM
IBM ServeRAID-4LX Ultra 160 controller (SCSI controller of internal disks)
IBM LTO library connected via an Adaptec SCSI controller.

During the setup of TSM and the full backup of a number of clients, the
server has rebooted 6 times. There is no Dr. Watson or what so ever. In the
TSM activity log there are also no errors written. You just retrieve the
latest commands before the shutdown and afterwards the normal startup
messages of TSM.

Only in the event log, there is an event stating 'An unexpected system
shutdown has occured'. No other errors or warnings in the event log.

Has anybody else experienced a similar situation and how did you solve it?

Any input is more then welcome. Thanks,

Kurt



TDP exchange - please help

2002-09-19 Thread chris rees

Hi all

I'm having the same problem that Joe had lst year ( see text below )
Someone gave him the answer but I can't find it on the forum. Can anyone
please enlighten me.  I think it may be to to with my inclexcl line but not
sure...it currently looks like
include "corwwdsapp04\first storage group\...\*"

I'm running active/passive on win2000 servers. TSM client in 5.1, TDP for
exchange is 2.2

Thanks

Chris




Server : TSM 4.1.3 on NT4 sp6a
Client:  Cluster 2 nodes
NT 2000 with TSM 4.2 and TDP for Exchange

No problem performing backups on cluster node name using TSM (system
drives). Backup of Exchange 5.5 using TDP v2.2 is ok (migrating to Exchange
2000)

TDP for exchange v2.2 dsm.opt file is :

NODename QBSMET01
CLUSTERnode   yes
COMPRESSIon   Off
PASSWORDAccessGenerate

This is connecting to the TSM server, but getting error of:

ACN5237E Unable to communicate with the Microsoft Exchange Server

Any thoughts?.

Thanks

Joe Cascanette
The Cumis Group Limited





_
Send and receive Hotmail on your mobile device: http://mobile.msn.com



Re: differences in between version 4 and 5 in the SQL database

2002-09-19 Thread Petur Ey?orsson

hehe yes of course Zlatko,

how could I have been so stupid :-/

sorry guys.



Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

[EMAIL PROTECTED]

 Nyherji Hf  Simi TEL: +354-569-7700
 Borgartun 37105 Iceland
 URL:http://www.nyherji.is


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Zlatko Krastev/ACIT
Sent: 18. september 2002 16:35
To: [EMAIL PROTECTED]
Subject: Re: differences in between version 4 and 5 in the SQL database


Petur,

check at which fix are you in v5.1. Maybe you missed it but there is a
problem with summary table not filled. And you have to check why
"sum(summary.bytes)" is more than 0 :-()

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:

Subject:differences in between version 4 and 5 in the SQL database

Hello there friends :-)

This has been buggin me the last week.

There have been some changes in the database since it became version 5

I have a script that shows the total amount of data sent over last night.

the output is like this in version 4.x and 3.x

NODE NAME  DOMAIN PLATFORM
MBYTES  CONECTIONS
-- --  -
--- ---
BAUG_CDB2  REKSTRAR   DB2
12360.93   4
FINGRANDI  REKSTRAR   WinNT
8789.06   3


ok this is what happens when I run the command in version 5.


NODE NAME  DOMAIN PLATFORM
MBYTES  CONECTIONS
-- --  -
--- ---
URDUR  VIDWinNT
1909.65   1
PERLAN VIDWinNT
1446.82   1

there is something wrong with this picture, I have around 40 clients on
this
site and they either don't show up
or they show only one connection to the database, when I know that there
has
been more connections.

this is the script I am using for this task.

select summary.entity as "NODE NAME",
 nodes.domain_name as "DOMAIN",
nodes.platform_name as "PLATFORM",
 cast((cast(sum(summary.bytes) as float) / 1024 / 1024) as
decimal(10,2))
as MBYTES ,
count(*) as "CONECTIONS"

 from summary ,nodes
where summary.entity=nodes.node_name
and summary.activity='BACKUP'
and start_time >current_timestamp - 1 day
group by entity, domain_name, platform_name
order by MBytes desc


here it is again:
select summary.entity as "NODE NAME", nodes.domain_name as "DOMAIN",
nodes.platform_name as "PLATFORM", cast((cast(sum(summary.bytes) as float)
/
1024 / 1024) as decimal(10,2)) as MBYTES , count(*) as "CONECTIONS" from
summary ,nodes where summary.entity=nodes.node_name and
summary.activity='BACKUP' and start_time >current_timestamp - 1 day group
by
entity, domain_name, platform_name order by MBytes desc

Ok I know there are some great SQL guys out there, like Paul Seay and
other
SQL gurus.

Can someone tell me why I am getting this so wrong?


Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

[EMAIL PROTECTED]

 Nyherji Hf  Simi TEL: +354-569-7700
 Borgartun 37105 Iceland
 URL:http://www.nyherji.is



Re: !Urgent - SDLT/TSM slow after upgrade from v. 4.2.1.7 to v. 4 .2.2 .12

2002-09-19 Thread Halvorsen Geirr Gulbrand

Hi Paul, Gilbert, Dwight (and the rest)!

I'm running on W2K, dual processor, P3 800, 1 GB RAM.
I checked DB Cache hit, and it's 98,27, which should be fine.
This morning DBbackup was fast (as before), but expiration was slow, so I
bumped the BUFPOOLSIZE (x1,5), too see if it helps. I'll be back in my
office on monday, to follow up further.

Thanks for your help (-so far  ;-).

Best Rgds.
Geirr G. Halvorsen


-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: 18. september 2002 16:39
To: [EMAIL PROTECTED]
Subject: Re: !Urgent - SDLT/TSM slow after upgrade from v. 4.2.1.7 to v.
4 .2.2 .12


We went from 4.2.2.7 to 4.2.2.12, not as large a jump as you and we saw this
problem has well.  Have you checked your db cache hit ratio?  We had to
increase the bufferpool size significantly, we needed to anyway.  It appears
4.2.2.12 is much more sensitive to low db cache hits.  As for database
backups, I think there is a problem there, ours are taking much longer than
before.  I am still trying to isolate the problem.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Halvorsen Geirr Gulbrand [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 3:59 AM
To: [EMAIL PROTECTED]
Subject: !Urgent - SDLT/TSM slow after upgrade from v. 4.2.1.7 to v. 4.2.2
.12


Hi Everyone!
For one of our customers I have recently upgraded their TSM server (and TSM
device-driver) from v. 4.2.1.7 to 4.2.2.12, because of added support for
multiple modules of library Compaq MSL5026DLX. Configuration is now: TSM
Server (+dev.driver) v. 4.2.2.12 Library Compaq MSL5025DLX (2 modules) with
3 SDLT 220 drives.

After the upgrade, many of the processes takes a very long time to complete.
Expiration used to take 10-15 minutes, takes now 1,5 hours. Database backup
used to take about 20 minutes, takes now 1-2 hours, migration is slow,
space-reclamation is very slow, and when they try to stop spacereclamation,
it takes hours before it stops.

I'm sorry I don't have any numbers (MB/s) for these processes. I might have
more data on this by tomorrow. But I would like to know if anyone else have
seen similar problems after an upgrade.

Any help is highly appreciated!

Rgds.
Geirr G. Halvorsen



Re: TDP exchange - please help

2002-09-19 Thread Loon, E.J. van - SPLXM

Hi Chis!
Checkout this one:
http://msgs2.adsm.org/cgi-bin/get/adsm0111/87.html
Maybe this helps?
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


-Original Message-
From: chris rees [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 12:02
To: [EMAIL PROTECTED]
Subject: TDP exchange - please help


Hi all

I'm having the same problem that Joe had lst year ( see text below )
Someone gave him the answer but I can't find it on the forum. Can anyone
please enlighten me.  I think it may be to to with my inclexcl line but not
sure...it currently looks like
include "corwwdsapp04\first storage group\...\*"

I'm running active/passive on win2000 servers. TSM client in 5.1, TDP for
exchange is 2.2

Thanks

Chris




Server : TSM 4.1.3 on NT4 sp6a
Client:  Cluster 2 nodes
NT 2000 with TSM 4.2 and TDP for Exchange

No problem performing backups on cluster node name using TSM (system
drives). Backup of Exchange 5.5 using TDP v2.2 is ok (migrating to Exchange
2000)

TDP for exchange v2.2 dsm.opt file is :

NODename QBSMET01
CLUSTERnode   yes
COMPRESSIon   Off
PASSWORDAccessGenerate

This is connecting to the TSM server, but getting error of:

ACN5237E Unable to communicate with the Microsoft Exchange Server

Any thoughts?.

Thanks

Joe Cascanette
The Cumis Group Limited





_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


**
For information, services and offers, please visit our web site: http://www.klm.com. 
This e-mail and any attachment may contain confidential and privileged material 
intended for the addressee only. If you are not the addressee, you are notified that 
no part of the e-mail or any attachment may be disclosed, copied or distributed, and 
that any other action related to this e-mail or attachment is strictly prohibited, and 
may be unlawful. If you have received this e-mail by error, please notify the sender 
immediately by return e-mail, and delete this message. Koninklijke Luchtvaart 
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for 
the incorrect or incomplete transmission of this e-mail or any attachments, nor 
responsible for any delay in receipt.
**



Netware cluster volumes and TSM

2002-09-19 Thread Rene Olsen

Hi,

Does anyone know the status for TSM support for Netware cluster volumes?  As far as I 
know, TSM is not yet "Netware cluster aware".  Netware's own backup SBCON and 
BackupExec are the only systems that are "Netware cluster aware".


René Olsen
Netadministrator Tele/Data
Odense Universitetshospital

Tlf. sekr.: +45 6541 2894
Fax +45 6541 2601



Re: Future plans for encryption in TSM

2002-09-19 Thread Emil S. Hansen

On Wed, Sep 18, 2002 at 09:49:07AM -0400, Jelinek, David G. wrote:
> Has anyone heard if there are any plans to increase the encryption
> strength from 56 bit DES to at least 1024 bit? We have requirements
> because of the HIPAA (Health Information Portability and Accountability
> Act) stuff. Thanks in advance.

1024 bit symetric encryption? You guys must be crasy or talking about
asymetric encryption which is another ball game (read: Oranges and
apples).

-- 
Best Regards
Emil S. Hansen - [EMAIL PROTECTED] - ESH14-DK
UNIX Administrator, Berlingske IT - www.bit.dk
PGP: 109375FA/ABEB 1EFA A764 529E 82B5  0943 AD3B 1FC2 1093 75FA

"tjaa men ville disse lister ikke være kedelige hvis vi altid gav
hinanden ret med det samme :o)" - Kim Schulz på SSLUG.PROG



msg30066/pgp0.pgp
Description: PGP signature


Select command to q client name and version

2002-09-19 Thread Karla Ross

Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross



Re: Select command to q client name and version

2002-09-19 Thread Halvorsen Geirr Gulbrand

Hi Karla,
try
select node_name,client_version,client_release,client_level,client_sublevel
from nodes

Rgds,
Geirr G. Halvorsen

-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: 19. september 2002 15:08
To: [EMAIL PROTECTED]
Subject: Select command to q client name and version


Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross



Re: 4.2.x selects from DRIVE table

2002-09-19 Thread David Stabler

gotta be a bugit's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.  WEIRD.

-drs-

>>> [EMAIL PROTECTED] 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and
Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on
AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?



Re: Select command to q client name and version

2002-09-19 Thread Hussein Abdirahman

Hi Carla;

Try this. I got this from group.
It will also display the OS versions.



select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as char(2)) || '.' -
|| cast(client_release as char(2)) || '.' -
|| cast(client_level as char(2)) || '.' -
|| cast(client_sublevel as char(2)) -
as char(15)) as "Client" -
from nodes -
order by platform_name, "Client", Node

regrds;
Hussein M. Abdirahman
UNIX Administrator




-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:08 AM
To: [EMAIL PROTECTED]
Subject: Select command to q client name and version


Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross



Re: 4.2.x selects from DRIVE table

2002-09-19 Thread Alexander Verkooijen

Hi,

I can reproduce this on our 4.2.2.10 (AIX) server.

Hardly WAD or a new feature, I think you found a bug.

Regards,

Alexander

On 19-Sep-02 Jolliff, Dale wrote:
> Something odd I noticed this morning about 4.2.x servers on AIX and Solaris
> -
>
> "query drive f=d"
> and
> "select * from drives"
>
> Displays values in the Device field, whereas a
>
> "select device from drives"
>
> displays a blank device field.
>
> This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.
>
> I went back to an older server (3.x) on AIX, and a "select device from
> drives"  shows the devices, as I expected.
>
> Anyone else able to reproduce this?  Is this WAD or a new 'feature'?

---
Alexander Verkooijen([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing



Re: Select command to q client name and version

2002-09-19 Thread Alexander Verkooijen

On 19-Sep-02 Karla Ross wrote:

> Does anyone have a select command that will show me the clients and what
> version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
> and 5.1.

select node_name,client_version,client_release,client_sublevel from nodes

---
Alexander Verkooijen([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing



Re: TSM 5.1.1 Win2000 server reboot

2002-09-19 Thread [EMAIL PROTECTED]

The problem seems to be solved. There was a service 'IBM Automatic Server Reboot' that 
caused the reboots. It is a known problem at IBM and the problem is fixed in a more 
recent version of the service. It has been installed and the server didn't reboot 
since then.

Thanks for the guided help you have been given

Kurt


 "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote:


>Thanx;
>but it's funny - the last version I could find on Adaptecs website says v.
>7.0.360.100 (from file information).
>
>Rgds
>Geirr G. Halvorsen
>
>-Original Message-
>From: Bill Boyer [mailto:[EMAIL PROTECTED]]
>Sent: 18. september 2002 15:24
>To: [EMAIL PROTECTED]
>Subject: Re: TSM 5.1.1 Win2000 server reboot
>
>
>From the Drivers Detail screen:
>
>ADPU160M.SYS
>
>Provider: Adaptec
>Version: d4.2 (4.10.4002)
>
>
>
>-Original Message-
>From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
>Halvorsen Geirr Gulbrand
>Sent: Wednesday, September 18, 2002 9:11 AM
>To: [EMAIL PROTECTED]
>Subject: Re: TSM 5.1.1 Win2000 server reboot
>
>
>Hi Bill,
>I would  very much like to know version data for the Adpatec driver you are
>using.
>
>Rgds
>Geirr G. Halvorsen
>
>
>-Original Message-
>From: Bill Boyer [mailto:[EMAIL PROTECTED]]
>Sent: 18. september 2002 15:03
>To: [EMAIL PROTECTED]
>Subject: Re: TSM 5.1.1 Win2000 server reboot
>
>
>Adaptec has an updated driver on their site that works great. The default
>driver delivered with Win2k has problems with LTO tape. I haven't seen
>reboot problems, but severe throughput issues to where I would only get
>1-2GB/hour throughput on the tape drives. Updating to the Adaptec drivers
>(even though the Tivoli support pages say to use the IBM drivers) has gotten
>me to 1+GB/Minute throughput.
>
>Bill Boyer
>DSS, Inc.
>
>-Original Message-
>From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
>Halvorsen Geirr Gulbrand
>Sent: Wednesday, September 18, 2002 4:37 AM
>To: [EMAIL PROTECTED]
>Subject: Re: TSM 5.1.1 Win2000 server reboot
>
>
>Hi Kurt,
>I have had a similar problem (maybe the same) with TSM v. 4.2.2 on an IBM
>x342, with adaptec 39160 SCSI controller, and LTO library IBM 3584.
>In my case it rebooted 1-2 times pr. day. I bugged me alot, but seemingly it
>was a problem with the SCSI Controller Driver on w2k.
>To fix this I made a database backup of TSM, and installed w2k from scratch,
>then installed the correct driver for the adapter-card (found on
>ftp://ftp.software.ibm.com/storage/devdrvr/Win2000/adaptec_lun.zip),
>reinstalled TSM, and restored the TSM database. I haven't had the problems
>after that. Now, I don't think reinstalling OS should be necessary, but I
>believe the problem is something related to registry settings for device
>adpu160m (the adaptec controller), and when updating this driver, some
>settings still are in registry or some files exist that are not replaced
>when updating the driver.
>Another problem is that because the server goes down unexpectedly, TSM is
>likely to have a corrupted database, and when you get the server to run OK,
>you should do an AUDITDB on your tsm. (Oh my, this is slow...)
>The other option is to drop your database, and just do the full backup all
>over again.
>
>Hope this helps...
>
>Rgds.
>Geirr G. Halvorsen
>
>
>-Original Message-
>From: Kurt Beyers [mailto:[EMAIL PROTECTED]]
>Sent: 17. september 2002 22:56
>To: [EMAIL PROTECTED]
>Subject: TSM 5.1.1 Win2000 server reboot
>
>
>Hi,
>
>I've just installed TSM 5.1.1 on a Windows 2000 Advanced Server (SP2)
>
>The hardware of the TSM server is:
>
>IBM Netfinity X232 8668 (Pentium 4, 1133 MHz)
>512 MB RAM
>IBM ServeRAID-4LX Ultra 160 controller (SCSI controller of internal disks)
>IBM LTO library connected via an Adaptec SCSI controller.
>
>During the setup of TSM and the full backup of a number of clients, the
>server has rebooted 6 times. There is no Dr. Watson or what so ever. In the
>TSM activity log there are also no errors written. You just retrieve the
>latest commands before the shutdown and afterwards the normal startup
>messages of TSM.
>
>Only in the event log, there is an event stating 'An unexpected system
>shutdown has occured'. No other errors or warnings in the event log.
>
>Has anybody else experienced a similar situation and how did you solve it?
>
>Any input is more then welcome. Thanks,
>
>Kurt
>



Re: 4.2.x selects from DRIVE table

2002-09-19 Thread Mr. Lindsay Morris

We saw the same thing.  You have to "select device, device_type, ...", not
just "select device".
Has to do with some database changes made in TSM - not sure what.

-
Mr. Lindsay Morris
Lead Architect, Servergraph
859-253-8000 ofc
425-988-8478 fax


> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Jolliff, Dale
> Sent: Thursday, September 19, 2002 9:14 AM
> To: [EMAIL PROTECTED]
> Subject: 4.2.x selects from DRIVE table
>
>
> Something odd I noticed this morning about 4.2.x servers on AIX
> and Solaris
> -
>
> "query drive f=d"
> and
> "select * from drives"
>
> Displays values in the Device field, whereas a
>
> "select device from drives"
>
> displays a blank device field.
>
> This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.
>
> I went back to an older server (3.x) on AIX, and a "select device from
> drives"  shows the devices, as I expected.
>
> Anyone else able to reproduce this?  Is this WAD or a new 'feature'?
>



Re: LAN-free backup goes SAN, LAN, SAN

2002-09-19 Thread Zlatko Krastev/ACIT

Paul,

This ought to be like non-Euclidian geometry - Two milleniums
mathmaticians thought there can be only one parallel line and when dropped
this limitation discovered whole new branch in the science :-)
In fact I thought enablelanfree allows client to have conversation with
more than one server - real TSM server and local STA. And management class
bindings direct which route to follow. Now I have to read the fine print
again ,-)
It works fine till now and the result is as I thought it ought to - files
bound to disk class go over LAN and files bound to SAN-tape class go
LAN-free.
I will dig deeper and on success will let you know.
Another question pops up in my head (again on the edge of non-supported :)
- What if I try to use v5.1 client and v4.2.1 storage agent? Have to read
carefully compatibility matrix - v5.1 client is supported with v4.2.1
server, storage agent is same version as the server, nothing said about
what I intend to use ...
Any ideas (Andy?)

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:

Subject:Re: LAN-free backup goes SAN, LAN, SAN

Zlatko,
I am actually surprised you even got this to work.  When you define in
DSM.SYS as LANFREE it has to go directly to tape for everything you are
backing up with that node.  Nothing can go to a disk pool.  So, you have
to
define multiple stanzas in dsm.sys and multiple dsm.opt files.  Now that
you
have multiple nodes you see the sticky wicket.  You can not send the DIRMC
to a disk pool and the data to a tape pool.

We tried what you did and occassionally got what you have seen, but more
often than not, complete failure.

If you find out that there is a way to make it work, I would like to know
how.  I do not remember where the fine print is buried on this
restriction,
but it is a known restriction.

You have to think of LANFREE as sending the data to an alternate TSM
server
on your local machine that shares the library with the TSM Server owning
the
library, but fakes out the fact that the database is on the TSM Server
owning the library.  A node can only form a session with one TSM server at
a
time.  This is why the TDP for SAP R3 supports a parallel session
capability
that can define more than one node so that you can actually send data to
several TSM server addresses simultaneously.  Typically, they are just
multiple adapters on a single TSM server, but they could be multiple TSM
servers.

I hope that makes sense, what I just said.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Zlatko Krastev/ACIT [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 12:27 PM
To: [EMAIL PROTECTED]
Subject: LAN-free backup goes SAN, LAN, SAN


Hello all,

If you do not like to read long posts please skip this one - it can be
boring.

I have a very nasty problem at customer site and asking for your help are
we
the only having it. If not can we fight it together.
Environment:
Server: v4.2.1.15, Windows 2000 SP2
Client: v4.2.2.1 (was 4.2.1.25), AIX 4.3.3ML09 + patches Storage Agent:
v4.2.1.15, TCP/IP or Shared Memory
SAN: IBM 2108-F16 (Brocade) switch + IBM 3583-L18 (ADIC) LTO with 2 drives
Storage policy: Stgpools use defined volumes and no scratches. Yes, I know
it's very unusual combination (Windows TSM server + AIX nodes). Even
support
in the beginning thought it is AIX server w/ Win client.

The node in question is somewhat mixed - small (<50kB) and large (Nx100MB
or
1-4GB) files. So for performance small files are directed to go over LAN.
Large files are bound to direct-to-SAN-tape class and storage agent should
take care of them. DIRMC is pointing diskpool as it ought to.

Now the problem:
1. Client starts backup, sent several directories over LAN, on first file
reported ANS1114I and waits server to mount a volume on behalf of storage
agent (OK) 2. Variable number of files are backed up for less than 1% of
the
volume mounted (OK) 3. Client reports another ANS1114I (here is the
problem). Under the covers it seems than client requested this and next
several files to go over LAN instead of LAN-free. So mount is performed by
server for its own use (normal MgSysLAN path). 4. Another bunch of files
are
backed to second volume. 'Q SES' shows tens of MBs so files go over LAN.
5.
Third ANS1114I is reported and client resumes normal operation 6. Backup
completes with no error, everything is backed up but for enourmous time -
test with 3-4 GB went good 20 minutes instead of 5. The result of this
SAN-LAN-SAN sequence is two volumes less than 5% utilized, 5-minutes
backup
taking between 20 and 40 minutes and unwanted data spread. Contents are
VOL1: file set 1, file set 3
VOL2: file set 2
And if accidentally second drive is busy (migration most often) the
process
might go to bed in step 3 and wake up one hour later (when drive becomes
available on the end).

Part

Re: TSM 5.1.1 Win2000 server reboot

2002-09-19 Thread Halvorsen Geirr Gulbrand

Hi Kurt.
Sorry I don't have anything further than maybe check if there has been any
ADSMSCSI and ADPU160M errors in the system event log, say the last hour
before the server dies. (Not necessarily right before crash.) Also check if
there are any newer Ultrium Device Drivers from IBM.
In my previous experience with this, I always had som of these errors also.
Another option - tedious and perhaps difficult (haven't tried it myself),
would be to contact Tivoli (or ADSM.ORG ;-)) for help on tracing the TSM
server, to see if there are any special actions taking place, causing the
reboot. I'm thinking it has to do with something in this direction --> Tsm
Server - TSM Device Driver - Adaptec Driver - Ultrium Driver.  If you can do
a trace, you will perhaps be able to se what the last actions are before
serverdown.


Rgds.
Geirr G. Halvorsen


-Original Message-
From: Kurt Beyers [mailto:[EMAIL PROTECTED]]
Sent: 18. september 2002 18:31
To: [EMAIL PROTECTED]
Subject: Re: TSM 5.1.1 Win2000 server reboot


Hi,

Sorry I couldn't reply any earlier.

I've got some additional info. The server was already at the client since
august. The Adaptec SCSI controller and library were installed in september.
The server was already rebooting several times a day from the beginning,
I've found this in the event log.

So there is definitely a hardware problem causing the reboots and TSM or the
Adaptec SCSI controller can't be the cause. I'll check the Adaptec driver
version tomorrow.

Thanks,
Kurt

- Original Message -
From: "Halvorsen Geirr Gulbrand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 3:10 PM
Subject: Re: TSM 5.1.1 Win2000 server reboot


> Hi Bill,
> I would  very much like to know version data for the Adpatec driver you
are
> using.
>
> Rgds
> Geirr G. Halvorsen
>
>
> -Original Message-
> From: Bill Boyer [mailto:[EMAIL PROTECTED]]
> Sent: 18. september 2002 15:03
> To: [EMAIL PROTECTED]
> Subject: Re: TSM 5.1.1 Win2000 server reboot
>
>
> Adaptec has an updated driver on their site that works great. The default
> driver delivered with Win2k has problems with LTO tape. I haven't seen
> reboot problems, but severe throughput issues to where I would only get
> 1-2GB/hour throughput on the tape drives. Updating to the Adaptec drivers
> (even though the Tivoli support pages say to use the IBM drivers) has
gotten
> me to 1+GB/Minute throughput.
>
> Bill Boyer
> DSS, Inc.
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Halvorsen Geirr Gulbrand
> Sent: Wednesday, September 18, 2002 4:37 AM
> To: [EMAIL PROTECTED]
> Subject: Re: TSM 5.1.1 Win2000 server reboot
>
>
> Hi Kurt,
> I have had a similar problem (maybe the same) with TSM v. 4.2.2 on an IBM
> x342, with adaptec 39160 SCSI controller, and LTO library IBM 3584.
> In my case it rebooted 1-2 times pr. day. I bugged me alot, but seemingly
it
> was a problem with the SCSI Controller Driver on w2k.
> To fix this I made a database backup of TSM, and installed w2k from
scratch,
> then installed the correct driver for the adapter-card (found on
> ftp://ftp.software.ibm.com/storage/devdrvr/Win2000/adaptec_lun.zip),
> reinstalled TSM, and restored the TSM database. I haven't had the problems
> after that. Now, I don't think reinstalling OS should be necessary, but I
> believe the problem is something related to registry settings for device
> adpu160m (the adaptec controller), and when updating this driver, some
> settings still are in registry or some files exist that are not replaced
> when updating the driver.
> Another problem is that because the server goes down unexpectedly, TSM is
> likely to have a corrupted database, and when you get the server to run
OK,
> you should do an AUDITDB on your tsm. (Oh my, this is slow...)
> The other option is to drop your database, and just do the full backup all
> over again.
>
> Hope this helps...
>
> Rgds.
> Geirr G. Halvorsen
>
>
> -Original Message-
> From: Kurt Beyers [mailto:[EMAIL PROTECTED]]
> Sent: 17. september 2002 22:56
> To: [EMAIL PROTECTED]
> Subject: TSM 5.1.1 Win2000 server reboot
>
>
> Hi,
>
> I've just installed TSM 5.1.1 on a Windows 2000 Advanced Server (SP2)
>
> The hardware of the TSM server is:
>
> IBM Netfinity X232 8668 (Pentium 4, 1133 MHz)
> 512 MB RAM
> IBM ServeRAID-4LX Ultra 160 controller (SCSI controller of internal disks)
> IBM LTO library connected via an Adaptec SCSI controller.
>
> During the setup of TSM and the full backup of a number of clients, the
> server has rebooted 6 times. There is no Dr. Watson or what so ever. In
the
> TSM activity log there are also no errors written. You just retrieve the
> latest commands before the shutdown and afterwards the normal startup
> messages of TSM.
>
> Only in the event log, there is an event stating 'An unexpected system
> shutdown has occured'. No other errors or warnings in the event log.
>
> Has anybody else experienced a similar situa

Re: TDP exchange - please help

2002-09-19 Thread Del Hoobler

> I'm having the same problem that Joe had lst year ( see text below )
> Someone gave him the answer but I can't find it on the forum. Can anyone
> please enlighten me.  I think it may be to to with my inclexcl line but
not
> sure...it currently looks like
> include "corwwdsapp04\first storage group\...\*"
>
> I'm running active/passive on win2000 servers. TSM client in 5.1, TDP for
> exchange is 2.2

Chris,

Failure to connect to the Exchange server has nothing to
do with your INCLUDE/EXCLUDE entries. They are used to
determine what gets backed up after connection to the
Exchange server is made.

Are you using the "/EXCSERVer=servername" option?

where "servername" is the "virtual" Exchange cluster server name
For example, if the Exchange cluster server name is "corwwdsapp04",
you should launch a backup of the "First Storage Group" with:

   TDPEXCC BACKUP "First Storage Group" FULL /EXCSERVER=corwwdsapp04

and launch the GUI with:

   TDPEXCC /EXCSERVER=corwwdsapp04

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

- Never cut what can be untied.
- Commit yourself to constant improvement.



Re: LAN-free backup goes SAN, LAN, SAN

2002-09-19 Thread Seay, Paul

Andy,
You may be right about this, but I am betting this is not the case.  The
problem we ran into was that the maxsize was set to a 3GB limit and the
first time a file was hit that was over 3GB the thing puked because it was
trying to go to the next pool which was tape.  The server and the storage
agent would get into a fight over who was going to provide the service and
mount every scratch tape in the library and put them all in the destination
pool empty as privates and read only and get an IO error.

If this fixes this problem, there will be a party in Newport News.  We were
told by support that it was working as designed.  I looked at the APAR in
IBMLINK and there is no sysroute to V4.  Do you happen to know what patch
levels have the problem corrected on Solaris and AIX?

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 3:06 PM
To: [EMAIL PROTECTED]
Subject: Re: LAN-free backup goes SAN, LAN, SAN


You'll find it at:

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/client/
v5r1/Windows/WinNT/v511

The key to finding the code is that PTFs are in the
../tivoli-storage-management/maintenance directory structure, and patches
are in the ../tivoli-storage-management/patches directory structure.

As an addendum to my prior post on this thread, even though it doesn't say
so in the README file, IC33316 is also fixed in 4.2.2.8.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




"Adams, Matt (US - Hermitage)" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/18/2002 11:24
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: LAN-free backup goes SAN, LAN, SAN



Andy,

I just went to the FTP site and didn't find it.  If you get a chance, post
the link or you can respond to me directly.

Thanks,

Matt Adams
Tivoli Storage Manager Team
Hermitage Site Tech
Deloitte & Touche USA LLP



-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 11:54 AM
To: [EMAIL PROTECTED]
Subject: Re: LAN-free backup goes SAN, LAN, SAN


I can not say for sure whether this is your problem, but it could be APAR
IC33316. This problem is fixed in patch level 5.1.1.5 (available now), and
will also be available in PTF 4.2.3 (should be available in the
not-too-distant future). Give 5.1.1.5 a shot and see how it goes.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Zlatko Krastev/ACIT <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/18/2002 09:27
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:LAN-free backup goes SAN, LAN, SAN



Hello all,

If you do not like to read long posts please skip this one - it can be
boring.

I have a very nasty problem at customer site and asking for your help are we
the only having it. If not can we fight it together.
Environment:
Server: v4.2.1.15, Windows 2000 SP2
Client: v4.2.2.1 (was 4.2.1.25), AIX 4.3.3ML09 + patches Storage Agent:
v4.2.1.15, TCP/IP or Shared Memory
SAN: IBM 2108-F16 (Brocade) switch + IBM 3583-L18 (ADIC) LTO with 2 drives
Storage policy: Stgpools use defined volumes and no scratches. Yes, I know
it's very unusual combination (Windows TSM server + AIX nodes). Even support
in the beginning thought it is AIX server w/ Win client.

The node in question is somewhat mixed - small (<50kB) and large (Nx100MB or
1-4GB) files. So for performance small files are directed to go over LAN.
Large files are bound to direct-to-SAN-tape class and storage agent should
take care of them. DIRMC is pointing diskpool as it ought to.

Now the problem:
1. Client starts backup, sent several directories over LAN, on first file
reported ANS1114I and waits server to mount a volume on behalf of storage
agent (OK) 2. Variable number of files are backed up for less than 1% of the
volume mounted (OK) 3. Client reports another ANS1114I (here is the
problem). Under the covers it seems than client requested this and next
several files to go over LAN instead of LAN-free. So mount is performed by
server for its own use (normal MgSysLAN path). 4. Another bunch of files are
backed to second volume. 'Q SES' shows tens of MBs so files go over LAN. 5.
Third ANS1114I

Re: LAN-free backup goes SAN, LAN, SAN

2002-09-19 Thread Andrew Raibeck

Yes, this is a client problem. The IC33316 APAR was opened against the
client. The problem affects 4.2 and 5.1 (the text has been modified to
mention that 4.2 is also affected). I also read your post too quickly, and
missed the point that this was an AIX client, not Windows. My apologies
for the confusion.

For AIX 4.3, client patch levels 4.2.2.5 and 5.1.1.5 contain the fix for
IC33316.

For Windows, client patch levels 4.2.2.8 and 5.1.1.5 contain the fix for
IC33316 (the README for 4.2.2.8 does not mention IC33316, but the fix is
in there).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Zlatko Krastev/ACIT <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/18/2002 23:42
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: LAN-free backup goes SAN, LAN, SAN



Thanks Andy,

you hit the bullseye. IC33316 is the exast problem with one tiny
difference - the longest retention mgmtclass is explicitly defined by
DIRMC option ,-)
The APAR is for ITSM v5.1 only and I cannot find similar one for v4.2. Can
you confirm in which patch it could be fixed for v4.2? Or at least point
which APAR to report to support. I was unable to find it in any of
v4.2.2.8 or above patches. Maybe we have to wait for maintenance 4.2.3.
Upgrade to v5.1 is something I do not want to do right now. Customer is
having very busy schedule implementing new systems, so backups are vital
for the process. Upgrade to v4.2.3 will leave spare move (to 5.1) while
migration to v5.1 will burn the bridges behind us.
I thought this ought to be client-side problem - client decides which
route to follow. IC33316 states it is server problem. Where am I wrong?
Many thanks for your help.

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:

Subject:Re: LAN-free backup goes SAN, LAN, SAN

I can not say for sure whether this is your problem, but it could be APAR
IC33316. This problem is fixed in patch level 5.1.1.5 (available now), and
will also be available in PTF 4.2.3 (should be available in the
not-too-distant future). Give 5.1.1.5 a shot and see how it goes.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



4.2.x selects from DRIVE table

2002-09-19 Thread Jolliff, Dale

Something odd I noticed this morning about 4.2.x servers on AIX and Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?



Re: Select command to q client name and version

2002-09-19 Thread Mark Stapleton

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Karla Ross
> Does anyone have a select command that will show me the clients and what
> version of TSM they are running?  My TSM servers are running TSM
> v4.1, 4.2,
> and 5.1.

select node_name,client_version,client_release,client_level,client_sublevel
from nodes

--
Mark Stapleton ([EMAIL PROTECTED])
Certified TSM consultant
Certified AIX system engineer
MCSE



Re: 4.2.x selects from DRIVE table

2002-09-19 Thread Williams, Tim P {PBSG}

known problem


Item IC33890

  APAR Identifier .. IC33890   Last Changed..02/07/04
  OUTPUT FROM SELECT COMMAND FOR THE DRIVES TABLE WILL NOT RETURN
  A DEVICE VALUE IF THE DEVICE_TYPE IS NOT SPECIFIED/REQUESTED.

  Symptom .. IN INCORROUT Status ... CLOSED  UR1
  Severity ... 4  Date Closed . 02/07/04
  Component .. 5698TSMAX  Duplicate of 
  Reported Release . 420  Fixed Release  999
  Component Name TSM AIX SERVER   Special Notice
  Current Target Date ..  Flags
  SCP ... AIXRSC
  Platform  AIX

  Status Detail: Not Available

  PE PTF List:

  PTF List:
  Release 420   : PTF not available yet


  Parent APAR:
  Child APAR list:


  ERROR DESCRIPTION:
  The output from a select statement against the TSM drives table
  in TSM 4.2 does not return a value in the device column unless
  the device_type is specified in the select command. If select
  * is used the device is returned. If select device_type, device
  is used then the device is returned. Or if device_type is part
  of the where predicate then the device is returned.
  With the code/function changes occuring in the code with the
  introdction of the path defintion the device is returned in
  the select statements from the paths table. In TSM 5.1 this will
  be the only table that the device will be in (it is no longer in
  the drive definition).


  LOCAL FIX:
  Us the paths table to find the device if a select statement
  is needed without specifying the device_type.


  PROBLEM SUMMARY:
  
  * USERS AFFECTED: All Solaris, HP, AIX and Windows 4.2 TSM *
  * users.   *
  
  * PROBLEM DESCRIPTION: DEVICE field does not contain data in   *
  *  the output of a SELECT from the DRIVES  *
  *  table unless the DEVICE_TYPE field is   *
  *  selected either by name or by the use   *
  *  of * to select all fields.  The *
  *  DEVICE_TYPE field does not need to be   *
  *  one of the displayed fields, but it *
  *  does need to be referenced in the   *
  *  SELECT statement for the DEVICE field   *
  *  to contain data.*
  
  * RECOMMENDATION:  *
  
  Make sure to include the DEVICE_TYPE field somewhere in the
  SELECT statment to get the DEVICE field included.  No code
  change is being made for this APAR as in the V5 server the
  DEVICE field is no longer part of the DRIVES table and is only
  available in the PATHS table, and there is a simple
  circumvention to obtain the data in the V4.2 server.


  PROBLEM CONCLUSION:


  TEMPORARY FIX:


  COMMENTS:


  MODULES/MACROS:   NONE


  SRLS:  NONE


  RTN CODES:


  CIRCUMVENTION:


  MESSAGE TO SUBMITTER:


For IBMLink customer support in the U.S, call 1-800-543-3912.

[ IBM Home | Shop | Contact | Search | Priv

-Original Message-
From: David Stabler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 8:26 AM
To: [EMAIL PROTECTED]
Subject: Re: 4.2.x selects from DRIVE table


gotta be a bugit's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.  WEIRD.

-drs-

>>> [EMAIL PROTECTED] 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and
Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on
AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?



Re: 4.2.x selects from DRIVE table

2002-09-19 Thread Mark Stapleton

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Alexander Verkooijen
> I can reproduce this on our 4.2.2.10 (AIX) server.
>
> Hardly WAD or a new feature, I think you found a bug.

(Alexander, reconfigure your email client so your reply-to points to the
ADSM-L mailing list.)

Although I don't have a 4.2 machine to look at, I suspect you've run across
the result of introducting the concept of PATH to TSM. The path table
probably contains the device data you're looking for. (The DRIVES table in
5.1 doesn't even have a DEVICE column; it has a DEVICE_NAME column.)

--
Mark Stapleton ([EMAIL PROTECTED])
Certified TSM consultant
Certified AIX system engineer
MCSE



Schedule Question.

2002-09-19 Thread Gent, Chad E.

Hello All,

NT 4 Client with TSM 4.2.15
Server AIX 4.3.3 TSM 4.2.11.14

I have a client with 2 drives; D: and S:. I need everything on the D: drive
to only be backed up on Fridays.  But I need the S: drive to continue doing
a daily backup.  What is the best way to accomplish this scenario?

1. Create a management class with a frequency of 7 and assign this
management class to the entire D: drive.  But if I use this option how do I
assign the entire D: drive to this management class in my client option
file?
Include "D:" PST_MGMT_CLASS

Or

2.  Is there a way to create a schedule on the Server and have that schedule
use a particular option file on the client?

Thanks
Chad



Re: LAN-free backup goes SAN, LAN, SAN

2002-09-19 Thread Andrew Raibeck

Paul,

Solaris client patch level 4.2.2.7 contains the fix for IC33316. There is
no patch for 5.1 for Solaris.

The APAR will most likely be sysrouted to 4.2 after the fixing PTF (4.2.3)
is available.

As far as your MAXSIZE problem goes, I will try to recreate this
myself but I am hard-pressed to believe that it is WAD. If after
applying the latest patch (and I believe you are pretty current with
server patches, right?) you are still experiencing the problem, you should
reopen the problem with support. If this problem still exists, then an
APAR should be taken, WAD or not, to document the issue.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




"Seay, Paul" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/18/2002 23:52
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: LAN-free backup goes SAN, LAN, SAN



Andy,
You may be right about this, but I am betting this is not the case.  The
problem we ran into was that the maxsize was set to a 3GB limit and the
first time a file was hit that was over 3GB the thing puked because it was
trying to go to the next pool which was tape.  The server and the storage
agent would get into a fight over who was going to provide the service and
mount every scratch tape in the library and put them all in the
destination
pool empty as privates and read only and get an IO error.

If this fixes this problem, there will be a party in Newport News.  We
were
told by support that it was working as designed.  I looked at the APAR in
IBMLINK and there is no sysroute to V4.  Do you happen to know what patch
levels have the problem corrected on Solaris and AIX?

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 3:06 PM
To: [EMAIL PROTECTED]
Subject: Re: LAN-free backup goes SAN, LAN, SAN


You'll find it at:

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/client/
v5r1/Windows/WinNT/v511

The key to finding the code is that PTFs are in the
../tivoli-storage-management/maintenance directory structure, and patches
are in the ../tivoli-storage-management/patches directory structure.

As an addendum to my prior post on this thread, even though it doesn't say
so in the README file, IC33316 is also fixed in 4.2.2.8.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




"Adams, Matt (US - Hermitage)" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/18/2002 11:24
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: LAN-free backup goes SAN, LAN, SAN



Andy,

I just went to the FTP site and didn't find it.  If you get a chance, post
the link or you can respond to me directly.

Thanks,

Matt Adams
Tivoli Storage Manager Team
Hermitage Site Tech
Deloitte & Touche USA LLP



-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 11:54 AM
To: [EMAIL PROTECTED]
Subject: Re: LAN-free backup goes SAN, LAN, SAN


I can not say for sure whether this is your problem, but it could be APAR
IC33316. This problem is fixed in patch level 5.1.1.5 (available now), and
will also be available in PTF 4.2.3 (should be available in the
not-too-distant future). Give 5.1.1.5 a shot and see how it goes.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Zlatko Krastev/ACIT <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/18/2002 09:27
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:LAN-free backup goes SAN, LAN, SAN



Hello all,

If you do not like to read long posts please skip this one - it can be
boring.

I have a very nasty problem at customer site and asking for your help are
we
the only having it. If not can we fight it together.
Environment:
Server: v4.2.1.15, Windows 2000 SP2
Client: v4.2.2.1 (was 4.2.1.25), AIX 4.3.3ML09 + patches Storage Agent:
v4.2.1.15, TCP/IP or 

Re: 4.2.x selects from DRIVE table

2002-09-19 Thread Alexander Verkooijen

On 19-Sep-02 Mark Stapleton wrote:

> (Alexander, reconfigure your email client so your reply-to points to the
> ADSM-L mailing list.)

Unfortunately my rather archaic email software
doesn't allow me to change my reply-to address
for a single message.

Alexander
---
Alexander Verkooijen([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing



Re: LAN-free backup goes SAN, LAN, SAN

2002-09-19 Thread Andrew Raibeck

Zlatko,

The 5.1 client is compatible with 4.2 server and storage agent.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Zlatko Krastev/ACIT <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/19/2002 00:08
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: LAN-free backup goes SAN, LAN, SAN



Paul,

This ought to be like non-Euclidian geometry - Two milleniums
mathmaticians thought there can be only one parallel line and when dropped
this limitation discovered whole new branch in the science :-)
In fact I thought enablelanfree allows client to have conversation with
more than one server - real TSM server and local STA. And management class
bindings direct which route to follow. Now I have to read the fine print
again ,-)
It works fine till now and the result is as I thought it ought to - files
bound to disk class go over LAN and files bound to SAN-tape class go
LAN-free.
I will dig deeper and on success will let you know.
Another question pops up in my head (again on the edge of non-supported :)
- What if I try to use v5.1 client and v4.2.1 storage agent? Have to read
carefully compatibility matrix - v5.1 client is supported with v4.2.1
server, storage agent is same version as the server, nothing said about
what I intend to use ...
Any ideas (Andy?)

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:

Subject:Re: LAN-free backup goes SAN, LAN, SAN

Zlatko,
I am actually surprised you even got this to work.  When you define in
DSM.SYS as LANFREE it has to go directly to tape for everything you are
backing up with that node.  Nothing can go to a disk pool.  So, you have
to
define multiple stanzas in dsm.sys and multiple dsm.opt files.  Now that
you
have multiple nodes you see the sticky wicket.  You can not send the DIRMC
to a disk pool and the data to a tape pool.

We tried what you did and occassionally got what you have seen, but more
often than not, complete failure.

If you find out that there is a way to make it work, I would like to know
how.  I do not remember where the fine print is buried on this
restriction,
but it is a known restriction.

You have to think of LANFREE as sending the data to an alternate TSM
server
on your local machine that shares the library with the TSM Server owning
the
library, but fakes out the fact that the database is on the TSM Server
owning the library.  A node can only form a session with one TSM server at
a
time.  This is why the TDP for SAP R3 supports a parallel session
capability
that can define more than one node so that you can actually send data to
several TSM server addresses simultaneously.  Typically, they are just
multiple adapters on a single TSM server, but they could be multiple TSM
servers.

I hope that makes sense, what I just said.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Zlatko Krastev/ACIT [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 12:27 PM
To: [EMAIL PROTECTED]
Subject: LAN-free backup goes SAN, LAN, SAN


Hello all,

If you do not like to read long posts please skip this one - it can be
boring.

I have a very nasty problem at customer site and asking for your help are
we
the only having it. If not can we fight it together.
Environment:
Server: v4.2.1.15, Windows 2000 SP2
Client: v4.2.2.1 (was 4.2.1.25), AIX 4.3.3ML09 + patches Storage Agent:
v4.2.1.15, TCP/IP or Shared Memory
SAN: IBM 2108-F16 (Brocade) switch + IBM 3583-L18 (ADIC) LTO with 2 drives
Storage policy: Stgpools use defined volumes and no scratches. Yes, I know
it's very unusual combination (Windows TSM server + AIX nodes). Even
support
in the beginning thought it is AIX server w/ Win client.

The node in question is somewhat mixed - small (<50kB) and large (Nx100MB
or
1-4GB) files. So for performance small files are directed to go over LAN.
Large files are bound to direct-to-SAN-tape class and storage agent should
take care of them. DIRMC is pointing diskpool as it ought to.

Now the problem:
1. Client starts backup, sent several directories over LAN, on first file
reported ANS1114I and waits server to mount a volume on behalf of storage
agent (OK) 2. Variable number of files are backed up for less than 1% of
the
volume mounted (OK) 3. Client reports another ANS1114I (here is the
problem). Under the covers it seems than client requested this and next
several files to go over LAN instead of LAN-free. So mount is performed by
server for its own use (normal MgSysLAN path). 4. Another 

Re: Select command to q client name and version

2002-09-19 Thread Cook, Dwight E

I use

select
node_name,platform_name,client_os_level,client_version,client_release,client
_level,client_sublevel from adsm.nodes

and you can add in a :
where client_version<>4 AND client_release<>2 AND client_level<>2
if you want to see nodes not at a specific vrlm...

Dwight E. Cook
Software Application Engineer III
Science Applications International Corporation
509 S. Boston Ave.  Suite 220
Tulsa, Oklahoma 74103-4606
Office (918) 732-7109



-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 8:08 AM
To: [EMAIL PROTECTED]
Subject: Select command to q client name and version


Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross



Réf. : Select command to q client name and version

2002-09-19 Thread Guillaume Gilbert

Hi Karla

Here is what I use :

select platform_name,node_name,-
cast(client_version as char(1))||'.'||cast(client_release as char(1))||-
'.'||cast(client_level as char(1))||'.'||cast(client_sublevel as char(2)) -
as "Version" -
from nodes order by platform_name,node_name

Guillaume Gilbert
CGI Canada




Karla Ross <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-09-19 09:08:08

Veuillez répondre à "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Envoyé par :   "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


Pour :[EMAIL PROTECTED]
cc :
Objet :   Select command to q client name and version

Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross






binding WWN and SCSI on NT with QLOGIC

2002-09-19 Thread Jason Livie

Greetings,

Is there a way to permanently bind a WWN address to a SCIS ID in w2K with a
QLOGIC QLA2200. If so, what is the utility available and the driver version
necessary for this. We are currently using driver version 8.1.5.60 on a
QLA2200 and W2K.

There seems to be a problem whenever the SAN "glitches", the drive
attribution on NT changes from the original setting, therefore our
drivemapping on TSM is no longer valid in our lanfree environment.

sincerely,

Jason Livie
e-Business Process/Storage Team - Service Delivery
IBM Global Services - La Gaude
Tél.: 04 9211 5943 - email : [EMAIL PROTECTED]


Re: 3584 tape questions

2002-09-19 Thread Orville Lantto

>From the IBM Ultrium Setup and Operators Guide

"The IBM LTO Ultrium Data Cartridge includes a Linear Tape-Open Cartridge
Memory (LTO-CM) chip, which contains information about the cartridge and 
the tape
(such as the name of the manufacturer that created the tape), as well as 
statistical
information about the cartridge's use. Whenever you unload a tape 
cartridge, the
tape library writes any pertinent information to the cartridge memory."

Maybe the volser is in the chip.


Orville L. Lantto
Datatrend Technologies, Inc.  (http://www.datatrend.com)
IBM Premier Business Partner
121 Cheshire Lane, Suite 700
Minnetonka, MN 55305
Email: [EMAIL PROTECTED]





Dan Foster <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/18/2002 09:25 PM
Please respond to "ADSM: Dist Stor Manager"

 
To: [EMAIL PROTECTED]
cc: 
Subject:3584 tape questions


I've finally got the new 3584 library up and worked through all hardware
and TSM issues, and just finished with the first round of successful 
tests.
Looks sharp! Currently tuning the setup (disk, memory, network, TSM, etc).

Environment: AIX 4.3.3 ML10, pSeries 660-6H1, TSM 4.2 (5.1 next week)
to 4.2.2.12, SCSI attachment to host, 3584-L32 and 3584-D32 frames.

Two questions about 3584 tapes --

1. Is it normal for it to take 45 seconds to read/verify the
   label on the tape? The tape load itself is pretty quick, but
   takes forever-and-an-half to read/verify the label.

2. There's two label sources -- one is the barcode scanner, which
   works great and *very* quick, and it seems the other label
   source is on the tape somewhere.

   Where exactly on the tape is the label preserved, other than 
the
   volser bar code label? Is it in the LTO-CM area of the tape? Or
   is it on the first part of the tape, or something?

   I'm curious about this because the implications is that if I
   do destructive read-write tests with tapes involving overwrite,
   I might potentially overwrite the label, and have to relabel 
it?

   The documentation suggests that 'LABEL LIBVOL' for a 3584 would
   update label in the LTO-CM area of the tape cartridge, but it
   isn't real definite or clear on that point.

-Dan



serverfree - lanfree ?

2002-09-19 Thread chris rees

Hi All

Can someone please explain the difference between serverfree and lanfree
backup?

My understanding is that LAN free still involves the clients they just send
their data over the SAN, and Serverfree uses some method to backup without
involving the client.

What software/clients/agents do you need to achieve both of these solutions?

Working on a big implementation at the moment, including win2000, HSM, 2000
clusters, Exchange clusters new SAN, new storage etc etc etc.  I think you
going to be hearing a lot from me over the next couple of months, ! !!

Chris



Have a look at http://www.geocities.com/rees_chris


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com



Problem with EXPORT

2002-09-19 Thread Zoltan Forray/AC/VCU

Trying to EXPORT a node.  Process runs for a while and then get an error:

09/19/2002 10:09:55   ANR2017I Administrator ZFORRAY issued command:
EXPORT NODE ATLAS.VCU.EDU FILEDATA=ALL PREVIEW=NO DEVCLASS=CART3590
SCRATCH=YES

...


09/19/2002 10:31:18   ANRD AFCPUTIL(1677): Row not found for bitfile
0.5885060.
09/19/2002 10:33:40   ANR1361I Output volume 041322 closed.
09/19/2002 10:33:40   ANR5208I Dismounting volume 041322 (updated).
09/19/2002 10:33:40   ANR5228I Deleting 3590 041322 from volume history
(EXPORT volume).
09/19/2002 10:33:40   ANR0728E EXPORT NODE: Processing terminated
abnormally - internal error.
09/19/2002 10:33:40   ANR0626I EXPORT NODE: Copied 1 node definitions.
09/19/2002 10:33:40   ANR0627I EXPORT NODE: Copied 13 file space 36495
archive files, 59527 backup files, and 0 space managed files.
09/19/2002 10:33:40   ANR0629I EXPORT NODE: Copied 22899049 bytes of data.

09/19/2002 10:33:40   ANR0611I EXPORT NODE started by ZFORRAY as process
75 has ended.
09/19/2002 10:33:40   ANR0986I Process 75 for EXPORT NODE running in the
BACKGROUND processed 96036 items for a total of 22,899,049 bytes with a
completion state of FAILURE at 10:33:40.

There are a *LOT* more files to export:  Q OCC shows more than 200K files


What gives ?How do I resolve this ? Would an AUDIT OCC fix it ?

TSM server is on OS390 - V4.1.4  (waiting for final PTF's for 4.2.2.)



How can I tell when an archive was performed?

2002-09-19 Thread Michael Moore

We do little to no archiving, we tested with it in the past, but our
infrastructure cannot support full archives on the nodes required.  But,
someone has done some archiving, other that what we tested with.

I cannot tell by looking at the filespace, due to the fact that the node is
backed up daily.

How can I tell when this took place?

Thanks!!

Michael Moore
VF Services Inc.
121 Smith Street
Greensboro,  NC  27420-1488

Voice: 336-332-4423
Fax: 336-332-4544



tsm solaris client error

2002-09-19 Thread Justin Bleistein

Has anyone ever seen these errors before our could elaborate on what they
could be or how they could be fixed? Thanks:

I logged into the client system and found the following error in the client
error log:

09/16/02   23:36:42 TcpRead(): recv(): errno = 131
09/17/02   00:36:42 sessRecvVerb: Error -50 from call to 'readRtn'.
09/17/02   00:36:42 cuFSUpd: Received rc: -50 trying to read a EndTxn verb

--Justin Richard Bleistein



Select for Scratches

2002-09-19 Thread Lars Bebensee

Hi folks,

I am not that good with select queries yes, so I will have to ask one of
the SQL gurus here:
we wanted to show how many scratch tapes each library has with a query like
this:

"select a.library_name,count(*) as volumes, b.devtype from libvolumes as a,
devclasses as b where upper(status) like 'SCRATCH%' and a.library_name='$i'
and a.library_name=b.library_name group by a.library_name,b.devtype"

$i will be filled with the name of the library before. The funny thing, it
shows exactly as twice as many scratches. Is there someone amongst you who
can exctract this little monster for me and show me what I am doing wrong.

Thanks for helping out

Lars



Re: serverfree - lanfree ?

2002-09-19 Thread Joshua Bassi

LAN-free backup sends data across the FC SAN.
Serverless backup sends data directly from the storage (ESS or EMC
today) server to the tape drive bypassing the client and only sending
meta-data to the TSM server.

To run either of these backup methodologies I would recommend being on
the latest and greatest versions of the TSM client and server (5.1.1.x).


--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
Tivoli Certified Consultant - ADSM/TSM
eServer Systems Expert -pSeries HACMP

AIX, HACMP, Storage, TSM Consultant
Cell (831) 595-3962
[EMAIL PROTECTED]


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of
chris rees
Sent: Thursday, September 19, 2002 8:38 AM
To: [EMAIL PROTECTED]
Subject: serverfree - lanfree ?

Hi All

Can someone please explain the difference between serverfree and lanfree
backup?

My understanding is that LAN free still involves the clients they just
send
their data over the SAN, and Serverfree uses some method to backup
without
involving the client.

What software/clients/agents do you need to achieve both of these
solutions?

Working on a big implementation at the moment, including win2000, HSM,
2000
clusters, Exchange clusters new SAN, new storage etc etc etc.  I think
you
going to be hearing a lot from me over the next couple of months, ! !!

Chris



Have a look at http://www.geocities.com/rees_chris


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com



Re: How can I tell when an archive was performed?

2002-09-19 Thread Mr. Lindsay Morris

If you have the accounting log (...server/bin/dsmaccnt.log) reaching that
far back (and it does not prune itself automatically, so you probably do, if
you have accounting turned on at all),
then you can awk your way through that looking for the KB-archived field
being non-zero.

Or maybe, from the client, you could just say "q arch..."?

-
Mr. Lindsay Morris
Lead Architect, Servergraph
859-253-8000 ofc
425-988-8478 fax


> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Michael Moore
> Sent: Thursday, September 19, 2002 1:06 PM
> To: [EMAIL PROTECTED]
> Subject: How can I tell when an archive was performed?
>
>
> We do little to no archiving, we tested with it in the past, but our
> infrastructure cannot support full archives on the nodes required.  But,
> someone has done some archiving, other that what we tested with.
>
> I cannot tell by looking at the filespace, due to the fact that
> the node is
> backed up daily.
>
> How can I tell when this took place?
>
> Thanks!!
>
> Michael Moore
> VF Services Inc.
> 121 Smith Street
> Greensboro,  NC  27420-1488
>
> Voice: 336-332-4423
> Fax: 336-332-4544
>



Re: Select command to q client name and version

2002-09-19 Thread Karla Ross

This worked great!  Thanks for all the replys.

Karla Ross


-- Forwarded by Karla Ross/St Louis/IBM on 09/19/2002
01:26 PM ---

Hussein Abdirahman <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
09/19/2002 08:34:10 AM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:[EMAIL PROTECTED]
cc:
Subject:Re: Select command to q client name and version



Hi Carla;

Try this. I got this from group.
It will also display the OS versions.



select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as char(2)) || '.' -
|| cast(client_release as char(2)) || '.' -
|| cast(client_level as char(2)) || '.' -
|| cast(client_sublevel as char(2)) -
as char(15)) as "Client" -
from nodes -
order by platform_name, "Client", Node

regrds;
Hussein M. Abdirahman
UNIX Administrator





-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:08 AM
To: [EMAIL PROTECTED]
Subject: Select command to q client name and version


Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross



Re: netware dsmcad sessions hung

2002-09-19 Thread Christo Heuer

Hi Tim,

I have the same problem on NT servers - I started using the
dsmcad on NT - but because of the problems with the
managedservices I never rolled it out to other servers
Are you on 4.1.2?
You should go to 4.2.2 - that seems to be more stable as far
as the DSMCAD is concerned.

Regards
Christo



netware tsm client dsmcad is loaded but backup never runs
i have to unload and reload dsmcad to force the next backup
anybody ever see this problem

Next operation scheduled:

Schedule Name: NETWARE_MON
Action:Incremental
Objects:
Options:
Server Window Start:   22:00:00 on 09/16/2002

Waiting to be contacted by the server.

backup should of run at 22:00:00 on 09/16/2002

tsm server 5.1.1
netware client 5.1.0

netware cleint options

MANAGEDSERVICES WEBCLIENT SCHEDULE
SCHEDMODE  PROMPTED

Tim Brown
Systems Specialist
Central Hudson Gas & Electric
284 South Avenue
Poughkeepsie, NY 12601

Phone: 845-486-5643
Fax: 845-486-5921
Pager: 845-455-6985

[EMAIL PROTECTED]
__
"The information contained in this communication is confidential and
may be legally privileged.  It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it.  If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking action
in reliance of the contents of this information is strictly prohibited
and may be unlawful.  Absa is liable neither for the proper, complete
transmission of the information contained in this communication, nor
for any delay in its receipt, nor for the assurance that it is
virus-free."



Re: Select for Scratches

2002-09-19 Thread Slaughter, Bill

I run something similar every day.

I have 1 devclass per library and the command works fine without duplicating
the count of scratch tapes.

Do you have multiple device classes in the same library? My scratch are not
assigned to a specific device class they are scratch for the entire library.

If you don't require the deviceclass in the output you could simplify:

"select library_name, count(*) as volumes from libvolumes
where upper(status) like 'SCRATCH%' and library_name='$i'
group by library_name"


You could also improve the scratch query by changing

upper(status) like 'SCRATCH%'

to

status='Scratch'

I hope this helps.

Bill


-Original Message-
From: Lars Bebensee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:35 AM
To: [EMAIL PROTECTED]
Subject: Select for Scratches

Hi folks,

I am not that good with select queries yes, so I will have to ask one of
the SQL gurus here:
we wanted to show how many scratch tapes each library has with a query like
this:

"select a.library_name,count(*) as volumes, b.devtype from libvolumes as a,
devclasses as b where upper(status) like 'SCRATCH%' and a.library_name='$i'
and a.library_name=b.library_name group by a.library_name,b.devtype"

$i will be filled with the name of the library before. The funny thing, it
shows exactly as twice as many scratches. Is there someone amongst you who
can exctract this little monster for me and show me what I am doing wrong.

Thanks for helping out

Lars



Re: How can I tell when an archive was performed?

2002-09-19 Thread Michael Moore

Unfortunately, I don't have access to the clients.  So, I am trying to get
this information via the server.

Michael Moore
VF Services Inc.
121 Smith Street
Greensboro,  NC  27420-1488

Voice: 336-332-4423
Fax: 336-332-4544




  "Mr. Lindsay
  Morris"  To:   [EMAIL PROTECTED]
   Subject:  Re: How can I tell when an 
archive was performed?
  Sent by: "ADSM:
  Dist Stor
  Manager"
  <[EMAIL PROTECTED]
  .EDU>


  09/19/02 02:04 PM
  Please respond to
  lmorris






If you have the accounting log (...server/bin/dsmaccnt.log) reaching that
far back (and it does not prune itself automatically, so you probably do,
if
you have accounting turned on at all),
then you can awk your way through that looking for the KB-archived field
being non-zero.

Or maybe, from the client, you could just say "q arch..."?

-
Mr. Lindsay Morris
Lead Architect, Servergraph
859-253-8000 ofc
425-988-8478 fax


> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Michael Moore
> Sent: Thursday, September 19, 2002 1:06 PM
> To: [EMAIL PROTECTED]
> Subject: How can I tell when an archive was performed?
>
>
> We do little to no archiving, we tested with it in the past, but our
> infrastructure cannot support full archives on the nodes required.  But,
> someone has done some archiving, other that what we tested with.
>
> I cannot tell by looking at the filespace, due to the fact that
> the node is
> backed up daily.
>
> How can I tell when this took place?
>
> Thanks!!
>
> Michael Moore
> VF Services Inc.
> 121 Smith Street
> Greensboro,  NC  27420-1488
>
> Voice: 336-332-4423
> Fax: 336-332-4544
>



Re: 3584 tape questions

2002-09-19 Thread David Longo

1.  I have 3584-L32 with FC-AL drives.  Yes I think that time is normal.

It includes mounting and reading label.  The fast mount  you mention
is
the Robot putting tape in drive.  It takes much longer for a tape to
actually be "mounted" as viewed by "q mount" or by "q proesss" and
seeing how long it's waiting for mount.

2.  You have to use "Label Libvol" for each new tape.  I believe the
"label"
is written in header of tape like other tape formats.  Maybe it's in
the
LTO-CM also.  Yes, it is possible to overwrite the tape - though not
likely
in "normal" operations.

David Longo

>>> [EMAIL PROTECTED] 09/18/02 10:25PM >>>
I've finally got the new 3584 library up and worked through all
hardware
and TSM issues, and just finished with the first round of successful
tests.
Looks sharp! Currently tuning the setup (disk, memory, network, TSM,
etc).

Environment: AIX 4.3.3 ML10, pSeries 660-6H1, TSM 4.2 (5.1 next week)
to 4.2.2.12, SCSI attachment to host, 3584-L32 and 3584-D32 frames.

Two questions about 3584 tapes --

1. Is it normal for it to take 45 seconds to read/verify the
   label on the tape? The tape load itself is pretty quick,
but
   takes forever-and-an-half to read/verify the label.

2. There's two label sources -- one is the barcode scanner,
which
   works great and *very* quick, and it seems the other label
   source is on the tape somewhere.

   Where exactly on the tape is the label preserved, other than
the
   volser bar code label? Is it in the LTO-CM area of the tape?
Or
   is it on the first part of the tape, or something?

   I'm curious about this because the implications is that if
I
   do destructive read-write tests with tapes involving
overwrite,
   I might potentially overwrite the label, and have to relabel
it?

   The documentation suggests that 'LABEL LIBVOL' for a 3584
would
   update label in the LTO-CM area of the tape cartridge, but
it
   isn't real definite or clear on that point.

-Dan


"MMS " made the following
 annotations on 09/19/2002 01:21:29 PM
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

==



How to find obsolete filespaces?

2002-09-19 Thread Gerhard Rentschler

Hi,
filespaces which no longer exist on the node will stay on the server
forever. As they may consume considerable resources on tape and in the
database, we regularly try to find such filespaces and ask the owner whether
they can be deleted or not. We use the field "Last Backup Start date/time"
of "q filespace f=d" or the corresponding field in the filespaces table.
Unfortunately, I learned from responses to a mail earlier this week that
this field is not always updated (for example not by selective backups).
Is there another way to find out obsolete filespaces?
Best regards
Gerhard

---
Gerhard Rentschleremail:[EMAIL PROTECTED]
Regional Computing Center tel.   ++49/711/685 5806
University of Stuttgart   fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany



Re: Select command to q client name and version

2002-09-19 Thread Karla Ross

This works great, thanks for all the replays.

Karla Ross




Hussein Abdirahman <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
09/19/2002 08:34:10 AM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:[EMAIL PROTECTED]
cc:
Subject:Re: Select command to q client name and version



Hi Carla;

Try this. I got this from group.
It will also display the OS versions.



select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as char(2)) || '.' -
|| cast(client_release as char(2)) || '.' -
|| cast(client_level as char(2)) || '.' -
|| cast(client_sublevel as char(2)) -
as char(15)) as "Client" -
from nodes -
order by platform_name, "Client", Node

regrds;
Hussein M. Abdirahman
UNIX Administrator





-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:08 AM
To: [EMAIL PROTECTED]
Subject: Select command to q client name and version


Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross



Problem deleting filespace SYSTEM OBJECT

2002-09-19 Thread Gerhard Rentschler

Hello,
I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3.
Using the command
del filespace rus_zsdsinz 'SYSTEM OBJECT'
I get the following messages in the activity log:
09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in
the
   BACKGROUND at 16:20:33.
09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node
RUS_ZSDSINZ
   started as process 452.
09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive
data)
   for node RUS_ZSDSINZ started.
09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId<84> Error 1123
deleting
   group leader 0 585684848.
09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in
the
   BACKGROUND completed with completion state FAILURE at
   16:20:34.
I opened a PMR. Level 1 suggested to run the command "cleanup backupgroup"
and retry the delete filespace command. It didn't help. The next advice was
to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del
filespace. The next thing to do would be a dsmserv auditdb. However, this
would take a lot of time with my 55 GB database.

Has anyone else seen this? Level 1 told me that he found only one similar
problem.
Best regards
Gerhard
---
Gerhard Rentschleremail:[EMAIL PROTECTED]
Regional Computing Center tel.   ++49/711/685 5806
University of Stuttgart   fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany



Re: Client install on Unix (Also running TDP for Oracle)

2002-09-19 Thread Neil Rasmussen

Mark,

libApiDS.so is the TSM API library which is also part of the BA Client
package. When you removed the BA Client with 'pkgrm', you also removed the
TSM API library. TDP Oracle has a dependency on the TSM API library to
communicate with the TSM Server. Essentially, the rug was just pulled out
from under Oracle. What needs to be done to fix this is to make sure all
the links are in their proper places. With all Oracle/Rman instances
shutdown (including listener), check that the following links are in
place:

(I will assume 32bit)

$ORACLE_HOME/lib/libobk.so -> /usr/lib/libobk.so
/usr/lib/libobk.so -> /opt/tivoli/tsm/client/oracle/bin/libobk.so
(Make sure the libobk.so file exists in /opt/tivoli/tsm/client/oracle/bin
)


/usr/lib/libApiDS.so -> /opt/tivoli/tsm/client/api/bin/libApiDS.so
(Make sure the libApiDS.so file exists /opt/tivoli/tsm/client/api/bin )

You may want to run the command: # /usr/ccs/bin/what /usr/lib/libApiDS.so
| more

This should tell you that this link is pointing to a valid TSM API and it
will give you the version of the API. Since you upgraded client to 5.1,
the API should have been upgraded as well, and the 'what' command should
reflect this. If you find the TSM API is not installed you can reinstall
the BA Client package and only select the API for that installation. Hope
this helps.



--

Date:Wed, 18 Sep 2002 15:00:44 -0500
From:Mark Hayden <[EMAIL PROTECTED]>
Subject: Client install on Unix (Also running TDP for Oracle)

Question, we just finished installing just the client on a Unix machine =
running Solaris 8. We upgraded the client to TSM 5.1 When we did the PKGRM
=
for just the Tivoli client software, (did not remove the TDP for Oracle) =
we noticed that we could not bring the Oracle DB back up. It was looking =
for a file called libApiDS.so which is located in the API/BIN directory of
=
the client. So when we removed the TSM software, we started to get the =
error. My question, does anyone know why and what this file is used =
for Below is the actual error.

ld.so.1: oracleorap: fatal: libApiDS.so: open failed: No such file or =
directory
ERROR:
ORA-12547: TNS:lost contact


Thanks, Mark Hayden
Informations Systems Analyst
E-Mail:  [EMAIL PROTECTED]

--


Regards,

Neil Rasmussen
Software Development
TDP for Oracle
[EMAIL PROTECTED]



Réf. : RE: Réf. : Re: Backup reporting

2002-09-19 Thread Guillaume Gilbert

Unfortunatly I do not speak PERL but I guess I'll have to learn it if the summary 
table is FUBAR.

Guillaume




Bill Boyer <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-09-18 15:45:37

Veuillez répondre à "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Envoyé par :   "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


Pour :[EMAIL PROTECTED]
cc :
Objet :   RE: Réf. : Re: Backup reporting

I believe that this only affects the summary table data, not the accounting
records. The accounting records are correct in the byte counts. I know you
can't get it with a simple SQL, but it's there. Can you speak PERL??

Bill

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Guillaume Gilbert
Sent: Wednesday, September 18, 2002 3:27 PM
To: [EMAIL PROTECTED]
Subject: Rif. : Re: Backup reporting


I'm at level 4.2.2.12 of the server on AIX and the summary table problems
are still there. I am currently writing a PMR on this.

Guillaume Gilbert
CGI Canada




Bill Boyer <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-09-18 15:10:13

Veuillez ripondre ` "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

Envoyi par :   "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


Pour :[EMAIL PROTECTED]
cc :
Objet :   Re: Backup reporting

There was a problem where the bytes transferred in the summary table as
zero. It has been fixed in later patch levels. I'm not sure what the APAR
number is or the level where it was fixed.

If you need this data, turn on the accounting records. There is an
additional field "Amount of backup files, in kilobytes, sent by the client
to the server" in addition to the "Amount of data, in kilobytes,
communicated between the client node and the server during the session". The
bytes communicated is the total bytes transferred and includes and
re-transmissions/retries. I believe the "Amount of backup files, in
kilobytes, sent by the client to the server" is just what was sent AND
stored in TSM.

I haven't fully looked into this, but if I'm trying to get a total for the
amount of data backed up I would be using this field as opposed to the bytes
transmitted field. Something for me to add to my Honey-Do list..:-)

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Mark Bertrand
Sent: Wednesday, September 18, 2002 2:39 PM
To: [EMAIL PROTECTED]
Subject: Re: Backup reporting


Paul and all,

When I attempt to use any of the following select statements my "Total MB"
returned is always 0. I get my list of nodes but there is never any numbers
for size.

Since this is my first attempt at select statements, I am sure I doing
something wrong. I have tried from command line and through macro's.

I am trying this on a W2K TSM v4.2.2 server.

Thanks,
Mark B.

-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 16, 2002 11:43 PM
To: [EMAIL PROTECTED]
Subject: Re: Backup reporting


See if these will help:

/* SQL Script:   */
/*   */
/* backup_volume_last_24hours.sql*/
/* Date   Description*/
/* 2002-06-10 PDS Created*/

/* Create Report of total MBs per each session */

select entity as "Node Name  ", cast(bytes/1024/1024 as decimal(10,3))
as "Total MB  ",  cast(substr(cast(end_time-start_time as char(17)),3,8) as
char(8)) as "Elapsed  ", substr(cast(start_time as  char(26)),1,19) as
"Date/Time  ", case when cast((end_time-start_time) seconds as
decimal) >0 then  cast(bytes/cast((end_time-start_time) seconds as
decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as  "
MB/Sec" from summary where start_time>=current_timestamp - 1 day and
activity='BACKUP'

/* Create Report of total MBs and length of backup for each node */

select entity as "Node Name  ", cast(sum(bytes/1024/1024) as
decimal(10,3)) as "Total MB",  substr(cast(min(start_time) as
char(26)),1,19) as "Date/Time   ",
cast(substr(cast(max(end_time)-min(start_time)  as char(20)),3,8) as
char(8)) as "Length   " from summary where start_time>=current_timestamp -
22 hours and  activity='BACKUP' group by entity

/* Create Report of total backed up*/

select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup"
from summary where start_time>=current_timestamp  - 1 day and
activity='BACKUP'



=






Re: How can I tell when an archive was performed?

2002-09-19 Thread Fred Johanson

Select * from archives where node_name=nodename


At 01:05 PM 9/19/2002 -0400, you wrote:
>We do little to no archiving, we tested with it in the past, but our
>infrastructure cannot support full archives on the nodes required.  But,
>someone has done some archiving, other that what we tested with.
>
>I cannot tell by looking at the filespace, due to the fact that the node is
>backed up daily.
>
>How can I tell when this took place?
>
>Thanks!!
>
>Michael Moore
>VF Services Inc.
>121 Smith Street
>Greensboro,  NC  27420-1488
>
>Voice: 336-332-4423
>Fax: 336-332-4544



Re: Online Oracle 7.x Backup Techniques

2002-09-19 Thread Joshua Bassi

Roy,

What exactly are these scripts doing to allow for hot backups?  Did you
integrate them with EBU and the TSM API or what?  Would you mind sharing
what you have?

--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
Tivoli Certified Consultant - ADSM/TSM
eServer Systems Expert -pSeries HACMP
AIX, HACMP, Storage, TSM Consultant
Cell (831) 595-3962
[EMAIL PROTECTED]



NAS backups (netapp)

2002-09-19 Thread Chetan H. Ravnikar

Folks Hi,

I understand NAS backups with NDMP have been talked in general in
this group.

I had a specifics with Netapp filers and their NDMP and wanted to know, if
people had an idea..

I was reading an internal Netapp docuement which was not official yet!
which said

TIVOLI 5.1 w/NDMP certified on filers with Data ONTAP 6.2
and the following support is provided with 5.1

1. local backup from filers to tape drives or libs
   * full & incremental backups and restores
  * library control from server or from file via NDMP
2. Dynamic drive sharing
3. Choice of interface to initate, monitor or cncel backup & restore
operations
  * web client
  * backup archive cmd line client

THe following functions are NOT supported in TSM 5.1 -Tivoli data
protection for NDMP

* filer to filer
* filer to server
* server to filer
* direct access restore (DAR functionality will be added Q1CY 2003)
* linux platform support
* detection of damaaged files
* data-trasnfer operation for NAS data stored by TSM

can somebody comment on these.

Cheers..



Re: How can I tell when an archive was performed?

2002-09-19 Thread Andrew Raibeck

Try looking at the SUMMARY and/or ARCHIVES table in the database:

   select * from summary where activity='ARCHIVE'

You can also look at the ARCHIVES table, maybe something like this:

   set sqldisplaymode wide
   select date(archive_date) as DATE, time(archive_date) as TIME,
  filespace_name || hl_name || ll_name as "FILE NAME"
  from archives

If you are interested strictly in the date(s), then you could do something
like this:

   select distinct archive_date from archives order by archive_date

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Michael Moore <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/19/2002 11:36
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: How can I tell when an archive was performed?



Unfortunately, I don't have access to the clients.  So, I am trying to get
this information via the server.

Michael Moore
VF Services Inc.
121 Smith Street
Greensboro,  NC  27420-1488

Voice: 336-332-4423
Fax: 336-332-4544




  "Mr. Lindsay
  Morris"  To: [EMAIL PROTECTED]
   Subject:  Re: How can I
tell when an archive was performed?
  Sent by: "ADSM:
  Dist Stor
  Manager"
  <[EMAIL PROTECTED]
  .EDU>


  09/19/02 02:04 PM
  Please respond to
  lmorris






If you have the accounting log (...server/bin/dsmaccnt.log) reaching that
far back (and it does not prune itself automatically, so you probably do,
if
you have accounting turned on at all),
then you can awk your way through that looking for the KB-archived field
being non-zero.

Or maybe, from the client, you could just say "q arch..."?

-
Mr. Lindsay Morris
Lead Architect, Servergraph
859-253-8000 ofc
425-988-8478 fax


> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Michael Moore
> Sent: Thursday, September 19, 2002 1:06 PM
> To: [EMAIL PROTECTED]
> Subject: How can I tell when an archive was performed?
>
>
> We do little to no archiving, we tested with it in the past, but our
> infrastructure cannot support full archives on the nodes required.  But,
> someone has done some archiving, other that what we tested with.
>
> I cannot tell by looking at the filespace, due to the fact that
> the node is
> backed up daily.
>
> How can I tell when this took place?
>
> Thanks!!
>
> Michael Moore
> VF Services Inc.
> 121 Smith Street
> Greensboro,  NC  27420-1488
>
> Voice: 336-332-4423
> Fax: 336-332-4544
>



reconstruct=yes overhead?

2002-09-19 Thread David E Ehresman

Anyone have data on how much overhead reconstruct=yes on a move nodedata
adds to the run time?

David



3494 and LAN-free backup

2002-09-19 Thread Eliza Lau

Hello all,

I am trying to set up LAN-free backup on my TSM 4.2.1.15 AIX server and
Solaris 8 client with no success.
I first added to /usr/tivoli/tsm/server/bin/dsmserv.opt:
   3494shared yes

Restarted the server.

> define server theclient serverpassword= hladdress=x.x.x.x lladdress=1500
> define drivemapping theclient 3494lib tapedrive1 device=/dev/rmt/1st online=yes

But got an error message that says the library is not shared.

dsmadmc > update library 3494lib shared=yes

Define drivemapping now works.

My first question is:  Is the "3494shared yes" option necessary?


The client's management class is set up to backup directly to tape.
We then proceeded to set up the client and all went well.  After the first
test, LAN-free backup didn't work and LAN backup kicked in.  It mounted
the tape 301405 and backed up some files.  Now 301405 is not accessable
on the TSM server. I tried a 'move data 301405' and got an error that
the tape is not accessable.  The tape is in the 3494 libary with access=readw.
I can check it out and check it back in.
It appears that TSM server thinks that 301405 belongs to another server
that it cannot mount.

If you are running LAN-free backups, could you post your client's
dsm.sys, dsm.opt and dsmsta.opt?

server: 4.2.1.15 on AIX 4.3.3
client: 4.2.2.1 on Solaris 8
storage agent : SUN 4.2.1.14

Thanks,
Eliza Lau
Virginia Tech Computing Center
Blacksburg, VA 24060
[EMAIL PROTECTED]



other solution ?'s

2002-09-19 Thread Coviello, Paul

I just received in the mail a letter from a company call Vyant technologies.
www.vyanttech.com
has anyone heard of them and or know what exactly they are selling?
outside of guaranteeing a restore of data within 20 min's regardless of
size.


thanks
Paul

Paul J Coviello
Sr Systems Analyst
Catholic Medical Center
2456 Brown Ave
Manchester, NH 03103
603 663-5326



Re: Problem deleting filespace SYSTEM OBJECT

2002-09-19 Thread Burton, Robert

we are having the same problemand the auditdb for a 37 GB database took
over 26 HRs...

thanks
Robert Burton 
Enterprise Storage Network Analyst 
Royal Bank of Canada 
315 Front St West 
Toronto, On, M5V 3A4 
* 416-348-3849 
* [EMAIL PROTECTED]  


-Original Message-
From: Gerhard Rentschler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:42 AM
To: [EMAIL PROTECTED]
Subject: Problem deleting filespace SYSTEM OBJECT


Hello,
I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3.
Using the command
del filespace rus_zsdsinz 'SYSTEM OBJECT'
I get the following messages in the activity log:
09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in
the
   BACKGROUND at 16:20:33.
09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node
RUS_ZSDSINZ
   started as process 452.
09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive
data)
   for node RUS_ZSDSINZ started.
09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId<84> Error 1123
deleting
   group leader 0 585684848.
09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in
the
   BACKGROUND completed with completion state FAILURE at
   16:20:34.
I opened a PMR. Level 1 suggested to run the command "cleanup backupgroup"
and retry the delete filespace command. It didn't help. The next advice was
to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del
filespace. The next thing to do would be a dsmserv auditdb. However, this
would take a lot of time with my 55 GB database.

Has anyone else seen this? Level 1 told me that he found only one similar
problem.
Best regards
Gerhard
---
Gerhard Rentschleremail:[EMAIL PROTECTED]
Regional Computing Center tel.   ++49/711/685 5806
University of Stuttgart   fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany

--
This e-mail may be privileged and/or confidential, and the sender does not waive any 
related rights and obligations. Any distribution, use or copying of this e-mail or the 
information it contains by other than an intended recipient is unauthorized. If you 
received this e-mail in error, please advise me (by return e-mail or otherwise) 
immediately. 

Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et 
obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou 
des renseignements qu'il contient par une personne autre que le (les) destinataire(s) 
désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser 
immédiatement, par retour de courriel ou par un autre moyen. 


==



TSM Scheduler on WinNT and Win2K

2002-09-19 Thread Martinez, Matt

Hi all,

The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will
not start up after a reboot. When I go in and start the service manually it
starts up fine. I can't seem to find any errors in the Event Log. Any help
you can provide will be appreciated.

Thanks,
Matt



Re: dsmcsvc.exe will not die

2002-09-19 Thread Bill Boyer

It was a known issue between OFM and McAfee. The client upgraded OFM to the
lates 8.x version.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Hussein Abdirahman
Sent: Wednesday, September 18, 2002 3:42 PM
To: [EMAIL PROTECTED]
Subject: Re: dsmcsvc.exe will not die


Bill;

How did you fix it?

regards;
Hussein A.

-Original Message-
From: Bill Boyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 2:57 PM
To: [EMAIL PROTECTED]
Subject: Re: dsmcsvc.exe will not die


We had a problem like this at a client site that turned out to be a problem
between McAfee Anti-vitus software and St. Bernard Open File Manager (OFM).

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Pitur Ey~srsson
Sent: Wednesday, September 18, 2002 11:56 AM
To: [EMAIL PROTECTED]
Subject: Re: dsmcsvc.exe will not die


yes i have had some problems with Anti-virus programs.
But is almost impossible to say what caused it there can be so mutch.
What kind of applications are running on your TSM Client?
What version, maintenance, fix and patch is the Client you are using?
What kind of configurations are you using in your dsm.opt file?




Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

[EMAIL PROTECTED]

 Nyherji Hf  Simi TEL: +354-569-7700
 Borgartun 37105 Iceland
 URL:http://www.nyherji.is


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Hussein Abdirahman
Sent: 18. september 2002 14:34
To: [EMAIL PROTECTED]
Subject: dsmcsvc.exe will not die


Hello All;

I have a win2k client that its backup fails and the dsmsvc.exe process
seems to consume  a lot of CPU. 40-50% even when there is no backup running.

I can not kill this process with the "kill -f PID" command or through the
task manager.
Stopping the service would not stop it either.

The dsmerror.log contains the following.

09/18/2002 07:33:04 cuConfirm: Received rc: -50 trying to receive
ConfirmResp verb
09/18/2002 07:33:04 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:05 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:20 ANS1810E TSM session has been reestablished.
09/18/2002 07:33:21 ANS1005E TCP/IP read error on socket = 844, errno =
10035, reason : 'A non-blocking socket operation could not be completed
immediately.'.
09/18/2002 07:33:21 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:22 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:37 ANS1810E TSM session has been reestablished.



Any suggestions on the cause and the cure of this?




Environment:
Client:
Windows 2000 SP2 (contains a shared drive) Which is, looking the scheduler
log, where the backup hangs.
TSM client version is 5.1.1.0


Server;
AIX 4.3.3.0 ML10
TSM version 5.1.1.0


TIA and regards;

Hussein M. Abdirahman
UNIX Administrator
IrwinToy LTD



IBM quote

2002-09-19 Thread Orin Rehorst

The point system IBM uses for pricing is confusing.

A quote has 40 points shown for the Exchange protect agent maintenance, 275
points for the TSM server component maintenance.

Do these points represent a quantity of one each?



Regards,
Orin

Orin Rehorst
Port of Houston Authority
(Largest U.S. port in foreign tonnage)
e-mail:  [EMAIL PROTECTED]
Phone:  (713)670-2443
Fax:  (713)670-2457
TOPAS web site: 



Re: TSM Scheduler on WinNT and Win2K

2002-09-19 Thread Rushforth, Tim

Are you running 5.11 client?

Some people (including me) are having this problem.

I have PMR # 40368 open with Tivoli on this.

A workaround I use on Windows 2000 is to set the Recovery Options on the
service to restart after 2 minutes on failure.

Tim Rushforth
City of Winnipeg

-Original Message-
From: Martinez, Matt [mailto:[EMAIL PROTECTED]]
Sent: September 19, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: TSM Scheduler on WinNT and Win2K

Hi all,

The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will
not start up after a reboot. When I go in and start the service manually it
starts up fine. I can't seem to find any errors in the Event Log. Any help
you can provide will be appreciated.

Thanks,
Matt



JFS snapshots for backup

2002-09-19 Thread Levinson, Donald A.

Is anyone using the splitcopy feature of AIX LVM to perform snapshot
backups?
How well does it work for restore and what steps do you take to make sure
that the filesystems do not get marked as inactive after deleting the copy
filesystem?
If you are using splitcopy do you have a disaster recovery cookbook to
restore from the splitcopy instead of mksysb?


This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.



Re: Schedule Question.

2002-09-19 Thread Andrew Raibeck

The include syntax for your D: drive would be:

   include d:\...\* pst_mgmt_class

But I don't think that this would work very well since there is almost
certainly no guarantee that everything on D: changes every Friday, in
lock-step

A couple of possibilities:

1) Create schedules for Monday, Tuesday, Wednesday, Thursday, Friday, and
Weekend. For the Friday schedule, set the OBJECTS parameter to D: S:. For
the other schedules, set OBJECTS to S: only.

2) Create a single schedule with OBJECTS="D: S:". Then create two Admin
schedules:

- One to issue UPDATE SCHEDULE for the client schedule that sets
OBJECTS="D: S:". Schedule this to run just before the Friday backup.

- One to issue UPDATE SCHEDULE for the client schedule that sets
OBJECTS="S:". Schedule this to run before the Saturday backup.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




"Gent, Chad E." <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/19/2002 06:45
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Schedule Question.



Hello All,

NT 4 Client with TSM 4.2.15
Server AIX 4.3.3 TSM 4.2.11.14

I have a client with 2 drives; D: and S:. I need everything on the D:
drive
to only be backed up on Fridays.  But I need the S: drive to continue
doing
a daily backup.  What is the best way to accomplish this scenario?

1. Create a management class with a frequency of 7 and assign this
management class to the entire D: drive.  But if I use this option how do
I
assign the entire D: drive to this management class in my client option
file?
Include "D:" PST_MGMT_CLASS

Or

2.  Is there a way to create a schedule on the Server and have that
schedule
use a particular option file on the client?

Thanks
Chad



Re: How can I tell when an archive was performed?

2002-09-19 Thread David E Ehresman

select node_name,filespace_name,description,min(archive_date) -
as "Archive Date",  count(ll_name) as "Num Files"  -
from archives group by node_name, -
filespace_name, description



Re: TSM Scheduler on WinNT and Win2K

2002-09-19 Thread Shannon Bach

Look in "services" and make sure that your TSM Client Acceptor is also set
to automatic.

Shannon Bach
Madison Gas & Electric Co.
Operations Analyst - Data Center Services
Office 608-252-7260
Fax 608-252-7098
e-mail [EMAIL PROTECTED]



Re: Linux "No domain available"

2002-09-19 Thread Zoltan Forray/AC/VCU

If you check the ADSM-L archive (www.adsm.org), this is a common
problem/issue with older TSM clients and RedHat Linux clients that utilize
the EXT3/ReiserFS file system, i.e. V7.

The answer is to upgrade the client to V5.x or add VIRTUALMOUNTPOINT
statements to your DSM.SYS.






Kai Hintze <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/19/2002 03:57 PM
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Linux "No domain available"


Greetings oh Guru's of TSM!

My first linux client complains that there is "No domain available" when I
try to run your basic incremental. The same server domain works fine on
other systems. I looked at the ADSM-L archives and found a clue that Linux
may not have a default domain, so I tried to set it, but I'm still not
having any luck. I have tried a domain statement in both dsm.opt and
dsm.sys
but neither worked. According to the manual, a file specification trumps a
domain statement, and sure enough "dsmc incr / -subdir=yes" works. So it
is
a problem with the client domain. What am I overlooking?

TIA!

- Kai.

[root@mylinux bin]# uname -a
Linux mylinux 2.4.18-3smp #1 SMP Thu Apr 18 07:27:31 EDT 2002 i686 unknown
[root@mylinx bin]# dsmc incr
Tivoli Storage Manager
Command Line Backup Client Interface - Version 4, Release 2, Level 2.1
(C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved.

Node Name: MYLINIX
Session established with server TSMAA: AIX-RS/6000
  Server Version 4, Release 2, Level 2.5
  Server date/time: 09/19/2002 13:26:30  Last access: 09/19/2002 13:05:21

ANS1149E No domain available for incremental backup

[root@mylinux bin]# cat dsm.opt

Servername tsmaa
tapeprompt no
domain all-local

*virtualnodeclient
[root@mylinux bin]#  more dsm.sys
SErvername  tsmaa
   COMMmethod TCPIP
   TCPSERVERADDRESS   tsmaa
   TXNBYTE8192
   compressionoff
  nodename mylinux
  domain   all-local
  changingretries  1
  inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl
  maxcmdretries8
  retryperiod  15
  schedlogname /var/adm/schedule.log
  queryschedperiod 1
  schedmodeprompted
  passwordaccess   generate
  schedlogretention10 d
  mailprog /usr/bin/mail root
  txnbytelimit 25600
  tcpbuffsize  512
  tcpwindowsize640
  largecommbuffers yes
  resourceutilization  6
  dirmcstatic

## and in case it really is the server domain

[root@mylinux bin]#  dsmadmc
Tivoli Storage Manager
Command Line Administrative Interface - Version 4, Release 2, Level 2.1
(C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved.

Enter your user id:  me

Enter your password:

Session established with server TSMAA: AIX-RS/6000
  Server Version 4, Release 2, Level 2.5
  Server date/time: 09/19/2002 13:13:02  Last access: 09/19/2002 09:27:13


tsm: TSMAA>q node mylinux f=d

 Node Name: mylinux
  Platform: Linux86
   Client OS Level: 2.4.18-3s
Client Version: Version 4, Release 2, Level 2.1
Policy Domain Name: AA_DOMAIN
 Last Access Date/Time: 09/19/2002 13:05:21
Days Since Last Access: <1
Password Set Date/Time: 09/16/2002 17:22:08
   Days Since Password Set: 3
 Invalid Sign-on Count: 0
   Locked?: No
   Contact: staff
   Compression: Client
   Archive Delete Allowed?: Yes
Backup Delete Allowed?: Yes
Registration Date/Time: 09/16/2002 17:22:08
 Registering Administrator: ME
Last Communication Method Used: Tcp/Ip
   Bytes Received Last Session: 1,756
   Bytes Sent Last Session: 6,395
  Duration of Last Session: 3.01
   Pct. Idle Wait Last Session: 162.81
  Pct. Comm. Wait Last Session: 0.00
  Pct. Media Wait Last Session: 0.00
 Optionset:
   URL:
 Node Type: Client
Password Expiration Period:
 Keep Mount Point?: No
  Maximum Mount Points Allowed: 1
Auto Filespace Rename : No


tsm: TSMAA>q dom AA_domain

PolicyActivated Activated  Number of Description

DomainPolicyDefault   Registered
Name  Set   Mgmt   Nodes
Class
- - - --

AA_DOMAIN STANDARD  STANDARD  12 Back up to AA

tsm: TSMAA>q pol AA_domain standard

PolicyPolicyDefault   Description
DomainSet Name  Mgmt
NameClass
Name
- - - 
AA_DOMAIN STANDARD  STANDARD  Default policy

tsm: TSMAA>q pol AA_domain standard f

Re: Problem deleting filespace SYSTEM OBJECT

2002-09-19 Thread Williams, Tim P {PBSG}

 but did it FIX the problem?

-Original Message-
From: Burton, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 2:32 PM
To: [EMAIL PROTECTED]
Subject: Re: Problem deleting filespace SYSTEM OBJECT


we are having the same problemand the auditdb for a 37 GB database took
over 26 HRs...

thanks
Robert Burton 
Enterprise Storage Network Analyst 
Royal Bank of Canada 
315 Front St West 
Toronto, On, M5V 3A4 
* 416-348-3849 
* [EMAIL PROTECTED]  


-Original Message-
From: Gerhard Rentschler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:42 AM
To: [EMAIL PROTECTED]
Subject: Problem deleting filespace SYSTEM OBJECT


Hello,
I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3.
Using the command
del filespace rus_zsdsinz 'SYSTEM OBJECT'
I get the following messages in the activity log:
09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in
the
   BACKGROUND at 16:20:33.
09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node
RUS_ZSDSINZ
   started as process 452.
09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive
data)
   for node RUS_ZSDSINZ started.
09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId<84> Error 1123
deleting
   group leader 0 585684848.
09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in
the
   BACKGROUND completed with completion state FAILURE at
   16:20:34.
I opened a PMR. Level 1 suggested to run the command "cleanup backupgroup"
and retry the delete filespace command. It didn't help. The next advice was
to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del
filespace. The next thing to do would be a dsmserv auditdb. However, this
would take a lot of time with my 55 GB database.

Has anyone else seen this? Level 1 told me that he found only one similar
problem.
Best regards
Gerhard
---
Gerhard Rentschleremail:[EMAIL PROTECTED]
Regional Computing Center tel.   ++49/711/685 5806
University of Stuttgart   fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany


--
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distribution, use or copying
of this e-mail or the information it contains by other than an intended
recipient is unauthorized. If you received this e-mail in error, please
advise me (by return e-mail or otherwise) immediately. 

Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux
droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou
copie de ce message ou des renseignements qu'il contient par une personne
autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez
ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de
courriel ou par un autre moyen. 



==



Linux "No domain available"

2002-09-19 Thread Kai Hintze

Greetings oh Guru's of TSM!

My first linux client complains that there is "No domain available" when I
try to run your basic incremental. The same server domain works fine on
other systems. I looked at the ADSM-L archives and found a clue that Linux
may not have a default domain, so I tried to set it, but I'm still not
having any luck. I have tried a domain statement in both dsm.opt and dsm.sys
but neither worked. According to the manual, a file specification trumps a
domain statement, and sure enough "dsmc incr / -subdir=yes" works. So it is
a problem with the client domain. What am I overlooking?

TIA!

- Kai.

[root@mylinux bin]# uname -a
Linux mylinux 2.4.18-3smp #1 SMP Thu Apr 18 07:27:31 EDT 2002 i686 unknown
[root@mylinx bin]# dsmc incr
Tivoli Storage Manager
Command Line Backup Client Interface - Version 4, Release 2, Level 2.1
(C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved.

Node Name: MYLINIX
Session established with server TSMAA: AIX-RS/6000
  Server Version 4, Release 2, Level 2.5
  Server date/time: 09/19/2002 13:26:30  Last access: 09/19/2002 13:05:21

ANS1149E No domain available for incremental backup

[root@mylinux bin]# cat dsm.opt

Servername tsmaa
tapeprompt no
domain all-local

*virtualnodeclient
[root@mylinux bin]#  more dsm.sys
SErvername  tsmaa
   COMMmethod TCPIP
   TCPSERVERADDRESS   tsmaa
   TXNBYTE8192
   compressionoff
  nodename mylinux
  domain   all-local
  changingretries  1
  inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl
  maxcmdretries8
  retryperiod  15
  schedlogname /var/adm/schedule.log
  queryschedperiod 1
  schedmodeprompted
  passwordaccess   generate
  schedlogretention10 d
  mailprog /usr/bin/mail root
  txnbytelimit 25600
  tcpbuffsize  512
  tcpwindowsize640
  largecommbuffers yes
  resourceutilization  6
  dirmcstatic

## and in case it really is the server domain

[root@mylinux bin]#  dsmadmc
Tivoli Storage Manager
Command Line Administrative Interface - Version 4, Release 2, Level 2.1
(C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved.

Enter your user id:  me

Enter your password:

Session established with server TSMAA: AIX-RS/6000
  Server Version 4, Release 2, Level 2.5
  Server date/time: 09/19/2002 13:13:02  Last access: 09/19/2002 09:27:13


tsm: TSMAA>q node mylinux f=d

 Node Name: mylinux
  Platform: Linux86
   Client OS Level: 2.4.18-3s
Client Version: Version 4, Release 2, Level 2.1
Policy Domain Name: AA_DOMAIN
 Last Access Date/Time: 09/19/2002 13:05:21
Days Since Last Access: <1
Password Set Date/Time: 09/16/2002 17:22:08
   Days Since Password Set: 3
 Invalid Sign-on Count: 0
   Locked?: No
   Contact: staff
   Compression: Client
   Archive Delete Allowed?: Yes
Backup Delete Allowed?: Yes
Registration Date/Time: 09/16/2002 17:22:08
 Registering Administrator: ME
Last Communication Method Used: Tcp/Ip
   Bytes Received Last Session: 1,756
   Bytes Sent Last Session: 6,395
  Duration of Last Session: 3.01
   Pct. Idle Wait Last Session: 162.81
  Pct. Comm. Wait Last Session: 0.00
  Pct. Media Wait Last Session: 0.00
 Optionset:
   URL:
 Node Type: Client
Password Expiration Period:
 Keep Mount Point?: No
  Maximum Mount Points Allowed: 1
Auto Filespace Rename : No


tsm: TSMAA>q dom AA_domain

PolicyActivated Activated  Number of Description

DomainPolicyDefault   Registered
Name  Set   Mgmt   Nodes
Class
- - - --

AA_DOMAIN STANDARD  STANDARD  12 Back up to AA

tsm: TSMAA>q pol AA_domain standard

PolicyPolicyDefault   Description
DomainSet Name  Mgmt
NameClass
Name
- - - 
AA_DOMAIN STANDARD  STANDARD  Default policy

tsm: TSMAA>q pol AA_domain standard f=d

PolicyPolicyDefault   Description  Last
Update by  Last Upda- Managing profile
DomainSet Name  Mgmt
(administrator) te Date/T-
NameClass
ime
Name

- - - 
--- -- -AA_DOMAIN STANDARD
STANDARD  Default policy   ME  07/24/2002


tsm: TSMAA>q mgmt AA_domain standard standard f=d


Re: IBM quote

2002-09-19 Thread Levinson, Donald A.

I just got a new quote and it appears that we now buy the product number on
a per-processor basis instead of per-point or tier. For instance to buy the
Data Protection for SQL (oracle) agent for a dual processor Compaq running
Intel I was told to buy two of D510ELL IBM TSM for DBS processor Lic with 10
points each. However I was only told to buy one of D5127LL IBM TSM processor
lic for the TSM client for 1 point. I wish they would settle on one easy to
understand price model and then track it the same way in Passport Advantage
so I could tell what I bought.


-Original Message-
From: Orin Rehorst [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:37 AM
To: [EMAIL PROTECTED]
Subject: IBM quote


The point system IBM uses for pricing is confusing.

A quote has 40 points shown for the Exchange protect agent maintenance, 275
points for the TSM server component maintenance.

Do these points represent a quantity of one each?



Regards,
Orin

Orin Rehorst
Port of Houston Authority
(Largest U.S. port in foreign tonnage)
e-mail:  [EMAIL PROTECTED]
Phone:  (713)670-2443
Fax:  (713)670-2457
TOPAS web site: 


This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.



Re: dsmcsvc.exe will not die

2002-09-19 Thread Edgardo Moso

You can stop using this command:
at the dos prompt or run  " Killl dsmcsvc.exe"




From: Bill Boyer <[EMAIL PROTECTED]> on 09/19/2002 03:29 PM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:
Subject:  Re: dsmcsvc.exe will not die

It was a known issue between OFM and McAfee. The client upgraded OFM to the
lates 8.x version.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Hussein Abdirahman
Sent: Wednesday, September 18, 2002 3:42 PM
To: [EMAIL PROTECTED]
Subject: Re: dsmcsvc.exe will not die


Bill;

How did you fix it?

regards;
Hussein A.

-Original Message-
From: Bill Boyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 2:57 PM
To: [EMAIL PROTECTED]
Subject: Re: dsmcsvc.exe will not die


We had a problem like this at a client site that turned out to be a problem
between McAfee Anti-vitus software and St. Bernard Open File Manager (OFM).

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Pitur Ey~srsson
Sent: Wednesday, September 18, 2002 11:56 AM
To: [EMAIL PROTECTED]
Subject: Re: dsmcsvc.exe will not die


yes i have had some problems with Anti-virus programs.
But is almost impossible to say what caused it there can be so mutch.
What kind of applications are running on your TSM Client?
What version, maintenance, fix and patch is the Client you are using?
What kind of configurations are you using in your dsm.opt file?




Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

[EMAIL PROTECTED]

 Nyherji Hf  Simi TEL: +354-569-7700
 Borgartun 37105 Iceland
 URL:http://www.nyherji.is


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Hussein Abdirahman
Sent: 18. september 2002 14:34
To: [EMAIL PROTECTED]
Subject: dsmcsvc.exe will not die


Hello All;

I have a win2k client that its backup fails and the dsmsvc.exe process
seems to consume  a lot of CPU. 40-50% even when there is no backup
running.

I can not kill this process with the "kill -f PID" command or through the
task manager.
Stopping the service would not stop it either.

The dsmerror.log contains the following.

09/18/2002 07:33:04 cuConfirm: Received rc: -50 trying to receive
ConfirmResp verb
09/18/2002 07:33:04 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:05 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:20 ANS1810E TSM session has been reestablished.
09/18/2002 07:33:21 ANS1005E TCP/IP read error on socket = 844, errno =
10035, reason : 'A non-blocking socket operation could not be completed
immediately.'.
09/18/2002 07:33:21 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:22 ANS1809W Session is lost; initializing session reopen
procedure.
09/18/2002 07:33:37 ANS1810E TSM session has been reestablished.



Any suggestions on the cause and the cure of this?




Environment:
Client:
Windows 2000 SP2 (contains a shared drive) Which is, looking the scheduler
log, where the backup hangs.
TSM client version is 5.1.1.0


Server;
AIX 4.3.3.0 ML10
TSM version 5.1.1.0


TIA and regards;

Hussein M. Abdirahman
UNIX Administrator
IrwinToy LTD



Re: TSM Scheduler on WinNT and Win2K

2002-09-19 Thread prasanna S ghanekar

Hello,

Both Services are set to "Automatic" for startup. It happens invariably on most of the 
Windows NT servers. After Reboot, if you check the event log, it says "Starting 
Scheduler Service" but actually it's not running.

One more observation on Windows NT4.0 with SQL server:

Sometimes, TSM scheduler service starts at the reboot but the one for TDPSQL fails to 
start and nothing is written in the event log.

Regards,

Prasanna Ghanekar


--

On Thu, 19 Sep 2002 14:44:53
 Shannon Bach wrote:
>Look in "services" and make sure that your TSM Client Acceptor is also set
>to automatic.
>
>Shannon Bach
>Madison Gas & Electric Co.
>Operations Analyst - Data Center Services
>Office 608-252-7260
>Fax 608-252-7098
>e-mail [EMAIL PROTECTED]
>


_
Play the Elvis. Scratch & Win for your chance to instantly win $10,000 Cash
- a 2003 Harley Davidson. Sportster. - 1 of 25,000 CD's - and more!
http://r.lycos.com/r/sagel_mail_scratch_tl/http://win.ipromotions.com/lycos_020801/index.asp?tc=7087



Re: other solution ?'s

2002-09-19 Thread Mark Stapleton

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Coviello, Paul
> I just received in the mail a letter from a company call Vyant
> technologies.
> www.vyanttech.com
> has anyone heard of them and or know what exactly they are selling?
> outside of guaranteeing a restore of data within 20 min's regardless of
> size.

It's got to be real-time replication with some kind of failover capability,
rather like NSI's DoubleTake.

--
Mark Stapleton ([EMAIL PROTECTED])
Certified TSM consultant
Certified AIX system engineer
MCSE



Re: 3584 tape questions

2002-09-19 Thread Mark Stapleton

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Orville Lantto
> Maybe the volser is in the chip.

Nope. Per Tivoli, no one there has written anything to take advantage of the
chip inbedded in each LTO tape.

AFAIK, no one at IBM has done likewise.

Volume labels are written at the beginning of each tape. (I think) there is
a reserved area at the beginning at each tape for such information to be
written.

--
Mark Stapleton ([EMAIL PROTECTED])
Certified TSM consultant
Certified AIX system engineer
MCSE



Re: TSM Scheduler on WinNT and Win2K

2002-09-19 Thread Martinez, Matt

I am using 5.11. I am using the recovery options for Win2k also. But that
doesn't help me with NT4.0 Clients.

Thanks,
Matt

 -Original Message-
From:   Rushforth, Tim [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, September 19, 2002 3:38 PM
To: [EMAIL PROTECTED]
Subject:Re: TSM Scheduler on WinNT and Win2K

Are you running 5.11 client?

Some people (including me) are having this problem.

I have PMR # 40368 open with Tivoli on this.

A workaround I use on Windows 2000 is to set the Recovery Options on the
service to restart after 2 minutes on failure.

Tim Rushforth
City of Winnipeg

-Original Message-
From: Martinez, Matt [mailto:[EMAIL PROTECTED]]
Sent: September 19, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: TSM Scheduler on WinNT and Win2K

Hi all,

The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will
not start up after a reboot. When I go in and start the service manually it
starts up fine. I can't seem to find any errors in the Event Log. Any help
you can provide will be appreciated.

Thanks,
Matt



Re: TSM Scheduler on WinNT and Win2K

2002-09-19 Thread Martinez, Matt

Shannon,

It is also set to automatic. Thanks for the advice

Thank You,
Matt Martinez
Workgroup Support Analyst
IDEXX Laboratories, Inc
207-856-0656
[EMAIL PROTECTED]

 -Original Message-
From:   Shannon Bach [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, September 19, 2002 3:45 PM
To: [EMAIL PROTECTED]
Subject:Re: TSM Scheduler on WinNT and Win2K

Look in "services" and make sure that your TSM Client Acceptor is also set
to automatic.

Shannon Bach
Madison Gas & Electric Co.
Operations Analyst - Data Center Services
Office 608-252-7260
Fax 608-252-7098
e-mail [EMAIL PROTECTED]



Re: 3584 tape questions

2002-09-19 Thread David Longo

Mark,

Do you know how to access the info on the chip?  I've seen the few
comments in sales lit/manuals that have a couple of sentences but
no info on how to access.  It's supposed to have for one thing
the total/partial stats for the life of the tape.  I assumed the
library or
drive was updating that info.  Any way to access with tapeutil or
3584 library Storwatch?

Thanks,
David Longo

>>> [EMAIL PROTECTED] 09/19/02 03:29PM >>>
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf
Of
Orville Lantto
> Maybe the volser is in the chip.

Nope. Per Tivoli, no one there has written anything to take advantage
of the
chip inbedded in each LTO tape.

AFAIK, no one at IBM has done likewise.

Volume labels are written at the beginning of each tape. (I think)
there is
a reserved area at the beginning at each tape for such information to
be
written.

--
Mark Stapleton ([EMAIL PROTECTED])
Certified TSM consultant
Certified AIX system engineer
MCSE


"MMS " made the following
 annotations on 09/19/2002 05:01:32 PM
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

==



Re: TSM Scheduler on WinNT and Win2K

2002-09-19 Thread Williams, Tim P {PBSG}

I too am experiencing this problem. I have not opened it up as an issue,
yet.
I was the "apar owner" of the issue with device...from the drive
tableand
offered that up to this listserv...
FYI Thanks Tim

-Original Message-
From: Martinez, Matt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 3:07 PM
To: [EMAIL PROTECTED]
Subject: Re: TSM Scheduler on WinNT and Win2K


I am using 5.11. I am using the recovery options for Win2k also. But that
doesn't help me with NT4.0 Clients.

Thanks,
Matt

 -Original Message-
From:   Rushforth, Tim [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, September 19, 2002 3:38 PM
To: [EMAIL PROTECTED]
Subject:Re: TSM Scheduler on WinNT and Win2K

Are you running 5.11 client?

Some people (including me) are having this problem.

I have PMR # 40368 open with Tivoli on this.

A workaround I use on Windows 2000 is to set the Recovery Options on the
service to restart after 2 minutes on failure.

Tim Rushforth
City of Winnipeg

-Original Message-
From: Martinez, Matt [mailto:[EMAIL PROTECTED]]
Sent: September 19, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: TSM Scheduler on WinNT and Win2K

Hi all,

The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will
not start up after a reboot. When I go in and start the service manually it
starts up fine. I can't seem to find any errors in the Event Log. Any help
you can provide will be appreciated.

Thanks,
Matt



Re: other solution ?'s

2002-09-19 Thread Coviello, Paul

I also found mention of it working with TSM.

> -Original Message-
> From: Mark Stapleton [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 3:47 PM
> To:   [EMAIL PROTECTED]
> Subject:  Re: other solution ?'s
>
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Coviello, Paul
> > I just received in the mail a letter from a company call Vyant
> > technologies.
> > www.vyanttech.com
> > has anyone heard of them and or know what exactly they are selling?
> > outside of guaranteeing a restore of data within 20 min's regardless of
> > size.
>
> It's got to be real-time replication with some kind of failover
> capability,
> rather like NSI's DoubleTake.
>
> --
> Mark Stapleton ([EMAIL PROTECTED])
> Certified TSM consultant
> Certified AIX system engineer
> MCSE



Re: IBM quote

2002-09-19 Thread Coats, Jack

>From my crude understanding that could be WAY off, is that full retail cost
of a point is about $32USD (and is probably different, so YMMV).  Most
people get a discount of some type if you go through a VAR or have some
other reason (like IBM wants to make a sale).

Basically, points are used as a way to price.  And the discount come rather
than wrangling about components you get for 'free', you wrangle about the
cost
per 'point'.

So everyone must purchase so many points.  Just what you pay for them is up
for discussion.

Just another way to slice the same pie.  Confusing? yep.  But pricing of
most other things is confusing too.

What gripes me is that you enter license by number of this and that you are
license for, and not just here are x points, use them till they are up.
There isn't
even a easy standard way to audit to say 'go buy xxx more points', or 'you
have
x points, y points are consumed, z points are not in current use'

Such is life.

-Original Message-
From: Orin Rehorst [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 2:37 PM
To: [EMAIL PROTECTED]
Subject: IBM quote


The point system IBM uses for pricing is confusing.

A quote has 40 points shown for the Exchange protect agent maintenance, 275
points for the TSM server component maintenance.

Do these points represent a quantity of one each?



Regards,
Orin

Orin Rehorst
Port of Houston Authority
(Largest U.S. port in foreign tonnage)
e-mail:  [EMAIL PROTECTED]
Phone:  (713)670-2443
Fax:  (713)670-2457
TOPAS web site: 



Re: serverfree - lanfree ?

2002-09-19 Thread Zlatko Krastev/ACIT

Chris,

I try to explain to my customers in the following order:
1. Normal behavior (LAN) is in three steps - Node storage -> TSM Client ->
TSM Server -> Tape
2. LAN-free transfer reduces them to two steps eliminating one by
combining last two in one - Node storage -> TSM Client/Storage agent ->
Tape (last step requires SAN-shared tape)
3. server-free eliminates one more step, skipping both TSM server (as in
LAN-free) and TSM client (new add-on) - Node storage -> SAN-tape
The last "single-step" is accomplished using SAN data mover, i.e. device
on SAN capable to perform data transfer between a disk (Node storage) and
tape (TSM server storage) without any host involvement (neither server nor
client).
Currently supported data movers are IBM SAN Data Gateway (2108-G07 and
same module in IBM 3583) and Pathlight 5000.
Hope this helps to you to understand. This will prove my "customer"
explanation :-)

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:

Subject:serverfree - lanfree ?

Hi All

Can someone please explain the difference between serverfree and lanfree
backup?

My understanding is that LAN free still involves the clients they just
send
their data over the SAN, and Serverfree uses some method to backup without
involving the client.

What software/clients/agents do you need to achieve both of these
solutions?

Working on a big implementation at the moment, including win2000, HSM,
2000
clusters, Exchange clusters new SAN, new storage etc etc etc.  I think you
going to be hearing a lot from me over the next couple of months, ! !!

Chris



Have a look at http://www.geocities.com/rees_chris


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com



How can I tell what tapes are in a BackupSet?

2002-09-19 Thread Coats, Jack

Anyone have a suggestion for a select statement that could return this a
list of the tapes in each BackupSet that is still active?



Re: How can I tell what tapes are in a BackupSet?

2002-09-19 Thread Joshua Bassi

Query backupset

--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
Tivoli Certified Consultant - ADSM/TSM
eServer Systems Expert -pSeries HACMP

AIX, HACMP, Storage, TSM Consultant
Cell (831) 595-3962
[EMAIL PROTECTED]


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of
Coats, Jack
Sent: Thursday, September 19, 2002 2:33 PM
To: [EMAIL PROTECTED]
Subject: How can I tell what tapes are in a BackupSet?

Anyone have a suggestion for a select statement that could return this a
list of the tapes in each BackupSet that is still active?



Re: IBM quote: Points System

2002-09-19 Thread Seay, Paul

The point system was a relative value for a component residing on a machine
with of 1 of 3 tiers.

Forty Points is a tier 1 NT system, 4 or less CPUs, for Exchange.
The 275 is a mixture of Server and client code I am guessing.

Your quote will make sense if you get the input numbers and the points for
each component.

The nice part is the points system is going away, the bad part is the new
replacement, CPU based, is even more confusing.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Orin Rehorst [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 3:37 PM
To: [EMAIL PROTECTED]
Subject: IBM quote


The point system IBM uses for pricing is confusing.

A quote has 40 points shown for the Exchange protect agent maintenance, 275
points for the TSM server component maintenance.

Do these points represent a quantity of one each?



Regards,
Orin

Orin Rehorst
Port of Houston Authority
(Largest U.S. port in foreign tonnage)
e-mail:  [EMAIL PROTECTED]
Phone:  (713)670-2443
Fax:  (713)670-2457
TOPAS web site: 



Re: binding WWN and SCSI on NT with QLOGIC

2002-09-19 Thread Seay, Paul

This is the one major problem with the Qlogic driver.  The Emulex
card/driver supports persistent binding last I checked.  We all should
probably start pounding on Qlogic for a solution.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Jason Livie [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 19, 2002 10:50 AM
To: [EMAIL PROTECTED]
Subject: binding WWN and SCSI on NT with QLOGIC


Greetings,

Is there a way to permanently bind a WWN address to a SCIS ID in w2K with a
QLOGIC QLA2200. If so, what is the utility available and the driver version
necessary for this. We are currently using driver version 8.1.5.60 on a
QLA2200 and W2K.

There seems to be a problem whenever the SAN "glitches", the drive
attribution on NT changes from the original setting, therefore our
drivemapping on TSM is no longer valid in our lanfree environment.

sincerely,

Jason Livie
e-Business Process/Storage Team - Service Delivery
IBM Global Services - La Gaude
Tél.: 04 9211 5943 - email : [EMAIL PROTECTED]



Re: 4.2.x selects from DRIVE table

2002-09-19 Thread Seay, Paul

Yes, I have seen this, but I forgot to open a PMR on it.  I guess I need to.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: David Stabler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:26 AM
To: [EMAIL PROTECTED]
Subject: Re: 4.2.x selects from DRIVE table


gotta be a bugit's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.  WEIRD.

-drs-

>>> [EMAIL PROTECTED] 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?



Re: Select for Scratches

2002-09-19 Thread Seay, Paul

Why does this not give you the correct answer:

Select library_name, count(*) from libvolumes group by library_name

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Lars Bebensee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:35 AM
To: [EMAIL PROTECTED]
Subject: Select for Scratches


Hi folks,

I am not that good with select queries yes, so I will have to ask one of the
SQL gurus here: we wanted to show how many scratch tapes each library has
with a query like
this:

"select a.library_name,count(*) as volumes, b.devtype from libvolumes as a,
devclasses as b where upper(status) like 'SCRATCH%' and a.library_name='$i'
and a.library_name=b.library_name group by a.library_name,b.devtype"

$i will be filled with the name of the library before. The funny thing, it
shows exactly as twice as many scratches. Is there someone amongst you who
can exctract this little monster for me and show me what I am doing wrong.

Thanks for helping out

Lars



Re: Select for Scratches

2002-09-19 Thread Seay, Paul

Sorry, wrong select
Why does this one not give the correct answer?

Select library_name, count(*) from libvolumes where status='Scratch' group
by library_name

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Lars Bebensee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:35 AM
To: [EMAIL PROTECTED]
Subject: Select for Scratches


Hi folks,

I am not that good with select queries yes, so I will have to ask one of the
SQL gurus here: we wanted to show how many scratch tapes each library has
with a query like
this:

"select a.library_name,count(*) as volumes, b.devtype from libvolumes as a,
devclasses as b where upper(status) like 'SCRATCH%' and a.library_name='$i'
and a.library_name=b.library_name group by a.library_name,b.devtype"

$i will be filled with the name of the library before. The funny thing, it
shows exactly as twice as many scratches. Is there someone amongst you who
can exctract this little monster for me and show me what I am doing wrong.

Thanks for helping out

Lars



Re: Select command to q client name and version: Pretty Form

2002-09-19 Thread Seay, Paul

select node_name,cast (client_version as char(1)) || '.' || cast
(client_release as char(1)) || '.' || cast (client_level as char(1)) || '.'
|| trim(cast(client_sublevel as char(2))) as "Level" from nodes order by 2,1

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: Halvorsen Geirr Gulbrand [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Select command to q client name and version


Hi Karla,
try
select node_name,client_version,client_release,client_level,client_sublevel
from nodes

Rgds,
Geirr G. Halvorsen

-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: 19. september 2002 15:08
To: [EMAIL PROTECTED]
Subject: Select command to q client name and version


Does anyone have a select command that will show me the clients and what
version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
and 5.1.

Karla Ross



Is it possible to install two different versions of TSM Server on a single server?

2002-09-19 Thread StorageGroupAdmin StorageGroupAdmin

A part of our DR procedures is that if we lost a given data centre we
would recover the TSM server onto the same hardware as the alternate
site's TSM server and run both instances in parallel  (Both machines are
SUN 450's)

If the TSM servers were at the same release level then we have the
option of using the exact same binaries and simply point them to
different config files.

My problem occurs when one of the server levels is back level. To
prevent this problem from occurring I would like to;

 # find a method that would allow me to install TSM to host specific
directories (ie /site1_tsm/tivoli/tsm/server/bin/... rather than
/opt/tivoli/.)

 # find a method that would allow me install a second TSM package to a
different directory (ie /site2_tsm/server/.) I am guessing that
pkgadd will not like me installing a package on the system that already
has a package of the same name already installed.


Is this possible? An idea or hints would be appreciated



Peter Griffin
Sydney Water


---
This e-mail is solely for the use of the intended recipient
and may contain information which is confidential or
privileged. Unauthorised use of its contents is prohibited.
If you have received this e-mail in error, please notify
the sender immediately via e-mail and then delete the
original e-mail.
---



db2 online and increase backup use tsm

2002-09-19 Thread fenglimian

i want to hnow whether or not can db2 do online and increase backup use tsm.
thanks!



Re: 4.2.x selects from DRIVE table

2002-09-19 Thread Williams, Tim P {PBSG}

I sent all the apar on thisdid no one get it?
I was the originator of this aparmonths ago...
?
tw

-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 7:21 PM
To: [EMAIL PROTECTED]
Subject: Re: 4.2.x selects from DRIVE table


Yes, I have seen this, but I forgot to open a PMR on it.  I guess I need to.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: David Stabler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:26 AM
To: [EMAIL PROTECTED]
Subject: Re: 4.2.x selects from DRIVE table


gotta be a bugit's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.  WEIRD.

-drs-

>>> [EMAIL PROTECTED] 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?



Re: how can i clear up the content of a diskpool?

2002-09-19 Thread Seay, Paul

When you say clear it up, AUDIT it or Migrate it to Zero?

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: fenglimian [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 10:24 PM
To: [EMAIL PROTECTED]
Subject: how can i clear up the content of a diskpool?


what is the operation?
thanks



Re: Is it possible to install two different versions of TSM Serve r on a single server?

2002-09-19 Thread Seay, Paul

This is a sore spot with everyone.  Unfortunately, Tivoli did not setup
their installs to support ./ on Solaris.  I am going to make a point of
getting this on the list of the package install changes.  I am not a UNIX
Admin, but this is what they say is the proper way to setup installs in the
Solaris world.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-Original Message-
From: StorageGroupAdmin StorageGroupAdmin
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:14 PM
To: [EMAIL PROTECTED]
Subject: Is it possible to install two different versions of TSM Server on a
single server?


A part of our DR procedures is that if we lost a given data centre we would
recover the TSM server onto the same hardware as the alternate site's TSM
server and run both instances in parallel  (Both machines are SUN 450's)

If the TSM servers were at the same release level then we have the option of
using the exact same binaries and simply point them to different config
files.

My problem occurs when one of the server levels is back level. To prevent
this problem from occurring I would like to;

 # find a method that would allow me to install TSM to host specific
directories (ie /site1_tsm/tivoli/tsm/server/bin/... rather than
/opt/tivoli/.)

 # find a method that would allow me install a second TSM package to a
different directory (ie /site2_tsm/server/.) I am guessing that pkgadd
will not like me installing a package on the system that already has a
package of the same name already installed.


Is this possible? An idea or hints would be appreciated



Peter Griffin
Sydney Water


---
This e-mail is solely for the use of the intended recipient
and may contain information which is confidential or privileged.
Unauthorised use of its contents is prohibited. If you have received this
e-mail in error, please notify the sender immediately via e-mail and then
delete the original e-mail.
---