Error: User(s) not able to import metadata on schema with more than 500 tables with an error message
When user tries scanning metadata from DB2 - iSeries, scanning fails when schema scan more than 500 tables and error message reflects as "Undefined".
Right click on that specific environment (from which you're trying to scan metadata from DB2 - iSeries) and then click on "Edit Environment". Please follow the below steps:
- Click on the gear icon and then select the check-box for the Test Connection Query and provide "SELECT 1" for the value and then hit Ok icon to save. Attached snapshot(s) for your reference
- Change the Connection Pool Type from HIKARICP to BONECP and then save the connection parameters. Attached snapshot for reference
- Click on the Test connection icon, to check if the connection is successful and then click on "Save and Continue" button to view the schemas
- Try selecting the schemas and then hit the save button to check if the scanning gets completed and user is able to view all the required tables/ columns across that specific environment.
If there are any issues or questions feel free to open a ticket with support: https://support.erwin.com/hc/en-us/requests/new