Automic Workload Automation

Expand all | Collapse all

Run DB Load on a linux x64 client targeting a DB2 Server

  • 1.  Run DB Load on a linux x64 client targeting a DB2 Server

    Posted 10-09-2014 11:04 AM
    Hi everyone,

    Last days, I 'v being stuck on trying to run DB Load on DB2 10.5 server from a linux client terminal. Although my configuration on client (ubuntu) seems to be correct (ODBC validated using isql, DB2 credentials passed), I'm getting constantly the same error trace :

    U0003545 UCUDB: Opening database �
    U0029112 UCUDB - Length of the DB-History area: 100
    U0029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 1  DB-HDBC: 1
    U0003591 UCUDB - DB error info: OPC: 'SQLConnect' Return code: 'ERROR'
    U0003590 UCUDB - DB error: '', '', '', ''
    U0003590 UCUDB - DB error: '', '', '', ''
    U0003590 UCUDB - DB error: '', '', '', ''

    Could anyone have any idea what I'm doing wrong or any suggestion to workaround?
    I would much appreciate it!

    Cheers,




  • 2.  Run DB Load on a linux x64 client targeting a DB2 Server

    Posted 10-14-2014 06:19 PM
    What version of the AE are you using?
    Are you able to connect to the database and run basic queries?


  • 3.  Run DB Load on a linux x64 client targeting a DB2 Server

    Posted 10-17-2014 05:59 AM
    Thanks for reply,

    my issue was caused by wrong parameters in the ucybdld.sh
    after removing the param -d64, the Dbload utility ran correctly,