Re: Temporary dbspace
I found out the DBTEMP should not be set at all. This is nologer used with
the 7.x DSA online engines.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet: cherylk@spamis.jcdc.doleta.gov
OR
cherylk@prod1.jcdc.doleta.gov
OR
kendric@gwysmtp.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Thu, 28 Mar 1996, Melvin Mariney wrote:
} cherylk@prod1.jcdc.doleta.gov (Cheryl Kendricks) wrote:
}
} >Do you mean that if I create a dbspace and do not denote it as a temp
} >dbspace, yet include it in my DBSPACETEMP in my profile and configuration
} >the engine does not realize this as a TEMP DB space? There are 3 places to
} >identify temp db space:
} > On UNIX w/ AIX in the user's .profile variable DBTEMP
} > In the Informix Configuration file variable DBSPACETEMP
} > On the Informix Onmonitor Menu when you create the db space TEMP [ ]
}
} >Well I set it on the first 2 and not the third, but by your statement
} >Informix will not reconize this as a TEMP DBSPACE since I did not say Yes
} >(Y) to the third option.
}
} >Is this true?
}
} Cheryl,
}
} Tolly is right....if you do not specify a 'Y' in the TEMP field of
} ONMONITOR when creating a dbspace or the 't' option if using onspaces,
} Informix does not treat this dbspace as a temporary dbspace.
}
} >
}
} --
}
} Melvin Mariney, Informix DBA
} e-mail: melvin.mariney2@bridge.bellsouth.com
}
}