DSXchange

Hi All.

I have a DB2 stage that is selecting data from multiple tables and writing into a flat file. I am using a column generated sql. When I validate my job I don't get any errors. However, when I run the job, I get the following error -
I searched the forum but did not find an effective resultion.

Any Ideas?

-Thanks in advance
Anjan

Anjan Roy wrote:Hi All.

I have a DB2 stage that is selecting data from multiple tables and writing into a flat file. I am using a column generated sql. When I validate my job I don't get any errors. However, when I run the job, I get the following error -

Code: Select all

[IBM][CLI Driver] CLI0131E  Invalid string or buffer length. SQLSTATE=HY090
SQLTables: Error retrieving system catalog information for requested tables(s). 

I searched the forum but did not find an effective resultion.

Any Ideas?

-Thanks in advance
Anjan

Add this environment variable "DS_NO_PROCESS_METADATA" in the admnistrator and set it to 1 and try to compile and run the job. This is needed if you are using the DB2 8 version

Can you import table definitions?

Check that you have requisite SELECT priveleges to the system tables.

Hi vcannadevula,

Your suggestion worked!

We just did an upgrade to DS7.5.1.A in our dev server and started doing a shakeout on our jobs and got this error in 3 jobs so far:
[IBM][CLI Driver] CLI0131E Invalid string or buffer length. SQLSTATE=HY090
SQLTables: Error retrieving system catalog information for requested tables(s).

So I added that environment variable as you suggested and the jobs ran fine this time.

What's that env variable for? You mentioned we need this if we're using DB2 8? Can you pls tell me more abt it?

Thanks much!!