Exam Code: C2090-918
Exam Name: System Administration for IBM Informix Dynamic Server V11
An application uses temporary tables which currently reside in the rootdbs. The DBA has just added a temporary dbspace called “tempdbs” but notices that none of the temporary tables are using the dbspaces. Which action would the DBA take to force the temporary tables into the temporary dbspace?
A. Set TEMP DBSPACE to “tempdbs”.
B. Add another temp dbspace since the temp dbspace must be full.
C. Set the onconfig parameter TEMPTAB_NOLOG to 1.
D. Drop and re-create the temp dbspace.