Re: dropping temp TBLspace
In article <35fd15f0.70581570@kiosk>, allenj@ndr.com (Allen Jantzen)
wrote:
> Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following
> appears in $INFORMIXDIR/online.log on the way back up
>
> 13:45:23 Dropping temporary TBLspace 300061, recovering 96 pages.
> 13:45:23 Dropping temporary TBLspace 3000c0, recovering 176 pages.
> 13:45:23 Dropping temporary TBLspace 3000c7, recovering 32 pages.
> 13:45:23 Dropping temporary TBLspace 300105, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300120, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300121, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300122, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300123, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300124, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300125, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300126, recovering 8 pages.
> 13:45:23 Dropping temporary TBLspace 300127, recovering 8 pages.
> ..................and so on>
> Can anyone tell me what is causing this?? Is this a bad thing??
>
> Aren't any temp tables created by a database process dropped when the
> process ends??
>
> I am creating temp tables in a few processes w/ the NO LOG option. Is
> this the culprit?
>
> TIA
>
> Allen
>
>
The engine has stopped all by itself or else kill with users still
connected. When the engine is restarted the temp areas are being tidied.
Shouldn't cause you a problem.
Paul Watson # I don't suffer from
WF Software Ltd. # stress, I'm just
Tel. (+44) 1436 674729 # a carrier
Fax. (+44) 1436 678693 #
www.wfsoftware.co.uk