Using "UPDATE COMMAND OPTIONS Command" to set "Auto-commit SQL
statements".
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.
ibm.db2.udb.doc/core/r0001975.htm
-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x36277660.[Email address protected]
Sent: Monday, April 23, 2007 10:49 AM
To: LazyDBA Discussion
Subject: RE: Need Help
What about using "commits" after every 1000 records or whatever number
that works for you?
Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: sbhavsar
[mailto:db2udbdba-ezmlmshield-x71731623.[Email address protected]
Sent: Monday, April 23, 2007 10:47 AM
To: LazyDBA Discussion
Subject: Need Help
Hi,
I have history table very big.
I would like to update @60,000 row.
When JOB is batch running it timed out.
If I ran with 1000 transaction with updates, It's fine.
What I need to do?
......Shilpa
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
DB2 & UDB email list listserv db2-l LazyDBA home page