Database Management Systems

Orchestrate (IBM InfoSphere DataStage parallel framework) has its own type system distinct from standard DataStage stages. OSH (Orchestrate Shell) import operators explicitly handle type conversion from external formats like sequential files into Orchestrate schema types. A is false because they're different systems, B is false because varchar/integer aren't native Orchestrate types, C is false because int32 IS a valid Orchestrate type.

TIMESTAMP, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH are standard datetime and interval data types supported in SQL for column definitions.

DSN1CHKR is the IBM DB2 standalone utility that verifies the integrity of the DB2 directory and catalog. This is a critical diagnostic tool. DSN1SDMP is for formatted dumps, DSN1LOGP prints log records, DSN1COMP compresses data. Only DSN1CHKR performs integrity verification of DB2's core metadata structures.

DSN1COMP is a DB2 for z/OS standalone utility that analyzes data in a table space or image copy to estimate the percentage of disk space saved if compression is enabled. DSN1CHKR checks page consistency, DSN1COPY copies data sets, and DSN1SDMP dumps data pages.

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.

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. This is a duplicate question.

DSN1CHKR is the DB2 standalone utility specifically designed to verify the integrity of the DB2 directory and catalog structures. It checks for structural inconsistencies and reports any corruption found. DSN1SDMP is for formatting data dumps, DSN1LOGP formats log records, and DSN1COMP estimates compression savings.

DSN1COMP is the compression utility that analyzes data and estimates the space savings achievable through DB2 data compression. It provides detailed reports on compression ratios without actually compressing the data. DSN1CHKR checks integrity, DSN1COPY copies data, and DSN1SDMP dumps data.

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.

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.