:[EMAIL PROTECTED] On Behalf Of Gill,
Geoffrey L.
Sent: den 5 juli 2007 21:43
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] unloaddb/loaddb (success)
Hi all,
I wanted to pass this along since there always seems to be a lot of
questions surrounding how and if it works. My system is AIX 5.3 ML05
initially needed to create the larger size and run
unloaddb/loaddb in order to be able to reduce it. Below are my stats run
on a P55A lpar, one CPU assigned, db and logs running on a DS4800 and
dumping to a 3590 Tape drive attached to a 3494. Interestingly enough I
read that this only works with a
5:44 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: unloaddb/loaddb
We recently did unloaddb / loaddb's to a couple of our TSM servers, to a
FILE-type devclass, with great success. Much easier than
messing with manual libraries, in my opinion.
If you can scrounge up 25 GB or so of disk space, that shou
Hello,
I did it with file on the disk, and it much more simple.
Hana
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gill, Geoffrey L.
Sent: Thursday, June 28, 2007 3:11 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] unloaddb/loaddb
I'm tryi
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: [ADSM-L] unloaddb/loaddb
06/28/2007 05:11
PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: unloaddb/loaddb
We recently did unloaddb / loaddb's to a couple of our TSM servers, to a
FILE-type devclass, with great success. Much easier than
messing with manual libraries, in my opinion.
If you can scrounge up 25 GB or so of disk space, that should be mo
VM.MARIST.EDU
Sent by: "ADSM:cc
Dist Stor
Manager" Subject
<[EMAIL PROTECTED] [ADSM-L] unloaddb/loaddb
.EDU>
06/27
cc
Dist Stor
Manager" Subject
<[EMAIL PROTECTED] [ADSM-L] unloaddb/loaddb
.EDU>
06/27/2007 08:10
PM
Please respond to
I'm trying to reduce the assigned capacity of the DB since it is only
18% utilized but it looks like I've hit a roadblock. I'm thinking I need
to run the uloaddb and loaddb to fix this but not totally sure. If so,
as I read it, it sounds like the library needs to be changed to manual
in order for t
I'd be interested in hearing how long these improvements in db processing time
last. From what I've read on this list it seems these kind of improvements can
be short lived, or am I wrong about that?
You're right, 10 hrs. seems like a long time for a reload.
William White wrote:
> Dear TSM'er
) 376-7774
-Original Message-
From: William White [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 4:39 AM
To: [EMAIL PROTECTED]
Subject: UNLOADDB/LOADDB Performance Note
Dear TSM'ers,
I recently saw several postings regarding TSM performance for UNLOADDB and
LOADDB.
Last weeke
Dear TSM'ers,
I recently saw several postings regarding TSM performance for UNLOADDB and
LOADDB.
Last weekend I did it and here are the results.
Environment: OS/390 V2.8; IBM 9672-RC4; STK 9840 tape
UNLOADDB:
Command: UNLOADDB DEVCLASS=RTAPE SCRATCH=YES CONSISTENT=YES
TSM server V4.1.2
System
> Technical Coordinator
> (419) 291-0049
>
> -Original Message-
> From: Andrew Carlson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 3:16 PM
> To: [EMAIL PROTECTED]
> Subject:Re: UnloadDB - LoadDB is it worth it?
>
> On out test
ssage-
From: Andrew Carlson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 3:16 PM
To: [EMAIL PROTECTED]
Subject: Re: UnloadDB - LoadDB is it worth it?
On out test box, it took 16 hours to unload, and 7 hours to load. I
started an unneeded audit, just to see how it would go
or the response. How long did the whole process take?
>
> Thomas S. Ritter
> Promedica Health System
> Technical Coordinator
> (419) 291-0049
>
> -Original Message-
> From: Andrew Carlson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 10:29 A
]
Subject:Re: UnloadDB - LoadDB is it worth it?
I have done it in test, but not production til next week. Out DB went
from 46GB to 26GB. I was able to do selects from the database that
would never finish on the prod system. I obviously have no idea of the
long term effects are.
Andy Carlson
27;-'
St. Louis, Missouri '---''(_/--' `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html
On Wed, 26 Jun 2002, Anderson, Michael - HMIS wrote:
> I have one more question about the unloaddb/loaddb procedure. When
> you do the
I have one more question about the unloaddb/loaddb procedure. When
you do the loadformat command do you count the
mirrored logs in the count. For example if I have 2 recovery log files
and copies of the 2 in another directory I would assume
that my loadformat command would have 4
I have done it in test, but not production til next week. Out DB went
from 46GB to 26GB. I was able to do selects from the database that
would never finish on the prod system. I obviously have no idea of the
long term effects are.
Andy Carlson|\ _,,,---
I was reading the TSM Admin guide where it recommends that you periodically
do a reorg of the database. We have had our TSM server running since 1998
and have never done a reorg. Our database is around 65G. We're running TSM
4.2.1.11 on OS/390.
Thomas S. Ritter
Promedica Health System
Technica
ssociation of Contract Employees (P.A.C.E. --
www.pacepros.com)
San Jose, Ca
(408) 257-3037
mailto:[EMAIL PROTECTED]
-Original Message-
From: Rajesh Oak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 10:23 AM
To: [EMAIL PROTECTED]
Subject: Problems after unloaddb/loaddb
Everyon
UP
Error Description:
After the UNLOADDB/LOADDB procedure the volume history is not
updated properly (see also APAR IC29502) and a new DB backup
starts with a backup series number of 1 already lower than older
DB backups before the UNLOADDB.
.
Q VOLH TYPE=DBB yields an output like:
Date/Time
Everyone,
I tried out the unloaddb/loaddb on one of my NT TSM Servers. The Server is up and
running but am facing a few problems:
1. I formatted space on my z drive for db and log(as I had before the unloaddb)
dsmserv loadformat 1 z:\tsmdata\server1\log1.dsm 2048 1 z:\tsmdata\server1\db1.dsm
manual.
Best regards,
Kirsten Gloer
-Original Message-
From: Andy Carlson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 6:10 PM
To: [EMAIL PROTECTED]
Subject: UNLOADDB/LOADDB Scenario
I have been kicking around the idea of doing and unload/load of the
database. Here is a
about some problems with loaddb with some TSM-Versions, so I
have to have a quick fallback-strategy.
Best regards
Chris
> -Ursprüngliche Nachricht-
> Von: Andy Carlson [SMTP:[EMAIL PROTECTED]]
> Gesendet am: Mittwoch, 20. März 2002 18:10
> An: [EMAIL PROTECTED]
> Bet
I have been kicking around the idea of doing and unload/load of the
database. Here is a scenario I came up with, to possibly cover my bases
if the load goes badly:
UNLOADDB to a disk file
LOADFORMAT one of my mirrored DB and mirrored LOG
LOADDB
AUDITDB (do I really have to do this?)
The advanta
TED]>
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject: UNLOADDB-LOADDB
Hi all,
I am trying to test an unload/load of my production-database to get
information on how long it takes and how big the reorganization-effort is.
I stopped the production database, copied the db-files, co
Hi all,
I am trying to test an unload/load of my production-database to get
information on how long it takes and how big the reorganization-effort is.
I stopped the production database, copied the db-files, copied the log-file,
and transfered it to my testserver.
On testserver (physically on the
For those that are interested, we just completed a unload/loadformat/load of our
TSM database.
Our system is a RS6K-F80 running AIX4.3.3 running TSM 4.2.1.8. The database is
60GB in size with a 97% utilization. Disk is on an ESS connected via FC.
We used an LTO drive to run the unload/load.
The
Well if you've been following along you know I have a new 3466-C01
I've made a test snap shot of my current TSM DB running there
and while I'm waiting to do it 'for real' on this coming w/e
I thought I'd 'kill' time doing a dry run of possible scenarios.
So I am now trying to do an UNLOADDB and
30 matches
Mail list logo
