IBM Mainframe Forum

by **zblservices** » Tue Aug 27, 2019 6:03 am

I'm trying to setup a remote datasource in my DB2 z/OS SubSystem so that I can access a database on DB2 Linux. I'm getting an error I just don't understand. Hoping I can get some help here while I'm also waiting for a reply on my IBM ticket.

I've cataloged the connection as follows:

Select all

SYSIBM.LOCATIONS

LOCATION LINKNAME IBMREQD PORT  TPN DBALIAS  TRUSTED SECURE
 -------- -------- ------- ----- --- -------- ------- ------
 MYREMOTE LNXDB01  N       50000     TESTDB01 N       N


SYSIBM.IPNAMES

LINKNAME SECURITY_OUT USERNAMES IBMREQD IPADDR
 -------- ------------ --------- ------- ---------------
 LNXDB01  P            O         N       192.168.100.101


SYSIBM.USERNAMES
TYPE AUTHID LINKNAME NEWAUTHID PASSWORD IBMREQD
 ---- ------ -------- --------- -------- -------
 O    ZBLSVC LNXDB01 APPUSER   xxxxxxxx N

If I connect directly to TESTDB01 on 192.168.100.101:500000 as user APPUSER and run this query, I get 888.

Select all

SELECT COUNT(1) FROM MYSCHEMA.TEST_TABLE

If I connect to my DB2 SubSystem as user ZBLSVC and execute this query, I get the error that follows:

Select all

SELECT COUNT(1) FROM MYREMOTE.MYSCHEMA.TEST_TABLE

SQL Error [42615]: SQLCODE = -644, SQLSTATE = 42615, SYNTAX ERROR OR ACCESS RULE VIOLATION FROM DB2 UDB for AIX, Linux, HP-UX, Sun, and Windows TOKENS FETCH <ATTRIBUTE-STRING>. SQLCODE=-644, SQLSTATE=42615, DRIVER=4.15.134

Anyone have any ideas or help??

IBM Mainframe Forum

Connecting to Remote Datasource on Linux

Connecting to Remote Datasource on Linux