Waning in test, abort in prod

[diamondabhi]

Hi All,
When I run a job in test box I get the following message as warning but the job runs successfully where as I get the same message in the prod box the job aborts, can anybody tell me what needs to be done. I am usng DB2 plugin stage.

Error Message:
[IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM .SQLTABLES " failed due to reason "00E7900C". SQLSTATE=55023

SQLTables: Error retrieving system catalog information for requested tables(s).

Thanks,
Abhi.

[roy]

Double post Please answer the other one!
viewtopic.php?t=93979

[vcannadevula]

Hi All,
When I run a job in test box I get the following message as warning but the job runs successfully where as I get the same message in the prod box the job aborts, can anybody tell me what needs to be done. I am usng DB2 plugin stage.

Error Message:
[IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM .SQLTABLES " failed due to reason "00E7900C". SQLSTATE=55023

SQLTables: Error retrieving system catalog information for requested tables(s).

Thanks,
Abhi.

I had the same issue in the 7.5. I decalred a environment variable

"DS_NO_PROCESS_METADATA" in the user defined section of the administrator and set it to 1. THis will allow your job to run. I am assuming you are using the DB2 8 version.

[diamondabhi]

Hi ,
Devula Can you please explain it elaborately as to how to set this env variable as i gave the env variable as you said but the job is still aborting, yes we are using DB2 version 8
And Ray i checked with my DBA and she says the privileges are the same in both boxes.
If anybody had a similar problem please help me out.

Thanks,
Abhi.

[vcannadevula]

Hi ,
Devula Can you please explain it elaborately as to how to set this env variable as i gave the env variable as you said but the job is still aborting, yes we are using DB2 version 8
And Ray i checked with my DBA and she says the privileges are the same in both boxes.
If anybody had a similar problem please help me out.

Thanks,
Abhi.

Go to the administrtor, select the project and goto the properties.
Click the environment varianbles button. Go to the user defined tab,
Give name as "DS_NO_PROCESS_METADATA"
Type as "string"
value as 1

After giving this, close the adminstrator and the other client windows and try to run the job

[diamondabhi]

Hi Devula,
Thanks for the reply, but I know how to set an user defined env variable, I am sorry for my miscommunication but I just wanted to know is that enough or did u do something more as I my job is still getting aborted after doing that.

Thanks,
Abhi.

[ray.wurlod]

Either Roy or I need a name change!

Please, can someone give Roy some credit for some of my posts?