We are using DB2 8.1.4 Windows to do our DB2 stored procedure development. In Windows env, we can "Build for Debug" and debug any stored procedure without any problem.
Then we migrated the code to SIT environment which is DB2 8.1.4 AIX 5.2. For some reasons, we cannot debug the same stored procedures anymore even we re-build the stored procedure using "Build for Debug" option. When we click "Debug", the Development Center indicates Debug started, Calling the stored procedure and Debug completed without stopping.
Is there any environment setup/configuration that we shall do for the AIX in order for us to build the stored procedure with debug option?