|
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 **********************************************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
