SAP on IBM i: FEMS Pushdown for Queries on DataStore Objects
You may remember my blog post about pushing down the evaluation of so-called “FEMS queries” into the Db2 for i database from September last year. If not, check it out here: SAP on IBM i: Pushing FEMS Queries to the Database Level.
Until now, the FEMS Pushdown support was limited to queries on Flat InfoCubes. With the corrections in SAP Note 2764474 – IBM i: BW: FEMS restriction pushdown on DSO, FEMS queries on DataStore objects have become eligible for FEMS Pushdown on Db2 for i as well.
The BW Sanity Checks (see also SAP on IBM i: Improvements in the BW Sanity Checks) in the DBA-Cockpit have also been adapted. They check now whether the FEMS Pushdown support for DataStore objects is installed in the monitored system. Because FEMS Pushdown is no longer a sole feature of Flat InfoCubes, the check of the FEMS Pushdown configuration has been moved from the checks for Flat InfoCubes to its own node. Call transaction DBACOCKPIT and follow the path Diagnostics -> BW Sanity Checks -> FEMS Pushdown to review the status of the FEMS Pushdown support.