Your Doorstep to the Temple of Oracle

Oracle EBS

Basic information about Concurrent Managers

Posted by appsdba11i on March 17, 2011


1. CONCURRENT MANAGER BASICS

A. The ICM (Internal Concurrent Manager) controls all of the other
concurrent managers.

B. The Standard Manager accepts any and all requests. It has no
predefined specialization rules and is active all the time. It is not
recommended to add specialization rules to the standard manager as it
can cause problems.

C. The Conflict Resolution Manager resolves conflicts, such as request
incompatibilities.

2. STARTING THE CONCURRENT MANAGERS

A. There are two ways to determine if the concurrent managers are up and
running:

1. Log in to applications as System Administrator responsibility and
navigate to the concurrent manager administration page (Concurrent,
Manager, Administrator) and under the processes column if the
target and actual column equal the same number (above 0) this means
the managers are up and running.

2. You can also go into SQL*PLUS as APPS and run the following script:

SQL> @$FND_TOP/sql/afimchk.sql

This script will return output similar to the below:

Status Since Method
————————————– ——— ———– ——
Internal Conc Manager is running on – colapp03 05-MAR-99 06:41:32 PM LOCK

B. Use this syntax to start the concurrent managers from the command line:

Startmgr sysmgr=apps/apps (10.7 & 11.0)

adcmctl.sh apps/ start (11.5)

C. On Windows NT, the concurrent managers are started with a service.
This is created by using the following command:

cmsrvadm add [automatic/manual]

Please refer to the NT installation manuals for more detailed
information on this topic.

3. STOPPING THE CONCURRENT MANAGERS

You stop the concurrent managers from the command line:

CONCSUB apps/apps SYSADMIN ‘System Administrator’ SYSADMIN CONCURRENT FND
DEACTIVATE or ABORT

DEACTIVATE tells the managers to complete processing of any running
requests before terminating. This is a cleaner way of bringing down the
managers.

ABORT tells the managers to terminate the managers immediately.
When the concurrent managers are terminated through the abort command,
the jobs that they were running will be returned to pending status.

adcmctl.sh apps/ stop (11.5)

On NT you need to stop the service.

4. LOCATION OF CONCURRENT MANAGER LOG FILES

A. The concurrent manager log files can be located in one of the following
places:

1. If the environment variable $APPLCSF is set, the default location
is $APPLCSF/$APPLLOG

2. If the environment variable $APPLCSF is not set, the logs go to
$FND_TOP/$APPLLOG

The default name of the concurrent manager log files is std.mgr. You
can change these by setting the parameter logfile=.

3. On NT the log files are called CM_.LOG

B. The logfile= parameters can be appended for additional
functionality. This parameter allows you to specify the name of the
log file. The default name of the log file is std.mgr.

C. The Diag=Y parameter allows you to add debugging information into the
concurrent log files for troubleshooting.

Manager Log Files:

Standard manager log: w.mgr
Transaction manager log: t.mgr
Conflict Resolution manager log: c.mgr

Where: is the concurrent process id of the manager

5. FNDLIBR PROCESSES ON THE SERVER MACHINE

When the concurrent managers are up, they create an FNDLIBR process on the
server machine. If the concurrent managers are up, one FNDLIBR process
will appear for the ICM and each Standard manager that is defined.

On UNIX, you can locate this FNDLIBR process by doing the following:

ps -ef | grep -i FNDLIBR

On NT, you check the task manager, under the processes tab to see the
FNDLIBR process.

6. Please reference Note 134007.1 cmclean.sql & Note 171855.1 Diagnostic Script for Concurrent Manager.

7. PMON METHOD INFORMATION

Ensure that the PMON method is set to LOCK. Using the LOCK method has been
recommended since Version 10.6.

You will usually have one of two settings for PMON:

1. RDBMS= the internal manager queries against fnd_v$process to
retrieve the session id and the operating system process id.

2. LOCK= the internal concurrent manager tries to lock on the process
it is monitoring.

If you use the diag=y option in your start manager command then the PMON
method being used will be written on the first page of the log file.

To change the PMON method do the following in sqlplus as APPLSYS:

1. SQL> @$FND_TOP/sql/afimpmon.sql (10.7)

The following line will appear:

“If you wish to continue type the word ‘dual’:”

Type: dual.
Enter value for 1:
Type: LOCK

2. SQL> @$FND_TOP/sql/afimpmon.sql (11.0)

The afimpmon.sql script was updated to prompt only for one parameter,
‘dual’ and then automatically changes the PMON method to LOCK.

8. 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 & 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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: