Accumulation Status List Display utility (active server)(only on HULFT-HUB Server for UNIX/Linux-ENT)

Displays the list of accumulation data status on the active server, in the order in which accumulation has started.

This utility can be used when the Replication functionality is used, and displays sync status of accumulation information from an active server to an alternative server.

Usage

utlhubacclist [-disp | -csv] [-e ok | ng | ns] [-h hostname:servicename] 
   [-date yyyymmdd | -day n | [-fromdate d1] [-todate d2] ] 
   [-count] [-notitle]

Explanation of parameters

[-disp | -csv]

List display format (Optional)

Specifies the display format.

-disp:

Displays the main fields in a one-field-per-line format.

-csv:

Displays the list in a CSV format. Double quotation marks (") are used as Enclosed Characters and commas (,) are used as Separators. If the data includes a double quotation mark ("), two double quotation marks ("") are displayed.

If omitted, -disp is assumed.

[-e ok | ng | ns]

Status (Optional)

-e ok:

Data accumulations that ended successfully are displayed.

The statuses of data accumulations that ended successfully are as follows:

  • Accumulation Complete

  • Delivery Complete

  • Reset to Undelivered

-e ng:

Data accumulations that ended unsuccessfully are displayed.

The status of data accumulations that ended unsuccessfully is as follows:

  • Delivery Error

-e ns:

Displays the accumulated data that is not delivered yet.

The statuses of undelivered accumulated data are as follows:

  • Accumulation Complete

  • Delivery Error

  • Reset to Undelivered

If omitted, all the statuses are targeted for display.

[-h hostname:servicename]

Host name and service name (Optional)

Displays the accumulated data whose transfer destination matches hostname:servicename.

If omitted, all the transfer destinations are targeted for display.

If you specify a host for which no service name is set, specify only a host name, and do not specify a service name that includes a colon (:).

= Remarks =

If the service name is omitted, it will not be possible to make more than one host with the same host name a target.

[-date yyyymmdd | -day n | [-fromdate d1] [-todate d2]]

Date specification (Optional)

Displays the accumulated data which is included in the Accumulation Start Date/Time Range.

If -date is specified, the data which started the accumulation processing before yyyymmdd is targeted for display.

The data which started the accumulation processing on yyyymmdd is also included.

If -day is specified, the data which started the accumulation processing until n days before the utility has been executed is targeted for display. A value from 0 to 999 can be specified.

If 0 is specified, the data which started the accumulation processing until the utility has been executed is targeted for display.

If -fromdate | -todate is specified, the data which has started the accumulation processing between d1 and d2 is targeted for display.

d1 and d2 must be 14-byte numeric values (yyyymmddhhmmss), or 8-byte numeric values (yyyymmdd). If the date is specified with 8-byte numeric values, all the data which has started the accumulation processing on the specified day is targeted for display.

If -todate is omitted, all the data which has started the accumulation processing after the date specified in -fromdate is targeted for display.

If -fromdate is omitted, all the data which has started the accumulation processing before the date specified in -todate is targeted for display.

= Remarks =

  • If you specify -fromdate and -todate at the same time, d1 must be equal to or smaller than d2.

  • The date format of -fromdate and -todate can be different.
       Example) -fromdate 20150801 -todate 20150930123000

Note

Multiple specification of date related parameters (-date, -day, or -fromdate/-todate) is not possible.

[-count]

Output the number of records (Optional)

If specified, only the number of the accumulated data that matches the specified conditions is displayed.

Note

If -count is specified, even when the data that matches the conditions does not exist, the processing ends with outputting 0 as the number of records and outputting status code 0.

[-notitle]

Omission of the header line (Optional)

If you specify "-notitle", the list is displayed without the header line.

If you do not specify "-notitle", a field name is displayed as the header. For details about field names, see Displayed fields.

Status code

0:

The utility was executed successfully.

4:

The utility was canceled.

10:

The specified options are incorrect.

12:

Failed to allocate memory.

13:

A system error occurred.

100:

The record to be listed does not exist.

101 or above:

An SQL error occurred.

Note

If -count is specified, even when the data that matches the conditions does not exist, the processing ends with outputting 0 as the number of records and outputting status code 0.

Notes on using the utilities

For details about the operation environment for using the utilities, see Notes on execution of utilities (commands).

Output example

The following shows an output example when -csv is specified:

"FileID","Business Group","Transfer Source","Transfer Destination","Status","Fil 
eSize","Strage Period","Storage start date/time","Storage end date/time","Delive 
ry Count","Latest Identifier","Starting Identifier","Accumulated Data Status","T 
ransfer Serial ID","Send File Name" 
"DATA001","unknown","HOST001","HOST002","Accumulation Complete","436","-","2015/ 
12/04 15:28:33","2015/12/04 15:28:33","0 times","B57812BE804C715EF2B072ABF5DCE4B 
581","B57812BE804C715EF2B072ABF5DCE4B581","OK","001ec9e0ca2432312201301281617360
0001","20151201.dat"

Figure 3.11 Output example of Accumulation Status List Display (active server) (when -csv is specified)

The following shows an output example when -disp is specified:

Relay transfer

HULFT-HUB Server status : XXXXXX, XXXXX, XXXXX, XXXXX 4)
FILEID                      1)      2)     3)      STATUS   HOSTNAME                        DATE                DAY/NUM
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 9)
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 10)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 
                      5)                           XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 
                                                      6)                  7)                          8)

Figure 3.12 Output example of Accumulation Status List Display (active server) during relay transfer (when -disp is specified)

Multicasting transfer

HULFT-HUB Server status : XXXXXX, XXXXX, XXXXX, XXXXX 4)
FILEID                      1)      2)     3)      STATUS   HOSTNAME                        DATE                DAY/NUM
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 9)
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 10)
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999
                                                   XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999
                    5)                             XXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX YYYY/MM/DD HH:MM:SS 9999 
                                                      6)                 7)                           8)

Figure 3.13 Output example of Accumulation Status List Display (active server) during multicasting transfer (when -disp is specified)

The following shows an output example when -csv -count is specified:

"Number of Records"                                                                           
"3"

Figure 3.14 Output example of Accumulation Status List Display (active server) (when -disp -count is specified)

The following shows an output example when -disp -count is specified.

COUNT                                                                           
3

Figure 3.15 Output example of Accumulation Status List Display (active server) (when -disp -count is specified)

Displayed fields

The following table lists and describes the fields shown in the output example.

Table 3.13 Displayed fields when -csv is specified

Field name

Description

FileID

File ID

Business Group

Name of the Business Group

Transfer Source(*1)

Host name, service name, and Alias of the Transfer Source

Transfer Destination(*1)

Host name, service name, and Alias of the Transfer Destination

STATUS

Status when the data is accumulated

Accumulation Complete

Delivered

Delivery Error

Reset to Undelivered

Request Issued

Startup of Job Flow Failed, XXXX

Job Flow in Execution, XXXX

Job Flow Ended Successfully, XXXX

Job Flow Ended Unsuccessfully, XXXX

XXXX represents one of the following:

Accumulation Complete

Request Issued

Delivered

Delivery Error

FileSize

File size of the accumulated data

Remaining Days

Remaining number of days in the case where the deletion date is specified.

Storage Start Date/Time

Date and time on which accumulation processing was started.

Displayed with YYYY/MM/DD HH:MM:SS format (the initial digits of the month, date, hour, minute, and second are filled with 0).

Storage End Date/Time

Date and time the delivery processing is completed.

Displayed with YYYY/MM/DD HH:MM:SS format (the initial digits of the month, date, hour, minute, and second are filled with 0).

Delivery Count

Number of times delivery was carried out

Latest Identifier

Latest Identifier

Starting Identifier

Starting Identifier

Status of the accumulated data

Status of the accumulated data

Transfer Serial ID

ID uniquely assigned for each transfer

Send File Name(*2)

File name of the Send file

*1

:

According to Kanji Code Type (KnjCode) specified in the System Environment Settings, the string is converted to EUC, SJIS, or UTF-8.

*2

:

If the Send File Name has been dynamically specified at the time of Send File, this will be the specified file name. If the Send File Name was not dynamically specified, this will be the file name specified in the Send Management Information.

Table 3.14 Displayed fields when -disp is specified

No.

Header name(*1)

Field name

Description

Display size

1

 

 

Active Server

6

2

 

 

Total number of accumulated data files

5

3

 

 

Number of Delivery Errors

5

4

 

 

Number of undelivered data files

5

5

FILEID

File ID

File ID

50

6

STATUS (1st line)

Accumulation Status

Displays the status of accumulation and job flow

Accumulation Complete

:

Accumulation Complete

Startup Failed

:

Startup of Job Flow Failed

In Execution

:

Job Flow in Execution

Ended Unsuccessfully

:

Job Flow Ended Unsuccessfully

Ended Successfully

:

Job Flow Ended Successfully

8

STATUS (2nd line)

Delivery status

Displays the status of delivery

Delivery Error

:

Delivery Error

Delivery Complete

:

Delivery Complete

Reset to Undelivered

:

Reset to Undelivered

Issue Request

:

Request Issued

-

:

No delivery

8

7

HOSTNAME (1 st line)

Send Host Name

Host name and service name of the Transfer Source

31

HOSTNAME (2nd line)

Receive Host Name

Host name and service name of the Transfer Destination

31

8

DATE (1st line)

Accumulation Start Date/Time

Date and time of the start of accumulation processing.

19

DATE (2nd line and beyond)

Delivery End Date/Time

Date and time the delivery processing is completed.

19

9

DAY (1st line)

Remaining Days

Remaining number of days in the case where the deletion date is specified.

4

10

NUM (2nd line and beyond)

Delivery Count

Number of times delivery was carried out

4

*1

:

The 1st line is a line where FILEID is displayed. The 2nd line and beyond are the lines without FILEID.

Table 3.15 Displayed fields when -csv -count is specified

Field name

Description

Number of Records

The number of the accumulated data that matches the conditions

Table 3.16 Displayed fields when -disp -count is specified

Header name

Field name

Description

COUNT

Number of Records

The number of the accumulated data that matches the conditions

TOP

Policies     (c) Saison Technology Co.,Ltd. 2006