#Informix, where can I find some examples how to use on* commands
Answered: green (solid confidence) — Several replies gave direct onspaces examples, documentation navigation and tutorial links, and the asker said they now have enough material.
Advisory only.
Posted in 2024
Uwe Trefz, new to Informix, asked for examples of using on* commands, especially onspaces for chunks. Marcus Haarmann listed onspaces functions and gave the add-chunk form (onspaces -a with -p, -o offset, -s size). Art Kagel pointed to the Administrator's Reference, Henri Cujass to a German beginner book, and Lester Knutsen to online tutorials. Uwe said he had enough material.
Topics: Storage & Space Management, Server Administration
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 ------------------------------