CHGPFR - Change access paths of all logical views over a physical from one command


This command is used to affect the access path attributes of all Logical files over a specified Physical file.

This is particularly useful when performing a full data rebuild of a physical file with many logical files: If all access paths are left at *IMMED, the AS/400 will automatically spend time updating the logical file access paths for EVERY RECORD written to the file. If you are reloading a large file this can be a noticeable overhead.

The command can be used to switch all Logical files to *REBLD before the data is loaded, and switched back to *IMMED (or *DLY) after completion.

For example, when the file is returned to *IMMED after reloading all the data. The AS/400 will then recreate the logical file access paths - saving a lot of unnecessary machine work.



Current weather

Roanoke, Virginia USA

Overcast
  • Overcast
  • Temperature: 51.8 °F
  • Wind: East, 3.5 mph
  • Pressure: 1015 hPa
  • Rel. Humidity: 82 %
  • Visibility: 10 mi
Reported on:
Thu, 03/11/2010 - 09:21

Locations of visitors to this page

Bunch of Twits

  • has discovered that his mighty hammer Mjölnir is missing. 2 days 1 hour ago
  • grabs a coffee and settles down for a day of post implementation checks, project closure and user documentation... bah! 3 days 2 hours ago
  • is about to embark on an IHOP pancake eating frenzy with the sprogs... 4 days 1 hour ago
  • just watching tv, a female marine running up a beach, teagan says 'i hope shes not wearing heels because thats hard' ;) 4 days 14 hours ago
  • saturday morning, determined to do no work today just gonna hang out with the kids, walk the mutts, watch movies and vejjjjjj... hurrah! 4 days 23 hours ago
  • is al about rpg3, rpg4, php, asp, IBMi, html, xml, wsdl's and any other acronyms I can think of.... 6 days 10 hours ago
  • is pretending to type something important to avoid listening to someone talking a load of codswallop. 6 days 18 hours ago
  • see... DOTnetnuke.... Microsoft products make my brain shout 'Uncle!' 1 week 1 day ago
  • is moving out of his PHP-Drupal comfort zone and trying to wrap his brain around PHPNuke and the wonderful world of ASP.NET content manageme 1 week 1 day ago
  • cant sleep. awake since 4.30 and its Sunday morning aaargh 1 week 4 days ago

Who's online

There are currently 0 users and 32 guests online.