Hitachi

JP1 Version 12 JP1/Automatic Job Management System 3 - Definition Assistant Description, Operator's Guide and Reference


C.1 Estimating processing performance for JP1/AJS3 - Definition Assistant

Consider the following points when estimating the import and export processing performance for JP1/AJS3 - Definition Assistant:

When definition information is imported and exported, JP1/AJS commands are remotely executed for the connection destination JP1/AJS. An increase in the number of units to process has a dramatic effect on performance.

Organization of this subsection

(1) Recommended configuration

We recommend that you consider the above, and perform the following three operations for JP1/AJS3 - Definition Assistant to mitigate the network load for data transmission, to prevent degradation in performance for processing of the definition information management template and execution command:

Functionally speaking, JP1/AJS3 - Definition Assistant can process definition information for more than 10,000 units simultaneously. However, keeping performance load in mind, we recommend that you keep the maximum number of units processed simultaneously for one operation to around 1,000.

Note that the following definitions significantly lower performance, and should not be made:

(2) Estimating the import processing time

Although performance depends on differences in machine specifications, you can generally use the following formula to obtain an approximate time required for importing definition information.

Import-processing-time (seconds) =
    ((0.15*a*b)*(1-i-j)) + (0.01*c) + (0.01*d) + (0.025*e) + (0.001*f) +
    (0.08*g) + h
Legend:
a: Average size of the unit definition

Estimate the size of the standard output file that was obtained by executing the ajsprint -a command for a single unit with the most definition information defined.

b: Number of units

c: Total number of "Open day"

d: Total number of "Closed day"

e: Total number of lines of "Command statement"

f: Total number of a Relations

g: Total number of lines of "Environment variables"

h: Time required for saving the execution result file

The following table provides guidelines for how much time is required.

Table C‒1: Approximate time required to save an import execution results file

Execution result file size (unit: megabytes)

Required time (unit: seconds)

2

10

10

50

20

100

i: If 1 is specified for IMPORT-USEMEMORY, use 0.05 for an estimate. If 0 is specified for IMPORT-USEMEMORY, use 0 for an estimate.

j: If Y is specified for IMPORT-TIME-IMPROVE and the version of JP1/AJS3 at the connection destination is 10-00 or later, use 0.25 for an estimate. If these conditions do not apply, use 0.

(3) Estimating the export processing time

Although performance depends on differences in machine specifications, you can generally use the following formula to obtain an approximate time required for exporting definition information.

(a) When the value of the BATCHEXPORT-USEMEMORY environment settings parameter is 0

<In the case of 32-bit version of JP1/AJS3 - Definition Assistant>
Export-processing-time (seconds) =
  (a*a*i/10000000) + (0.002*a*i) + (0.3*b) + (0.02*c) + (0.3*d) + 
  (0.02*e) + (0.02*f) + (0.3*g) + h
<In the case of 64-bit version of JP1/AJS3 - Definition Assistant>
Export-processing-time (seconds) =
  (a*a/10000000) + (0.02*a) + (0.3*b) + (0.02*c) + (0.3*d) + 
  (0.02*e) + (0.02*f) + (0.3*g) + h

(b) When the value of the BATCHEXPORT-USEMEMORY environment settings parameter is 1

Export-processing-time (seconds) =
  (0.003*a) + (0.3*b) + (0.02*c) + (0.3*d) + (0.02*e) + (0.02*f)
  + (0.3*g) + h
Legend:

a: Number of units specified for batch definition

b: Number of units specified for independent definition

c: Total number of the lines in the cell of the Previous fileds.

d: Number of modification items specified for modification

e: Total number of the lines in the cell of the marking Previous fileds

f: Total number of the lines in the cell of the marking Waiting-target units fileds

g: Number of units specified for deletion

h: Time required for saving the execution result file

The following table provides guidelines for how much time is required.

Table C‒2: Approximate time required to save an export execution results file

Execution result file size (unit: megabytes)

Required time (unit: seconds)

2

10

10

50

20

100

i: Estimate this value by referring to the values shown in the table below.
Table C‒3: i value

Version of Excel used

Value

Excel 2013 or Excel 2016

1.0

Excel 2019

1.6

(4) Estimating the ajsdaconvert command processing time

Although performance depends on differences in machine specifications, you can generally use the following formula to obtain an approximate time required for ajsdaconvert command.

ajsdaconvert command-processing-time (seconds) = (a*(8.5*b) + 5) + 30
Legend:

a: Number of files before conversion

b: File size of the execution result file (megabyte)

Estimate the size of the file by using the execution result file that has the largest size before conversion.

If the above process is difficult, estimate the size by using the following formula:

File size of the execution result file (megabytes) = c*d

c: Average size of the unit definition

Estimate the size of the standard output file that was obtained by executing the ajsprint -a command for a single unit with the most definition information defined.

If the above process is difficult, estimate the size by using the value 0.007.

d: Number of units

If all of the files before conversion are in xls format, estimate the size by using either the value of MAX-IMPORT-UNIT or MAX-EXPORT-UNIT in the environment settings parameters, whichever is larger.

For other formats, estimate the size by using the value of XLSM-MAX-IMPORT-UNIT or XLSM-MAX-EXPORT-UNIT in the environment settings parameters.