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

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

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

    Sponsored by
    Maxava

    Migrate IBM i with Confidence

    Maxava Migrate LiveTM minimizes disruption with seamless transitions. Upgrading to Power11, or cloud hosted system, Maxava has you covered!

    MIGRATE NOW

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Delete Badly-Named OS/400 IFS Files, Take Two Setting TCP/IP Server Autostart Parameters as a Group

    Leave a ReplyCancel 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

    • IBM i PTF Guide, Volume 28, Number 28: A Crazy Number of Security Vulnerability Patches
    • Inside The Encryption Key Management Changes In IBM i 7.6
    • FalconStor Moved To The Blue Lagoon, And Is Poised For Growth Because Of It
    • Guru: Claude’s SQL Tip
    • Astera Makes Extracting Legacy Report Data an AI Specialty
    • IBM i PTF Guide, Volume 28, Number 27
    • Welcoming The New IBM i Chief Architect And Other New Top Brass
    • A Deep Dive Into That Power S1112 Entry Power11 Server
    • Guru: Beyond Three-Part Naming – Running SQL Across Remote IBM i Systems
    • How IBM Bolstered IBM i Resilience In The Summer Tech Refreshes

    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