Antwort: Re: missing data in summary table

[Karin Dambacher]

Hi,

that there were problems in the past with the summary table, I know. But I
have not seen one in the last time, so I wonder about this.
TSM Server is 5.2.1.3 AIX 5
TSM Client is 5.2.3.4 Windows 2003

We saw the problem in the daily e-mail of tsmm, the server is missing
sometimes. And then we looked for the missed days in the summary table, and
the server is not there for that days. The schedules were completed
successfully.
Maybe updating to the newest maintenance/patch will help. I hope so.

Best regards, Karin



|-+>
| |   Andrew Raibeck   |
| |   <[EMAIL PROTECTED]|
| |   OM>  |
| |   Gesendet von:|
| |   "ADSM: Dist Stor |
| |   Manager" |
| |   <[EMAIL PROTECTED]|
| |   .EDU>|
| ||
| ||
| |   29.11.2004 15:17 |
| |   Bitte antworten  |
| |   an "ADSM: Dist   |
| |   Stor Manager"|
|-+>
  
>-|
  | 
|
  |   An:   [EMAIL PROTECTED]
|
  |   Kopie:(Blindkopie: Karin Dambacher/Emprise)   
|
  |   Thema:Re: missing data in summary table   
|
  
>-|




> Until know, we expect that everybody in the world (except TSM
> developers) know that data in Summary table is not reliable at all.
>
> Andy??? (True or False)

As a blanket statement, I'd have to answer "false".

I am not personally aware of any problems in current code (and this
doesn't mean that, hypothetically, there aren't any), but historically TSM
server development is fully aware of past problems.

If you have specific problems with SUMMARY table information, then I
recommend that you:

- Consider the most current server maintenance. Check the README file to
see if any known problems are fixed in that level.

- Search the TSM support page
(
http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
)
for problems that match your symptoms.

- Open a problem with IBM support.

With that said.. what problems are you currently experiencing with the
SUMMARY table, and which TSM server are you running?

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

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

"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/26/2004
13:27:58:

> Until know, we expect that everybody in the world (except TSM
> developers) know that data in Summary table is not reliable at all.
>
> Andy??? (True or False)
>
> Use Activity log.
>
> Joe C.
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
> Karin Dambacher
> Sent: Friday, November 26, 2004 5:15 AM
> To: [EMAIL PROTECTED]
> Subject: missing data in summary table
>
> Hi everybody
>
> I miss data for one fileserver in my summary table. If I ask for data
> with
> "select * from summary where entitiy="nodename", for some days there is
> data, other days nothing is in the table. The schedules have the status
> "Completed".
> Other file servers (associated to the same client schedule) are in the
> summary table with data every day.
>
> Does anybody know why?
>
> TSM Server 5.2.1.3 AIX 5
> TSM Client 5.2.3.4 Windows 2003
>
> Thanks, Karin

Re: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2

[goc]

- Original Message -
From: "Peter Hadikin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 29, 2004 11:26 PM
Subject: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2

Hello TSMers
We are planning to finally update the AIX version on our RS6000 that is
running our TSM server.  Currently we are at AIX 4.3.3 ML 10 and we are
planning to install AIX 5.2.  The TSM server on this box is sitting at
TSM 5.1.5.4.  Can we simply upgrade to AIX 5.2 and leave the TSM server
at 5.1.5.4 for the time being?  Would it be beneficial to move to some
level of the TSM 5.2.x server?  If we are moving to TSM 5.2.x, can we do
a one step migration from TSM 5.1.5.4 or are there multiple steps to the
upgrade?
Any info or experiences would be most appreciated,
Take care,
Peter
Peter Hadikin
[EMAIL PROTECTED]
Phone: 604-432-8452
Fax: 604-439-6785
dont forget to upgrade microcode levels for your hardware
for aix 5.2 before upgrading the OS, or you will be in trouble

TSM 5.2, Solaris 8 w/ STK L700 9940B drive.

[Ruengrit Changkwanyuen]

Hi Guys,

Currently I'm having problem configuring TSM mt driver on Solaris 8 with STK
9940B tape drive. I tried many different mt.conf configuration but I still
got the following error:

# add_drv -v /usr/kernel/drv/mt
exit status = 0
devfsadm: driver failed to attach: mt
exit status = 11
Warning: Driver (mt) successfully added to system but failed to attach
Driver (mt) installed.

Following is the configuration that I have been tried:

name="mt" class="scsi" target=2 lun=0;
name="mt" parent="fp" target=0 lun=0 fc-port-wwn="21e08b17938b";
name="mt" class="scsi" target=2 lun=0 hba="fca-pci1"
wwpn="21e08b17938b";

I did try with different combination of target and lun number but it didn't
seem to work. Here is the information of my HBA card:

system  SUNWqlcQlogic ISP 2200/2202 Fibre Channel Device Driver
system  SUNWqlcx   Qlogic ISP 2200/2202 Fibre Channel Device Driver
(64 bit)

#  pkginfo -l SUNWqlc
   PKGINST:  SUNWqlc
  NAME:  Qlogic ISP 2200/2202 Fibre Channel Device Driver
  CATEGORY:  system
  ARCH:  sparc
   VERSION:  11.8.0,REV=2000.04.01.16.21
   BASEDIR:  /
VENDOR:  Sun Microsystems, Inc.
  DESC:  Qlogic ISP 2200/2202 Fibre Channel Device Driver
PSTAMP:  nsvr-30020040307201709
  INSTDATE:  Jul 21 2004 07:32
   HOTLINE:  Please contact your local service provider
STATUS:  completely installed
 FILES:4 installed pathnames
   2 shared pathnames
   2 directories
   1 executables
 677 blocks used (approx)

# prtdiag
System Configuration: Sun Microsystems  sun4u Sun Fire V240
System clock frequency: 160 MHZ
Memory size: 2GB

 CPUs

  E$  CPU CPU   Temperature Fan
   CPU  Freq  SizeImpl.   Mask DieAmbient   Speed
Unit
   ---    --  --        -

 MB/P0  1280 MHz  1MB US-IIIi  2.4   --
 MB/P1  1280 MHz  1MB US-IIIi  2.4   --

= IO Devices
=
 Bus   Freq
Brd  Type  MHz   SlotName  Model
---      --  

 0   pci66   MB  pci108e,1648 (network)

 0   pci66   MB  pci108e,1648 (network)

 0   pci33   MB  isa/su (serial)

 0   pci33   MB  isa/su (serial)

 0   pci33   MB  pci10b9,5229 (ide)

 0   pci33 PCI2  SUNW,qlc-pci1077,2300 (scsi-+

 0   pci33 PCI1  SUNW,qlc-pci1077,2300 (scsi-+

 0   pci66   MB  scsi-pci1000,21 (scsi-2)

 0   pci66   MB  scsi-pci1000,21 (scsi-2)

 0   pci66   MB  pci108e,1648 (network)

 0   pci66   MB  pci108e,1648 (network)

 0   pci66 PCI0  SUNW,XVR-100 (display)SUNW,375-3181

 0   pci337  isa/rmc-comm-rmc_comm (seria+


# cfgadm -al
Ap_Id  Type Receptacle   Occupant
Condition
c0 scsi-bus connectedconfigured
unknown
c0::dsk/c0t0d0 disk connectedconfigured
unknown
c1 scsi-bus connectedunconfigured
unknown
c2 scsi-bus connectedconfigured
unknown
c2::dsk/c2t0d0 CD-ROM   connectedconfigured
unknown
c3 fc-fabricconnectedconfigured
unknown
c3::500104f0006fd113   tape connectedconfigured
unknown
c3::500104f0006fd11f   tape connectedconfigured
unknown
c3::500104f0006fd12e   tape connectedconfigured
unknown
c3::500104f000775529   tape connectedconfigured
unknown
c3::500601601060288e   disk connectedconfigured
unknown
c3::500601691060288e   disk connectedconfigured
unknown
c4 fc-fabricconnectedconfigured
unknown
c4::500601611060288e   disk connectedconfigured
unknown
c4::500601681060288e   disk connectedconfigured
unknown

[EMAIL PROTECTED] # luxadm -e dump_map /dev/fc/fp0
Pos  Port_ID Hard_Addr Port WWN Node WWN Type
010ee2   e2500104f0006fd12e 500104f0006fd12d 0x1  (Tape device)
111ee8   e8500104f0006fd11f 500104f0006fd11e 0x1  (Tape device)
211fe4   e4500104f0006fd113 500104f0006fd112 0x1  (Tape device)
35   0 500601691060288e 500601609060288e 0x0  (Disk device)
451000   0 500601601060288e 500601609060288e 0x0  (Disk device)
570f55   55500104f000775529 500104f000775528 0x1  (Tape device)
651500   0 21e08b17938b 20e08b17938b 0x1f (Unknown
Type,Host Bus Adapter)

How can I fix this 

TSM Exteneded Edition ver5.2 and TSM ver 5.1.5

[nghiatd]

Dear all,

I 'm using TSM ver 5.1.5 and I want to upgrade to TSM Extended Edition ver 5.2. 
I know TSM Ext Edit support creating recovery plan file and disaster recovery 
automatically (that TSM ver 5.1.5 doesn't have), larger library. 

I also visited web site IBM but I haven't found additional feature.

Does anyone know TSM Exteneded Edition ver 5.2 is different from TSM ver 5.1.5 
? (exception these functions)

Thank in advance,

Nghiatd

auto reply for checkin and checkout

[Mark Strasheim]

Aloha,

is there is possibility to avoid the need of reply(ing)
to checkout and checkin processes.

with regrads
Mark Strasheim

--

definitiv! business applications GmbH & Co. KG
Fresnostrasse 14 - 18 · DE-48159 Münster
Tel. +49 (0) 251 21092 - 23 · Fax +49 (0) 251 21092 - 29
 mailto:[EMAIL PROTECTED] ·
 http://www.definitiv-ba.de

--

Re: Scheduling time problem

[Bos, Karel]

Hi,

The duration of the schedule is something to check as well as the client 
scheduling mode (polling/prompted).

Regards,

Karel

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
chithirai selvan
Sent: maandag 29 november 2004 21:37
To: [EMAIL PROTECTED]
Subject: Scheduling time problem


i have problem in understanding the time manipulation
in tivoli for schedule.
i synchronize my server for this reason  last month,
still i'm having problem.if i define schedule for some
node at 19.00.58
it's executing in differnce of 5 hrs affter.

any one please explain this one.
some points i need to be cleard

Tivoli uses OS time information rite not of Hardware
Clock rite.


thanx in advance,
Chithirai Selvan.R



__
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

Re: auto reply for checkin and checkout

[Henrik Wahlstedt]

Hi,

Try:
checkout libv library tape remove=bulk checkl=n
checkin libv library search=bulk checkl=barcode status=pri.



Med vänlig hälsning






 Henrik Wahlstedt  Statoil   Phone: +46 8 429 6325  

 KTJ IT NED SE1Torkel Knutssonsgatan 24  Mobile: +46 70 429 6325

   118 88 Stockholm  E-mail:

   Sverige   [EMAIL PROTECTED]   







   
Mark
   
StrasheimTo: [EMAIL PROTECTED]   
   
<[EMAIL PROTECTED]cc: (bcc: Henrik Wahlstedt)   

-BA.DE>  Subject: auto reply for checkin 
and checkout  
Sent by:
   
"ADSM: Dist 
   
Stor Manager"   
   
<[EMAIL PROTECTED]  

RIST.EDU>   
   

   

   
2004-11-30  
   
11:27   
   
Please  
   
respond to  
   
"ADSM: Dist 
   
Stor Manager"   
   

   

   




Aloha,

is there is possibility to avoid the need of reply(ing)
to checkout and checkin processes.

with regrads
Mark Strasheim

--

definitiv! business applications GmbH & Co. KG
Fresnostrasse 14 - 18 · DE-48159 Münster
Tel. +49 (0) 251 21092 - 23 · Fax +49 (0) 251 21092 - 29
 mailto:[EMAIL PROTECTED] ·
 http://www.definitiv-ba.de

--




---
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.

Re: Select Statement Help for Volume Breakdown

[Matt Chan]

Hello all,

Related to this in a way then, can anyone help me with how to determine
which of all my defined tapes are scratch, for audit purposes ?


Matt Chan





"Stapleton, Mark" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
23/11/2004 07:23 AM
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To
[EMAIL PROTECTED]
cc

Subject
Re: Select Statement Help for Volume Breakdown






There are no scratch tapes in storage pools. A tape volume only exists
in a storage pool when it contains client data (and is therefore no
longer a scratch tape).

--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627

SQL Help

[David E Ehresman]

I'm trying to get a count of tapes pending by date.  I'm using:
select date(pending_date),count(*) from volumes where
status='PENDING' -
   group by date(pending_date)
but I get the error message:
   ANR2904E Unexpected SQL key word token - 'DATE'.
pointing to the date in the group by clause.

Anyone know how to get a pending count by date?

David

Re: Select Statement Help for Volume Breakdown

[Richard Sims]

Matt -
Do   select * from volumes where scratch='Yes'
That is, a volume which is in use in a storage pool,
which came from the Scratch tape pool, will have its
SCRATCH column set to Yes.  A storage pool volume
which is in the storage pool because of a Define Volume
will have a SCRATCH column value of No.
   Richard Sims
On Nov 30, 2004, at 7:21 AM, Matt Chan wrote:
Hello all,
Related to this in a way then, can anyone help me with how to determine
which of all my defined tapes are scratch, for audit purposes ?
Matt Chan
"Stapleton, Mark" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
23/11/2004 07:23 AM
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only exists
in a storage pool when it contains client data (and is therefore no
longer a scratch tape).
--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627

Re: SQL Help

[James Choate]

Try this.
 
select date(pending_date), count(*) from volumes where -
status='PENDING' -
 group by pending_date
 



From: ADSM: Dist Stor Manager on behalf of David E Ehresman
Sent: Tue 11/30/2004 6:10 AM
To: [EMAIL PROTECTED]
Subject: SQL Help



I'm trying to get a count of tapes pending by date.  I'm using:
select date(pending_date),count(*) from volumes where
status='PENDING' -
   group by date(pending_date)
but I get the error message:
   ANR2904E Unexpected SQL key word token - 'DATE'.
pointing to the date in the group by clause.

Anyone know how to get a pending count by date?

David

Re: Select Statement Help for Volume Breakdown

[James Choate]

Matt,
 
The scratch column is case sensitive.  Looks like the yes & no are 
capitalized.  
 
The status column is YES|NO|NULL
 
james



From: ADSM: Dist Stor Manager on behalf of Richard Sims
Sent: Tue 11/30/2004 6:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Select Statement Help for Volume Breakdown



Matt -

Do   select * from volumes where scratch='Yes'
That is, a volume which is in use in a storage pool,
which came from the Scratch tape pool, will have its
SCRATCH column set to Yes.  A storage pool volume
which is in the storage pool because of a Define Volume
will have a SCRATCH column value of No.

Richard Sims

On Nov 30, 2004, at 7:21 AM, Matt Chan wrote:

> Hello all,
>
> Related to this in a way then, can anyone help me with how to determine
> which of all my defined tapes are scratch, for audit purposes ?
>
> Matt Chan
>
>
> "Stapleton, Mark" <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> 23/11/2004 07:23 AM
> Please respond to
> "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
>
> To
> [EMAIL PROTECTED]
> cc
>
> Subject
> Re: Select Statement Help for Volume Breakdown
>
> There are no scratch tapes in storage pools. A tape volume only exists
> in a storage pool when it contains client data (and is therefore no
> longer a scratch tape).
>
> --
> Mark Stapleton ([EMAIL PROTECTED])
> Berbee Information Networks
> Office 262.521.5627

Re: Select Statement Help for Volume Breakdown

[Richard Sims]

On Nov 30, 2004, at 8:40 AM, James Choate wrote:
The scratch column is case sensitive.  Looks like the yes & no are
capitalized.
The status column is YES|NO|NULL
Such things are prone to change over time: in some releases only
the initial character is capitalized.  We often have to find out
the particulars by trial and error, or getting a syscat columns
listing.
   Richard Sims

Re: SQL Help

[David E Ehresman]

That groups things by a time stamp which results in a count of one for
each time stamp.  I'm trying to get a count by date, not by
minute/second.

David

>>> [EMAIL PROTECTED] 11/30/2004 8:16:10 AM >>>
Try this.

select date(pending_date), count(*) from volumes where -
status='PENDING' -
 group by pending_date




From: ADSM: Dist Stor Manager on behalf of David E Ehresman
Sent: Tue 11/30/2004 6:10 AM
To: [EMAIL PROTECTED]
Subject: SQL Help



I'm trying to get a count of tapes pending by date.  I'm using:
select date(pending_date),count(*) from volumes where
status='PENDING' -
   group by date(pending_date)
but I get the error message:
   ANR2904E Unexpected SQL key word token - 'DATE'.
pointing to the date in the group by clause.

Anyone know how to get a pending count by date?

David

Re: Select Statement Help for Volume Breakdown

[David E Ehresman]

The use of upper/lower functions in SQL statements can save a lot of
grief!

>>> [EMAIL PROTECTED] 11/30/2004 8:47:29 AM >>>
On Nov 30, 2004, at 8:40 AM, James Choate wrote:

> The scratch column is case sensitive.  Looks like the yes & no are
> capitalized.
>
> The status column is YES|NO|NULL

Such things are prone to change over time: in some releases only
the initial character is capitalized.  We often have to find out
the particulars by trial and error, or getting a syscat columns
listing.

Richard Sims

Re: SQL Help

[Stapleton, Mark]

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of David E Ehresman
>I'm trying to get a count of tapes pending by date.  I'm using:
>select date(pending_date),count(*) from volumes where 
>status='PENDING' -
>   group by date(pending_date)
>but I get the error message:
>   ANR2904E Unexpected SQL key word token - 'DATE'.
>pointing to the date in the group by clause.
>
>Anyone know how to get a pending count by date?

Try

  select date(pending_date) as "Date",count(*) from volumes where
status='PENDING' group by "Date"

--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627  

LAN-free Data transfer

[Joni Moyer]

Hello All!

TSM 5.2.2.5 server AIX 5.2
Sun Solaris Lan-Free client 5.2.2.5

Once the lan-free data transfer fails it is stated that you must recycle
the storage agent.  I was just wondering what everyone has in place to
accomplish this once lan-free has failed?  Do you look at the system every
1/2 hour to see if the storage agent is running or do you try to trap a
certain message and then recycle the storage agent?  Any suggestions would
be appreciated.  Thank you!


Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]

Re: LTO Media

[Kauffman, Tom]

It may not clean the drive, but the library updated the usage counter for the 
tape evry time we loaded it.

Tom

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stef Coene
Sent: Tuesday, November 30, 2004 1:32 AM
To: [EMAIL PROTECTED]
Subject: Re: LTO Media

On Monday 29 November 2004 22:25, Kauffman, Tom wrote:
> My original LTO-1 library went back to the leasing company after three
> years of use, averaging about 2 TB of data per DAY across 10 drives. In
> that time period, we clocked 11 uses of one cleaning tape. All eleven
> were manually triggered from the operator panel (move tape from slot to
> drive) to check out tape drives after repair/replace in the first two
> months (before we got the proper microcode installed on the drives).
>
> In other words -- 3 years, 2 TB/day * 365 days *3 -- and the drives
> never indicated they needed to be cleaned. And no I/O errors relating to
> cleaning being required.
I thought that you can not clean a lto drive if it isn't needed.  You can put 
the cleaning tape in, but it will not clean the drive.
Each cleaning tape also has a counter so you can only use it a few times (most 
tapes can be used 50 times).

Stef

-- 
[EMAIL PROTECTED]
 "Using Linux as bandwidth manager"
     http://www.docum.org/

Re: auto reply for checkin and checkout

[Bill Boyer]

Not until TSM 5.3. When you use SEARCH=BULK you get the reply. For a Unix
box you could use this small shell script. I think someone on this list
posted it..I don't lay claims to it. For our Windows servers, we have a
small Perl script that does the same thing.

# set the admin username and password and the email contact
dsmuser=
dsmpass=
dsmadmc -id=$dsmuser -pa=$dsmpass "run checkin"
sleep 15
REQNO=$(dsmadmc -id=$dsmuser -pa=$dsmpass "q req"|grep ANR8373I| awk '{print
$2}'|tr -d ':')
dsmadmc -id=$dsmuser -pa=$dsmpass "reply $REQNO"

# finished
exit 0

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Henrik Wahlstedt
Sent: Tuesday, November 30, 2004 6:31 AM
To: [EMAIL PROTECTED]
Subject: Re: auto reply for checkin and checkout


Hi,

Try:
checkout libv library tape remove=bulk checkl=n
checkin libv library search=bulk checkl=barcode status=pri.



Med vdnlig hdlsning



 Henrik Wahlstedt  Statoil   Phone: +46 8 429 6325
 KTJ IT NED SE1Torkel Knutssonsgatan 24  Mobile: +46 70 429 6325
   118 88 Stockholm  E-mail:
   Sverige
[EMAIL PROTECTED]






Mark
StrasheimTo: [EMAIL PROTECTED]
<[EMAIL PROTECTED]cc: (bcc: Henrik Wahlstedt)
-BA.DE>  Subject: auto reply for checkin
and checkout
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


2004-11-30
11:27
Please
respond to
"ADSM: Dist
Stor Manager"






Aloha,

is there is possibility to avoid the need of reply(ing)
to checkout and checkin processes.

with regrads
Mark Strasheim

--

definitiv! business applications GmbH & Co. KG
Fresnostrasse 14 - 18 7 DE-48159 M|nster
Tel. +49 (0) 251 21092 - 23 7 Fax +49 (0) 251 21092 - 29
 mailto:[EMAIL PROTECTED] 7
 http://www.definitiv-ba.de

--




---
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.=

Re: size of active vs. inactive?

[Johnson, Milton]

We have been using a VTL for 3-4 months and we consider it a success.  

Environment:


*   OS: AIX 4330-11
*  TSM: Version 4, Release 2, Level 1.7
* Physical Library: Single frame 3494 w/2 3590E1A Drives
*  VTL: Sepaton ES2100 10.5TB (Raw)
* VTL Drive Config: 50 Drives
*VTL Tape Vol Size: 10 GB (picking a size is a religious belief)
* VTL Tape Volume Quantity: 839
*   Avg Nightly Backup Amt: ~750 GB
* Client Types: AIX, Windoze(NT, 2000, 2003), Oracle (TDP), 
.   Microsoft SQL (TDP), Novell
*  Collocation: None
*Total Primary Stg Amt: ~10.3 TB

Problems Leading Requiring Upgrade/VTL Purchase:


* Poor restoration speed for file servers due to:
- No use of collocation because of single frame 3494, amt of primary
stg, desire
. to make tape management simple (read desire tape library to house all
primary
. tape volumes, no overflow to a cabinet/vault)
- Only 2 drives
- Both drives spinning tapes 95%-99% of day doing migrations, backups
and 
. reclamations, leaving little time for restorations.

* Poor offsite reclamation performance: Offsite tape count growing to
~500 with
. >400 being >50% reclaimable

* Onsite tape count growth forcing expansion of existing
library/purchase of new
. library and associated disk stgpool

Reasons Pushing to VTL over DASD and Physical Library:


* Ability to do LAN Free back-ups w/o Sanergy
* Storage compression w/o load on TSM server or client
* Performance: Mounts/Unmounts, Reads, Writes (Comparison with physical
tapes
. need to keep in mind your clients/server may not be able to
continuously
. stream data to tape.
* Desire to break out of the structure where growth requires growth of
library
. system AND disk stgpool
* Ease of implementation

Benefits Realized:


* All of the problems requiring the upgrade have been eliminated
* All primary stg pool data has been moved to the VTL
* 3494 is only used for the offsite COPYPOOL stgpools and offsite DB
back-ups
* offsite COPYPOOL reduced to ~195 tapes with ~5 being >50% reclaimable
* 3494 drives no longer have to spin 95% of the day
* Back-up and restorations greatly improved w/o use of collocation
* Implementation was easy:
- VTL was TSM certified just like a physical library
- VTL install and config: ~1 hours
- TSM Config (Library, Drives, stgpool): ~20 minutes
- TSM labeling of 839 volumes: ~2 hours
- ~2 minutes to update the NEXT STGPOOL on the primary disk stgpools to
point to
. VTL stgpool

We viewed the costs of the VTL vs. a physical library with drives (that
performs like the VTL) and associated disk stgpool to be comparable.

Needless to say, I disagree with the statement that TSM doesn't appear
to be a good fit for a VTL.  Remember a VTL is just a library that can
mount/unmount a tape in less than one second and read/write to the tape
at disk speeds.  Why wouldn't TSM work well with a library on steroids?
 
Thanks,
H. Milton Johnson

 
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
David E Ehresman
Sent: Monday, November 29, 2004 2:42 PM
To: [EMAIL PROTECTED]
Subject: Re: size of active vs. inactive?

>>It has also been discussed several times that TSM doesn't appear to be
a
good fit for a VTL. May want to search the archives to find out more on
the subject.<<

Has anyone heard of good experiences with TSM on a virtual tape library?
Can this ever be a good thing?

Re: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2

[Bill Boyer]

You will need to uninstall the current TSM filesets. There are different
versions for AIX5 in the TSM filesets..plus if you're turning on 64-bit.
When we did this we did:

1. BA DB T=FULL
2. Halt TSM
3. Uninstall TSM (SMITTY)
4. We saved the files DSMSERV.DSK, DSMSERV.OPT, DEVCONFIG and VOLHISTORY
4.5 Renamed the DSMSERV.DSK file so the re-install doesn't touch the
database.
5. Upgrade AIX, Atape if applicable.
6. Install the 5.1.5.4 TSM with appropriate filesets for AIX5 and 64-bit.
7. Rename the DSMSERV.DSK file (from 4.5 above) back
8. Start TSM. I normally bring it up in the foreground for the first time so
I can watch for any errors.

If things don't work out, you can always RESTORE DB from the #1 tape above.

I would also recommend upgrading the firmware on the library/drives and any
tape drives (Atape if using IBM drives). If using non-IBM, you'll need to go
back in and redefine the TSM Devices (SMITTY DEVICES). Get a mapping of the
LBx and MTx before you start so you can make them match after the upgrade.

Bill Boyer
"I saw screens of green, red messages too, then came blue, shubidu
And i think to myself, what a wonderful world
" - ??


-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
goc
Sent: Tuesday, November 30, 2004 3:33 AM
To: [EMAIL PROTECTED]
Subject: Re: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2


- Original Message -
From: "Peter Hadikin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 29, 2004 11:26 PM
Subject: Upgrading AIX from 4.3.3 ML 10 to AIX 5.2


> Hello TSMers
>
> We are planning to finally update the AIX version on our RS6000 that is
> running our TSM server.  Currently we are at AIX 4.3.3 ML 10 and we are
> planning to install AIX 5.2.  The TSM server on this box is sitting at
> TSM 5.1.5.4.  Can we simply upgrade to AIX 5.2 and leave the TSM server
> at 5.1.5.4 for the time being?  Would it be beneficial to move to some
> level of the TSM 5.2.x server?  If we are moving to TSM 5.2.x, can we do
> a one step migration from TSM 5.1.5.4 or are there multiple steps to the
> upgrade?
>
> Any info or experiences would be most appreciated,
>
> Take care,
> Peter
>
> Peter Hadikin
> [EMAIL PROTECTED]
> Phone: 604-432-8452
> Fax: 604-439-6785

dont forget to upgrade microcode levels for your hardware
for aix 5.2 before upgrading the OS, or you will be in trouble

Re: size of active vs. inactive?

[Richard Sims]

On Nov 30, 2004, at 9:58 AM, Johnson, Milton wrote:
...Needless to say, I disagree with the statement that TSM doesn't
appear
to be a good fit for a VTL.  Remember a VTL is just a library that can
mount/unmount a tape in less than one second and read/write to the tape
at disk speeds.  Why wouldn't TSM work well with a library on
steroids? ...
Thanks for sharing your experience with VTL in a TSM environment:
it's helpful to have the perspective of experience.
As we've seen in past tape vs. disk discussions, though, don't regard
"disk speed" as some kind of ultimate data processing I/O attainment:
high performance tape technologies streaming to sequential media can
in many cases out-pace disk throughput.  It is in mounting and tape
positioning that tape is a poor performer relative to disk, where one
can wait a minute or more before I/O can proceed.  That's were VTL
shines.
   Richard Sims

Re: tsm server and nas client

[Killam, Perpetua]

Hi 

1.

we have tsm 5.2 running on sun 5.8, our nas tsm client is on hp11 tsm
5.1 version,Everytime we tried to backup, we are getting these errors
and no backup
"PrivIncrFileSpace: Received rc=106 from fioGetDirEntries:" error
message 

And no backup performed, any ideas would be helpful.

2. we are also going to test directly mounting the filesystem onto our
tsm server, any thoughts/restrictions welcomed.


Thanks,
Perpetua




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

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

Re: size of active vs. inactive?

[Prather, Wanda]

A lot of the earlier discussions on the list were related to the IBM
3494 VTL, which was designed for handling small chunks of seldom-used
sequential data.  It is prone to performance issues when handling LARGE
chunks of sequential data, so it is not a good fit for backup products
like TSM, which are designed to FILL a volume, whether virtual or real.


The 3494 VTL uses a combination of disk and tape, whereas the newer
VTL's are all disk - a very different architecture.  And so these newer
types of VTL's will have different issues.

When considering performance issues, know thine own hardware
architecture.

Now, back to the original point of this thread, sizing a library (real
or virtual):

The biggest mistake people make when sizing a TSM library is in just
summing up the total amount of data they will back up.
Not only do you need additional space in the library for your inactive
versions, you must allow for the fact that  your volumes WILL NOT BE
FULL.  Data is constantly expiring, and on a given day a significant
number of your volumes will be partially full, but below your
reclamation threshold.  

My rule(s) of thumb:

1.For file server backups, start with the amount of data you will back
up.  Add .05 (5 per cent) multiplied by the number of VERSIONS you will
keep.  (IBM recommends 10% as a starting point, but I find the rate of
change on most file servers to be far less than that).

2.For large data bases, (Oracle, Exchange, etc.)  start with the amount
of data you will back up.  Multiply by the number of versions you will
keep.

3.Add some additional tapes for your DB backups and scratch pool.

4.Assume that you will get at most a compression ratio of 1.5.

5.Assume that your tapes will be, on average 60% full.

6.Now that you have a total, remember that most data centers experience
a rate of growth in data storage of 50-100% PER YEAR.  Whatever you buy
for TSM, it better be expandable.

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)


 



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Tuesday, November 30, 2004 10:36 AM
To: [EMAIL PROTECTED]
Subject: Re: size of active vs. inactive?


On Nov 30, 2004, at 9:58 AM, Johnson, Milton wrote:

> ...Needless to say, I disagree with the statement that TSM doesn't
> appear
> to be a good fit for a VTL.  Remember a VTL is just a library that can
> mount/unmount a tape in less than one second and read/write to the
tape
> at disk speeds.  Why wouldn't TSM work well with a library on
> steroids? ...

Thanks for sharing your experience with VTL in a TSM environment:
it's helpful to have the perspective of experience.
As we've seen in past tape vs. disk discussions, though, don't regard
"disk speed" as some kind of ultimate data processing I/O attainment:
high performance tape technologies streaming to sequential media can
in many cases out-pace disk throughput.  It is in mounting and tape
positioning that tape is a poor performer relative to disk, where one
can wait a minute or more before I/O can proceed.  That's were VTL
shines.

Richard Sims

IMAGE backups on AIX

[Zoltan Forray/AC/VCU]

What is the minimum client level to perform IMAGE backups on AIX ?

scheduled SQL log backup question

[Luc Beaudoin]

Hi all

I'm doing SQL LOG backup every 6 hours and a full backup every day ...

I got a failed status everytime cause I can not take theLOG backup of the
master DB ...

This is the command that I launch ...

%sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
/logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log

Is there a option that I can put .. like   backup ALL LOG except MASTER

thanks

Luc Beaudoin
Network Administrator/ SAN/TSM
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254

Re: size of active vs. inactive?

[Johnson, Milton]

I agree with your comments and yes if your server/client can stream data
fast enough to the tape drive you may be able to out-pace a disk drive.
If you can not keep up with the tape drive then you can take a serious
performance hit when the tape stops, repositions and restarts.  This
performance hit is not as great with a virtual tape.  

We also looked at the "3494 VTL or Tape Server" and saw that it is
indeed a poor fit for TSM.  Most TSM configurations already have a disk
based stgpool front-end to the tape library so you would not gain much
by adding one inside the library.

Than
H. Milton Johnson
 
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Tuesday, November 30, 2004 9:36 AM
To: [EMAIL PROTECTED]
Subject: Re: size of active vs. inactive?

On Nov 30, 2004, at 9:58 AM, Johnson, Milton wrote:

> ...Needless to say, I disagree with the statement that TSM doesn't 
> appear to be a good fit for a VTL.  Remember a VTL is just a library 
> that can mount/unmount a tape in less than one second and read/write 
> to the tape at disk speeds.  Why wouldn't TSM work well with a library

> on steroids? ...

Thanks for sharing your experience with VTL in a TSM environment:
it's helpful to have the perspective of experience.
As we've seen in past tape vs. disk discussions, though, don't regard
"disk speed" as some kind of ultimate data processing I/O attainment:
high performance tape technologies streaming to sequential media can in
many cases out-pace disk throughput.  It is in mounting and tape
positioning that tape is a poor performer relative to disk, where one
can wait a minute or more before I/O can proceed.  That's were VTL
shines.

Richard Sims

Overflow location

[Sandra]

Dear All,
today i ran into something on :
TSM 5.2.3 on Windows 2000 server.

I have 3582 Library and my sequential storage poool is setup with 9 volumes for
collocation. No as per the policies of various servers' data retention, these
are not enough for this amount of data and my backups fail since none of the
volumes have enough space to carry more data.

I increased the number of scratchs in that pool. but I don't want to run into
same situation when i have to keep volumes in the library for DRM.

Can I checkout volumes that are full and then run audit library or what?

How can I cope with this situation?

Kindly enlighten me !

Kind Regards,
Sandra

Re: ANR0781E

[Thomas Denier]

> Well, the HELP for ANR0781E indicates this:
>
> > ANR0781E Export/import command: Process aborted - server sign on failed.
>
> > Explanation: The server export/import process encounters an internal
> error
> > in establishing an intermemory communications session with other server
> > components.
>
> > System Action: The export or import process ends and server operation
> > continues.
>
> > User Response: Contact your service representative.
>
> This certainly suggests a cause of failure (can't establish connectivity,
> in so many words)... is there some other specific information you would
> like to see in the message text or explanatory information? One immediate
> improvement comes to mind: the "User Response" section could suggest
> checking the connection between servers.

The best one can say for the message text is that it fails to distinguish
between two classes of underlying problem:
1.Failure to establish a TCP/IP connection
2.Failure in the authentication process

I would go further and say that the message text is misleading, in that
'server sign on' seems to refer to the authentication process. That seems
to be the way IBM support understood the message text, since their first
suggestion was to reset the password.

The explanation is even worse. It implies that the underlying problem
has to do with an intermemory connection between two components of the
z/OS server, not with any kind of communications between two servers.

> As to the hung sessions: I would agree that those should not occur. If I
> remember correctly, you've already got a PMR open for this... support
> should continue to work with you to address that issue.

It is not clear to me that support shares your view that they should
continue working with me; I reported the IP connectivity problem to them
almost two business days ago and have yet to get any response.

tsm client for netware and netware file compression

[Steve Bennett]

We are considering use of client side compression on some of our netware
tsm 5.2 clients.
Netware is set to compress files that haven't been used in 7 days. I
found some doc that said even with "compress yes" the tsm client will
not compress netware compressed files before sending. But what about
when the file goes from netware uncompressed to compressed?
For instance, I create file A on the netware box today and during the
nightly backup it gets processed. Then the file isn't touched for 7 days
so netware compresses it. Does the tsm client then backup the file again
because it changed?
One TSM server is v5.1.8 and another is v5.2.3.2 both runing on win2000
boxes.
--
Steve Bennett, (907) 465-5783
State of Alaska, Enterprise Technology Services, Technical Services Section

Re: tsm client for netware and netware file compression

[Stapleton, Mark]

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of Steve Bennett
>We are considering use of client side compression on some of 
>our netware tsm 5.2 clients.
>
>Netware is set to compress files that haven't been used in 7 
>days. I found some doc that said even with "compress yes" the 
>tsm client will not compress netware compressed files before 
>sending. But what about when the file goes from netware 
>uncompressed to compressed?
>
>For instance, I create file A on the netware box today and 
>during the nightly backup it gets processed. Then the file 
>isn't touched for 7 days so netware compresses it. Does the 
>tsm client then backup the file again because it changed?

I'm confused about something. If memory serves, NetWare compression
doesn't actually compress individual files; my understanding is that it
compresses the entire volume structure. (This was the reason that you
couldn't restore compressed NetWare files to an uncompressed volume, and
vice versa.)

Or are you running a utility that compresses a single file at a time?

(Why do you want to run client compression in the first place?
Constricted network bandwidth?)

--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627  

Re: tsm client for netware and netware file compression

[Rushforth, Tim]

There used to be an option for Netware called:

NWIGNORECOMpressbit

I have not worked with NetWare for a while but this option would do what it
sounds like it does - not re-backup the file when NetWare compresses it.

Tim Rushforth
City of Winnipeg
-Original Message-
From: Steve Bennett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 30, 2004 12:07 PM
To: [EMAIL PROTECTED]
Subject: tsm client for netware and netware file compression

We are considering use of client side compression on some of our netware
tsm 5.2 clients.

Netware is set to compress files that haven't been used in 7 days. I
found some doc that said even with "compress yes" the tsm client will
not compress netware compressed files before sending. But what about
when the file goes from netware uncompressed to compressed?

For instance, I create file A on the netware box today and during the
nightly backup it gets processed. Then the file isn't touched for 7 days
so netware compresses it. Does the tsm client then backup the file again
because it changed?

One TSM server is v5.1.8 and another is v5.2.3.2 both runing on win2000
boxes.

--

Steve Bennett, (907) 465-5783
State of Alaska, Enterprise Technology Services, Technical Services Section

Re: scheduled SQL log backup question

[Joe Crnjanski]

I think you cannot take log backup of master db; only full; that doesn't
matter, it is small database (but very important)

In your script put "tdpsqlc backup db1,db2,db3,db4 log ."

Db1,db2... are database names (don't include master)

Joe Crnjanski - Partner
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax: 416-235-0265
Web: www.infinitynetwork.com
 
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Luc Beaudoin
Sent: Tuesday, November 30, 2004 11:56 AM
To: [EMAIL PROTECTED]
Subject: scheduled SQL log backup question

Hi all

I'm doing SQL LOG backup every 6 hours and a full backup every day ...

I got a failed status everytime cause I can not take theLOG backup of
the
master DB ...

This is the command that I launch ...

%sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
/logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log

Is there a option that I can put .. like   backup ALL LOG except MASTER

thanks

Luc Beaudoin
Network Administrator/ SAN/TSM
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254

Re: scheduled SQL log backup question

[Luc Beaudoin]

Thanks Joe .

I thought of that one but I was hopping for a nice exetp option ...
cool .. I will do that way...

thanks again

Luc





Joe Crnjanski <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
2004-11-30 01:35 PM
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
cc:
Subject:Re: scheduled SQL log backup question


I think you cannot take log backup of master db; only full; that doesn't
matter, it is small database (but very important)

In your script put "tdpsqlc backup db1,db2,db3,db4 log ."

Db1,db2... are database names (don't include master)

Joe Crnjanski - Partner
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax: 416-235-0265
Web: www.infinitynetwork.com

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Luc Beaudoin
Sent: Tuesday, November 30, 2004 11:56 AM
To: [EMAIL PROTECTED]
Subject: scheduled SQL log backup question

Hi all

I'm doing SQL LOG backup every 6 hours and a full backup every day ...

I got a failed status everytime cause I can not take theLOG backup of
the
master DB ...

This is the command that I launch ...

%sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
/logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log

Is there a option that I can put .. like   backup ALL LOG except MASTER

thanks

Luc Beaudoin
Network Administrator/ SAN/TSM
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254

Re: tsm client for netware and netware file compression

[Steve Bennett]

Mark,
First, let me say I don't do netware. My netware admins indicate that
compression happens at the file level but then maybe we're both confused.
We are going to client compression because of a few clients with network
restrictions but more because we are replacing most of our primary tape
storage with a large local sata. Client cpu is cheaper than a bigger
sata. There won't be much (if any) data in the onsite tapepool which
gets compressed by the drives.
Stapleton, Mark wrote:
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of Steve Bennett
We are considering use of client side compression on some of
our netware tsm 5.2 clients.
Netware is set to compress files that haven't been used in 7
days. I found some doc that said even with "compress yes" the
tsm client will not compress netware compressed files before
sending. But what about when the file goes from netware
uncompressed to compressed?
For instance, I create file A on the netware box today and
during the nightly backup it gets processed. Then the file
isn't touched for 7 days so netware compresses it. Does the
tsm client then backup the file again because it changed?

I'm confused about something. If memory serves, NetWare compression
doesn't actually compress individual files; my understanding is that it
compresses the entire volume structure. (This was the reason that you
couldn't restore compressed NetWare files to an uncompressed volume, and
vice versa.)
Or are you running a utility that compresses a single file at a time?
(Why do you want to run client compression in the first place?
Constricted network bandwidth?)
--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627
--
Steve Bennett, (907) 465-5783
State of Alaska, Enterprise Technology Services, Technical Services Section

Re: scheduled SQL log backup question

[Del Hoobler]

Luc,

This is a known requirement that has been submitted and being
prioritized for a future release, i.e. allowing you to
"exclude" certain databases from a command.

Thanks,

Del


"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/30/2004
01:47:30 PM:

> Thanks Joe .
>
> I thought of that one but I was hopping for a nice exetp option ...
> cool .. I will do that way...
>
> thanks again
>
> Luc
>
>
>
>
>
> Joe Crnjanski <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> 2004-11-30 01:35 PM
> Please respond to "ADSM: Dist Stor Manager"
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject:Re: scheduled SQL log backup question
>
>
> I think you cannot take log backup of master db; only full; that doesn't
> matter, it is small database (but very important)
>
> In your script put "tdpsqlc backup db1,db2,db3,db4 log ."
>
> Db1,db2... are database names (don't include master)
>
> Joe Crnjanski - Partner
> Infinity Network Solutions Inc.
> Phone: 416-235-0931 x26
> Fax: 416-235-0265
> Web: www.infinitynetwork.com
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
> Luc Beaudoin
> Sent: Tuesday, November 30, 2004 11:56 AM
> To: [EMAIL PROTECTED]
> Subject: scheduled SQL log backup question
>
> Hi all
>
> I'm doing SQL LOG backup every 6 hours and a full backup every day ...
>
> I got a failed status everytime cause I can not take theLOG backup of
> the
> master DB ...
>
> This is the command that I launch ...
>
> %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
> /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log
>
> Is there a option that I can put .. like   backup ALL LOG except MASTER
>
> thanks
>
> Luc Beaudoin
> Network Administrator/ SAN/TSM
> Hopital General Juif S.M.B.D.
> Tel: (514) 340-8222 ext:8254

Re: tsm client for netware and netware file compression

[Andrew Raibeck]

Check out the NWIGNORECOMPRESSBIT option.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

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

"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/30/2004
11:49:46:

> Mark,
>
> First, let me say I don't do netware. My netware admins indicate that
> compression happens at the file level but then maybe we're both
confused.
>
> We are going to client compression because of a few clients with network
> restrictions but more because we are replacing most of our primary tape
> storage with a large local sata. Client cpu is cheaper than a bigger
> sata. There won't be much (if any) data in the onsite tapepool which
> gets compressed by the drives.
>
> Stapleton, Mark wrote:
>
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
> > Behalf Of Steve Bennett
> >
> >>We are considering use of client side compression on some of
> >>our netware tsm 5.2 clients.
> >>
> >>Netware is set to compress files that haven't been used in 7
> >>days. I found some doc that said even with "compress yes" the
> >>tsm client will not compress netware compressed files before
> >>sending. But what about when the file goes from netware
> >>uncompressed to compressed?
> >>
> >>For instance, I create file A on the netware box today and
> >>during the nightly backup it gets processed. Then the file
> >>isn't touched for 7 days so netware compresses it. Does the
> >>tsm client then backup the file again because it changed?
> >
> >
> > I'm confused about something. If memory serves, NetWare compression
> > doesn't actually compress individual files; my understanding is that
it
> > compresses the entire volume structure. (This was the reason that you
> > couldn't restore compressed NetWare files to an uncompressed volume,
and
> > vice versa.)
> >
> > Or are you running a utility that compresses a single file at a time?
> >
> > (Why do you want to run client compression in the first place?
> > Constricted network bandwidth?)
> >
> > --
> > Mark Stapleton ([EMAIL PROTECTED])
> > Berbee Information Networks
> > Office 262.521.5627
> >
>
> --
>
> Steve Bennett, (907) 465-5783
> State of Alaska, Enterprise Technology Services, Technical Services
Section

Read Only Script

[Meadows, Andrew]

I am attempting to create a script with little success for taking our
LTO tapes that are in read only status and moving the data to other
tapes in the same storage pool, then sending an e mail to a human for
the tape to be removed from the library. Does anyone currently have a
script that does this? An internet search has proved unfruitful and
multiple attempts on my part have proved so as well.
I have TSM Server version 5.2.1.1 and the OS is AIX 5.1.
Thanks,
Andrew

This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.

Re: scheduled SQL log backup question

[Steve Schaub]

Del/Luc,

I just finished setting up our TDP environment and hit this as well -
the easiest way out is to code a client option set for your TDP-SQL
nodes that excludes the log backups from master.  Mine looks like this:

compression   yes
inclexcl  "include '\...\*' STD_SQLDB"
inclexcl  "exclude '\...\master\...\log*'"

Your activity log results will then show excluded backups

Steve Schaub
Computer Storage Systems Engineer II
Haworth, Inc
616-393-1457 (desk)
616-886-8821 (cell)
[EMAIL PROTECTED] 
"Trials are inevitable.  We can curse them and grow bitter, or harvest
them and grow stronger"
   

-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 30, 2004 1:55 PM
To: [EMAIL PROTECTED]
Subject: Re: scheduled SQL log backup question


Luc,

This is a known requirement that has been submitted and being
prioritized for a future release, i.e. allowing you to "exclude" certain
databases from a command.

Thanks,

Del


"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/30/2004
01:47:30 PM:

> Thanks Joe .
>
> I thought of that one but I was hopping for a nice exetp option ... 
> cool .. I will do that way...
>
> thanks again
>
> Luc
>
>
>
>
>
> Joe Crnjanski <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-11-30 
> 01:35 PM Please respond to "ADSM: Dist Stor Manager"
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject:Re: scheduled SQL log backup question
>
>
> I think you cannot take log backup of master db; only full; that 
> doesn't matter, it is small database (but very important)
>
> In your script put "tdpsqlc backup db1,db2,db3,db4 log ."
>
> Db1,db2... are database names (don't include master)
>
> Joe Crnjanski - Partner
> Infinity Network Solutions Inc.
> Phone: 416-235-0931 x26
> Fax: 416-235-0265
> Web: www.infinitynetwork.com
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf 
> Of Luc Beaudoin
> Sent: Tuesday, November 30, 2004 11:56 AM
> To: [EMAIL PROTECTED]
> Subject: scheduled SQL log backup question
>
> Hi all
>
> I'm doing SQL LOG backup every 6 hours and a full backup every day ...
>
> I got a failed status everytime cause I can not take theLOG backup of 
> the master DB ...
>
> This is the command that I launch ...
>
> %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt 
> /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log
>
> Is there a option that I can put .. like   backup ALL LOG except
MASTER
>
> thanks
>
> Luc Beaudoin
> Network Administrator/ SAN/TSM
> Hopital General Juif S.M.B.D.
> Tel: (514) 340-8222 ext:8254

Re: Read Only Script

[Lawrence Clark]

I don't know ...copies take a long time
If you have a copy pool you can do a select to generate  a list and then:
- check them out
-mark them destroyed
- execute a restore stgpool, assuming your copypool volumes are in a library

But below is an outline for what you want to do

a script that assembles something like:
dsmcmd:
dsmadmc -id=admin -pa=password -displaymode=table $1

*-
1). Generate a list of volumes
 dsmcmd "select volume_name from volumes where stgpool_name='STGPOOLNAME' AND 
access='READONLY'" > SQLTEST}
grep "^[000] " SQLTEST > VOLLIST

OFFSITEVOLS < VOLLIST

2) Use list generated to do copies as in the example below to check them out

3). CHeck them out
{
OFFSITEVOLS ()
while read volname; do
echo "found a vol to checkout: " $volname
/home/root/dsmcmd "CHECKO LIBV  $volume "
/home/root/dsmcmd "UPDATE VOL $volume ACC=offsite"
done
}

4) Send email of list copied and checked out.


>>> [EMAIL PROTECTED] 11/30/2004 3:10:12 PM >>>
I am attempting to create a script with little success for taking our
LTO tapes that are in read only status and moving the data to other
tapes in the same storage pool, then sending an e mail to a human for
the tape to be removed from the library. Does anyone currently have a
script that does this? An internet search has proved unfruitful and
multiple attempts on my part have proved so as well.
I have TSM Server version 5.2.1.1 and the OS is AIX 5.1.
Thanks,
Andrew

This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.

Re: scheduled SQL log backup question

[Joe Crnjanski]

After I sent my last post I remembered this (from dsm.smp)


*==*
* The following include statements assign all meta objects to  *
* management class SqlDbMetaMgmtClass and all data objects to  *
* SqlDbDataMgmtClass   *

*==*

*INCLUDE "\...\meta\...\*" SqlDbMetaMgmtClass
*INCLUDE "\...\data\...\*" SqlDbDataMgmtClass

*==*
* The following include statements assign all log meta objects to  *
* management class SqlLogMetaMgmtClass and all log data objects to *
* SqlLogDataMgmtClass  *

*==*

*INCLUDE "\...\meta\...\log*"  SqlLogMetaMgmtClass
*INCLUDE "\...\data\...\log*"  SqlLogDataMgmtClass

*==*
* The following exclude statements exclude all log backups for *
* databases master and msdb*
*==*

*EXCLUDE "\...\master\...\log*"
*EXCLUDE "\...\msdb\...\log*"




Del, 
can you comment this. You said that we cannot exclude databases in this
release. I never used it, but I think this is what Luc is looking for;
to exclude log backup of master db.



Joe Crnjanski - Partner
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax: 416-235-0265
Web: www.infinitynetwork.com
 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Del Hoobler
Sent: Tuesday, November 30, 2004 1:55 PM
To: [EMAIL PROTECTED]
Subject: Re: scheduled SQL log backup question

Luc,

This is a known requirement that has been submitted and being
prioritized for a future release, i.e. allowing you to
"exclude" certain databases from a command.

Thanks,

Del


"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/30/2004
01:47:30 PM:

> Thanks Joe .
>
> I thought of that one but I was hopping for a nice exetp option ...
> cool .. I will do that way...
>
> thanks again
>
> Luc
>
>
>
>
>
> Joe Crnjanski <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> 2004-11-30 01:35 PM
> Please respond to "ADSM: Dist Stor Manager"
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject:Re: scheduled SQL log backup question
>
>
> I think you cannot take log backup of master db; only full; that
doesn't
> matter, it is small database (but very important)
>
> In your script put "tdpsqlc backup db1,db2,db3,db4 log ."
>
> Db1,db2... are database names (don't include master)
>
> Joe Crnjanski - Partner
> Infinity Network Solutions Inc.
> Phone: 416-235-0931 x26
> Fax: 416-235-0265
> Web: www.infinitynetwork.com
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of
> Luc Beaudoin
> Sent: Tuesday, November 30, 2004 11:56 AM
> To: [EMAIL PROTECTED]
> Subject: scheduled SQL log backup question
>
> Hi all
>
> I'm doing SQL LOG backup every 6 hours and a full backup every day ...
>
> I got a failed status everytime cause I can not take theLOG backup of
> the
> master DB ...
>
> This is the command that I launch ...
>
> %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
> /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log
>
> Is there a option that I can put .. like   backup ALL LOG except
MASTER
>
> thanks
>
> Luc Beaudoin
> Network Administrator/ SAN/TSM
> Hopital General Juif S.M.B.D.
> Tel: (514) 340-8222 ext:8254

Re: scheduled SQL log backup question

[Del Hoobler]

Luc, Steve, Joe,

Yes, this will work, and it will show up as an "excluded" database
in the statistics at the end. There is a similar requirement for
from some customers to remove a database from being "examined" at all.
Data Protection will examine (get status and other details) all databases,
even the ones that are EXCLUDEd in the DSM.OPT file. For example, if there

is a database known to be "down or in standbye" state, it will show up as
an error,
even if it EXCLUDEd. The similar requirement is to allow a way to bypass
even those databases.

The EXCLUDE statements will work for this particular case.
I am sorry if I misinterpreted the question.

Thanks for clearing this up Joe and Steve.

Del



"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/30/2004
03:50:44 PM:

> After I sent my last post I remembered this (from dsm.smp)
>
>
> *==*
> * The following include statements assign all meta objects to  *
> * management class SqlDbMetaMgmtClass and all data objects to  *
> * SqlDbDataMgmtClass   *
>
> *==*
>
> *INCLUDE "\...\meta\...\*" SqlDbMetaMgmtClass
> *INCLUDE "\...\data\...\*" SqlDbDataMgmtClass
>
> *==*
> * The following include statements assign all log meta objects to  *
> * management class SqlLogMetaMgmtClass and all log data objects to *
> * SqlLogDataMgmtClass  *
>
> *==*
>
> *INCLUDE "\...\meta\...\log*"  SqlLogMetaMgmtClass
> *INCLUDE "\...\data\...\log*"  SqlLogDataMgmtClass
>
> *==*
> * The following exclude statements exclude all log backups for *
> * databases master and msdb*
> *==*
>
> *EXCLUDE "\...\master\...\log*"
> *EXCLUDE "\...\msdb\...\log*"
>
>
>
>
> Del,
> can you comment this. You said that we cannot exclude databases in this
> release. I never used it, but I think this is what Luc is looking for;
> to exclude log backup of master db.
>
>
>
> Joe Crnjanski - Partner
> Infinity Network Solutions Inc.
> Phone: 416-235-0931 x26
> Fax: 416-235-0265
> Web: www.infinitynetwork.com
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
> Del Hoobler
> Sent: Tuesday, November 30, 2004 1:55 PM
> To: [EMAIL PROTECTED]
> Subject: Re: scheduled SQL log backup question
>
> Luc,
>
> This is a known requirement that has been submitted and being
> prioritized for a future release, i.e. allowing you to
> "exclude" certain databases from a command.
>
> Thanks,
>
> Del
>
> 
> "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 11/30/2004
> 01:47:30 PM:
>
> > Thanks Joe .
> >
> > I thought of that one but I was hopping for a nice exetp option ...
> > cool .. I will do that way...
> >
> > thanks again
> >
> > Luc
> >
> >
> >
> >
> >
> > Joe Crnjanski <[EMAIL PROTECTED]>
> > Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> > 2004-11-30 01:35 PM
> > Please respond to "ADSM: Dist Stor Manager"
> >
> >
> > To: [EMAIL PROTECTED]
> > cc:
> > Subject:Re: scheduled SQL log backup question
> >
> >
> > I think you cannot take log backup of master db; only full; that
> doesn't
> > matter, it is small database (but very important)
> >
> > In your script put "tdpsqlc backup db1,db2,db3,db4 log ."
> >
> > Db1,db2... are database names (don't include master)
> >
> > Joe Crnjanski - Partner
> > Infinity Network Solutions Inc.
> > Phone: 416-235-0931 x26
> > Fax: 416-235-0265
> > Web: www.infinitynetwork.com
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
> Of
> > Luc Beaudoin
> > Sent: Tuesday, November 30, 2004 11:56 AM
> > To: [EMAIL PROTECTED]
> > Subject: scheduled SQL log backup question
> >
> > Hi all
> >
> > I'm doing SQL LOG backup every 6 hours and a full backup every day ...
> >
> > I got a failed status everytime cause I can not take theLOG backup of
> > the
> > master DB ...
> >
> > This is the command that I launch ...
> >
> > %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
> > /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log
> >
> > Is there a option that I can put .. like   backup ALL LOG except
> MASTER
> >
> > thanks
> >
> > Luc Beaudoin
> > Network Administrator/ SAN/TSM
> > Hopital General Juif S.M.B.D.
> > Tel: (514) 340-8222 ext:8254

Re: Overflow location

[Steve Harris]

Sandra,

There is a section in the Admin Guide on dealing with a full library.

Regards

Steve.

>>> [EMAIL PROTECTED] 01/12/2004 3:27:52 >>>
Dear All,
today i ran into something on :
TSM 5.2.3 on Windows 2000 server.

I have 3582 Library and my sequential storage poool is setup with 9 volumes for
collocation. No as per the policies of various servers' data retention, these
are not enough for this amount of data and my backups fail since none of the
volumes have enough space to carry more data.

I increased the number of scratchs in that pool. but I don't want to run into
same situation when i have to keep volumes in the library for DRM.

Can I checkout volumes that are full and then run audit library or what?

How can I cope with this situation?

Kindly enlighten me !

Kind Regards,
Sandra



***
This email, including any attachments sent with it, is confidential and for the 
sole use of the intended recipient(s).  This confidentiality is not waived or 
lost, if you receive it and you are not the intended recipient(s), or if it is 
transmitted/received in error.

Any unauthorised use, alteration, disclosure, distribution or review of this 
email is prohibited.  It may be subject to a statutory duty of confidentiality 
if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this email in 
error, you are asked to immediately notify the sender by telephone or by return 
email.  You should also delete this email and destroy any hard copies produced.
***

Adding TSM instances to MS Cluster environment

[Graham Trigge]

Fellow TSMers,

I am setting up TSM 5.2.3 on a two node, W2K active/active cluster (no
shared libraries as all  backups are running to disk only). I have
successfully created my first virtual server on both cluster nodes with no
problems. I have successfully created the first half of the second virtual
server with no problems. Creating the second half of the second virtual
server is giving me grief.

On the second cluster node I have run the Initial Configuration wizard to
configure the new virtual server. The server initializes correctly then
runs the Cluster Configuration Wizard. A screen is displayed asking "Do
you want to configure TSM to manage tape failover for this group?" - the
instructions tell me that there is nothing I can do here as the answer is
retrieved from the first virtual server created. Clicking next give me the
following error message:

"The selected autochanger is not on a valid shared SCSI bus with
the selected node".

Looking at the greyed out options the checkbox for "Configure TSM to
manage tape failover" is selected and I can't change it.

Any assistance would be appreciated.

Regards,

--
Graham Trigge
IT Technical Specialist
Server Support
Telstra Australia

Office:  (02) 9201 9577
Mobile: 0409 654 434

"Time flies like an arrow, but fruit flies like a banana"