I encountered a strange issue when deploying my Dictionary DC on PI 7.11 SP3 on AIX server, DBM: IBM DB2 9.7 SP1. The server threw the exception "Error while initiating runtime table Caused by: Table BC_DDDBTABLERT could not be created in database" in deployment progress.
I was in doubt that user used to deploy the DC does not have enough permissions to update (insert a new record in) the system table BC_DDDBTABLERT which is used to store metadata of tables created whenever Dictionary DCs are deployed.
There are other 6 systems which have the same PI/DB2/OS information/version and the Dictionary DC could be deployed successfully on them. I have also compared the permissions on the DB schema and authorization tables between the successful and failed systems (syscat.tabauth, syscat.schemaauth); there are no differences.
I have searched for an OSS note but no luck yet.
Could anyone tell me what I can do to fix this?
Any help is appreciated.
Thank you very much,