Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.


#Data
 View Only
  • 1.  Db2 using S3 storage for REMOTE STORAGE

    Posted 15 hours ago

    Hi All,

    Just wondering if anyone out there is also using the Db2 COS feature (Cloud Object Storage) to enable direct log archiving (via LOGARCHMETH) to a remote (Cloud) storage such as the AWS S3?

    And, if you have been using this feature, have you attempted any Db2 upgrades along the way, which also required the upgrade of the operating system as a prerequisite?

    How did this work out for you?

    I have just attempted the above - upgrade Db2 from v11.5.7 to v12.1.3, which required the OS upgrade from RHEL8.1 to RHEL9.6, and this resulted in the broken COS client (by the looks of it), with the following error messages in the db2diag.log:

      FUNCTION: DB2 UDB, oper system services, sqloRemStgList, probe:1139
      MESSAGE : ZRC=0x870F00B7=-2029059913=SQLO_UNSUPPORTED
                "Operation is unsupported."
       ...
      DATA #3 : String, 26 bytes
       COS Client is unavailable

    Not much else (in terms of useful info) is present in the db2diag.log, so I'm wondering if my problem is somehow related to the OS upgrade and if there are any extra steps to be taken to remedy the problem (there is nothing in the DB2 Knowledge Centre that would suggest any such actions, that I can see)?

    Needless to say, but here it is anyway: the REMOTE STORAGE worked flawlessly for several years prior to this DB2/OS upgrade.

    Has anyone had any experience with something like this - and if yes, how did you get out of it?

    Kind regards, Damir



    ------------------------------
    Damir Wilder
    Senior Consultant
    Triton Consulting
    London
    ------------------------------


  • 2.  RE: Db2 using S3 storage for REMOTE STORAGE

    Posted 2 hours ago
    Edited by malek shabou 2 hours ago

    Hi Damir,

    can you post the output (run with instance used) of: 

    ldd ~/sqllib/lib/libdb2CosApiS3_RHEL9.so

    and (change the path to DBB2 binary)

    ldd /opt/ibm/db2/V12.1/lib64/awssdk/RHEL/9.2/libaws-cpp-sdk-core.so

    Malek,



    ------------------------------
    malek shabou
    ------------------------------