Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's

    Posted Thu February 05, 2026 02:54 PM

    Hi everyone,

    When I try to upgrade from 15.0.0.2 to 15.0.1.0 I have errors about IPA's.

    On 15.0.0.2 I run for each database:

    select sysadmin:task("table update_ipa",tabname)
    from systables
    where tabid >= 100
    and tabtype = "T"
    ;

    When I start 15.0.1.0 I have the following messages:

    14:11:57 Insufficient free huge pages in /proc/meminfo for shared memory segment.
    Requested: 228978688 bytes. Available: 0 bytes.
    The default memory page size will be used.
    14:11:57 Requested shared memory segment size rounded from 223609KB to 223612KB
    14:11:57 Segment locked: addr=0x145ed0000, size=228978688
    14:11:57 Successfully added a bufferpool of page size 2K.

    14:11:57 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permissions
    14:11:57 Event alarms enabled. ALARMPROG = '/opt/IBM/informix/etc/alarmprogram.sh'
    14:11:57 Booting Language <c> from module <>
    14:11:57 Loading Module <CNULL>
    14:11:57 Booting Language <builtin> from module <>
    14:11:57 Loading Module <BUILTINNULL>
    14:12:03 Trusted host cache successfully built:/etc/hosts.equiv.
    14:12:03 KERNEL_CTRL - Default value: 0x270b5, Current setting: 0x70b5
    14:12:03 CCFLAGS - Default value: 0, Current setting: 0x0
    14:12:03 DR: DRAUTO is 0 (Off)
    14:12:03 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
    14:12:03 Event notification facility epoll enabled.
    14:12:03 IBM Informix Dynamic Server Version 15.0.1.0WE
    14:12:03 VP 8 is requesting 8192 kaio event resources.
    14:12:03 Performance Advisory: The current size of the physical log buffer is smaller than recommended.
    14:12:03 Results: Transaction performance might not be optimal.
    14:12:03 Action: For better performance, increase the physical log buffer size to 4096.
    14:12:03 The current size of the logical log buffer is smaller than recommended.
    14:12:03 Conversion from version 15.0.0.0 Started
    14:12:04 Checking partition header pages for IPAs and required free space...
    14:12:05 IPA Version slot on secondary partition page 5:21 shows outstanding IPAs.
    14:12:05 IPA Version slot on secondary partition page 5:42 shows outstanding IPAs.
    14:12:06 IPA Version slot on secondary partition page 5:585 shows outstanding IPAs.
    14:12:06 You will need to resolve all in-place alters (IPAs) in your previous
    version before migrating to version 15.0.1.0. No disk structures have
    been altered during this conversion attempt. For information
    on generating the list of tables requiring IPA resolution,
    see the section titled "Resolve outstanding in-place alter
    operations" in the latest Informix documentation.
    14:12:06 Check for IPAs and required space in partition header pages failed.
    14:12:06 oninit: Fatal error in shared memory initialization

    14:12:06 IBM Informix Dynamic Server Stopped.

    I run oncheck -pT for each database and there is no IPA.

    OS: OpenSuse 15.5 on VMware
    Linux compt-flexio-dev 5.14.21-150500.55.39-default #1 SMP PREEMPT_DYNAMIC Tue Dec 5 10:06:35 UTC 2023 (2e4092e) x86_64 x86_64 x86_64 GNU/Linux

    I try fix_ipa from Art Kagel but it did't find any IPA.

    What's next ?

    Thanks



    ------------------------------
    Jean-Guy Charron
    ------------------------------


  • 2.  RE: Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's

    Posted Fri February 06, 2026 01:03 AM

    Hi

    I see some more questions here which needs an answer.
    Therefore - can you open a support ticket for this issue?



    ------------------------------
    Hedwig Fuchs
    ------------------------------

    Original Message


  • 3.  RE: Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's

    Posted Fri February 06, 2026 02:55 AM
    Hello,

    I had similar problems when trying upgrade from 15.0.0.2 to 15.0.1.0 (besides others during conversion from 12/14.x to 15.x on AIX) - see  TS020674987

    Obsah obrázku text, klipart Popis byl vytvořen automaticky

    Milan Rafaj

    Senior Lead, Infrastructure/Cloud Architecture

    Kyndryl Consult

    +420 737 264 248

    www.kyndryl.cz

     

    Planned absence/Plánovaná nepřítomnost: 30.5., 6.6., 20.6.2025

     

    Kyndryl Česká republika, spol. s r. o.

    Sídlo: Praha 4, Chodov, V Parku 2308/8, PSČ: 148 00,

    IČ: 14890992

    Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277)

    Registered address: Prague 4, Chodov, V Parku, 2308/8, Zip code: 148 00

    Company ID: 14890992

    Entered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)

    -- 

     




    Original Message


  • 4.  RE: Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's

    Posted Fri February 06, 2026 10:42 AM

    Case number

    TS021403988



    ------------------------------
    Jean-Guy Charron
    ------------------------------

    Original Message


  • 5.  RE: Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's

    Posted Fri February 06, 2026 10:11 AM

    Just curious:  would omitting the "tabid >= 100" filter in your update_ipa query avoid this problem?



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------

    Original Message


  • 6.  RE: Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's

    Posted Fri February 06, 2026 10:43 AM

    I already try it and It dont' change anything.



    ------------------------------
    Jean-Guy Charron
    ------------------------------

    Original Message


Related Content