Re: DB2 Connect issue

2013-04-05 Thread Terry Sambrooks
Hi William, I cannot help with the exact nature of the issue your people face but I can confirm that DALLAS9 is in SYSIBM.LOCATIONs as proved by SELECT * FROM SYSIBM.LOCATIONS WHERE SUBSTR(LOCATION,1,6) = 'DALLAS' A similar query against SYSIBM.SYSTABLES,

DB2 connect issue

2013-04-04 Thread william janulin
To list;   We have users that are working with DB2 Connect, trying to use the command line function of it. They reported the following SQL error: SQL0551N  SSSDM does not have the privilege to perform operation CREATE IN on object DALLAS9.NULLID.SQLC2G13.().  SQLSTATE=42501 This object of

Re: DB2 connect issue

2013-04-04 Thread AbsKerneels
Reply from Google : You need to configure DB2 Connect properly (i.e. set up the DCS directory properly). It sounds like you've defined the connection as though it's running on DB2 UDB for LUW, not DB2 for z/OS.