Topic
  • 6 replies
  • Latest Post - ‏2014-06-12T18:02:46Z by Samuel Pizarro
Samuel Pizarro
Samuel Pizarro
4 Posts

Pinned topic SYSPROC.ADMIN_GET_MEM_USAGE() with SQL0444N error on Windows 7

‏2014-06-07T02:23:47Z |

db2 express-C 10.1 installed in a Window7 64bits:

C:\Program Files\IBM\SQLLIB\BIN>db2level
DB21085I  Instance "DB2" uses "64" bits and DB2 code release "SQL10010" with
level identifier "0201010E".
Informational tokens are "DB2 v10.1.0.872", "s120403", "NTX64101", and Fix Pack
"0".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name
"DB2Server".

Executing the follwoing table function (from CLP, or from DataStudio using jdbc), I am receiving this SQL0444N error:

SELECT * FROM TABLE(SYSPROC.ADMIN_GET_MEM_USAGE()) AS T


MEMBER MAX_MEMBER_MEM       CURRENT_MEMBER_MEM   PEAK_MEMBER_MEM
------ -------------------- -------------------- --------------------
SQL0444N  Routine "*EM_USAGE" (specific name "ADMIN_GET_MEM_USAGE_AP") is
implemented with code in library or path "...db2dbroutext", function
"adminGetMemUsage_ap" which cannot be accessed.  Reason code: "6".
SQLSTATE=42724

 

 

  • nivanov
    nivanov
    19 Posts

    Re: SYSPROC.ADMIN_GET_MEM_USAGE() with SQL0444N error on Windows 7

    ‏2014-06-10T16:16:40Z  

    So, is the library "db2dbroutext" present under C:\PROGRA~1\IBM\SQLLIB?

  • Samuel Pizarro
    Samuel Pizarro
    4 Posts

    Re: SYSPROC.ADMIN_GET_MEM_USAGE() with SQL0444N error on Windows 7

    ‏2014-06-11T01:59:23Z  
    • nivanov
    • ‏2014-06-10T16:16:40Z

    So, is the library "db2dbroutext" present under C:\PROGRA~1\IBM\SQLLIB?

    Hi Nivanov

    It looks it is.  The only file with that name that I found is this dll under sqllib\bin\routine directory:

    C:\Program Files\IBM\SQLLIB\BIN\routine>dir db2dbroutext*
     Volume in drive C has no label.
     Volume Serial Number is 822A-F81B

     Directory of C:\Program Files\IBM\SQLLIB\BIN\routine

    05/04/2012  01:30         3.706.728 db2dbroutext.dll
                   1 File(s)      3.706.728 bytes
                   0 Dir(s)  204.429.062.144 bytes free

     

    and this are the permissions to the file:

    PS C:\Program Files\ibm\SQLLIB\bin\routine> Get-Acl .\db2dbroutext.dll | Format-List

    Path   : Microsoft.PowerShell.Core\FileSystem::C:\Program Files\ibm\SQLLIB\bin\routine\db2dbroutext.dll
    Owner  : NT AUTHORITY\SYSTEM
    Group  : NT AUTHORITY\SYSTEM
    Access : NT AUTHORITY\SYSTEM    Allow  FullControl
             BUILTIN\Administrators Allow  FullControl
             BUILTIN\Users          Allow  ReadAndExecute, Synchronize
    Audit  :
    Sddl   : O:SYG:SYD:AI(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;0x1200a9;;;BU)

    I am running the db2 cmds (the query) from a db2 CLP window with Administrator elevated privileges, and my ID is member of Administrators group.

    Thanks

  • nivanov
    nivanov
    19 Posts

    Re: SYSPROC.ADMIN_GET_MEM_USAGE() with SQL0444N error on Windows 7

    ‏2014-06-11T12:44:50Z  

    Hi Nivanov

    It looks it is.  The only file with that name that I found is this dll under sqllib\bin\routine directory:

    C:\Program Files\IBM\SQLLIB\BIN\routine>dir db2dbroutext*
     Volume in drive C has no label.
     Volume Serial Number is 822A-F81B

     Directory of C:\Program Files\IBM\SQLLIB\BIN\routine

    05/04/2012  01:30         3.706.728 db2dbroutext.dll
                   1 File(s)      3.706.728 bytes
                   0 Dir(s)  204.429.062.144 bytes free

     

    and this are the permissions to the file:

    PS C:\Program Files\ibm\SQLLIB\bin\routine> Get-Acl .\db2dbroutext.dll | Format-List

    Path   : Microsoft.PowerShell.Core\FileSystem::C:\Program Files\ibm\SQLLIB\bin\routine\db2dbroutext.dll
    Owner  : NT AUTHORITY\SYSTEM
    Group  : NT AUTHORITY\SYSTEM
    Access : NT AUTHORITY\SYSTEM    Allow  FullControl
             BUILTIN\Administrators Allow  FullControl
             BUILTIN\Users          Allow  ReadAndExecute, Synchronize
    Audit  :
    Sddl   : O:SYG:SYD:AI(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;0x1200a9;;;BU)

    I am running the db2 cmds (the query) from a db2 CLP window with Administrator elevated privileges, and my ID is member of Administrators group.

    Thanks

    Normally I'd suggest installing the latest fix pack, but this being Express-C I guess your only option is to reinstall a newer version of DB2.

    Was this database migrated from an earlier version of DB2 by chance?

  • Samuel Pizarro
    Samuel Pizarro
    4 Posts

    Re: SYSPROC.ADMIN_GET_MEM_USAGE() with SQL0444N error on Windows 7

    ‏2014-06-11T17:36:40Z  
    • nivanov
    • ‏2014-06-11T12:44:50Z

    Normally I'd suggest installing the latest fix pack, but this being Express-C I guess your only option is to reinstall a newer version of DB2.

    Was this database migrated from an earlier version of DB2 by chance?

    Hi Nivanov. 

    You mean, installing db2 express-c 10.5 ? 

    Have you tested this at least to see if this is isolated here, or if this is really a bug on express-c 10.1 ?

    And NO, this DB was created under this release.  not migrated from a previous version.

     

    Regards

    Samuel

  • nivanov
    nivanov
    19 Posts

    Re: SYSPROC.ADMIN_GET_MEM_USAGE() with SQL0444N error on Windows 7

    ‏2014-06-11T17:43:15Z  

    Hi Nivanov. 

    You mean, installing db2 express-c 10.5 ? 

    Have you tested this at least to see if this is isolated here, or if this is really a bug on express-c 10.1 ?

    And NO, this DB was created under this release.  not migrated from a previous version.

     

    Regards

    Samuel

    All I can say it seems to work properly on DB2 Express-C 10.5 fp 1 on Linux.

  • Samuel Pizarro
    Samuel Pizarro
    4 Posts

    Re: SYSPROC.ADMIN_GET_MEM_USAGE() with SQL0444N error on Windows 7

    ‏2014-06-12T18:02:46Z  
    • nivanov
    • ‏2014-06-11T17:43:15Z

    All I can say it seems to work properly on DB2 Express-C 10.5 fp 1 on Linux.

    Hi Nivanov

    table function syspro.admin_get_mem_usage() worked properly on db2 express-c 10.5.

    C:\Program Files\IBM\SQLLIB\BIN>db2 "select * from table(sysproc.admin_get_mem_usage()) as t"

    MEMBER MAX_MEMBER_MEM       CURRENT_MEMBER_MEM   PEAK_MEMBER_MEM
    ------ -------------------- -------------------- --------------------
         0           3432411136            456130560            497811456

      1 record(s) selected.


    C:\Program Files\IBM\SQLLIB\BIN>db2level
    DB21085I  This instance or install (instance name, where applicable: "DB2")
    uses "64" bits and DB2 code release "SQL10051" with level identifier
    "0602010E".
    Informational tokens are "DB2 v10.5.100.64", "special_31160", "IP23521_31160",
    and Fix Pack "1".
    Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2SRV1".

     

    Thanks