IBM Support

IT06441: ONSPACES RENAME SBSPACE CHANGES SYSSBSPACENAME BUT NOT SBSPACENAME

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

  • onspaces -ren change SYSSBSPACENAME but not SBSPACENAME onconfig
    parameter.
    From online.log it looks like that parameter is changed !
    
    Example:
    $ echo "N" | dbaccessdemo
    $ onstat -c|grep SBSPACENAME
    # SBSPACENAME    - The default sbspace name where smart large
    objects
    # SYSSBSPACENAME - The default sbspace for system statistics
    SBSPACENAME     sbsnew
    SYSSBSPACENAME  sbsnew
    
    $ onmode -s
    
    This will perform a GRACEFUL SHUTDOWN -
    Do you wish to continue (y/n)? y
    
    $ onspaces -ren sbsnew -n sbs
    Rename of Space completed successfully.
    
    ** WARNING **  A level 0 archive of Root DBSpace and the renamed
    
    Space need to be done.
    WARNING !! Modifying SBSPACENAME value in onconfig file.
            A copy of previous onconfig file will be saved.
    WARNING !! Modifying SYSSBSPACENAME value in onconfig file.
            A copy of previous onconfig file will be saved.
    
    $ onstat -c|grep SBSPACENAME
    # SBSPACENAME    - The default sbspace name where smart large
    objects
    # SYSSBSPACENAME - The default sbspace for system statistics
    SBSPACENAME     sbsnew
    SYSSBSPACENAME  sbs
    
    $ onbar -b -F
    $ onmode -m
    
    
    if we now migrate to a higher version (12.10.xC4W1), than we get
    following error during conversion:
    
    $ onstat -m
    01/12/15 11:16:26  Conv/rev: blade conversion failed. See
    $INFORMIXDIR/etc/conv/convblade1210xC4.out
    01/12/15 11:16:26  Conv/rev: Finished conversion for component
    BLADE
    01/12/15 11:16:26  Conv/rev: Started conversion for component
    SCHAPI
    01/12/15 11:16:26  *** numVersions=7 targetVersion=7 ***
    01/12/15 11:16:26  *** entity_ver=6  targetVersion=7
    indexVersion= 0 ***
    01/12/15 11:16:26  *** FromVersion=0  ToVersion=1 entity_ver=6
    targetVersion=7 indexVersion=0 ***
    01/12/15 11:16:26  *** FromVersion=1  ToVersion=2 entity_ver=6
    targetVersion=7 indexVersion=1 ***
    01/12/15 11:16:26  *** FromVersion=2  ToVersion=3 entity_ver=6
    targetVersion=7 indexVersion=2 ***
    01/12/15 11:16:26  *** FromVersion=3  ToVersion=4 entity_ver=6
    targetVersion=7 indexVersion=3 ***
    01/12/15 11:16:26  *** FromVersion=4  ToVersion=5 entity_ver=6
    targetVersion=7 indexVersion=4 ***
    01/12/15 11:16:26  *** FromVersion=5  ToVersion=6 entity_ver=6
    targetVersion=7 indexVersion=5 ***
    01/12/15 11:16:26  *** FromVersion=6  ToVersion=7 entity_ver=6
    targetVersion=7 indexVersion=6 ***
    01/12/15 11:16:26  *** SCHAPI 1 12.10.xC4 ***
    01/12/15 11:16:26  calling schapi_cvr1210XC4_convert
    01/12/15 11:16:26  Conv/rev: Finished conversion for component
    SCHAPI
    01/12/15 11:16:26  Conv/rev: Started conversion for component HA
    01/12/15 11:16:26  *** numVersions=8 targetVersion=8 ***
    01/12/15 11:16:26  *** entity_ver=6  targetVersion=8
    indexVersion= 0 ***
    01/12/15 11:16:26  *** FromVersion=0  ToVersion=1 entity_ver=6
    targetVersion=8 indexVersion=0 ***
    01/12/15 11:16:26  *** FromVersion=0  ToVersion=2 entity_ver=6
    targetVersion=8 indexVersion=1 ***
    01/12/15 11:16:26  *** FromVersion=0  ToVersion=3 entity_ver=6
    targetVersion=8 indexVersion=2 ***
    01/12/15 11:16:26  *** FromVersion=3  ToVersion=4 entity_ver=6
    targetVersion=8 indexVersion=3 ***
    01/12/15 11:16:26  *** FromVersion=4  ToVersion=5 entity_ver=6
    targetVersion=8 indexVersion=4 ***
    01/12/15 11:16:26  *** FromVersion=5  ToVersion=6 entity_ver=6
    targetVersion=8 indexVersion=5 ***
    01/12/15 11:16:26  *** FromVersion=6  ToVersion=7 entity_ver=6
    targetVersion=8 indexVersion=6 ***
    01/12/15 11:16:26  *** HA 1 12.10.xC4 ***
    01/12/15 11:16:26  *** FromVersion=7  ToVersion=8 entity_ver=7
    targetVersion=8 indexVersion=7 ***
    01/12/15 11:16:26  Conv/rev: Finished conversion for component
    HA
    01/12/15 11:16:26  Conversion failed.
    01/12/15 11:16:26  *** Conversion failed ***
     CONVERSION_GUARD was on. To go back to the original version
     of IDS, run onrestorept.
    01/12/15 11:16:26  Assert Failed: *** Conversion failed ***
     CONVERSION_GUARD was on. To go back to the original version
     of IDS, run onrestorept.
    01/12/15 11:16:26  IBM Informix Dynamic Server Version
    12.10.FC4W1
    01/12/15 11:16:26   Who: Session(11, informix@greenwood, 0,
    0x4646bdf8)
      Thread(22, convert, 46427ee8, 1)
      File: framework.c Line: 962
    01/12/15 11:16:26   Results: Dynamic Server must abort
    01/12/15 11:16:26   Action: Restart conversion after fixing the
    problem.
    01/12/15 11:16:26  stack trace for pid 27539 written to
    /opt/informix/12.10.FC4W1/tmp/af.3fe9efa
    01/12/15 11:16:26   See Also:
    /opt/informix/12.10.FC4W1/tmp/af.3fe9efa
    01/12/15 11:16:28  Thread ID 22 will NOT be suspended because
              it is deemed too critical to the server.
    01/12/15 11:16:28   See Also:
    /opt/informix/12.10.FC4W1/tmp/af.3fe9efa
    01/12/15 11:16:28  Starting crash time check of:
    01/12/15 11:16:28  1. memory block headers
    01/12/15 11:16:28  2. stacks
    01/12/15 11:16:28  Crash time checking found no problems
    01/12/15 11:16:28  *** Conversion failed ***
     CONVERSION_GUARD was on. To go back to the original version
     of IDS, run onrestorept.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IBM Informix Server 12.10                          *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IBM Informix Server 12.10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT06441

  • Reported component name

    IFMX ULT WHSE E

  • Reported component ID

    IM0019BOS

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-12

  • 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

    IFMX ULT WHSE E

  • Fixed component ID

    IM0019BOS

Applicable component levels

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBJS3","label":"Informix Ultimate Warehouse Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 October 2015