PROBLEM: DataGate/400 Service won’t start

The information in this article applies to:

DataGate/400, All versions (with TCP/IP)
OS/400, Version V4R4 and higher
IBM Workstation Gateway
AS/400
Acceler8DB

SYMPTOMS:

Any of these symptoms may exist:

DataGate/400 Server won't start after entering the DG8_40/STRDG8SVR command and no errors are generated. Sometimes you will see the error "error binding socket, 3420" in the Job Log or Spool File.
An upgrade to OS/400 V4R4 or higher (V4R5) has occurred
An IPL has occurred.

CAUSE:

Here are some possible changes that may cause the DataGate/400 not running:

The TCP/IP Port (5042) assigned to DataGate is in use by IBM’s WSG (Workstation Gateway). This problem usually occurs after upgrading to OS/400 V4R4 and higher.
Security or Configuration has changed on the AS/400.
Objects that DataGate needs to run are no longer there.
TCP/IP or QINTER Subsystem is not running.

RESOLUTION:

NOTE: Please coordinate with your Systems Administrator and/or IBM regarding issues with the AS/400 and Workstation Gateway and how this will impact your current configuration. These steps are needed to be completed only once. Once the port restriction is added, IBM Workstation Gateway will not bind to port 5042.

Here are some resolutions:

Create a Port Restriction for IBM's Workstation Gateway so DataGate/400 can bind to port 5042:

Issue the end DataGate/400 Server command. (If there have been previous attempts to troubleshoot the problem. This command will free up any attempts to bind to port 5042.):

DG8_40/ENDDG8SVR

End Workstation Gateway (Once issuing the end Workstation Gateway command, the TCP/IP Port (5042) for Acceler8DB will become available for DataGate/400.):

ENDTCPSVR *WSG

Create a new TCP/IP Port Restriction:

ADDTCPPORT PORT(5042) PROTOCOL(*TCP) USRPRF(DG8SVCPRF)

Start DataGate/400 Server:

DG8_40/STRDG8SVR

Click here for Information on Security, Configuration Changes, and Objects for DataGate/400.
Start TCP/IP and QINTER Subsystems before starting the DataGate/400 Service.

PREVENTION:

Create a new TCP/IP Port Restriction:

ADDTCPPORT PORT(5042) PROTOCOL(*TCP) USRPRF(DG8SVCPRF)

MORE INFORMATION:

To find more information on how to determine what AS/400 User Profile is using the Acceler8DB Port (5042) by following these steps:

At Command line, type: WRKTCPSTS or NETSTAT
Select Option 3
Press F14 to see the numeric values on the local ports column
Press F11 to see the User connected to the Port.
Under the local ports column find and entry that reads 5042.

If you find that the port is being used by a different service (i.e. IBM's Workstation Gateway) other than DataGate/400 (Acceler8DB), then you will have to decide which service keeps the port and assign a different port number to the other service. If the port in conflict is indeed 5042, then you should probably assign it to DataGate/400 since it has been official registered by ASNA with the Internet Assigned Numbers Authority, for a list of all assigned ports click here. To change a port number use the command WRKSRVTBLE.

NOTE: This is port status information example shows that the user profile associated with the port 5042 is QTMTWSG when it should be DG8SVCPRF- the DataGate/400 user profile.

Here’s a copy of what the port status looks like:



Connection identification: 

Remote host name  . . . . . . . . . . . . . :

Remote internet address . . . . . . . . . . :    *

Remote port . . . . . . . . . . . . . . . . :    *

Local host name . . . . . . . . . . . . . . :

Local internet address  . . . . . . . . . . :    *

Local port  . . . . . . . . . . . . . . . . :    Acceler8DBServer

Associate User Profile  . . . . . . . . . . . . .  :  
  QTMTWSG

TCP programming interface information:

    State . . . . . . . . . . . . . . . . . . :  Listen

    Connection open type  . . . . . . . . . . :  Passive

Timing information:

Idle time . . . . . . . . . . . . . . . : 005:25:02.620