IBM Support

IZ75522: UNSUPPORTED CALL IN CREATEWSRRDB.SQL CAUSES SQL0104N

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • The following statement in createWsrrDb.sql is not
compatible
with DB2 9.1

UPDATE DB CFG USING cur_commit ON;

Local fix

  • NA

Problem summary

  • 



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • If you are using a DB2 version of 9.5 or earlier, you will see
the following error when you create the WebSphere Service
Registry and Repository database tables using the supplied SQL
scripts.

SQL0104N An unexpected token "cur_commit" was found following
"USING". Expected tokens may include: "ADSM_MGMTCLASS".
SQLSTATE=42601

The error can be ignored and the scripts will still run to
completion successfully.

    



APAR Information




    

  • APAR number
    IZ75522
    • 

  • Reported component name
    SERVICE REGISTR
    • 

  • Reported component ID
    5724N7200
    • 

  • Reported release
    700
    • 

  • Status
    CLOSED  SUG
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2010-04-30
    • 

  • Closed date
    2010-05-27
    • 

  • Last modified date
    2010-05-27
    • 





    

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

    • 

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

    • 



Fix information


    



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWLGF","label":"WebSphere Service Registry and Repository"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            27 May 2010
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback