• 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
    Maxava

    Migrate IBM i with Confidence

    Tired of costly and risky migrations? Maxava Migrate Live minimizes disruption with seamless transitions. Upgrading to Power10 or cloud hosted system, Maxava has you covered!

    Learn More

    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

    • Meet The Next Gen Of IBMers Helping To Build IBM i
    • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
    • Will Independent IBM i Clouds Survive PowerVS?
    • Now, IBM Is Jacking Up Hardware Maintenance Prices
    • IBM i PTF Guide, Volume 27, Number 24
    • Big Blue Raises IBM i License Transfer Fees, Other Prices
    • Keep The IBM i Youth Movement Going With More Training, Better Tools
    • Remain Begins Migrating DevOps Tools To VS Code
    • IBM Readies LTO-10 Tape Drives And Libraries
    • IBM i PTF Guide, Volume 27, Number 23

    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