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
------------------------------
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
------------------------------
Original Message
Original Message:
Sent: Wed October 13, 2021 07:34 PM
From: Tom Kochie
Subject: Unable to load data from csv file into DB2 on Cloud after recent migration
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
------------------------------
Additional
Resources
Discover these carefully selected resources to dive deeper into your journey and unlock fresh insights
Office
If you need immediate assistance please contact the Community Management team
Monday - Friday: 8AM - 5 PM MT