Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80

    Unanswered: Issue with get_dbsize_info(?,?,?,-1) , error : SQL0443N , SQLSTATE=38553

    Hi,
    I am working on db2 v9.5.0.3.
    When I am executing db2 "call get_dbsize_info(?,?,?,-1)" from any other user (having DBADM also) I am getting below error :
    SQL0443N Routine "*IZE_INFO" (specific name "") has returned an error
    SQLSTATE with diagnostic text "SQL1092 Reason code or token: <userid through which I am executing the command>
    ". SQLSTATE=38553

    I bind the packages also.

    and as per IBM link need to execute db2updv** -d dbname. But I cant make database offline as of now.
    http://www-01.ibm.com/support/docvie...id=swg21637888


    Please suggest if you have any work around.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    If the instance defines a SYSMON_GROUP then add the relevant user(s) to that group
    OR
    Get the instance-owner to explicitly grant execute on that routine to the relevant user(s).

  3. #3
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    Quote Originally Posted by db2mor View Post
    If the instance defines a SYSMON_GROUP then add the relevant user(s) to that group
    OR
    Get the instance-owner to explicitly grant execute on that routine to the relevant user(s).
    Thanks db2mor for response.
    But I have mentioned user is having DBADM privilege. Do you think after that we need to provide execute privilege ?
    As per me no ..

  4. #4
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    Error which I am getting in diag :

    2014-10-24-20.02.02.727463-240 E8350582E570 LEVEL: Warning
    PID : 27133 TID : 47581879449920PROC : db2fmp (
    INSTANCE: <instance_id> NODE : 000
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerFencedTruncateTokensUserSqlState, probe:100
    DATA #1 : signed integer, 4 bytes
    -443
    DATA #2 : String with size, 5 bytes
    38553
    DATA #3 : String with size, 23 bytes
    SYSPROC.GET_DBSIZE_INFO
    DATA #4 : String with size, 15 bytes
    GET_DBSIZE_INFO
    DATA #5 : String with size, 69 bytes
    SQL1092 Reason code or token: <userid from which I am executing the command>

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you have a chance to look up the explanation for SQL1092 in the manual?
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    Hi n_i ... yes before coming to db forum I did that..
    I did the same... but no luck over there...
    I mentioned User is having DBADM privilege, and its unix box.
    With same pramaters/privilege setting I am able to execute command in other environment.
    I am not sure why I am hitting this error in few unix boxes only.
    Please suggest me if you observe anything ....
    Last edited by niteshtheone; 10-25-14 at 17:54.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    according the doc and get_dbsize_info : dbadm is not stated for authorization - being part of sysmon group is stated as authority needed
    Authorization
    SYSMON authority
    EXECUTE privilege on the GET_DBSIZE_INFO procedure
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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