Function

The hdestate command outputs the current status of the source Datareplicator to the standard output. The command outputs the following information:

• Common information
  Common information such as the source Datareplicator identifier, total number of nodes, and number of connected nodes.
  
• Node information
  Information about a node's status, such as the node host name and the status of the extraction node master process.
  
• Extraction information queue file information
  Information about the utilization status of the extraction information queue files.
  
• Extraction processing information
  Information about the status of extraction processing, such as the status of the extraction process and the write position in the extraction information queue file.
  
• Transmission processing information
  Information about the status of transmission processing, such as the target identifier and the status of the transmission process.
  

Format

hdestate [ -b HiRDB-server-name ][ -s target-identifier ]

Options

-b HiRDB-server-name ~ <symbolic name of 8 characters>

Specify the HiRDB server name of the extraction environment that is to be processed by the hdestate command. The command collects status information for the source Datareplicator that corresponds to the specified server name. Note that you must also specify this option when the source HiRDB is a single server.

-s target-identifier

Specify a target identifier in order to collect status information about the source Datareplicator corresponding to the specified target. Specifying ** for the target identifier will result in an invalid-argument error.

To collect status information about a specified target identifier at a specified server, specify both the -b and the -s options. These options can be specified in either order. If you omit all options, the hdestate command collects status information for all target identifiers at all servers.

Rules

• If the hdestate command terminates normally, it returns 0. If it terminates abnormally, it returns 1.
• You can execute the hdestate command only while the source HiRDB is active.
• The source Datareplicator collects status information as of the time the hdestate command executes and outputs it to the standard output. Therefore, the output information might not match the actual status of the source Datareplicator.
• The source Datareplicator does not output information for a target identifier specified as an absent number.

Output format

Common information

1. hdeid = fa
   Displays the source Datareplicator identifier.
   
2. Shmid: 3502
   Displays the shared memory ID. If the source HiRDB is a parallel server, this is the shared memory ID allocated by the system manager.
   
3. PID: hdemaster = 4579
   Displays the extraction master process ID.
   
4. Total node count = 1 and Connecting node count = 1
   Total node count displays the total number of server machines managed by the extraction master process. Connecting node count displays the number of server machines that are connected.
   
5. nodecontrol: server
   Displays the node master process control method (nodecontrol operand value in the extraction system definition). The node master process control method is displayed as follows:
   unit: Node master process is started for each unit.
   server: Node master process is started for each server.
   

Node information

1. host name = host01
   Displays the host name for a node.
   
2. current host name = host0001
   When nodecontrol is server, displays the current host name as follows, depending on the communication status output in Communication status:
   When Communication status is online
   current host name: Host name currently recognized as the node master process to be started
   When Communication status is offline
   Server name: Server name
   
3. Communication status: online
   Displays the status of communication between the extraction master process and extraction node master process. The communication status is one of the following:
   online: Connected.
   offline: Disconnected due to an error.
   When the status is offline, none of the subsequent information is output.
   
4. Shmid: common = 1162 to msginf = 1164
   Displays the IDs of the shared memories allocated by the extraction node master process. The following are the types of shared memories:
   common: Shared memory for process-to-process communication
   definf: Shared memory for storing definition information
   msginf: Shared memory for storing message information
   
5. Semid: 923
   Displays the semaphore ID for locking message output that was obtained by the extraction node master process.
   
6. PID: hdenodemst = 2247
   Displays the process ID of the extraction node master process.
   

Extraction information queue file information

1. Server name = pbes01 to Semid: 925
   Server name displays the source HiRDB's server name, and Replication-node id displays the data linkage identifier. Semid displays the semaphore ID obtained by the extraction node master process.
   
2. wrap count = 0
   Displays the number of times the extraction information queue file was wrapped since initial start of the source Datareplicator.
   
3. qufile001 to status: unused
   Displays the utilization status for each extraction information queue file specified in the qufile001 to qufile016 operands in the extraction environment definition. The following are the utilization statuses:
   using: In use (when update information is stored, the utilization status is always using)
   unused: Unused
   
4. max used ratio: 2005/03/24 09:21:18 70%
   Displays the date and time at which the extraction information queue file's usage rate peaked (reached the maximum value) and what that usage rate was.
   The following is the display format when the extraction information queue file has just been initialized or when the maximum usage rate has just been reset by the hdechgstatus command:
   
   max used ratio : ****/**/** **:**:** 0%
   
   
5. current used ratio: 2005/03/24 09:51:18 10%
   Displays the date and time the hdestate command was executed and the extraction information queue file's usage rate at that time.
   If all destinations are in the reduced mode, -- is displayed as the usage rate.
   

Extraction processing information

1. Status: active
   Displays one of the following as the status of the extraction process:
   active: Active
   not active: Inactive
   not active (error): Inactive due to an error
   If the status is not active or not active (error), extraction processing information 2 below is not displayed.
   
2. PID: hdecapture = 2248
   Displays the extraction process ID.
   
3. HiRDB system log overwrite: not overwrite
   Displays whether the unextracted log was overwritten in the source HiRDB's system log file:
   overwrite: Overwritten
   not overwrite: Not overwritten
   
4. Queue write position to offset = 1024
   Displays the write position in the extraction information queue file. qufilexxx displays one of the qufile001 to qufile016 operands specified in the extraction environment definition that corresponds to the extraction information queue file in which the update information is written. offset displays the write position of the update information, expressed as the offset from the beginning of the file.
   
5. Extract delay times: 0000:00:05/0000:10:00
   Displays the amount of time that elapsed from the time update data was committed at the source HiRDB until the time it was written into the extraction information queue file; also displays the value specified in the extraction definition. The following table shows display formats:
   

   Display format	Description
   0000:00:00/defined-value	Nothing has been extracted from an extraction process.
   ****:**:**/****:**:**	The value 0 was specified in the extract_delay_limit_time operand in the extraction environment definition.
   --:----:--/defined-value	9999:59:59 was exceeded.

Transmission processing information

1. Send name = send01
   Displays the target identifier specified with one of the sendid01 to senddid64 operands in the extraction system definition.
   
2. Status: queue read
   Displays one of the following as the status of the transmission process:
   init: Being initialized
   queue read: Reading the extraction information queue file
   data transmission: Transmitting data
   hold: Transmission in shutdown status
   not active: Inactive
   not active (error): Inactive due to an error
   If the status is hold or not active (error), transmission processing information 3 below is not displayed.
   
3. PID: hdesender = 2249
   Displays the transmission process ID. However, if sendmst is specified in the sendcontrol operand in the extraction system definition, 0 is displayed. If an update-SQL output process is running, this item displays the update-SQL output process ID.
   
4. Service name: serv01
   Displays the transmission server name.
   
5. Send host name: shost01
   Displays the host name at the destination.
   
6. Send system id: aa
   Displays the target Datareplicator identifier at the destination.
   
7. Send delay times: 0000:00:10/0000:10:00
   Displays the amount of time that elapsed until reception of update data was completed at the target system from the time it was committed at the source HiRDB; also displays the value specified in the transmission definition. The following table shows display formats:
   

   Display format	Description
   0000:00:00/defined-value	Nothing has been sent by a transmission process.
   ****:**:**/****:**:**	The value 0 was specified in the send_delay_limit_time operand in the transmission environment definition.
   --:----:--/defined-value	9999:59:59 was exceeded.
   Not displayed	The update-SQL output facility is used.

8. send count: 3
   Displays the number of transmissions since the start of transmission processing.
   
9. transmission transaction count = 50
   Displays the number of transmission transactions since the start of transmission processing. When false is specified in the send_counter_reset operand in the extraction system definition, the settings used during the previous session are inherited even when the source Datareplicator is restarted.
   
10. transaction count2=10
    Displays the number of transactions created and transmitted by the source Datareplicator separately from those transactions existing when the source database was updated. This count is not included in the number of transmission transactions in transmission transaction count.
    For example, for a table for which the WITHOUT ROLLBACK option is specified, one update operation is treated as one transaction. Therefore, if a table for which the WITHOUT ROLLBACK option is specified and a table for which the WITHOUT ROLLBACK option is omitted are both updated within the same transaction, the target Datareplicator sends and imports them as separate transactions. In such a case, the displayed number indicates the number of transactions for the table for which the WITHOUT ROLLBACK option is specified that were created and sent by the source Datareplicator.
    
11. undetermined transaction count = 5
    Displays the number of unresolved transactions since the start of transmission processing.
    
12. ins = 50 to event = 0
    Displays the number of transmitted data items for each type of data manipulation since the start of transmission processing. When false is specified in the send_counter_reset operand in the extraction system definition, the settings used during the previous session are inherited even when the source Datareplicator is restarted.
    The data transmission count for each operation is displayed as follows:
    ins: Number of insert data items
    upd: Number of update data items
    del: Number of delete data items
    purge: Number of purge table data items
    event: Number of events issued
    
13. ins = 0 to event = 0
    Displays the skipped data count for each type of operation since transmission processing started.
    The skipped data count is displayed for each type of operation as follows:
    ins: insert data count
    upd: update data count
    del: delete data count
    purge: purge table data count
    event: Number of events issued
    
14. Queue read position to offset = 33792
    Displays the read position in the extraction information queue file. qufilexxx displays one of the qufile001 to qufile016 operands specified in the extraction environment definition that corresponds to the extraction information queue file in which the update information is being read. offset displays the read position of the update information, expressed as the offset from the beginning of the file.
    In the case of an update-SQL output process, the value of Queue read position is not updated.
    
15. Queue current pos
    Displays the read location in the extraction information queue file. This information is displayed only when the update-SQL output process is active.
    
16. system id = a1 to count = 5
    Displays transmission suppression information for the update information. system id displays the system identifier of the original receiver of the update information. count displays the number of transmission-suppressed data items.
    

Notes:

• The values displayed in item No. 2 in the extraction information queue file information and in item Nos. 8 and 11 in the transmission processing information are reset to 0 when they exceed 4294967295.
• The values displayed in item Nos. 9, 12, and 13 in the transmission processing information are reset to 0 when they exceed 18446744073709551615.
• Item Nos. 7, 8, 9, 11, and 15 in the transmission processing information are reset each time the source Datareplicator is started.
• The values displayed in item Nos. 9, 10, 12, and 13 in the transmission processing information are reset at the following times:
  
  • The source Datareplicator is initialized (including partial initialization) or started^#
  • An event specified in the eventcntreset operand in the transmission environment definition is detected
    #: Applicable when false is specified in the send_counter_reset operand in the extraction system definition
    
• If update information for UPDATE that contains the SET, ADD, or DELETE clause is sent for a repetition column, the update data count displayed in item No. 12 in the transmission processing information will be greater than the actual number of updates. If you want to synchronize the update data count displayed in item No. 12 and the actual number of updates for repetition columns, update for each clause by using UPDATE.