DPS V5.2.1


Supported Platforms:

OS/390, VSE

Supported ADABAS Versions:

5.x, 6.x, 7.x, 8.x

Current Fix Level:


g
Current Zap Level:


--
Batch, On-line, or Both:

Batch

Current Version:

5.2.1.g

Currently, no Zaps are necessary for DPS V5.2.1

Fixes

FIX EXPLANATION

A

Fix A resolves all issues encountered during early release implementation.

B

Support for Adabas v8.3.
Reference #27480

When a numeric column has non-numeric data, an LTR00111 error message is displayed. This error message has been enhanced to include DBID/FNR/TABLE for the problem data.
Reference #24483

The file number may be incorrect on an ADARES Regenerate Checkpoint.
Reference #27370

A S0C3 abend may occur when processing a spanned block record with a Before Image (BI) with multiple record segments and an After Image (AI) that contains only one record segement.
Reference #27464

C

COLACAST - New Column ETR - Sets the column value to the highest occurrence number for a column mapped from an MU or elementary field within a PE group. Reference #29970

COLANVAL - Column ETR was missing from the V521 initial release. Reference #29907

COLAUNIQ - Reassembled to get new offsets for a MACRO that was changed. Reference #29907

FLDAHEXV - This Field ETR has been enhanced to provide user customizable symbolic variables to allow for 3 possible outcomes if the input value is low values (x'00's). &EMPTY=R, the default will replace each byte of x'00' with 2-bytes of c'00'. &EMPTY=E, will exit without setting a replacement value. &EMPTY=N, will set the replacement value to null. Reference #29907

DPSSPLIT (mainframe only) has been enhanced to allow user specification of fixed or variable blocked output files (DDCTL and DDMAT). When writing the MAT file to a fixed block output file, a TAB (x'05') will be added to the end of each line. Reference #24351

DPSSPLIT (Java only) was enhanced for the generation of multiple files for parallel bulk loading, using the -maxrec= option. Reference #27552

Compatibility enhancements for DPSv521 and DPYv521. Reference #27629, #28680

Select Criteria involving PE fields produces incorrect results. Reference #25876

An SOC7 abend in DPSDCOM2 may occur when processing a spanned record. This abend only occurs when the record size is equal to the maximum record size. Reference #27662

ACTAVBM performance enhancements (Materialization only). Reference #29942, #31102

Additional changes to support lower case ADABAS field names. Reference #29954

An SOC7 abend occurs during APC processing. Reference #31131

Select Criteria involving ADABAS binary fields is incorrect. Reference #31143

D

ACTANDEL - The compare of the table name between the CHILDTBL input and the table name in the DDPARML always compares 120 bytes. Reference #32014

DPS operator commands were not working properly in VSE. Reference #29967

When running MATERIALIZATION SQL or MATERIALIZATION TRANSSQL, and SQLOUT (for ZOS) or SYS018 (for VSE) is not specified in the JCL, the run would complete with RC 0 and no output. This situation will now issue an error message and issue an RC 8. Reference #31078

An abend may occur when ACTAVBM is specified and the VBMPARM input file contains an odd number of entries. Reference #31202

Oracle SQL generator will now concatanate a column value > 2499 on multiple lines in the SQL statements. Reference #31241

Correction to error messages displayed when DPS encounters a problem with partial backed out images. Reference #31406

Processing Adabas v8.3 PLOGs may encounter an APC-03 error or LTR00033 error. Reference #31689, #32045

CHECKFDT results incorrect when running APC. Reference #31707

DPS propagation using implicit MU within PE mappings (PELOW=0, PEHIGH=0, MULOW=0, MUHIGH=0) may have missing transactions. Reference #31774

Clean up error messages written from ETRs. Reference #32030

APC may encounter an abend 'UNSUCCESSFUL SORT 0C7' if a x»03» is used as an ET checkpoint (close for EXF user or close for EXU user). Reference #32065

DPS v521 fix C does not correctly process complex Select statements. Specifying multiple Select statements for the same file results in DPS ignoring all but the first Select statement. Reference #32092

APC statistics are incorrect. Reference #32110

Adabas v8.4 compatibility. Reference #32187

E

Enhancement to provide support for logical ISNs. To implement logical ISNs modify the DDPARM file or entries in the new module DPSLISNP. Reference #31887

S213-17 error with CHECKEXP specified for an expanded file if the associator file has a large block size. Reference #32363

Enhanced error processing. If the DDPLOG input file is missing from a Propagation run, an error message is displayed and an RC 8 is issued instead of an SOC4 abend. If ACTROUTINE=ACTALODx, ACTROUTINE=OUTALODx or OUTROUTINE=ACTALODx is defined in the DDPARML file an error message is now displayed and an RC 8 is issued. Reference #32397, #32398

Correct a problem with extract statistics if DPS is run with 'PROPAGATION EXTRACT' runtime parameter. Reference #32401

DPS v521 fix D does not correctly process SELECT statements with NE operator when the column values is null. Reference #32717,#32727

DPSCLRPT is a new module similar to DSCLEAN. It is designed to report which lines and columns contain non-printable values. Reference #32771

Correct problem with SUBFILE parameter processing. Reference #33893

Load of a module on VSE sometimes failing. Reference #33940

The rightmost digits of ISN are missing if the value is greater than 2,147,483,647. Reference #33952

F

Corrected problems with comparing the values defined in the EXP= parameter and the results from CHECKEXP obtained from the ADABAS associator. Reference #32114

Avoid calls to check if a JCL DD statement is present if running DPSYNC. Reference #35171

Changed the wording of a message if certain checkpoints are encountered on the PLOG and the file involved with the checkpoint is being processed by DPS, The wording is only changed if the file has NOREMOVE specified in DPS parameters.

Old wording:

FILE xxxxx DBID xxxxx HAS BEEN PHYSICALLY ALTERED. REMATERIALIZATION MAY BE NECESSARY, OR SPECIFY NOREMOVE FOR FIKLE AND RERUN.

New wording:

FILE xxxxx DBID xxxxx PHYSICALLY ALTERED, NOREMOVE SPECIFIED, FILE NOT REMOVED. REMATERIALIZATION MAY BE NECESSARY.

Reference #35190

In the case of spanned block records being processed by DPS, SRLOG=ALL must be specified. A loop was encountered when SRLOG=ALL was not specified. Reference #36360

Incorrect SQL generated when processing a PE Group that contains an MU in PE. Errors are encountered when a PE occurrence contains a value only for the MU in PE (no PE elementary field values) OR when at least one PE occurrence is entirely null and a subsequent PE occurrence contains a value only for the MU in PE (no PE elementary field values). Reference #36467, #37550

Avoid occasional SOC6 and instead display this error: DPS00030--LENGTH OF VALUE GREATER THAN FIELD LENGTH Reference #37625

38863 - Adjust null= handling in DPS v521 to be similar to DPS v511 for columns mapped with constants. Reference #38863

G

Quoted string not properly terminated if a value has a single quote embedded in position 257, 513, 769, A first fix corrected this problem but introduced a problem with a single quote embedded in other positions. The second fix corrected this new problem as well as the original problem. Reference #39015

Propogation job would loop if the ADABAS version was not supported. Reference #39136

Fixed an issue with some updates being done without corresponding INSERT by revising backout handling. Reference #39202

Fixed a S0C4 in module DPSAUTOF by only counting FDT's (not SDT's). Reference #39265

Support ADABAS 8.5. Reference #38970

Properly handle spanned records. Reference #39570

Correct incorrect statistics reported by APC. Reference #39999