Manager commands

1.1 Manager commands

The Manager module must be running for other Oracle GoldenGate components to operate. The process ensures proper startup, monitoring, and other activities. Once you start the Manager process, you can:

Determine whether the Manager process is running
Retrieve information about the running Manager process
Stop the process

The Manager process ($GGMGR), runs as a NonStop process pair that includes the process ($GGMGR) and a child process ($GGMGX).

You can change the default process name from $GGMGR to another name. To change this and other default settings, see Changing Default Component Names.

1.1.1 INFO MANAGER

Use INFO MANAGER to determine whether the Manager process is running. If Manager is running, the process name, port number, TCPIP process, and IP address may be displayed depending on the parameters set for Manager.

Syntax

INFO MANAGER

Example

The following examples show different displays for the INFO MANAGER command.

Example 1

If the IP port is not configured, the display will be similar to:

Manager process $GGMGR is running.
(IP port not configured).

Example 2

If the TCPIP process name and port are configured, the display will be similar to:

Manager process $GGMGR is running 
(Process \NY.$ZTC1, port 7830).

Example 3

If the IP port, TCPIP process name, and IPINTERFACE are all configured, the display will be similar to one of the following:

Manager process $GGMGR is running 
(Process \NY.$ZTC1, IP 192.0.2.1 port 7830).

Manager process $GGMGR is running 
(Process \NY.$ZTC1, IP 2001:db8:2010:5040:4fff:ffff:ffff:28 port 7830).

1.1.2 SEND MANAGER

Use SEND MANAGER to communicate with the current Manager process.

Syntax

SEND MANAGER 
{CHILDSTATUS | 
GETPORTINFO [DETAIL] | 
GETPURGEOLDEXTRACTS |
KILL process_name}

CHILDSTATUS

Displays information about all processes started by Manager.

GETPORTINFO [DETAIL]

Retrieves the status of ports in use. Also returns statistical information about port sessions.

Include DETAIL with GETPORTINFO to retrieve information about all dynamically allocated ports, regardless of whether they are in use, as in:

SEND MANAGER, GETPORTINFO DETAIL

GETPURGEOLDEXTRACTS

Displays information about trail maintenance rules set with the PURGEOLDEXTRACTS parameter in the Manager parameter file. For more information about PURGEOLDEXTRACTS, see "PRIORITY".

KILL process_name

Stops a process that was previously created by Manager. Manager returns an error if the process is not one it created.

Examples

Example 1

SEND MANAGER CHILDSTATUS returns a child process status similar to the following.

ID  Process         Retry   Retry Time         When added
--- --------------- ------- ----- ------------ -------------------
  3 \NY.$GGS03      0,0512      0 None         2014/08/16 14:39:07

Example 2

SEND MANAGER GETPURGEOLDEXTRACTS returns a report similar to the following:

PurgeOldExtracts Rules
Fileset                       MinHours  MinFiles     UseCP
$DATA04.GGSDAT.HT*                   0         1       Y
$DATA04.GGSDAT.ET*                   0         1       Y

Extract Trails
Filename                    Group    Oldest Seqno MinHours 
\NY.$DATA04.GGSDAT.ET       REPACL              0        0 
\NY.$DATA04.GGSDAT.HT       ACTHIST             0        0 
\NY.$DATA04.GGSDAT.LT       ACRLOG              0        0 
\NY.$DATA04.GGSLOG.LT       ACELOG              0        0

1.1.3 START MANAGER

Use START MANAGER to start the Manager process.

Syntax

START MANAGER 
[, CPU primary_cpu]
[, BACKUPCPU backup_cpu] 
[, PRI priority]

CPU primary_cpu: The primary CPU name.
BACKUPCPU backup_cpu: The backup CPU name. If a backup CPU is specified in the Manager parameter file, it overrides any START MANAGER backup CPU specification.
PRI priority: Sets the NonStop priority of the process.

Example

 START MANAGER, CPU 1, BACKUPCPU 3, PRI 170

1.1.4 STATUS MANAGER

Use STATUS MANAGER to determine whether the Manager process is running and to identify its characteristics.

Syntax

STATUS MANAGER

Example

The command STATUS MANAGER will display the Manager process name, the running process, and the port number as shown below.

Manager process $ACMGR is running (IP \NY.$ZTC1 port 7670)

If a specific IP address or DNS name has been assigned using IPINTERFACE, it will be included as shown below.

Manager process $ACMGR is running (IP \NY.$ZTC1 192.0.2.2 port 7670)

1.1.5 STOP MANAGER

Use STOP MANAGER to stop the Manager process. You will be asked to confirm this command, since stopping Manager eliminates important activities. GGSCI logs STOP MANAGER commands to the Oracle GoldenGate event log.

Syntax

STOP MANAGER [!]

!: Unless you specify the exclamation point (!), you must confirm this operation.