while executing the program (DB2-BMP) through XPEDITER i got one problem regarding the PSB. The PSB That i was using for testing get locked because while executing the program i got one error ( load module of some subroutine was not found) when i again tried to execute the program... PSB get locked.
so please suggest me the solution to unlock that PSB.
Joined: 07 Nov 2005 Posts: 1105 Location: The Netherlands at Hole 19
TS didn't react for some time now so I think his problem is solved. Might be his transaction aborted causing the program and transaction to be stopped. So I don't think his PSB was locked but after aborting someone seems to have failed starting program and transaction again. I suggest we leave this topic till TS gets back to us.
Guess..it is PSB LOCKED not STOPPED if it is STOPPED we can use the above commands.Please contact your DBA to unlock it ,it is using the command /UNLOCK <psb or pgm name>,generally we don't have the privilege.