Multiple choice technology databases

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
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DSN1COPY is the IBM DB2 standalone utility used to move data between DB2 subsystems. It translates internal identifiers (OBID = Object ID, PSID = Page Set ID, DBID = Database ID) to make data valid in the target subsystem. DSN1COMP compresses, DSN1PRNT prints, DSN1SDMP dumps. Only DSN1COPY handles cross-subsystem data movement with ID translation.

Keep practicing — related questions