Stored Procedure Builing Problems

**Mark A** · Nov 12 '05, 05:39 AM

Re: Stored Procedure Builing Problems

"Narayan Appachar" <narayan.appach ar@state.or.us> wrote in message
news:301a3f0c.0 310220647.1d615 3f2@posting.goo gle.com...[color=blue]
> Hi,
>
> We were able to build stored procedures without any problems till now.
> Now while building procedures, we are getting the following errors <snip>[/color]

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

**W Gemini** · Nov 12 '05, 05:39 AM

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:[color=blue]
> 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.l og". 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(db2a gent (DRMTST02) 0) TID:1
> Appid:AA687DBF. 0B17.0310221437 33
> oper system services sqloopenp Probe:20 Database:DRMTST 02
>
> 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(db2a gent (DRMTST02) 0) TID:1
> Appid:AA687DBF. 0B17.0310221437 33
> oper system services sqloopenp Probe:20 Database:DRMTST 02
>
> 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(db2a gent (DRMTST02) 0) TID:1
> Appid:AA687DBF. 0B17.0310221437 33
> relation data serv sqlrr_fetch Probe:10 Database:DRMTST 02
>
> 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(db2f mp (917658) 0) TID:1 Appid:none
> DRDA Application Requester sqljrReportServ erErrReply 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(db2f mp (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(db2f mp (917658) 0) TID:1 Appid:none
> base sys utilities sqlePrepareDebu gger 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(db2f mp (917658) 0) TID:1 Appid:none
> routine_infrast ructure sqlerFmpListene r 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(db2f mp (917658) 0) TID:1 Appid:none
> oper system services sqloSetFileAcce ssMode 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(db2f mp (917658) 0) TID:1 Appid:none
> oper system services sqloSetFileAcce ssMode 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(db2f mp (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(db2f mp (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(db2f mp (917658) 0) TID:1 Appid:none
> Connection Manager sqleUCAnchorSTP DbHandle 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(db2f mp (917658) 0) TID:1 Appid:none
> routine_infrast ructure sqlerFmpListene r 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(db2a gent (DRMTST02) 0) TID:1
> Appid:AA687DBF. 0B17.0310221437 33
> oper system services sqloopenp Probe:20 Database:DRMTST 02
>
> 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(db2a gent (DRMTST02) 0) TID:1
> Appid:AA687DBF. 0B17.0310221437 33
> oper system services sqloclose Probe:110 Database:DRMTST 02
>
> errno:
> 0x2FF181E0 : 0x00000009 ....
>
> --------------------------------------------------------------------------
>
> Can anyone please help us in resolving this.
>
> Thanks in advance
>
> Narayan[/color]

**Narayan Appachar** · Nov 12 '05, 05:41 AM

Re: Stored Procedure Builing Problems

We have UDB Version 8.1 on AIX 5.2. Also tried with debug off. Still
the same error.

W Gemini <wgemini@nowher e.com> wrote in message news:<2FPlb.249 675$ko%.93966@n ews04.bloor.is. net.cable.roger s.com>...[color=blue]
> 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:[color=green]
> > 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.l og". 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(db2a gent (DRMTST02) 0) TID:1
> > Appid:AA687DBF. 0B17.0310221437 33
> > oper system services sqloopenp Probe:20 Database:DRMTST 02
> >
> > 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(db2a gent (DRMTST02) 0) TID:1
> > Appid:AA687DBF. 0B17.0310221437 33
> > oper system services sqloopenp Probe:20 Database:DRMTST 02
> >
> > 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(db2a gent (DRMTST02) 0) TID:1
> > Appid:AA687DBF. 0B17.0310221437 33
> > relation data serv sqlrr_fetch Probe:10 Database:DRMTST 02
> >
> > 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(db2f mp (917658) 0) TID:1 Appid:none
> > DRDA Application Requester sqljrReportServ erErrReply 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(db2f mp (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(db2f mp (917658) 0) TID:1 Appid:none
> > base sys utilities sqlePrepareDebu gger 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(db2f mp (917658) 0) TID:1 Appid:none
> > routine_infrast ructure sqlerFmpListene r 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(db2f mp (917658) 0) TID:1 Appid:none
> > oper system services sqloSetFileAcce ssMode 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(db2f mp (917658) 0) TID:1 Appid:none
> > oper system services sqloSetFileAcce ssMode 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(db2f mp (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(db2f mp (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(db2f mp (917658) 0) TID:1 Appid:none
> > Connection Manager sqleUCAnchorSTP DbHandle 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(db2f mp (917658) 0) TID:1 Appid:none
> > routine_infrast ructure sqlerFmpListene r 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(db2a gent (DRMTST02) 0) TID:1
> > Appid:AA687DBF. 0B17.0310221437 33
> > oper system services sqloopenp Probe:20 Database:DRMTST 02
> >
> > 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(db2a gent (DRMTST02) 0) TID:1
> > Appid:AA687DBF. 0B17.0310221437 33
> > oper system services sqloclose Probe:110 Database:DRMTST 02
> >
> > errno:
> > 0x2FF181E0 : 0x00000009 ....
> >
> > --------------------------------------------------------------------------
> >
> > Can anyone please help us in resolving this.
> >
> > Thanks in advance
> >
> > Narayan[/color][/color]

Stored Procedure Builing Problems

Stored Procedure Builing Problems

Comment

Comment

Comment