Hi Everyone,
I am testing out DB2 Data Management Console.
For my LUW DB2 databases I can easily connect.
However, I cannot connect to "DB2 for i", which is often thought of as the AS400 version of DB2.
Does anyone know if it can be done?
I keep getting this error message:
"Attention:
The current profile is not initialized, please double check all the required fields, save it and try again."
The log shows this error plus some JSON code.
The dataServerType value looks wrong: DB2LUW
"HWCBAS0050E: An unexpected error occurred. Please contact the administrator or refer to log files for more details."
{
"req": {
"url": "/dbapi/v4/dbprofiles/H_and_L",
"requestId": "17cc7c9d-4f34-159a-32e8-5f9905231077",
"method": "PUT",
"headers": {
"X-Request-ID": "17cc7c9d-4f34-159a-32e8-5f9905231077",
"ucUserID": "********",
"X-DB-Profile": "undefined",
"Authorization": "********",
"Accept": "application/json",
"Content-Type": "application/json"
},
"data": {
"name": "PDP",
"dataServerType": "DB2LUW",
"databaseName": "DC3PDP",
"port": "446",
"host": "XXX.XXX.XXX.XXX",
"URL": "jdbc:db2://XXX.XXX.XXX.XXX:446/DC3PDP:retrieveMessagesFromServerOnGetMessage=true;",
"sslConnection": "false",
"disableDataCollection": "true",
"collectionCred": {},
"operationCred": {
"securityMechanism": "3",
"user": "MyUser",
"password": "MyPassword",
"saveOperationCred": "true"
},
"xtraProps": "",
"comment": "My DB"
}
},
"res": {
"url": "/dbapi/v4/dbprofiles/PDP",
"status": 500,
"statusText": "Internal Server Error",
"requestId": "17cc7c9d-4f34-159a-32e8-5f9905231077",
"headers": {},
"method": "PUT",
"data": {
"trace": "17cc7c9d-4f34-159a-32e8-5f9905231077",
"errors": [
{
"code": "internal_server_error",
"message": "HWCBAS0050E: An unexpected error occurred. Please contact the administrator or refer to log files for more details.",
"target": {
"type": "",
"name": ""
},
"more_info": ""
}
]
}
}
}
#Db2