RE: Problem LEI 8.5 with AS400 V7R1 Daniel W Heichel 26.Feb.14 12:22 AM Lotus Notes LEI LEI - 8.0Windows
It sounds like your Domino & LEI server is merely accessing the iSeries, and is not installed on it, from the wording.
Did you upgrade the OS of your original machine, or are you now going to a new machine (that is running at V7R1)? If it's an entirely new machine, that would explain why it isn't finding the package; you would have to update your connectivity software and connection document appropriately.
However, and more likely, it sounds like you need to rebind your DB2 packages.
It's possible the database was rebuilt and thus needs to be rebound, but it seems more likely that DB2 was upgraded as part of the OS upgrade, and a re-bind is thus necessary. Specifically it appears that your NULLID / dynamic placeholders small package WITH HOLD 00 needs to be rebound.
There is documentation available online regarding how to bind these packages. In general, it will go something like this:
1. Open the DB2 Command Window
2. CD to the SQLLIB\bnd directory
3. Issue the following, replacing the values in <carrots like this> with the appropriate values. Note that the user profile you pick must have sufficient access to the NULLID library.
db2 connect to <databaseName> user <username> using <password>
db2 bind db2clipk.bnd blocking all sqlerror continue grant public
You would then terminate or reset the connection.
Be sure your DB group PTF is up to date as well. On V7R1, that is SF99701. Issue a WRKPTFGRP SF99701 to check; level 27 is the latest at the time of this writing.