View previous topic :: View next topic
|
Author |
Message |
itmanand
New User
Joined: 18 Dec 2008 Posts: 24 Location: Newyork
|
|
|
|
I have the below syntax for Load Replace.
LOAD DATA REPLACE
LOG NO
INDDN SYSREC00
INTO TABLE ABC.XYZ.
Can some one tell me what is the significance of LOG NO?
Also if I already have 100 records in the table and I want to continue loading it, will the below command work?
LOAD DATA RESUME
LOG NO
INDDN SYSREC00
INTO TABLE ABC.XYZ. |
|
Back to top |
|
|
shrinivasabharathi_b
New User
Joined: 04 Nov 2008 Posts: 11 Location: Chennai
|
|
|
|
LOG - tells logging required during the reload phase,
and when you mention NO - no logging of records will happen during load process..
it sets copy pending restriction against the table space / partitions.. |
|
Back to top |
|
|
shrinivasabharathi_b
New User
Joined: 04 Nov 2008 Posts: 11 Location: Chennai
|
|
|
|
this might be useful for u .. I took it from DB2 util guide
RESUME
Tells whether records are to be loaded into an empty or non-empty table
space. For nonsegmented table spaces, space occupied by rows that have
been marked as deleted or by rows of dropped tables is not reused.
Attention: Specifying LOAD RESUME (rather than PART integer
RESUME) tells LOAD to drain the table space, which can inhibit concurrent
processing of separate partitions. If you want to process other partitions
concurrently, use “Into-table-spec” on page 176 to specify PART integer
RESUME.
NO
Loads records into an empty table space. If the table space is not
empty, and you have not used REPLACE, a message is issued and the
utility job step terminates with a job step condition code of 8.
For nonsegmented table spaces containing deleted rows or rows of
dropped tables, using the REPLACE keyword provides increased
efficiency.
The default is NO, unless you override it with PART integer RESUME
YES.
YES
Loads records into a non-empty table space. If the table space is
empty, a warning message is issued, but the table space is loaded.
Loading begins at the current end of data in the table space. Space
occupied by rows marked as deleted or by rows of dropped tables is
not reused. |
|
Back to top |
|
|
|