Metadata extraction from DB2 z/OS is always read-only. The process does not modify data but requires access to system tables to retrieve advanced metadata, such as the SQL definitions of views and stored procedures.
Note: The metadata extraction is available
only with Advanced Conectivity Bundle (ACB) entitlement.
-
Required permissions:
- The user must have read-only access to DB2 system tables.
- The exact minimal set of permissions varies by DB2 type and version; therefore, no universal grant list can be provided.
- In practice, a Database Administrator (DBA) must be involved to provision a user with sufficient access.
-
Recommended approach:
Initial validation
- Test the metadata extraction using a full Sys Admin account (with all permissions).
This ensures the process works correctly against the target database.
Privilege reduction
Once validated, the DBA can create a dedicated user with reduced, read-only privileges that still allows successful metadata extraction.
Note: The permission requirements described
here are subject to change depending on the database
version, configuration, and future updates.