Fast Unload abends with USER COMPLETION CODE=0502 in module UTLFUGLB

Products

• Fast Unload for DB2 for z/OS
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Fast Unload for Db2 for z/OS (PFU) abends with a USER COMPLETION CODE of
U0502 in module UTLFUGLB:

USER COMPLETION CODE=050
PSW AT TIME OF ERROR 078D1000 80141702 ILC 2 INTC 0D
ACTIVE LOAD MODULE ADDRESS=00140000 OFFSET=00001702
NAME=UTLFUGLB

Cause

SYSADM Authorization Considerations:

Important! You can no longer specify a group ID as a SYSADM ID. Instead, update the SYSADM value in SETUP
or the SYSADM1 value in DSNZPARM with a user ID that is defined to the external security server and to DB2.
This user ID must have the appropriate DB2 authorizations.

Resolution

Force PFU to read the SETUPxx member SYSADM values by coding SYSADM SETUP.

This can be done in two ways:
1) Coding SYSADM SETUP within the SYSIN syntax of the PFU job
2) Create a PFU member in hlq.CDBAPARM with the syntax SYSADM SETUP so all PFU jobs will use this as a global default

Additional Information

SYSADM Authorization Considerations