When you created the tempdbs, did you specify that it was to be a temporary space
in the onspaces command (-t)? You can check by looking to see if the temp flag
is
set in the onstat -d output.
Vic
davin_harvey@dsti.co.uk wrote:
>
>
> Hi,
> =20
> I have Online 7=2E23=2EUC6 running on AIX 4=2E2, with over 1/2 Gb avai=
> lable=20
> in my tempdbs=2E DBSPACETEMP is set to tempdbs in the onconfig file,=20
> and is not set in my environment=2E However, any temp table created,=20
> implicitly or explicitly, goes into my rootdbs, which has only 40Mb=20
> free=2E Any ideas anyone?
> =20
> TIA
> Davin
>
> **********************************************************************
> DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu=
> k=20
>
--
Vic Goldberg
Manager, DBA Team, Cornell University
(607) 254-7441 (Voice) (607) 255-6982 (Fax)