Which standalone utility can be used to move data between subsystems by translating OBID, PSID and DBID?
-
DSN1COMP
-
DSN1PRNT
-
DSN1SDMP
-
DSN1COPY
DSN1COPY is the standalone utility used to copy data between DB2 subsystems while automatically translating internal identifiers like OBID (Object ID), PSID (Page Set ID), and DBID (Database ID). This ensures data remains valid when moved to a different subsystem. DSN1COMP is for compression, DSN1PRNT prints formatted data, and DSN1SDMP dumps data.
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.