|
|
|
The CA Datacom/AD database files are sequential files allocated in install job WRDCM$04. The database tables are in eight files. Each table has an associated table ID that CA Datacom/AD uses to reference it. The following tables show the allocations supplied in cylinders for the production (500) database. Also, there is an approximation of how many rows each table holds when fully extended, based on these allocations. Job WRDCM$04 allocates the files with the following space allocations:
|
Table ID (Name) |
Primary |
Secondary |
Rows |
|---|---|---|---|
|
NO 7 (RESOURCE) |
20 |
20 |
About 14000 |
|
NO4 (NUMERICFACT) |
240 |
40 |
About 8000000 |
|
NO2 (ENUMERATEDFACT) |
30 |
5 |
About 112500 |
|
NO6 (PERIOD) |
5 |
1 |
About 105000 |
Note: The tables above will grow and extend in your database.
|
Table ID (Name) |
Primary |
Secondary |
Rows |
|---|---|---|---|
|
NO 1 (ATTRIBUTE) |
1 |
1 |
About 320 |
|
NO8 (TIMEFRAME) |
1 |
1 |
About 25 |
|
NO5 (PERFORMANCEAGENT) |
1 |
1 |
About 6 |
|
NO3 (KEYRANGE) |
1 |
1 |
About 4 |
Note: The tables will not grow beyond the supplied values in your database.
The NUMERICFACT table will expand the most. The supplied PRIMARY allocation of 240 cylinders and the SECONDARY allocation of 40 cylinders will allow this table to hold approx. 8,000,000 records when the file has expanded to its allowable 16 extents. This is based on the following formula:
240 3390 cylinders = approx. 2250000 records 40 3390 cylinders = approx. 375000 records
You can increase the PRIMARY and SECONDARY allocations for the NUMERICFACT table to suit your requirements.
| Copyright © 2012 CA. All rights reserved. |
|