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.
Waning in test, abort in prod
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
Double post Please answer the other one!
viewtopic.php?t=93979
viewtopic.php?t=93979
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
Re: Waning in test, abort in prod
diamondabhi wrote: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.
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
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.
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.
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
diamondabhi wrote: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
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: