Greetings,
I am working on an HP-UX 10.01 system running On-Line 7.13.UC1
the the ESQL/C and ISQL packages installed. Lately, I've
noticed a problem with temp tables not getting cleaned up.
Initially I had DBSPACETEMP defined as the same dbspace as my
root dbspace. After running about a week, the root dbspace
filled to capacity. I looked at the SMI tables, oncheck -pe,
and onstat -d and noticed the free space was decreasing but
there was nothing in that space. After restarting the engine
it went through and cleaned up the temporary table space, and
I was back to normal.
I created a new dbspace and defined it as a temp dbspace and
set DBSPACETEMP to this dbspace in my onconfig file. After
restarting the engine, now my temporary dbspace is filling
up with temp tables and the space is not being freed.
The question is, is there something I've configured improperly
or is this something I must accept? If I must accept this,
is there a utility available that will search the dbspace and
free the unused temp tables while the engine is online?