DBG37006E MIB 19:30:05 DB2 CALL FOR IFI CALL RESULTED IN FRB RETCODE 0100 AND FRB REASON CODE 00F30018

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

CA Datacollector Started task IDB2DCSC job abends daily at a particular time(19:30 PST) in Production.

Below is the Information found from DBGPRINT                                                                          
DBG43004I MIB  19:30:05 IFI FUNCTION READA    COMPLETED WITH RETURN CODE 0100 AND REASON CODE 00F30018
DBG37006E MIB  19:30:05 DB2 CALL FOR TERMINATE THREAD RESULTED IN FRB RETCODE 0100 AND FRB REASON CODE 00F30018
DBG37005I MIB  19:30:05 DATA COLLECTOR DISCONNECTED FROM DB2 SUBSYSTEM MIB     
                                                                               
DBG39038I MIB  19:30:05 TERMINATION STARTED FOR DATA COLLECTOR FOR DB2 SUBSYSTEM MIB
DBG84003I MIB  19:30:05 HEALTH CHECKER SUBTASK TERMINATING                     
DBG84004I MIB  19:30:05 HEALTH CHECKER SUBTASK TERMINATION COMPLETE            

                                                                               
  

Environment

Release : 19.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

The Data Collector userID will need to have been granted EXECUTE on the CA-Insight explain plan, referenced in the PLANSxx member of the parmlib. The IDGRANT in the .SOURCE library contains a sample GRANT EXECUTE statement.

See the following link for more about it. Let me know if you have any question.https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/configuring/security/db2-authorizations.html