• No replies
17917 Posts

Pinned topic Debug Stored Procedure on DB2 10.1 from Data Studio 3.1.1 problem

‏2012-11-28T08:50:32Z |
Debugging stored procedure on DB2 v 10.1 ( recently migrated from 9.7) ends up with error "Cannot ping the session manager". I'm guessing that there is no running session manager on DB2 server. I have selected second option "use the session manager on each connected server" in Data Studio preferences "Run/Debug - Routine debuger - IBM",
this trick helped with v9.7 ( this version of DB2 runs by default session manager )

There is way to run locally session manager described here :
Debugging stored procedures in DB2 z/OS with Optim Development Studio, Part 1: Use the Unified Debugger in a sample scenario

Question in short is:
How to run session manager on DB2 LUW 10.1 server ( on standard port 4553), thus enable debugging of stored procedures ?