Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Load Replace and Load Resume

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
itmanand

New User


Joined: 18 Dec 2008
Posts: 24
Location: Newyork

PostPosted: Fri Dec 19, 2008 9:50 pm    Post subject: Load Replace and Load Resume
Reply with quote

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
View user's profile Send private message

shrinivasabharathi_b

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Sat Dec 20, 2008 3:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
shrinivasabharathi_b

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Sat Dec 20, 2008 3:32 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts resume binary ftp in z/os meykh2014 All Other Mainframe Topics 3 Sun Jan 22, 2017 10:01 am
No new posts Replace repeated JCL with looping REXX prino CLIST & REXX 3 Thu Oct 13, 2016 5:30 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. Sort card to replace text using cross... Susanta SYNCSORT 32 Tue Sep 13, 2016 4:17 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us