On webMethods running on SQL databases, which database and table do I find all the processes data. That is I created my own service and BPM e.g. createEmployee. I want to see the payload data,field, correlationID,startTime,EndTime etc.
In my opinion getting data directly from WM SQL tables are NOT a good idea.
Answer on your question depends on purpose do you want to use this informations.
Using in BPM? Check out methods in WmPRT package and read documentation - “Administering_Process_Engine”.
Real time monitoring? Look at MWS administration webpage and find Business Process Instances.
Extended raporting? I usually inserted into process “technical” step - IS service which insert/update data in external database.
Log into the product database and look for PRA_* and PRT* tables.