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

Products

• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/Introduction

Symptoms:

USER COMPLETION CODE=0502

TIME=14.40.26 SEQ=02777 CPU=0000 ASID=002D

PSW AT TIME OF ERROR 078D1000 80141702 ILC 2 INTC 0D

ACTIVE LOAD MODULE ADDRESS=00140000 OFFSET=00001702

NAME=UTLFUGLB

 

This occurs after upgrade to r18.

 

Environment: 

CA Fast Unload r18 for DB2 for z/OS r18

 

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

In r18, you will need to force CA Fast Unload 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 CA Fast Unload job

2) Create a PFU member in hlq.CDBAPARM with the syntax SYSADM SETUP so all CA Fast Unload jobs will use this as a global default.

 

Additional Information:  

Documentation reference:

R18 CA Fast Unload User Guide / Getting Started / Required Authorization

https://docops.ca.com/ca-fast-unload-db2/18/en/getting-started/required-authorizations/sysadm-authorization-considerations

 

 

Environment

Release:
Component: PFU