ODBC-ACCESS-INFORMIX-PROBLEM

i got the following message (cannot write sorted rows #-567) when i'm starting an odbc-access-informix connection. this messages i only got by great databases with more than 20000 rows. is there anybody who can give me a solution for my problem michael klimt Sent via Deja.com http://www.deja.com/ Before you buy.

michael_klimt@my-deja.com wrote: > > i got the following message (cannot write sorted rows #-567) when i´m > starting an odbc-access-informix connection. this messages i only got by > great databases with more than 20000 rows. > > is there anybody who can give me a solution for my problem You are running out of sort-work temp file space during a sort. Read the relevant sections of the Administrators Guide manual to see where you need to add space which depends on several factors including the settings of three environment variables: DBSPACETEMPPSORT_DBTEMP and can refer to ROOTDBS, and temp dbspaces, the current table's dbspace(s), filesystems listed in PSORT_DBTEMP. Art S. Kagel