When adding DB2 data connections to iSeries DB2 platform (AS/400), for the connection to your repository to be properly configured, you must modify the Trillium config.txt file by adding the entry value iseries 1 to the end of the key rdbms section. For example:
key rdbms {
value uncommitted_read "off"
value records_read 100
value records_read_odbc 1
value iseries 1
}Make this change either before or after you add the loader connection in the Repository Manager, but use the connection only after the change.
The config.txt file is located in the server install directory on your Trillium server system. On Linux this directory is install_path/metabase/etc.