Interstage Shunsaku Data Manager Operator's Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

D.3.1 The Size of Director Data Files

The formula for estimating the size of director data files is shown below.

Without the direct access function:

Definition unit	Variable Elements	Size (bytes)
The director data file	Standard record size (in byte) The number of records to be added The number of record to be updated Safety factor (at least 1.3)	46,000 + ((Standard record size) x The number of records to be added + The number of add records) x Safety factor.

The number of records to be added is the total number of records that are added by using shundimport command or from the application.
The number of records to be updated is the number of records that are updated or deleted before executing shundcds command.

Example Calculation

An example calculation for the size of a director data file is shown below.

If the variable elements are as follows:

• Standard record size: 4,000 (bytes)
• The number of records to be added: 100,000 records
• The number of records to be updated: 1,000 records
• Safety factor: 1.3

  46,000 + ((76 + 4,000) x (100,000 + 1,000)) x 1.3 = 535,224,800 bytes (approx. 511 MB)

  
  

With the direct access function:

Definition unit	Variable Elements	Size (bytes)
The director data file	Standard record size (in byte) The number of records to be added The number of record to be updated Average size of direct access key Safety factor (at least 1.3)	46,000 + ((92 + Standard record size + Average size of direct access key) x (The number of records to be added. + The number of records to be updated)) x Safety factor

The number of records to be added is the total number of records that are added by using shundimport command or from the application.
The number of records to be updated is the number of records that are updated or deleted before executing shundcds command.
Average size of direct access key is the average size of the direct access key elements in 1 record.

Example Calculation

An example calculation for the size of a director data file is shown below.

If the variable elements are as follows:

• Standard record size: 4,000 (bytes)
• The number of records to be added: 100,000 (records)
• The number of record to be updated: 1,000 (records)
• Average size of direct access key: 12 bytes
  (Key name: the size of KEY1 is 4 bytes, the size of KEY2 is 8 bytes)
• Safety factor: 1.3

46,000 + ((92 + 4,000 + 12) x (100,000 + 1,000)) x 1.3 = 538,901,200 bytes (approx. 514 MB)

• Specify the calculation result for the size of a director data file to the MaxDataFileSize parameter in the director environment file.
• If direct data files are being optimized using shundcds command, the amount of disk space required temporarily is equal to twice the size of the director data files. Therefore, The disk space where director data files are located must be more than twice the size of the estimated result.