Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
 View Only
  • 1.  db2Load API crashing on Linux

    Posted 16 days ago

    Hii Team,

    I am from InfoShere Optim Development. Optim trying to load data using db2Load on Linux 64 bit, it is crashing here is the stack trace:

    sqluValidateInputPointers() at 0x7fff655a22a3    
    squCheckLoadClientParms() at 0x7fff6559d08f    
    sqluLoadClient() at 0x7fff655a6bdb    
    db2Load() at 0x7fff6517eaf2    
    XlodDB2Loader() at PswrDBMS.cpp:1,378 0x7fff5eb28f1f    

    Db2 Release both client and Server = 11.05.0000

    This is the call which is crashing. All the members of loadStruct populated with proper data. Same call works on Windows.

    db2Load(db2Version950, &loadStruct, pSqlca);

    I have exhausted all my options in fixing this problem from Optim side.

    Reaching out to the Db2 team any leads to resolve this issue.

    Thanks and Regards,

    Tulasi 



    ------------------------------
    Tulasi Uppu
    ------------------------------


  • 2.  RE: db2Load API crashing on Linux

    Posted 14 days ago
    You're using the GA version(11.05.0000)  of the software. We recommend keeping both your server and client updated to the latest release.







  • 3.  RE: db2Load API crashing on Linux

    Posted 10 days ago

    I guess 11.5 is not tool old and it not reached end of support. 



    ------------------------------
    Tulasi Uppu
    ------------------------------



  • 4.  RE: db2Load API crashing on Linux

    Posted 10 days ago

    Tried with latest fixpack 11.5.9.0, no success, db2Load crashing.

    Any further hints?

    Thanks,

    Tulasi

    -------------------------------------------



  • 5.  RE: db2Load API crashing on Linux

    Posted 10 days ago

    Can you show us yoour complete test case?



    ------------------------------
    Jan Nelken
    Db2 (LUW) DBA
    Open for work
    Katowice or Krakow
    +48 783 109 863
    ------------------------------



  • 6.  RE: db2Load API crashing on Linux

    Posted 8 days ago

    It is a db2Load called inside c++ application by creating proper data and control files.

    -------------------------------------------



  • 7.  RE: db2Load API crashing on Linux

    Posted 10 days ago
    Change the version constant first.





  • 8.  RE: db2Load API crashing on Linux

    Posted 10 days ago
    Initialize sqlu_struct correct and then populate the fields.





  • 9.  RE: db2Load API crashing on Linux

    Posted 8 days ago

    Yes, I have made sure about populating sqlu_struct structure and in the debug also I found required values are correct. Not sure what else I am missing. Same code works on Windows.

    -------------------------------------------



  • 10.  RE: db2Load API crashing on Linux

    Posted 2 days ago
    Can you check the db2 log around the stack trace for SQLCODE/SQLSTATE?