1. Applications Upgrade Guide for IBM i with DB2 for IBM i
  2. Adding an Entry to the Remote Database Directory

Adding an Entry to the Remote Database Directory

You can add an entry to the remote database directory by completing these steps:

  1. Log on to the IBM i as QSECOFR.

  2. On the command line, enter WRKRDBDIRE.

  3. Look for an entry on your IBM i for Remote Location *LOCAL. This entry must have the same name as your machine.

  4. If you do not have an entry like this, enter 1 in the Option column and type you machine name in the Relational Database column, and press enter. In the Remote Location Name or Address field, enter *LOCAL and press Enter. If you already have a *LOCAL entry and the Relational database name is not the same as your machine name, you must remove the entry that you have and add a new entry as previously described.

    Note: In previous JD Edwards EnterpriseOne releases, installation of Vertex required adding an entry to the Remote Database Directory, but no special naming was required. It is possible, in some cases, an entry was added with some other naming convention for this purpose. Vertex will work with a Remote Database Directory entry that is correct for Release 9.2.

  5. Once you have added or change the entry, you should recycle the database host server prestart jobs by issuing these commands:

    ENDPJ SBS(QSERVER) PGM(QSYS\QZDAINIT) OPTION(*IMMED)
ENDPJ SBS(QUSRWRK) PGM(QSYS\QZDASOINIT) OPTION(*IMMED)
ENDPJ SBS(QUSRWRK) PGM(QSYS\QZDASSINIT) OPTION(*IMMED)
STRPJ SBS(QSERVER) PGM(QSYS\QZDAINIT)
STRPJ SBS(QUSRWRK) PGM(QSYS\QZDASOINIT)
STRPJ SBS(QUSRWRK) PGM(QSYS\QZDASSINIT)
    Note: Users will not be able to use JD Edwards EnterpriseOne while you are running these commands.