Onspaces syntax and examples of Informix (disk space management) __informix

(where the Red font is manual input, the blue font is the main change concern.) )

1. Basic usage:

-bash-3.1$ Onspaces--

Usage:

onspaces {-A <spacename>-P <path>-O <offset>-S <size> [-M <path> <offset>]

{{[-mo <mdoffset>] [-ms <mdsize>]} |-u}

} |

{-c {d <DBspace> [k <pagesize>] [-t]

-P <path>-O <offset>-S <size> [M <path> <offset>]} |

{d <DBspace> [k <pagesize>]

-P <path>-O <offset>-S <size> [M <path> <offset>]

[-ef <first_extent_size>] [-en <next_extent_size>]} |

{-B <BLOBspace> g <pagesize>

-P <path>-O <offset>-S <size> [M <path> <offset>]} |

{-S <SBLOBspace> [t]

-P <path>-O <offset>-S <size> [M <path> <offset>]

[-mo <mdoffset>] [-ms <mdsize>] [-df <default-list>]} |

{-X <Extspace> l <Location>}} |

{d <spacename> [P <path>-o <offset>] [f] [y]} |

{-f[y] off [<dbspace-list>] | on [<dbspace-list>]} |

{m <spacename> {-P <path>-o <offset>-M <path> <offset> [-y] |

-f <filename>} |

{-R <spacename> [y]} |

{-S <spacename>-P <path>-o <offset> {-O |-d} [y]} |

{-ch <sbspacename>-df <default-list>} |

{-CL <sbspacename>} |

{-ren <spacename>-n <newname>}

-a-add a chunk to a DBspace, blobspace or Sblobspace

-c-create a DBspace, Blobspace, Sblobspace or Extspace

-d-drop a DBspace, Blobspace, Sblobspace, extspace, or chunk

-f-change dataskip default for specified DBspaces

-m-add mirroring to a existing DBspace, blobspace or Sblobspace

-r-turn mirroring off for a DBspace, blobspace or Sblobspace

-s-change the status of a chunk

-ch-change default list for smart large object spaces

-cl-garbage collect smart Large objects that are not referenced

Default-list = {[LOGGING = {on| Off}] [, Accesstime = {on| OFF}]

[, Avg_lo_size = {1-2097152}]}

-ren-rename a DBspace, Blobspace, Sblobspace or Extspace

2. Example:

(1) (Create Dbspace)

-bash-3.1$ onstat-d

IBM Informix Dynamic Server Version 11.50.uc1de-on-line--up 04:03:45--93844 Kbytes

Dbspaces

Address number flags Fchunk Nchunks pgsize flags owner name

44d4a7f8 1 0x70001 1 1 2048 N B Informix Rootdbs

44e107e8 2 0x60001 2 1 2048 N B Informix DBS1

2 Active, 2047 maximum

Chunks

Address Chunk/dbs offset Size free bpages flags pathname

44d4a958 1 1 0 450000 340077 Po-b/home/informix/ids11uc1/dbs/rootdbs

44e10948 2 2 0 250000 161794 Po-b/DBS/DBS1

2 Active, 32766 maximum

Note:the values in the ' size ' and ' free ' columns for DBspace chunks are

Displayed in terms of "pgsize" of the DBspace to which they.

Expanded Chunk Capacity Mode:always

-bash-3.1$ Touch/dbs/dbstest1

-bash-3.1$ chmod 660/dbs/dbstest1

-bash-3.1$ Onspaces-c-D dbspacetest1-p/dbs/dbstest1-o 20000-s 1000000

Verifying Physical disk space.

/dbs:write failed, file system is full.

-bash-3.1$ Onspaces-c-D dbspacetest1-p/dbs/dbstest1-o 20000-s 1000

Verifying Physical disk space.

Space successfully added.

* * WARNING * * A Level 0 Archive of Root DBSpace'll need to is done.

-bash-3.1$ onstat-d

IBM Informix Dynamic Server Version 11.50.uc1de-on-line--up 04:08:39--93844 Kbytes

Dbspaces

Address number flags Fchunk Nchunks pgsize flags owner name

44d4a7f8 1 0x70001 1 1 2048 N B Informix Rootdbs

44e107e8 2 0x60001 2 1 2048 N B Informix DBS1

472abd88 3 0x60001 3 1 2048 N B Informix Dbspacetest1

3 Active, 2047 maximum

Chunks

Address Chunk/dbs offset Size free bpages flags pathname

44d4a958 1 1 0 450000 340077 Po-b/home/informix/ids11uc1/dbs/rootdbs

44e10948 2 2 0 250000 161794 Po-b/DBS/DBS1

472EAD50 3 3 10000 447 Po-b/dbs/dbstest1

3 Active, 32766 maximum

Note:the values in the ' size ' and ' free ' columns for DBspace chunks are

Displayed in terms of "pgsize" of the DBspace to which they.

Expanded Chunk Capacity Mode:always

(2) (Create Blobspace)

-bash-3.1$ Touch Dbtest2

-bash-3.1$ chmod 660 Dbtest2

-bash-3.1$ Onspaces-c-B blobsptest1-g 50-p/home/share/dbtest2-o 200000-s 1000

Verifying Physical disk space.

Space successfully added.

* * WARNING * * A Level 0 Archive of Root DBSpace'll need to is done.

-bash-3.1$ onstat-d

IBM Informix Dynamic Server Version 11.50.uc1de-on-line--up 04:29:15--93844 Kbytes

Dbspaces