I would like to perform a check of Data Partitions and Stored Queries that exist in my Service Desk Manager environment to ensure that no Cartesian errors exist. Is there a command I can use to perform this task?
CA Service Desk Manager
To ensure that your data partition constraint does not produce a Cartesian product join, enter the following command:
bop_cmd -f $NX_ROOT\bopcfg\interp\bop_diag.frg "check_queries()"
op_cmd -f $NX_ROOT/bopcfg/interp/bop_diag.frg "check_queries()"
When a data partitions or stored query is created in Service Desk Manager a Cartesian check is performed at the point of saving. The command outlined in this document may be useful if data partitions or stored queries were loaded into the environment that by-passed the built in system check (perhaps with a pdm_load). Under normal circumstances this command would not typically be needed.
More information on data partitions is located at How to Setup Data Partitions