• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Reader Feedback and Insights: Service Program Catch-22 Simplified

    July 12, 2002 Timothy Prickett Morgan

    Hey, Ted:

    The tip you presented in Midrange Guru, OS/400 Edition, about the binding Catch-22 was excellent.

    I wanted to point out that the tip mentioned that both programs must be bound twice. This is not true. Only one must be created with OPTION(*UNRSLVREF). The other can be created without ignoring unresolved references, since the first object already exists.

    Of course your way will work, but it’s an unnecessary step.

    I think that it’s time for IBM to give us a really good MAKE utility that handles the ILE model gracefully.

    By the way, I think that a similar article about some other compiler options, for example *DUPPROC, can be written.

    — Mark

    Sponsored By
    CENTERFIELD TECHNOLOGY

    $10,000 of Consulting for only $925

    Not only do we take the guesswork out of iSeries DASD Management with disk/HUNTER, but Centerfield Technology also offers a robust set of iSeries tools for application performance and user access control and diagnostics.

    Check out our low cost/high value service offering, the SQL Insurance Analysis. For only $925 we will show you how to increase the performance of your business process and how to secure your exposed critical files. Our analysis is geared toward any one using SQL-based applications on the iSeries–J.D Edwards OneWorld® and WorldSoftware®, MAPICS, BPCS, Web Sphere, Data Warehousing, applications developed in-house, etc.

    Key Benefits of SQL Insurance Analysis

    • The SQL Insurance Analysis deliverables are specific to each customer. Since the ‘raw material’ for the analysis comes from data you collect, the conclusions and recommendations are truly actionable.

    • Because we use our tools to do the analysis, we have the flexibility to adjust the SQL Insurance Analysis to focus on a specific part of a customer’s application. This ability to hone in on ‘areas of pain’ provides even more information and value. Individual reports are provided on:
      • Top 3 index recommendations most likely to boost application performance

      • Top resource intensive SQL statements and what to do next

      • Largest (CPU consumption) jobs with specific tuning options

      • Longest running programs by CPU time with tuning options

      • File transaction rates for effective index management

      • Unused Indexes to potentially delete for disk conservation
      • Duplicate indexes to reduce maintenance

      • Select/OMIT indexes that can be optimized

      • Security exposures of critical files

    • The SQL Insurance Analysis reporting process includes a post-assessment Q&A with a CTI analysis specialist, surfacing additional information and expert feedback from our knowledge base and experience with other similar customers.

    This extensive program set combines a methodology and tools to simplify the complex and time-consuming process of controlling and tuning SQL applications. Our easy, low cost analysis will help you fix availability problems now, before significant cost/damage occurs. And, we’ll show you how to control application performance and query access permanently – 24/7! Click here for more information.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mgo_rc, Volume 2, Number 52 -- July 12, 2002

    Sponsored by
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Delete Badly-Named OS/400 IFS Files, Take Two Readers Insights and Feedback: Dealing with Record Locks

    Leave a Reply Cancel reply

MGO Volume: 2 Issue: 52

This Issue Sponsored By

    Table of Contents

    • Reader Feedback and Insights: Service Program Catch-22 Simplified
    • Setting TCP/IP Server Autostart Parameters as a Group
    • Scheduling a Job to Run More than Once a Day

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • Positive News From The Kyndryl Mainframe Modernization Report
    • NAViGATE, inPower 2025 On Tap for September 2025
    • Guru: WCA4i And Granite – Because You’ve Got Bigger Things To Build
    • As I See It: Digital Coup
    • IBM i PTF Guide, Volume 27, Number 37
    • AI Is Coming for ERP. How Will IBM i Respond?
    • The Power And Storage Price Wiggling Continues – Again
    • LaserVault Adds Multi-Path Support To ViTL
    • As I See It: Spacing Out
    • IBM i PTF Guide, Volume 27, Numbers 34, 35, And 36

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2025 IT Jungle