Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: DB2 Function LISTAGG failing with SQL0440N

    We have several DB2 Servers and multiple instances all running DB2 LUW (windows) DB2 V9.7 Fixpack 9

    a call to DB2 Function LISTAGG is working against some of the databases - and failing in others.

    Here is the SQL:

    SELECT COL1, COL2, LISTAGG(AGT_DESGNT_CD,',') WITHIN GROUP (ORDER BY AGT_DESGNT_CD ) AS AGT_DESGN_DESC
    FROM myschema. mytable
    GROUP BY COL1, COL2
    ORDER BY COL1, COL2

    Here is the error:
    Error during Prepare
    42884(-440)[IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named "LISTAGG" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

    I cannot find a pattern as to why it is failing in some databases and not in others. On one Server, I have 2 Databases - both in the same instance - and it is failing in one and not the other.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Try to run the following command as an instance owner against your problematic databases.
    db2updv97 -d mybaddb
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •