Copy one table so the agent can practice off production DB2
We want the agent to practice on a copy of one table, not on production DB2. How do we move just that table?
Export the schema onto the target connection. You can drop the target table first if you mean to replace it. From the SELECT, export the dataset into that table with a record limit. That is a test-data copy. It is not a migration of the system of record, and it does not empty the host file.