The Data Exchange OS 2200 Director is a background server, which provides an interface for the Administrative Service and the DDW.
The Administrative Service makes service requests to the Director for the following actions:
Start/Stop/Monitor each Application Group specific OS 2200 Agent.
Start/Stop/Monitor the RDMS data extraction phase of a bulk data transformation.
The DDW makes a service request to the Director to load an RDMS Schema definition into the DDW Repository. Each of these service requests may result in the Director initiating further background servers. For example, a ‘Start’ request for Changed Data Capture for an Application Group causes the Director to start a OS 2200 Agent Server to monitor the audit trail.
Both the Administrative Service and the DDW interface to the Director through a TCP Port. The port number is configurable.
It is possible to run multiple Directors servicing different ports.
The Data Exchange Director and any of its Agents register their Generated RunId as a Console Key-in.
Note: If a generated RunId has a leading numeric character, prefix it with an asterisk (*) mark when entering the console key-in.
Console Operations for the Director
The Director D5156E is taken as an example for commands and reply messages.
The available commands for the Director include the following:
STATUS : Lists the status of the Director.
D5156E status > D5156E*Data Exchange Director: D5156E (Up-49:33:48) D5156E*Open Connections: 0 D5156E*Agent connections: D5156E*Extract connections:
CONFIG: Shows the configuration details.
D5156E config> D5156E*Data Exchange Director: D5156E Port 5156 D5156E*Version: 2.0.34 (14-12-09 19:05:56) D5156E*Host: XX14 (nnn.nn.nn.nn) D5156E*Log File: DEXCH$D5156E*LOG$(7)
DEBUG [ON/OFF]: Enables or disables the ability of the Director to write debugging information to the log file.
D5156E debug on> D5156E*Debug Set for D5156E D5156E debug off> D5156E*Debug Cleared for D5156E
SWAP: Swaps to the new log file.
D5156E swap> D5156E*Logging swapped to DEXCH$D5156E*LOG$(8)
TERM <Director name> : Terminates the Director unconditionally.
d5156e term d5156e> D5156E*D5156E Terminating - Please wait D5156E*Data Exchange Director D5156E Terminated D5156E FIN
Console Operations for the Agent
The Agent AG05NT is taken as an example for commands and reply messages.
The available commands for the Agent include the following:
STATUS: Lists the status of the Agent.
AG05NT status> AG05NT*Data Exchange Agent: D5156EAG05$0 (Up-0:00:28) AG05NT*App Audit File: SYS$*EAG$1(234) AG05NT*RDMS Count: 0 AG05NT*DMS Count: 0 AG05NT*QBSEND Count:11 AG05NT*QBRECV Count:8 AG05NT*Age of last Audit Entry:(1037033:18:03)
where QBSEND is the number of queue banks sent to the Runtime Service; QBRECV is the number of queue banks received by the OS 2200 Agent.
While running a CDT,
The count of QBSEND should be greater than or equal to the count of QBRECV while data is being transferred. This means that the data is being transferred and Runtime Service is handling these messages. For example,
AG05NT*QBSEND Count:11 AG05NT*QBRECV Count:8
The count of QBSEND should be equal to the count of QBRECV after the data is transferred for a while. This means that no data is being transferred and Runtime Service has finished handling the messages. For example,
AG05NT*QBSEND Count:11 AG05NT*QBRECV Count:11
If there is no data being transferred, and the QBSEND is greater than the QBRECV after the data was transferred for a while, it is an Error status.
This means that the OS 2200 agent has failed to receive a message from the Runtime Service. Check if the queue banks are hung in Data Exchange. For example,
AG05NT*QBSEND Count:11 AG05NT*QBRECV Count:8
CONFIG: Shows the configuration details.
AG05NT config> AG05NT*Data Exchange Agent: D5156EAG05$0 Port 5156 AG05NT*Version: X.0.0 (14-12-09 19:05:56) AG05NT*Host: XX14 (nnn.nn.nn.nn) App: 5 AG05NT*Runtime Service Host: AG05NT* XXX15 (nnn.nn.nn.nn) AG05NT* Non-secure connection AG05NT*Log File: DEXCH$D5156E*LOG$AG05$0(1)
The three CONFIG Parameters are:
MAX_QB_QENTRIES: This parameter specifies the maximum number of active QBANKs. A QBANK is created to package data capture records from audit trail for transport to DE Runtime Service or Runtime Service in all instances. Once a QBANK is full, it is closed and sent to Runtime Service and another QBANK is obtained for the next lot of data capture records. Until the OS 2200 Agent receives acknowledgement of a successful QBANK delivery from DE Runtime Service, the QBANK remains active.
This is a required parameter. The minimum value for MAX_QB_QENTRIES is 4 and maximum is 20; the recommended initial value is 4.
MAX_AT_SECS: If all QBANKs are in use (as specified by MAX_QB_QENTRIES), the OS 2200 Agent will wait for duration specified in MAX_AT_SECS for an available QBANK; if none becomes available, the OS 2200 Agent will terminate.
This is a required parameter. The minimum value for MAX_AT_SECS is 1 second and maximum is 3,600 seconds; the recommended initial value is 30 seconds.
MAX_QB_RCVTIMEO: This parameter specifies the number of seconds the OS 2200 Agent will wait for QBANK delivery acknowledgement from DE Runtime Service. Its value should be set to a value higher than MAX_AT_SECS to minimize the chances of the OS 2200 Agent terminating. If MAX_QB_ RCVTIMEO is set to its maximum value of 262,143 seconds, the OS 2200 Agent will wait indefinitely for QBANK delivery acknowledgement.
This is an optional parameter, if not specified, MAX_QB_ RCVTIMEO will default to 60 seconds. The minimum value for MAX_QB_ RCVTIMEO is 1 second and maximum is 262,143 seconds.
The setting of these values depend on many factors such as, transaction rate, network latency, DE processing power, and target database. In a well performing environment, the recommended and default values are appropriate. If the OS 2200 Agent does terminate because of QBANK issues, in most cases, it occurs due to the performance issue of the DE Runtime Service.
DEBUG [ON/OFF]: Enables or disables the ability of the Agent to write debugging information to the log file.
AG05NT debug on> AG05NT*Debug Set for D5156EAG05$0 AG05NT debug off> AG05NT*Debug Cleared for D5156EAG05$0
SWAP: Swaps to the new log file.
AG05NT swap > AG05NT*Logging swapped to DEXCH$D5156E*LOG$AG05$0(2)
TERM <Agent name> : Terminates the Agent unconditionally.
AG05NT term d5156eag05$0> AG05NT*D5156EAG05$0 Terminating - Please wait AG05NT*Data Exchange Agent D5156EAG05$0 Terminating AG05NT*Data Exchange Agent D5156EAG05$0 Terminated AG05NT FIN