Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2014
    Posts
    20

    Question Unanswered: Unable to execute stored procedures

    Hi,
    I am using the db2 database of 9.7 Version,fixpack 3,edition is ESE and Operating system is Linux( 5.4 Tikanga).

    When am i trying to execute any procedure like get_dbsize_info or automaint_get_policyfile or automaint_get_policy getting "SQL1042C An unexpected system error occurred. SQLSTATE=58004"

    I checked that DB2 Administration Server password is correct,the DB manager is also correctly installed.

    I need to inform that able to connect manually to Database and applications are able to DB properly.

    Can any one help in resolving this issue please..

    Regards,
    Santosh K

  2. #2
    Join Date
    Apr 2012
    Posts
    156
    Can you execute the procedure from the command line via the instance id?

  3. #3
    Join Date
    Jan 2014
    Posts
    20
    Quote Originally Posted by azready View Post
    Can you execute the procedure from the command line via the instance id?
    Hi,

    The above mentioned procedures are executed in the command line via the instance ID.

    Regards,
    Santosh

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Santosh Kenguva View Post
    I need to inform that able to connect manually to Database and applications are able to DB properly.

    Can any one help in resolving this issue please..
    Do you think that db2diag.log might have additional information?
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2014
    Posts
    20
    Hi,

    The below log observed in the db2diag.log while executing the procedure query.


    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved
    to the nearest symbol)
    [0] 0x00002AE27682B260 pdLog + 0x398
    [1] 0x00002AE2769B2AE9 _Z17sqlerAllocIPCListP18SQLCC_INITSTRUCT_TmP11sqle rFmp
    Row + 0x16D
    [2] 0x00002AE2769B0CEF _Z17sqlerAddFmpToPoolP13sqlerFmpParmsP14sqlerFmpHa ndle
    PiP16SQLO_EDUWAITPOSTP8sqeAgentbbbi + 0x9DB
    [3] 0x00002AE2769AF506 _Z19sqlerGetFmpFromPoolP14sqlerFmpHandleP13sqlerFm pPar
    ms + 0x7B2
    [4] 0x00002AE2769AC820 _Z24sqlerInvokeFencedRoutineP13sqlerFmpParms + 0x3EA
    [5] 0x00002AE276F2B835 _Z9sqlricallP8sqlrr_cb + 0xF4D
    [6] 0x00002AE279135CC4 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x13E
    [7] 0x00002AE276E44056 _Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x1AA4
    [8] 0x00002AE276E3C466 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x118
    [9] 0x00002AE276A50921 _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDM Obje
    ct + 0x4E7

    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, pr
    obe:0
    MESSAGE : SQO semop=> pSSemID:
    DATA #1 : Hexdump, 4 bytes
    0x00002AE616C3DBAC : 0000 0000

    DATA #1 : String, 58 bytes
    marking fmp as unstable after new thread creation failure:
    DATA #2 : String, 8 bytes
    Fmp TID:
    DATA #3 : Hexdump, 8 bytes
    0x00002AE616674D90 : 0000 0000 0000 0000 ........
    DATA #4 : String, 8 bytes
    Fmp Row:
    DATA #5 : sqlerFmpRow, PD_SQLER_TYPE_FMP_ROW, 496 bytes
    fmpPid: 6904
    fmpPoolList Ptr: 0x0000000000000000 fmpForcedList Ptr: 0x0000000000000000
    nextFmpCB Ptr: 0x000000020077f640 prevFmpCB Ptr: 0x0000000000000000
    fmpIPCList Ptr: 0x0000000200de77a0
    stateFlags: 0x00000152 numFmp32Attaches: 0
    numActiveThreads: 0 numPoolThreads: 0
    fmpCodePage: 0 fmpRowUseCount: 1
    active: 0x01 rowLoaderValidate: 0x00
    ipcLatch:
    0x00002AE616AA4B44 : 0100 B001 ....
    rowLatch:
    0x00002AE616AA4B48 : 0100 B101 ....
    fmpAgentList:
    0x00002AE616AA4B50 : 0800 0700 3433 0000 0000 0000 0000 0000 ....43.........
    .
    0x00002AE616AA4B60 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4B70 : 0000 0000 0000 0000 0000 0000 2A00 0000 ............*..
    .
    0x00002AE616AA4B80 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4B90 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4BA0 : 0000 0000 2A00 0000 0000 0000 0000 0000 ....*..........
    .
    0x00002AE616AA4BB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4BC0 : 0000 0000 0000 0000 0000 0000 2A00 0000 ............*..
    .
    0x00002AE616AA4BD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4BE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4BF0 : 0000 0000 2A00 0000 0000 0000 0000 0000 ....*..........
    .
    0x00002AE616AA4C00 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4C10 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4C20 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4C30 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4C40 : 0000 0000 5345 4D41 5048 4F52 4520 5741 ....SEMAPHORE W
    A
    0x00002AE616AA4C50 : 4954 0000 0000 0000 0000 0000 0000 0000 IT.............
    .
    0x00002AE616AA4C60 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4C70 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4C80 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4C90 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4CA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4CB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ...............
    .
    0x00002AE616AA4CC0 : 404B AA16 E62A 0000 40DB C316 E62A 0000 @K...*..@....*.
    .
    0x00002AE616AA4CD0 : 6047 AA16 E62A 0000 0000 0000 0000 0000 `G...*.........
    .
    0x00002AE616AA4CE0 : 0000 0000 0000 0000 0100 0000 0000 0000 ...............
    .

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

    Who is the owner of the ~db2instanceowner/sqllib/ctrl/.fencedID file?
    What's the contents of this file?
    You can try to determine this user like described here:
    How to determine the fenced user id for the instance

    If you have a chance to stop the instance you can try to run the following command from root:
    db2iupdt -u db2fenceduser db2instanceowner
    Regards,
    Mark.

  7. #7
    Join Date
    Jan 2014
    Posts
    20
    Hi Mark,

    The owner of the file .fencedID is with the number 502.

    The content of this file is "db2fenc1".

    There is no process running with the name db2fmp and in the db2pd -fmp command output the Fenced User is unknown.

    There is no chance to stop the instance as it is a live system. Please help in this regard.

    Thanks in advance..

    Regards,
    Santosh

  8. #8
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Does the user db2fenc1 exist on the system? If not, create one with UID 502.
    ---
    "It does not work" is not a valid problem statement.

  9. #9
    Join Date
    Jan 2014
    Posts
    20
    Hi,

    After creating the user db2fenc1 with UID 502 in the system, able to execute the procedures.

    Now I would like to know the relation between procedures executing and fence user.

    Also is there realtion between fence user and das user??

    Thanks for your support in resolving the issue.
    Regards,
    Santosh K

  10. #10
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

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