CM Monitoring and Diagnostic Scripts

HELPFUL DIAGNOSTIC SCRIPTS

The following SQL scripts located under $FND_TOP/sql are useful when diagnosing concurrent manager problems:

1. afimchk.sql Tells the status of the ICM and PMON method

2. afcmstat.sql Lists active manager processes

3. afrqrun.sql Lists all the running, waiting and terminating requests

4. afrqwait.sql Lists requests that are constrained and waiting for the ICM to release them

5. afrqscm.sql Prints log file name of managers that can run a given request. It can be used to check for possible errors when a request stays in pending status. It requires a request id value.

6. afcmcreq.sql Prints the log file name of the manager that processed the request

7. afrqstat.sql Summary of completed concurrent requests grouped by completion status and execution type. It requires number of days prior to today on which to report parameter.

8. afimlock.sql Lists locks that the ICM is waiting to get

9. afcmrrq.sql Lists managers that currently are running a request

CONCURRENT MANAGER MONITORING SCRIPTS

1. afcmclean.sql SQL script to clean the Concurrent Manager tables

2. analyzereq.sql SQL script to analyze a concurrent request - Sample output

3. cproginfo.sql SQL script to list info about a concurrent program

4. ccmlocks.sql SQL script to list RDBMS locks held by concurrent processes

5. cmlogs.sh Shell script to gather all logfiles related to a concurrent request

6. reqinfo.sql All you ever wanted to know about a concurrent request

7. fnd_file_test.sh Shell script to test the setup needed for the FND_FILE package.

8. AFFTEST.pls PL/SQL procedure to test the setup needed for the FND_FILE package.

9. aftmtst SQL scripts for testing basic transaction manager functionality. (skip)

10. multisub Shell script submits multiple requests using CONCSUB

11. chkreqs.sql SQL script lists concurrent request totals

12. flexinfo.sql SQL script lists flexfields information

13. getinc.sql SQL script to list a concurrent program's incompatibilities

14. whocanrun.sql SQL script lists the responsibilities that can run a given concurrent program