473,782 Members | 2,437 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to "LOAD COPY NO" without backup ?

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" ?
Nov 13 '08 #1
2 4519
On Nov 13, 6:11 pm, mvsmsh <mvs...@gmail.c omwrote:
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
Nov 14 '08 #2
>
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 ?

Nov 14 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1653
by: Jan Suchanek | last post by:
Hello, I am using "load" to get the table data from another database into a DB2 database. This works quite well (before that I used "import" which is, as it commits each "line", very slow). The problem I have now is that when I insert some data into one table a table which stores forgein keys from the first table has no data yet - so the table loses its "integrity". So I have to run "set integrity" for each table (and in the right...
27
2300
by: Shagy | last post by:
Greetings, I've been trying to find an equivant c funtion to the c++ copy function. Description: copy(char *cstring, size_t count, size_t offset); Copies "count" characters from a C-style string starting at offset.
2
1996
by: thorax | last post by:
I'm having problems running a release build of an application. The application is a native C++ .NET 2003 MFC application which links to a number of other DLLs, one of which is mixed (SLGSE.dll) (VB.NET/C++). Most of the DLLS are statically linked to the main exe (directly or indirectly) but a few are dynamically linked at runtime. When I try and run the app, it gets "An unhandled non- continuable exception was thrown during process...
1
1299
by: Dominique Vandensteen | last post by:
I want to dynamicly load a type (typename is defined in the database). This type is located in the exe itself or one of the dll's in the directory with the exe file. When creating an instance directly it works, when using reflection none of the dll's is "scanned". I used following code to work around this problem. Now I just want to know if this is the/a good way to do it, or should I use another system.
3
2754
by: nsh | last post by:
mailing.database.mysql, comp.lang.php subject: does "LOAD DATA" EVER work?!? I've tried EVERYTHING! version info: my isp is running my web page on a linux box with php ver. 4.4.1 according to phpinfo, the "mysql api client is ver. 4.0.25" - I have no idea how this relates, if at all, to the mysql engine's version. background:
1
1384
by: sck10 | last post by:
Hello I am using Visual Web Developer 2005 Express. Whenever I use the "copy web site" function, it creates a "publishform" button on my task bar that doesn't go away. So if I publish 3 different times, it creates 3 "publishform" buttons. Do I need to re-install the application? -- Thanks in advance,
3
2207
by: savvy | last post by:
I'm using "Visual Studio 2005 Professional". I'm half way through in my project development. I've created a New Website in the Visual Studio 2005 and developing my project over there. When i wanted to test my current project on the main production server its giving an error saying "Could not load collection5". the page directive of the .aspx file is <%@ Page Language="C#" MasterPageFile="~/home.master" AutoEventWireup="true"...
2
4981
by: Hexman | last post by:
Hello All, I receive many files with similar content each day. All I want to do is copy them into one file, then I'll use that file for my processes. Using vb2005. I've tried: Shell("copy c:\CND\dr*.txt C:\CND\TestC.txx") That comes back with "File not found". There are files there! Tried:
3
1976
by: Jess | last post by:
Hello, The C++ reference says the return result of "copy" is an output iterator. I'm wondering how I can assign the returned iterator to some other iterator. I tried int main(){ string s("abcdefg"); vector<charv; vector<char>::iterator k = copy(s.begin(),s.end(),back_inserter(v));
0
9639
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10311
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10080
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9942
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6733
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5378
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5509
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4043
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3639
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.