Troubleshooting of errors in DB2 Stored Procedure debugging

After the DB2 stored procedure is created, why is the debugging error? It doesn't matter. Next we will introduce you to a solution for debugging errors in the DB2 Stored Procedure for your reference.

Creates a DB2 Stored Procedure DB2ADMIN. test, the following error occurs during the build: but the entire hard disk is not found in the C: \ ProgramFiles \ SQLLIB \ function \ routine \ sqlproc \ SAMPLE \ ADMINISTRATOR \ tmp P2409650.log file)

DB2ADMIN. TEST-the stored procedure is created and the return value is-7032.

DB2ADMIN. TEST: [IBM] [CLI Driver] [DB2/NT] SQL7032N the SQL process "TEST" has not been created ". The diagnostic file is "P2409650.log ". SQLSTATE = 42904

DB2ADMIN. TEST-change rollback.

DB2ADMIN. TEST-build failed

Solution:

Install VC:
Set environment variables.
Open the ibm/sqllib/function/routine/sr_cpath.bat file.
Add the following command line:

 
 

  
  
set VCV6_DRIVE=c:\Program Files\Microsoft Visual Studio  
  
  
set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%VCV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\include  
  
  
set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib  
  
  
set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\li 
 
 

Deep understanding of DB2 stored procedures

DB2 connection Server Configuration

Learn about the DB2 lock types

Solution to db2 tablespace lock

SQL statement for creating tables in DB2 with Constraints