Results 1 to 3 of 3

Thread: Archive/Purge Proces

  1. #1

    Archive/Purge Proces

    I'm looking for someone who has experience with the archive/purge process on the F0911 table.
    We run a few jobs that post a lot records directly into this table and its fast approaching 9 million records.
    I have not had any performance problems yet, but I do have issues when I run the R98403.
    We are running Xe B7333 SP23 with a MS SQL DB, GL, AP, FA modules only.
    Thank you in advance for your input.
    Gilc


  2. #2
    Senior Member gregglarkin's Avatar
    Join Date
    Mar 2002
    Location
    USA and Canada
    Posts
    1,508

    Re: Archive/Purge Proces

    Hi Gil,

    We are running into the same issue. Our F0911 table has over 30 million records. Our South American division's database is growing by five gigabits per month. We purchased Princeton Softech's Optimum archiving solution for JDE. It works with all releases. It has a GL, AP, AR and Sales moduals currently. Inventory is coming soon. We installed and configured GL, AP, AR and Sales on our test server. We easily purged over 5.5 million GL records for Mexico with no integrity issues. Very slick. We'll be moving this to our production server shortly. If anyone is interested, I can post benchmark figures for our purge and archive process.

    Gregg Larkin
    JDE System Administrator (CNC) / North America
    Praxair, Inc.
    Independent Consultant, Larkinville Associates, LLC
    XE thru 9.2

  3. #3
    Senior Member DSauve's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA
    Posts
    1,255

    Re: Archive/Purge Proces

    Gilc,

    I just recently went through and archived off our G/L data, removing about 2 million F0911 records from 5 years worth of data. I used the R09911 UBE with a different version for each year to purge. Note that the R09911, if so configured, will move the F0911 records into the F0911P. I then took these records and moved them into a normally read-only archive-type tablespace (Oracle db), then wiped out the F0911P table. Note that to really reclaim the space freed up from the deleted records, you should reorganize your db. For each run that deleted about 500,000 F0911 records, it took about 3 hours to complete.

    Also, if you are running any financial integrity reports, you'll want to adjust processing options and/or data selection to skip the years you archive from the F0911 table. Otherwise, your integrity reports will balloon.
    Don Sauve
    Wagstaff, Inc.
    E1 9.2, Win2016, SQL Server 2016, TR 9.2.2.6, WebLogic 12.2.1, BI Publisher

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.