Error While reading from DB2 table on mainframe

sairamkrish · Post by **sairamkrish** » Fri May 19, 2006 5:49 am

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

kumar_s · Post by **kumar_s** » Fri May 19, 2006 6:26 am

Hi,
Have you tried performing a search?

sairamkrish · Post by **sairamkrish** » Mon May 22, 2006 3:35 am

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

DSguru2B · Post by **DSguru2B** » Mon May 22, 2006 6:57 am

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.

kumar_s · Post by **kumar_s** » Mon May 22, 2006 7:29 am

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.

sairamkrish · Post by **sairamkrish** » Tue May 23, 2006 12:06 am

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

Klaus Schaefer · Post by **Klaus Schaefer** » Tue May 23, 2006 6:03 am

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

sairamkrish · Post by **sairamkrish** » Thu May 25, 2006 3:39 am

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

sairamkrish · Post by **sairamkrish** » Tue May 30, 2006 4:41 am

Hi Ray,

Can you tell me the possible reason for the error?

thanks
Krishna

kumar_s · Post by **kumar_s** » Tue May 30, 2006 6:02 am

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.

sairamkrish · Post by **sairamkrish** » Tue May 30, 2006 7:28 am

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

ray.wurlod · Post by **ray.wurlod** » Tue May 30, 2006 4:30 pm

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.