• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Db2 For IBM i 7.3 Hits A Bad Patch

    December 2, 2019 Timothy Prickett Morgan

    As you know, we are among the people in the IBM i community who are always telling you to keep current on your PTF patches for the best operating system available on Power Systems. (No, we are not talking about AIX or Linux.) But every now and again, as happens with all operating systems, something gets fixed and the fix is worse than the problem it was solving.

    That has apparently happened with the database patches for the Db2 for i relational database management system embedded in the IBM i 7.3 release once the Db2 Group patches from November 13 are applied.

    We just found out about this as the Thanksgiving Holiday was starting and have not had a chance to get comment from Big Blue as yet, but Doug Bidwell, president of IBM i reseller DLB Associates in southern California, found the issue the hard way by keeping one of his IBM i 7.3 customers current on patches. To be precise, Bidwell was installing IBM i 7.3 DB2 for IBM i Group SF99703, Level 16, dated November 13, on a Power9 machine and it made the machine crash. Bidwell’s understanding is critical PTFs for the database were not included in Level 16, and the resulting issue is that both the A and B side of the software update (a sort of before and after the patch setup) will lock up. This will require what is called a “SLIP install” to repair, which is a big pain in the neck. If you are unfamiliar with the SLIP install process, you can read about it here and you can also count yourself lucky.

    Let’s explain a bit. So a SLIP install allows you to replace the Licensed Internal Code at the heart of the operating system – what people in other operating systems might call the kernel – independent of the surrounding operating system, or to change the operating system independent of the Licensed Internal Code. In this case, it is the operating system that is somehow corrupted, not the LIC, and in this case it is the database group that is corrupted and it locking up the operating system. This is a weird one in that the A side – the part of the operating system that has PTFs permanently applied – and the B side – the part of the operating system that has the PTFs temporarily applied and therefore you can go back to where you were before the PTFs were applied – were both corrupted. So at that point, all you can do is SLIP the operating system and reapply known good PTFs to the system. Depending on the size of the system, this could take a few hours. The issue will be finding someone who knows what to do, and who doesn’t crack up when they are told to SLIP the LIC. (Well, technically they are not SLIPing the LIC but SLIPing the OS, but the joke is too good.)

    Bidwell says to install SF99703 Level 17, made available on November 25, which was issued to fix this issue. If you are not able to do that, contact IBM for assistance.

    One other thing the DB2 group PTF SF99703, Level 16 was included with Cume orders, and the SF99731 Group (all the groups except the cume).

    By the way, the planned schedule for updating of the SF99703 group of PTFs is every four months, so that the fact that it was updated twice in two weeks is significant. As far as we know, there is no issue with the database patches for either IBM i 7.2 or IBM i 7.4, but we will keep an eye out. We will keep you updated if conditions change.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: AIX, BM i 7.2, DB2, DB2 for i, IBM i, IBM i 7.3, LIC, Licensed Internal Code, Linux, Power Systems, PTF, SLIP

    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

    Converge Technology Emerges As Reseller Powerhouse IBM i PTF Guide, Volume 21, Number 48

    2 thoughts on “Db2 For IBM i 7.3 Hits A Bad Patch”

    • Greg Wilburn says:
      December 2, 2019 at 8:34 am

      Should level 16 be deleted if already “downloaded”? We download PTF groups every weekend… and level 17 is not on our system.

      Reply
    • Mike says:
      December 20, 2019 at 10:20 am

      Any update on what process is affected with the Level 16? I have 2 system running with it and have had no problems

      Reply

    Leave a Reply Cancel reply

TFH Volume: 29 Issue: 71

This Issue Sponsored By

  • Fresche Solutions
  • WorksRight Software
  • ARCAD Software
  • Computer Keyes
  • Manta Technologies

Table of Contents

  • Db2 For IBM i 7.3 Hits A Bad Patch
  • Converge Technology Emerges As Reseller Powerhouse
  • Guru: End Of Year Feedback
  • Power S812 Gets Another Reprieve, And Other Power Systems Stuff
  • IBM i PTF Guide, Volume 21, Number 47

Content archive

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

Recent Posts

  • The Power11 Transistor Count Discrepancies Explained – Sort Of
  • Is Your IBM i HA/DR Actually Tested – Or Just Installed?
  • Big Blue Delivers IBM i Customer Requests In ACS Update
  • New DbToo SDK Hooks RPG And Db2 For i To External Services
  • IBM i PTF Guide, Volume 27, Number 33
  • Tool Aims To Streamline Git Integration For Old School IBM i Devs
  • IBM To Add Full System Replication And FlashCopy To PowerHA
  • Guru: Decoding Base64 ASCII
  • The Price Tweaking Continues For Power Systems
  • IBM i PTF Guide, Volume 27, Numbers 31 And 32

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