How to unlock the PSB

poul_motiram · New User Joined: 05 Dec 2006 Posts: 13 Location: chennai

Hi,

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.

Bitneuker · Posted: Tue Jan 09, 2007 6:49 pm

Sorry.......doesn't ring a bell

Nighthawk750 · New User Joined: 04 Nov 2006 Posts: 20 Location: Amsterdam

well......I hear a very small bell.....so I do not know if it is usefull

But can you tell us if you are running your program online or via batch?

kalukakkad · New User Joined: 10 Mar 2005 Posts: 81

go the IMS region and if you have access to execute commands, try
/START PGM psb-name

Devzee · Posted: Sat Jan 20, 2007 4:54 pm

How did you came to know that the PSB is locked?

Bitneuker · Posted: Mon Jan 22, 2007 2:39 pm

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.

Ravinderreddy-mekala · Posted: Sat Feb 03, 2007 1:02 pm

Hi

Please try below command. May help you.
1.
/START TRAN <PSB NAME OR TRANSACTION NAME> , If both are equal.

2.

/DIS A -- Then you can see the number across your login id, stop it by using STO command and automatically you will be comeout of XPEDITOR session.

Regards
Ravi

manishram1 · New User Joined: 23 Mar 2006 Posts: 34

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.

ranesach · New User Joined: 23 Jul 2009 Posts: 3 Location: India

where exactly we need to give this unlock/start command?

dick scherrer · Posted: Tue Nov 17, 2009 8:19 pm

Hello,

Please note that you have replied to a topic that has been inactive for almost 3 years (it is better to reply to active topics or start a new topic for your question).

These are just other commands (many of which may only be issued by a dba).

Suggest you talk with your dba and learn if this is something you have available and if so, how/when to do this. It is not something to do just because something is "stuck".