MVSFORUMS.com

kingo1984 · Beginner Joined: 24 Jan 2007 Posts: 1 Topics: 1

Hi,
I liked to know or can anyone explain me why we use LOG NO or YES
in the LOAD utility.

hareshh · Beginner Joined: 13 Dec 2006 Posts: 16 Topics: 0

Hi kingo1984,

Please check link:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnugh13/2.12.2.4.10?SHELF=&DT=20020826194002&CASE=

Regards,
Haresh

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

Besides LOBs, you have to answer the question: Do I want to be able to recover this tablespace which DB2 utilities?

If yes, you have to use LOG YES in the Load statement and pay an extra CPU/IO price for that, or you use LOG NO and start an imagecopy utility directly after the load or use the implicit imagecopy capability of the load utility.

If no, you have to be able to build the table data from scratch.

regards
Christian

kingo · Posted: Wed Feb 07, 2007 6:05 am Post subject:

I have one more question so what does this LOG info contain?
For example
If i have run a LOAD utility to insert some 100000 recs does it contain LOG info of each and every record?

Thanks,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

kolusu · Posted: Wed Feb 07, 2007 6:30 am Post subject:

kingo,

LOG Tells whether logging is to occur during the RELOAD phase of the load process. YES Specifies normal logging during the load process. All records loaded are logged.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

kingo · Posted: Wed Feb 07, 2007 7:36 am Post subject:

Can we give LOG NO with both REPLACE and RESUME ?

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

kolusu · Posted: Wed Feb 07, 2007 8:52 am Post subject:

kingo · Posted: Wed Feb 07, 2007 9:20 am Post subject:

Thanks Kolusu Very Happy

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.