IBM Support

IT03546: ASSERT WARNING RECREATE TEMP SBSPACE, CORRUPT DBSPACE RESERVED PAGES AFTER REVERSION FROM 12.10.FC4 TO 12.10.FC2

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

  • The following assertion can be seen after reverting from
    12.10.FC4 to 12.10.FC2 and also corrupt dbspace reserved pages
    (missing name),
    which is also seen in onstat -d
    
    17:25:41  Assert Warning: recreate of temporary sbspsace failed
    sbsnum:6, err=0
    
    17:25:41   Who: Session(1, informix@server, 0, 0x44bee028)
                    Thread(7, main_loop(), 44ba8028, 1)
                    File: rstbs.c Line: 4679
    17:25:41   Results: Downing sbspace.
    17:25:41   Action: Please notify IBM Informix Technical Support.
    17:25:41  Raw hex dump of stack located in
    /work3/laube/pmrs/90399_004_000/tmp/af.3efc265.rawstk
    17:25:41  Stack for thread: 7 main_loop()
    
    (oninit) afstack
    (oninit) afhandler
    (oninit) afwarn_interface
    (oninit) recreate_tmpsbspace
    (oninit) clean_dbspaces
    (oninit) main_loop
    (oninit) th_init_initgls
    (oninit) startup
    
    The dbspace output of onstat -d should look like:
    
    $ onstat -d
    
    IBM Informix Dynamic Server Version 12.10.FC2 -- On-Line -- Up
    00:00:41 -- 156264 Kbytes
    
    Dbspaces
    address          number   flags      fchunk   nchunks  pgsize
    flags    owner    name
    44abe028         1        0x60001    1        1        2048
    N  BA    informix rootdbs
    45a81028         2        0x60001    2        1        2048
    N  BA    informix dbs1
    45a811d0         3        0x60001    3        1        2048
    N  BA    informix dbs2
    45a81378         4        0x42001    4        1        2048
    N TBA    informix tmpdbs1
    45a81520         5        0x42001    5        1        2048
    N TBA    informix tmpdbs2
    45a816c8         6        0x4a001    6        1        2048
    N UBA    informix tmpsbs1
    45a81870         7        0x4a001    7        1        2048
    N UBA    informix tmpsbs2
    45a81a18         8        0x68001    8        1        2048
    N SBA    informix sbs1
    45a81bc0         9        0x68001    9        1        2048
    N SBA    informix sbs2
     9 active, 2047 maximum
    
    But now looks like:
    
    Dbspaces
    address          number   flags      fchunk   nchunks  pgsize
    flags    owner    name
    44abe028         1        0x60001    1        1        2048
    N  BA                informix
    45a7f028         2        0x60001    2        1        2048
    N  BA                informix
    45a7f1d0         3        0x60001    3        1        2048
    N  BA                informix
    45a7f378         4        0x42001    4        1        2048
    N TBA                informix
    45a7f520         5        0x42001    5        1        2048
    N TBA                informix
    45a7f6c8         6        0x4a005    6        1        2048
    NDUBA                informix
    45a7f870         7        0x4a005    7        1        2048
    NDUBA                informix
    45a7fa18         8        0x68001    8        1        2048
    N SBA                informix
    45a7fbc0         9        0x68001    9        1        2048
    N SBA                informix
     9 active, 2047 maximum
    
    Note the missing dbspace names also observed in oncheck -pr
    output.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IDS 12.10.xC4 and above                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-12.10.xC5                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-12.10.xC5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT03546

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-08-01

  • Closed date

    2015-10-16

  • Last modified date

    2015-10-16

  • 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

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 October 2015