About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Carried out the test and verified that GCP supports S3 protocol.
[db2ips1@bns-ftm-db2-standby-aux1 ~]$ aws s3 --endpoint-url https://storage.googleapis.com ls s3://bns-ftm-storage/
PRE db2backup/
2024-06-19 18:07:04 21167568 Db2_v11.5.4.0_Pacemaker_20200615_RHEL8.1_x86_64.tar.gz
2024-06-19 13:54:08 1963519317 special_42449_v11.5.9_linuxx64_server_dec.tar.gz
Followed the process to set registry variables...
[db2ips1@bns-ftm-db2-standby-aux1 ~]$ db2set -all
[i] DB2_ENABLE_COS_SDK=ON
[i] DB2_OBJECT_STORAGE_LOCAL_STAGING_PATH=/db2space/FTM/FTMDB/backup
[i] DB2COMM=SSL,TCPIP
[g] DB2SYSTEM=bns-ftm-db2-standby-aux1.us-east4-b.c.bns-ftm-426014.internal
Catalogged remote storage...
[db2ips1@bns-ftm-db2-standby-aux1 ~]$ db2 "catalog storage access alias googlebkup vendor S3 server https://storage.googleapis.com user 'XXXXXX' password 'XXXXX' container 'bns-ftm-storage'"
DB20000I The CATALOG STORAGE ACCESS command completed successfully.
[db2ips1@bns-ftm-db2-standby-aux1 ~]$ db2 list storage access
Node Directory
Node 1 entry:
ALIAS=googlebkup
VENDOR=S3
SERVER=https://storage.googleapis.com
USERID=****
CONTAINER=bns-ftm-storage
OBJECT=
DBUSER=
DBGROUP=SYSADM
Number of entries in the directory = 1
DB20000I The LIST STORAGE ACCESS command completed successfully.
[db2ips1@bns-ftm-db2-standby-aux1 ~]$ db2 "backup db FTMDB online to DB2REMOTE://googlebkup//bns-ftm-storage/"
SQL2025N An I/O error occurred. Error code: "0x870F01B6". Media on which
this error occurred: "DB2REMOTE://googlebkup//bns-ftm-storage/".
Backup fails with above error.
From diaglog i can see it has initialized the s3 protocols and path...
2024-07-19-14.36.30.485447+000 I275911E1038 LEVEL: Error
PID : 36049 TID : 140394285229632 PROC : db2sysc 0
INSTANCE: db2ips1 NODE : 000 DB : FTMDB
APPHDL : 0-17895 APPID: *LOCAL.db2ips1.240719143629
AUTHID : DB2IPS1 HOSTNAME: bns-ftm-db2-standby-aux1.us-east4-b.c.bns-ftm-426014.internal
EDUID : 126 EDUNAME: db2med.84.0 (FTMDB) 0
FUNCTION: DB2 UDB, oper system services, sqlowriteEx, probe:11988
MESSAGE : ZRC=0x870F01B6=-2029059658=SQLO_FAILED
"An unexpected error is encountered"
DATA #1 : String, 33 bytes
COS PutObject request has failed.
DATA #2 : COS SDK Client, PD_TYPE_COS_CLIENT, 2624 bytes
SqloCosClient: 0x00007fb012c53020
{
Global COS SDK CB: 0x00007fb13852db80
Is Initialized: Yes
COS Interface CB: 0x00007fb13852dbe0
API Type: 0 ( S3 )
Endpoint: [https://storage.googleapis.com]
Container: [bns-ftm-storage]
Is Persistent: Yes
Object size: -1
Current GET position: 0
SDK Persistent Client: 0x00007fb060017fe0
}
First error from log as below...
2024-07-19-14.36.30.480824+000 I272942E863 LEVEL: Error
PID : 36049 TID : 140394285229632 PROC : db2sysc 0
INSTANCE: db2ips1 NODE : 000 DB : FTMDB
APPHDL : 0-17895 APPID: *LOCAL.db2ips1.240719143629
AUTHID : DB2IPS1 HOSTNAME: bns-ftm-db2-standby-aux1.us-east4-b.c.bns-ftm-426014.internal
EDUID : 126 EDUNAME: db2med.84.0 (FTMDB) 0
FUNCTION: DB2 UDB, oper system services, sqloS3Client_InitMultiPartUpload, probe:112
MESSAGE : ZRC=0x870F01B6=-2029059658=SQLO_FAILED
"An unexpected error is encountered"
DATA #1 : String, 39 bytes
S3:CreateMultipartUpload request failed
DATA #2 : signed integer, 4 bytes
100
DATA #3 : String, 15 bytes
InvalidArgument
DATA #4 : String, 73 bytes
Unable to parse ExceptionName: InvalidArgument Message: Invalid argument.
With invalid argument & unexpected errors unable to debug it further.