qualifier Table and DataDeploy

Hi!
may it possible indicate a different qualifier table using iwdd.ipl script?

Find more posts tagged with

Comments

your question is not very clear. can you elaborate? if you meant specifying a table name in the DD config file with qualifiers., that should be ok.

carletto

is it possible to use a table qualifier different from the one you use fot the login account to the database ?

carletto

I connect to a DB2 DataBase using JDBC NET version drivers, and my account is "BP";

These follow tables
IWOV_IDMAPS
IWDELTRACKER
IWTRACKER
was created from user called "PT".
so full name are
PT.IWOV_IDMAPS
PT.IWDELTRACKER
PT.IWTRACKER

DataDeploy connect correctly
but when it access to IWOV_IDMAPS use "BP" how qualifier of table and DB2 log this message error:

SQLException occured in TIdentifierMappingtable::BuildMappingCache()
Exception Message: [IBM][CLI Driver][DB2]SQL0204N "BP.IWOV_IDMAPS" is an undefined name. SQLSTATE=42704

I can't use "BP" account for Create Table.

Migrateduser

If you are using DD55x then you can specify the overriding CREATE TABLE statements for these internal tables that DD creates. Or you can create the these tables ahead of time as the PT user and create synonyms for BP user?

It seems to me like when you ran DD for the first time, the login user was PT and then you decided to change the login user to BP for subsequent deployments. If that's the case, I guess the only way to override the default lookup is to create the synonym for the BP user.