What should I do when I insert a record and find that the database is full?

The only way to solve this problem is to increase the size of the tablespace for the database. Since the type of tablespace must be regular (otherwise you would not see this error message, since an autoextend tablespace expands as needed), there are two ways to increase the size. One way is to add files to the tablespace. The other is to add pages to the tablespace. You can enlarge the tablespace by issuing dmSQL commands.

Add files to the tablespace: Suppose you have a tablespace ts1 for the database MY_DB, and you want to add a data file f7 to the tablespace. You would make the following entry in dmconfig.ini:

[MY_DB] f7 = /disk1/usr/f7.dat 3000

The following SQL command adds the datafile f7 into the tablespace ts1

dmSQL> ALTER TABLESPACE ts1 ADD DATAFILE f7;

Add pages to the tablespace: The following example extends the size of the file f1 by adding 100 pages. The file f1 must already exist and be associated with some tablespace.

dmSQL> ALTER DATAFILE f1 ADD 100 pages;