Utility Statements › FORMAT › Examples

Examples

Formatting a segment

The following illustration shows a segment that includes three files:

┌────────┬────────┬────────┐
│ FILE_1 │ FILE_2 │ FILE_3 │
├────────┴────────┴────────┤
│        SEGMENT_A         │
└──────────────────────────┘

To format all the files associated with the segment illustrated above, you could use the following FORMAT statement:

format segment segment_a;

Reformatting by database file

The following left-hand illustration shows two areas, each of which maps to a single database file. The right-hand illustration shows a single area that maps to two database files.

┌────────────┬────────────┐          ┌────────────┬────────────┐
│   FILE_1   │   FILE_2   │          │   FILE_1   │   FILE_2   │
├────────────┼-----------─┤          ├────────────┴────────────┤
│   AREA_A   │   AREA_B   │          │         AREA_A          │
└────────────┴────────────┘          └─────────────────────────┘

The FORMAT utility can reformat the portions of the database illustrated above either by file or by area. However, because processing by file is more efficient, you would use the following FORMAT statements to do the job in both cases:

format file segment_a.file_1;
format file segment_a.file_2;

Reformatting by area

The following left-hand illustration shows two areas that map to a single database file. The right-hand illustration shows an area that maps to two database files, one of which also contains another area.

┌─────────────────────────┐          ┌────────┬────────────────┐
│         FILE_1          │          │ FILE_1 │     FILE_2     │
├────────────┬────────────┤          ├────────┴───────┬────────┤
│   AREA_A   │   AREA_B   │          │     AREA_A     │ AREA_B │
└────────────┴────────────┘          └────────────────┴────────┘

To reformat AREA_A in either illustration, you must use the following FORMAT statement:

format area segment_a.area_a;

Formatting a journal file

The following FORMAT statement requests formatting of the disk journal named SYSJRNL1:

format journal sysjrnl1;

Formatting by SEGMENT

In the following example, three database files are formatted for an SQL-defined database using the SEGMENT option of the FORMAT utility.

A CONNECT to the segment or database name containing the table definitions is issued. This is necessary so that the INSTALL STAMPS utility can automatically install area and table stamps during the FORMAT operation.

connect to syssql;
 format segment userdb;

Formatting SYSTRK Files

The following sample IDMSBCF statement instructs the FORMAT utility to format three new SYSTRK files (track01, track02, track03). It directs the utility to format the files to have the default page size of 7548 and contain 60 pages each. CA IDMS will maintain 3 active mirrors.

format systrk track01, track02, track03
   initial file count 3
   file size 60;