Which standalone utility can be used to move data between subsystems by translating OBID, PSID and DBID?

  1. DSN1COMP

  2. DSN1PRNT

  3. DSN1SDMP

  4. DSN1COPY


Correct Option: D

AI Explanation

To answer this question, we need to understand the different utilities available in IBM's Db2 for z/OS database management system.

Option A) DSN1COMP - This utility is used to compress Db2 table spaces and indexes. It does not have the capability to move data between subsystems or translate OBID, PSID, and DBID.

Option B) DSN1PRNT - This utility is used to print the data in a Db2 table space or index. It does not have the capability to move data between subsystems or translate OBID, PSID, and DBID.

Option C) DSN1SDMP - This utility is used to dump the data in a Db2 table space or index. It does not have the capability to move data between subsystems or translate OBID, PSID, and DBID.

Option D) DSN1COPY - This utility is used to copy Db2 table spaces and indexes. It can be used to move data between subsystems by translating OBID, PSID, and DBID. It allows you to specify the target subsystem and translate the identifiers accordingly.

The correct answer is D) DSN1COPY. This option is correct because it is the only utility among the given options that can be used to move data between subsystems by translating OBID, PSID, and DBID.

Find more quizzes: