DSXchange

Just wondering as DB2 will be a new source for everyone here and getting software approved is a long and arduous process. So, I know most clients come with their own tools, like sqlplus for Oracle, and Toad probably has a 'for DB2' version but wondering what else might be out there that people have...

Thanks for all your input. It's much clear to me now.

Hi all, maybe this is a stupid question,howerver,I get a little confused with datastage cluster environment and datastage grid environment. Could someone tell me if they are the same concept or what are the differences between them. I know datastage engine could be distributed to other machines to b...

if you install a db2 client on the DS Server box, you could use libdb2.so as the odbc driver to connect to db2 v9, and you don't need to upgrade DataDirect to 5.3 for DS 7.5.1, and I did so in some project, it worked very well.

check to see if the database user for XMETA has a expired password. the user password create at the default installation will expire after 30 days on windows

I believe it's round robin in your case

Not sure what you mean by "no resolution found"... the Local Fix section of the linked note contains the grants needed to resolve the problem, did they not correct it for you? Or does being on an AS400 somehow invalidate that solution? :? chulett, I believe these system tables are for db2...

I got the same issue while access as400 tables.

is there anyone who could read as400 table using db2 connector successfully?

does db2 connector support db2 on i series?

Hi, We faced the similar issue some time back and got resolution.When using connector stage. It tries to query some of the DB2 system views related to environment. Once after granting permission to the Application user id (datastage id) on the respective tables our issue got resolved. yes, here is ...

Thanks Ray.

I resolved this issue by adding the user to group DB2USERS.

Hello, I installed IBM information server 8.0.1 on Windows 2003 Server Edition. When I created a job with DB2 API stage in datastage designer(on the same machine the server installed), I got the following error message. "ds_loadlibrary: Win32 error in LoadLibrary of dsdb2.dll - The specified mo...