Warning while importing metadata from DB2

kalimuddin · Post by **kalimuddin** » Thu Aug 31, 2006 3:52 am

Hello,

I am trying to import table from DB2, it is giving warning No columns in TABLE NAME - not imported. I am importing through import--plugin metadata--DB2. I can see all the tables there but when i am clicking import i am getting this warning. When i opened DB2 i can see the table and columns there. Two days ago i imported the table for another project i was succesful, I also designed job using that, When i run those jobs today its working fine,its deleting, inserting. But the problem is its not allowing to import the table to any project, not alone this single table i tried importing other tables also its not working giving me the same warrning. Do give me a better solution to rectify this.

Thanks & Regards,
Kalimuddin.

ArndW · Post by **ArndW** » Thu Aug 31, 2006 4:18 am

Often this is because your userid in DB/2 doesn't have sufficient access rights to read the table metadata. I am assuming that you have set up DataStage PX access correctly since it does work in another project.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 31, 2006 6:03 pm

You need SELECT privilege to a number of system tables in DB2 to be able to import table definitions from DB2. Search the forum to discover which system tables they are.

kalimuddin · Post by **kalimuddin** » Fri Sep 01, 2006 12:45 am

ray.wurlod wrote:You need SELECT privilege to a number of system tables in DB2 to be able to import table definitions from DB2. Search the forum to discover which system tables they are. ...

I have given the privilege to all the tables which are needed. This I did at the time when i created those tables. But the problem started from yesterday.When i checked the privilege its granted. But still i am getting the same warning while importing.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 01, 2006 2:48 am

System tables. You don't create system tables.

ArndW · Post by **ArndW** » Fri Sep 01, 2006 3:29 am

Per the upgrade/install guide, make sure of the following (particularly #2):

1 Install DB2 and make sure it is working properly.

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

peterbaun · Post by **peterbaun** » Fri Sep 01, 2006 4:02 am

Hi -

Besides being a permission issue it could also be related to the DB2 Connect parameter named SCHEMALIST. The name of the database(s) that you extract metadata from should be in SCHEMALIST.

Regards
Peter

kalimuddin · Post by **kalimuddin** » Sat Sep 02, 2006 5:23 am

Thank you gentelmen with your help i tried to correct it.Its working now.

ArndW · Post by **ArndW** » Sat Sep 02, 2006 9:27 am

Do you know which the suggestions worked for you and could you post that so that this thread can help future DSXchange users?
Thanks!

kalimuddin · Post by **kalimuddin** » Sat Sep 02, 2006 11:26 pm

ArndW wrote:Per the upgrade/install guide, make sure of the following (particularly #2):

1 Install DB2 and make sure it is working properly.

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

This is the one which helped me.
Thanks & Regard,
Kalimuddin.

ray.wurlod · Post by **ray.wurlod** » Sun Sep 03, 2006 1:07 am

That's the information I was trying to remember when I kept going on about system tables. Clearly it's important. But when one is in an internet cafe paying for connection time one does not really want to spend it searching.