IBM Support

JR51042: ORACLE CC BULK LOAD USING OCI DIRECT PATH LOAD MAY RESULT IN EMPTY NCLOB COLUMN.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Using the Oracle CC Bulk to write OCI Direct Path may result in
empty NCLOB columns

Local fix

  • 



Problem summary


    

  • When a CLOB or NCLOB exceeds a certain size, the contents of the
 LOB column simply isn't there when the job completes.

    



Problem conclusion


    

  • The fix is that when using internal read buffer mode, the LOB is
 handled all in one piece.

    



Temporary fix


    

  • The issue is replicated when we include this storage clause for
LOB in the create table statement.  For example,
LOB ("MESSAGE") STORE AS BASICFILE (ENABLE STORAGE IN ROW CHUNK
8192 RETENTION)
We discovered that if the LOB is stored as SECUREFILE
(default on Oracle 12c) or the row chunk is larger (e.g., 16384)
the issue goes away.

    



Comments


    

  • 



APAR Information




    

  • APAR number
    JR51042
    • 

  • Reported component name
    WIS DATASTAGE
    • 

  • Reported component ID
    5724Q36DS
    • 

  • Reported release
    912
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2014-08-14
    • 

  • Closed date
    2014-08-27
    • 

  • Last modified date
    2014-08-27
    • 





    

  • 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


    

  • R912  PSY
       UP
    • 








      
              
                            

              

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

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            27 August 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback