Connecting to Remote Datasource on Linux



IBM's flagship relational database management system

Connecting to Remote Datasource on Linux

Postby 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:


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 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 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??
zblservices
 
Posts: 1
Joined: Tue Aug 27, 2019 5:53 am
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post