Permissions
The user defined in the endpoint settings must have the following permissions on the target database:
-
EXECUTE ON PACKAGE SYSIBM.DSNUTILU (ZLOAD)
-
LOAD ON DATABASE
-
EXECUTE ON PACKAGE NULLID.* (ODBC)
-
SELECT ON SYSIBM.* (CATALOG)
-
CREATETS ON DATABASE
-
CREATETAB ON DATABASE
-
INDEX ON TABLE
-
ALTER ON TABLE
-
DROP ON TABLE
-
SELECT ON TABLE
-
INSERT ON TABLE
-
DELETE ON TABLE
-
UPDATE ON TABLE
-
CREATEALIAS (only required when replicating tables whose names contain non-English letters)