infx space func=new|extend|drop|dropchk|del|newchunk|rename|buffer|extendable|spsize fork=no
notes - The default location for chunks and chunk links is /infx/inst/${inst}/chks
- You can override this in config.ini with the CHKDIR parameter. See config.ini.
- These examples all use the default location
Specify chunk=pool to get the new chunk out of the storage pool. automatic chunks
Specify chunk=new to create a new chunk file for a storage space. The new chunk filename is generated based on the space name,
and a sequence number. Starting from dat01.000, and moving up if the name has already been used..
To override this behaviour, create your own script and set the INFXCHUNK parameter.
Specify chunk=same to create a new chunk for a storage space, by extending the size of the existing chunk. If the space already
contains multiple chunks, the last chunk in the storage space is extended. infx automatically calculates the new offset for you.
Specify size=size:offset to manually specify an offset. For example 100:500, if you want to create a 100mb chunk, with a 500mb
offset.
create a new storage space
infx space func=new space= dbtype=data|tmpdata|blob|sblob size= chunk=
[ mchunk moffset pgsize pageunit first next user Ms Mo ] fork=no
Create a new storage space, of the specified type. See the Informix Administrator's Guide for more information about storage
spaces.
create a data storage space
infx space dbtype=data name= size= chunk= [ mchunk moffset pgsize first next ] fork=no
option
|
description
|
example |
| space= |
specify the name of the new storage space |
name=dat01 |
| size= |
the initial size of the space, in megabytes |
size=100 |
| chunk= |
the initial chunk to create the space on |
chunk=dat01.001 |
| pgsize= |
specify the page size, in kilobytes, to set for this space |
pgsize=8 |
| first= |
the size, in megabytes of the first extent of the tblspace tblspace |
first=10 |
| next |
the size, in megabytes of the next extents of the tblspace tblspace |
next=5 |
| mchunk= |
optionally specify a mirror chunk for this space |
mchunk=mdat01.001 |
| moffset= |
with mchunk, specify the offset into the chunk |
moffset=0 |
| fork= |
specify fork=no to wait until the bspace is created before returning |
fork=no |
create a temporary data storage space
infx space dbtype=tmpdata name= size= chunk= pgsize= fork=no
option
|
description
|
example |
| space= |
specify the name of the new storage space |
name=tmp01 |
| size= |
the initial size of the space, in megabytes |
size=100 |
| chunk= |
the initial chunk to create the space on |
chunk=tmp01.001 |
| pgsize= |
specify the page size, in kilobytes, to set for this space |
pgsize=8 |
| fork= |
specify fork=no to wait until the space is created before returning |
fork=no |
create a blob storage space
infx space dbtype=blob name= size= chunk= [ mchunk moffset pageunit ] fork=no
option
|
description
|
example |
| space= |
specify the name of the new storage space |
name=dat01 |
| size= |
the initial size of the space, in megabytes |
size=100 |
| chunk= |
the initial chunk to create the space on |
chunk=dat01.001 |
| mchunk= |
optionally specify a mirror chunk for this space |
mchunk=mdat01.001 |
| moffset= |
with mchunk, specify the offset into the chunk |
moffset=0 |
| pageunit= |
the blob space storage unit, in pages |
pageunit=4 |
| fork= |
specify fork=no to wait until the space is created before returning |
fork=no |
create a smart blob storage space
infx space dbtype=sblob name= size= chunk= fork=no
[ mchunk moffset avg ext min snext log at buf lock temp Ms Mo ] fork=no
option
|
description
|
example |
| space= |
specify the name of the new storage space |
name=dat01 |
| size= |
the initial size of the space, in megabytes |
size=100 |
| chunk= |
the initial chunk to create the space on |
chunk=dat01.001 |
| mchunk= |
optionally specify a mirror chunk for this space |
mchunk=mdat01.001 |
| moffset= |
with mchunk, specify the offset into the chunk |
moffset=0 |
| avg= |
set sblob default AVG_LO_SIZE=, kilobytes |
avg=123 |
| ext= |
set sblob default EXTENT_SIZE=, kilobytes |
ext=100 |
| min= |
set sblob default MIN_EXT_SIZE=, kilobytes |
min=50 |
| snext= |
set sblob default NEXT_SIZE=, kilobytes |
snext=100 |
| at= |
set sblob default ACCESSTIME=ON|OFF |
at=of |
| buf= |
set sblob default BUFFERING=ON|OFF |
buf=on |
| lock= |
set sblob default LOCK_MODE=RANGE|BLOB |
lock=blob |
| log= |
set sblob default LOGGING=ON|OFF |
log=on |
| Ms= |
size, in megabytes to initially allocate for metadata |
Ms=1000 |
| Mo= |
offset, in megabytes, into the chunk to locate the metadata |
Mo=128 |
| temp= |
create permanent or temporary smart blob storage |
temp=yes |
| fork= |
specify fork=no to have the service wait until the bspace is created,
before returning |
fork=no |
extend an existing storage space
infx space func=extend space= size= chunk= [ mchunk moffset Ms Mo user ] fork=no
Increase the size of an existing storage space. You can extend any type of storage space with this command. See the
Informix Administrator's Guide for more information about storage spaces.
option
|
description
|
example |
| space= |
specify the name of the storage space to extend |
name=dat01 |
| size= |
the amount of space, in megabytes |
size=100 |
| chunk= |
the chunk to allocate this space on |
chunk=dat01.001 |
| mchunk= |
optionally specify a mirror chunk for this additional chunk |
mchunk=mdat01.001 |
| moffset= |
with mchunk, specify the offset into the chunk |
moffset=0 |
| Ms |
sblobs: amount of space, in kilobytes, to allocate for sblob metadata |
Ms=1000 |
| Mo |
sblobs: offset into chunk to store metadata |
Mo=0 |
| user |
sblob specify user=yes to allocate this chunk for user data only, no metadata |
user=yes |
| fork= |
specify fork=no to have the service wait until the sbspace is created,
before returning |
fork=no
|
drop a storage space
infx space func=drop space=
Completely remove a storage space, once it is no longer in use. All database object must be removed from the storage
space first.
drop a chunk from a storage space
infx space func=drop space= chunk= offset=
Completely remove a specific chunk from a storage space, once it is no longer in use. All database objects must be removed
from the chunk first.
Specify the name and offset of the chunk to be dropped.
rename a storage space
infx space func=space space= newspace=
Change the name of the storage space. The database server must be in quiescent mode for this service to run.
create a new chunk file
infx space func=newchunk chunk= pool=yes|no
Create a new chunk file so that it can be allocated to storage spaces. Specify pool=yes to also allocate it to the storage pool.
Specify a relative chunk path name to create the chunk directly in /infx/inst/${inst}/chks.
chunk=dat01.001 file=/infx/inst/infx01/chks/dat01.001
Specify an absolute path name, and infx creates a link in /infx/inst/${inst}/chks to this file. The name of the link
will be the base name from the path.
chunk=/data/infx01/dat01.001 link=/infx/inst/infx01/chks/dat01.001
Specify a raw device name, and infx creates a link in /infx/inst/${inst}/chks, called ${server}.${seq}. ${server} is the instance anme, ${seq} is a sequence number starting from 000 chunk=/dev/rdsk/vol1 link=/infx/inst/infx01/chks/infx01.000
chunk=/dev/rdsk/vol2 link=/infx/inst/infx01/chks/infx01.001
Specify either an absolute path to a file, or a raw device and specify the name to be used for the new chunk. The "as" parameter can be specified to override the default infx naming of the link.
chunk=/dev/rdsk/vol1 as=vol1 link=/infx/inst/infx01/chks/vol1
chunk=/data/infx01/dat01.001 as=dat01 link=/infx/inst/infx01/chks/dat01
remove a chunk file
infx space func=del chunk=
Remove a chunk file, once it is no longer in use. If the chunk file is a link, only the link is removed.
change sblob defaults
infx space func=sbsdef space= [ avg ext min snext log at buf lock ]
option
|
description
|
example |
| space= |
specify the name the new storage space to change |
name=sbs01 |
| avg= |
set sblob default AVG_LO_SIZE=, kilobytes |
avg=123 |
| ext= |
set sblob default EXTENT_SIZE=, kilobytes |
ext=100 |
| min= |
set sblob default MIN_EXT_SIZE=, kilobytes |
min=50 |
| snext= |
set sblob default NEXT_SIZE=, kilobytes |
snext=100 |
| at= |
set smart blob default ACCESSTIME=ON|OFF |
at=of |
| buf= |
set smart blob default BUFFERING=ON|OFF |
buf=on |
| lock= |
set sblob default LOCK_MODE=RANGE|BLOB |
lock=blob |
| log= |
set sblob default LOGGING=ON|OFF |
log=on |
garbage collect sblob spaces
infx space func=cl space=
Run smart block space garbage collection on the specified storage space.
change dataskip setting
infx space func=dataskip on= | off=
Change dataskip default settings for storage spaces. Specify the list to set dataskip on for, and/or a list to set dataskip
off for.
infx space func=dataskip on=dat01
infx space func=dataskip off=idx01
create a new buffer cache
infx space func=buffer pgsize= buffers= [ lrus maxdirty mindirty ]
Create a buffer cache of a new page size. Do this before creating any storage spaces of that page size.
option
|
description
|
example |
| pgsize= |
the page size, in kilobytes, to create the buffer cache for |
pgsize=8 |
| bufffers= |
how many buffers, of page size, to allocate to this cache |
buffers=1000000 |
| lrus= |
optional, specify the number of LRU queues to allocate |
lrus=100 |
| maxdirty= |
optional, specify LRU_MAX_DIRTY percentage |
maxdirty=1.00 |
| mindirty= |
optional, specify LRU_MIN_DIRTY percentage |
mindirty=0.001 |
mark a chunk as extendableinfx space func=extendable id= mode=on|off
Mark the specified chunk file as extendable. Use the infx chunk command to get the id of the chunk.
option
| description
| example | | id= | the chunk id to modify | id=1 | | mode= | set extendable on or off | mode=on |
change storage pool sizesinfx space func=spsize space= size= ext=
Change the sizes associated with expanding a storage space.
option
| description
| example | | space= | the storage space to modify | space=dat01 | | size= | set the create size, in MB to use for new chunks in this space | size=100 | | ext= | set the extend size, in MB to use for expandable chunks in this space | ext=25 |
|