Forum

Hi Klaus,

you probably will not solve the problem just by altering DCB attributes of your output files.

I would like to make following suggestion:

Create one or more DB2 tables dedicated to output processing. For example one table for each DD-name. Or one table for each unique DCB-type (e.g. OUT_FB80, OUT_VB137). Add a sequence or running number SEQNR to each table as a key field. And add a RECORD field (CHAR(80), or VARCHAR(137) ) to your table(s).

Then you should redesign your application: First do your business work and write output to that DB2 output table(s) dedicated to output processing.

Once the batch application program finaly finished work, or or finished restart processing, then it’s time to process your output tables: Develop an application program which only processes DB2 output tables. For example, to write reports or to create interface files to other IT processes.

After all your output and files have been sucessfully created, you may TRUNCATE that DB2 output tables.

This design should solve your restart/recovery problems using sequential output datasets!

Regards
Gernot