DB2 10 for z/OS Database Administrator — Question 1

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

Answer options

• A. Catalog a storage access alias in the DB2 database
• B. Create an FTP account on IBM Softlayer Object Storage
• C. Use the DB2REMOTE parameter of the LOAD command
• D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
• E. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Correct answer: A, C

Explanation

The correct answer, A, is essential because the storage access alias is needed for DB2 to identify and connect to the object storage. Option C is also correct since the DB2REMOTE parameter is required to load data from remote sources. Options B, D, and E are not necessary for this process, as they do not facilitate direct reading and loading of data into DB2.