Re: invalid dbspace

Pierre Bosman wrote: > > Hi > > Check in your onconfig file and search for the DBSPACETEMP setting. You > have this setting set in there. > Then go into onmonitor and go and check the valid dbspaces. > > You will most likely find that the dbspace was created and then later > dropped and reassigned. All you need to do > is take it out of the onconfig file, or set it up again. Since DBSPACETEMP is also an overridding environment variable this could be a user with an old environment, an old cron job, or a user connecting from another machine with a differently named tempspace. I have seen all three situations. It is harmless except that that connection is using rootdbs for temp tables and sortspace (assuming PSORT_DBTEMP is not set also). Art S. Kagel