AS400 Users: WRKRDBDIRE Question

I haven't had any users complaining but I'm getting the some errors in the WRKSPL for the ONEWORLD userid.

QPJOBLOG:Userdaa JDENET_K
SQL0950: Relational Database AS400ONE not in relational database table. .....change name or ADDRDBDIRE.

I looked at the WRKRDBDIRE and it has our serial number of our AS400 in as an entry with *LOCAL.

Looks like OneWorld is looking for our host name AS400ONE instead. Can I change this, implications if I do? What does everyone have their entry set to, the host name or the serial#?

TIA , Grant.

This is everywhere we have the machine serial number called out in our JDEINI on the AS/400


[DB SYSTEM SETTINGS]
Base Datasource=serialnumber - B733 Server Map
Server=serialnumber
Database=serialnumber - B733 Server Map
Library List=serialnumber

[SECURITY]
SecurityServer=serialnumber

[LOCK MANAGER]
Server=serialnumber

Darrell Allison
Systems Programmer
AS/400 V4R5 9406-730 8-Way / OneWorld B7332 SP11.3

Grant,

I just 2 minutes ago ran into this also on a new install of ERP 8.0.

My AS/400 serial number is S102745X but the AS/400 computer name is ANTIGUA.
If you do a WRKRDBDIRE you'll likely see that there is only one entry for
*LOCAL set to the serial number of the AS/400.
You may have another entry for the machine name set to the IP address of the
AS/400, however from my experience this is not correct as the AS/400 will
look for this machine on a remote network rather than internally.

I deleted the *LOCAL setting that has the RDB entry set to the serial number
of the AS/400 and added a new entry for the machine name set to the *LOCAL.
If you do this it should get rid of your error. If it doesn't work you can
always just recreate the previous entry.

I was changing a whole bunch of AS/400 parameters so I did IPL. After I
changes this and all the other settings all was well.

If you have custom written programs or other AS/400 apps that require a
specific RDB entry (Crystal) this change may affect it.

Colin

server and stop and start the services. Check the logs from the startup to
see if the error appears.

----- Original Message -----
From: "MagarG" <[email protected]>
To: <[email protected]>
Sent: Tuesday, April 08, 2003 3:41 PM
Subject: AS400 Users: WRKRDBDIRE Question


WRKSPL for the ONEWORLD userid.QPJOBLOG:Userdaa JDENET_KSQL0950: Relational
Database AS400ONE not in relational database table. .....change name or
ADDRDBDIRE.I looked at the WRKRDBDIRE and it has our serial number of our
AS400 in as an entry with *LOCAL.Looks like OneWorld is looking for our host
name AS400ONE instead. Can I change this, implications if I do? What does
everyone have their entry set to, the host name or the serial#?TIA , Grant.



Colin Dawes, Sr. Technical Consultant
Syntax.net
B733.1 to ERP 8.0
Oracle 8i/9i/SQL Server 2K, DB2

Thanks for the replies. Looks like I'll have to check for any custom programs or AS400 applications that might use this entry. If all looks ok, I'll make the change.

Do you have the host name defined in the Host Entry Table?

Work with TCP/IP Host Table Entries

ADDTCPHTE
CHGTCPHTE
RMVTCPHTE
RNMTCPHTE

or GO CFGTCP option 10....

Re: RE: AS400 Users: WRKRDBDIRE Question

Yes, we have our AS400 name (not serial#) in the Host Table for TCP/IP.

We made the change yesterday to the Relational Database Entry. Everything looks ok this morning. Thanks.

Grant.