Professional Web Applications Themes

Stored Procedure Builing Problems - IBM DB2

Hi, We were able to build stored procedures without any problems till now. Now while building procedures, we are getting the following errors ------------------------------------------ Create stored procedure returns -7032. [IBM][CLI Driver][DB2/6000] SQL7032N SQL procedure "TESTMD5_1" not created. Diagnostic file is "P7374587.log". SQLSTATE=42904 Changes rolled back. Build failed. ------------------------------------------- LOG FILE P7374587.log Details -- LOG FILE P7374587.log FOR PROCEDURE HDNRA00 .TESTMD5_1 -- DB2_SQLROUTINE_PREPOPTS= -- PREP/BIND MESSAGES FOR /opt/db2/ol1t//sqllib/function/routine/sqlproc/DRMTST02/HDNRA00/tmp/P7374587.sqc -- PREP/BIND ERROR CODES: 0 -1 LINE MESSAGES FOR P7374587.sqc ------ -------------------------------------------------------------------- SQL0060W The "C" precompiler is in progress. SQL1024N A database connection does not exist. SQLSTATE=08003 SQL0095N No bind file was created ...

  1. #1

    Default Stored Procedure Builing Problems

    Hi,

    We were able to build stored procedures without any problems till now.
    Now while building procedures, we are getting the following errors
    ------------------------------------------
    Create stored procedure returns -7032.

    [IBM][CLI Driver][DB2/6000] SQL7032N SQL procedure "TESTMD5_1" not
    created. Diagnostic file is "P7374587.log". SQLSTATE=42904

    Changes rolled back.

    Build failed.
    -------------------------------------------

    LOG FILE P7374587.log Details

    -- LOG FILE P7374587.log FOR PROCEDURE HDNRA00 .TESTMD5_1

    -- DB2_SQLROUTINE_PREPOPTS=

    -- PREP/BIND MESSAGES FOR
    /opt/db2/ol1t//sqllib/function/routine/sqlproc/DRMTST02/HDNRA00/tmp/P7374587.sqc
    -- PREP/BIND ERROR CODES: 0 -1

    LINE MESSAGES FOR P7374587.sqc
    ------ --------------------------------------------------------------------
    SQL0060W The "C" precompiler is in progress.
    SQL1024N A database connection does not exist.
    SQLSTATE=08003
    SQL0095N No bind file was created because of previous
    errors.
    SQL0092N No package was created because of previous
    errors.
    SQL0091W Precompilation or binding was ended with "3"
    errors and "0" warnings.

    -- END OF LOG FILE (SQLCODE: -1)



    --------------------------------------
    A look in db2diag.log gives the following info


    2003-10-22-07.37.45.720585 Instance:ol1t Node:000
    PID:917658(db2agent (DRMTST02) 0) TID:1
    Appid:AA687DBF.0B17.031022143733
    oper system services sqloopenp Probe:20 Database:DRMTST02

    errno:
    0x2FF147A0 : 0x0000001A ....

    PID:917658 TID:1 Node:000 Title: Path/Filename
    /opt/db2/ol1t//sqllib/function/routine/sqlproc/DRMTST02/HDNRA00/P8221804

    2003-10-22-07.37.45.843184 Instance:ol1t Node:000
    PID:917658(db2agent (DRMTST02) 0) TID:1
    Appid:AA687DBF.0B17.031022143733
    oper system services sqloopenp Probe:20 Database:DRMTST02

    errno:
    0x2FF14C30 : 0x0000001A ....

    PID:917658 TID:1 Node:000 Title: Path/Filename
    /opt/db2/ol1t//sqllib/function/routine/sqlproc/DRMTST02/HDNRA00/P8221804

    2003-10-22-07.37.45.955346 Instance:ol1t Node:000
    PID:917658(db2agent (DRMTST02) 0) TID:1
    Appid:AA687DBF.0B17.031022143733
    relation data serv sqlrr_fetch Probe:10 Database:DRMTST02

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0x80120086".

    2003-10-22-07.37.45.960077 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    DRDA Application Requester sqljrReportServerErrReply Probe:20

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0x80370086".

    PID:696432 TID:1 Node:000 Title: SQLCA
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 7
    sqlerrmc: 0x1245
    sqlerrp : sqljrerm€7
    sqlerrd : (1) 0x80370086 (2) 0x00000086 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    PID:696432 TID:1 Node:000 Title: **** DRDA ARCB ****
    Dump File:/opt/db2/ol1t//sqllib/db2dump/6964321.000

    PID:696432 TID:1 Node:000 Title: **** AR REQUEST LIST ****
    Dump File:/opt/db2/ol1t//sqllib/db2dump/6964321.000

    PID:696432 TID:1 Node:000 Title: **** DRDA CMNMGR CB ****
    Dump File:/opt/db2/ol1t//sqllib/db2dump/6964321.000

    PID:696432 TID:1 Node:000 Title: **** RECEIVE BUFFER ****
    Dump File:/opt/db2/ol1t//sqllib/db2dump/6964321.000

    PID:696432 TID:1 Node:000 Title: **** SEND BUFFERS ****
    Dump File:/opt/db2/ol1t//sqllib/db2dump/6964321.000

    PID:696432 TID:1 Node:000 Title: **** AR UCINTERFACE ****
    Dump File:/opt/db2/ol1t//sqllib/db2dump/6964321.000

    2003-10-22-07.37.46.020702 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    base sys utilities sqleGetSQLError Probe:10

    SQL Error:

    0x2FF21768 : 5B49 424D 5D5B 434C 4920 4472 6976 6572 [IBM][CLI
    Driver
    0x2FF21778 : 5D20 5351 4C33 3030 3230 4E20 2045 7865 ] SQL30020N
    Exe
    0x2FF21788 : 6375 7469 6F6E 2066 6169 6C65 6420 6265 cution failed
    be
    0x2FF21798 : 6361 7573 6520 6F66 2061 2044 6973 7472 cause of a
    Distr
    0x2FF217A8 : 6962 7574 6564 2050 726F 746F 636F 6C20 ibuted
    Protocol
    0x2FF217B8 : 4572 726F 7220 7468 6174 2077 696C 6C20 Error that
    will
    0x2FF217C8 : 6166 6665 6374 2074 6865 2073 7563 6365 affect the
    succe
    0x2FF217D8 : 7373 6675 6C20 6578 6563 7574 696F 6E20 ssful
    execution
    0x2FF217E8 : 6F66 2073 7562 7365 7175 656E 7420 636F of subsequent
    co
    0x2FF217F8 : 6D6D 616E 6473 2061 6E64 2053 514C 2073 mmands and SQL
    s
    0x2FF21808 : 7461 7465 6D65 6E74 733A 2020 5265 6173 tatements:
    Reas
    0x2FF21818 : 6F6E 2043 6F64 6520 2230 7831 3234 3522 on Code
    "0x1245"
    0x2FF21828 : 2E20 2053 514C 5354 4154 453D 3538 3030 .
    SQLSTATE=5800
    0x2FF21838 : 390A 9.

    2003-10-22-07.37.46.049245 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    base sys utilities sqlePrepareDebugger Probe:100

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFF8ABC".

    2003-10-22-07.37.46.050576 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    routine_infrastructure sqlerFmpListener Probe:500

    DIA8004C A cursor is still active, file token "".
    ZRC=0x00000004

    2003-10-22-07.37.46.056573 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    oper system services sqloSetFileAccessMode Probe:100

    errno:
    0x2FF18690 : 0x00000002 ....

    PID:696432 TID:1 Node:000 Title: Path/Filename
    /opt/db2/ol1t//sqllib/function/routine/sqlproc/DRMTST02/HDNRA00/tmp/P7374587.bnd

    2003-10-22-07.37.46.061819 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    oper system services sqloSetFileAccessMode Probe:100

    errno:
    0x2FF18690 : 0x00000002 ....

    PID:696432 TID:1 Node:000 Title: Path/Filename
    /opt/db2/ol1t//sqllib/function/routine/sqlproc/DRMTST02/HDNRA00/tmp/P7374587.c

    2003-10-22-07.37.46.083169 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    oper system services sqloxltc_app Probe:15

    Unexpected system error 0x16 has occurred.
    This has been mapped to ZRC 0x83000016.

    PID:696432 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
    A system call received a parameter that is not valid.

    2003-10-22-07.37.46.088186 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    base sys utilities sqleAttachCtx Probe:40

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0x83000016".

    2003-10-22-07.37.46.089428 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    Connection Manager sqleUCAnchorSTPDbHandle Probe:1

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0x8005006D".

    2003-10-22-07.37.46.090615 Instance:ol1t Node:000
    PID:696432(db2fmp (917658) 0) TID:1 Appid:none
    routine_infrastructure sqlerFmpListener Probe:210

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFFFB95".

    2003-10-22-07.37.47.134000 Instance:ol1t Node:000
    PID:917658(db2agent (DRMTST02) 0) TID:1
    Appid:AA687DBF.0B17.031022143733
    oper system services sqloopenp Probe:20 Database:DRMTST02

    errno:
    0x2FF17DB0 : 0x0000001A ....

    PID:917658 TID:1 Node:000 Title: Path/Filename
    /opt/db2/ol1t//sqllib/function/routine/sqlproc/DRMTST02/HDNRA00/P8221804

    2003-10-22-07.37.47.140960 Instance:ol1t Node:000
    PID:917658(db2agent (DRMTST02) 0) TID:1
    Appid:AA687DBF.0B17.031022143733
    oper system services sqloclose Probe:110 Database:DRMTST02

    errno:
    0x2FF181E0 : 0x00000009 ....

    --------------------------------------------------------------------------

    Can anyone please help us in resolving this.

    Thanks in advance

    Narayan
    Narayan Guest

  2. #2

    Default Re: Stored Procedure Builing Problems

    "Narayan Appachar" <or.us> wrote in message
    news:google.com... 

    When you get an internal error(s), it needs to be reported to IBM support
    for resolution..


    Mark Guest

  3. #3

    Default Re: Stored Procedure Builing Problems

    You are not using an os390 client or something, are you? Also, try to
    turn routine debug off (it's a db2set parameter).

    Narayan Appachar wrote: 

    W Guest

Similar Threads

  1. problems executing wscript_command stored procedure
    By MShaneW in forum Coldfusion Database Access
    Replies: 1
    Last Post: June 14th, 04:31 PM
  2. Using a stored procedure
    By MarkWright in forum Coldfusion Database Access
    Replies: 13
    Last Post: April 15th, 05:53 PM
  3. Problems with Oracle Stored Function (Procedure)
    By Rob@PSA in forum Coldfusion Database Access
    Replies: 11
    Last Post: March 18th, 01:20 AM
  4. Stored procedure
    By Uri in forum Microsoft SQL / MS SQL Server
    Replies: 13
    Last Post: August 19th, 03:23 PM
  5. need help on a stored procedure
    By Helixpoint in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 8th, 01:26 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139