Estimating disk space required for Embedded RDB

This subsection provides formulas for determining the disk space required when using Embedded RDB as the database. If a calculation results in a decimal fraction, round it up to the next integer.

In the formulas, remote installation-related job and remote collection-related job mean one of the jobs listed below.

Remote installation-related jobs:

Install package job
Transfer package to relay system job
Send package, allow client to choose job

Remote collection-related jobs:

Collect files from client job
Collect files from client to relay system job

Organization of this subsection: (1) Disk space required for work table files; (2) Disk space required for the resident table file; (3) Disk space required for the index file; (4) Disk space required for the job-related binary object file; (5) Disk space required for the asset information-related binary object file; (6) Disk space required for the software operation monitoring log file; (7) Disk space required for the updated program management file; (8) Disk space required for the temporary table file; (9) Notes on differences between sizes for version 08-00 and earlier and version 08-10 and later

(1) Disk space required for work table files

Out of the disk space requirements described below, use the maximum value as the estimate for the worktable area.

Disk space required by the basic functions
Disk space required by Inventory Viewer
Disk space required by the CSV output utility
Disk space required by the operation log list

The following gives the formulas for calculating these disk space requirements.

(a) Disk space required for the basic functions

Disk space required for the basic functions (bytes) =: [(average number of clients per job 2) x 4096 x 2 x 2]; + [(average number of clients per job 3) x 4096 x 2 x 2]; + [(average number of clients per job 3) x 4096 x 2 x 2]

(b) Disk space required for Inventory Viewer

Disk space required for Inventory Viewer (bytes) =: ((average number of system information items to be acquired by system + number of user inventory items + number of registry items to be acquired) x number of clients 4) x 4096 x 2 x 9

(c) Disk space required for the CSV output utility

For the disk space required for the CSV output utility, choose the maximum value from the results obtained from the formulas shown below.

Destination attribute (bytes) =: [(number of clients belonging to host group 7) x 4096 x 2 x 2]; + [(number of clients belonging to ID group 32) x 4096 x 2 x 2]; + [(number of clients 51 x 4096 x 2 x 2)]

Package attribute (bytes) =: (number of packages 57) x 4096 x 2 x 5

Inventory (bytes) =: [(number of user inventory items 255) x 4096 x 2 x 5]; + [(number of user inventory items 11) x 4096 x 2 x 2]

Registry information (bytes) =: (number of registry items to be acquired x number of clients 5) x 4096 x 2 x 2

Installed package information (bytes) =: (average number of software information items to be acquired x number of clients 19) x 4096 x 2 x 2

Job execution status (bytes) =: (average number of clients per job x average number of packages per job (use 1 in all cases except for remote installation-related jobs) 6) x 4096 x 2 x 2

User management information (bytes) =: (number of user inventory items x number of clients 14) x 4096 x 2 x 2

Software inventory (bytes) =: (number of files to be managed by software inventory dictionary x number of clients 12) x 4096 x 2 x 2

Package content (bytes) =: ((number of packages + 1) 184) x 4096 x 2 x 2

Microsoft Office product information (bytes) =: (number of Microsoft Office products to be managed x number of clients 8) x 4096 x 2 x 2

Anti-virus product information (bytes) =: (number of anti-virus products to be managed x number of clients 19) x 4096 x 2 x 2

Startup suppression logs (bytes) =: [(number of clients + number of clients with startup suppression logs 19) x 4096 x 2 x 2]; + [(number of clients + number of clients with startup suppression logs 56) x 4096 x 2 x 2]

(d) Disk space required for the operation log list

For the disk space required for the operation log list, choose the maximum value from the results obtained from the formulas shown below.

Operation log list (bytes) =: (total number of operation information items (suppression logs and operation logs) 1) x 4096 x 2 x 2

Operation log details (bytes) =: (total number of operation information items (suppression logs and operation logs) 1) x 4096 x 2 x 2

Disk space required for the operation log total (bytes) =: [(total number of operation information items (suppression logs and operation logs) 1) x 4096 x 2 x 2]; + [(total number of operation information items (suppression logs and operation logs 184) x 4096 x 2 x 2]

(2) Disk space required for the resident table file

Size of a resident table file (bytes) =: (1048576 x 2); + {[135 x (number of cabinets + 2)]; + [421 x (number of remote collection-related jobs x average number of clients per job)]; + [1028 x (number of remote installation-related jobs x average number of packages per job x average number of clients per job); + (number of jobs other than remote installation-related jobs x average number of clients per job)]; + [972 x (number of remote installation-related ID group jobs managed by the relay managing the ID x average number of packages per job x average number of clients per ID group); + (number of ID group jobs other than remote installation-related jobs x average number of clients per ID group)]; + [96 x number of ID groups]; + [654 x (number of ID groups x average number of relays per ID group x average number of clients registered per ID group)]; + [360 x (number of clients x average number of files to be acquired by searching software inventory)]; + [488 x (number of clients x average number of system information items to be acquired)]; + [600 x (number of jobs defined + number of folders)]; + [1256 x (number of remote collection-related jobs defined x number of folders)]; + [802 x ((number of jobs defined x average number of clients per job) + number of folders)]; + [1798 x ((number of remote installation-related jobs defined x average number of packages per job) + number of folders)]; + [348 x (number of Get software information from client jobs defined + number of folders)]; + [206 x (number of Transfer user inventory schema to client jobs defined + number of folders)]; + [352 x (number of jobs + number of folders)]; + [406 x (number of ID groups managed by the relay managing the ID x total number of ID groups specified by ID group jobs)]; + [114 x (number of remote installation-related jobs x average number of packages per job)]; + [76 x (number of items in the software search list + 1)]; + [234 x (number of hosts in the system configuration when OpenView Linkage is used)]; + [634 x (number of clients + number of host groups)]; + [122 x number of packages]; + [918 x (number of packages + number of cabinets)]; + [148 x number of jobs scheduled and executed]; + [194 x (number of remote installation-related jobs x average number of packages per job x average number of clients per job) + (number of jobs other than remote installation-related jobs x average number of clients per job)]; + [346 x number of clients x number of user inventory items]; + [768 x number of user inventory items]; + [1204 x (number of clients x average number of software information items to be acquired)]; + [464 x (number of all-lower-clients jobs defined x total number of relay managers specified by all-lower-clients jobs)]; + [610 x number of hosts from which registry information is to be collected x number of registry items to be acquired]; + [358 x number of registry acquisition entries to be created]; + [1514 x number of hosts in the system configuration]; + [918 x number of files to be managed in the software inventory dictionary]; + [126 x number of files whose licenses are to be managed]; + [406 x number of files whose deletion is to be managed in the software inventory dictionary]; + [1970 x (number of clients for which Microsoft Office products are to be obtained + number of Microsoft Office products to be managed)]; + [1950 x (number of clients for which anti-virus products are to be obtained + number of anti-virus products to be managed)]; + [806 x number of automatic host group maintenance policies]; + [2780 x number of automatic ID group maintenance policies]; + [1156 x number of system configuration information deletion entries]; + [452 x number of uninstalled JP1/Software Distribution hosts]; + [208 x number of conditions set in search host]; + [276 x number of communities specified in the search host settings]; + [440 x number of hosts found by search host]; + [266 x number of Report message jobs defined]; + [175 x number of software operation monitoring policies]; + [77 x (number of software operation monitoring policies x 7^#1)]; + [770 x number of programs to be monitored]; + [473 x number of programs for which operation time is to be acquired]; + [176 x number of permitted software monitoring information entries]; + [556 x 10000^#2]; + [254 x number of Set the software monitoring policy jobs defined]; + [342 x number of filtering conditions specified in operation monitoring policies]; + [138 x number of USB media access suppression exclusion conditions]; + [939 x number of patch information items]; + [22 x 3]^#3; + [14]^#4; + [280]^#5; + [64]; + [2731 x (number of domains + number of OUs + number of groups + number of computers + number of users)]; + [2305 x (number of OUs x number of items to be collected from OUs) + (number of groups x number of items to be collected from groups) + (number of computers x number of items to be collected from computers) + (number of users x number of items to be collected from users)]; + [2024 x (number of items to be collected from OUs + number of items to be collected from groups + number of items to be collected from computers + number of items to be collected from users)]; + [3157 x number of domains]; + [66 x number of members belonging to groups]; + [165 x number of Web access log filtering conditions]}

#1: Number of device types

#2: Maximum number of suppression history events to be saved

#3: Number of management items at the last modification date for system configuration information, system configuration information deletion history, and uninstalled host information

#4: Valid period setting for search hosts results

#5: Patch management information

(3) Disk space required for the index file

Size of the index file (bytes) =: (1048576 x 2); + {[8 x (number of cabinets + 2)]; + [28 x (number of remote collection-related jobs x average number of clients per job)]; + [672 x (number of remote installation-related jobs x average number of packages per job x average number of clients per job); + (number of jobs other than remote installation-related jobs x average number of clients per job)]; + [368 x (number of remote installation-related ID group jobs managed by the relay managing the ID x average number of packages per job x average number of clients per ID group); + (number of ID group jobs other than remote installation-related jobs x average number of clients per ID group)]; + [36 x number of ID groups]; + [328 x (number of ID groups x average number of relays per ID group x average number of clients registered per ID group)]; + [360 x (number of clients x average number of files to be acquired by searching software inventory)]; + [280 x (number of clients x average number of system information items to be acquired)]; + [208 x (number of jobs defined + number of folders)]; + [208 x (number of remote collection-related jobs defined x number of folders)]; + [172 x (number of ID groups x average number of relays per ID group x average number of clients registered per ID group)]; + [548 x ((number of jobs defined x average number of clients per job) + number of folders)]; + [276 x ((number of remote installation-related jobs defined x average number of packages per job) + number of folders)]; + [208 x (number of Get software information from client jobs defined + number of folders)]; + [36 x (number of Get user inventory information jobs defined + number of folders)]; + [272 x (number of jobs + number of folders)]; + [276 x (number of ID groups managed by the relay managing the ID x total number of ID groups specified by ID group jobs)]; + [28 x (number of remote installation-related jobs x average number of packages per job)]; + [40 x (number of software search list items + 1)]; + [76 x (number of hosts in the system configuration when OpenView Linkage is used)]; + [144 x (number of clients + number of host groups)]; + [8 x number of packages]; + [72 x (number of packages + number of cabinets)]; + [144 x number of jobs scheduled and executed]; + [120 x (number of remote installation-related jobs x average number of packages per job x average number of clients per job)] + [number of jobs other than remote installation-related jobs x average number of clients per job]; + [136 x number of clients x number of user inventory items]; + [136 x number of user inventory items]; + [116 x (number of clients x average number of software information items to be acquired)]; + [320 x (total number of all-lower-clients jobs x total number of relay managers specified by all-lower-clients jobs)]; + [328 x number of hosts from which registry information is acquired x number of registry items to be acquired]; + [260 x number of registry acquisition entries created]; + [168 x number of hosts in the system configuration]; + [408 x number of files managed in software inventory dictionary]; + [108 x number of files whose licenses are to be managed]; + [296 x number of files whose deletion is to be managed]; + [328 x (number of clients + number of Office products to be managed)]; + [588 x (number of clients + number of anti-virus products to be managed)]; + [12 x number of automatic destination maintenance policies]; + [72 x number of system configuration information deletion history entries]; + [36 x number of hosts in which JP1/Software Distribution has not been installed]; + [20 x number of conditions set in search host]; + [12 x number of communities specified in search host settings]; + [24 x number of hosts found in host search]; + [208 x number of Report message jobs defined]; + [68 x number of software operation monitoring policies]; + [72 x (number of software operation monitoring policies x 7^#1)]; + [76 x number of programs to be monitored]; + [340 x number of programs for which operation time is to be acquired]; + [473 x number of operation time information items to be acquired]^#2; + [348 x number of permitted information items for software operation monitoring]; + [68 x 10000^#3]; + [208 x number of Set the software monitoring policy jobs defined]; + [336 x number of filtering conditions specified in operation monitoring policies]; + [160 x number of software operation monitoring log information items]^#4; + [68 x number of USB media access suppression exclusion conditions]; + [304 x (number of domains + number of OUs + number of groups + number of computers + number of users)]; + [36 x (number of OUs x number of items to be collected from OUs) + (number of groups x number of items to be collected from groups) + (number of computers x number of items to be collected from computers) + (number of users x number of items to be collected from users)]; + [12 x (number of items to be collected from OUs + number of items to be collected from groups + number of items to be collected from computers + number of items to be collected from users)]; + [260 x number of domains]; + [72 x number of members belonging to groups]; + [68 x number of Web access log filtering conditions]

#1: Number of device types

#2: Number of operation time information items acquired =: 220 x number of clients x number of programs for which operation time is to be acquired

#3: Maximum number of suppression history events to be saved

#4: Number of software operation monitoring log information items =: number of clients to be subject to software operation monitoring; x size of operation information acquired for 1 client per day; x number of days operation information is to be retained

(4) Disk space required for the job-related binary object file

(5) Disk space required for the asset information-related binary object file

(6) Disk space required for the software operation monitoring log file

Size of a software operation monitoring log file (bytes) =: 4194304; + (1363 x number of software operation monitoring log entries)^#1; + [80 x number of operation time information items acquired]^#2

#1: To determine the number of software operation monitoring log entries, use the following formula:

Number of software operation monitoring log entries =: number of clients subject to software operation monitoring; x size of operation information acquired for 1 client per day; x number of days operation information is to be retained

#2: Number of operation time information items acquired =: 220 x number of clients x number of programs for which operation time is to be acquired

For clients in a virtual environment, the number of information items collected increases in proportion to the number of login users. Therefore, add the number of expected login users to number of clients.

If you use the dcmmonrst command provided by JP1/Software Distribution, you can also store in the database the operation information whose retention days specified at setup have expired. When you determine the number of days operation information is to be retained, take into account the number of days operation information is stored in the database by the dcmmonrst command.

(7) Disk space required for the updated program management file

(8) Disk space required for the temporary table file

(9) Notes on differences between sizes for version 08-00 and earlier and version 08-10 and later

When you upgrade from version 08-00 or earlier to version 08-10 or later, the database structure is different so the disk space required by the database is also different. This means that an error may occur during upgrading due to insufficient disk space.

Before you upgrade, re-estimate the amount of disk space required for the database. You can change the size of the database when you upgrade.

The formulas provided below are applicable if, after upgrading, you use only the functions supported in version 08-00 or earlier. To use the new functions supported in version 08-10 and later, you must use the formulas in subsections (1) through (8) above to calculate the database size of the additional functions.

The following subsections provide the formulas for calculating the database size needed in version 08-10 and later, based on the database size in version 08-00 and earlier.

(a) Resident table file

Size of resident table files (bytes) =: size of version 08-00 or earlier resident table files; + [73 x (number of cabinets + 2)]; + [233 x (number of remote collection-related jobs x average number of clients per job)]; + [1008 x (number of remote collection-related jobs defined x number of folders)]; + [736 x ((number of remote installation-related jobs defined x average number of packages per job) + number of folders)]; + [746 x (number of packages + number of cabinets)]; + [908 x (number of clients x average number of software information items to be acquired)]

(b) Index file

No changes have been made to index files.

(c) Job-related binary object file

Size of job-related binary object file (bytes) =: size of version 08-00 or earlier job-related binary object file; - {[7 x (number of remote collection-related jobs x average number of clients per job)]; + [15 x (number of remote collection-related jobs x number of folders)]; + [20 x ((number of remote installation-related jobs x average number of packages per job) + number of folders)]}; x 8192

(d) Asset information-related binary object file

Size of asset information-related binary object file (bytes) =: size of version 08-00 or earlier asset information-related binary object file; - {[7 x (number of cabinets + 2)]; + [7 x (number of packages)]; + [7 x (number of clients x average number of asset information items per client)]}; x 8192

(e) Software operation monitoring log file

No changes have been made to the software operation monitoring log file.

(f) Temporary table file

No changes have been made to the temporary table file.

All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.

5.4.1 Estimating disk space required for Embedded RDB