Fast Unload PART-SEPARATE YES does not print total messages PFU0250I.

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

When including the following Fast Unload for Db2 for z/OS (PFU) options when unloading a 250 part table:

PART-SEPARATE YES         
MAX-SELECTS  9999         
AUTO-TAG-SIZE   4         

Overall count lines are not produced:

PFU0232I - COUNT-TABLESPACE PAGES READ: ..............................15,204,893
PFU0234I - COUNT-TABLESPACE ROWS PROCESSED: .........................219,879,508
PFU0236I - COUNT-TABLESPACE ROWS FROM UNSELECTED TABLES: .....................00
PFU0237I - COUNT-TABLESPACE ROWS FROM SELECTED TABLES: ..............219,879,508
                                                                                
PFU0238I - COUNT-ROWS PASSED TO SELECT#01: ..........................219,879,508
PFU0242I - COUNT-ROWS WRITTEN TO SYSREC01 FOR SELECT#01:  ...........219,879,508
PFU0243I - SYSREC01 SELECTED FROM OBJ: creator.table OBID:     n                  
PFU0242I - COUNT-ROWS WRITTEN TO PUNCH01  FOR SELECT#01:  ...................376

 

Is this working as designed?
Is there an option to create these lines when running the parts in parallel?

Resolution

For the following message and total messages that follow:
PFU0250I - TASK #00 GRAND TOTAL STATISTICS FOR: TABLESPACE - dbname.tsname

Due to the partitions executing in parallel, the total statistics messages are not generated
and is working as designed.  There is no available option to create these total statistics
when executing in parallel with PART-SEPARATE YES and functions the same way if the
SELECT statements are manually coded as well such as:

SELECT * FROM creator.table PART 1;
SELECT * FROM creator.table PART 2;
SELECT * FROM creator.table PART 3;
etc....