Re: DB2 Connect issue
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, SYSIBM.SYSTABLESPACE and SYSIBM.SYSDATABASE gave a 0 hit count. Kind Regards - Terry Director KMS-IT Limited 228 Abbeydale Road South Dore Sheffield S17 3LA UK Reg : 3767263 Outgoing e-mails have been scanned, but it is the recipients responsibility to ensure their anti-virus software is up to date. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
DB2 connect issue
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 DALLAS9 is, I believe, part of the SYSIBM.LOCATIONS table but do not know for sure. I know that the error they are getting deals with not having the privilege. I have to grant them BIND privileges but do not know if this Dallas9 stuff is a table, scheme, or something else. Has anyone run into this? Regards, Bill J. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DB2 connect issue
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. http://bytes.com/topic/db2/answers/183050-bind-needed-remote-remote-pc-access-db2-os-390-a On 4/4/2013 3:28 PM, william janulin wrote: does not have the privilege to perform operation CREATE IN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN