Topic
1 reply Latest Post - ‏2012-10-01T09:50:07Z by mgudmund
jgubler
jgubler
1 Post
ACCEPTED ANSWER

Pinned topic IDMT Error in migration from DB2 LUW 9.5.5 to DB2 LUW 10 -SYSCAT.MODULEAUTH

‏2012-07-10T16:19:22Z |
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.

The SELECT:
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?
Updated on 2012-10-01T09:50:07Z at 2012-10-01T09:50:07Z by mgudmund
  • mgudmund
    mgudmund
    1 Post
    ACCEPTED ANSWER

    Re: IDMT Error in migration from DB2 LUW 9.5.5 to DB2 LUW 10 -SYSCAT.MODULEAUTH

    ‏2012-10-01T09:50:07Z  in response to jgubler
    Hi!
    Same error message here, but moving from 9.5 to 9.7.

    Did you ever solve it?

    Br, Martin