#Informix, where can I find some examples how to use on* commands

Hello all, I'm new here and new with Informix administration. I search for some examples how to use the on* commands. Esspecially to create chunks with onspaces. can somebody help me with a link to some tutorials? the IBM original documentation isn't helpfully. I didn't understand it. Many thanks and LG Uwe ------------------------------ Uwe Trefz ------------------------------

Hi, for onspaces, you need to know what you want to do. onspaces can be used for: creation of new dbspaces adding chunks to dbspaces deleting chunks from dbspaces delete dbspaces (which have only one chunk left) adding/removing mirroring to a chunk change status of a mirror chunk change SMARTBLOB behaviou for SBlob chunks rename chunks/dbspaces E.g. if you just want to add new chunk to a pre-existing dbspace (because it is running out of space), use onspaces -a <spacename> -p <path to chunk file> -o <offset in chunk file (typically 0)> -s <size (in kb)> The offset parameter is mandatory, but can be set to 0 unless you are handling a special raw device which contains some information in the first blocks like a partition table which you do not want to overwrite. In this case. leave some kb as offset. The path needs to be existing and have access rights informix:informix 660 It could be a symbolic link to a raw device of an empty file (cat < /dev/null > filename; chown informix:informix filename; chmod 660 filename) When setting up a new system, you need to decide if you want to go for raw spaces or files (mixing is not a good idea) What do you want to do ?

Uwe: Here is a link to the online documentation for Informix: https://www.ibm.com/docs/en/informix-servers/14.10?topic=overview-whats-new-in-informix On the left side, scroll down to <Administering> and pull down that submenu. Under that you will see <System Administration> Pull that submenu down and you will see: <Adminstrators Reference>. Click on that and the onspaces, and most of the other on* utilities are documented in there under <Administrative Utilities>. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Hi Uwe, welcome to the Informix community. In addition to the very good and actual online documentation with tutorials, there is a nice book for getting started by our colleague Eric Herber https://www.amazon.de/-/en/Herber/dp/3868020128 (even if it is a bit older). Otherwise, we (www.leolo.de) also offer support and Informix kick-off training in BW/Bavaria/DACH. Best Regards Henri ------------------------------ Henri Cujass leolo IT, CTO Germany IBM Champion henri.cujass@leolo.com ------------------------------

Hi, I have a set of online tutorials for Informix at https://advancedatatools.com/tech-info/informix-tutorials/ and number 3 is on managing dbspaces and includes example of onspace commands. Enjoy - Lester ------------------------------ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 Visit our Web page: http://www.advancedatatools.com ------------------------------

Hello everyone, I would like to thank everyone for their valuable help. I now have enough tutorials and an antique book. Everything helps me. Many thanks and best regards, Uwe ------------------------------ Uwe Trefz ------------------------------