Public Cloud Global

Expand all | Collapse all

Unable to load data from csv file into DB2 on Cloud after recent migration

  • 1.  Unable to load data from csv file into DB2 on Cloud after recent migration

    Posted Thu October 14, 2021 08:39 AM
    My DB2 on Cloud instance recently (within the last week)  went through a migration and will only allow SSL connections now.
    I can create and test a connection and that all works fine but when I attempt to use the DB2 on Cloud
    web console to load data I get the following error:
    [jcc][t4][2020][11256][4.27.25] Connection authorization failure occurred. Reason: Invalid GSSAPI server credential. ERRORCODE=-4214, SQLSTATE=28000

    How can this be corrected ?

    ------------------------------
    Tom Kochie
    ------------------------------


  • 2.  RE: Unable to load data from csv file into DB2 on Cloud after recent migration

    Posted Thu October 14, 2021 10:30 AM
    The solution to this problem was to login to the DB2 on Cloud web UI console with my DB2 userid and password, not my IBMid and password. If logged into
    the IBM Cloud dashboard with your IBMId and password it will let you open the DB2 Web UI without logging in to the DB2 Web UI. It will then let you open
    the web UI and allow you to attempt to load data. The load data will fail with the above error. To fix you need to logout of DB2 web UI and log back in using
    your DB2 userid and password.

    ------------------------------
    Tom Kochie
    ------------------------------