dropping temp TBLspace

Posted in 1998

Allen Jantzen — Mon, 14 Sep 1998 13:17:05 GMT — source: Informix-list mailing list archive (1991-1998)

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