Function

The hdsstate command outputs the current status of the target Datareplicator to the standard output. The command outputs the following information:

• Common information
  Information common to all import processing for the target system.
  
• Synchronous import group information
  Information about the synchronous import group.
  
• Import information queue file information
  Information about the utilization status of the import information queue files.
  
• Reception processing information
  Information about the status of reception processing, such as the protocol type and existence of reception events.
  
• Import processing information
  Information about the status of import processing, such as the import processing mode and commit interval.
  

Format

hdsstate [ -d data-linkage-identifier | -g synchronous-import-group-name ]

Options

-d data-linkage-identifier

To collect target Datareplicator status information corresponding to a specified source system, specify the source system's data linkage identifier. Specifying ** for the data linkage identifier will result in an invalid-argument error.

For details about the data linkage identifier when the source database is a HiRDB, see 5.2 Extraction system definition. For details about the data linkage identifier when the source database is a mainframe database, see the VOS3 XDM/DS manual.

If you omit the -d option, Datareplicator collects status information for all target Datareplicators corresponding to all source systems.

-g synchronous-import-group-name

Specifies the name of a synchronous import group in order to use the import transaction synchronization facility to collect status information for the data linkage identifiers that constitute that synchronous import group.

If you omit the -g option, the command acquires status information for the target Datareplicators that corresponds to all source systems.

Rules

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

Output format

Common information

1. hdsid to semid = 907
   hdsid displays the target Datareplicator identifier. shmid displays the shared memory ID. semid displays the semaphore ID.
   
2. PID: hdsmaster to hdsosimst = 4694
   hdsmaster displays the import master process ID. hdstcpmst or hdsosimst displays the import communication master process ID corresponding to the specified communications protocol. If there is no import master process, an error results when the hdsstate command executes. If there is no import communications master process, 0 is displayed as the import communication master process ID.
   

Synchronous import group information

1. sync-group=Grp001
   sync-group displays the synchronous import group name.
   
2. shmid=4
   shmid displays the shared memory ID that is used for the synchronous import group.
   
3. semid=1
   semid displays the semaphore ID that is used for the synchronous import group.
   
4. PID: hdsrefsync=27266
   hdsrefsync displays the process ID of the synchronization managing process.
   
5. syncwait tran count=11
   This item displays the number of target transactions that are being imported after the previous commit.
   

Import information

Import information file information

1. dsid = a1 [sync-group:Grp001]
   Displays the data linkage identifier specified in the -d option. If the specified data linkage identifier is not found, the hdsstate command results in an error.
   For a data linkage identifier that is not specified in the synchronous import group, the output format is as follows:
   dsid=xx
   For a data linkage identifier that is specified in the synchronous import group, the output format is as follows:
   dsid=xx [sync-group:synchronous-import-group-name]
   
2. wrap count = 1
   Displays the number of times the import information queue file was wrapped since initial start of the target Datareplicator.
   
3. qufile001 to status: unused
   Displays the utilization status for each import information queue file specified in the qufile001 to qufile008 operands in the import 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/11/10 13:47:41 70%
   Displays the date and time the import information queue file's usage rate peaked (reached the maximum value) and what that peak usage rate was.
   The following is the display format when the import information queue file has just been initialized, or when the maximum usage rate has just been reset by the hdschgstatus command:
   
   max used ratio : ****/**/** **:**:** 0%
   
   
5. current used ratio:2005/11/10 13:47:41 10%
   Displays the date and time at which the hdsstate command was executed, and the import information queue file's usage rate at that time.
   Reception processing information
   
6. PID: hdsosimst to protocol = OSI
   hdsosimst displays the reception protocol ID. protocol displays one of following as the communications protocol:
   TCP/IP: TCP/IP protocol
   OSI: OSI protocol
   If there is no reception process, -1 is displayed as the reception process ID.
   
7. receiving event = exist
   Displays whether there is a reception event establishing connection with the source system:
   exist: There is a reception event.
   not exist: There is no reception event.
   N/A: Not applicable (because the reception process is inactive).
   
8. write position to offset = 2048
   Displays the write position of the update information. qufilexxx displays one of the qufile001 to qufile008 operands specified in the import environment definition that corresponds to the import 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.
   Import processing information
   
9. PID: hdsdefserv to definition-shmid = 1305
   hdsdefserv displays the import definition server process ID. definition-shmid displays the shared memory ID for storing the definition information.
   If there is no import definition server process, -1 is displayed as the import definition server process ID.
   
10. reflection mode to commit interval = 1
    reflection mode displays the import processing mode. commit interval displays the import processing commit interval. One of the following is displayed as the import processing mode:
    init: Import processing is being initialized.
    trn: Processing using the transaction-based import method is underway.
    tbl: Processing using a table-based import method or using a UOC routine is underway.
    spd: Import processing has been suspended (in this case, items 12 through 18 are not displayed).
    N/A: Not applicable (because the definition server process is inactive).
    For the import processing commit interval, the command displays the interval at which commit is issued, expressed as a number of transactions at the source system. This is the value specified with the cmtintvl, trncmtintvl, or tblcmtintvl operand in the import environment definition or the value of the -c option in the hdsrfctl command. Note that if the import process is engaged in startup processing, 0 is displayed.
    
11. GROUP to hdssqle = 4715
    GROUP displays the name of an import group. hdsreflect displays the import process ID. hdssqle displays the import SQL process (UOC process) ID. Once import processing is stopped, -1 is displayed as the process ID.
    The import group name to be displayed varies as follows:
    trngroup: When reflection mode is trn or init
    import-group-name: When reflection mode is tbl
    othergrp: When no import group is specified
    uocxxx: When a UOC routine is used (xxx: sequential number beginning with 001)
    For the import SQL process (UOC process) ID, the command displays hdssqle for an import SQL process and the user-defined import UOC process name for an import UOC process. If there is no shared memory for storing definition information, the command displays uoc [unknown].
    
12. status to retbl
    status displays the status of import processing. last event displays the type of most recent event detected by the import processing.
    The status of import processing is displayed as follows:
    run: Executing
    definto-wait: Waiting for definition information
    data-wait1: Waiting for update information to be received (before importing the end-of-transmission message)
    data-wait2: Waiting for update information to be received (after importing the end-of-transmission message and ready to execute the hdsstop command)
    event-stop: Event stopped
    normal-stop: Normal termination
    abnormal-stop: Abnormal termination
    midway-stop: Forced termination
    The event type is displayed as follows:
    none: No event detected
    trn: Transaction-based import event
    tbl: Table-based import event
    spd: Import processing stop event
    retrn: Transaction-based import restart event
    retbl: Table-based import restart event
    cntreset: Event to reset the import processing count
    end: Termination event
    other: Other
    
13. DB-status: normal
    Displays the status of the target database as follows:
    normal: Normal status or during initialization of import processing
    critical: Import processing terminated abnormally during synchronization point processing on the import processing.
    
14. read transaction = 4
    Displays the number of transactions read from the import information queue file since the beginning of import processing.
    This is the total value for the update information that was stored in the import information queue file, regardless of commit. The number of committed transactions is displayed in item No. 17.
    
15. read position to 1536
    Displays the read position of the update information. qufilexxx displays one of the qufile001 to qufile008 operands specified in the import environment definition that corresponds to the import information queue file from which update information is read. offset displays the read position of the update information, expressed as the offset from the beginning of the file.
    
16. uocname = none
    If a UOC routine is used, uocname displays the name of the UOC routine. If no UOC routine is used, none is displayed. If there is no shared memory for storing definition information, N/A is displayed.
    
17. Reflection count to commit(extract transaction) = 4
    Displays the number of import operations since the beginning of import processing. For this item, the value that existed at the time of the previous session is inherited even when the target Datareplicator is restarted.
    If a UOC routine is used for import processing, Reflection count displays the number of import information items passed to the UOC routine. If no UOC routine is used for import processing, the SQL execution counts are displayed as follows:
    ins: Number of insert operations
    upd: Number of update operations
    del: Number of delete operations
    purge: Number of purge operations
    commit: Number of commits
    timestamp: Number of insert operations on the time-ordered information table
    The value is 0 if a UOC routine is used.
    commit(extract transaction): Number of committed source transactions
    
18. reflect delay times = 0000:00:05/0000:10:00
    Displays the amount of time that elapsed until update data was imported by the target HiRDB from the time it was committed at the source HiRDB; also displays the value specified in the import definition. The following table shows display formats:
    

    Display format	Description
    0000:00:00/defined-value	Nothing has been output from an import process.
    ****:**:**/****:**:**	The value 0 was specified in the reflect_delay_limit_time operand in the import environment definition.
    --:----:--/defined-value	9999:59:59 was exceeded.
    -xxxx:xx:xx/defined-value	The amount of time that elapsed from when update was committed at the source RDAREA until it was imported is a negative value. This means that the source machine's time is ahead of the target machine's time.

19. SQL distribute information to timestamp = 0
    Displays the number of import operations that have been committed per SQL import process. This value indicates the number of SQL processes that executed key range partitioning or hash partitioning, as shown below (ins, upd, del, purge, and timestamp correspond to those indicated in 17 above):
    ins: Number of insert operations
    upd: Number of update operations
    del: Number of delete operations
    purge: Number of purge operations
    commit: Number of commits
    timestamp: Number of insert operations on the time-ordered information table
    

Notes

• Common information items Nos. 1 and 2 are common to all replication nodes that belong to the target Datareplicator.
• Import information items Nos. 1-19 are retained for each data linkage identifier. When you omit the -d option in the hdsstate command, the command displays this information as many times as there are data linkage identifiers. When you specify the -d option, the command displays this information only for the specified data linkage identifiers.
• Import information items Nos. 9-19 are displayed as many times as there are import processing groups.
• Import information item No. 14 indicates the last transaction processed. No. 17 indicates the number of transactions whose import processing has been completed (committed to the target database).
• If Datareplicator is started by the hdsstart -i command and reflection mode is spd, the value 0 is displayed for commit interval.
• If data linkage uses update information in a SAM file, reception processing information is displayed as follows, in which case import information items Nos. 6-8 are not displayed:
  Communication process not effective
  
• Import information item No. 19 is displayed only when multiple SQL processes are started for a single import process, such as for key range partitioning or hash partitioning.
• The value displayed in item No. 2 in the import information is reset to 0 when it exceeds 2,147,483,647.
• Import information items Nos. 14, 17, and 19 are reset to 0 once their values exceed 18,446,744,073,709,551,615.
• The information output in import information items Nos. 14, 17, and 19 is reset each time the target Datareplicator is started.
• The information output in import information items Nos. 17 and 19 is reset at the following times:
  
  • Initialization (including partial initialization) or start of the target Datareplicator^#
  • Detection of an event specified in the eventcntreset operand in the import environment definition
    #: Applicable when false is specified in reflect_counter_reset in the import system definition
    
• The import processing count is reset in the following cases:
  
  • The target Datareplicator was started with a different import processing method than was used in the previous session.
  • The table-based import method was used and the following information has been changed for the import group from what it was in the previous session:
    Import group name
    Number of SQL processes
    Partitioning method (key range or hash partitioning)
    Number of key range groups when the key range partitioning method is used
    Number of RDAREAs for a hash-partitioned table when the hash partitioning method is used
    
  For details, see the reflect_counter_reset operand in the import system definition.