DB2 - Problembeschreibung
Problem IT27737 | Status: Geschlossen |
BACKUP, RESTORE, INGEST AND LOAD ARE FAILING WHEN USING SOFTLAYER REMOTE STORAGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.01.2019 31.01.2020 31.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |