Db2 Commit
Posted: Wed Jul 25, 2007 11:55 am
Hi,
Iam using DB2 API stage to insert data in to an X table . Iam getting an Dead locking issue. I changed my transaction size to 2000 and the job is running fine Iam not facing any issues now, is there a way so that once I finished my work on X table that I can commit the work to free the X table .
Thanks,
SomaRaju.
Iam using DB2 API stage to insert data in to an X table . Iam getting an Dead locking issue. I changed my transaction size to 2000 and the job is running fine Iam not facing any issues now, is there a way so that once I finished my work on X table that I can commit the work to free the X table .
Thanks,
SomaRaju.