TechTip: Programmatically Changing All the Files in a Library PDF Print E-mail
Tips & Techniques - CL
Written by Joe Pluta   
Sunday, 30 November 2003 18:00

Q: We are running JD Edwards here and upgrading to V5R2 this weekend. One
problem that JDE has is performance issues related to some new values. It seems
that there can large performance hits if the logical files are not changed
as shown:

CHGLF FILE(F0003LA) ACCPTHSIZ(*MAX1TB)

Well, there are at least 300 (out of 1000's) logicals that I should do this for immediately. Is there a different way to submit this command so to change/update more than one file at a time? Using the keyword FILE(F0003*) does not work.

A: Use a command to create a list in a physical file:

DSPOBJD OBJ(JDELIB/*ALL) OBJTYPE(*FILE) OUTPUT(*OUTFILE)

Then use RCVF in a CL to read the records. Process only those record with ODOBAT = 'LF'. To process them sequentially, just do a CHGLF in the CL. If you want them to execute simultaneously, submit the CHGLF to a job queue and set MAXJOBS for the number you want to execute at once.
Joe Pluta is the founder and chief architect of Pluta Brothers Design, Inc. He has been working in the field since the late 1970s and has made a career of extending the IBM midrange, starting back in the days of the IBM System/3. Joe has extensive experience in Web application design and specifically IBM’s WebSphere, especially as the base for PSC/400, the only product that can move your legacy systems to the Web using simple green-screen commands. Joe is also the author of E-Deployment: The Fastest Path to the Web and Eclipse: Step by Step. You can reach him at joepluta@plutabrothers.com.

Joe Pluta
About the Author:
Joe Pluta is the founder and chief architect of Pluta Brothers Design, Inc. and has been extending the IBM midrange since the days of the IBM System/3. Joe uses WebSphere extensively, especially as the base for PSC/400, the only product that can move your legacy systems to the Web using simple green-screen commands. He has written several books, including E-Deployment: The Fastest Path to the Web, Eclipse: Step by Step, and WDSC: Step by Step. Joe performs onsite mentoring and speaks at user groups around the country. You can reach him at joepluta@plutabrothers.com.

 

MC Press books written by Joe Pluta available now on the MC Press Bookstore.

 

Developing Web 2.0 Applications with EGL for IBM i Developing Web 2.0 Applications with EGL for IBM i

Joe Pluta introduces you to EGL Rich UI and IBM’s Rational Developer for the IBM i platform.

List Price $39.95
Now On Sale
 
WDSC: Step by Step WDSC: Step by Step
Discover incredibly powerful WDSC with this easy-to-understand yet thorough introduction.

List Price $74.95
Now On Sale
 
Eclipse: Step by Step

Eclipse: Step by Step


Quickly get up to speed and productive using Eclipse.

List Price $59.00

Now On Sale
 
Read More >>

< Prev   Next >
Last Updated on Thursday, 04 October 2007 05:50
 
dougd@softlanding.com
Use WRKOBJPDM and the filters available there to narrow down your selection. Then create a user defind option that does the CHGLF. (your option could run interactively, or it could do it\'s own SBMJOB). Enter your option next to the filtered list and press F13 to repeat, then press enter.
J.Droke
A different approach which requires no programming would be to use PDM (WRKOBJPDM), subsetting it to the library and logical file in question. Then enter a 2 (CHGLF) and press F13 to copy this option to all options in the list. On the command line enter the parameter you want to change - ACCPTHSIZ(*MAX1TB) - and press ENTER.
Alx
I have found that creating a custom PDM user option and running that option over a filtered list in PDM has been very effective for a majority of my needs. Remember you can override selected parms at the command line that applies for each execution. (i.e. CHGOWN in the PDM user option and NEWOWN(XYZ) on the command line) Downside: It runs online.
Please login to make comments.
User Rating: / 0
PoorBest 

TRIAL SOFTWARE

The following trial software can be found at the MC Press Software Center.

 

WEBCAST

The following webcasts can be found on the MC Webcast Center.

 

WHITE PAPERS

The following White Papers can be found at the MC White Paper Center

 

 
   MC-STORE.COM