A046 SQL - ERROR IN SUBSYSTEM "xxxx", RTRN CODE 12, RSN CODE X'00F30077'

Document ID : KB000031772
Last Modified Date : 14/02/2018
Show Technical Document Details

The X'00F30077' message means:    

                                   
Explanation: 

A plan or package could not be executed for one of these reasons:                                                             

The most likely reason is:

They had not been granted execute on the package.

Other possibilities are:

-   It is disabled in the environment in which you attempted to run.   
-   The attach library that you are using is from a previous release of
    DB2 that does not support the ENABLE and DISABLE options of the bind
    operation.                                                         
System Action:  The plan or package is not executed.                   
System Programmer Response:  One of the following:                     
-   Rebind the plan or package to enable it to execute in the present  
    environment.                                                       
                                                                       
-   Check the SYSPLSYSTEM or SYSPKSYSTEM catalog table to find an      
    environment in which the plan or package can be executed.          
-   Correct the attach library.