Informix

nested-group-icon.png

DB2

Expand all | Collapse all

SDS / Raw devices RHEL 8

  • 1.  SDS / Raw devices RHEL 8

    Posted Thu February 13, 2020 04:31 PM
    Hi.

    We have been running 12.10 in SDS mode on RHEL 6.7 for many years now and everything works very well. At the time we started using SDS I asked some questions about this setup in the old forum on the IIUG website, and now the discussion is lost :(
    Is there an archive of it somewhere?  

    Now we are migrating to new servers running RHEL 8.0 so we can upgrade to 14.10.
    On RHEL 6.7 we use raw devices and multipath for our disks. Now the sysadmins who are configuring the new system tell me they have problems with raw devices in RHEL 8. They tell me the 6.7 way of doing things doesn't work in 8.x (they were not very specific).
    Googling "raw devices RHEL 8" does not give any useful results.

    Is anyone using a similar setup in RHEL 8.0? (SDS)?
    Is there a better/other way to use SDS than raw devices / multipath?

    Thanks in advance,
    -Snorri

    ------------------------------
    Snorri Bergmann
    Init ehf.
    Informix DBA
    ------------------------------


  • 2.  RE: SDS / Raw devices RHEL 8

    Posted Thu February 13, 2020 07:33 PM
    Edited by SangGyu Jeong Fri February 14, 2020 12:44 AM
    Hi Snorri,
    I have installed informix 14.10.fc3 on centos 8.1.
    After installation, I created a raw device and added dbspace.
    I think it's the same in Red Hat 8.


    root:
    raw /dev/raw/raw1 /dev/sdc
    chown informix:informix /dev/raw/raw1

    informix:
    onspaces -c -d dbs1 -p /dev/raw/raw1 -o 32 -s 5000000



    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------


  • 3.  RE: SDS / Raw devices RHEL 8

    Posted 24 days ago
    Can someone help me or guide me, what are the specific steps or configuration to use raw devices with informix.
    I tried an example that I used from a post on the internet, but after I created the raw devices.
    restart the server and when I was going to create the soft links for install the IDS software 12cFC14, the raw devices did not exist.
    the steps I did were as follows
    in a virtual one with rhel7.6, create a 60GB disk for the use of the dbspaces, then from root
    on a second attempt I re-created the raw devices and in /etc/sysconf/rawdevices add the steep4 image setting, try to start the rawdevice service but it fails.
    It is my first time in informix that I use raw device, I have experience in oracle with multipath and I would like to know if it is with multpath, Udev or with block devices that can be done, I appreciate even a link or documentation or some basic steps that you can offer me, Thank you

    ------------------------------
    jose Lara
    ------------------------------



  • 4.  RE: SDS / Raw devices RHEL 8

    Posted 24 days ago
    Hi,

    To turn raw devices persistent you need to create one startup file.
    Create one file /etc/udev/rules.d/60-raw.rules and specify the settings for the devices you need.
    You can see partitions with lsblk command.
    On config file use the following if you use partitions:

    ACTION=="add", KERNEL=="sdX1", OWNER="informix", GROUP="informix", MODE="0660", RUN+="/bin/raw /dev/raw/raw1 %N"

    If you are using LVM use this syntax (you get VG and VG names with lvs command):

    ENV{DM_VG_NAME}=="centos", ENV{DM_LV_NAME}=="dev_rootdbs", OWNER="informix", GROUP="informix", MODE="0660", RUN+="/bin/raw /dev/raw/raw1 %N"

    add this line at the end to change permissions: 

    ACTION=="add", KERNEL=="raw3", OWNER="informix", GROUP="informix", MODE="0660"

    Save the file and execute the command toactive raw devices: udevadm trigger --action=add
    This settings create one raw device with the following path /dev/raw/raw1
    Those settings work on RedHat 7 and 8

    I hope this can help,

    SP



    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 5.  RE: SDS / Raw devices RHEL 8

    Posted 24 days ago
    Thanks Sergio!!, I will take the test and I will let you know..
    regards
    Jose@Lara


    ------------------------------
    jose Lara
    ------------------------------



  • 6.  RE: SDS / Raw devices RHEL 8

    Posted Fri February 14, 2020 05:02 AM
    Hi Snorri,

    I always use raw devices concerning security as they don't appear can't be deleted! About performance it is relative as they are new features that can improve performance...
    About configuration on RHEL 8 is similar to RHEL 7, create one file /etc/udev/rules.d/60-raw.rules and put something like this, one line for each device:

    ACTION=="add", KERNEL=="sdX1", OWNER="informix", GROUP="informix", MODE="0660", RUN+="/bin/raw /dev/raw/raw1 %N"

    ..

    ACTION=="add", KERNEL=="sdX6", OWNER="informix", GROUP="informix", MODE="0660", RUN+="/bin/raw /dev/raw/raw? %N"
    ACTION=="add", KERNEL=="raw?", OWNER="informix", GROUP="informix", MODE="0660"

    To activate use the command: udevadm trigger --action=add

    If you use LVM use this on file and replace VG and LV names with your settings [lvs] command to see them:
    ACTION=="add", ENV{DM_VG_NAME}=="vg_test", ENV{DM_LV_NAME}=="lv_test1", RUN+="/bin/raw /dev/raw/raw1 %N"
    ...
    ACTION=="add", KERNEL=="raw?", OWNER="informix", GROUP="informix", MODE="0660"

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 7.  RE: SDS / Raw devices RHEL 8

    Posted Wed February 19, 2020 09:38 AM
    Thank you guys for your input. 
    Now I have my system up and running.

    Best regards,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------



  • 8.  RE: SDS / Raw devices RHEL 8

    Posted Tue February 25, 2020 01:43 PM
    You can still access old forums at: http://old.iiug.org/forums/ids/

    Regards,

    Benito

    ------------------------------
    Sistemas Federacio Farmaceutica
    ------------------------------



  • 9.  RE: SDS / Raw devices RHEL 8

    Posted Tue February 25, 2020 03:41 PM
    Yes, you can but they are no longer active and the email gateway no longer works which means that those of us who used to monitor posts there and respond no longer do. The IIUG Board is working with IBM to port all of the old forum history to the new community site's history so it can be searched. We will keep everyone informed on who that goes.

    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.








  • 10.  RE: SDS / Raw devices RHEL 8

    Posted 24 days ago
    Can someone help me or guide me, what are the specific steps or configuration to use raw devices with informix.
    I tried an example that I used from a post on the internet, but after I created the raw devices.
    restart the server and when I was going to create the soft links for install the IDS software 12cFC14, the raw devices did not exist.
    the steps I did were as follows
    in a virtual one with rhel7.6, create a 60GB disk for the use of the dbspaces, then from root
    on a second attempt I re-created the raw devices and in /etc/sysconf/rawdevices add the steep4 image setting, try to start the rawdevice service but it fails.
    It is my first time in informix that I use raw device, I have experience in oracle with multipath and I would like to know if it is with multpath, Udev or with block devices that can be done, I appreciate even a link or documentation or some basic steps that you can offer me, Thank you

    ------------------------------
    jose Lara
    ------------------------------