Re: SQL Code 0842, SQL State 8002

On 21-Oct-2014 12:59 -0500, Michael Ryan wrote:

Ok...I seem to be getting this more frequently. I'm issuing a remote
connect, and occasionally receive a 0842 error code. I can't seem to
get a lot of info by googling, but it appears that the connection
already exists. I am making a lot of calls. Should I use SET
CONNECTION when this happens? Anyone encounter this? Thanks.

The results of a request to Display Message Description (DSPMSGD) of the corresponding SQLCODE is often helpful to review; though IIRC the identical information should be in the InfoCenter\KnowledgeCenter under SQL codes and messages:
DSPMSGD SQL0842 QSQLMSG

As I recall for my few programs using DRDA coded to utilize or allow for more than one hard-coded connection, I would just issue a SET CONNECTION for the specified RDB when that was the condition for a CONNECT statement.