Prev: Getting rid of kuddb2
Next: How do I concatenate strings from a column into a single row in DB2
From: mvsmsh on 13 Nov 2008 18:11
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" ?
From: kschlamb on 13 Nov 2008 20:07
On Nov 13, 6:11 pm, mvsmsh <mvs...(a)gmail.com> wrote:
> 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/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0004587.htm

Kelly
From: mvsmsh on 13 Nov 2008 20:36
>
> 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/infocenter/db2luw/v8/index.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 ?

 | 
Pages: 1
Prev: Getting rid of kuddb2
Next: How do I concatenate strings from a column into a single row in DB2