Informix

 View Only
  • 1.  14.10.FC9W1 is out!

    IBM Champion
    Posted Sat February 04, 2023 07:28 PM


    Informix 14.10.FC9W1 is available from Time Limited Downloads!


    Go to Try Developer Edition for free

    You can get even get the Advanced Enterprise Time Limited version from there!

    It is code signed so I was able to Validate the signature!

    https://twitter.com/smooth1x1/status/1622007426781257728?s=20&t=LNIss5idh28GdcwzIqfJfwhttps://twitter.com/smooth1x1/status/1622007426781257728?s=20&t=LNIss5idh28GdcwzIqfJfwhttps://twitter.com/smooth1x1/status/1622007426781257728?s=20&t=LNIss5idh28GdcwzIqfJfw



    ------------------------------
    David Williams
    ------------------------------


  • 2.  RE: 14.10.FC9W1 is out!

    IBM Champion
    Posted Sat February 04, 2023 07:45 PM


    ...and "Dave the Destroyer " has broken it 6 ways already!

    1.  When you go to unpack the Advance Enterprise Installer it has a duplicate filename!

    https://twitter.com/smooth1x1/status/1622007547254243330?s=20&t=LNIss5idh28GdcwzIqfJfw

    2. To get the installer to pass the prerequisites on RHEL 7.9 I had to make this link, can we get this fixes to change the dependency to libncurses.so.6?

    Not unreasonable in this day and age.

    [root@localhost lib64]# ls -l /usr/lib64/libncurses.so.5
    lrwxrwxrwx. 1 root root 17 Feb 4 15:25 /usr/lib64/libncurses.so.5 -> libncurses.so.6.1

    3.  On RHEL 7.9 the sys* databases did not get built.

    I had to create this link, again can we get the dependency updated to be current?

    [root@localhost lib64]# ls -lrt /usr/lib64/libtinfo.so.5
    lrwxrwxrwx. 1 root root 13 Feb 4 15:46 /usr/lib64/libtinfo.so.5 -> libtinfo.so.6

    4. The installer did not abort when the system databases did not get built.

    I can restart to fix this but it also meant that only rootdbs got created not all the other dbspaces and there is no quick fix for that!

    [root@localhost IDS.14.10.FC9W1]# onstat -d
    Your evaluation license will expire on 2023-05-05 16:26:30

    IBM Informix Dynamic Server Version 14.10.FC9W1AETL -- On-Line -- Up 00:03:30 -- 185996 Kbytes
    2023-02-04 15:52:44

    Dbspaces
    address number flags fchunk nchunks pgsize flags owner name
    459aa028 1 0x1 1 1 2048 N BA informix rootdbs
    1 active, 2047 maximum

    Chunks
    address chunk/dbs offset size free bpages flags pathname
    459aa270 1 1 0 78848 41468 PO-B-D /opt/IBM/IDS.14.10.FC9W1/storage/rootdbs
    1 active, 32766 maximum

    Not all the other dbspaces

    [root@localhost IDS.14.10.FC9W1]# onstat -d
    Your evaluation license will expire on 2023-05-05 17:08:46

    IBM Informix Dynamic Server Version 14.10.FC9W1AETL -- On-Line -- Up 00:01:11 -- 185996 Kbytes
    2023-02-04 16:21:12

    Dbspaces
    address number flags fchunk nchunks pgsize flags owner name
    459aa028 1 0x30001 1 1 2048 N BA informix rootdbs
    4808ab30 2 0x30001 2 1 2048 N BA informix physdbs
    4815bb88 3 0x20001 3 1 2048 N BA informix logdbs
    48bc1cf0 4 0x20001 4 1 2048 N BA informix datadbs
    481b0d50 5 0x28001 5 1 2048 N SBA informix sbspace
    48c7fde0 6 0x2001 6 1 2048 N TBA informix tempdbs
    6 active, 2047 maximum

    Chunks
    address chunk/dbs offset size free bpages flags pathname
    459aa270 1 1 0 78848 68640 PO-B-- /opt/IBM/IDS.14.10.FC9W1/storage/rootdbs
    4815b028 2 2 0 15360 459 PO-B-D /opt/IBM/IDS.14.10.FC9W1/storage/plogdbs
    47ce3028 3 3 0 14848 459 PO-B-D /opt/IBM/IDS.14.10.FC9W1/storage/llogdbs
    481b0028 4 4 0 110592 110539 PO-B-D /opt/IBM/IDS.14.10.FC9W1/storage/datadbs
    48c7f028 5 5 0 16384 15205 15205 POSB-D /opt/IBM/IDS.14.10.FC9W1/storage/sbspace
    Metadata 1126 837 1126
    47f95028 6 6 0 27648 27595 PO-B-- /opt/IBM/IDS.14.10.FC9W1/storage/tempdbs
    6 active, 32766 maximum

    5.  When I tried to uninstall it failed with a core dump!

    [root@localhost ~]# $INFORMIXDIR/uninstall/uninstall_server/uninstallserver -i gui
    Your evaluation license will expire on 2023-05-05 16:26:30
    Your evaluation license will expire on 2023-05-05 16:26:30
    shared memory not initialized for INFORMIXSERVER 'ol_informix1410'
    Unhandled exception
    Type=Segmentation error vmState=0x00040000
    J9Generic_Signal_Number=00000018 Signal_Number=0000000b Error_Value=00000000 Signal_Code=00000002
    Handler1=00007F6D4D6183E0 Handler2=00007F6D4CEE66D0 InaccessibleAddress=00000000EEAADB9B
    RDI=00007F6CD40198A0 RSI=00000000EEAADB9B RAX=00007F6CD40198A0 RBX=00007F6CD40195D0
    RCX=000000000000001B RDX=00000000000000FF R8=00000000000000FF R9=00007F6CD4019890
    R10=0000000000000000 R11=000000000000000F R12=00007F6D085EC760 R13=0000000000000000
    R14=00007F6CD400BF80 R15=00007F6CD40198A0
    RIP=00007F6D4EDBFB2E GS=0000 FS=0000 RSP=00007F6D085EC288
    EFlags=0000000000010287 CS=0033 RBP=0000000000000000 ERR=0000000000000004
    TRAPNO=000000000000000E OLDMASK=0000000000000000 CR2=00000000EEAADB9B
    xmm0 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm1 ff00000000000000 (f: 0.000000, d: -5.486124e+303)
    xmm2 4946474f4c50564a (f: 1280333440.000000, d: 9.936567e+44)
    xmm3 004854415047534d (f: 1346851712.000000, d: 2.706705e-307)
    xmm4 0000070d00000003 (f: 3.000000, d: 3.830202e-311)
    xmm5 0000003000000003 (f: 3.000000, d: 1.018558e-312)
    xmm6 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm7 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm8 494458494d520029 (f: 1297219584.000000, d: 9.074115e+44)
    xmm9 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm10 000000003f800000 (f: 1065353216.000000, d: 5.263544e-315)
    xmm11 000000007fffffff (f: 2147483648.000000, d: 1.060998e-314)
    xmm12 000000004b000000 (f: 1258291200.000000, d: 6.216785e-315)
    xmm13 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm14 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm15 00000000c10d0000 (f: 3238854656.000000, d: 1.600207e-314)
    Module=/lib64/libc.so.6
    Module_base_address=00007F6D4ECF1000
    Target=2_90_20220511_28614 (Linux 4.18.0-425.10.1.el8_7.x86_64)
    CPU=amd64 (4 logical CPUs) (0xe7883000 RAM)
    ----------- Stack Backtrace -----------
    __strncpy_avx2+0x29e (0x00007F6D4EDBFB2E [libc.so.6+0xceb2e])
    iadGetConfig+0x145 (0x00007F6D0814D535 [libnativeAPI.so+0x10535])
    iadRemoveInstance+0x1f3 (0x00007F6D08153813 [libnativeAPI.so+0x16813])
    iadRemoveInstallationInstances+0xfe (0x00007F6D0816117E [libnativeAPI.so+0x2417e])
    Java_com_ibm_informix_install_NativeAPI_iadRemoveInstallationInstances+0x2f (0x00007F6D081655AF [libnativeAPI.so+0x285af])
    ffi_call_unix64+0x52 (0x00007F6D4D6BF80A [libj9vm29.so+0x15180a])
    ffi_call_int+0x1fc (0x00007F6D4D6BBC9C [libj9vm29.so+0x14dc9c])
    _ZN32VM_BytecodeInterpreterCompressed3runEP10J9VMThread+0xf912 (0x00007F6D4D590992 [libj9vm29.so+0x22992])
    bytecodeLoopCompressed+0xad (0x00007F6D4D58106D [libj9vm29.so+0x1306d])
    (0x00007F6D4D652E52 [libj9vm29.so+0xe4e52])
    ---------------------------------------
    JVMDUMP039I Processing dump event "gpf", detail "" at 2023/02/04 16:02:29 - please wait.
    JVMDUMP032I JVM requested System dump using '/tmp/core.20230204.160229.478411.0001.dmp' in response to an event
    JVMPORT030W /proc/sys/kernel/core_pattern setting "|/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e" specifies that the core dump is to be piped to an external program. Attempting to rename either core or core.596739.

    JVMDUMP012E Error in System dump: The core file created by child process with pid = 596739 was not found. Expected to find core file with name "/tmp/core.596739"
    JVMDUMP032I JVM requested Java dump using '/tmp/javacore.20230204.160229.478411.0002.txt' in response to an event
    JVMDUMP010I Java dump written to /tmp/javacore.20230204.160229.478411.0002.txt
    JVMDUMP032I JVM requested Snap dump using '/tmp/Snap.20230204.160229.478411.0003.trc' in response to an event
    JVMDUMP010I Snap dump written to /tmp/Snap.20230204.160229.478411.0003.trc
    JVMDUMP013I Processed dump event "gpf", detail "".







    ------------------------------
    David Williams
    ------------------------------



  • 3.  RE: 14.10.FC9W1 is out!

    IBM Champion
    Posted Sat February 04, 2023 08:08 PM

    There is an APAR for the library issues - https://www.ibm.com/support/pages/apar/IT32637

    1. It is from 2020 and it is "CLOSED ISV" and not fixed.

    If the OS has moved on you cannot just say it is the OS suppliers problem!

    You need to update your dependencies to match the new OS Version.

    2. That APAR is broken as well - the comments contain typos!

    libncurses.5 should be libncurses.so.5
    libncurses.6 should be libncurses.so.6

    ------------------------------
    David Williams
    ------------------------------



  • 4.  RE: 14.10.FC9W1 is out!

    IBM Champion
    Posted Sat February 04, 2023 07:48 PM

    I did not see an annoucement here or on Twitter so I did it myself.

    Built on Jan 24 announced by me on Feb 4th, I am not sure when I was put on the site but feel I am slower in my old age!

    Anyway I'm BA-ACK!

    [root@localhost x]# oninit -version
    Program Name: oninit
    Build Version: 14.10.FC9W1AETL
    Build Number: N002
    Build Host: njdc-lxibm01
    Build OS: Linux 3.10.0-693.el7.x86_64
    Build Date: Tue Jan 24 19:12:19 CST 2023
    Build Timestamp: 2023-01-24T17:25:12-06
    GLS Version: glslib-7.00.FC7


    ------------------------------
    David Williams
    ------------------------------



  • 5.  RE: 14.10.FC9W1 is out!

    Posted Mon February 06, 2023 02:55 AM
    Where can we find the fixlist of 14.10.xC9W1 ?

    BR
    Markus

    ------------------------------
    Markus Holzbauer
    ------------------------------



  • 6.  RE: 14.10.FC9W1 is out!

    IBM Champion
    Posted Tue February 07, 2023 08:24 AM

    I do not see the fix list available yet!

    Also the manual https://www.ibm.com/docs/en/informix-servers/14.10?topic=overview-whats-new-in-informix has not been updated yet,

    ------------------------------
    David Williams
    ------------------------------



  • 7.  RE: 14.10.FC9W1 is out!

    Posted Tue February 07, 2023 04:15 PM
      |   view attached

    Here is the Fix List for 14.10.FC9W1.

     

    Hasn't made the web site yet. Some logistics issues I would imagine. Will try get them there as well.

     

    Scott Pickett

     

    Sent from Mail for Windows

     




    Attachment(s)

    xls
    Fix List -14.10.9W1.xls   33 KB 1 version


  • 8.  RE: 14.10.FC9W1 is out!

    Posted Thu February 09, 2023 08:39 AM

     

     

    Sent from Mail for Windows

     






  • 9.  RE: 14.10.FC9W1 is out!

    Posted Tue February 07, 2023 09:50 AM
    Any word on when the container version will be posted at the IBM Container Registry (icr.io/informix)?

    ------------------------------
    mark collins
    ------------------------------