IBM Support

IT42470: UPGRADE OF AN INSTANCE WITH AUDIT ON AND DBDELIMITER ENV VAR SETTO NOT "|" FAIL IN SYSMASTER BUILD

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When attempting an Upgrade on an instance which has audit
    enabled and
    in the instance environment the DBDELIMITER environment variable
    is not set
    to "|" e.g to "" the upgrade of the sysmaster database report an
    error
    
    11:05:53  Maximum server connections 1
    11:05:53  Checkpoint Statistics - Avg. Txn Block Time 0.000, #
    Txns blocked 0, Plog used 3, Llog used 3
    
    
    11:05:53  Error building 'sysmaster' database.
    11:05:53  See '/tmp/buildsmi.8951'.
    11:05:53  Assert Failed: build_smi failed
    11:05:53  IBM Informix Dynamic Server Version 14.10.FC9
    11:05:53   Who: Session(7, informix@localhost, 0, 0x568dffa8)
                    Thread(19, convert, 5689a200, 1)
                    File: rspseudo.c Line: 11253
    11:05:53   Results: Cannot build/check 'sysmaster' database
    11:05:53  stack trace for pid 8951 written to
    /opt/informix/IBM/14.10.FC9/tmp/af.3fbc181
    11:05:53   See Also: /opt/informix/IBM/14.10.FC9/tmp/af.3fbc181
    11:05:58  build_smi failed
    11:05:58  Conv/rev: Finished conversion for component SMI
    11:05:58  Conv/rev: Started conversion for component BAR
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 14.10.xC9W1.               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 14.10.xC9W1.                      *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 14.10.xC9W1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT42470

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-11-15

  • Closed date

    2023-02-17

  • Last modified date

    2023-02-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
17 February 2023