Start Today

← Legacy to AI

Should the agent query DB2 in place or work from a copy?

The agent needs three DB2 tables. Should we copy them to Postgres, or query them where they sit?

If the system of record stays on the host, publish the tables from [[product:ol-coreiq|OL CoreIQ]], or turn a reviewed SELECT in [[product:ol-dataiq|OL DataIQ]] into a Hub API. Copy a slice when the agent needs joins you will not run on the host, or when you need test data. For VSAM and IMS, the approved copybook is the type source. JDBC metadata is not.

Read more