Re: invalid dbspace

Those messages have to do with your definition of temporary dbspaces, as indicated by the environment variable "DBSPACETEMP". A temporary dbspace is where Online will create temporary tables used for queries. Check either your onconfig file for DBSPACETEMP, or if not there DBSPACETEMP may be set as a shell environment. Basically, the message is saying that you have indicated that you want to store temporary tables in a dbspace called "tmpdbs1", but it does not exist. To see your extant dbspaces, run `onstat -d`. Cosmo Paul Watson wrote: > > I have been receiving this message for awhile..it hasn't seemed to > > affect normal functionality...but, I still would love to know what > > this message means: > > > > Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. > > > > lrwxr-xr-x 1 informix informix 19 Oct 16 1996 tmpdbs -> > > /dev/vg03/rlvtmpdbs > > > > ls -ld /dev/vg03/rlvtmpdbs > > crw-rw---- 1 informix informix 64 0x030002 Jan 24 1997 > > /dev/vg03/rlvtmpdbs > > > > Any ideas? > > > You can get this problem in some of the 7.1x releases if you restore a DB > that has temp dbspaces. > > -- > Paul Watson > WF Software Ltd. > Tel: +44 1436 674729 > Fax: +44 1436 678693 > Email: paulw@wfsoftware.co.uk -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *