Drop a chunk from an sbspace with onspaces

The following example drops a chunk from sbsp3 on UNIX. An offset of 300 KB is specified. The database server must be in online administration, or quiescent mode when you drop a chunk from an sbspace or temporary sbspace.
onspaces -d sbsp3 -p /dev/raw_dev1 -o 300 

You cannot drop the initial chunk of an sbspace with the syntax in the previous example. Instead, you must drop the sbspace. Use the fchunk column of onstat -d to determine which chunk is the initial chunk of an sbspace.


Copyright© 2018 HCL Technologies Limited