Hi,

We have generic master file on iSeries box. When I execute the report it goes and reads the data from default schema on DB2. Now we have created LINUX box for the purpose of scalability and this connects to the same DB2 DB on iSeries. But now the same synonym is not working in the same way. It is throwing below error. IADMIN is the admin user but I logged in using different dev user. Looks like some parameter or setting is not done properly. Could some one through some light on this issue ?

SET GRAPHSERVURL=http://172.31.8.34:8080/ibi_apps/IBIGraphServlet
SET GRAPHENGINE=GRAPH53
SET EXCELSERVURL=http://172.31.8.34:8080/ibi_apps
TABLE FILE pymast_sec_test
PRINT *
WHERE RECORDLIMIT EQ 500
WHERE READLIMIT EQ 500
END
(FOC1400) SQLCODE IS -204 (HEX: FFFFFF34) XOPEN: 42S02
: [S0002] [IBM][CLI Driver][AS] SQL0204N "IADMIN.PYMAST" is an undefined
: name. SQLSTATE=42704
L (FOC1406) SQL OPEN CURSOR ERROR. : PYMAST_SEC_TEST

Best Regards,
Prakash

This message has been edited. Last edited by: <Emily McAllister>,

Sounds like your old server was not Linux, and the adapter needs to communicate a different way.

You may have to recreate your adapter config.

Just a guess though.

Compare paymast_sec_test.acx on your Linux to the one on the iSeries. Did you create synonym for the paymast_sec_test or did you copy the one you had on iSeries?

Master file is a generic one. But I have created the test master file on the same table both on iSeries and LINUX.

I feel like, it has to do with settings.

I'm not sure what a generic master file is but if you create a new master file on Linux for this table and open this master file can you get sample data? I suspect you'll get an error there as well.

What happens when you open the Adapter Connection and Test it? Do you get any errors or do you get a sampling of system tables?