mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • mrc-Productivity Series
  • Improving performance: Cleaning the MRCLDC9A file
Back to Manual

Improving performance: Cleaning the MRCLDC9A file

 

Due to the flexibility of the mrc suite, there are times when the MRCLDC9A file can not automatically delete member files. This can cause performance issues if not cleaned every few years. Here is what we recommend:

Take a DSPFD on the MRCLDC9A in the appropriate library by typing in:

DSPFD XXXXXX/MRCLDC9A where XXXXXX is your library name

On the following screen type B on the Control to go to the bottom of the page.

If your file is correct, it will look similar to the image above. Note: The Total number of members is listed at 1, with the only member being MRCLDC9A.

However, if the file needs to be cleaned, it might look something like this:

Note the number of members — 96.

To remove the extra members, type in RMVM and prompt.

Note: The extra members generally start with A0, B0, C0, M0, and/or M1. You will need to verify what your file contains in the DSPFD in the last step.

Specify the database file, the library, and which member you would like to delete. You can use the * as a wild card. In the example above, we are removing any member that begins with "M0".

Repeat this step until all members have been removed less the MRCLDC9A file.

Note: Be sure to NEVER remove the MRCLDC9A file.

Note: This problem is only know to occur on the MRCLDC9A file.

Created: February 29, 2008 | Modified: December 23, 2011

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Freemarker Admin mrc-Productivity Series Calculations Database DB2 Security Maintainer Maintainers Parameters Administration External Objects Compiling Retrieval Data Dictionary Summaries Retrievals Build Process Dates Production Java Tomcat Report Graphs Popular Reports Form Validation RPG Dropdowns Record Selections App Properties Email Getting Started Bootstrap Templates Performance Application Properties Graphing Video Excel Bar Graphs m-Painter Graph Properties Advanced Prompt Screens SQL

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.