IBM Support

JR53025: DB2 CONNECTOR JOBS THAT WRITE TO DB2 FOR Z OS CAN ABORT WHEN RUN IN PARALLEL WHILE USING STAGE PARTITION NUMBER PROPERTY.

Fixes are available

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5.0.1 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Connector auto generated syntax for the DB2 LOAD
utility can lead to concurrency issues if multiple DataStage
jobs are invoked to write to specific partitions for the same
paritioned table using the DB2 Connector "Partition number"
property.

The issue occurs due to specifying LOAD RESUME, rather than
PART integer RESUME, which causes LOAD to serialize on the
entire tablespace, thus inhibiting concurrent processing of
separate partitions.

Please note that the correct LOAD syntax is generated when the
DB2 Connector "Partition number" property is not utilized

Local fix

  • 



Problem summary


    

  • DB2 CONNECTOR JOBS THAT WRITE TO DB2 FOR Z OS CAN ABORT WHEN RUN
 IN PARALLEL WHILE USING STAGE PARTITION NUMBER PROPERTY.

    



Problem conclusion


    

  • The DB2 Connector auto generated syntax for the DB2 LOAD utility
 can lead to concurrency issues if multiple DataStage jobs are
invoked to write to specific partitions for the same paritioned
table using the DB2 Connector "Partition number" property.


The issue occurs due to specifying LOAD RESUME, rather than PART
integer RESUME, which causes LOAD to serialize on the entire
tablespace, thus inhibiting concurrent processing of separate
partitions.

Please note that the correct LOAD syntax is generated when the
DB2 Connector "Partition number" property is not utilize.

With this fix, connector will generate correct LOAD syntax
  when the DB2Connector "Partition number" property is utilized.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR53025
    • 

  • Reported component name
    WIS DATASTAGE
    • 

  • Reported component ID
    5724Q36DS
    • 

  • Reported release
    912
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2015-04-09
    • 

  • Closed date
    2015-05-04
    • 

  • Last modified date
    2015-05-04
    • 





    

  • 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
    WIS DATASTAGE
    • 

  • Fixed component ID
    5724Q36DS
    • 



Applicable component levels


    

  • R910  PSY
       UP
    • 

  • R912  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"912","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            07 January 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback