Clarify Scenario:

We configured the Clarify Datasource to the proper iSeries Lirbary and we see the table under Schemas.

Clarify Issue:

When we start the database monitor we get the error Logicalfile in LIBNAME not correct type..

Server Error:

Auditor:

call EXTOLDBMON.EXTOL_DBM_INSERT_SP('com.abc.edi.Logistics.outbound.StatusDetails315.LogisitcsOutbound315DBM', 'jdbc:as400://1.1.50.', 'com.abc.edi.Logistics.outbound.StatusDetails315.LogisticsOutbound315LaunchEventEV', 'LIBNAME', 'http://1.1.1.1:8081/dbmonitor/DatabaseMonitor?eventName=com.abc.edi.Logistics.outbound.StatusDetails315.LogisticsOutbound315LaunchEventEV&databaseUrl=jdbc%3Aas400%3A%2F%2F1.1.1.1&databaseAction=INSERT&datasourceDesc=com.abc.core.DatabaseObjects.DataSources.As400SmlfqaDS&databaseTable=EDHEREO3&databaseMonitorName=com.abc.edi.Logistics.outbound.StatusDetails315.LogisitcsOutbound315DBM', 1, varNew);
END
03/07/2017 - 08:49:53.582 AM [ERROR] Exception occurred while STARTING Database Monitor: [SQL0156] logicalfile in LIBNAME not correct type..
03/07/2017 - 08:49:53.582 AM [ERROR] sqlstate = 42809

Clarify Resolution:

The AS400/iSeries OS only supports triggers on physical file, not logical files. We assigned a physical file to the database insert trigger and it worked.
For more assistance or overview of Cleo Clarify 4.6+, please feel free to CONTACT OUR GROUP.