DBG37006E 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
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Sysview Performance Management for Db2 for z/OS (IDB2) Data Collector task abends daily at a particular time (19:30 PST) in Production.

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

Resolution

The Data Collector USERID must be granted EXECUTE on the Sysview for Db2 explain plan referenced in the PLANSxx member of
hlq.CDBAPARM. The IDGRANT in the .SOURCE library contains a sample GRANT EXECUTE statement.

 
See the following link:
Db2 Authorizations

Note: Pay attention to whether initialization completed or not. The run time will be less than a minute if the IDGRANT was not done
generally and the return and reason codes would have to match the one in the problem description.