Using P8 Enterprise Manager

The P8 Enterprise Manager administration application is useful tool for both examining details about deployed IBM InfoSphere Enterprise Records class and property schemas and in providing the capacity to test SQL query statements.

Common IBM InfoSphere Enterprise Records classes

The following paths refer to the hierarchy displayed in the Enterprise Manager tree view. These paths represent the more common IBM InfoSphere Enterprise Records schema classes used in report queries.

Using P8 Enterprise Manager to Test Report Queries

The P8 Enterprise Manager Query Builder feature is helpful in developing and testing P8 CM SQL query statements.

To access the Query Builder feature

  1. In Enterprise Manager, right-click the Object Stores | <object store> | Search Results tree view node.
  2. Select New Search from the context menu.
  3. On the View menu, select SQL View to change the Query Builder view to the free form SQL text entry form.

When using the P8 Enterprise Manager Query Builder, the first SELECT statement item must be the "This" object reference pertaining to the primary table involved in the query. For example, the following report SQL statement:

SELECT ri.DocumentTitle, ri.DateCreated
FROM RecordInfo ri
WHERE ri.Format LIKE 'Regulator Data%'

must be changed to:

SELECT ri.This, ri.DocumentTitle, ri.DateCreated
FROM RecordInfo ri
WHERE ri.Format LIKE 'Regulator Data%'

in order to test the SQL statement with P8 Enterprise Manager Query Builder. When supplying literal date/time values, P8 CM SQL syntax requires the use of the ISO format YYYYMMDDhhmmss[,ffff]Z or the W3C format YYYY-MM-DD[Thh:mm:ss[.ffff]][<timezone>  as in

WHERE ri.DateLastModified >= 20080324T112334Z
  AND ri.DateLastModified <= 2009-02-12