jueves, 28 de febrero de 2008

Añadir chunk a un dbspace en informix

En primer lugar debe estar creado el fichero que albergará el chunk. En windows, la ubicacion por defecto es C:\IFMXDATA\nombre_del_servidor\nombre_del_chunk.000. Basta con crear un fichero vacio.

A continuacion:

onspaces -a rootdbs -s 12800 -o 0 -p C:\IFMXDATA\nombre_del_servidor\nombre_del_chunk.000

Siendo la sintaxis de onspaces:

Usage:
onspaces { -a -p -o -s [-m ]
{ { [-Mo ] [-Ms ] } | -U }
} |

{ -c { -d [-k ] [-t]
-p -o -s [-m ] } |
{ -d [-k ]
-p -o -s [-m ]
[-ef ] [-en ] } |
{ -b -g
-p -o -s [-m ] } |
{ -S [-t]
-p -o -s [-m ]
[-Mo ] [-Ms ] [-Df ] } |
{ -x -l } } |

{ -d [-p -o ] [-f] [-y] } |

{ -f[y] off [] | on [] } |

{ -m {-p -o -m [-y] |
-f } } |

{ -r [-y] } |

{ -s -p -o {-O | -D} [-y] } |

{ -ch -Df } |

{ -cl } |

{ -ren -n }

-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 an 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 space
-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

No hay comentarios: