DBG550D3I DB2 CREATE THREAD FAILED

Document ID : KB000117893
Last Modified Date : 25/10/2018
Show Technical Document Details
Issue:
The following error message was displayed when trying to display the SQL text with T option in INCOMPTD panel  : DBG550D3I DB2 create thread failed (RC=0008-00F30034) DB2CVUS DB2C
Resolution:
The DBG550D3I message indicates the user id specified in the message does not have the authorization to Execute the Sysview for DB2 plan for System Explains. 
The plan name can be found in the PLANS00 member of CDBAPARM. Grant statements are found in IDGRANT member of HGHLVL.SOURCE library. 
The Product Authorization function off the DB2 tools main menu can also be used to to grant the Execute privilege to the plans as an alternative.