Re: AW: Unload db/Loaddb
DUMPDB/LOADDB - is used when the database is corrupted, and audit db doesn't solve the problem. DUMPDB increases the size of the database. UNLOADDB/LOADDB - rearrange the structure of the database, this would in most cases result in better search performance and a smaller database. Odd-Magne - Original Message - From: Luscombe John (HS) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 13, 2002 4:46 PM Subject: AW: Unload db/Loaddb Interesting, ours went up by 25%, but my colleague did a dumpdb/loaddb, is there a difference between this and an unloaddb/loaddb? or when should one be used instead of the other? John. I have performed an unload/reload of our AIX TSM server, and recieved the following results: Reduced database utilization by - 21.2%
Re: AW: Unload db/Loaddb
I just completed a dump/reload of my database of a version 4.1.4 server It was a 3 gb db showing 80% utilization. After the reload I'm down to 24% My problem was with the 4.1 documentation, try as I might it wouldn't work with the loadformat step until a ran a dsmfmt of the logvolumes and the db voilumes first. Odd-Magne Sekkingstad [EMAIL PROTECTED]@VM.MARIST.EDU on 05/14/2002 02:46:16 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: AW: Unload db/Loaddb DUMPDB/LOADDB - is used when the database is corrupted, and audit db doesn't solve the problem. DUMPDB increases the size of the database. UNLOADDB/LOADDB - rearrange the structure of the database, this would in most cases result in better search performance and a smaller database. Odd-Magne - Original Message - From: Luscombe John (HS) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 13, 2002 4:46 PM Subject: AW: Unload db/Loaddb Interesting, ours went up by 25%, but my colleague did a dumpdb/loaddb, is there a difference between this and an unloaddb/loaddb? or when should one be used instead of the other? John. I have performed an unload/reload of our AIX TSM server, and recieved the following results: Reduced database utilization by - 21.2%
Re: Unload db/Loaddb
Rajesh, I have performed an unload/reload of our AIX TSM server, and recieved the following results: Reduced database utilization by - 21.2% Reduced used database pages by - 3,114,592 Maximum database reduction increased by - 22,044mb Our TSM production database is 60gb in size. It took 8.5hrs to unload the database, and 4.0hrs to reload the database. Two of the biggest benefits that we saw were a reduction of runtime for Expire Inventory, and the time it took to perform a FULL TSM Database backup. Monte Pioneer Hi-Bred International -Original Message- From: Rajesh Oak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 8:41 AM To: [EMAIL PROTECTED] Subject: Unload db/Loaddb Does anyone have a standard procedure for unloaddb and loaddb. I have TSM 4.2.1.11 on AIX. Our db is 36GB and is about 79 % full. Any gotchas while doing the unload and loaddb? Any help is appreciated. Rajesh Oak
AW: Unload db/Loaddb
Interesting, ours went up by 25%, but my colleague did a dumpdb/loaddb, is there a difference between this and an unloaddb/loaddb? or when should one be used instead of the other? John. I have performed an unload/reload of our AIX TSM server, and recieved the following results: Reduced database utilization by - 21.2%
Re: Unload db/Loaddb
How long did these benefits last? We are going to do the same thing, with a 48GB database. On our test system, it was redeuced to 26GB, but I have no load there to find out how long the benefits will last, and how often I will have to do this. Andy Carlson|\ _,,,---,,_ Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_ BJC Health Care|,4- ) )-,_. ,\ ( `'-' St. Louis, Missouri '---''(_/--' `-'\_) Cat Pics: http://andyc.dyndns.org/animal.html On Mon, 13 May 2002, Michael, Monte wrote: Rajesh, I have performed an unload/reload of our AIX TSM server, and recieved the following results: Reduced database utilization by - 21.2% Reduced used database pages by - 3,114,592 Maximum database reduction increased by - 22,044mb Our TSM production database is 60gb in size. It took 8.5hrs to unload the database, and 4.0hrs to reload the database. Two of the biggest benefits that we saw were a reduction of runtime for Expire Inventory, and the time it took to perform a FULL TSM Database backup. Monte Pioneer Hi-Bred International -Original Message- From: Rajesh Oak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 8:41 AM To: [EMAIL PROTECTED] Subject: Unload db/Loaddb Does anyone have a standard procedure for unloaddb and loaddb. I have TSM 4.2.1.11 on AIX. Our db is 36GB and is about 79 % full. Any gotchas while doing the unload and loaddb? Any help is appreciated. Rajesh Oak
Unload db/Loaddb
DOes anyone have a standard procedure for unloaddb and loaddb. I have TSM 4.2.1.11 on AIX. Our db is 36GB and is about 79 % full. Any gotchas while doing the unload and loaddb? Any help is appreciated. Rajesh Oak
Re: Unload db/Loaddb
You might want to check out the archives on this, there has been quite a bit of discussion in regards to this issue. Nici At 09:41 AM 5/10/2002 -0400, you wrote: DOes anyone have a standard procedure for unloaddb and loaddb. I have TSM 4.2.1.11 on AIX. Our db is 36GB and is about 79 % full. Any gotchas while doing the unload and loaddb? Any help is appreciated. Rajesh Oak Nici Albrecht MDR Consulting Education, Inc. 210-860-4641
Re: Unload db/Loaddb
My db shrank a lot also, but re-grew a fair bit over the next week. I suspect it will reach a steady-state value not much different than I started with. Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) 121 Cheshire Lane #700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] V: 952-931-1203 Andrew Carlson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 05/10/02 04:11 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Unload db/Loaddb I missed the first message in this thread, but I have been testing this. This is what I plan to do: - wait for DB backup to complete - enter 'halt quiesce command so the db should be consistent - unloaddb (to disk) - loaddb (from disk) In testing, with out full size DB (47.9GB), it went down to 28.6GB. I am very happy with the results, and am anxious to do it on the prod server. Andy Carlson|\ _,,,---,,_ Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_ BJC Health Care|,4- ) )-,_. ,\ ( `'-' St. Louis, Missouri '---''(_/--' `-'\_) Cat Pics: http://andyc.dyndns.org/animal.html On Fri, 10 May 2002, Nici Albrecht wrote: You might want to check out the archives on this, there has been quite a bit of discussion in regards to this issue. Nici At 09:41 AM 5/10/2002 -0400, you wrote: DOes anyone have a standard procedure for unloaddb and loaddb. I have TSM 4.2.1.11 on AIX. Our db is 36GB and is about 79 % full. Any gotchas while doing the unload and loaddb? Any help is appreciated. Rajesh Oak Nici Albrecht MDR Consulting Education, Inc. 210-860-4641
Re: Unload DB/LoadDB
Matt, many people on this list have larger DB. What is your concern about the database - performance, DB backup time, ... ? If there is a problem other than size provide some details - version, DBVols and LOGVols storage type, etc. Unload/Load may help to reduce the DB but may not as well. You can argue against no off-site reclamation. At the end through such reclaim not only tape usage is better but also chance for tape errors due to aging is minimized. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Unload DB/LoadDB I have a 45GB database. It is approximately 11,500,000 pages. Has anyone tried or had success using the Unload/Load DB? Is there another way that I can reduce this? I have my ACTLOG retention set for 4 days. I think what is holding me back is we have our OFFSITE copy pool set for . We send everything offsite forever (Not my idea). Matt Adamson, MCSE NDC MS Hardware Support *desk:425.288.6286 *cell:206.601.8561 *mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Unload DB/LoadDB
I have a 45GB database. It is approximately 11,500,000 pages. Has anyone tried or had success using the Unload/Load DB? Is there another way that I can reduce this? I have my ACTLOG retention set for 4 days. I think what is holding me back is we have our OFFSITE copy pool set for . We send everything offsite forever (Not my idea). Matt Adamson, MCSE NDC MS Hardware Support *desk:425.288.6286 *cell:206.601.8561 *mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]