Hello community,

I am installing a new BSE test environment as a copy of an existing BSE and have problems importing the tables. The idea is to use the same database as the original BSE but import the tables under a different owner/schema.
Database is Informix and the application is LN. What I did is:

1) Copy $BSE, modify pathnames and start the new environment (rc.start)
2) Create a new schema owner/user and role
3) Grant dba permissions and role to the schema user
4) Modify files under $BSE/lib/informix (inf_users, inf_group, inf_storage_param)
5) Check db_resource, bse_vars, tabledef6.2

When I import a table with bdbpost, I get "Can't lock table - Error 329 - Database not found or no system persmissions". But when I connect through dbaccess, I can create or drop tables.

Any ideas ?

Regards,

Mario

Problem is solved. I had to create a new "database" in Informix, then the import succeeded.
It's been a while since I last did this under Informix. I hope I will remember it next time ;-)

mario