Well, well, well!
It's Deepti Batra! Hehe. How have you been?
There are a number of options that allow you to customize an import
operation. You can specify file type modifiers in the MODIFIED BY clause
to change the format of the data, tell the import utility what to do
with the data, and to improve performance.
The import utility, by default, does not perform commits until the end
of a successful import, except in the case of some ALLOW WRITE ACCESS
imports. This improves the speed of an import, but for the sake of
concurrency, restartability, and active log space considerations, it
might be preferable to specify that commits take place during the
import. One way of doing so is to set the COMMITCOUNT parameter to
"automatic," which instructs import to internally determine when it
should perform a commit. Alternatively, you can set COMMITCOUNT to a
specific number, which instructs import to perform a commit once that
specified number of records has been imported.
There are a few ways to improve import's performance. As the import
utility is an embedded SQL application and does SQL fetches internally,
optimizations that apply to SQL operations apply to import as well. You
can use the compound file type modifier to perform a specified number of
rows to insert at a time, rather than the default row-by-row insertion.
If you anticipate that a large number of warnings will be generated
(and, therefore, slow down the operation) during the import, you can
also specify the norowwarnings file type modifier to suppress warnings
about rejected rows.
It's Fridayyyyyyyy! Partyyyyyyyyyyy! Hehe.
Have a great Day and Weekend!
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: Deepti Batra
[mailto:db2udbdba-ezmlmshield-x39669250.[Email address protected]
Sent: Friday, May 25, 2007 8:20 AM
To: LazyDBA Discussion
Subject: IMPORT OF LOBs
I am facing problem of time in importing LOB columns in table .
Please suggest any ways to improve the speed of import of LOB objects
Thanks and Regards,
Deepti Batra,
46 New Broad Street,
Liverpool Street
London
deepti.[Email address protected]
Tel +44 (0) 20 754 56729
---
This e-mail may contain confidential and/or privileged information. If
you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
---------------------------------------------------------------------
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
DB2 & UDB email list listserv db2-l LazyDBA home page