IBM Support

IT45111: SYBASE DBMS IDENTIFIER HAS CHANGED FROM "SQL SERVER" TO "ADAPTIVE SERVER ENTERPRISE" CAUSING AN ABEND.

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

  • Sybase DBMS Identifier has changed from "SQL Server" to
"Adaptive Server Enterprise" causing an abend.  An update to
handle this change is required.

Local fix

  • 



Problem summary


    

  • ****************************************************************
USERS AFFECTED:
All Users of IBM Integration Bus V10.1, App Connect Enterprise
V11 or App Connect Enterprise V12 who have updated to Sybase 16
SP03 or higher.


Platforms affected:
MultiPlatform

****************************************************************
PROBLEM DESCRIPTION:
This problem will happen to any user who updates to Sybase 16
SP03 or higher and it has been caused by Sybase changing its
'database type name'. It used to return "SQL Server" but now
returns "Adaptive Server Enterprise" This unexpected change by
Sybase means that ACE/IIB no longer recognises that it is
interacting with a Sybase database and so all the customisation
within the ACE/IIB code for interacting with Sybase is not
triggered.

    



Problem conclusion


    

  • IBM App Connect Enterprise and IBM Integration Bus now detect
this change and recognise that it is interacting with a Sybase
database.

---------------------------------------------------------------
The fix is targeted for delivery in the following PTFs:

Version    Maintenance Level
v10.1      10.1.0.3
v11.0      11.0.0.25
v12.0      12.0.12.0

The latest available maintenance can be obtained from:
http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041

If the maintenance level is not yet available,information on
its planned availability can be found on:
http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
---------------------------------------------------------------

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT45111
    • 

  • Reported component name
    INTEGRATION BUS
    • 

  • Reported component ID
    5724J0540
    • 

  • Reported release
    A00
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2023-12-11
    • 

  • Closed date
    2024-01-16
    • 

  • Last modified date
    2024-01-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
    INTEGRATION BUS
    • 

  • Fixed component ID
    5724J0540
    • 



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A00"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            16 January 2024
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback