 |
 |
Archives of the TeradataForum
Message Posted: Fri, 06 Aug 2004 @ 08:55:11 GMT
| Subj: | | Re: Session Blocking - Reasons and Work Arounds |
| |
| From: | | Kepinski, Marek |
Hi,
I just started working with Teradata so I'm not an experienced user but I also noticed that locking is quite a problem. I work with Teradata
stored procedures and I found out that if the procedure is called more than twice (at the same time), locks occur and Teradata is not able to
resolve them. I tried adding "locking" statement but finally I added "commit" statement after almost each SQL statement (because the processing
does not need to be transactional in thios case). This helped but the locks still occur from time to time.
I f anyone has an idea what else can be improved, let us know.
Marek
| |
