Re: TSM in a MS Cluster environment

[Manuel Schweiger]

Joe,

Sure you can put them on the cluster disk as you have to set the service
resource for the scheduler dependend on the disk anyway.
Remember to set up all schedulers & nodes first and then activate the
registry replication as Bruce mentioned in another message.

Regards, Manuel

- Original Message -
From: "Wholey, Joseph (TGA\MLOL)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 2:10 AM
Subject: Re: TSM in a MS Cluster environment


> Manuel,
>
> This does help...  I have only one group.  Can I, for example, put the
dsm.opt file on an "H" drive, and have both client 1 and 2 point to that
dsm.opt file.  So if server 1 fails, server 2 will start
> up the group scheduler and manage the backups.
>
> Regards, Joe
>
> -Original Message-
> From: Manuel Schweiger [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 10, 2002 5:19 PM
> To: [EMAIL PROTECTED]
> Subject: Re: TSM in a MS Cluster environment
>
>
> Joe,
>
> You will need to set up 1 TSM client for each cluster node and 1 TSM
client
> for each cluster group.
> Best to do a simple example on this:
>
> Cluster: 2 Nodes, 3 Groups
>
> Installation Node 1:
>
> TSM Client Local1
> TSM Client Group1
> TSM Client Group2
> TSM Client Group3
> Every group has its own schedulers, client acceptors and remote agents
> (those of group1-3 have to switch with the cluster)..
>
> Installation Node 2:
>
> TSM Client Local2
> TSM Client Group1
> TSM Client Group2
> TSM Client Group3
> (Group 1-3 have to be set up exactly like on Node 1!!)
>
> Hope that helps a little.
>
> regards, Manuel
>
>
> - Original Message -
> From: "Wholey, Joseph (TGA\MLOL)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, December 10, 2002 10:52 PM
> Subject: TSM in a MS Cluster environment
>
>
> > I'm about to install TSM in a MS cluster environment.  I've done this
with
> success in the past in an active/active environment where each server has
3
> TSM scheduler services.  e.g.  local scheduler,
> > scheduler_service_for_group_A, scheduler_service_for_group_B.
> >
> > I've not done it in an active/passive environment where all resources
> normally belong to the active server.  The documentation is very vague.
> Here are my questions.
> >
> > How many nodes will I have?
> > How many scheduler services will I have on each server?
> > Do both nodes share one "cluster" dsm.opt file that resides in the same
> directory?
> >
> > Does anyone have step by step doc for an active/passive TSM cluster
server
> install?
> >
> > thx.
> >
> >
> > Regards, Joe

Re: Select Statement: The ANSWER

[Seay, Paul]

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 "CONNECTIONS", 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 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,
client_version, client_release, client_level, client_sublevel order by
MBytes desc

I had always wondered if this could be done.  I played with it until I
figured it out.  It was just a matter of looking at it from a group by point
of view.  The only problem is it does not fit across the screen.

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


-Original Message-
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 10:56 AM
To: [EMAIL PROTECTED]
Subject: Re: Select Statement


There are so many replies to this that look like contradictions to each
other that I'd like to look at this further on my system. I am not a SQL
guru by any means, I can't even seem to combine a couple of statements to
get what I need. Hopefully someone can help me(us) out here. I do an audit
license daily so this should come back with good, or in this case, bad
results.

When I try to combine these to get an output I always get a statement error.
I want to find out what levels are having the problem. I think it's
ridiculous that this does not work for "ALL" client levels. It always did in
the past and I can't understand why I have to now upgrade possibly 80 some
nodes to fix it. Why doesn't IBM fix their server code instead?

Could someone please combine these to get the necessary output? Client
level, node name, amount backed up and I think group by client level might
work.

Select for client level:

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


Select for amount backed up:

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 "CONNECTIONS" 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


Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (877) 905-7154



> -Original Message-
> From: Michel Engels [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 6:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Select Statement
>
>
> When I do remember well this problem appeared when I installed TSM
> Clients 5.1.0. There was a maintenance (I do not remember if it was
> 5.1.2 or 5.1.3) that solved the problem. Be sure you do an "audit
> license" regularly. I did not install a V5.1.5 yet, so I do not know
> if the problem reappears in that version.
>
> Hope this helps,
>
> Michel Engels
> Software Consultant
> Devoteam Belgium
>
>
>
>
>
>
> "Gill, Geoffrey L." <[EMAIL PROTECTED]> on 12/10/2002 11:16:02
> PM
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> To:   [EMAIL PROTECTED]
> cc:(bcc: Michel Engels/BE/Devoteam)
>
> Subject:  Select Statement
>
>
>
> I got this somewhere and I know it used to work on my 4x server. Now
> that I'm on 5.1.5.2 I get a lot of nodes report back with 0 Megabytes
> but they obviously sent files.
>
> Anyone who can make it work since my SQL stills are pretty much non
> existant?
>
> /**/
> /* Specify a date on the run line as follows  */
> /* run q_backup 2001-09-30*/
> /**/
> select entity as node_name, date(start_time) as date, - cast(activity
> as varchar(10)) as activity, time(start_time)as start, -
> time(end_time) as end, cast(bytes/100 as decimal(6,0))as
> megabytes, - cast(affected as decimal(7,0)) as files, successful from
> summary - where date(start_time)='$1' and activity='BACKUP' order by
> megabytes desc
>
>  NODE_NAME: NODEA
>   DATE: 2002-12-09
>   ACTIVITY: BACKUP
>  START: 20:00:51
>END: 20:48:07
> MEGABYTES: 0
>  FILES: 100
> SUCCESSFUL: YES
>
>
>
> This one does the same thing with some nodes. It also only reports
> about half the nodes even though it looks like it's supposed to be
> going back a full day.
>
> NODEA   NT_DOM WinNT
>   0.00
> 1
> select summary.entity as "NODE NAME", nodes.domain_name as "DOMAIN",
> nodes.platform_name as "PLA

Re: Copypool management

[Seay, Paul]

The best way is to use two different nodes and two different management
classes/copygroups/pools.  This way your offsite node is the only one used
to manage that data.  We do some things very similar to this.

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


-Original Message-
From: Roger Ward [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 11:35 AM
To: [EMAIL PROTECTED]
Subject: Copypool management


Multiple database backups to copypools?

How do I complete multiple database backups each day but only copy the most
current to offsite_pool for DR??



I did receive one good response to wanted to make sure that there were no
alternate ways of accomplishing this task???

Thanks, Roger

Re: Batch Command and security

[Seay, Paul]

You have to define them as a ADMIN with no grants.  They will get the query
commands with that by default.  That may be more than you want to give them.

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


-Original Message-
From: Elio Vannelli [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 3:58 AM
To: [EMAIL PROTECTED]
Subject: Batch Command and security


Hi guys,

I have to build a batch command so a client can query activity log. I
thought to do it processing the "dsmadmc -id=name -password=password"
command. As username and password pass in clear text, I think it's better
having a specific user in TSM server and rights only to read activity log.
Which kind of user have I to set?

Thanks in advance

Elio

Re: LAN free backup for Novell

[Seay, Paul]

The reality is this.  File system backups of small files are not a good
candidate for SAN Tape backups.  Netware does not run any large file
databases, so there is no SAN Storage Agent requirement.  The answer is
Gigabit between your TSM server and the client and let the TSM server stream
the data to the tape drives.  You will get as go performance, if not better
than a SAN backup would ever provide.

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


-Original Message-
From: Jin Bae Chi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 8:34 AM
To: [EMAIL PROTECTED]
Subject: LAN free backup for Novell


Hi, expets,

I'm trying to implement LAN free backup feature with TSM 4.2 on AIX 4.3.3
for client nodes with Novell servers. These NetWare servers are fibre
connected to EMC box through SAN switches. TSM support told me there is no
Storage Agent support for Netware platforms. Does anyone backup Novell
servers through Fibre Channel? What would be your suggestion to backup to
tape library that resides on SAN? Thanks again for your help!!





Jin Bae Chi (Gus)
System Admin/Tivoli
Data Center
614-287-5270
614-287-5488 Fax
[EMAIL PROTECTED]

Re: K-cartridges besides J-cartridges

[Seay, Paul]

And, if you look at a J and a K tape on the notches you will notice that
they have a different configuration.  So, if you put a K tape in a J only
drive, it will kick it right back out.  I thought that all B to E upgrade
kits were K capable.  I did not think that kit came out until the E upgrade
kit for K was available.  If your upgrade kits were installed after July
2001, they just about have to be K capable.

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


-Original Message-
From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:16 AM
To: [EMAIL PROTECTED]
Subject: Re: K-cartridges besides J-cartridges


Should see a "2X" sticker on the back of your 3590 drive if it is set to
deal with double length tapes. Also the internal tape spool is green (along
with one or two other internal parts, I seem to recall) so you might be able
to look in through the cooling holes in the top of the case to double check
(if you don't find a "2X" sticker on the drive)


Dwight



-Original Message-
From: Jim Sporer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 4:25 PM
To: [EMAIL PROTECTED]
Subject: Re: K-cartridges besides J-cartridges


There is a difference between the J and K tapes and the 3590 drives need to
support the extended length tapes.  If the drives are new there is no
problem but older 3590E drives may need an upgrade to support the extended
length tapes.  Check with your CE. Jim Sporer


At 11:12 PM 12/10/2002 +0100, you wrote:
>Hello,
>
>AIX 5.1, TSM 4.2.1.19, IBM 3494 library, 3590E-drives
>
>At the moment we use about 900 J-cartridges in our library. Is it
>possible to checkin K-cartridges and use them besides the J-cartridges.
>
>During upgrade from our drives from 3590B to 3590E we changed status of
>our volumes to read-only because of different tracks used on tape.
>
>As far as I know is the only difference between J and K the length of
>the tape, so I guess there will be no problem.
>
>I'm wondering if someone is using both J and K cartridges and if there
>encounter any problems.
>
>Thanx,
>
>Brian.
>
>
>
>
>
>
>_
>Chatten met je online vrienden via MSN Messenger.
>http://messenger.msn.nl/

Re: Market Share of TSM vs Legato Networker

[Seay, Paul]

Do not read into anything about market share statistics.  Suffice to say,
the only two products that get any significant press now are TSM and Veritas
NetBackup.  They have market share in around the 20 percentile.  A large
number of Backup Exec licenses exist and are continually sold, but that is a
very small environment solution and is Windows Only.  So, you can see how it
can claim installation in lots of sites.  Every company probably has 1 copy
of Backup Exec.

The real story is, what are your business requirements.  Forget the claims.

However, there is one document recently published on TSM and NetBackup.  It
wasn't a slam dunk of TSM over NetBackup, but it was pretty close.
Essentially, the report recognized the industry leading design (10 years
old) that TSM has for large environments.  You simply cannot perform full
backups anymore.  TSM's progressive backup and media management philosophy
is the answer for the forseeable future.

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


-Original Message-
From: Rupp Thomas (Illwerke) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 12:23 PM
To: [EMAIL PROTECTED]
Subject: Market Share of TSM vs Legato Networker


Hi TSM-ers,

is there a place where I can find information about the market share of TSM
and Legatos Networker in real busines environment (FORTUNE 500 etc.)? Tivoli
claims that 80% of the Fortune 500 companies use TSM.

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG







--
Dieses eMail wurde auf Viren geprueft.

Vorarlberger Illwerke AG

--

Re: Management Class and TDP for R/3

[Raghu S]

Hi Tom

You are controlling SAP R/3 database versioning through TSM, not TDP R/3
(  )




I take online backup on weekdays ( Mon - Satday ) & offline backup on
Sunday. Online backup and offline backup data goes onto separate
storagepools. I take offsite copy from offline backup storage pool.

How MAX_VERSION parameter of TDP R/3 works here? ( if i want to control
versioning through TDP R/3 ).
Does it see online and offline combinely or separately? If it treats online
and offline combinely , to maintain three versions of offline backup i
shoud use MAX_VERSIONS=21 which is going to eat 21 * 500 GB = 10.5 TB on my
tapepools (..it sounds tooo much ...). I should go back to TSM
version control.

However, tivoli recommends using TDP R/3 version controlling. Whats the big
reason behind??

Can you through some light on this?


Regards
Raghu.







"Kauffman,
Tom" To: [EMAIL PROTECTED]
 Subject: Re: Management Class and TDP for
Sent by: R/3
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


12/12/2002
02:29 AM
Please
respond to
"ADSM: Dist
Stor Manager"





Brian --

TDP/R3 does not use backup classes, it uses archive classes.

I currently have four SAP systems running, and have 7 management classes
defined.

First and foremost -- off-line redo log copies. I have two management
classes (PRDLOG1 and PRDLOG2) so I can have two seperate storage pool
chains, disk and tape. There's no point in doing two sets of logs if they
can end up on a common media somewhere. These two classes are used for all
SAP instance redo logs and have a 21-day retention (redo log retention
should match off-line backup retention).

PRDLOG1 ties to storage pool PRDLOG1 (disk) with next pool of PRDLOG1-LT
(lto tape). PRDLOG1-LT gets copied daily to PRDLOG1-LT-COPY for off-site
movement.

PRDLOG1 ties to storage pool PRDLOG2 (disk) with next pool of PRDLOG2-LT
(lto tape). PRDLOG2-LT gets copied daily to ARCH-LT-COPY for off-site
movement. (ARCH-LT-COPY also gets a copy of ARCH-LT which is the lto pool
for all non-SAP oracle archives).

Then my SAP data archive. The production instance uses management class
PRDSAP-ONLINE (online backups, 8 day retention) or PRDSAP-OFFLINE (21 day
retention -- run once per week). Both tie to tape storage pool PRDSAP-LT,
which copies daily to PRDSAP-LT-COPY for off-site rotation.

I do not run reclaims on any of the PRDSAP tape; I just let them die a
natural death after 8 or 21 days. I DO run reclaims on the redo log tapes
copies, and tend to have 4 to 6 lto tapes tied up in either class off-site.

My technical sandbox uses LOCALARCH as a management class. This ties to a
LOCALARCH disk pool with LOCAL-LT as next pool. 21 day retention, no
off-site copy (sandbox and test oracle databases, other archives of systems
that can be rebuilt from off-site copies of production environments).

My test/QA region uses TSTSAP as a mangement class, pointing to an LTO pool
TSTSAP-LT; 21 day retention, no off-site copy. We rebuild from the PRD
environment about every six weeks by cloning.

My DEV environment uses DEVSAP-LT as a management class, pointing to a disk
pool called ARCHIVEPOOL with next pool of ARCH-LT, 21 day retention (and
yes, it copies to ARCH-LT-COPY nightly).

In addition, I run weekly archives of the non-database SAP filesystems
(/sapmnt/SID, /oracle/SID, /usr/sap/trans, and a few local filesystems
using
the PRDLOG1 and PRDLOG2 management classes. These are done to speed up
point-in-time recovery at D/R by laying down the most recent Sunday from
the
archive and then restoring to 'now'.

SAP recommends you keep 3 generations of your off-line backup (archive); 21
days works if you do this weekly. If you run off-line monthly you'll want
90+ days and need to adjust redo log retention to match.

Is there anything else I can add to further confuse the issue? 

The mish-mosh of pools I use has been set up to optimise D/R recovery and
the off-site storage pool backup process. They work for us; we've had a
number of successful D/R drills over the years.

Tom Kauffman
NIBCO, Inc

> -Original Message-
> From: brian welsh [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: Management Class and TDP for R/3
>
>
> Hello,
>
> Server AIX 5.1, TSM 4.2.2.8. Client AIX 4.3, TSM 4.2.1.25,
> and TDP for R/3
> 3.2.0.11 (Oracle)
>
> Question about TDP.
>
> We wanted to use the Management Class on the TSM-server like this:
> Versions Data ExistsNOLIMIT
> Versions Data Deleted   3
> Retain Extra Versions   21
> Retain Only Version 30
>
> In the Guide Tivoli Data Protection for R/3 Installation 

Re: Management Class and TDP for R/3

[Seay, Paul]

We have setup something almost identical to what Tom has done.  This is an
excellent design based on our experiences as well.  Our retentions are
different, but we use the same concepts.

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


-Original Message-
From: Kauffman, Tom [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Management Class and TDP for R/3


Brian --

TDP/R3 does not use backup classes, it uses archive classes.

I currently have four SAP systems running, and have 7 management classes
defined.

First and foremost -- off-line redo log copies. I have two management
classes (PRDLOG1 and PRDLOG2) so I can have two seperate storage pool
chains, disk and tape. There's no point in doing two sets of logs if they
can end up on a common media somewhere. These two classes are used for all
SAP instance redo logs and have a 21-day retention (redo log retention
should match off-line backup retention).

PRDLOG1 ties to storage pool PRDLOG1 (disk) with next pool of PRDLOG1-LT
(lto tape). PRDLOG1-LT gets copied daily to PRDLOG1-LT-COPY for off-site
movement.

PRDLOG1 ties to storage pool PRDLOG2 (disk) with next pool of PRDLOG2-LT
(lto tape). PRDLOG2-LT gets copied daily to ARCH-LT-COPY for off-site
movement. (ARCH-LT-COPY also gets a copy of ARCH-LT which is the lto pool
for all non-SAP oracle archives).

Then my SAP data archive. The production instance uses management class
PRDSAP-ONLINE (online backups, 8 day retention) or PRDSAP-OFFLINE (21 day
retention -- run once per week). Both tie to tape storage pool PRDSAP-LT,
which copies daily to PRDSAP-LT-COPY for off-site rotation.

I do not run reclaims on any of the PRDSAP tape; I just let them die a
natural death after 8 or 21 days. I DO run reclaims on the redo log tapes
copies, and tend to have 4 to 6 lto tapes tied up in either class off-site.

My technical sandbox uses LOCALARCH as a management class. This ties to a
LOCALARCH disk pool with LOCAL-LT as next pool. 21 day retention, no
off-site copy (sandbox and test oracle databases, other archives of systems
that can be rebuilt from off-site copies of production environments).

My test/QA region uses TSTSAP as a mangement class, pointing to an LTO pool
TSTSAP-LT; 21 day retention, no off-site copy. We rebuild from the PRD
environment about every six weeks by cloning.

My DEV environment uses DEVSAP-LT as a management class, pointing to a disk
pool called ARCHIVEPOOL with next pool of ARCH-LT, 21 day retention (and
yes, it copies to ARCH-LT-COPY nightly).

In addition, I run weekly archives of the non-database SAP filesystems
(/sapmnt/SID, /oracle/SID, /usr/sap/trans, and a few local filesystems using
the PRDLOG1 and PRDLOG2 management classes. These are done to speed up
point-in-time recovery at D/R by laying down the most recent Sunday from the
archive and then restoring to 'now'.

SAP recommends you keep 3 generations of your off-line backup (archive); 21
days works if you do this weekly. If you run off-line monthly you'll want
90+ days and need to adjust redo log retention to match.

Is there anything else I can add to further confuse the issue? 

The mish-mosh of pools I use has been set up to optimise D/R recovery and
the off-site storage pool backup process. They work for us; we've had a
number of successful D/R drills over the years.

Tom Kauffman
NIBCO, Inc

> -Original Message-
> From: brian welsh [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: Management Class and TDP for R/3
>
>
> Hello,
>
> Server AIX 5.1, TSM 4.2.2.8. Client AIX 4.3, TSM 4.2.1.25, and TDP for
> R/3 3.2.0.11 (Oracle)
>
> Question about TDP.
>
> We wanted to use the Management Class on the TSM-server like this:
> Versions Data ExistsNOLIMIT
> Versions Data Deleted   3
> Retain Extra Versions   21
> Retain Only Version 30
>
> In the Guide Tivoli Data Protection for R/3 Installation & User's
> Guide for Oracle is mentioned to define 4 different Management
> Classes. I was wondering how other people have defined there
> Management Classes. Support
> told me to use 4 different Management Classes because it's in
> the manual so
> they mention something with it (maybe for in the future), but
> what is the
> advantage of 4 different Management Classes. We have 8
> TDP-clients. The
> manual is saying every client his own 4 different Management
> Classes. It's
> not easy to manage that way.
>
> Besides you have to define an archive-copy group. We don't want to use
> Versioning in TDP, but use expiration via TSM-client/server. How many
> days I have to define the archive-copy group. I think it has to be
> 21 days. I guess
> that when using Versioning in TDP you have to set these
> parameter on .
> Am I right.
>
> Is there somebody who want to share the definitons used for TDP for
> Management Classes and Copy Groups?
>
> Thanx,
>
> Brian.
>
>
>

Re: ADSM-L Digest - 10 Dec 2002 to 11 Dec 2002 (#2002-345)

[Lisa Galindo]

I'm out of the office until 12/16, but will read email once a day.

Re: TSM in a MS Cluster environment

[Wholey, Joseph (TGA\\MLOL)]

Manuel,

This does help...  I have only one group.  Can I, for example, put the dsm.opt file on 
an "H" drive, and have both client 1 and 2 point to that dsm.opt file.  So if server 1 
fails, server 2 will start
up the group scheduler and manage the backups.

Regards, Joe

-Original Message-
From: Manuel Schweiger [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 5:19 PM
To: [EMAIL PROTECTED]
Subject: Re: TSM in a MS Cluster environment


Joe,

You will need to set up 1 TSM client for each cluster node and 1 TSM client
for each cluster group.
Best to do a simple example on this:

Cluster: 2 Nodes, 3 Groups

Installation Node 1:

TSM Client Local1
TSM Client Group1
TSM Client Group2
TSM Client Group3
Every group has its own schedulers, client acceptors and remote agents
(those of group1-3 have to switch with the cluster)..

Installation Node 2:

TSM Client Local2
TSM Client Group1
TSM Client Group2
TSM Client Group3
(Group 1-3 have to be set up exactly like on Node 1!!)

Hope that helps a little.

regards, Manuel


- Original Message -
From: "Wholey, Joseph (TGA\MLOL)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 10:52 PM
Subject: TSM in a MS Cluster environment


> I'm about to install TSM in a MS cluster environment.  I've done this with
success in the past in an active/active environment where each server has 3
TSM scheduler services.  e.g.  local scheduler,
> scheduler_service_for_group_A, scheduler_service_for_group_B.
>
> I've not done it in an active/passive environment where all resources
normally belong to the active server.  The documentation is very vague.
Here are my questions.
>
> How many nodes will I have?
> How many scheduler services will I have on each server?
> Do both nodes share one "cluster" dsm.opt file that resides in the same
directory?
>
> Does anyone have step by step doc for an active/passive TSM cluster server
install?
>
> thx.
>
>
> Regards, Joe

Re: TSM in a MS Cluster environment

[Wholey, Joseph (TGA\\MLOL)]

Bruce,

Was it an active/passive or active/active cluster environment.

Regards, Joe

-Original Message-
From: Bruce Kamp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:48 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM in a MS Cluster environment


I set it up is the same way.  Three schedulers & 3 opt files.  One thing to
make sure is that you build both sides of the cluster before adding the
registry key replication in the cluster resource.  Documentation isn't
specific on this  Caused me about 3 days on the phone with level 1 &
level 2 support & I ended up figuring it out on my own by dumb luck!
Hope this helps!

---
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E-mail: [EMAIL PROTECTED]
Phone: (954) 987-2020 x4597
Fax: (954) 985-1404
---


-Original Message-
From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 4:52 PM
To: [EMAIL PROTECTED]
Subject: TSM in a MS Cluster environment


I'm about to install TSM in a MS cluster environment.  I've done this with
success in the past in an active/active environment where each server has 3
TSM scheduler services.  e.g.  local scheduler,
scheduler_service_for_group_A, scheduler_service_for_group_B.

I've not done it in an active/passive environment where all resources
normally belong to the active server.  The documentation is very vague.
Here are my questions.

How many nodes will I have?
How many scheduler services will I have on each server?
Do both nodes share one "cluster" dsm.opt file that resides in the same
directory?

Does anyone have step by step doc for an active/passive TSM cluster server
install?

thx.


Regards, Joe

Re: HSM

[Richard Sims]

> Anyone have a particularly large HSM environment and been using it a while?

We have been using ADSM HSM for years, principally for archiving system log files
and like stuff, which we retain for five years.  HSM makes this practical, and
affords obviousness of the stored data (unlike ADSM Archive) and ready retrievability.
Suffice to say we have many gigabytes of it.  For this it works nicely.

We had early on anticipated rolling out HSM more generally - but then realized
the problems.  HSM is a DISASTER when used over NFS...  Picture gigabytes of data
flowing into a file system over NFS; then the file system fills.  Automigration
makes what space it can - but that's not enough.  Reconciliation is now running
on the file system, but that can take up to 2 hours.  Now the file system is
full, and the HSM session is wedged.  This causes *all* NFS service from that
system to cease, and wide-spread chaos ensues as even innocent 'df' commands
issued on other systems which have that file system NFS-mounted hang, and can
not be freed until the NFS server again responds.  This, in combination with
fragmentation issues and other factors, caused us to deem HSM not for civilians.
HSM has its uses, but is awfully Rube Goldberg.  You may first want to consider
file systems which autocompress data stored in them.

  Richard Sims, BU

Network drive backup with Storage Agent

[Jin Bae Chi]

Hi, TSMers,

This is kind of followup question I opened previously with 'LAN free
backup of Novell'; I found out TSM doesn't have Storage Agent for
NetWare platform.

As alternative solution, I plan to install Storage Agent on a Windows
2000 client and backup all network drives ( G: H: I: J: etc) to do LAN
free backup to tape library, 3575.  As we are Novell shop, I wonder if I
can backup data with NSS format from network drives (actual data resides
on EMC Clariion box) and restore them to original place without
corrupting the data, using Windows as client platform? Any comment will
be appreciated. Thanks.








Jin Bae Chi (Gus)
System Admin/Tivoli
Data Center
614-287-5270
614-287-5488 Fax
[EMAIL PROTECTED]

Re: tsm server monitoring products

[Lambelet,Rene,VEVEY,GL-CSC]

Hi, we use tsmmanager (www.tsmmanager.com), really nice and usefull,

René LAMBELET
NESTEC  SA
GLOBE - Global Business Excellence
Central Support Center
Information Technology
Av. Nestlé 55  CH-1800 Vevey (Switzerland) 
tél +41 (0)21 924 35 43   fax +41 (0)21 703 30 17   local
UBS-Nestec, Bussigny
mailto:[EMAIL PROTECTED]

This message is intended only for the use of the addressee
and may contain information that is privileged and confidential.


-Original Message-
From: Justin Bleistein [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 8:32 PM
To: [EMAIL PROTECTED]
Subject: tsm server monitoring products


Like "servergraph" does anyone have a list of anymore products for this
purpose. I'm trying to compile a list of products so that I can review them
for our environment?. Thanks!.

--Justin Richard Bleistein
Unix Systems Administrator (Sungard eSourcing)
Desk: (856) 866 - 4017
Cell:(856) 912-0861
Email: [EMAIL PROTECTED]

Re: HSM

[Mark D. Rodriguez]

Gerald Wichmann wrote:


Anyone have a particularly large HSM environment and been using it a while?
I'm curious on any experiences with the product, good or bad. I would
imagine there must be some people out there who need long term storage of
infrequently accessed files and have considered it as a solution for that.

Gerald Wichmann
Senior Systems Development Engineer
Zantaz, Inc.
925.598.3099 (w)



This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm)
service.  For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law.  If the reader of this message is not the intended recipient, or the
employee or agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this communication in error, please notify the sender immediately by
telephone or directly reply to the original message(s) sent.  Thank you.



Hi,

I have one customer that may fall into the large HSM category.  They
have a document management program that is based around HSM.  The last
time I did an update to the server they had about 6 Million documents
each of which contains a few to many different files.  They have about
500GB of local storage for the stub files and local cacheing and are
using several 3995 Optical libraries to migrate the data to.

I also work with a different customer that has a similar environment but
it is not as large.  They are only managing about 2.5 to 3 million files
and require only one 3995 library with just over 1 TB of data.

Both of these system work really well.  Performance is very good.  In
fact one of the customers has a requisite to be able to produce any one
of the millions of documents on the screen in under 3 minutes!  That
time includes doing the search thru the application database to
determine the needed files, issuing the recall from ITSM server, loading
the Optical platter, transmitting the data, assemble it and display it
on the screen!  I was quite impressed with how well it handles that.

Like any product it has its quirks but for the most part once it is set
up it just works!

If you have any specific questions or need help with your environment
please feel free to contact me.

--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

===
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux
Red Hat Certified Engineer, RHCE
===

Re: HSM

[Remco Post]

On Wed, 11 Dec 2002 10:37:02 -0800
"Gerald Wichmann" <[EMAIL PROTECTED]> wrote:

> Anyone have a particularly large HSM environment and been using it a
> while?

We have about 0.5 and about 1 TB in HSM, no problem. Until this year,
HSM never f***ed up, and even then I just had to restore one or two
directories of stub-files and I'm still unsure weather HSM or the aix
nfs server was at fault. "Migration requires backup" is a sensible thing
to use, as are fast (3590/stk9840/stk9940) tape drives and a very fast
library, mount and seek-times are the bottle-neck in performance...

> I'm curious on any experiences with the product, good or bad. I would
> imagine there must be some people out there who need long term storage
> of infrequently accessed files and have considered it as a solution
> for that.
>
> Gerald Wichmann
> Senior Systems Development Engineer
> Zantaz, Inc.
> 925.598.3099 (w)
>
>


Remco Post

Re: HSM

[asr]

=> On Wed, 11 Dec 2002 10:37:02 -0800, Gerald Wichmann <[EMAIL PROTECTED]> said:


> Anyone have a particularly large HSM environment and been using it a while?
> I'm curious on any experiences with the product, good or bad. I would
> imagine there must be some people out there who need long term storage of
> infrequently accessed files and have considered it as a solution for that.


We don't have a "particularly large" HSM: We've got about 60GB migrated and
premigrated of system logs (trying to keep them forever) and another 60GB of
database load files.

Don't use shared memory transport.  TSM chokes itself on shared memory on a
regular, and rapid, basis.

Unfortunately, this means that even if you host the HSM filesystem on the TSM
server, you need to do network access through loopback.  D'oh, Sl'oh.  But for
HSM, you don't usually care about slow.

One interesting thing about HSM these days: Think about your incremental price
delta for new storage.

I think we quoted 18x36GB SSA, plus drawer, at $25K.  Raid5, hot spare, and
you've got $43/GB.

Take your new S frame at $21K, fill it with $50 K-tapes, pay $41K.

>From that make one primary, one copy stgpool.

Assume 1.5x compression across all data.

I make that $3.41/GB, if you _WRITE OFF_ such irrelevancies as, oh, the
server, the drives, etc.


Just keep those comaprisons in the back of your head as you evaluate possible
HSM applications.


- Allen S. Rout

tape to tape copy

[StorageGroupAdmin StorageGroupAdmin]

Hello,
 
Running TSM 5.1 on Solaris 8, using IBM 3590's in an ATL over a SAN (& SAN DATA 
GATEWAYS)
 
Does anyone know how to copy a TSM BACKUPSET series of tapes directly to another set 
of tapes (1 at a time is fine)
 
I already know the following: TSM has no way of doing this.
Solaris DD or TAR cannot do this as it requires EOT markers on each tape
IBM TCOPY also cannot do this as it also requires EOT markers on each tape (tcopy can 
copy a backupset on a single tape)
MMUNIX software cannot see scsi tapes in an ATL over the SAN.
 
I do not have the space to recover the data and make another copy.
 
Appreciate any help,
 
Thanks
Anthony Langford
Sydney Water



---
Voluntary water restrictions now apply to residents in
Sydney, Blue Mountains and the Illawarra.  
No sprinklers or watering systems between 8am and 8pm. 
No hosing of paths, buildings or hard surfaces. 
For more information visit www.sydneywater.com.au
---
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.
---

Re: TSM SERVER 5.1.5.2 Performance Issue

[Seay, Paul]

PQ68076 is MVS ONLY related to GETMAIN activity, not AIX and there is no
equivalent issue on AIX.  So, the problem is something else.

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


-Original Message-
From: Dan Foster [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:16 PM
To: [EMAIL PROTECTED]
Subject: Re: TSM SERVER 5.1.5.2


Hot Diggety! David Longo was rumored to have written:
> 5.1.5.2 has been out about a month or so now.
> Also that something else isn't broke?

There was a major performance bug fixed in 5.1.5.3; we had a really nasty
situation where a west coast client was sending data at only 2 Mbps to the
east coast server; raw network between the two is up to 32 Mbps as evidenced
by ttcp tests between west coast client and other east coast servers on the
same subnet.

Turns out we needed an efix for the pre-release version of fixed netinet
driver in AIX 5.1 (to be bos.net.tcp.client 5.1.0.37 and released next week)
to fix the OS perf bug *AND* to also upgrade to 5.1.5.3 from 5.1.5.2.

Doing so improved the ITSM network perf from 2 Mbps to 8 Mbps, and raw OS
network perf to 32 Mbps. Merely fixing the OS perf bug wasn't sufficient for
us. (We tested and retested between every single step to rule out multiple
variables.)

>From the 5.1.5.3 README:

PQ68076 PERFORMANCE DEGRADATION AFTER UPGRADE TO 5.1.5.0, 5.1.5.1 OR

-Dan

Re: Management Class and TDP for R/3

[Kauffman, Tom]

Brian --

TDP/R3 does not use backup classes, it uses archive classes.

I currently have four SAP systems running, and have 7 management classes
defined.

First and foremost -- off-line redo log copies. I have two management
classes (PRDLOG1 and PRDLOG2) so I can have two seperate storage pool
chains, disk and tape. There's no point in doing two sets of logs if they
can end up on a common media somewhere. These two classes are used for all
SAP instance redo logs and have a 21-day retention (redo log retention
should match off-line backup retention).

PRDLOG1 ties to storage pool PRDLOG1 (disk) with next pool of PRDLOG1-LT
(lto tape). PRDLOG1-LT gets copied daily to PRDLOG1-LT-COPY for off-site
movement.

PRDLOG1 ties to storage pool PRDLOG2 (disk) with next pool of PRDLOG2-LT
(lto tape). PRDLOG2-LT gets copied daily to ARCH-LT-COPY for off-site
movement. (ARCH-LT-COPY also gets a copy of ARCH-LT which is the lto pool
for all non-SAP oracle archives).

Then my SAP data archive. The production instance uses management class
PRDSAP-ONLINE (online backups, 8 day retention) or PRDSAP-OFFLINE (21 day
retention -- run once per week). Both tie to tape storage pool PRDSAP-LT,
which copies daily to PRDSAP-LT-COPY for off-site rotation.

I do not run reclaims on any of the PRDSAP tape; I just let them die a
natural death after 8 or 21 days. I DO run reclaims on the redo log tapes
copies, and tend to have 4 to 6 lto tapes tied up in either class off-site.

My technical sandbox uses LOCALARCH as a management class. This ties to a
LOCALARCH disk pool with LOCAL-LT as next pool. 21 day retention, no
off-site copy (sandbox and test oracle databases, other archives of systems
that can be rebuilt from off-site copies of production environments).

My test/QA region uses TSTSAP as a mangement class, pointing to an LTO pool
TSTSAP-LT; 21 day retention, no off-site copy. We rebuild from the PRD
environment about every six weeks by cloning.

My DEV environment uses DEVSAP-LT as a management class, pointing to a disk
pool called ARCHIVEPOOL with next pool of ARCH-LT, 21 day retention (and
yes, it copies to ARCH-LT-COPY nightly).

In addition, I run weekly archives of the non-database SAP filesystems
(/sapmnt/SID, /oracle/SID, /usr/sap/trans, and a few local filesystems using
the PRDLOG1 and PRDLOG2 management classes. These are done to speed up
point-in-time recovery at D/R by laying down the most recent Sunday from the
archive and then restoring to 'now'.

SAP recommends you keep 3 generations of your off-line backup (archive); 21
days works if you do this weekly. If you run off-line monthly you'll want
90+ days and need to adjust redo log retention to match.

Is there anything else I can add to further confuse the issue? 

The mish-mosh of pools I use has been set up to optimise D/R recovery and
the off-site storage pool backup process. They work for us; we've had a
number of successful D/R drills over the years.

Tom Kauffman
NIBCO, Inc

> -Original Message-
> From: brian welsh [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: Management Class and TDP for R/3
>
>
> Hello,
>
> Server AIX 5.1, TSM 4.2.2.8. Client AIX 4.3, TSM 4.2.1.25,
> and TDP for R/3
> 3.2.0.11 (Oracle)
>
> Question about TDP.
>
> We wanted to use the Management Class on the TSM-server like this:
> Versions Data ExistsNOLIMIT
> Versions Data Deleted   3
> Retain Extra Versions   21
> Retain Only Version 30
>
> In the Guide Tivoli Data Protection for R/3 Installation &
> User's Guide for
> Oracle is mentioned to define 4 different Management Classes. I was
> wondering how other people have defined there Management
> Classes. Support
> told me to use 4 different Management Classes because it's in
> the manual so
> they mention something with it (maybe for in the future), but
> what is the
> advantage of 4 different Management Classes. We have 8
> TDP-clients. The
> manual is saying every client his own 4 different Management
> Classes. It's
> not easy to manage that way.
>
> Besides you have to define an archive-copy group. We don't want to use
> Versioning in TDP, but use expiration via TSM-client/server.
> How many days I
> have to define the archive-copy group. I think it has to be
> 21 days. I guess
> that when using Versioning in TDP you have to set these
> parameter on .
> Am I right.
>
> Is there somebody who want to share the definitons used for TDP for
> Management Classes and Copy Groups?
>
> Thanx,
>
> Brian.
>
>
>
>
>
> _
> Chatten met je online vrienden via MSN Messenger.
http://messenger.msn.nl/

Re: RedHat 8 and TSM Client

[Mark D. Rodriguez]

Jeff Rogers wrote:


Before I go and upgrade my Thinkpad to RedHat Linux 8,  does anybody know
if the TSM client runs on RH 8?

It would be a bummer to wipe my machine out, install a new OS, only to find
out I can't get at my backups anymore.

-JeffR



Jeff,

IMHO, I would avoid RH 8.0!  Every Linux mailing list out there is
flooded with complaints and problems with RH 8.0.  Red Hat is
notoriously bad with there *.0 versions.  I would wait for the RH 8.1
As mentioned already there are some library differences.  Also, the
desktop environment has been hacked beyond recognition.

But hey, if you have to go to RH8.0 then I wish you luck and let us know
how it goes.

--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

===
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux
Red Hat Certified Engineer, RHCE
===

Re: Management Class and TDP for R/3

[Davidson, Becky]

For my SAP systems I have 4 management classes
_saplog1
_saplog2
_sapincr
_cold  

Re: bad tape

[PINNI, BALANAND (SBCSI)]

If tape is not getting deleted
Say

Delete volume  discard=yes force=yes

With force=yes u may get error but it will be deleted.Since its 0 bytes hope
its ok for u.

Balanand Pinni

-Original Message-
From: Robert L. Rippy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 1:40 PM
To: [EMAIL PROTECTED]
Subject: Re: bad tape

I have some like that also. Usually an audit of the database will clear
those up, they have with mine. But some databases are so large that the
server can't be down that long. If you figure out another way without a
long outage, let me know.

Thanks,
Robert Rippy



From: Joni Moyer <[EMAIL PROTECTED]> on 12/11/2002 11:52 AM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  bad tape

Hello everyone!

I have a weird situation and I wasn't quite sure what to do.  I have a bad
tape that is vaulted.  It has 0 data on it, but it won't delete from TSM.
The reuse delay is way past expiration, so it isn't being held by that.
Does anyone have any suggestions?  Thanks!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338

Management Class and TDP for R/3

[brian welsh]

Hello,

Server AIX 5.1, TSM 4.2.2.8. Client AIX 4.3, TSM 4.2.1.25, and TDP for R/3
3.2.0.11 (Oracle)

Question about TDP.

We wanted to use the Management Class on the TSM-server like this:
Versions Data ExistsNOLIMIT
Versions Data Deleted   3
Retain Extra Versions   21
Retain Only Version 30

In the Guide Tivoli Data Protection for R/3 Installation & User's Guide for
Oracle is mentioned to define 4 different Management Classes. I was
wondering how other people have defined there Management Classes. Support
told me to use 4 different Management Classes because it's in the manual so
they mention something with it (maybe for in the future), but what is the
advantage of 4 different Management Classes. We have 8 TDP-clients. The
manual is saying every client his own 4 different Management Classes. It's
not easy to manage that way.

Besides you have to define an archive-copy group. We don't want to use
Versioning in TDP, but use expiration via TSM-client/server. How many days I
have to define the archive-copy group. I think it has to be 21 days. I guess
that when using Versioning in TDP you have to set these parameter on .
Am I right.

Is there somebody who want to share the definitons used for TDP for
Management Classes and Copy Groups?

Thanx,

Brian.





_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/

tsm server monitoring products

[Justin Bleistein]

Like "servergraph" does anyone have a list of anymore products for this
purpose. I'm trying to compile a list of products so that I can review them
for our environment?. Thanks!.

--Justin Richard Bleistein
Unix Systems Administrator (Sungard eSourcing)
Desk: (856) 866 - 4017
Cell:(856) 912-0861
Email: [EMAIL PROTECTED]

Re: bad tape

[Robert L. Rippy]

I have some like that also. Usually an audit of the database will clear
those up, they have with mine. But some databases are so large that the
server can't be down that long. If you figure out another way without a
long outage, let me know.

Thanks,
Robert Rippy



From: Joni Moyer <[EMAIL PROTECTED]> on 12/11/2002 11:52 AM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  bad tape

Hello everyone!

I have a weird situation and I wasn't quite sure what to do.  I have a bad
tape that is vaulted.  It has 0 data on it, but it won't delete from TSM.
The reuse delay is way past expiration, so it isn't being held by that.
Does anyone have any suggestions?  Thanks!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338

Re: question on backupset volumes: how to count them ?

[Prather, Wanda]

This will give you the list of backupset volumes form volhistory:

 select volume_name from volhistory  where type='BACKUPSET'

This will give you the NUMBER of backupset volumes from volhistory:

select count(volume_name) from volhistory where type='BACKUPSET'

This will give you a list of the backupset volumes that are NOT checked in:

   select volume_name from volhistory where type='BACKUPSET' and volume_name
not in (select volume_name from libvolumes)

This will give you the NUMBER of backupset volumes that are NOT checked in:

  select count(volume_name) from volhistory where type='BACKUPSET' and
volume_name not in  (select volume_name from libvolumes)




-Original Message-
From: Rainer Wolf [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 10:54 AM
To: [EMAIL PROTECTED]
Subject: question on backupset volumes: how to count them ?


Hello,
sorry if this is often asked or I haven't found the doc...
I have the following problem:
We are using aix tsm server 4.2.2.13 and a 3494 Library with k- and j-tapes.
Backupsets of clients are created with duration of 999 and the
only device-class for backupset-voluems is the devclass of the 3494 library.
Now some of the Backupset - tapes are checked out and some are still in
the Library. Some of the online Backupset-Volumes have been once
checked out and are checked in again with status=private-
I have not found something equivalent like 'q drmed ... for
DBBackup-Volumes'
for thoe backupset-volumes.

Now i am looking for a good way to ...
... to count the total number of those 3494 Backupset volumes
  ( online OR offline )
... only to get the number of the currently checked-in backupset volumes
  in the library.
  Maybe a problem is, that some of the online backup-set-volumes
  have been once checked out and then checked in again and may appear
  just as private ( in the q libvol ... ) ?
  So do I have to combine something like 'q libvol' and 'q volhist
t=backupset'
  to get it ?
...  count the number ( online or offline  )
  of tapes depending on the node, for whom this backupset is created ?

Thanks for any help/scripts/macros :-)
Rainer


--

---
Rainer Wolf mail:
[EMAIL PROTECTED]
tel: ++49 731 50-22482  fax:  ++49 731 50-22471
Computing Center, University of Ulm, Germanyweb:
http://www.uni-ulm.de/urz

Re: ?? Cost on a storage frame on 3494

[Lisa Cabanas]

>I hear IBM are doing a seasonal special on this very upgrade right now.

I always love their "fire sale" specials (3Q & 4Q) ;-)


   
 
John Wright
 
cc:   
 
Sent by: Subject: Re: ?? Cost on a storage frame 
on 3494
"ADSM: Dist
 
Stor Manager"  
 
<[EMAIL PROTECTED] 
 
IST.EDU>   
 
   
 
   
 
12/11/2002 
 
10:05 AM   
 
Please respond 
 
to "ADSM: Dist 
 
Stor Manager"  
 
   
 




Last retail price I had on a frame was about £21k though discounts are
available.

3590H. I looked into these, they can be SCSI or Fibre channel. If you
already have SCSI the default upgrade is to 3590H SCSI.
For a few hundred £ more you can have them converted to FC at the same
time you have the upgrade done.
These can be directly fibre attached to the Unix host or to the host via a
switched network but don't forget to include fibre HBAs for the Host in
your budget.

I hear IBM are doing a seasonal special on this very upgrade right now.

Regards
John




"Lisa Cabanas" <[EMAIL PROTECTED]>

Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
11-Dec-2002 15:47
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>




To: ADSM-L

cc:
Subject:?? Cost on a storage frame on 3494

Howdy all,

any one have a quick and dirty estimate of what a storage frame runs on a
3494 (retail, gov't)?  My IBM contacts are out of the office today, and
one
of my bosses wants to talk storage planning today.  I have prices for the
L12 and D12.

While I'm at it-- any of you guys with the new H drives-- what do they run
(the FC ones?)

thanks!!

lisa

Re: bad tape

[Alan Davenport]

Is the tape in "readonly" or "Offsite" status? I found that tapes will not
scratch unless they are in "readwrite" status.

   Al

Alan Davenport
Senior Storage Administrator
Selective Insurance Co. of America
[EMAIL PROTECTED]
(973) 948-1306


-Original Message-
From: Joni Moyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: bad tape


Hello everyone!

I have a weird situation and I wasn't quite sure what to do.  I have a bad
tape that is vaulted.  It has 0 data on it, but it won't delete from TSM.
The reuse delay is way past expiration, so it isn't being held by that.
Does anyone have any suggestions?  Thanks!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338

Re: Question about Veritas Cluster and filespace name

[Jim Kirkman]

You know, there seems to be a similar issue with filespace naming with the new Netware 
cluster aware client. We're awaiting a server
upgrade to pursue it further. Seems as it the 'getservername' API call is at the heart 
of this.



David Rigaudiere wrote:

> Yes, i have exactly the same problem with Windows & Double-Take,
> i would like change the way that TSM nam the the filespacing naming
> process.
>
> --
> David  Rigaudiere  -+-  Administration  TSM + NT
> Paris -+- 40, rue de Courcelles -+- 4e étage -+-
> [EMAIL PROTECTED] -+- 01.5621.7802
>
> |-+--->
> | |   Peter Bjoern|
> | || |   .DK>|
> | |   Sent by: "ADSM: |
> | |   Dist Stor   |
> | |   Manager"|
> | |   <[EMAIL PROTECTED]|
> | |   T.EDU>  |
> | |   |
> | |   |
> | |   11/12/2002 12:45|
> | |   Please respond  |
> | |   to "ADSM: Dist  |
> | |   Stor Manager"   |
> | |   |
> |-+--->
>   
>>|
>   |  
> |
>   |To:  [EMAIL PROTECTED] 
> |
>   |cc:   
> |
>   |Subject: Question about Veritas Cluster and filespace name
> |
>   
>>|
>
> Hi
>
> We have a situation with a Veritas cluster installed on two Win2000
> servers.
> The physical servers are called J2P-CLUSTER101 and J2P-CLUSTER102.
> There is a virtual server defined with the name WEB1.
>
> Each physical server has it's own C: drive which is backed up via a
> schedule
> that specifies 'C:' and 'systemobject' on the domain statement in the
> option file.
> The C: filespaces are given the names \\J2P-CLUSTER101\C$ and
> \\J2P-CLUSTER102\C$ respectively.  This is all OK.
>
> There is a shared drive X: which is associated with the WEB1 resource and
> moves with WEB1 between the two physical servers so that it is available
> either on J2P-CLUSTER101 or J2P-CLUSTER102.
>
> X: is backed up from a virtual node defined in TSM called WEB1 and via a
> separate TSM scheduler
> service with an option file that  specifies X: on the domain statement.
>
> If this had been a Microsoft Cluster installation, we would have specified
> 'CLUSTERNODE YES' in the optionfiles to make TSM name the X: filespace
> with the virtual clustername (WEB1) so that it would have been named
> \\WEB1\X$ regardless of which physical server it was backed up from.
>
> However, CLUSTERNODE does not work with a Veritas cluster, so the result is
> that we get two parallel filespaces named  \\J2P-CLUSTER101\X$ and
> \\J2P-CLUSTER101\X$ because X: sometimes resides on J2P-CLUSTER101
> and some times on J2P-CLUSTER102.
>
> From previous postings on this list I get the impression that there is
> nothing
> we can do to solve this, but I just want to be sure if this is true
>
> How are other people who are running Veritas clusters and TSM solving this
> ?
>
> This is a bad situation and one could fear (from a TSM person point of
> view) that
> it could pave the way for the introduction of Veritas backup software at
> the site.
>
> If CLUSTERNODE cannot easily be enhanced to support Veritas clusters as
> well, all we would need would be a new statement in the option file,
> perhaps called
> MACHINENAME or so, where we could specify 'MACHINENAME WEB1' in the
> optionfile and then have TSM use this name is the filespacing naming
> process.
>
> Regards
>
> Peter
>
> ---
> This message (including any attachments) is confidential and may be
> privileged. If you have received it by mistake please notify the sender by
> return e-mail and delete this message from your system. Any unauthorised
> use or dissemination of this message in whole or in part is strictly
> prohibited. Please note that e-mails are susceptible to change.
> ABN AMRO Bank N.V. (including its group companies) shall not be liable for
> the improper or incomplete transmission of the information contained in
> this communication nor for any delay in its receipt or damage to your
> system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that
> the integr

Win 2k File system failures

[Pete Vittands]

I am trying to back up all local drives on a Windows 2000 TSM 5.15 client.
Server is at 5.1.5 as well.  The backups work fine for all of my other boxes
that are almost identical.  This box fails every time on the same file
systems.  I get the following errors:


12/05/2002 23:57:24 ANS1228E Sending of object '\\server\v$ <\\server\v$> '
failed
12/05/2002 23:57:24 ANS1063E Invalid path specification

This look familiar to anyone.  I have looked for some answers online but did
not come across anything.
Thanks for your help in advance.



Pete Vittands
Microsoft Certified System Engineer
Microsoft Certified System Administrator
IBM High End Disk Solutions Specialist
IBM certified specialist for System Support
IBM certified specialist for System Administration
Tivoli Certified Consultant

Systems & Software, Inc.
e:  [EMAIL PROTECTED]
w:  www.ssiutilitysuite.com 

HSM

[Gerald Wichmann]

Anyone have a particularly large HSM environment and been using it a while?
I'm curious on any experiences with the product, good or bad. I would
imagine there must be some people out there who need long term storage of
infrequently accessed files and have considered it as a solution for that.

Gerald Wichmann
Senior Systems Development Engineer
Zantaz, Inc.
925.598.3099 (w)



This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm)
service.  For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law.  If the reader of this message is not the intended recipient, or the
employee or agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this communication in error, please notify the sender immediately by
telephone or directly reply to the original message(s) sent.  Thank you.

Re: How Much Data was Backed Up

[Talafous, John G.]

First suggestion is to take a good look into the dsmaccnt.log accounting
file. This is a great source of information!!!

john

-Original Message-
From: David Macisso [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: How Much Data was Backed Up


I am looking for an SQL statement or any report that will tell the amount
of data that hit the disk storage pool over a specified time interval.  I
am trying to determine the size of my Backup Pool and my Archive Pool.
Any ideas?
---
David Macisso
IBM Certified Specialist - AIX System Administration
Archdiocese of Boston
Ph: 617-746-5617
Fx: 617-746-5938


**
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.

The Timken Company
**

Re: LAN free backup for Novell

[Joshua Bassi]

It is my understanding that LAN-free backup works only with Windows and
UNIX clients.


--
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
Jin Bae Chi
Sent: Wednesday, December 11, 2002 5:34 AM
To: [EMAIL PROTECTED]
Subject: LAN free backup for Novell


Hi, expets,

I'm trying to implement LAN free backup feature with TSM 4.2 on AIX
4.3.3 for client nodes with Novell servers. These NetWare servers are
fibre connected to EMC box through SAN switches. TSM support told me
there is no Storage Agent support for Netware platforms. Does anyone
backup Novell servers through Fibre Channel? What would be your
suggestion to backup to tape library that resides on SAN? Thanks again
for your help!!





Jin Bae Chi (Gus)
System Admin/Tivoli
Data Center
614-287-5270
614-287-5488 Fax
[EMAIL PROTECTED]

Re: bad tape

[Prather, Wanda]

By the way, you may need to change the tape status from READONLY back to
OFFSITE.
(Depends on what vaulting software you are using to check for tapes to
return.)

-Original Message-
From: Joni Moyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 12:25 PM
To: [EMAIL PROTECTED]
Subject: Re: bad tape


Thank you so much.  It worked great!!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338



"Prather, Wanda"
 cc:
Sent by: "ADSM:Subject: Re: bad tape
Dist Stor
Manager"
<[EMAIL PROTECTED]
T.EDU>


12/11/2002 11:56
AM
Please respond
to "ADSM: Dist
Stor Manager"






Try this:

Update the access to READONLY instead of OFFSITE (even if you haven't
brought the tape back yet).
run:  AUDIT VOLUME XX FIX=YES

If there really is 0 data, it won't call for a mount, it will just give you
a message about fixing inconsistent data.
Then the tape should go to EMPTY status.

I just cleaned up 6 tapes that way; we are TSM on AIX 4.2.1.15.


Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
[EMAIL PROTECTED]

"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert





-Original Message-
From: Joni Moyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: bad tape


Hello everyone!

I have a weird situation and I wasn't quite sure what to do.  I have a bad
tape that is vaulted.  It has 0 data on it, but it won't delete from TSM.
The reuse delay is way past expiration, so it isn't being held by that.
Does anyone have any suggestions?  Thanks!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338

Re: RedHat 8 and TSM Client

[Patrick Boutilier]

Installing compat-libstdc++-7.3-2.96.110.i386.rpm would be a more proper
solution. :-)


Julian Armendariz wrote:

I tried installing the new TSM client but libstdc++ causes the client to fail since RH8 has a completely different version.  I force installed libstdc++2.96-110.i386.rpm and it started to work.

Julian Armendariz
System Analyst - UNIX
H.B. Fuller
(651) 236-4043





[EMAIL PROTECTED] 12/11/02 10:05AM >>>


Before I go and upgrade my Thinkpad to RedHat Linux 8,  does anybody know
if the TSM client runs on RH 8?

It would be a bummer to wipe my machine out, install a new OS, only to find
out I can't get at my backups anymore.

-JeffR

Re: bad tape

[Joni Moyer]

Thank you so much.  It worked great!!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338



"Prather, Wanda"
 cc:
Sent by: "ADSM:Subject: Re: bad tape
Dist Stor
Manager"
<[EMAIL PROTECTED]
T.EDU>


12/11/2002 11:56
AM
Please respond
to "ADSM: Dist
Stor Manager"






Try this:

Update the access to READONLY instead of OFFSITE (even if you haven't
brought the tape back yet).
run:  AUDIT VOLUME XX FIX=YES

If there really is 0 data, it won't call for a mount, it will just give you
a message about fixing inconsistent data.
Then the tape should go to EMPTY status.

I just cleaned up 6 tapes that way; we are TSM on AIX 4.2.1.15.


Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
[EMAIL PROTECTED]

"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert





-Original Message-
From: Joni Moyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: bad tape


Hello everyone!

I have a weird situation and I wasn't quite sure what to do.  I have a bad
tape that is vaulted.  It has 0 data on it, but it won't delete from TSM.
The reuse delay is way past expiration, so it isn't being held by that.
Does anyone have any suggestions?  Thanks!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338

Market Share of TSM vs Legato Networker

[Rupp Thomas (Illwerke)]

Hi TSM-ers,

is there a place where I can find information about the market share of TSM
and Legatos Networker
in real busines environment (FORTUNE 500 etc.)?
Tivoli claims that 80% of the Fortune 500 companies use TSM.

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG






--
Dieses eMail wurde auf Viren geprueft.

Vorarlberger Illwerke AG
--

Re: bad tape

[Prather, Wanda]

Try this:

Update the access to READONLY instead of OFFSITE (even if you haven't
brought the tape back yet).
run:  AUDIT VOLUME XX FIX=YES

If there really is 0 data, it won't call for a mount, it will just give you
a message about fixing inconsistent data.
Then the tape should go to EMPTY status.

I just cleaned up 6 tapes that way; we are TSM on AIX 4.2.1.15.


Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
[EMAIL PROTECTED]

"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert





-Original Message-
From: Joni Moyer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: bad tape


Hello everyone!

I have a weird situation and I wasn't quite sure what to do.  I have a bad
tape that is vaulted.  It has 0 data on it, but it won't delete from TSM.
The reuse delay is way past expiration, so it isn't being held by that.
Does anyone have any suggestions?  Thanks!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338

How Much Data was Backed Up

[David Macisso]

I am looking for an SQL statement or any report that will tell the amount
of data that hit the disk storage pool over a specified time interval.  I
am trying to determine the size of my Backup Pool and my Archive Pool.
Any ideas?
---
David Macisso
IBM Certified Specialist - AIX System Administration
Archdiocese of Boston
Ph: 617-746-5617
Fx: 617-746-5938

bad tape

[Joni Moyer]

Hello everyone!

I have a weird situation and I wasn't quite sure what to do.  I have a bad
tape that is vaulted.  It has 0 data on it, but it won't delete from TSM.
The reuse delay is way past expiration, so it isn't being held by that.
Does anyone have any suggestions?  Thanks!!

Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338

Re: scratch tapes not recognized

[Michelle Wiedeman]

marc the problem is allready solved. thnx for ur reply anyway!

-Original Message-
From: Marc Lowers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 5:30 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


Could you mail the messages from your activity log and the 'q vol' output
from the tape you said you assigned to the TAPEPOOL, this may help us all
in trying to help solve the problem.

Marc.

Recall: scratch tapes not recognized

[Michelle Wiedeman]

Michelle Wiedeman would like to recall the message, "scratch tapes not
recognized".

Re: scratch tapes not recognized

[Ray Baughman]

Is there a reason not to set maxscratch high say  for all storage pools,
then you only have to ensure there are scratch tapes in the library.  What
would be the reason for setting the number lower other than migrating to
other storage pools?

Ray Baughman
Engineering Systems Administrator
TSM Administrator
National Machinery LLC
Phone 419-443-2257
Fax 419-443-2376
Email [EMAIL PROTECTED]

> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Michelle Wiedeman
> Sent: Wednesday, December 11, 2002 11:30 AM
> To: [EMAIL PROTECTED]
> Subject: Re: scratch tapes not recognized
>
>
> hmmm...didnt figure it was that way. I "upgraded" maxscratch and the tapes
> are now being used!
> thnx a lot everyone, I can go home for diner instead of ordering a pizza!
>
>
> -Original Message-
> From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 5:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: scratch tapes not recognized
> Importance: High
>
>
> Now don't start thinking that "max scratch" simply accounts for
> the volumes
> that show up as "Scratch" during a "q libvol"
> "max scratch" limits the number of tapes that will be used that
> were checked
> in AS scratch.
> So if you checked in 300 tapes as scratch,
> your "q libvol" currently shows 135 scratch
> which implies 165 private (in my example)
> THIS MEANS only 30 more tapes will be used...
> that is, 105 of those 135 tapes marked scratch WILL NOT BE USED.
> for all 300 to be used, maxscr would need to be set to 300
>
> just pointing this out for clarification purposes...
>
>
> 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: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 9:47 AM
> To: [EMAIL PROTECTED]
> Subject: Re: scratch tapes not recognized
>
>
> scratch tapes in the tapepool is 135 max scratch is 195, i checked that
> allready.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 4:22 PM
> To: [EMAIL PROTECTED]
> Cc: Michelle Wiedeman
> Subject: RE: scratch tapes not recognized
>
>
>
> Hi,
>
> In your tapepoolX, what is the Maximum Scratch Volumes Allowed?
> And how many
> volumes are in use in that pool?
>
> Gr.,
>
> Karel
> ps. the more info you give, the faster the correct answer will be given.
>
> -Oorspronkelijk bericht-
> Van: Michelle Wiedeman [ mailto:[EMAIL PROTECTED]
>  ]
> Verzonden: woensdag 11 december 2002 16:13
> Aan: [EMAIL PROTECTED]
> Onderwerp: scratch tapes not recognized
>
>
> hi all,
>
> does anyone have a clue,
>
> I have 13 scratch tapes available in the library, but the diskpool doesnt
> want to backup coz it says theres  insufficient space in
> subordinate storage
>
> pool.
> ive checked the volumes which are scratch and theyre still in the library,
> not defined to any storagepool and readwrite enabled.
> thnx!
>

Re: scratch tapes not recognized

[Marc Lowers]

Could you mail the messages from your activity log and the 'q vol' output
from the tape you said you assigned to the TAPEPOOL, this may help us all
in trying to help solve the problem.

Marc.

Re: RedHat 8 and TSM Client

[Julian Armendariz]

I tried installing the new TSM client but libstdc++ causes the client to fail since 
RH8 has a completely different version.  I force installed libstdc++2.96-110.i386.rpm 
and it started to work.

Julian Armendariz
System Analyst - UNIX
H.B. Fuller
(651) 236-4043



>>> [EMAIL PROTECTED] 12/11/02 10:05AM >>>
Before I go and upgrade my Thinkpad to RedHat Linux 8,  does anybody know
if the TSM client runs on RH 8?

It would be a bummer to wipe my machine out, install a new OS, only to find
out I can't get at my backups anymore.

-JeffR

Re: scratch tapes not recognized

[Robert L. Rippy]

On the tapepool that is having the problem of not using your scratch tapes,
check maxscratch and compare that to the number below and make sure they
are not equal?

select count(*) from volumes where stgpool_name='STGPOOL_NAME'

Thanks,
Robert Rippy



From: Michelle Wiedeman <[EMAIL PROTECTED]> on 12/11/2002 11:21
  AM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  Re: scratch tapes not recognized

good idea, only it doesnt help me right now...the server is reclaiming and
getting ready to start the backups for the rest of the night. I could try
this tommorow (if it hasnt crashed by then lol) Does anyone have a clue to
why the scratch tape I mannully assigned to the tapepool is being used by
the server to write on? it normally doesnt work that way does it? I thought
the server assignes tapes from the library to the tapepool if it asks for
it.

-Original Message-
From: Nelson, Doug [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 5:10 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


You could try an Audit of the library (Check label = yes). This will make
it
load and read each tape. Maybe that will "convince" it that it has scratch.

Douglas C. Nelson
Distributed Computing Consultant
Alltel Information Services
Chittenden Data Center
2 Burlington Square
Burlington, Vt. 05401
802-660-2336



-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


yup theyre there, looked there already, funny thing is I moved one of the
volumes to the tapepool and tsm picked it up at once and started writing on
it and changed the status from scratch to private.
its not a matter of checking in i can be sure of that, there are tapes
among
it which have been in the library for over a year and have worked fine
before.
I was thinking if it could be a communication failure between the library
and the server, but it does do a reclamation of the tapepool so this cannot
be the issue.

-Original Message-
From: MacMurray, Andrea (CC-ETS Ent Storage Svcs)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


Try a 'q libvol library_name' and see if the scratch tapes are listed in
there as well. If not the problem might be a matter if they are checked in
correctly.

Andrea Mac Murray
Enterprise Unix and Storage Services
(402) 577 - 3603




-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate
storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: scratch tapes not recognized

[Michelle Wiedeman]

hmmm...didnt figure it was that way. I "upgraded" maxscratch and the tapes
are now being used!
thnx a lot everyone, I can go home for diner instead of ordering a pizza!


-Original Message-
From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 5:15 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized
Importance: High


Now don't start thinking that "max scratch" simply accounts for the volumes
that show up as "Scratch" during a "q libvol"
"max scratch" limits the number of tapes that will be used that were checked
in AS scratch.
So if you checked in 300 tapes as scratch,
your "q libvol" currently shows 135 scratch
which implies 165 private (in my example)
THIS MEANS only 30 more tapes will be used...
that is, 105 of those 135 tapes marked scratch WILL NOT BE USED.
for all 300 to be used, maxscr would need to be set to 300

just pointing this out for clarification purposes...


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: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:47 AM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


scratch tapes in the tapepool is 135 max scratch is 195, i checked that
allready.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:22 PM
To: [EMAIL PROTECTED]
Cc: Michelle Wiedeman
Subject: RE: scratch tapes not recognized



Hi,

In your tapepoolX, what is the Maximum Scratch Volumes Allowed? And how many
volumes are in use in that pool?

Gr.,

Karel
ps. the more info you give, the faster the correct answer will be given.

-Oorspronkelijk bericht-
Van: Michelle Wiedeman [ mailto:[EMAIL PROTECTED]
 ]
Verzonden: woensdag 11 december 2002 16:13
Aan: [EMAIL PROTECTED]
Onderwerp: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage

pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: scratch tapes not recognized

[Nelson, Doug]

   You can do it either way. The difference is that if it takes a tape from scratch, 
it will reclaim it back to scratch. If you put the tape into the pool, it won't ever 
go back to scratch (on it's own).
   Maybe as a short-term fix you should move a few more tapes over. You can always 
delete them from the pool (back to scratch) later.

Douglas C. Nelson
Distributed Computing Consultant
Alltel Information Services
Chittenden Data Center
2 Burlington Square
Burlington, Vt. 05401
802-660-2336



-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:21 AM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


good idea, only it doesnt help me right now...the server is reclaiming and
getting ready to start the backups for the rest of the night. I could try
this tommorow (if it hasnt crashed by then lol) Does anyone have a clue to
why the scratch tape I mannully assigned to the tapepool is being used by
the server to write on? it normally doesnt work that way does it? I thought
the server assignes tapes from the library to the tapepool if it asks for
it.

-Original Message-
From: Nelson, Doug [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 5:10 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


You could try an Audit of the library (Check label = yes). This will make it
load and read each tape. Maybe that will "convince" it that it has scratch.

Douglas C. Nelson
Distributed Computing Consultant
Alltel Information Services
Chittenden Data Center
2 Burlington Square
Burlington, Vt. 05401
802-660-2336



-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


yup theyre there, looked there already, funny thing is I moved one of the
volumes to the tapepool and tsm picked it up at once and started writing on
it and changed the status from scratch to private.
its not a matter of checking in i can be sure of that, there are tapes among
it which have been in the library for over a year and have worked fine
before.
I was thinking if it could be a communication failure between the library
and the server, but it does do a reclamation of the tapepool so this cannot
be the issue.

-Original Message-
From: MacMurray, Andrea (CC-ETS Ent Storage Svcs)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


Try a 'q libvol library_name' and see if the scratch tapes are listed in
there as well. If not the problem might be a matter if they are checked in
correctly.

Andrea Mac Murray
Enterprise Unix and Storage Services
(402) 577 - 3603




-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: scratch tapes not recognized

[Michelle Wiedeman]

good idea, only it doesnt help me right now...the server is reclaiming and
getting ready to start the backups for the rest of the night. I could try
this tommorow (if it hasnt crashed by then lol) Does anyone have a clue to
why the scratch tape I mannully assigned to the tapepool is being used by
the server to write on? it normally doesnt work that way does it? I thought
the server assignes tapes from the library to the tapepool if it asks for
it.

-Original Message-
From: Nelson, Doug [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 5:10 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


You could try an Audit of the library (Check label = yes). This will make it
load and read each tape. Maybe that will "convince" it that it has scratch.

Douglas C. Nelson
Distributed Computing Consultant
Alltel Information Services
Chittenden Data Center
2 Burlington Square
Burlington, Vt. 05401
802-660-2336



-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


yup theyre there, looked there already, funny thing is I moved one of the
volumes to the tapepool and tsm picked it up at once and started writing on
it and changed the status from scratch to private.
its not a matter of checking in i can be sure of that, there are tapes among
it which have been in the library for over a year and have worked fine
before.
I was thinking if it could be a communication failure between the library
and the server, but it does do a reclamation of the tapepool so this cannot
be the issue.

-Original Message-
From: MacMurray, Andrea (CC-ETS Ent Storage Svcs)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


Try a 'q libvol library_name' and see if the scratch tapes are listed in
there as well. If not the problem might be a matter if they are checked in
correctly.

Andrea Mac Murray
Enterprise Unix and Storage Services
(402) 577 - 3603




-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: scratch tapes not recognized

[Cook, Dwight E]

Now don't start thinking that "max scratch" simply accounts for the volumes
that show up as "Scratch" during a "q libvol"
"max scratch" limits the number of tapes that will be used that were checked
in AS scratch.
So if you checked in 300 tapes as scratch,
your "q libvol" currently shows 135 scratch
which implies 165 private (in my example)
THIS MEANS only 30 more tapes will be used...
that is, 105 of those 135 tapes marked scratch WILL NOT BE USED.
for all 300 to be used, maxscr would need to be set to 300

just pointing this out for clarification purposes...


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: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:47 AM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


scratch tapes in the tapepool is 135 max scratch is 195, i checked that
allready.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:22 PM
To: [EMAIL PROTECTED]
Cc: Michelle Wiedeman
Subject: RE: scratch tapes not recognized



Hi,

In your tapepoolX, what is the Maximum Scratch Volumes Allowed? And how many
volumes are in use in that pool?

Gr.,

Karel
ps. the more info you give, the faster the correct answer will be given.

-Oorspronkelijk bericht-
Van: Michelle Wiedeman [ mailto:[EMAIL PROTECTED]
 ]
Verzonden: woensdag 11 december 2002 16:13
Aan: [EMAIL PROTECTED]
Onderwerp: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage

pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: Question about Veritas Cluster and filespace name

[David Rigaudiere]

Yes, i have exactly the same problem with Windows & Double-Take,
i would like change the way that TSM nam the the filespacing naming
process.


--
David  Rigaudiere  -+-  Administration  TSM + NT
Paris -+- 40, rue de Courcelles -+- 4e étage -+-
[EMAIL PROTECTED] -+- 01.5621.7802



|-+--->
| |   Peter Bjoern|
| |   |
| |   Sent by: "ADSM: |
| |   Dist Stor   |
| |   Manager"|
| |   <[EMAIL PROTECTED]|
| |   T.EDU>  |
| |   |
| |   |
| |   11/12/2002 12:45|
| |   Please respond  |
| |   to "ADSM: Dist  |
| |   Stor Manager"   |
| |   |
|-+--->
  
>---|
  |
   |
  |To:  [EMAIL PROTECTED]   
   |
  |cc: 
   |
  |Subject: Question about Veritas Cluster and filespace name  
   |
  
>---|




Hi

We have a situation with a Veritas cluster installed on two Win2000
servers.
The physical servers are called J2P-CLUSTER101 and J2P-CLUSTER102.
There is a virtual server defined with the name WEB1.

Each physical server has it's own C: drive which is backed up via a
schedule
that specifies 'C:' and 'systemobject' on the domain statement in the
option file.
The C: filespaces are given the names \\J2P-CLUSTER101\C$ and
\\J2P-CLUSTER102\C$ respectively.  This is all OK.

There is a shared drive X: which is associated with the WEB1 resource and
moves with WEB1 between the two physical servers so that it is available
either on J2P-CLUSTER101 or J2P-CLUSTER102.

X: is backed up from a virtual node defined in TSM called WEB1 and via a
separate TSM scheduler
service with an option file that  specifies X: on the domain statement.

If this had been a Microsoft Cluster installation, we would have specified
'CLUSTERNODE YES' in the optionfiles to make TSM name the X: filespace
with the virtual clustername (WEB1) so that it would have been named
\\WEB1\X$ regardless of which physical server it was backed up from.

However, CLUSTERNODE does not work with a Veritas cluster, so the result is
that we get two parallel filespaces named  \\J2P-CLUSTER101\X$ and
\\J2P-CLUSTER101\X$ because X: sometimes resides on J2P-CLUSTER101
and some times on J2P-CLUSTER102.

>From previous postings on this list I get the impression that there is
nothing
we can do to solve this, but I just want to be sure if this is true

How are other people who are running Veritas clusters and TSM solving this
?

This is a bad situation and one could fear (from a TSM person point of
view) that
it could pave the way for the introduction of Veritas backup software at
the site.

If CLUSTERNODE cannot easily be enhanced to support Veritas clusters as
well, all we would need would be a new statement in the option file,
perhaps called
MACHINENAME or so, where we could specify 'MACHINENAME WEB1' in the
optionfile and then have TSM use this name is the filespacing naming
process.

Regards

Peter



---
This message (including any attachments) is confidential and may be
privileged. If you have received it by mistake please notify the sender by
return e-mail and delete this message from your system. Any unauthorised
use or dissemination of this message in whole or in part is strictly
prohibited. Please note that e-mails are susceptible to change.
ABN AMRO Bank N.V. (including its group companies) shall not be liable for
the improper or incomplete transmission of the information contained in
this communication nor for any delay in its receipt or damage to your
system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that
the integrity of this communication has been maintained nor that this
communication is free of viruses, interceptions or interference.
---

Le présent message (y compris tous les éléments attachés) est confidentiel
et est destiné aux seules personnes qu'il vise. Si vous l'avez reçu par
erreur, merci de l'indiquer à son expéditeur par retour et de procéder à sa
destruction dans vos systèmes. Toute uti

Re: scratch tapes not recognized

[Nelson, Doug]

You could try an Audit of the library (Check label = yes). This will make it
load and read each tape. Maybe that will "convince" it that it has scratch.

Douglas C. Nelson
Distributed Computing Consultant
Alltel Information Services
Chittenden Data Center
2 Burlington Square
Burlington, Vt. 05401
802-660-2336



-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


yup theyre there, looked there already, funny thing is I moved one of the
volumes to the tapepool and tsm picked it up at once and started writing on
it and changed the status from scratch to private.
its not a matter of checking in i can be sure of that, there are tapes among
it which have been in the library for over a year and have worked fine
before.
I was thinking if it could be a communication failure between the library
and the server, but it does do a reclamation of the tapepool so this cannot
be the issue.

-Original Message-
From: MacMurray, Andrea (CC-ETS Ent Storage Svcs)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


Try a 'q libvol library_name' and see if the scratch tapes are listed in
there as well. If not the problem might be a matter if they are checked in
correctly.

Andrea Mac Murray
Enterprise Unix and Storage Services
(402) 577 - 3603




-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: ?? Cost on a storage frame on 3494

[James, Phil]

I have storage frames but can find the cost for them.  But lately I have
been getting D12
frames without drives and use them for storage.  Just in case I need to add
more drive capacity
later.  I don't have the option of taking the library down for a extend
amount of time after
its in production.  The last two times I needed to add tape drives the
library didn't need
come down for them to be added.

This is for 4 drives gov't cost without customer discount.

3590-H1A  ENTERPRISE TAPE DRIVE   4  174,000.00C
800.00C  Mth
2924  U.S. ENGLISH4 N/C
5861  61 M SC/SC FIBRE CABLE  82,584.00
9510  FIBRE CHANNEL ATTACH - PLANT4 N/C
9600  ATTACH TO RS/6000, PSERIES  4 N/C
9670  PLANT INSTALL HXX FIBRE DRIVE   4 N/C
 ___
___
  Serial: N/A Total  USD 176,584.00   USD




-Original Message-
From: Lisa Cabanas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 7:47 AM
To: [EMAIL PROTECTED]
Subject: ?? Cost on a storage frame on 3494


Howdy all,

any one have a quick and dirty estimate of what a storage frame runs on a
3494 (retail, gov't)?  My IBM contacts are out of the office today, and one
of my bosses wants to talk storage planning today.  I have prices for the
L12 and D12.

While I'm at it-- any of you guys with the new H drives-- what do they run
(the FC ones?)

thanks!!

lisa

Re: ?? Cost on a storage frame on 3494

[Thorson, Paul]

Hi Lisa,

I believe 'S' frames (400 slots) retail for around $10-15K.

3590H drives (ESCON or fiber) retail for $43,500.

Regards,

- Paul

Paul Thorson
Levi, Ray & Shoup, Inc.
Tivoli Specialist - LRS IT Solutions
(217) 793-3800 x1704


-Original Message-
From: Lisa Cabanas [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 11, 2002 9:47 AM
To: [EMAIL PROTECTED]
Subject: ?? Cost on a storage frame on 3494


Howdy all,

any one have a quick and dirty estimate of what a storage frame runs on
a 3494 (retail, gov't)?  My IBM contacts are out of the office today,
and one of my bosses wants to talk storage planning today.  I have
prices for the L12 and D12.

While I'm at it-- any of you guys with the new H drives-- what do they
run (the FC ones?)

thanks!!

lisa

Re: ?? Cost on a storage frame on 3494

[John Wright]

Last retail price I had on a frame was about £21k though discounts are 
available.

3590H. I looked into these, they can be SCSI or Fibre channel. If you 
already have SCSI the default upgrade is to 3590H SCSI.
For a few hundred £ more you can have them converted to FC at the same 
time you have the upgrade done.
These can be directly fibre attached to the Unix host or to the host via a 
switched network but don't forget to include fibre HBAs for the Host in 
your budget.

I hear IBM are doing a seasonal special on this very upgrade right now.

Regards
John




"Lisa Cabanas" <[EMAIL PROTECTED]>

Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
11-Dec-2002 15:47
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

 
 

To: ADSM-L

cc: 
Subject:?? Cost on a storage frame on 3494

Howdy all,

any one have a quick and dirty estimate of what a storage frame runs on a
3494 (retail, gov't)?  My IBM contacts are out of the office today, and 
one
of my bosses wants to talk storage planning today.  I have prices for the
L12 and D12.

While I'm at it-- any of you guys with the new H drives-- what do they run
(the FC ones?)

thanks!!

lisa

Re: scratch tapes not recognized

[Michelle Wiedeman]

yup theyre there, looked there already, funny thing is I moved one of the
volumes to the tapepool and tsm picked it up at once and started writing on
it and changed the status from scratch to private.
its not a matter of checking in i can be sure of that, there are tapes among
it which have been in the library for over a year and have worked fine
before.
I was thinking if it could be a communication failure between the library
and the server, but it does do a reclamation of the tapepool so this cannot
be the issue.

-Original Message-
From: MacMurray, Andrea (CC-ETS Ent Storage Svcs)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: Re: scratch tapes not recognized


Try a 'q libvol library_name' and see if the scratch tapes are listed in
there as well. If not the problem might be a matter if they are checked in
correctly.

Andrea Mac Murray
Enterprise Unix and Storage Services
(402) 577 - 3603




-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

RedHat 8 and TSM Client

[Jeff Rogers]

Before I go and upgrade my Thinkpad to RedHat Linux 8,  does anybody know
if the TSM client runs on RH 8?

It would be a bummer to wipe my machine out, install a new OS, only to find
out I can't get at my backups anymore.

-JeffR

Re: Select Statement

[Gill, Geoffrey L.]

There are so many replies to this that look like contradictions to each
other that I'd like to look at this further on my system. I am not a SQL
guru by any means, I can't even seem to combine a couple of statements to
get what I need. Hopefully someone can help me(us) out here. I do an audit
license daily so this should come back with good, or in this case, bad
results.

When I try to combine these to get an output I always get a statement error.
I want to find out what levels are having the problem. I think it's
ridiculous that this does not work for "ALL" client levels. It always did in
the past and I can't understand why I have to now upgrade possibly 80 some
nodes to fix it. Why doesn't IBM fix their server code instead?

Could someone please combine these to get the necessary output? Client
level, node name, amount backed up and I think group by client level might
work.

Select for client level:

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


Select for amount backed up:

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 "CONNECTIONS" 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


Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (877) 905-7154



> -Original Message-
> From: Michel Engels [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 6:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Select Statement
>
>
> When I do remember well this problem appeared when I
> installed TSM Clients 5.1.0. There was a maintenance (I do
> not remember if it was 5.1.2 or 5.1.3) that solved the
> problem. Be sure you do an "audit license" regularly. I did
> not install a V5.1.5 yet, so I do not know if the problem
> reappears in that version.
>
> Hope this helps,
>
> Michel Engels
> Software Consultant
> Devoteam Belgium
>
>
>
>
>
>
> "Gill, Geoffrey L." <[EMAIL PROTECTED]> on 12/10/2002
> 11:16:02 PM
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> To:   [EMAIL PROTECTED]
> cc:(bcc: Michel Engels/BE/Devoteam)
>
> Subject:  Select Statement
>
>
>
> I got this somewhere and I know it used to work on my 4x
> server. Now that I'm on 5.1.5.2 I get a lot of nodes report
> back with 0 Megabytes but they obviously sent files.
>
> Anyone who can make it work since my SQL stills are pretty
> much non existant?
>
> /**/
> /* Specify a date on the run line as follows  */
> /* run q_backup 2001-09-30*/
> /**/
> select entity as node_name, date(start_time) as date, -
> cast(activity as varchar(10)) as activity, time(start_time)as start, -
> time(end_time) as end, cast(bytes/100 as decimal(6,0))as
> megabytes, - cast(affected as decimal(7,0)) as files,
> successful from summary - where date(start_time)='$1' and
> activity='BACKUP' order by megabytes desc
>
>  NODE_NAME: NODEA
>   DATE: 2002-12-09
>   ACTIVITY: BACKUP
>  START: 20:00:51
>END: 20:48:07
> MEGABYTES: 0
>  FILES: 100
> SUCCESSFUL: YES
>
>
>
> This one does the same thing with some nodes. It also only
> reports about half the nodes even though it looks like it's
> supposed to be going back a full day.
>
> NODEA   NT_DOM WinNT
>   0.00
> 1
> 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
>
> A better one would also work.
> Geoff Gill
> TSM Administrator
> NT Systems Support Engineer
> SAIC
> E-Mail: [EMAIL PROTECTED]
> Phone:  (858) 826-4062
> Pager:   (877) 905-7154
>

question on backupset volumes: how to count them ?

[Rainer Wolf]

Hello,
sorry if this is often asked or I haven't found the doc...
I have the following problem:
We are using aix tsm server 4.2.2.13 and a 3494 Library with k- and j-tapes.
Backupsets of clients are created with duration of 999 and the
only device-class for backupset-voluems is the devclass of the 3494 library.
Now some of the Backupset - tapes are checked out and some are still in
the Library. Some of the online Backupset-Volumes have been once
checked out and are checked in again with status=private-
I have not found something equivalent like 'q drmed ... for DBBackup-Volumes'
for thoe backupset-volumes.

Now i am looking for a good way to ...
... to count the total number of those 3494 Backupset volumes
  ( online OR offline )
... only to get the number of the currently checked-in backupset volumes
  in the library.
  Maybe a problem is, that some of the online backup-set-volumes
  have been once checked out and then checked in again and may appear
  just as private ( in the q libvol ... ) ?
  So do I have to combine something like 'q libvol' and 'q volhist t=backupset'
  to get it ?
...  count the number ( online or offline  )
  of tapes depending on the node, for whom this backupset is created ?

Thanks for any help/scripts/macros :-)
Rainer


--
---
Rainer Wolf mail: [EMAIL PROTECTED]
tel: ++49 731 50-22482  fax:  ++49 731 50-22471
Computing Center, University of Ulm, Germanyweb: http://www.uni-ulm.de/urz

Re: scratch tapes not recognized

[MacMurray, Andrea (CC-ETS Ent Storage Svcs)]

Try a 'q libvol library_name' and see if the scratch tapes are listed in
there as well. If not the problem might be a matter if they are checked in
correctly.

Andrea Mac Murray
Enterprise Unix and Storage Services
(402) 577 - 3603




-Original Message-
From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: scratch tapes not recognized

[Michelle Wiedeman]

scratch tapes in the tapepool is 135 max scratch is 195, i checked that
allready.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:22 PM
To: [EMAIL PROTECTED]
Cc: Michelle Wiedeman
Subject: RE: scratch tapes not recognized



Hi,

In your tapepoolX, what is the Maximum Scratch Volumes Allowed? And how many
volumes are in use in that pool?

Gr.,

Karel
ps. the more info you give, the faster the correct answer will be given.

-Oorspronkelijk bericht-
Van: Michelle Wiedeman [ mailto:[EMAIL PROTECTED]
 ]
Verzonden: woensdag 11 december 2002 16:13
Aan: [EMAIL PROTECTED]
Onderwerp: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage

pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: scratch tapes not recognized

[Frost, Dave]

Michelle,

Check the "maxscratch" setting for the "next" (or subordinate) storage pool


Regards,

-=Dave=-
+44 (0) 20 7608 7140

Give a man a fish and you feed him for a day; give him a freshly-charged
Electric Eel and chances are he won't bother you for anything ever again.



  Michelle Wiedeman
   cc:
  Sent by: "ADSM: DistSubject:  scratch tapes not 
recognized
  Stor Manager"
  <[EMAIL PROTECTED]
  U>


  12/11/2002 03:13 PM
  Please respond to
  "ADSM: Dist Stor
  Manager"






hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate
storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

?? Cost on a storage frame on 3494

[Lisa Cabanas]

Howdy all,

any one have a quick and dirty estimate of what a storage frame runs on a
3494 (retail, gov't)?  My IBM contacts are out of the office today, and one
of my bosses wants to talk storage planning today.  I have prices for the
L12 and D12.

While I'm at it-- any of you guys with the new H drives-- what do they run
(the FC ones?)

thanks!!

lisa

Re: scratch tapes not recognized

[Matt Simpson]

At 16:13 +0100 12/11/02, Michelle Wiedeman wrote:

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool


Do a Q STGPOOL poolname F=D  for your tape backup pool and check the
pct util and max scratch vols allowed.  You probably need to increase
the max scratch vols on that pool.
--


Matt Simpson --  OS/390 Support
219 McVey Hall  -- (859) 257-2900 x300
University Of Kentucky, Lexington, KY 40506

mainframe --   An obsolete device still used by thousands of obsolete
companies serving billions of obsolete customers and making huge obsolete
profits for their obsolete shareholders.  And this year's run twice as fast
as last year's.

Re: scratch tapes not recognized

[Robert L. Rippy]

Check your MAXSCRATCH setting in the tapepool you are backin up to. use
command "Q STG 'poolname' F+D' look for maxscratch setting and be sure its
set high enough.

Thanks,
Robert Rippy.



From: Michelle Wiedeman <[EMAIL PROTECTED]> on 12/11/2002 10:13
  AM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  scratch tapes not recognized

hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate
storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: scratch tapes not recognized

[Karel Bos]

Hi,

In your tapepoolX, what is the Maximum Scratch Volumes Allowed? And how many
volumes are in use in that pool?

Gr.,

Karel
ps. the more info you give, the faster the correct answer will be given.

-Oorspronkelijk bericht-
Van: Michelle Wiedeman [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 11 december 2002 16:13
Aan: [EMAIL PROTECTED]
Onderwerp: scratch tapes not recognized


hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

scratch tapes not recognized

[Michelle Wiedeman]

hi all,

does anyone have a clue,

I have 13 scratch tapes available in the library, but the diskpool doesnt
want to backup coz it says theres  insufficient space in subordinate storage
pool.
ive checked the volumes which are scratch and theyre still in the library,
not defined to any storagepool and readwrite enabled.
thnx!

Re: TSM in a MS Cluster environment

[Bruce Kamp]

I set it up is the same way.  Three schedulers & 3 opt files.  One thing to
make sure is that you build both sides of the cluster before adding the
registry key replication in the cluster resource.  Documentation isn't
specific on this  Caused me about 3 days on the phone with level 1 &
level 2 support & I ended up figuring it out on my own by dumb luck!
Hope this helps!

---
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E-mail: [EMAIL PROTECTED]
Phone: (954) 987-2020 x4597
Fax: (954) 985-1404
---


-Original Message-
From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 4:52 PM
To: [EMAIL PROTECTED]
Subject: TSM in a MS Cluster environment


I'm about to install TSM in a MS cluster environment.  I've done this with
success in the past in an active/active environment where each server has 3
TSM scheduler services.  e.g.  local scheduler,
scheduler_service_for_group_A, scheduler_service_for_group_B.

I've not done it in an active/passive environment where all resources
normally belong to the active server.  The documentation is very vague.
Here are my questions.

How many nodes will I have?
How many scheduler services will I have on each server?
Do both nodes share one "cluster" dsm.opt file that resides in the same
directory?

Does anyone have step by step doc for an active/passive TSM cluster server
install?

thx.


Regards, Joe

Re: Summary Table Problems sample

[Richard Cowen]

Server 5.1.5.4 AIX 5.1
Clients
STINGRAY1   5.1.5.5  (upgraded from 5.1.5.0 around 12:20:00)
RICHARDC2K  5.1.5.4
NORBERT 4.2.1.15


Using the Summary Table:

Session NodeStartTime   EndTime Objects Bytes  Elapsed  Session
PlatformMedia Wait
3   RICHARDC2K  12:36:1113:14:4415757   245.6MB 2313
ARCHIVE WinNT   49
13  STINGRAY1   12:53:2812:53:335   9.7KB
5   BACKUP  AIX 0
43  RICHARDC2K  14:12:0714:12:207   1.5KB
13  BACKUP  WinNT   0
47  RICHARDC2K  14:14:5014:39:072   591
1457BACKUP  WinNT   0
142 NORBERT 15:55:3815:56:522   1.4GB   74
ARCHIVE SUN SOLARIS 39



>From the actlog:

Session NodeStartTime   EndTime Objects Bytes  Elapsed  Session
PlatformMedia Wait
20  STINGRAY1   12:18:5212:33:3613  1.9MB
884 backup  AIX 0
3   RICHARDC2K  12:36:1113:14:445900250.9MB 2313
archive WinNT   49
13  STINGRAY1   12:53:2812:53:335   9.7KB
5   backup  AIX 0
43  RICHARDC2K  14:12:0714:12:207   1.5KB
13  backup  WinNT   0
47  RICHARDC2K  14:14:5014:39:072   599
1457backup  WinNT   0
142 NORBERT 15:55:3815:56:522   1.4GB   74
archive SUN SOLARIS 39

The Norbert session actually ran for almost an hour:

12/10/2002 14:59:08  ANR0406I Session 71 started for node NORBERT (SUN
SOLARIS)
  (Tcp/Ip 10.178.90.202(38907)).
12/10/2002 14:59:08  ANR0403I Session 71 ended for node NORBERT (SUN
SOLARIS).
12/10/2002 14:59:09  ANR0406I Session 72 started for node NORBERT (SUN
SOLARIS)
  (Tcp/Ip 10.178.90.202(38908)).
12/10/2002 14:59:23  ANR0403I Session 72 ended for node NORBERT (SUN
SOLARIS).
12/10/2002 15:00:13  ANR0406I Session 73 started for node NORBERT (SUN
SOLARIS)
  (Tcp/Ip 10.178.90.202(38909)).
12/10/2002 15:00:13  ANR0406I Session 74 started for node NORBERT (SUN
SOLARIS)
  (Tcp/Ip 10.178.90.202(38910)).
12/10/2002 15:00:31  ANR0406I Session 75 started for node NORBERT (SUN
SOLARIS)
  (Tcp/Ip 10.178.90.202(38911)).
12/10/2002 15:00:31  ANR0403I Session 75 ended for node NORBERT (SUN
SOLARIS).
12/10/2002 15:16:12  ANR0482W Session 73 for node NORBERT (SUN SOLARIS)
  terminated - idle for more than 15 minutes.
12/10/2002 15:55:36  ANR0403I Session 74 ended for node NORBERT (SUN
SOLARIS).
12/10/2002 15:55:38  ANR0406I Session 142 started for node NORBERT (SUN
  SOLARIS) (Tcp/Ip 10.178.90.202(38923)).
12/10/2002 15:55:38  ANE4952I (Session: 142, Node: NORBERT)  Total
number of
  objects inspected:2
12/10/2002 15:55:38  ANE4953I (Session: 142, Node: NORBERT)  Total
number of
  objects archived: 2
12/10/2002 15:55:38  ANE4958I (Session: 142, Node: NORBERT)  Total
number of
  objects updated:  0
12/10/2002 15:55:38  ANE4960I (Session: 142, Node: NORBERT)  Total
number of
  objects rebound:  0
12/10/2002 15:55:38  ANE4957I (Session: 142, Node: NORBERT)  Total
number of
  objects deleted:  0
12/10/2002 15:55:38  ANE4970I (Session: 142, Node: NORBERT)  Total
number of
  objects expired:  0
12/10/2002 15:55:38  ANE4959I (Session: 142, Node: NORBERT)  Total
number of
  objects failed:   0
12/10/2002 15:55:38  ANE4961I (Session: 142, Node: NORBERT)  Total
number of
  bytes transferred: 1.38 GB
12/10/2002 15:55:38  ANE4963I (Session: 142, Node: NORBERT)  Data
transfer
  time:3,279.74 sec
12/10/2002 15:55:38  ANE4966I (Session: 142, Node: NORBERT)  Network
data
  transfer rate:  442.39 KB/sec
12/10/2002 15:55:38  ANE4967I (Session: 142, Node: NORBERT)  Aggregate
data
  transfer rate:436.30 KB/sec
12/10/2002 15:55:38  ANE4968I (Session: 142, Node: NORBERT)  Objects
compressed
  by:0%%
12/10/2002 15:55:38  ANE4964I (Session: 142, Node: NORBERT)  Elapsed
processing
  time:00:55:25
12/10/2002 15:56:52  ANR0403I Session 142 ended for node NORBERT (SUN
SOLARIS).

Re: DB Backup in v5 TSM (5.1.1.6, 5.1.5.2, 5.1.5.4)

[Andy Carlson]

I should have mentioned that I tried it unmirrored (log and db) also.


Andy Carlson|\  _,,,---,,_
Senior Technical Specialist   ZZZzz /,`.-'`'-.  ;-;;,_
BJC Health Care|,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri   '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html


On Tue, 10 Dec 2002, Seay, Paul wrote:

> My database saves at about 22,000,000 pages an hour.  I have taken the
> messages from the log and they are consistently the same.  I do not know
> what is causing this.  There were some performance problems with mirrored
> databases, but I thought they were fixed at your level.
>
> Paul D. Seay, Jr.
> Technical Specialist
> Naptheon Inc.
> 757-688-8180
>
>
> -Original Message-
> From: Andy Carlson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 10, 2002 2:43 PM
> To: [EMAIL PROTECTED]
> Subject: DB Backup in v5 TSM (5.1.1.6, 5.1.5.2, 5.1.5.4)
>
>
> I have a strange problem that I have been working with IBM on, but was told
> it's "working as designed".  I have a new TSM server, which started life as
> 5.1.1.6, upgraded to 5.1.5.2 at IBM's request, then just did 5.1.5.4 today
> after seeing it had been released.  I back up the database, which is only
> 124000 pages since it is a new server.  It backs up the first 9 pages in
> a couple of minutes.  The last 34000 pages take over an hour.  While this is
> happening, there is very little CPU and I/O going on.  I have tried the
> database on SCSI, and on FastT700, the backup file on each, etc.  I can make
> it go away temporarily if I unload and reload, but once this database gets
> bigger, that will not be an option.  Any ideas?  Thanks.
>
>
> Andy Carlson|\  _,,,---,,_
> Senior Technical Specialist   ZZZzz /,`.-'`'-.  ;-;;,_
> BJC Health Care|,4-  ) )-,_. ,\ (  `'-'
> St. Louis, Missouri   '---''(_/--'  `-'\_)
> Cat Pics: http://andyc.dyndns.org/animal.html
>

TDP for Oracle under Linux

[Rainer Holzinger]

Hi all,

does  anyone  of  you  know  if there is a TDP for Oracle version available
running under Linux?

Oracle is at vers. 8.1.7
Linux is at version 7.2 (SUSE)

Thanks a a lot.

Rainer



   (Embedded  UPM Kymmene Papier GmbH & Co. KG
  image moved Member of the UPM-Kymmene Group
   to file:   HAI IT Services
 pic03430.gif)Rainer Holzinger, TSM/AIX
  Administrator
  Georg-Haindl-Str. 5, D-86153
  Augsburg
  Tel. +49 821 3109 590
  Fax. +49 821 3109 115
  Mobile +49 170 4037 616
  [EMAIL PROTECTED]




<>

Re: Select Statement

[Michel Engels]

When I do remember well this problem appeared when I installed TSM Clients
5.1.0. There was a maintenance (I do not remember if it was 5.1.2 or 5.1.3) that
solved the problem. Be sure you do an "audit license" regularly. I did not
install a V5.1.5 yet, so I do not know if the problem reappears in that version.

Hope this helps,

Michel Engels
Software Consultant
Devoteam Belgium






"Gill, Geoffrey L." <[EMAIL PROTECTED]> on 12/10/2002 11:16:02 PM

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

To:   [EMAIL PROTECTED]
cc:(bcc: Michel Engels/BE/Devoteam)

Subject:  Select Statement



I got this somewhere and I know it used to work on my 4x server. Now that
I'm on 5.1.5.2 I get a lot of nodes report back with 0 Megabytes but they
obviously sent files.

Anyone who can make it work since my SQL stills are pretty much non
existant?

/**/
/* Specify a date on the run line as follows  */
/* run q_backup 2001-09-30*/
/**/
select entity as node_name, date(start_time) as date, -
cast(activity as varchar(10)) as activity, time(start_time)as start, -
time(end_time) as end, cast(bytes/100 as decimal(6,0))as megabytes, -
cast(affected as decimal(7,0)) as files, successful from summary -
where date(start_time)='$1' and activity='BACKUP' order by megabytes desc

 NODE_NAME: NODEA
  DATE: 2002-12-09
  ACTIVITY: BACKUP
 START: 20:00:51
   END: 20:48:07
MEGABYTES: 0
 FILES: 100
SUCCESSFUL: YES



This one does the same thing with some nodes. It also only reports about
half the nodes even though it looks like it's supposed to be going back a
full day.

NODEA   NT_DOM WinNT0.00
1
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

A better one would also work.
Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail: [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (877) 905-7154

Re: K-cartridges besides J-cartridges

[Cook, Dwight E]

Should see a "2X" sticker on the back of your 3590 drive if it is set to
deal with double length tapes.
Also the internal tape spool is green (along with one or two other internal
parts, I seem to recall) so you might be able to look in through the cooling
holes in the top of the case to double check (if you don't find a "2X"
sticker on the drive)


Dwight



-Original Message-
From: Jim Sporer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 4:25 PM
To: [EMAIL PROTECTED]
Subject: Re: K-cartridges besides J-cartridges


There is a difference between the J and K tapes and the 3590 drives need to
support the extended length tapes.  If the drives are new there is no
problem but older 3590E drives may need an upgrade to support the extended
length tapes.  Check with your CE.
Jim Sporer


At 11:12 PM 12/10/2002 +0100, you wrote:
>Hello,
>
>AIX 5.1, TSM 4.2.1.19, IBM 3494 library, 3590E-drives
>
>At the moment we use about 900 J-cartridges in our library. Is it possible
>to checkin K-cartridges and use them besides the J-cartridges.
>
>During upgrade from our drives from 3590B to 3590E we changed status of our
>volumes to read-only because of different tracks used on tape.
>
>As far as I know is the only difference between J and K the length of the
>tape, so I guess there will be no problem.
>
>I'm wondering if someone is using both J and K cartridges and if there
>encounter any problems.
>
>Thanx,
>
>Brian.
>
>
>
>
>
>
>_
>Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/

Réf. : Re: Select Statement

[Guillaume Gilbert]

I've been having this problem for awhile. Support told me to go to 4.2.3.1 on server 
and client and now these clients are missing from the summary table. This is on my
biggest server (25 GB database). On other small and new servers, things seem to be ok. 
My PMR is still open (48498) and support is working on it.

Guillaume Gilbert
Conseiller - Gestion du stockage
CGI - Gestion intégré des technologies
TEL. : (514) 281-7000 ext 3642
Pager : (514) 957-2615
Email : [EMAIL PROTECTED]





Kolbeinn Josepsson <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-12-11 
08:24:56

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

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


Pour : [EMAIL PROTECTED]
cc :
Objet : Re: Select Statement

I have seen this problem since 5.1.0

At one site with server 5.1.5.2 and client 5.1.5.0, not only some clients
reports 0 MB, also some clients are completly missing from the summary
table.

At other site I have recently upgrated from 4.2.x to 5.1.5.4 and clients
5.1.5.0 and I'm seeing clients report 0 MB.

If this is question about client patch level, I would like to know





  Best regards,
  Kolbeinn Josepsson  7 Systems Engineer
  Tel: +354 569-7700 7 Fax: +354 569-7799
  www.nyherji.is








  "Seay, Paul"
 cc:
  Sent by: "ADSM:  Subject: Re: Select Statement
  Dist Stor
  Manager"
  <[EMAIL PROTECTED]
  T.EDU>


  11.12.2002 01:30
  Please respond
  to "ADSM: Dist
  Stor Manager"






As it turns out the clients also have to be updated to correct a problem
where the summary table statistics are missing.  I talked to a TSM Level 2
person about this just last week.  I do not know what levels you have to be
at to get the problem corrected, but I thought 5.1.5 was good enough.

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


-Original Message-
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 5:16 PM
To: [EMAIL PROTECTED]
Subject: Select Statement


I got this somewhere and I know it used to work on my 4x server. Now that
I'm on 5.1.5.2 I get a lot of nodes report back with 0 Megabytes but they
obviously sent files.

Anyone who can make it work since my SQL stills are pretty much non
existant?

/**/
/* Specify a date on the run line as follows  */
/* run q_backup 2001-09-30*/
/**/
select entity as node_name, date(start_time) as date, - cast(activity as
varchar(10)) as activity, time(start_time)as start, -
time(end_time) as end, cast(bytes/100 as decimal(6,0))as megabytes, -
cast(affected as decimal(7,0)) as files, successful from summary - where
date(start_time)='$1' and activity='BACKUP' order by megabytes desc

 NODE_NAME: NODEA
  DATE: 2002-12-09
  ACTIVITY: BACKUP
 START: 20:00:51
   END: 20:48:07
MEGABYTES: 0
 FILES: 100
SUCCESSFUL: YES



This one does the same thing with some nodes. It also only reports about
half the nodes even though it looks like it's supposed to be going back a
full day.

NODEA   NT_DOM WinNT0.00
1
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

A better one would also work.
Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail: [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (877) 905-7154

Re: DB2 backup on AIX

[Richard Sims]

>... is any redbook or documentation about backing up DB2 database with TSM

http://www.redbooks.ibm.com/ has a search capability, where you can enter
things like "db2 backup" and it will reveal the Redbooks and Redpieces
which contain such information.

  Richard Sims, BU

unsubscribe

[Bob Strandberg]

-Original Message-
From: Kolbeinn Josepsson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 8:05 AM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX


Try this link:
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246247.html?
Open




  Best regards,
  Kolbeinn Josepsson  7 Systems Engineer
  Tel: +354 569-7700 7 Fax: +354 569-7799
  www.nyherji.is








  Tomas Hrouda
  <[EMAIL PROTECTED]> To:  [EMAIL PROTECTED]
  Sent by: "ADSM:  cc:
  Dist StorSubject: Re: DB2 backup on
AIX
  Manager"
  <[EMAIL PROTECTED]
  T.EDU>


  11.12.2002 12:44
  Please respond
  to "ADSM: Dist
  Stor Manager"






Thanks Daniel,

I'll try to contact him (if any exists :-)). But I have one more question
... is any redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Daniel Sparrman
Sent: Wednesday, December 11, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX


Hi

DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin.
It also explains how to do it in "Backing up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: Select Statement

[Kolbeinn Josepsson]

I have seen this problem since 5.1.0

At one site with server 5.1.5.2 and client 5.1.5.0, not only some clients
reports 0 MB, also some clients are completly missing from the summary
table.

At other site I have recently upgrated from 4.2.x to 5.1.5.4 and clients
5.1.5.0 and I'm seeing clients report 0 MB.

If this is question about client patch level, I would like to know





  Best regards,
  Kolbeinn Josepsson  7 Systems Engineer
  Tel: +354 569-7700 7 Fax: +354 569-7799
  www.nyherji.is








  "Seay, Paul"
 cc:
  Sent by: "ADSM:  Subject: Re: Select Statement
  Dist Stor
  Manager"
  <[EMAIL PROTECTED]
  T.EDU>


  11.12.2002 01:30
  Please respond
  to "ADSM: Dist
  Stor Manager"






As it turns out the clients also have to be updated to correct a problem
where the summary table statistics are missing.  I talked to a TSM Level 2
person about this just last week.  I do not know what levels you have to be
at to get the problem corrected, but I thought 5.1.5 was good enough.

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


-Original Message-
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 5:16 PM
To: [EMAIL PROTECTED]
Subject: Select Statement


I got this somewhere and I know it used to work on my 4x server. Now that
I'm on 5.1.5.2 I get a lot of nodes report back with 0 Megabytes but they
obviously sent files.

Anyone who can make it work since my SQL stills are pretty much non
existant?

/**/
/* Specify a date on the run line as follows  */
/* run q_backup 2001-09-30*/
/**/
select entity as node_name, date(start_time) as date, - cast(activity as
varchar(10)) as activity, time(start_time)as start, -
time(end_time) as end, cast(bytes/100 as decimal(6,0))as megabytes, -
cast(affected as decimal(7,0)) as files, successful from summary - where
date(start_time)='$1' and activity='BACKUP' order by megabytes desc

 NODE_NAME: NODEA
  DATE: 2002-12-09
  ACTIVITY: BACKUP
 START: 20:00:51
   END: 20:48:07
MEGABYTES: 0
 FILES: 100
SUCCESSFUL: YES



This one does the same thing with some nodes. It also only reports about
half the nodes even though it looks like it's supposed to be going back a
full day.

NODEA   NT_DOM WinNT0.00
1
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

A better one would also work.
Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail: [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (877) 905-7154

LAN free backup for Novell

[Jin Bae Chi]

Hi, expets,

I'm trying to implement LAN free backup feature with TSM 4.2 on AIX 4.3.3 for client 
nodes with Novell servers. These NetWare servers are fibre connected to EMC box 
through SAN switches. TSM support told me there is no Storage Agent support for 
Netware platforms. Does anyone backup Novell servers through Fibre Channel? What would 
be your suggestion to backup to tape library that resides on SAN? Thanks again for 
your help!!





Jin Bae Chi (Gus)
System Admin/Tivoli
Data Center
614-287-5270
614-287-5488 Fax
[EMAIL PROTECTED]

Re: DB2 backup on AIX

[Tomás Hrouda]

Many many thanks Davide.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Davide Giacomazzi
Sent: Wednesday, December 11, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: R: DB2 backup on AIX


Hi Tom`s, you can find a redbook concerning db2 backup using tsm to the
following link :

http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65
f/ca11be93f3ae47b2852569f800819a82?OpenDocument

Best regards

Davide Giacomazzi
Information Technology - TSM manager
Tel. (+39) 045.8182215
Gruppo Assicurativo Arca
Via San Marco 48 - 37138 Verona


-Messaggio originale-
Da: Tomas Hrouda [mailto:[EMAIL PROTECTED]]
Inviato: mercoledl 11 dicembre 2002 13.45
A: [EMAIL PROTECTED]
Oggetto: Re: DB2 backup on AIX


Thanks Daniel,

I'll try to contact him (if any exists :-)). But I have one more question
... is any redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Daniel Sparrman
Sent: Wednesday, December 11, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX


Hi

DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin.
It also explains how to do it in "Backing up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: DB2 backup on AIX

[Kolbeinn Josepsson]

Try this link:
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246247.html?Open




  Best regards,
  Kolbeinn Josepsson  7 Systems Engineer
  Tel: +354 569-7700 7 Fax: +354 569-7799
  www.nyherji.is








  Tomas Hrouda
  <[EMAIL PROTECTED]> To:  [EMAIL PROTECTED]
  Sent by: "ADSM:  cc:
  Dist StorSubject: Re: DB2 backup on AIX
  Manager"
  <[EMAIL PROTECTED]
  T.EDU>


  11.12.2002 12:44
  Please respond
  to "ADSM: Dist
  Stor Manager"






Thanks Daniel,

I'll try to contact him (if any exists :-)). But I have one more question
... is any redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Daniel Sparrman
Sent: Wednesday, December 11, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX


Hi

DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin.
It also explains how to do it in "Backing up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: Select Statement

[Mahesh Tailor]

You need to load the 5.1.5 client and the 5.1.5.2 patch.  With it the
summary data does not get transferred from the client to the server.

Mahesh

>>> [EMAIL PROTECTED] 12/10/02 08:30PM >>>
As it turns out the clients also have to be updated to correct a
problem
where the summary table statistics are missing.  I talked to a TSM
Level 2
person about this just last week.  I do not know what levels you have
to be
at to get the problem corrected, but I thought 5.1.5 was good enough.

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


-Original Message-
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 5:16 PM
To: [EMAIL PROTECTED]
Subject: Select Statement


I got this somewhere and I know it used to work on my 4x server. Now
that
I'm on 5.1.5.2 I get a lot of nodes report back with 0 Megabytes but
they
obviously sent files.

Anyone who can make it work since my SQL stills are pretty much non
existant?

/**/
/* Specify a date on the run line as follows  */
/* run q_backup 2001-09-30*/
/**/
select entity as node_name, date(start_time) as date, - cast(activity
as
varchar(10)) as activity, time(start_time)as start, -
time(end_time) as end, cast(bytes/100 as decimal(6,0))as megabytes,
-
cast(affected as decimal(7,0)) as files, successful from summary -
where
date(start_time)='$1' and activity='BACKUP' order by megabytes desc

 NODE_NAME: NODEA
  DATE: 2002-12-09
  ACTIVITY: BACKUP
 START: 20:00:51
   END: 20:48:07
MEGABYTES: 0
 FILES: 100
SUCCESSFUL: YES



This one does the same thing with some nodes. It also only reports
about
half the nodes even though it looks like it's supposed to be going back
a
full day.

NODEA   NT_DOM WinNT
0.00
1
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

A better one would also work.
Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail: [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (877) 905-7154

Re: delete filespace

[Raghu S]

Hi

These are from Admin Guide. I hope Tony can understand it now.


DELETE FILESPACE (Delete Client Node Data from the Server)


Use this command to delete file spaces from the server. Files that belong
to the file space are deleted from primary and copy storage pools.


.





EXPIRE INVENTORY (Manually Start Inventory Expiration Processing)


Use this command to manually start inventory expiration processing. The
inventory expiration process removes client backup and archive file copies
from server storage based on policy specified in the backup and archive
copy groups of the management classes to which the files are bound.








Regards





Raghu.






"Robert L. Rippy"
cc:
Sent by: "ADSM: Dist Stor Subject: Re: delete filespace
Manager"
<[EMAIL PROTECTED]>


12/11/2002 06:18 PM
Please respond to "ADSM:
Dist Stor Manager"





You are correct on how expiration works, but Michelle is talking about a
manual delete or deletion of filespaces. WHen you delete a filespace as
Michelle has done the data is removed immediately and expire inventory
isn't necessary. I don't think its a matter how long I have been doing TSM,
yet a matter that I understand TSM and how it works. But I have been doing
TSM for 3 years currently. Please, try this with a test node and see what
happens. Expiration is there for files that are expired by the client. The
client marks files as expired in the database, then when you run
expiration, it deletes the files that have been marked for expirarion from
the database. If you delete a filespace you are telling TSM that you know
you want them gone and they are deleted immediately.

How long have you been working with TSM?

Would anyone like to make a comment on this and help Tony Trinh understand
better how TSM functions?

Thanks,
Robert Rippy




From: "Trinh, Tony" <[EMAIL PROTECTED]> on 12/10/2002 05:49 PM

To:   Robert Rippy/CT/Mail@KindredHealthCare, [EMAIL PROTECTED]
cc:
Subject:  RE: delete filespace

Robert,

May I asked how long have you been working with TSM? You are wrong about
the
data get deleted after deleting the filespace. Why do you think there's a
process in place called expiration? This process is in place is to expired
old data of previous version of backup or deleted filespace.

Regards,
Tony

-Original Message-
From: Robert L. Rippy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:15 PM
To: [EMAIL PROTECTED]
Subject: Re: delete filespace

They are done immediately. Expire Inventory isn't necessary.

Thanks,
Robert Rippy





From: Michelle DeVault <[EMAIL PROTECTED]> on 12/10/2002 03:59 PM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  delete filespace

After doing a delete filespace, when do the deleted
files get removed from the storage pools?  After an
expire inventory?

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

R: DB2 backup on AIX

[Davide Giacomazzi]

Hi Tomàs, you can find a redbook concerning db2 backup using tsm to the
following link :

http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65
f/ca11be93f3ae47b2852569f800819a82?OpenDocument

Best regards

Davide Giacomazzi
Information Technology - TSM manager
Tel. (+39) 045.8182215
Gruppo Assicurativo Arca
Via San Marco 48 - 37138 Verona


-Messaggio originale-
Da: Tomás Hrouda [mailto:[EMAIL PROTECTED]]
Inviato: mercoledì 11 dicembre 2002 13.45
A: [EMAIL PROTECTED]
Oggetto: Re: DB2 backup on AIX


Thanks Daniel,

I'll try to contact him (if any exists :-)). But I have one more question
... is any redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Daniel Sparrman
Sent: Wednesday, December 11, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX


Hi

DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin.
It also explains how to do it in "Backing up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Oracle TDP - SVR4 Error: 11: Resource temporarily unavailable

[Chalton, Nicolas (MED, Cap Gemini)]

Hello,

I am using TDP 2.1 on Oracle 8.1.6.3 databases (target & catalog).

I get the following error message about one time a week for a daily backup.


RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03006: non-retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-27015: skgfcls: failed to close the
file
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 7023
ORA-19511: SBT error = 7023, errno = 11, sbtclose: system error
RMAN-10031: ORA-19583 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Thanks for help !
Nicolas.

Re: delete filespace

[Andrew Raibeck]

>From the DELETE FILESPACE information in the Admin Reference:

"Use this command to delete file spaces from the server. Files that belong
to the file space are deleted from primary and copy storage pools."

This is not the same as just flagging them as expired; they are actually
deleted.

So your explanation is pretty much correct. The only thing I would add is
that inventory expiration is not only for files that have been expired by
the client, but also for versions that exceed the version and retention
settings in your policy domains.

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.




"Robert L. Rippy" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
12/11/2002 05:48
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: delete filespace



You are correct on how expiration works, but Michelle is talking about a
manual delete or deletion of filespaces. WHen you delete a filespace as
Michelle has done the data is removed immediately and expire inventory
isn't necessary. I don't think its a matter how long I have been doing
TSM,
yet a matter that I understand TSM and how it works. But I have been doing
TSM for 3 years currently. Please, try this with a test node and see what
happens. Expiration is there for files that are expired by the client. The
client marks files as expired in the database, then when you run
expiration, it deletes the files that have been marked for expirarion from
the database. If you delete a filespace you are telling TSM that you know
you want them gone and they are deleted immediately.

How long have you been working with TSM?

Would anyone like to make a comment on this and help Tony Trinh understand
better how TSM functions?

Thanks,
Robert Rippy




From: "Trinh, Tony" <[EMAIL PROTECTED]> on 12/10/2002 05:49 PM

To:   Robert Rippy/CT/Mail@KindredHealthCare, [EMAIL PROTECTED]
cc:
Subject:  RE: delete filespace

Robert,

May I asked how long have you been working with TSM? You are wrong about
the
data get deleted after deleting the filespace. Why do you think there's a
process in place called expiration? This process is in place is to expired
old data of previous version of backup or deleted filespace.

Regards,
Tony

-Original Message-
From: Robert L. Rippy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:15 PM
To: [EMAIL PROTECTED]
Subject: Re: delete filespace

They are done immediately. Expire Inventory isn't necessary.

Thanks,
Robert Rippy





From: Michelle DeVault <[EMAIL PROTECTED]> on 12/10/2002 03:59 PM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  delete filespace

After doing a delete filespace, when do the deleted
files get removed from the storage pools?  After an
expire inventory?

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Re: delete filespace

[Robert L. Rippy]

You are correct on how expiration works, but Michelle is talking about a
manual delete or deletion of filespaces. WHen you delete a filespace as
Michelle has done the data is removed immediately and expire inventory
isn't necessary. I don't think its a matter how long I have been doing TSM,
yet a matter that I understand TSM and how it works. But I have been doing
TSM for 3 years currently. Please, try this with a test node and see what
happens. Expiration is there for files that are expired by the client. The
client marks files as expired in the database, then when you run
expiration, it deletes the files that have been marked for expirarion from
the database. If you delete a filespace you are telling TSM that you know
you want them gone and they are deleted immediately.

How long have you been working with TSM?

Would anyone like to make a comment on this and help Tony Trinh understand
better how TSM functions?

Thanks,
Robert Rippy




From: "Trinh, Tony" <[EMAIL PROTECTED]> on 12/10/2002 05:49 PM

To:   Robert Rippy/CT/Mail@KindredHealthCare, [EMAIL PROTECTED]
cc:
Subject:  RE: delete filespace

Robert,

May I asked how long have you been working with TSM? You are wrong about
the
data get deleted after deleting the filespace. Why do you think there's a
process in place called expiration? This process is in place is to expired
old data of previous version of backup or deleted filespace.

Regards,
Tony

-Original Message-
From: Robert L. Rippy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:15 PM
To: [EMAIL PROTECTED]
Subject: Re: delete filespace

They are done immediately. Expire Inventory isn't necessary.

Thanks,
Robert Rippy





From: Michelle DeVault <[EMAIL PROTECTED]> on 12/10/2002 03:59 PM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  delete filespace

After doing a delete filespace, when do the deleted
files get removed from the storage pools?  After an
expire inventory?

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Re: DB2 backup on AIX

[Tomás Hrouda]

Thanks Daniel,

I'll try to contact him (if any exists :-)). But I have one more question
... is any redbook or documentation about backing up DB2 database with TSM
available? I would like to do some plans and pre-studying steps to
accomplish this workaround.

Thanks

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Daniel Sparrman
Sent: Wednesday, December 11, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backup on AIX


Hi

DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin.
It also explains how to do it in "Backing up databases with Tivoli Storage
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervdgen 6B
183 62 HDGERNDS
Vdxel: 08 - 754 98 00
Mobil: 070 - 399 27 51

Re: Help on TDP for SAP R/3 Oracle

[Cook, Dwight E]

Well,
I'll reference two things here, folks using TDP/R3 (threaded
version) and
 TSM client compression might want to read ALL of this.


PMR93135 was from where tdp/r3 3.2.0.8 ignored the setting of
"client determined" compression.
This was fixed in 3.2.0.11.
Now, TDP/R3  ~RLCOMPRESSION~  sucks... all it does is take out free space
basically.
(that is my own personal opinion)
I like setting client compression ON and using that because we see about
3.8/1 compression !
So, which can be sent between two boxes the fastest, 1 TB or 270 GB 
(duh...)
BUT you will drive the heck out of your SAP DB servers !
Oh, and if you send to cached diskpools, ya know the old deal of
~compression on~ & ~compressalways no~
In working my PMR93135 problem, IBM Germany took things one step better...
tdp/r3 from 3.2.0.11 (and beyond) preallocates tsm server storage at
110% of actual file size,
if a file grows with compression it won't ~seem~ to grow and thus
resends are eliminated
IF you happen to still see resends due to data growing with
compression,
there is now an environment variable XINT_TSMOFFSET
pre-allocations will occur at a +10% by default
OR what ever value is specified in the environment variable
XINT_TSMOFFSET

COOL !

NO
PMR04127  when using client compression and multiple sessions (like
10, 15, or 20)
TDP/R3 just WILL NOT USE CPU CYCLES !!
It is from a thread option they were using when creating
those threads.
I currently have a fix-test executable for 3.2.0.x
The fix won't be out until end of 1st qtr 2003 in 5.1 TDP/R3
(I know, ((()

IF you are running with client compression and your CPU just isn't being
utilized AND you are on a TDP/R3 that uses threads AND you need more
performance, you might look into getting the fixed executable.
That will probably take opening a problem, making reference to pmr04127,
etc.

BUT back to your main question...
We set client compression ON in the dsm.sys file in the SErver entry
COMPRESSION YES
Then, when using TDP/R3 3.2.0.11 & later, in the dsm.opt file we set
COMPRESSALWAYS YES
We send the data to a cached diskpool during the night & migrate to tape
during the day.
If we experience a SAP PR failure, we restore from the cached diskpool copy.
(generally in record time)

hope this helps :-)


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: brian welsh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 4:19 PM
To: [EMAIL PROTECTED]
Subject: Help on TDP for SAP R/3 Oracle


Hello,

Server AIX 5.1, TSM 4.2.2.8. Client AIX 4.3, TSM 4.2.1.35, and TDP 3.2.0.11

Question about compression.

We forced compression for this client at server-side, by setting option
Compression at client-node options to server. In client-option file there is
no compression-option.

We thought that this will be enough to compress also TDP -backup and archive
data. We checked and there is no compression. Tivoli Support say first that
TDP is compressing the files always, it a feature of TDP. And later they say
we have to activate this in TDP on the client.

I'm wondering how other sites set compression in this situation. On the
server, in TDP, on the client, ...

Thanx,

Brian.





_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/

Re: DB2 backup on AIX

[Daniel Sparrman]

Hi

DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin. 
It also explains how to do it in "Backing up databases with Tivoli Storage 
Manager"

Best Regards

Daniel Sparrman
---
Daniel Sparrman
Exist i Stockholm AB
Propellervägen 6B
183 62 HÄGERNÄS
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51

DB2 backup on AIX

[Tomáš Hrouda]

Hi all,

one of our customers wants to backup DB2 database on AIX system. I didn't
find any TSM or TDP product to use it for online backup of DB2, but I want
to be sure. Is any way to do it (except of file backup of stoped databse
using basic AIX TSM client)? Do anybody have any experience with backup this
stuff on AIX?

Many thanks

Tomas Hrouda

Question about Veritas Cluster and filespace name

[Peter Bjoern]

Hi

We have a situation with a Veritas cluster installed on two Win2000
servers.
The physical servers are called J2P-CLUSTER101 and J2P-CLUSTER102.
There is a virtual server defined with the name WEB1.

Each physical server has it's own C: drive which is backed up via a
schedule
that specifies 'C:' and 'systemobject' on the domain statement in the
option file.
The C: filespaces are given the names \\J2P-CLUSTER101\C$ and
\\J2P-CLUSTER102\C$ respectively.  This is all OK.

There is a shared drive X: which is associated with the WEB1 resource and
moves with WEB1 between the two physical servers so that it is available
either on J2P-CLUSTER101 or J2P-CLUSTER102.

X: is backed up from a virtual node defined in TSM called WEB1 and via a
separate TSM scheduler
service with an option file that  specifies X: on the domain statement.

If this had been a Microsoft Cluster installation, we would have specified
'CLUSTERNODE YES' in the optionfiles to make TSM name the X: filespace
with the virtual clustername (WEB1) so that it would have been named
\\WEB1\X$ regardless of which physical server it was backed up from.

However, CLUSTERNODE does not work with a Veritas cluster, so the result is
that we get two parallel filespaces named  \\J2P-CLUSTER101\X$ and
\\J2P-CLUSTER101\X$ because X: sometimes resides on J2P-CLUSTER101
and some times on J2P-CLUSTER102.

>From previous postings on this list I get the impression that there is
nothing
we can do to solve this, but I just want to be sure if this is true

How are other people who are running Veritas clusters and TSM solving this
?

This is a bad situation and one could fear (from a TSM person point of
view) that
it could pave the way for the introduction of Veritas backup software at
the site.

If CLUSTERNODE cannot easily be enhanced to support Veritas clusters as
well, all we would need would be a new statement in the option file,
perhaps called
MACHINENAME or so, where we could specify 'MACHINENAME WEB1' in the
optionfile and then have TSM use this name is the filespacing naming
process.

Regards

Peter

Re: Webrowser sessions that drive up cpu usage on AIX

[Steve Schaub]

We have been plagued by this problem for several years.  We have only
seen problems when a client machine has IE at level 5.0.  We ended up
including a "phantom killer" to our healthcheck that cancels any "?"
sessions it finds when it runs.

-Original Message-
From: Robert L. Rippy [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 10, 2002 7:25 AM
To: [EMAIL PROTECTED]
Subject: Re: Webrowser sessions that drive up cpu usage on AIX


I have seen them left behind when a user doesn't log out and just closes
the window also.

Thanks,
Robert Rippy



From: Peter Hadikin <[EMAIL PROTECTED]> on 12/09/2002 04:08 PM

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

To:   [EMAIL PROTECTED]
cc:
Subject:  Webrowser sessions that drive up cpu usage on AIX

Running TSM server on AIX ... AIX is at 4.3.3 maintenance level 10, TSM
server is a 5.1.5.2.  Anybody seen 'phantom' sessions left behind by
using a webrowser that seem to use plenty of cycles on the server?  Is
is just me or are others seeing this?

1,928 HTTP   RecvW0 S0   0 Admin WebBrow- ?
   ser
 1,949 HTTP   Run  0 S0   0 Admin WebBrow- ?
   ser

Thanks in advance, Peter