• SAPDBA is installed correctly. Refer to SAPDBA Setup.
• You know how to use SAPDBA and have logged on. Refer to Starting SAPDBA.

1. To view information about devices in the database, choose Dbspaces ® Analyze Dbspace Reports ® List Devices in SAPDBA.

What you see depends on your operating system, UNIX or NT.

UNIX

When you list device information, you see entries similar to the following examples:

dev	rawdevice	dbsname	size[KB]	free[KB]	free[%]	accessed	accessed[%]
1	data1	rootdbs	50000	23278	46.6	9803	9.2
1	data1	psapuser1	20000	19878	99.4	25	0.0
1	data1	psapstab	600000	0	0.0	2596	2.4
1	data1	GAP	98000	98000	100.0	0	0.0
1	data2	physdbs	20212	106	0.5	343	0.3
1	data2	psappool	200000	0	0.0	2285	2.1
1	data2	psapdocu	450000	29582	6.6	21892	20.6
1	data2	GAP	17788	17788	100.0	0	0.0
....

Each line refers to an area on a device. This area can either be a chunk (that is, recognized by the database server as a valid storage area holding data) or a gap (that is, free space that might become a chunk in the future). This report is very similar to Listing Chunks with SAPDBA, but differs in the following ways:

– Extra lines are displayed showing gaps (that is, free space) on the device. The gaps are available to add chunks if you need to set up a new dbspace or extend an existing dbspace.

– The columns accessed and accessed[%] only appear on this report.

– The columns in the report are explained in the following table:

Column	Meaning
dev	The physical device (that is, disk drive) on which the chunk (or gap) resides. A physical device normally contains a number of chunks and gaps. Therefore, the same value of dev appears on a number of different lines in this report. A question mark appears if your R/3 System was installed before Release 2.1G.
rawdevice	The raw device on which the chunk (or gap) resides. For example, a chunk in R/3 might lie in the directory $INFORMIXDIR/sapdata/physdev3/data4 . The value of rawdevice in this example is data4. A raw device normally contains a number of chunks. Therefore, the same value of rawdevice appears on a number of different lines in this report.
dbsname	The name of the dbspace to which the chunk belongs. If a dbsname (other than gap) appears on two or more lines, this means that the dbspace is composed of two or more chunks. If gap appears, this portion of space is not yet set up as a chunk, that is, it is not actually allocated to a dbspace. A gap is free space that you can use to add a chunk.
size [KB]	The total size of the chunk or gap, in kilobytes
free [KB]	The remaining contiguous free space available in the chunk, in kilobytes. For a gap, this is equivalent to size because a gap consists of free space.
free [%]	The amount of free space expressed as a percentage of the overall size of the chunk or gap. For a gap, this is always 100% because a gap is by definition composed of free space.
accessed	The number of disk accesses for the chunk.
accessed [%]	The percentage of all disk accesses for the chunk.

NT

You see entries similar to the following examples:

drive	free[KB]
C	10030
D	14404
.....

Each line refers to a single disk drive, as follows:

- drive refers to the name of the disk drive.

- free [KB] refers to the remaining free space available on the disk drive.

2. For more information about printing the report, see Printing a SAPDBA Report.

You have a better picture of the space situation in the devices of your Informix database. For more information, see Management of Informix Database Growth.