1. Applications Upgrade Guide for IBM i with DB2 for IBM i
  2. Adding a New Entry to the QAQQINI File

Adding a New Entry to the QAQQINI File

Once you have put the latest PTFs onto the IBM i, you need to enable the new LOB locator functionality. If you do not do this, Specifications Merge and Package Build will fail.

  1. Open the QAQQINI file on the Enterprise Server using this command:

    WRKOBJ QUSRSYS\QAQQINI *FILE

  2. If the QAQQINI file does not exist, add it using this command:

    CRTDUPOBJ QAQQINI QSYS *FILE QUSRSYS DATA(*YES)

  3. Start IBM i Navigator.

    This image is described in the surrounding text.

  4. Navigate the Databases node and then expand to show your machine name.

  5. Right click on your machine name and select Run SQL Scripts.

  6. Run these SQL commands:

    SELECT * FROM QUSRSYS.QAQQINI

    In the results, you should search for this entry:

    LOB_LOCATOR_THRESHOLD

    If the LOB_LOCATOR_THRESHOLD entry does not exist, you should insert it by running this command:

    INSERT INTO QUSRSYS.QAQQINI VALUES('LOB_LOCATOR_THRESHOLD','10000', default)

    If the LOB_LOCATOR THRESHOLD entry does exist, you should ensure that the value for QQVAL is set to 10000. If the QQVAL value is set to anything other than 10000 (for example, *DEFAULT), you must change it using this command:

    Tip: If you haveSTRSQL, you can also run this command directly from that program.

    UPDATE QUSRSYS.QAQQINI SET QQVAL='10000' WHERE QQPARM='LOB_LOCATOR_THRESHOLD'

  7. Sign out of the IBM i Navigator and make sure the QZDASOINIT job is terminated. This is required because a new database connection must be started with the new values for QZDASOINIT.