RE: Re-organising a LARGE file -- MIDRANGE-L

We had a similar problem with a file, which we estimated that it will take six 
days to reorg the file.

There are a number of products on the market to aid the reorg process. 
Some require that you have the you have the equivalent free space available or 
higher as the file that is being reorganised. It essentially creates a copy of 
file being reorganised. (SoftLandings PDQ)


Others reorgnise the file while its active. We tried to do this with a product 
from iTera. We didn't have the free space available to try the option above. It 
ran for about 7 days and fell over for some reason. (iTera Reorganise While 
Active).

The products may have moved on since we had a look.

I would recommend that you test whatever solution before using it on live data.

We never did get the file reorganised.

However we have just installed a 570 with V5R3 and would hope to reorg the file 
in the coming weeks using the V5R3 command.  

Hope this is of some use.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] 
On Behalf Of midrange-l-request@xxxxxxxxxxxx
Sent: 10/03/05 6:01 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 4, Issue 472


Send MIDRANGE-L mailing list submissions to
        midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
        midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than "Re: 
Contents of MIDRANGE-L digest..."


Today's Topics:

   1. RE: SQL question (Walden H. Leverich)
   2. Re-organising a LARGE file (Ian Dorrington)
   3. RE: Re-organising a LARGE file (Colin Williams)
   4. RE: Re-organising a LARGE file (Fisher, Don)
   5. Common Session Handouts (ChadB@xxxxxxxxxxxxxxxxxxxx)
   6. Re: Common Session Handouts (pnelson@xxxxxxxxxx)
   7. *** ADMIN: Reminder -- COMMON (David Gibbs)
   8. RE: HMC 4.4 (and above)3 (JOberholtzer@xxxxxxxxxxxx)


----------------------------------------------------------------------

message: 1
date: Thu, 10 Mar 2005 10:57:19 -0500
from: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
subject: RE: SQL question

>For traditional as400 library list searching, you need to use the
*SYSTEM
>naming convention

And _please_ do that, do NOT do what the IBM examples all do and write your 
select statements like "select ItemNo, Description from library.item" 

You'll have one hell of a fun time when you have to use "testlib.item" for 
testing and "prodlib.item" for production, and "mylib.item" for development. 
All the external interfaces to SQL (JDBC, ODBC, OLEDB,
.NET) allow you to tell SQL to use the system naming convention in the 
connection string.

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
  



------------------------------

message: 2
date: Thu, 10 Mar 2005 16:11:55 -0000
from: Ian Dorrington <ianDorrington@xxxxxxxxxxxxxxxx>
subject: Re-organising a LARGE file

We have a file with 387,961,653 records and 472,603,144 deleted records.  It 
has 3 logical files built over it.  Using the RGZPFM command we estimate 90+ 
hours to re-org.
 
I believe that there are utilities that do a re-org whilst the file is in use.  
Does anyone have any recommendations?  We're at 5.1 of OS400, there may be an 
OS400 utility at 5.3, but we're not going there for a little while.
 
Thanks,
Ian
 

**********************************************************************
The contents of this E Mail message are confidential as between the sender and 
the named recipient, and may be legally privileged.  Any person receiving this 
E Mail message not being the named recipient is prohibited from using the 
contents for any purpose other than to pass it to the named recipient without 
copying, disclosing or disseminating the contents in any way other than with 
the express consent of the named recipient.  Greene King reserves the right to 
monitor any and all E Mail communications using any part of its Network.

This footnote also confirms that this email message has been swept by 
MIMEsweeper/Sophos for the presence of computer viruses.
**********************************************************************


------------------------------

message: 3
date: Thu, 10 Mar 2005 16:16:11 -0000
from: Colin Williams <colin.williams@xxxxxxxxxxxx>
subject: RE: Re-organising a LARGE file

Ian

OS Solutions have such a tool that will run at V5R1

cheers
Colin.W

http://as400blog.blogspot.com
 


-----Original Message-----
From: Ian Dorrington [mailto:ianDorrington@xxxxxxxxxxxxxxxx] 
Sent: 10 March 2005 16:12
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Re-organising a LARGE file


We have a file with 387,961,653 records and 472,603,144 deleted records.  It 
has 3 logical files built over it.  Using the RGZPFM command we estimate 90+ 
hours to re-org.
 
I believe that there are utilities that do a re-org whilst the file is in use.  
Does anyone have any recommendations?  We're at 5.1 of OS400, there may be an 
OS400 utility at 5.3, but we're not going there for a little while.
 
Thanks,
Ian
 

**********************************************************************
The contents of this E Mail message are confidential as between the sender and 
the named recipient, and may be legally privileged.  Any person receiving this 
E Mail message not being the named recipient is prohibited from using the 
contents for any purpose other than to pass it to the named recipient without 
copying, disclosing or disseminating the contents in any way other than with 
the express consent of the named recipient.  Greene King reserves the right to 
monitor any and all E Mail communications using any part of its Network.

This footnote also confirms that this email message has been swept by 
MIMEsweeper/Sophos for the presence of computer viruses.
**********************************************************************
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To 
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or 
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.



------------------------------

message: 4
date: Thu, 10 Mar 2005 11:16:23 -0500
from: "Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>
subject: RE: Re-organising a LARGE file

You might want to check the archives for the list as I'm certain this has been 
discussed before.

When we've been faced with this problem, we usually copy the file to another 
library and then copy it back using MBROPT(*REPLACE).

With such a large file, you'll probably want to do that in a test environment 
to determine how long it will actually take. 

Hope that helps. 

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
We have a file with 387,961,653 records and 472,603,144 deleted records.  It 
has 3 logical files built over it.  Using the RGZPFM command we estimate 90+ 
hours to re-org. <clip>


------------------------------

message: 5
date: Thu, 10 Mar 2005 11:45:09 -0500
from: ChadB@xxxxxxxxxxxxxxxxxxxx
subject: Common Session Handouts






I'm attending Common next week and am wondering if the session presentations 
are typically handed out at the sessions?  I've found maybe 60% or so of the 
ones i'm interested in on the Common website for download, but many of them 
still aren't out there.  I was considering printing some and taking them with 
me, but don't want to spend the time doing it (or carry them around) unless 
absolutely necessary!  (I'm not planning on lugging a laptop around to the 
sessions either...)

Any advice would be greatly appreciated!

Thanks...

_____________________________________________________________________________
Scanned by IBM Email Security Management Services powered by MessageLabs. For 
more information please visit http://www.ers.ibm.com 
_____________________________________________________________________________

------------------------------

message: 6
date: Thu, 10 Mar 2005 10:51:55 -0600
from: pnelson@xxxxxxxxxx
subject: Re: Common Session Handouts

There will be last minute additions, and many of the sessions will also 
have handouts in the rooms. There are also printers on site if you need to 
print one from the web, but this is a last resort. For sessions that you miss, 
look for the handout table in the registration area on Tuesday AM. All the 
leftovers get put there in the middle of the night, so new 
handouts appear each morning.


Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx





ChadB@xxxxxxxxxxxxxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/10/2005 10:45 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Common Session Handouts







I'm attending Common next week and am wondering if the session presentations 
are typically handed out at the sessions?  I've found maybe 60% or so of the 
ones i'm interested in on the Common website for 
download,
but many of them still aren't out there.  I was considering printing some and 
taking them with me, but don't want to spend the time doing it (or carry them 
around) unless absolutely necessary!  (I'm not planning on lugging a laptop 
around to the sessions either...)

Any advice would be greatly appreciated!

Thanks...

_____________________________________________________________________________
Scanned by IBM Email Security Management Services powered by MessageLabs. For 
more information please visit http://www.ers.ibm.com 
_____________________________________________________________________________
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




------------------------------

message: 7
date: Thu, 10 Mar 2005 11:04:16 -0600
from: David Gibbs <david@xxxxxxxxxxxx>
subject: *** ADMIN: Reminder -- COMMON

Folks:

Just a quick reminder about COMMON ...

Stop by the MKS booth at the expo to pick up your midrange.com button. You can 
also leave messages for me there, if you need to.

Also, Sunday at CUDS will be Ask the Experts night ... and there will be a 
"MIDRANGE-L" table so we can put faces to the email addresses.

david



------------------------------

message: 8
date: Thu, 10 Mar 2005 11:13:47 -0600
from: JOberholtzer@xxxxxxxxxxxx
subject: RE: HMC 4.4 (and above)3





From:  Andy McLaughlin of IBM Austin TX.

        I believe what is being referred to here is that in the 4.3 release of 
the HMC, an enhancement was made to support a Journaled File System (EXT3), 
which provides much better file system recovery in the event of a
power loss or crash of the HMC.    However, the file system on the HMC only
gets converted to EXT3  if you do a full release install (which requires
the CDs).   You can also just install 4.3 as a PTF to an existing HMC at an
earlier release level, but that will only update the code without converting 
the filesystem.  I believe this improved reliability is why the Tech Support 
team is recommending that you do the full install update. There is no such 
underlying change going from 4.3 to 4.4, which is why just
applying the PTF is sufficient.   I'm sorry that the reasons were not
better explained to you.
        You can see this information in the release notes for 4.3 on the HMC 
support web site at: 
https://techsupport.services.ibm.com/server/hmc/power5/fixes/ptf_v4r31.html

Thanks,
Andy
STSM, eServer System Architecture
IBM Systems Group
Bldg 045/2M122, Austin, TX                Inet: amclaugh@xxxxxxxxxx


Jim Oberholtzer
Senior Solutions Architect
Computech Resources, Inc.



------------------------------

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list To 
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or 
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



End of MIDRANGE-L Digest, Vol 4, Issue 472
******************************************


**********************************************************************
***DISCLAIMER***

This message and/or any attached documents may contain Privileged and 
Confidential Information and should only be read by those persons to whom this 
message is addressed.
Other than where expressly stated to the contrary, the contents of this message 
and/or of any attached document(s) are not intended to be relied upon by any 
person without subsequent express written confirmation to that effect.
FBD Holdings plc disclaims all responsibility and accepts no liability 
(including liability for negligence) for the consequences for any person 
acting, or refraining from acting, on the information contained in this E-mail 
or in the attached document (s) before receiving such written confirmation.
Whilst reasonable efforts are made to ensure that this E-mail and any 
attachments are free from known viruses, FBD Holdings plc accepts no liability 
for the consequences of virus infection on the receivers IT Systems.
If you have received this E-mail message in error, please notify the sender 
immediately by telephone. Please also delete the message from your computer.
Any form of unauthorised reproduction, publication, distribution, disclosure, 
and/or modification of this E-mail message and/or its contents is strictly 
prohibited.
This footnote also confirms that this email message has been swept 
for the presence of computer viruses.
FBD Holdings plc includes FBD Group companies and its subsidiary and associated 
companies 

**********************************************************************