AW: Table locked - pending commit

If the user is working under commitment control, commit or rollback must
always be executed after the change.
If the user will end the job without executing commit a rollback will be
preformed and the changes will be reset.
Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Åke Olsson
Gesendet: Tuesday, 24. November 2009 08:42
An: midrange-l@xxxxxxxxxxxx
Betreff: Table locked - pending commit

We experienced the following situation on one system:



A user logged in and did an alter table.



After this the table was locked - completely. Could not be accessed by sql,
dsppfm or any other command.



For a DSPPFM I get a CPF4326 "Commitment definition" {blank space} "not
valid for open of TBL_PM"



The commitment identifier is listed as X'00000000000000000000'





I was unable to find any pending operations using the WRKCMTDFN ("Work with
commitment definitions") command. Otherwise I would have tried a forced
commit using that one.





Any ideas on how to solve a situation like this?





Med vänlig hälsning / Best regards


Åke H Olsson



Box 433 SE 551 16 Jönköping Sweden visit: Brunnsgatan 11

phone: +46 (0)36 342976 mobile: +46 (0)705 482976 fax: +46 (0)36 34 29 29

ake.olsson@xxxxxx <mailto:ake.olsson@xxxxxx> www.pdb.se





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal.