var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sp Build Problems
I am trying to set up SP ON AIX 5.1/ DB2 8.1.4
I created a stored procedure using the development center.We had recently installed C++ compiler on our server.I changed the profile.env file to include the following :
DB2_SQLROUTINE_COMPILE_COMMAND='xlC_r -+ -H512 -T512 -g -I/db2home/db2inst1/sqllib/include SQLROUTINE_FILENAME.c -bEQLROUTI
NE_FILENAME.exp -e SQLROUTINE_ENTRY -o SQLROUTINE_FILENAME -L/db2home/db2inst1/sqllib/lib -lc -ldb2 -q64'
when i click build from the dev center the SP gave the following result
DB2INST1.Draft - Build started.
Create stored procedure returns -7032.
[IBM][CLI Driver][DB2/AIX64] SQL7032N SQL procedure "DIV_2" not created. Diagnostic file is "P0270599.log". SQLSTATE=42904
DB2INST1.Draft - Build failed.
DB2INST1.Draft - Roll back failed.
In addition the build process sucked out all the memory on the system(8gig) and forced db2 instance to crash.Can you guys please help?