Error retrieving system catalog information for requested ta

[shivadas]

Hi,

We are getting the following message while trying to run a job that uses the Db2 stage.

APT_CombinedOperatorController(2),0: Fatal Error: Fatal: [IBM][CLI Driver][DB2/6000] SQL0444N Routine "SQLTABLES" (specific name "TABLES") is implemented with code in library or path ".../sqllib/function/unfenced/db2schema", function "sqltables" which cannot be accessed. Reason code: "9". SQLSTATE=42724
SQLTables: Error retrieving system catalog information for requested tables(s).

Could any one help on this?

Thanks.

[ArndW]

My first guess is that you have not allocated sufficient table privileges for DB2 in your instance. PX requires the following:

2 Grant the DataStage users SELECT privileges on the system tables
syscat.nodegroupdef, syscat.tablespaces, and syscat.tables.

3 Make the file db2nodes.cfg readable by the DataStage
administrative user.

4 DataStage runs many processes for each job. This can require the
system administrator to modify DB2 resources, configuration
parameters, and manager configuration parameters of your
system. See the DB2 administration manuals for more
information.

5 The DB2/UDB Enterprise stage requires that users invoking it in
load mode have DBADM privilege on the DB2 database written to
by the stage. Among the ways to grant this privilege is to start
DB2, connect to a database, and grant privileges as follows:
db2> CONNECT TO database_name
db2> GRANT DBADM ON DATABASE TO USER user_name