DB2 - Problem description
Problem IT27737 | Status: Closed |
BACKUP, RESTORE, INGEST AND LOAD ARE FAILING WHEN USING SOFTLAYER REMOTE STORAGE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Due to authentication changes any operations that requires remote Softlayer storage will not work. These operations are: backup to remote storage, restore from remote storage, ingest from remote storage and load from remote storage. One can issue catalog storage access command similar to the one below: db2 "catalog storage access alias mysoflayerstorage vendor softlayer server s3.host.objectstorage.softlayer.net user 1abc5f077d1ab82be938234c7819093 password 8b20b4a0c345fab7339b5a8e619bb8b5689149ab1c7b49b2 container my_container dbuser db2inst1" Then backup operation to remote Softlayer storage: db2 backup db internal to db2remote://mysoflayerstorage/my_container/back1 will fail and one can find entries like the one below in the database logs: .. 2018-11-21-21.27.04.843690+060 I18801E4515 LEVEL: Error PID : 25640 TID : 140403135211264 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : INTERNAL APPHDL : 0-12 APPID: *LOCAL.db2inst1.181121202702 AUTHID : DB2INST1 HOSTNAME: node100 EDUID : 67 EDUNAME: db2med.44.0 (INTERNAL) 0 FUNCTION: DB2 UDB, oper system services, SqloHRemStgSwift::SqloHRemStgSwift_Authenticate, probe:30 MESSAGE : ZRC=0x870F01B6=-2029059658=SQLO_FAILED "An unexpected error is encountered" DATA #1 : Codepath, 8 bytes 0 DATA #2 : String, 19 bytes Request has failed. DATA #3 : Generic Remote Storage Handle, PD_TYPE_REMSTG_HANDLE, 20736 bytes ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * SoftLayer has switched to s3 protocol. In the next release * * s3 protocol authentication was expanded. * * There are no plane to backport the code to Db2 11.1 code * * stream. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.01.2019 31.01.2020 31.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |