I am in the process of restoring a DB2 Database and am encountering this problem and I have not found a way to fix the problem. In a LINUX environment I am running the DB2 Administrative Tools and am getting a problem with the migration portion of the restore process. It is Error 1704N Reason #9 (table space access is not allowed).
Is there something I am not looking at, or any commands I can run to see if the user I am logged in as has the proper rights to this newly created database?
Thanks in Advance, - John