Re: Simple(?) question

but you can call any system command from stored procedure Piotr Art S. Kagel wrote: > Andy R. wrote: > > > > Hi everybody, > > > > I have a pretty simple question or two regarding the informix 7.x db's, and > > would appreciate any help:) > > > > Most of my experience is with Oracle and Sybase/MS-SQL, I have no practical > > experience with Ifmx. > > My question is this: > > In Oracle or MS-SQL I can create the devices(spaces) with a sql command, > > that includes the creation and naming of the physical (os) device file. Can > > this be done in informix? If so what is the command/SP? > > No. You can do this either in onmonitor or using the onspaces utility. > To create a dbspace: > > onspaces -c -d dbspace_name -p device -o offset -s size [-m mpath offs]> > to add an additional chunk (ie piece of disk) to an existing dbspace: > > onspaces -a dbspace_name -p device -o offset -s size [-m mpath offs]> > Informix dbspaces are ROUGHLY equivalent to Oracle tablespaces but more > flexible. The offset allows you to define more than one dbspace or > chunk on the same device such that no two chunks overlap. > > In the above: > device - device or file name or (better) a link to a disk device or > file. > offset - offset in KB indicating the disk position to start using for > this chunk/dbspace. > size - size of the chunk in KB. > mpath - device or file name or link for this chunk's mirror disk. > offs - offset for the mirror chunk. > > Art S. Kagel -- Piotr Micygiewicz Caton-Zalbix Corp. sp. z o.o. Software Group Manager 51-622 Wroclaw Poland ul.Kopernika 11 tel: (+4871) 729600, 729604 fax: (+4871) 729101 -------------------------------