=============================================================== SEARCH400.com | Administrator Tip Feb. 19, 2003 =============================================================== FROM OUR SPONSORS:
FREE iSeries 400 white papers http://search400.techtarget.com/whitepapers3/0,,sid3,00.html News Flash: AS/400 Personnel rescues IT manager from drowning. ... http://www.as400search.com/ =============================================================== Essential explanations, tools, and code for the iSeries administrator. More tips: http://search400.techtarget.com/tipsIndex/0,289482,sid3_tax2f8,00.html =============================================================== In today's technical advice roundup you'll find tips, expert answers and input from your peers on the following iSeries administrator questions and concerns: Today's Featured Administrator Tip: -- Achieve greater processing efficiency with delayed access paths Answers to Other Technical Questions - What do these access path terms mean? - Use DSPFD to track file accesses - Reorganize with CPYF *REPLACE - Create options from the source Important Announcements and Links - Tips Contest: Win a Swing Groover II electronic golf coach - Expert Profile: Richard Belles, systems management expert - Advice: Managing the iSeries Discussion Forum - Monthly Newsletter: Top Expert Advice _______________________________________________________________ ********** SPONSORED BY FREE iSeries 400 white papers ********* Download the key papers you need today to make informed decisions. Targeted categories include, database management, hardware (servers), OS/400, output solutions, security and storage Click here to access the FREE Search400.com white papers section. http://search400.techtarget.com/whitepapers3/0,,sid3,00.html =============================================================== Today's Featured Tip =============================================================== Achieve greater processing efficiency with delayed access paths By Ron Turull There is more than meets the eye to the Create Logical File (CRTLF) command. If you are accustomed to creating/compiling logical files by quickly typing option 14 and pressing Enter in PDM, you may be missing a lot. The same holds true if you type just CRTLF LIB/LGLFILE. Even if you prompt the Create Logical File command, you may be missing some important command parameters if you don't call them down with the F9 key. >> CLICK here to view the complete tip: http://www.search400.com/tip/1,289483,sid3_gci880908,00.html =============================================================== Answers to Other Administrator Questions =============================================================== What do these access path terms mean? Confused by the various terms that are used when discussing access paths? Site expert John Brandt defines those terms, including file indexes and logical files, and helps you make sense of them. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid457903_tax285217,00.html Use DSPFD to track file accesses It is often useful to know which are the most heavily accessed files in your system. Perhaps you would like to know which files have the most updates, deletes or reads. Such information can be useful in profiling individual programs, spotting performance bottlenecks and ensuring your system runs smoothly. There are many ways to determine such information, including performance tools, but journaling may be a better option. http://search400.techtarget.com/tip/1,289483,sid3_gci850005,00.html Reorganize with CPYF *REPLACE You can increase the speed of your CPYF replace by changing all of the logical files that are based on the destination physical file to MAINT(*REBLD) and then changing them back to MAINT(*IMMED) after the CPYF completes. Search400.com member Dan Sylvester did this on a file that had a whopping 55 logicals and witnessed a speed increase of 2000%. http://search400.techtarget.com/tip/1,289483,sid3_gci763915,00.html Create options from the source How many times have you recompiled an object only to find out later that you forgot to specify a particular keyword value to the compiler? According to Search400.com member Jeff Bull, CRTFMSRC allows you to encode these compiler/create options in with the source code. http://www.search400.com/tip/1,289483,sid3_gci874300,00.html _____________________________________________________________________ ****************** SPONSORED BY AS/400 Personnel ******************** News Flash: AS/400 Personnel rescues IT manager from drowning. ... "I thought that it would be easy to find the right IT professional in the 'Sea of resumes'. I got in way over my head and had given up hope," says one IT manager, "and then I called AS/400 Personnel. They saved me from certain doom!" A spokesman from AS/400 Personnel told this reporter that they save IT managers on a daily basis. "We have the resources and technical skills necessary to swim through the 'Sea of resumes' and find just the right professional for the job. This is what we do for a living," said the spokesman. "It's a treacherous sea, and IT managers shouldn't go it alone." "I am glad I called them," declared the IT manager, looking very relieved. "You will be too!" Call them for permanent professionals or contract consultants, or visit their Web site at http://www.as400search.com/. _______________________________________________________________ _______________________________________________________________ ::::::: DON'T MISS THESE IMPORTANT MESSAGES AND LINKS ::::::::: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WIN A SWING GROOVER II ELECTRONIC GOLF COACH | Submit your tip Would you like to improve your golf game? This month we're giving away a Swing Groover II electronic golf coach and analyzer. The electronic driving range improves your game with feedback on accuracy, distance and club head speed. You can practice and improve your full-swing golf shots with every club. Choose fairway lie or tee up at your preferred height, view the tethered ball's virtual flight and landing in "real time." The LCD displays each club's "average" and "best" distance and speed. Send in your tip -- you could be our next winner. >> SUBMIT a Tip: http://search400.techtarget.com/tipsSubmit/1,289485,sid3,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- EXPERT PROFILE | Rich Belles, systems management expert Richard's data processing career has spanned more than 30 years. He grew up with the midrange IBM computer line from the IBM 1401 through the iSeries 400. Intermingled therein included PCs, communications and some experience with IBM mainframe hardware and software. Richard has worked in all capacities -- from operations to data processing management. He has worked with the iSeries 400 since its appearance in 1988, specifically in the areas of systems administration, technical support and systems management. Richard currently works as an iSeries 400 technical specialist at Dimensional Insight Inc. in Burlington, Mass. Dimensional Insight provides complete business intelligence, reporting and data analysis software. In addition, he is an IBM Certified iSeries 400 Technical Specialist and an IBM Certified iSeries 400 Education Specialist. If you have systems management questions, Rich can help -- especially with those that deal with administration and technical support. >> CLICK HERE TO ASK Rich a question: http://search400.techtarget.com/ateQuestion/0,289624,sid3_cid371920_tax285222,00.html >> CLICK HERE TO READ recent Q&As: http://search400.techtarget.com/ateAnswers/0,289620,sid3_tax285222,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- MANAGING THE ISERIES DISCUSSION FORUM | Interact with your peers Check out Search400.com's Managing the iSeries discussion forum. If you have a performance problem you just can't figure out, or you need help recovering data after a system crash, we recommend you check out this forum. Other system managers can help you with these and other management issues. >> RECENT discussion threads you may find of interest: * Why won't the admin server start? http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84639/1118 * Storage limitations under OS/400? http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84639/1099 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MONTHLY NEWSLETTER | Top Expert Advice newsletter The Top Expert Advice newsletter was designed to help iSeries professionals manage tasks they deal with regularly. Each month we will give you expert advice on such topics as security, backup and recovery, Web development and application development. To receive this newsletter, simply edit your member profile at http://search400.techtarget.com/editSummary/1,291026,sid3,00.html and check Top Expert Advice newsletter under the Tips section. ________________________________________________________________ :::::::::::::::::::::: SEARCH400.COM CONTACTS :::::::::::::::::: TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Send us feedback on tips and ideas for new tip content. ________________________________________________________________ MICHELLE DAVIDSON, site editor (mailto:[EMAIL PROTECTED]) >> Send us your story ideas and best practices. ________________________________________________________________ DEBRA TART, assistant editor (mailto:[EMAIL PROTECTED]) >> Send us your tips and Best Web Links. ________________________________________________________________ DAVID GABEL, executive tech editor (mailto:[EMAIL PROTECTED]) >> Send me your technical tips and tip ideas. ________________________________________________________________ GABRIELLE DERUSSY (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. Unsubscribe from 'Administrator Tips' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://search400.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
