- All physical media (tapes/disk drives/CDs/etc) are tagged, tracked and
audited every quarter
- No physical media (tapes/disk drives/CDs/etc) leaves the site
- Malfunctioning media is marked for destruction collected in a safe
- When enough media marked for destruction has been collected, a
This is the script I use:
ASSUMPTIONS: RMAN is backing-up using the node name ORACLE-NODE-BU
select NODE_NAME,cast(BACKUP_DATE as date) as
BACKUP_DATE,STATE,cast(DEACTIVATE_DATE as date) as DEACTIVATE_DATE,
HL_NAME,LL_NAME from BACKUPS where NODE_NAME='ORACLE-NODE-BU' order by
BACKUP_DATE
Quite a project. Sepaton has customers that store Petabytes of data on
their VTLs. Sepaton claims performance of:
* 9600 MB/sec per VTL
* 1.2 Petabytes per VTL (without compression)
* RAID 6 protection
Obviously you need more information on the requirements. Good luck!
Thanks,
Milton
Here is my response to an earlier question on sizing a VTL. I have been
using a 10GB tape volume size for a couple of years and have not seen a
reason to change. I originally chose 10GB because ISM recommended that
size when using sequential file devices.
Yes that is an approach that will work.
Try:
select NODE_NAME,cast(BACKUP_DATE as date) as
BACKUP_DATE,STATE,cast(DEACTIVATE_DATE as date) as
DEACTIVATE_DATE,HL_NAME,LL_NAME from BACKUPS where
NODE_NAME='YOUR_TDP_NODE_NAME' order by BACKUP_DATE
Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL
Yes that is an approach that will work. I used:
(Total_Bytes_in_Primary_STG + ((Max_Daily_Amt_Backed-up X (ReuseDelay +
2))) X Growth_factor
I then let the compression factor be my fudge factor.
However give some thought to the size (native capacity) of your virtual
tape volumes. In the
, Matthias Hartmann, Thomas Fell, Michael Diemer
Sitz der Gesellschaft: Stuttgart
Registergericht: Amtsgericht Stuttgart, HRB 14562 WEEE-Reg.-Nr. DE 99369940
Johnson, Milton [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager
ADSM-L@VM.MARIST.EDU
15.06.2007 21:08
Please respond to
ADSM: Dist Stor
You usually do not use RMAN to create a backup file locally on the
client and then back up that file to TSM. Instead, via the TDPO api,
RMAN:
1) connects to the TSM server
2) generates a file name
3) checks to see if that file name is currently in use
4) sends a stream of data to the TSM server
If you are in a pure TSM environment, meaning the VTL is exclusively
used by TSM, how useful is truncating scratch tapes and returning that
space to the VTL's pool of free space? Unless you use co-location all
volumes are going to be quickly written to their define maximum native
capacity. The
?
On Wed, 13 Jun 2007 08:43:43 -0400, Johnson, Milton
[EMAIL PROTECTED] said:
The VTL is a Sepaton S2100-ES and yes it is disk only.
I don't see the benefit that a tape backed system would bring, how
does that really differ from a physical tape ATL with TSM providing a
DISKPOOL front end
[mailto:[EMAIL PROTECTED] On Behalf Of
Allen S. Rout
Sent: Tuesday, June 12, 2007 3:41 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Fw: How to Incorporate a CDL into TSM environment?
On Tue, 12 Jun 2007 12:16:27 -0400, Johnson, Milton
[EMAIL PROTECTED] said:
Why a VTL? With us we found
As I see it, there are two areas where you get performance hits when
restoring from non-collocated volumes:
1) Tapes Mounts: In my experience my VTL makes this problem
insignificant.
2) Spinning Sequential Media: Yes, VTL volumes are sequential and if
you define your tapes as 50GB native and
VTL and over subscription as I understand it.
Definition: When (tape volume size) X (number of defined volumes)
native capacity of VTL you have over subscribed. If you try to fill-up
all your defined volumes to their defined native capacity you will fail
as you will run out of space on your
Yes a virtual tape volume can be accessed only by one client at a time
and if two processes/clients try to access the same volume at the same
time one process/client must wait. Again smaller volume sizes decreases
the chance that a contention would happen and also decrease the
contention
Due to the lack of recent religious wars on this forum, I'm forced to
ask:
What is the best method to back-up and perform a reliable and successful
Bare Metal Restore of a WinTel platform (Windows NT/Server
2000/2003/XP/etc.) using a TSM AIX server? Methods requiring a third
party solution are
1. Sepaton
2. Yes
3. No
4. No
5. No
It's just a fast library. Eliminates the need for collocation.
Thanks,
Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gill, Geoffrey L.
Sent: Thursday, March 29, 2007 4:06 PM
To:
that this e-mail and
attachments are free from any viruses, the recipient should at its sole
discretion take the necessary measures to ensure that the received
messages are actually virus free
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of Johnson
I frequently find the culprit to be Oracle backups made via TDP/RMAN
(but it could be any backup made via TDP). Something happens and they
stop deleting old backups. I look at likely candidates using:
set sqldisplaymode wide
select NODE_NAME,cast(BACKUP_DATE as date) as
We have been using Sepaton for almost two years with no regrets.
Sepaton has excellent in-house knowledge of TSM, and configuring both
the VTL and TSM to use the VTL are very straight forward and simple.
Their support has been top-notch and never disappointed me, or my
management. The products
On-site tapes: Virtual Tape Library (Sepaton S2100-ES2)
Off-site tapes: IBM 3494 with 2 3590E1A drives
H. Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Allen S. Rout
Sent: Wednesday, August 02, 2006 9:37 PM
To:
This is normal behavior when reclaiming a storage pool that has a NEXT
STGPOOL defined. I became aware to it when I upgraded to 5.3, I also
have a VTL. However, being a VTL has nothing to do with it, it's having
a NEXT STGPOOL defined that elicits this behavior. If you use the
reclaim stg
Chip,
We have had a Sepaton S2100-ES2 for ~1 1/2 years and can report it has
given very little trouble. Think of it as a library on steroids being
very fast especially with tape mounts, dismounts and positioning. Our
environment is:
AIX 5300-04-00
Storage Management Server for AIX-RS/6000 -
This is an issue with turn-key systems. If you buy an application
from a vendor and plan to hold them responsible for the application's
uptime/availability and data restoration, it is reasonable that the
vendor can dictate the hardware/os used, the ability to run other
software on the system and
I decided on a VTL because I wanted to have LAN-free backup ability and
compression with no load on the TSM clients or TSM server. We have been
using Sepaton's ES2100 VTL for over a year with no problems (HP rebrands
Sepaton's product).
There have been numerous threads in this list about VTL
We use a Sepaton S2100-ES2 without problems. Vicki's advice is sound:
make sure the vendor's product is TSM certified; make the vendor supply
an evaluation system and test thoroughly.
A VTL should faithfully emulate a particular physical ATL and particular
physical drives. It should not
It's been my experience that the problem is not the large number of
tapes a restore takes when not collocating, rather it's the large
mount, unmount seek and rewind times associated with each tape mount
that is the problem. If you have sub-second mount, unmount, seek and
rewind times then there
I have 12TB of SATA storage in the form of a Virtual Tape Library (VTL)
appliance, in my case a SEPATON S2100-ES2. To TSM it's just a tape
library on steroids (rapid mounts, dismounts, etc). I have routinely
pushed in excess of 80 MB/sec. with no problems. It's scalable to 1PB
storage capacity
You could:
1) Create 2 offsite copypools (say OFF1 and OFF2)
2) Day 1 - for each volume in OFF1
do
move data volume stg=oFF2 reconstruct=yes
done
backup stg primarypool OFF2
Bring back all OFF1 volume that are offsite
3) Day 2 - for
My interpretation of electronic vaulting is that the tapes are
transferred via wire to the storage vault. If you are doing a backup
stg primary_pool copy_pool to a copypool 15 KM away, I would think that
you are doing electronic vaulting. The key is you are not doing a
physical transportation of
We were in a similar situation with a 3494 and two 3590E drives. We
went with a VTL for the primary stgpools using the 3494 just for offsite
copypools and have been very happy with it. Most everything goes
straight to the VTL and during the night I do repeated backups of the
primary stgpools in
Are you talking about a 1TB VOLUME, or several smaller volumes (say
10GB) on a 1TB array?
H. Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Prather, Wanda
Sent: Tuesday, June 07, 2005 9:07 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re:
My concerns with TSM based encryption are:
1) Since encrypted data does not compress well the TSM clients must do
both the compression and encryption.
2) TSM compression and encryption can be a performance hit on the client
increasing back-up time and further degrading performance during the
A 2 GB limit seems a bit restrictive, I wonder if that is a file system
limit on the VTL. My VTL has no such restriction. When I installed my
VTL I did not notice any change in TSM DB size due to an increase in the
number of volumes. The amt of data per volume seems minimal.
H. Milton
@VM.MARIST.EDU
Subject: Re: Tape Encryption Appliances
I have never heard of this applicance; but my first question would be,
whatcha gonna do when you have to take your tapes to a DR site?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Johnson, Milton
] On Behalf Of
Johnson, Milton
Sent: Thursday, May 05, 2005 8:19 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Tape Encryption Appliances
Has anyone had any experience with tape compression/encryption
appliances such as the NeoScale CryptoStor Tape 700
(http://www.neoscale.com/English/Products/CryptoStor.html
As usual Richard is correct
Syntax
-Query ARchive--+--+--+- filespec---+
'- options-' '- filespec-'
Parameters
filespec
Specifies the path and file name that you want to query. Use
wildcard
characters to specify a group of files or all the
Has anyone had any experience with tape compression/encryption
appliances such as the NeoScale CryptoStor Tape 700
(http://www.neoscale.com/English/Products/CryptoStor.html)? It is an
appliance that sits between the TSM Server and the Tape Drives and
transparently provide compression and
A few questions regarding using Iron Mountain (IM):
1) Is anyone using TSM and IM's SecureSync application?
1A) If so how do you integrate TSM with SecureSync?
2) Since TSM sends tapes to the vault and requests return of vaulted
tapes in a random sequence, does anyone allow their Vault Vendor
1) Sepaton states that their VTL is TSM Certified
2) When we initially installed our S2100-ES we did have a Fiber adapter
communication/compatibility problem. Sepaton's response was:
A) To quickly acknowledge the problem.
B) As an interim solution Sepaton sent us a S2100-DS that did not have
the
I use a Combination of the Two as Janis would say. I tend to create
TSM scripts to perform specific functions, then make calls to this
library of functions from outside scripts. For instance I have a TSM
script called bu_disk_stg_to_copypool that backs-up all primary stg
pools of type disk to my
I am not familiar with their product, but I have been using Sepaton's
Virtual Tape Library (VTL) for several months with no problems. The
Centricstor appears to a similar product but I am at a loss as to why it
would need third party software for syncronizing scratch tapes, what
ever that is. A
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:
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
Are you stating that you would be duplicating the tapes in a manner
completely unknown to TSM? If so a couple of potential issues are:
1) If one of your primary pool tapes becomes unreadable, you would be
unable to have TSM do a RESTORE VOLUME.
2) When TSM reclaims one of your primary pool
From help q stg:
Pct Util
An estimate of the utilization of the storage pool, as a
percentage.
For sequential access devices, this is expressed as a percentage of
the
number of active bytes on each sequential access volume and the
estimated capacity of all volumes in the
Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Mark D. Rodriguez
Sent: Tuesday, September 28, 2004 10:43 PM
To: [EMAIL PROTECTED]
Subject: Re: direct attached disk (DAS) at a tape library?
Johnson, Milton wrote:
I am not quite sure what you meant by with TSM you
shared file pools. I haven't
looked at the price. Have you?
Bill Smoldt
STORServer, Inc.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Johnson, Milton
Sent: Wednesday, September 29, 2004 6:48 AM
To: [EMAIL PROTECTED]
Subject: Re: direct attached
. Have you?
Bill Smoldt
STORServer, Inc.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of Johnson, Milton
Sent: Wednesday, September 29, 2004 6:48 AM
To: [EMAIL PROTECTED]
Subject: Re: direct attached disk (DAS) at a tape library
.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of Johnson, Milton
Sent: Wednesday, September 29, 2004 6:48 AM
To: [EMAIL PROTECTED]
Subject: Re: direct attached disk (DAS) at a tape library?
A virtual tape library operates
. That was why I questioned how you
were going to do LANFREE without Sanergy.
That clears that up. Thanks.
Johnson, Milton wrote:
A virtual tape library operates and connects just like a physical tape
library in a SAN environment. The VTL, TSM server and your client are
connected to the SAN so a LANFREE
) at a tape library?
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Johnson, Milton
No idea about TSM's LANFREE being a limited use copy of Sanergy.
It is not.
My understanding was that the big difference was in the client code so
that the meta data goes over the LAN to the TSM
I am not quite sure what you meant by with TSM you can use disk only
for backups instead of onsite tape. I do not see any reason why you
can not use FILE device types for both primary and copypool stg pools.
Of course if you actually want to move a copy of the data offsite, then
you would need
Read the recent thread D2D on AIX
H. Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gilles
Sent: Friday, September 24, 2004 8:04 AM
To: [EMAIL PROTECTED]
Subject: Diskspool volumes size
Hi,
I have 5 TB of disk stgspool
IBM gave a webinar on DISK ONLY backups including the advantages of DISK
vs. FILE device classes. While your mileage may vary, in general it
seems that a FILE devclass will give better performance for large pools
(read TB not GB). Two quick examples:
1) With DISK TSM keeps track of each 4K block
: Re: Duel tape write to LTO's
Hi Milton,
When TSM writes simultaneously to the copypool would this be on the 2nd
Library for duel tape backup?
Johnson, Milton wrote:
You should be able to create a PRIMARY STGPOOL named TAPEPOOL and a
COPY STGPOOL named COPYPOOL with both of them having
Now we get into religion. IBM did offer a figure of ~5GB during the
webinar, but there are a lot of factors that would affect this such as:
REUSE DELAY: you want to be able to use those TSM DB backups
RECLAMATION THRESHOLD: A lower threshold should lead to more efficient
usage of volumes except
What do use for a reuse delay? How many pending volumes do you
average?
H. Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Rushforth, Tim
Sent: Tuesday, September 21, 2004 1:00 PM
To: [EMAIL PROTECTED]
Subject: Re: D2D on AIX
It depends upon how you configure things. For dynamic allocation of
volumes, then yes you are limited to the size of the file system that
you mount on that mount point. However if you define the stgpool
volumes explicitly using the DEFINE VOLUME command, you can place the
volumes across as many
RMT8 DRIVE RMT_LTO
Any other ideas comments are welcome!
Thanks
Johnson, Milton wrote:
It is the basic philosophy of TSM to have only one copy of a file in a
PRIMARY STORAGE POOL. With TSM 5.x you can simultaneously write to a
PRIMARY STORAGE POOL and COPY STORAGE POOL (see HELP
It is the basic philosophy of TSM to have only one copy of a file in a
PRIMARY STORAGE POOL. With TSM 5.x you can simultaneously write to a
PRIMARY STORAGE POOL and COPY STORAGE POOL (see HELP DEFINE STGPOOL).
H. Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager
An interesting paper on an obviously VERY large TSM system, involving
upwards to 40 TSM servers. Your problem was that you did not want to
send 40 tapes offsite everyday with each tape containing a single backup
of a TSM server DB. So your elegant solution was to create a TSM server
instance,
OK, I just have to jump in. If I understand Hoa he:
1) Backs up the TSM database to a disk file
2) backs up that disk file to a TSM disk storage pool using DSM
3) moves that db backup to onsite/offsite tapes using backup stg and
migration
If this is so, then what do you do when you have lost your
I also do my scheduling via cron and have the cron job call admin
scripts but of course you run into the problem of hard coding a password
somewhere. You could also try something like:
Last step in admin schedule: q stg
/tmp/flags/BACKUP_SCHEDULE_DONE.FLAG
Then have cron schedule your shell
Just to add another fly in the ointment, if you have an aggressive
reclamation threshold, say 25%, and a reuse delay of say 5 days, you may
end up with a lot more tapes in a pending state then you anticipated. A
pending tape is not a scratch tape.
H. Milton Johnson
-Original Message-
If clients are backing-up during the migration period, those files will
be migrated to the primary tape pool. Do you disable sessions during
the migration?
H. Milton Johnson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent:
You can create a script with the following select statements:
select stgpool_name,'1' as Days Pending,count(*) as Total from volumes
where status='PENDING' -
and cast((current_timestamp-PENDING_DATE)days as decimal)=1
group by stgpool_name
select stgpool_name,'2' as Days Pending,count(*)
Will this work for you?
tsm: TSMSRV1select volume_name,cast(last_write_date as date) as
Date,cast(LAST_WRITE_DATE as time)as TIME from volumes where
devclass_name='3590TAPE' and
cast((current_timestamp-LAST_WRITE_DATE)days as decimal)=1 and
status='FULL'
VOLUME_NAME DATE
with is why a VTL?
Between random-access DISK volumes and sequential-access FILE volumes
what does a VTL buy me that I couldn't implement using those two volume
types in TSM?
Thanks.
Tab Trepagnier
TSM Administrator
Laitram, L.L.C.
Johnson, Milton [EMAIL PROTECTED]
06/15/2004 03:13 PM
Clean Me requests are also generated when the drive encounters a
problem. A faulty/failing drive can cause an abnormal spike in
cleaning requests. I monitor these requests daily as an indicator of
drive health. I have found that an increase in Clean Me messages
correlates with an Attn Drive
Management is desiring to implement a highly available TSM system with
the
following requirements:
Campus consists of 3 buildings, presently with the lone TSM server in
Bldg. 3.
If Bldg. 3 goes down then all TSM activities are unavailable and
management
wants to eliminate that single point of
Dave,
If you make a slight change in order you should solve your problem:
1) backup clients to disk where possible, tape where not
2) backup diskpools to copypool
3) backup tapepools to copypool
4) backup DB to tape
*NOTE: At this point ALL of your data has been copied to your copypool
and
I got a call from a rep asking if I was interested in a Sepaton S2100
VTL (Virtual Tape Library) (www.sepaton.com). It's billed as:
* a fiber connected SATA RAID Virtual Tape Library Appliance
* 3-200 TB Capacity / 1.6 TB/hour throughput
* configure up to 200 virtual tape drives
* Emulates various
Zoltan,
According to RFC 1918, the following are private, non-routed subnets:
10.0.0.0 - 10.255.255.255
172.16.0.0 - 172.31.255.255
192.168.0.0 - 192.168.255.255
Being non-routed you cannot connect from 128.172.6.177 to 192.168.20.44
unless you have a connection to the same physical subnet
Zoltan,
Try this, from a command line on the client:
ping 192.168.20.44
Does the ping work? If the ping fails then you do not have a connection
to 192.168.20.44 and no amount of port opening, aliasing, etc. can get
your traffic to flow to and from 192.168.20.44.
H. Milton Johnson
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
===
Johnson
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
===
Johnson, Milton [IT] wrote
: Johnson, Milton [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 20:06
To: [EMAIL PROTECTED]
Subject: Question on Restoration from DBSNAPSHOT
All,
TSM: Storage Management Server for AIX-RS/6000 - Version 4, Release 2,
Level 1.7
OS: AIX 4.3.3 ML 9
Log Mode: RollForward
All,
TSM: Storage Management Server for AIX-RS/6000 - Version 4, Release 2,
Level 1.7
OS: AIX 4.3.3 ML 9
Log Mode: RollForward
(Upgrade project planned in near future, but that's another story)
Everyday I do a full backup of the database to 3590E tape, immediately
followed
You have stacked files onto one tape. To restore the XXXvg use:
# mt -f /dev/rmt0.1 fsf 1; restorevgfiles -f /dev/rmt0.1
To restore the YYYvg use:
# mt -f /dev/rmt0.1 fsf 2; restorevgfiles -f /dev/rmt0.1
Milton Johnson
Voice: 210-677-6728
Email: [EMAIL PROTECTED]
-Original Message-
Personally I would never consider a WinDoze solution. WinDoze does not have
a rich scripting environment like UNIX does. Using scripting I have been
able to:
* Increase the performance of my TSM server
* Improve reclamation efficiency
* Created a menu driven program to aid the day-to-day
Thanks, unfortunately the Reclamation Tips guide link is broken.
Milton Johnson
-Original Message-
From: Richard Sims [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 7:51 AM
To: [EMAIL PROTECTED]
Subject: Tivoli Field Guides
A lesser-known information source for registered
Marc,
Part of our routine to send tapes offsite includes BACKUP STGPOOL
DISKDIRPOOL COPYPOOL which send the DIRMC storage pool offsite.
Part of the restoration procedure includes RESTORE STGPOOL DISKDIRPOOL
Milton Johnson
Voice: 210-677-6728
Email: [EMAIL PROTECTED]
-Original
Bill,
I also have only 2 tape drives and was running in to the problem of tapes
going off sight and never coming back. I solved it by creating a
reclamation script that does the following (pseudo code):
for stgpool in TAPEPOOL COPYPOOL
do
while [count(stgpool tapes 51% reclaimable) -gt 0]
83 matches
Mail list logo