home‎ > ‎param‎ > ‎

func=sbsdef

Change the defaults for a smart blobspace.

usage

infx param func=sbsdef space [ at=off|on avg buf=on|off lock=blob|range logging=off|on ext min snext ]
     set smart blob defaults
       required:
         space - the storage space name
       optional:
         at - maintain object access times
         avg - average large object size in kb
         buf - use buffering
         lock - type of locking to use
         logging - use logging for this space
         ext - is this file/device extendable
         min - sblob defualt min extent size in mb
         snext - sblob next size

example

demo1b@bobii:/home/informix>infx param func=sbsdef space=sblob01 avg=100 ext=110 min=120 snext=130 at=on buf=off lock=blob logging=on

onspaces -ch sblob01 -Df ACCESSTIME=ON,AVG_LO_SIZE=100,BUFFERING=OFF,LOCK_MODE=BLOB,LOGGING=ON,EXTENT_SIZE=110,MIN_EXT_SIZE=120,NEXT_SIZE=130 -y

You are turning off smart-large-object buffering.
You are setting the locking mode to BLOB locking.
These changes will become the new sbspace default values.
Changes have been made to the sbspace.
Now the utility will read and update 1000 smart large objects at a time and
commit each block of 100 smart large objects as a single transaction.This utility may take a long time to complete.