SEND MANAGER

Use SEND MANAGER to retrieve the status of the active Manager process or to retrieve dynamic port information as configured in the Manager parameter file.

Syntax

SEND MANAGER
[CHILDSTATUS [DEBUG]]
[GETPORTINFO [DETAIL]
[GETPURGEOLDEXTRACTS]

CHILDSTATUS [DEBUG]: For the CHILDSTATUS, GETPORTINFO commands the PORT field is the Unix Domain Socket. The value listed in the PORT field is the system file that contains the properties for the Unix Domain Socket communication.
GETPORTINFO [DETAIL]: By default, retrieves the current list of ports that have been allocated to processes and their corresponding process IDs. DETAIL provides a list of all the ports defined using the DYNAMICPORTLIST parameter.
GETPURGEOLDEXTRACTS: Displays information about trail maintenance rules that are set with the PURGEOLDEXTRACTS parameter in the Manager parameter file, see PURGEOLDEXTRACTS for Extract and Replicat.

Examples

SEND MANAGER CHILDSTATUS DEBUG returns a child process status similar to the following. The basic CHILDSTATUS option returns the same display, without the Port column.

ID  Group   Process  Retry  Retry Time      Start Time               Port
1   EXTA    6524     0      None         2019/09/30 07:17:51      /ogg/19.1/dirtmp/EXTA.s
2   EXTP    6525     0      None         2019/09/30 07:17:51      /ogg/19.1/dirtmp/EXTP.s
3   REPA    6526     0      None         2019/09/30 07:17:51      /ogg/19.1/dirtmp/REPA.s

SEND MANAGER GETPORTINFO DETAIL returns a dynamic port list similar to the following.

Entry  Port                         Error   Process   Assigned             Program
0      /ogg/19.1/dirtmp/EXTA.s       0       4533     2019/09/30 07:17:51
1      /ogg/19.1/dirtmp/EXTP.s       0                2019/09/30 07:17:51
2      /ogg/19.1/dirtmp/REPA.s       0                2019/09/30 07:17:51

SEND MANAGER GETPURGEOLDEXTRACTS outputs information similar to the following.

PurgeOldExtracts Rules
Fileset                      MinHours MaxHours MinFiles MaxFiles UseCP
S:\GGS\DIRDAT\EXTTRAIL\P4\*         0        0        1        0     Y
S:\GGS\DIRDAT\EXTTRAIL\P2\*         0        0        1        0     Y
S:\GGS\DIRDAT\EXTTRAIL\P1\*         0        0        1        0     Y
S:\GGS\DIRDAT\REPTRAIL\P4\*         0        0        1        0     Y
S:\GGS\DIRDAT\REPTRAIL\P2\*         0        0        1        0     Y
S:\GGS\DIRDAT\REPTRAIL\P1\*         0        0        1        0     Y
OK
Extract Trails
Filename                        Oldest_Chkpt_Seqno  IsTable  IsVamTwoPhaseCommit
S:\GGS\8020\DIRDAT\RT                         3        0        0
S:\GGS\8020\DIRDAT\REPTRAIL\P1\RT            13        0        0
S:\GGS\8020\DIRDAT\REPTRAIL\P2\RT            13        0        0
S:\GGS\8020\DIRDAT\REPTRAIL\P4\RT            13        0        0
S:\GGS\8020\DIRDAT\EXTTRAIL\P1\ET            14        0        0
S:\GGS\8020\DIRDAT\EXTTRAIL\P2\ET            14        0        0
S:\GGS\8020\DIRDAT\EXTTRAIL\P4\ET            14        0        0