Skip to Content mrc logo mrc logo
  • 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
  • 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 & Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Development Services Training Mentoring
  • Overview Partners Press Releases Careers Events Contact Blog
  • 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

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

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


© mrc. All rights reserved.