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

book

Article ID: 210468

calendar_today

Updated On:

Products

CA Fast Unload for DB2 for z/OS

Issue/Introduction

When including the following CA 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: HM1.TDOCLML OBID:     5                  
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?

Environment

Release : 20.0
Component : CA Fast Unload for DB2 for z/OS

Resolution

For the following message and total messages that following:
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 HM1.TDOCLM PART 1;
SELECT * FROM HM1.TDOCLM PART 2;
SELECT * FROM HM1.TDOCLM PART 3;
etc....