I'm trying to use IDMT to migrate some schemas from an DB2 9.5 to DB2 10.
I could use another solution, like making a backup/restore, but I'm testing the IDMT capabilities.
I get the folowwing error running the "unload" script (LINUX).
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.MODULEAUTH, DRIVER=3.63.123
This table doesn't exists on DB2 9.5.
WITH AUTH AS ( SELECT granteetype, grantee, tabname as name, CAST(NULL AS VARCHAR(128)) AS colname, auth, 'TABLE' as type FROM SYSCAT.TABAUTH, LATERAL(VALUES (case when controlauth = 'Y' then 'CONTROL' else NULL end),
UNION ALL SELECT granteetype, grantee, MODULENAME as name, CAST(NULL AS VARCHAR(128)) AS colname, (case when EXECUTEAUTH = 'Y' then 'MODULE' when EXECUTEAUTH = 'N' then NULL else 'EXECUTE GRANT' end) auth, 'EXECUTE' as type FROM SYSCAT.MODULEAUTH WHERE MODULESCHEMA = 'GRAVADOR' UNION ALL SELECT granteetype, grantee, rolename as name, CAST(NULL AS VARCHAR(128)) AS colname, (case when admin = 'Y' then 'ROLE GRANT' else 'ROLE' end) auth, 'ROLE' as type FROM SYSCAT.ROLEAUTH WHERE grantor = 'GRAVADOR' and rolename NOT LIKE 'SYSROLE%' ) SELECT * FROM AUTH WHERE AUTH IS NOT NULL ORDER BY CASE type WHEN 'SCHEMA' THEN 1 WHEN 'TABLE' THEN 2 WHEN 'COLUMN' THEN 3 ELSE 4 END
Any suggestion to solve this problem?
This topic has been locked.
1 reply Latest Post - 2012-10-01T09:50:07Z by mgudmund
Pinned topic IDMT Error in migration from DB2 LUW 9.5.5 to DB2 LUW 10 -SYSCAT.MODULEAUTH
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-01T09:50:07Z at 2012-10-01T09:50:07Z by mgudmund