Connect DB2 UDB

Connect your DB2 UDB source to Bigeye.

1. Create a read-only user in DB2 UDB

Bigeye requires a read-only user for connecting to your database. Below is a sample for creating one.

create user bigeye_read_only with password '<password>';

2. Grant the read only user permissions

As the admin user on the user's home database, grant limited permissions by entering the following:

grant select on system table to bigeye_read_only;  
grant select on system view to bigeye_read_only;  
grant select on table to bigeye_read_only;  
grant select on view to bigeye_read_only;  
grant list on test to bigeye_read_only;

3. Test database connectivity

The example below shows a connectivity test for the bigeye_read_only user account:

 nzsql -u bigeye_read_only -pw <password> test

4. Review the DB2 UDB connector notes below

Below are the objects accessed by the DB2 UDB lineage connector.

syscat.bufferpools  
syscat.colchecks  
syscat.columns  
syscat.tabconst  
syscat.checks  
syscat.colauth  
syscat.dbauth  
syscat.wrappers  
syscat.indexcoluse  
syscat.indexauth  
syscat.indexes  
syscat.packageauth  
syscat.statements  
syscat.packages  
syscat.keycoluse  
syscat.procparms  
syscat.references  
syscat.tables  
syscat.schemaauth  
syscat.schemata  
syscat.procedures  
syscat.tabauth  
syscat.tbspaceauth  
syscat.tablespaces  
syscat.triggers  
syscat.datatypes  
syscat.functions  
syscat.views  
syscat.servers

5. Next Steps

After you've configured the source, Bigeye loads and profiles your tables. It can take up to 24 hours for the profiling to complete and your autometrics and autothresholds to populate. See how to deploy autometrics in the Getting Started guide.