How can You Control Where Temporary Tables go During an Archive?

Technote (troubleshooting)


Problem(Abstract)

Ontape and onbar archives often use temporary space on disk. How do you control which dbspaces are used?

Resolving the problem

Transaction activity during an archive generates before-images in the physical log. These cannot be written to the parent table extents during archive checkpoints and are instead written to temporary tables. The temporary table contents are ultimately added to the archive media. An ontape or onbar archive locates the temporary tables in the rootdbspace by default. If you want the archive to use other spaces, set those spaces using DBSPACETEMP in the configuration file or the environment. If both are set, the environment DBSPACETEMP setting overrides the configuration setting. The temporary tables can be created in regular dbspaces and temporary dbspaces.

Related information

onbar archive fails with error -131
DBSPACETEMP configuration parameter
DBSPACETEMP environment variable

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

11.1, 11.5, 11.7, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

1605611

Modified date:

2013-04-22

Translate my page

Machine Translation

Content navigation