Function

The hdemodq command is used offline to change the organization of the extraction information queue files. This command can execute the following processing:

• Register additional extraction information queue files.
• Release the registration of extraction information queue files that are no longer needed.
• Display offline information about the extraction information queue files.

Format

hdemodq [ -x host-name ]-b HiRDB-server-name
        { -l |-a extraction-information-queue-file-name
        [ -n additional-queue-duplexing-definition-file]
             |-d extraction-information-queue-file-name }

Options

-x host-name ~ <symbolic name of 32 characters>

Specify the host name of the corresponding node.

Whether this option is required depends on the values of the nodecontrol and errfile_unique operands in the extraction system definition.

The following table shows the relationship between the -x option and the nodecontrol and errfile_unique operands in the extraction system definition:

nodecontrol and errfile_unique operand values	-x option
nodecontrol=unit errfile_unique=false	Ignored, if specified.
nodecontrol=server errfile_unique=false
nodecontrol=unit errfile_unique=true	Takes effect. Omitting the option results in an error.
nodecontrol=server errfile_unique=true	Ignored, if specified.

-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 hdemodq command. The command is executed in the environment of the source Datareplicator that corresponds to the specified server name to display information about the queue file, to register an additional file, or to release a registration. Note that you must also specify this option when the source HiRDB is a single server.

-l

Specify this option to display information about the extraction information queue file.

-a extraction-information-queue-file-name

To register an additional extraction information queue file, specify the absolute or relative path name of the extraction information queue file to be added. If a relative path name is specified, the command assumes $HDEPATH/relative-path-name as the absolute path.

The specified name must be unique in the source system. If the source HiRDB is a parallel server, specify a name that is unique within each back-end server.

• The actual name of the extraction information queue file is the specified name with _server-name appended. If you are specifying the absolute path name, make sure that the actual name including _server-name does not exceed 125 bytes. If you are specifying a relative path name, make sure that the actual name, which is _server-name appended to the assumed absolute path name, does not exceed 125 bytes.

The type of the queue file to be registered must be the same as the type of the existing queue files (in UNIX, if the existing queue files constitute a Datareplicator file system area, use a character special file).

If the file type is regular file for UNIX or Windows file, the hdemodq command creates the file.

• If the file type is a character special file for UNIX, the user must have created the file before executing the hdemodq command. The file name must be _server-name appended to the name specified in the -a option, and the file size must be equal to or greater than the size of the extraction information queue file.
• If this option is specified when large files are used, the command might take a long time to execute. For details, see 6.11.2 Estimating the command execution time when large files are used.

-n

Specify this operand to add a duplexed extraction information queue file. Specify in this operand the absolute path name of the additional queue duplexing definition file^# that defines the organization of the extraction information queue file to be added.

When this operand is specified, the command treats the extraction information queue file name specified in -a as the logical file name.

#: The syntax for the additional queue duplexing definition file is the same as for the duplexing definition file. For details about the duplexing definition file, see 5.7 Duplexing definition (source).

If a duplexed queue file is added or deleted, the duplexing control file (see 3.9 Duplexing files) is also updated as an extension of command processing. Therefore, if you employ a system switchover configuration, you must copy the duplexing control file to the secondary system after adding or deleting a queue. To keep this queue addition or deletion effective after the subsequent initialization of Datareplicator, you need to add or delete applicable duplexing definitions.

-d extraction-information-queue-file-name

Specify the absolute or relative path name of the extraction information queue file whose registration is to be released. If a relative path name is specified, the command assumes $HDEPATH/relative-path-name as the absolute path.

The actual name of an extraction information queue file is the specified name with _server-name appended.

Output format

The hdemodq command displays the status of the extraction information queue files in the following format:

1. Indicates the source Datareplicator identifier.
2. Indicates the server name of the source HiRDB.
3. Displays the wrap-around count for the extraction information queue file. Once the wrap count reaches 4294967295, it is reset to 0.
4. Indicates information about the extraction information queue files.
   status: Displays the status of extraction information queue files. The following information is displayed:
   

   No.	Code location	Description	Value	Status
   1	Col. 1	Whether there is any untransmitted extraction information	u	There is extraction information waiting to be sent to the target.
   2			e	There is no more extraction information waiting to be sent to the target.
   3	Cols. 2-7	Undefined	--	--

   size: Displays the size of the extraction information queue file in kilobytes.
   create date: Displays the date and time the extraction information queue file was created.
   file path: Displays the path of the extraction information queue file.
   

Note

If an error that indicates a nonexistent extraction node master error information file occurs, check and, if necessary, revise the following:

Check item	Action to be taken if necessary
Whether the extraction node master error information file has been deleted illegally.	Re-execute this command with the following procedure: Restart the source Datareplicator. Terminates the source Datareplicator. Re-execute the hdemodq command.
Whether specification of the -x option is correct, if specified.	Correct the specification.