UDS TIP Number

In the UDS TIP Number box, enter the value of the TIP file number on which the table is to be stored.

Enter a value in the range of 1 through 262143.

This field is disabled if the No TIP check box is selected.

No TIP

Select the No TIP check box to store the table as an EXEC file. This check box is selected by default.

Page Size

From the Page Size drop-down box, select a larger page size, in words, than that calculated automatically by Developer.

It is advisable to let the page size be automatically calculated for the first generation of your System. You can then check the calculated page size before setting a larger one.

After generation you can find the calculated page sizes in the SYSTEM NAME*SYS$LIB.DDS$ file. The page sizes in this file are calculated as appropriate. They are equal to or greater than the minimum page size.

If the Default check box is selected, the default value is selected as in the following table:

Initial Reserve

In the Initial Reserve box, enter the percentage of the initial reserve that should actually be used.

By default, the system creates a file with an initially reserved area of continuous disk space.

Enter a value in the range of 0 through 100. The default value is 100, which is 100% of the calculated reserve.

Load Factor

In the Load Factor box, enter the maximum percentage of space to be used for loading each index and data page.

Enter a value in the range of 50 through 100.

The default value is 80.

Compression

Select the Compression check box, to specify that compression is to be used.

This check box is selected by default.

Pack

From the Pack drop-down list, select the name of the pack on which the table is to be stored.

Alphanumeric, maximum length = 17.

If the Default check box is selected, the Database Pack is used.

Duplex Pack

From the Duplex Pack list, select a value to set a pack for TIP Duplex.

This field is disabled if the No Duplex check box or the No TIP check box is selected or if the UDS TIP Number field is set to 0.

No Duplex

Select the No Duplex check box if you do not want to use the TIP Duplex feature. This check box is disabled if the All TIP Files Duplex option is set to True in the General configuration properties.

If the Default check box is selected, the default Duplex Pack is used.

Locking Strategy

From the Locking Strategy drop-down list, select either of the following levels at which locks are applied.

A page represents a block of memory that contains a table of one or more records. Locking an entire page is faster than locking individual records, however it means that no other users can access the records. Locking a record at a time means that more users can access the record table at the same time.

Any advantage gained by locking individual records may be limited by the type of updating required. Insert and delete operations lock the entire page, as do updates to secondary indexes and primary key values.

Audited

Select the Audited check box in the Recovery group box, to specify that after-looks are taken for the storage area.

This check box is disabled if the Default check box in the Recovery group box is selected.

Default

If you select the Default check box in the Recovery group, the default setting of the Audited option is used.

Keep Assigned

Select the Keep Assigned check box in the Tuning group box, to keep your database files assigned after usage. This saves processing time, as you do not have assignment overhead every time the database files are accessed.

If you need to access the files externally, then the status of the file must be set to DOWN by using the IRU DOWN command. If this check box is not selected, the storage area is a candidate to be freed by UDS.

This check box is disabled if the Default check box is selected.

Default

If you select the Default check box in the Tuning group box, the default setting of the Keep Assigned option is used.

Expected Number

Select Expected Number, to control the size of the various tables and files. The exception is the EVENT file which is controlled by the value entered in the Monthly Volume field of the Environment Event Options page. This option is disabled if Max Pages is selected.

The default values for each system table are displayed in the following table:

Max Pages

Select Max Pages to specify that sizing is to be calculated according to the number of pages.

You can specify the maximum number of pages allowed in the storage area. Enter a value in the range 8 through 9 999 999 999.

This option is disabled if Expected Number is selected.

Unisys Only

Data Page Factor

Specifies the UREP parameter. By default, it is set to 100.

Index Page Factor

Specifies the UREP parameter. By default, it is set to 100.

Merge Factor

Specifies the UREP parameter. By default, it is set to 40.