DSXchange

Hi,

Job design

DB2 API Stage--->> TFM --->> Seq file stage

While running a parallel job with the above design i get the below message. Am just reading all records from a DB2 table on mainframes and a direct mapping to Seq file stage on Unix AIX box

DS CLient : DS 7.5.2 on Windows
DS Server : DS 7.5.2 on AIX

Copy_of_DB2_UDB_ASSET_T,0: Fatal Error: Fatal: [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
Krishna

Hi,
Have you tried performing a search?

kumar_s wrote:Hi,
Have you tried performing a search?

Hi,

I could not find topics related to my problem. Could you please help me

Thanks
Krishna

Looks like you are missing some important variables. Check this out.
Also if you do a google on your sql number, you will get so many results. That will definately help you.

Hi Krishna,
Click on the blue word given on the both of the post. You ll be diverted to a new page where you can get the releven informations.

kumar_s wrote:Hi Krishna,
Click on the blue word given on the both of the post. You ll be diverted to a new page where you can get the releven informations.

Hi,

I tried the links given in the post. The strange thing abt this problem is ...I could read from the DB2 table and the job runs fine if i choose some other table. For this particular table i get the error and it confirms the fact that i have select privileges on system tables. Please provide me the solution to this.

Thanks
Krishna

Krishna,

there are about 13 stored procedures in DB2 V8, names are like SYSIBM.SQLxxxxx, which need to be implemented/activated for DS DB2-plugin to work properly for metadate retrieval.

Please have your DBA check if all these stored procedures are activated and you have the proper rights to execute them.

Best regards

Klaus

Klaus Schaefer wrote:Krishna,

there are about 13 stored procedures in DB2 V8, names are like SYSIBM.SQLxxxxx, which need to be implemented/activated for DS DB2-plugin to work properly for metadate retrieval.

Please have your DBA check if all these stored procedures are activated and you have the proper rights to execute them.

Best regards

Klaus

The Db2 version we have is 7. Do i still need to be activated for procedures?

Thanks
Krishna

Hi Ray,

Can you tell me the possible reason for the error?

thanks
Krishna

Search in google based on the SQLSTATE gives the following And by db2 for SQL0471N is So is it not possible to come to a wauge idea with this.

kumar_s wrote:Search in google based on the SQLSTATE gives the following

Code: Select all

INVOCATION OF FUNCTION OR PROCEDURE name FAILED DUE TO REASON rc 

Explanation: A routine was invoked. The routine invocation was not 
accepted because of DB2 reason code rc. 

And by db2 for SQL0471N is

Code: Select all

SQL0471N Invocation of routine "<name>" failed due to reason
          "<reason-code>".

Explanation:

A routine "<name>" was invoked on a DB2 Universal Database for
OS/390 server.  The routine invocation failed because of the
condition described by DB2 reason code "<reason-code>".

 The statement cannot be executed. A DSNX9xx message describing
the error might be displayed on the MVS system console.

User Response:

 Consult the documentation for the DB2 Universal Database for
OS/390 server and correct the condition described by the DB2
reason code.

 sqlcode :  -471

 sqlstate :  55023

So is it not possible to come to a wauge idea with this.

Please let me know the work around for this problem.

Thanks
Krishna

Consult the documentation for the DB2 Universal Database for
OS/390 server and correct the condition described by the DB2
reason code.

This is not a DataStage problem.