Technote (troubleshooting)
Problem(Abstract)
Database Issues in Sterling B2B Integrator - data required by support team
Symptom
If problems occur with your Database System in Sterling B2B Integrator, e.g. performance or growth issues, Please collect the information mentioned below and attach it to the new PMR
Cause
| DBStat Report | In the Web-UI of the Product, go to Operations -> Reports Page and search for 'DBStat'. Click on source manager and then get the report in either PDF/HTML format. |
| Document Storage Type | check the jdbc.properties for the key "defaultDocumentStorageType". Also pay attention to possible overrides in customer_overrides.properties. Send both files to support. |
| Global Persistence Level | check the value for global persistence Level in noapp.properties_gis_ext.in. Send file to support. |
| BP and Document Lifespan | Please create a screenshot in the Web-UI of Operations->Archive Manager |
| Check system BPs | Check if the following BPs are enabled and running without errors
|
| DataSweeper | If the Datasweepter is installed, please collect the results of it and send to support. |
| Removal Method | What removal Method is configured, Archive first or Purge directly? |
| Business Process Status | Check the system for Business Processes that have a final status other than Completed or Terminated. Attach a screenshot from the GUI:- Operations->System-> Troubleshooter->Business Process Usage page |
| Screenshots of config |
|
| Mailbox usage | Does the system use:-
|
| Growing Tables | Are the WORKFLOW_CONTEXT , DOCUMENT , CORRELATION_SET or TRANS_DATA tables growing? How many new lines were added to these tables in the last 24 hours. Size of the LOB segment for TRANS_DATA. |
| DB2 LUW reports | Generate a db2support report from the database manager. See http://www-01.ibm.com/support/docview.wss?uid=swg21619551 |
| Oracle reports | Generate an Oracle AWR from the database manager and check the database logs. |
| MS SQL server | Check the database logs. |
| Directories | Attach the <install>/logs and <install>/properties directory to the PMR |
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.