Fastunload EXCP YS

Document ID : KB000121601
Last Modified Date : 21/12/2018
Show Technical Document Details
Issue:
We get this when start running V12 in CADB2 V20 .
What do you recommend to change it into? .
PFU0160I - DSNHDECP SPECIFIES: ISO FOR DATE; ISO FOR TIME; "." FOR DEC PT .PFU0201I - DFSMS VERSION IS 2.3.0; Z/OS VERSION IS 2.3.0; . DB2 VERSION IS 121M100 ; . .
PFU0003I - FASTUNLOAD CONTROL CARD PARSING STARTED .FASTUNLOAD .DISCARDS 1 .EXCP YES .INPUT-FORMAT TABLE .IO-BUFFERS 60 .QUOTE NONE .OUTPUT-FORMAT COMMA-DELIMITED .
PFU0603I - SYSIN INPUT USES CCSID 0278 .SQL-ENCODING-CCSID (278) .COMMA ';' .PART-INDEPENDENCE NO .SHRLEVEL REFERENCE .SORTSIZE MAX .SORTNUM 32 .SQL-ACCESS EXTENSION .VSAM-BUFFERS 96 . .
PFU0307W - "EXCP YES" NOT SUPPORTED FOR "DB2 V12" .PFU0054W - WARNING - "EXCP" HAS BEEN RESET TO "MM" . . SELECT DISTINCT A.FORSAKRADNR, . A.PERSONKUNDNR, . VARCHAR_FORMAT(A.SKAPADSTAMP,'YYYY-MM-DD HH24:MI:SS') . AS SKAPADSTAMP .FROM DB2P.TEAF001FORSAKRAD A , DB2P.TEAF003FORSLAGE B .WHERE A.FORSAKRADNR = B.FORSAKRADNR . AND . SUBSTR(CHAR(B.SKAPADSTAMP),1,10) >= (CURRENT_DATE) . -30 DAYS .ORDER BY A.FORSAKRADNR
Environment:
z/os DB2
Cause:
EXCP YES set
Resolution:
EXCP YES is not supported since DB2 v8. Here is an explanation from the Action for the message PFU0307W: DB2 V8 brings the possibility of various CISIZEs in the VSAM data sets containing DB2 tablespaces where the CISIZE is the same as the PAGESIZE. Previous DB2 versions supported only 4 KB CISIZE. EXCP supports 4 KB CISIZE and will not be enhanced. In DB2 V8, EXCP YES switches to EXCP MM access automatically. Pre-DB2 V8 versions still use EXCP.