IBM Support

During SQL processing an error is returned: SQL0727N An error occurred during implicit system action type "3" related to SNAPSHOT_APPL_INFO function

Troubleshooting


Problem

During SQL processing the following error message below is being received...
 

    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0727N An error occurred during implicit system action type "3".
    Information returned for the error includes SQLCODE "-440", SQLSTATE "42884"
    and message tokens "SNAPSHOT_APPL_INFO|FUNCTION". LINE NUMBER=5.
    SQLSTATE=56098
 
SQL0727N Reason Code "3" means an object is implicitly being re-validated and meeting with error SQL0440N SQLSTATE "42884"
 
    SQL0440N No authorized routine named "<routine-name>" of type
    "<routine-type>" having compatible arguments was found.

Symptom

Observed in the db2diag.log (from db2support) following entries....

    2018-08-01-15.53.55.019511+120 I6988710A927        LEVEL: Info
    PID    : 10748074            TID : 16878         PROC : db2sysc 0
    INSTANCE: db2inst1            NODE : 000          DB  : SAMPLE
    APPHDL : 0-64194             APPID: *LOCAL.db2inst1.123456789123
    AUTHID : DB2INST1            HOSTNAME: testsrv1
    EDUID  : 16878               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:670
    MESSAGE : ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND
             "Could not find an internal object required to process the command"
    DATA #1 : String, 51 bytes
    An error was detected during statement compilation.
    DATA #2 : String, 252 bytes
    Compiler error stack for rc = -2144272380:


   ....etc.

    2018-08-01-15.53.55.020185+120 I6989638A1021       LEVEL: Info
    PID    : 10748074            TID : 16878         PROC : db2sysc 0
    INSTANCE: db2inst1            NODE : 000          DB  : SAMPLE
    APPHDL : 0-64194             APPID: *LOCAL.db2inst1.123456789123
    AUTHID : DB2INST1            HOSTNAME: testsrv1
    EDUID  : 16878               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, access plan manager, sqlra_compile_var, probe:700
    MESSAGE : ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND
             "Could not find an internal object required to process the command"
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCAL   sqlcabc: 136  sqlcode: -440  sqlerrml: 27
     sqlerrmc: SNAPSHOT_APPL_INFO FUNCTION
     sqlerrp : SQLNQ259
    ...etc.

.. followed by a couple of entries after.....

   2018-08-01-15.53.55.021348+120 I6991552A2501       LEVEL: Info
    PID    : 10748074            TID : 16878         PROC : db2sysc 0
    INSTANCE: db2inst1            NODE : 000          DB  : SAMPLE
    APPHDL : 0-64194             APPID: *LOCAL.db2inst1.123456789123
    AUTHID : DB2INST1            HOSTNAME: testsrv1
    EDUID  : 16878               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, access plan manager, sqlra_compile_var, probe:800
    MESSAGE : stmt
    DATA #1 : Hexdump, 387 bytes
    0x0A0002000184C71C : 4352 4541 5445 2046 554E 4354 494F 4E20   CREATE FUNCTION
    0x0A0002000184C72C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C73C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C74C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C75C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C76C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C77C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C78C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C79C : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C7AC : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C7BC : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C7CC : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C7DC : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX
    0x0A0002000184C7EC : 0000 0000 0000 0000 0000 0000 0000 0000   XXXXXXXXXXXXXXXX

Document Location

Worldwide

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"Function;Routine;","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"AESE, ESE, WGSE","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

ibm10961568

Page Feedback