Results 1 to 6 of 6

Thread: Periodic Maintenance - A Series of Short Maintenance Articles

  1. #1

    Periodic Maintenance - A Series of Short Maintenance Articles

    Recently I realized that my participation here at JdeList has been declining and since I believe that any community is only as strong as its member's unselfish participation, I want to make sure I am doing my part.

    As such, I will be posting a series of short articles on the topic of Periodic Maintenance in E1 and supporting systems. Some of the articles will be relevant to you, some will not. Some will be old knowledge that everyone knows, some may be new ideas that will generated peer-review and debate. Some may apply to your platform and some will not.

    Regardless, I hope that someone, somewhere gets some benefit and all that I ask is that when you find one that helps, you reply with something along the lines of "Holy Smokes Jeff, I had 14,111,676 records in the F01131M table and had no idea."

    I'll be starting soon. When I am done if you have any maintenance items you wish to add, feel free to jump in. I just ask that you start a separate topic if you do and please wait until I finish.



    Jeff


  2. #2
    New Member
    Join Date
    May 2005
    Location
    Houston Texas
    Posts
    16

    Re: Periodic Maintenance - A Series of Short Maintenance Articles

    Jeff,
    I like your web page, great looking Bike.
    I think I do have more than 14 million records............
    Looking forward to your posts, at a new company and putting together a maintenance plan.

    Dave
    Currently supporting.....
    8.12, Oracle DB on Linux
    9.0, Oracle DB on Windows
    Prior Support on......
    XE Coexistance, AS400's
    World
    dcLink for Warehouse / Logistics

  3. #3

    Re: Periodic Maintenance - A Series of Short Maintenance Articles

    I was picturing about a hundred CNC's and dba's all switching to a query writer after reading that post and doing a count on F01131M.





    [ QUOTE ]
    Jeff,
    I like your web page, great looking Bike.
    I think I do have more than 14 million records............
    Looking forward to your posts, at a new company and putting together a maintenance plan.

    Dave

    [/ QUOTE ]

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

    Re: Periodic Maintenance - A Series of Short Maintenance Articles

    Well that's better than picturing a hundred CNCs and DBAs on bikes. That would be a heck of a lot of geeks on wheels......
    Independent Consultant, Larkinville Associates, LLC
    XE thru 9.2

  5. #5

    Re: Periodic Maintenance - A Series of Short Maintenance Articles

    [ QUOTE ]
    Well that's better than picturing a hundred CNCs and DBAs on bikes. That would be a heck of a lot of geeks on wheels......

    [/ QUOTE ]

    So, does that mean you hopped on yer bike and rode over to your fancy cross-campus failover site and executed?




    use jde_production
    select count (*) from proddta.f01131m

  6. #6

    Re: Periodic Maintenance - A Series of Short Maintenance Articles

    sounds like some good reads. What people don't know can hurt them, when their table counts get into the 1M rows...
    E900 / MSSQL2005 / WebLogic.JRocket

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, Oracle or Peoplesoft.