AS400 Table lists were not getting populated and system hangs for hours

Error - AS400 Table lists were not getting populated and system hangs for hours.

Reason - AS400 tables expected to be huge and binded with thousand of tables related to N number of schemas. So, while populating it takes hours to get the table extracted from that server. So, if we specify the server and schemas to be used for import in db2cli.ini then the performance would be significantly faster.

Resolution - Add entries like below in the file using db2 userid and password.

%DB2_DIR%/sqllib/cfg/ db2cli.ini
[DUBLIN2]
SchemaList='CRPLIB','MIFDATA20', ...

Incase you want to trace the output of the connection you can add the below 3 lines to check.
[COMMON]
Trace=1
TraceFileName=/tmp/db2clitrace
TraceFlush=1