Re: I-Star & server sorting temp dir

In article <422oao$dog@celebrian.otago.ac.nz>, andy@dcc.govt.nz (Andy Calverley) wrote: >We have two hosts connected using I-Star, if one is acting as the >client and the other the server, how is it possible to get the server >sqlturbo process (as forked by the sqlexecd daemon) to do any sorting >in a directory other than /tmp? > >I have tried starting up the sqlexed with DBTEMP and TMPDIR set to >dir's other than /tmp but this just creates a problem whereby the >sqlturbo process can't write *any* sort rows. Note that this is *not* >a problem with file system space, dir existance ... > With online, DBTEMP points to a DBSPACE. Your create a chunk (either a raw volume, logical volume, or cooked file), assign it the correct permissions, and then assign that chunk to the DBSPACE. Hope this helps, Gary Mitchell Lexmark International mitch@lexmark.com >Any ideas anyone? > > > >_______________________________________________________ > >Andy Calverley Internet: andy@dcc.govt.nz >Database Administrator >Technical Support >Management Information Systems >Dunedin City Council >PO Box 5045, Dunedin, New Zealand > >