Informix

 View Only

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

    Posted Mon August 12, 2024 10:08 AM

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


  • 2.  RE: #Informix, where can I find some examples how to use on* commands

    IBM Champion
    Posted Mon August 12, 2024 11:16 AM
    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 ?

    MARCUS HAARMANN



    Original Message


  • 3.  RE: #Informix, where can I find some examples how to use on* commands

    IBM Champion
    Posted Mon August 12, 2024 11:57 AM
    Uwe:

    Here is a link to the online documentation for 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


    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.






    Original Message


  • 4.  RE: #Informix, where can I find some examples how to use on* commands

    IBM Champion
    Posted Tue August 13, 2024 02:02 AM

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

    Original Message


  • 5.  RE: #Informix, where can I find some examples how to use on* commands

    IBM Champion
    Posted Tue August 13, 2024 10:33 AM

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

    Original Message


  • 6.  RE: #Informix, where can I find some examples how to use on* commands

    Posted Thu August 15, 2024 10:52 AM

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

    Original Message