Connecting Tech Pros Worldwide Forums | Help | Site Map

How to "LOAD COPY NO" without backup ?

mvsmsh
Guest
 
Posts: n/a
#1: Nov 13 '08
Hi ,
How can I load without copy in UDB V8/AIX , I don't want copy or
backup after load.

Are there any command in UDB , like Z/OS DB2 "repair tablespace
nocopypend" ?

kschlamb@ca.ibm.com
Guest
 
Posts: n/a
#2: Nov 14 '08

re: How to "LOAD COPY NO" without backup ?


On Nov 13, 6:11 pm, mvsmsh <mvs...@gmail.comwrote:
Quote:
Hi ,
How can I load without copy in UDB V8/AIX , I don't want copy or
backup after load.
>
Are there any command in UDB , like Z/OS DB2 "repair tablespace
nocopypend" ?
Your only other option is to specify NONRECOVERABLE. What this means
is that if you have to restore and rollforward through the load
operation, that the table will be marked as "invalid" and you can't
access it (only drop it).

See here for details:

http://publib.boulder.ibm.com/infoce...n/c0004587.htm

Kelly
mvsmsh
Guest
 
Posts: n/a
#3: Nov 14 '08

re: How to "LOAD COPY NO" without backup ?


>
Quote:
Your only other option is to specify NONRECOVERABLE. *What this means
is that if you have to restore and rollforward through the load
operation, that the table will be marked as "invalid" and you can't
access it (only drop it).
>
See here for details:
>
*http://publib.boulder.ibm.com/infoce...x.jsp?topic=/c...
>
Kelly

Thanks Kelly.

The table loaded every night as new. No needs recovery from backup/
log .

Currently ,the load usees TSM as backup ,
but sometimes load fails due to TSM problem.
so, I want to separate DB2 LOAD from TSM to minimize failure.

How about " LOAD ... backup to /DEV/NULL "
instead of " LOAD ... backup no " ?

Are there any problem for using "/DEV/NULL" as load backup file
locations ?

Closed Thread