Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
To read data directly from IBM Softlayer Object Storage and insert it into a DB2 database, two tasks must be performed. First, cataloging a storage access alias in the DB2 database is necessary to create an alias for accessing remote storage, which includes storing remote storage account credentials securely. Second, using the DB2REMOTE parameter of the LOAD command allows specifying a remote storage location, facilitating the direct access and manipulation of data stored on IBM Softlayer Object Storage.
The answers are correct. 1/ You have the command CATALOG STORAGE ACCESS if you want to creates an alias for accessing remote storage on IBM Cloud Object Storage or Amazon Simple Storage Service (S3) directly with the INGEST, LOAD, BACKUP DATABASE, or RESTORE DATABASE commands. When you create a storage access alias, your remote storage account credentials are safely stored in an encrypted keystore. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0070120.html 2/ DB2REMOTE : To restore from files on remote storage, such as IBM Cloud Object Storage or Amazon Simple Storage Service (S3), you can specify a remote storage location using a storage access alias. Local staging space is required to temporarily store the backup image that is transferred from the remote storage server; refer to Remote storage requirements. The syntax for specifying remote storage is: DB2REMOTE://<alias>//<storage-path>/<file-name> Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001976.html