Concurrent request to the Teradata server

[RohitJaggi]

We have a stored procedure that creates a user given the username and other attributes. We invoked it concurrently from an application to create 44 users. Only 14 users were created and following error was seen.

[NCR][ODBC Teradata Driver][Teradata RDBMS] sp_add_proc:Concurrent change conflict
on database -- try again. ."
(sp_add_proc is the procedure name)

The Teradata documentation lists the following description for the error

Concurrent change conflict on database --
try again.
Explanation: During processing of the user’s transaction,
another user changed the database.
Generated By: ITB, RES, GEN and OPT modules.
For Whom: End User.
Remedy: Resubmit the transaction


How to find the maximum number of concurrent changes that the database server can handle? Is there a way to increase/decrease this number?

Thanks,
Rohit

 

[tdatgod]

Hi,
What version of Teradata are you running?

 

[tdatgod]

Hi,
Sorry ignore that question. Obviously you are running 4.1.x or you wouldn't be able to do the create user.

Create user as an operation decrements Database Space from the creating user.

Therefore it is possible that if you have 48 people all trying to do create user at the same time from the same account that they are colliding on database space updates.

Are you using dynamic SQL to create and execute the create user?


Have you considered opening a Help ticket with the GSC. We have seen issues with concurrency and DROP user, but I thought we had taken care of most of the issues with CREATE user.

---

 

[RohitJaggi]

Hi,

1. Yes, the version is 4.1.x.
2. Yes, the dynamic SQLs are used to create and execute the create user.
3. How do I open a Help ticket with the GSC?

 

[tdatgod]

Hi,
Contact your local NCR account team. If you don't know who that is you can always logon to

http://www.teradata.com

and click on

Contact

on the top of the web page. It will step you through some questions and someone should contact you.