suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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