Scenario conceptual descriptions

UNLOAD

Customize Unload Output Using Expressions

EXTRACT_FORMAT=EXTRACT (by default)

INCLUDE SEGMENT with WHERE

EXCLUDE SEGMENT with WHERE

OUTPUT SEGMENT with WHERE and FIELDS

OUTPUT SEGMENT with FIELDS

OFILECTL with OAREA and DDNAME

• Include segment record in unload output file if conditional criteria are met
• Exclude segment record from processing if conditional criteria are met
• Control content of a segment record in unload output file by including segment if conditional criteria are met
• Control content of a segment record in unload output file
• Specify output file

Customize unload output using expressions

Offline EXTRACT

Customize Offline Extract Output Using Expressions

EXTRACT_FORMAT=USER

EXPAND

INCLUDE SEGMENT

SAMPLE_LIMIT

INCLUDE SEGMENT with WHERE

OUTPUT SEGMENT with FIELDS

OUTPUT SEGMENT with WHERE and FIELDS

USER_RECORD with BREAK / BEFORE FIELDS

OFILECTL with OAREA and DSNAME

• Create customized format for output file
• Expand compressed data
• Include sampling of root segments based on root segment count
• Include segment record for extract processing if conditional criteria are met
• Control content of a segment record in extract output
• Control content of a segment record in extract output by including segment if conditional criteria are met
• Create and define content for a database-level header record
• Specify output file name and attributes

Customize offline extract output using expressions

Control Interval Dump and Modification Utility (PROCESS_AREA command)

Use the SNAP Function to Dump Control Interval

PERFORM subcommand

SNAP function

Snap dump a specified control interval

Use the SNAP function to dump control interval

Control Interval Dump and Modification Utility (PROCESS_AREA command)

Repair Pointer Values Online Using VER and REP Functions

PERFORM subcommand

VER function

REP function

• Use VERify and REPlace function to verify and replace corrupted pointer values
• Commit repaired (replaced) pointer values to DASD

Repair pointer values online using VER and REP functions

Control Interval Dump and Modification Utility (PROCESS_AREA command)

Print Fields within In-Core DMAC

PERFORM subcommand

DMAC_PRINT function

Perform in-core DMAC print of specified area

Print fields within in-core DMAC

Area Change Modeling Utility (PFMD0100 Program)

Model Effects of Changing Randomizer for All Areas

CTL control statement:

DBDNAME / AREA

RPT

RMOD

• Specify a different randomizer than the randomizer currently specified in DBD
• Request report reflecting detailed record count

Model effects of changing randomizer for all areas

Area Change Modeling Utility (PFMD0100 Program)

Model Effects of Changing UOW and Root Values for Selected Areas

CTL control statement:

DBDNAME / AREA

ROOT

UOW

Increase ROOT and UOW values for specific areas

Model effects of changing UOW and ROOT values for selected areas

Area Change Modeling Utility (PFMD0100 Program)

Model Effects of Changing Control Interval Size for an Area

Control Segment Placement

CTL control statement:

DBDNAME / AREA

CISIZE

SEG control statement:

NAME

LIMITCT

• Change size of control interval for one area
• Limit the number of segments to be placed in RAA

Model effects of changing control interval size for an area and control segment placement

Area Change Modeling Utility (PFMD0100 Program)

Model Effects of Converting from Full-Function to DEDB Format

DBD control statement:

DBDNAME / AREA

UOW

ROOT

CISIZE

• Change ROOT and UOW values for selected area
• Change control interval size for two areas

Model effects of converting from full-function to DEDB format

File Sort Utility (PFPSORT command)

Sort File in Ascending Order by Root Key

SORT_SEQUENCE=KEY_ ASCEND

SORT_OPTION

Specify customized sort sequence for file with root key values as the sort key

Sort file in ascending order by root key

File Sort Utility (PFPSORT command)

Sort File in Ascending Order by RAP

Sort Logical SDEPs in Reverse Sequence

SORT_SEQUENCE=RAP_ ASCEND,SDEPSEQ

SORT_OPTION

• Specify customized sort sequence for file with RAP values as the sort key
• Specify sort sequence for associated SDEPs
• Specify dynamic allocation of sort work files

Sort file in ascending order by RAP and sort logical SDEPs in reverse sequence