03-03-2008
db2 - copy data from one db to another
I need to take data from one database to another on the same machine.
My first attempt has been using restore, but I am getting an error.
Here is the command I am trying:
db2 restore database prod into test
I get the following error:
The container is already in use.
What would be the best way to move data from one database to
another on the same machine? Are there other utilities that would work
better? DB2 version 8.1.1.56 fixpack 6. thank you.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
We keep getting production files into an input directory.
These files will be processed three times a day.
8:00AM
1:30PM
5:30PM
file1.20041005_05303423.dat
File2.200041005_14232313.dat
Once the files are processed, they are archived immediately to prod/archive directory
... (1 Reply)
Discussion started by: zomboo
1 Replies
2. Shell Programming and Scripting
Hi,
Good Morning everybody.
I need to write a perl script which will get some data from DB2 table and then put it into Sybase table. I have the experience in Oracle and Unix but new to these perl, DB2 and Sybase technologies.
Appreciate if any one can suggest with a sample code.
Thanks... (1 Reply)
Discussion started by: rajus19
1 Replies
3. UNIX for Dummies Questions & Answers
I have an Ingres database logfile that grows constantly, iircp.log. It is always "attached" to the Ingres process that uses it, and I do not want to screw up the data. I have been copying it to another directory and then using vi on the original to reduce the size 34000 lines at a time. What I want... (1 Reply)
Discussion started by: sarge
1 Replies
4. UNIX for Dummies Questions & Answers
Hi...
I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
5. Shell Programming and Scripting
Hi everyone!!
I need help regarding this.
How can we load data from DB2 Database tables into a Comma Separated File?
I also have another Question? Using Shell scripting, Is it easy to read Data from a table or from a text file?
It is very urgent for me. Please help me out guys.
... (1 Reply)
Discussion started by: ss3944
1 Replies
6. Shell Programming and Scripting
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies
7. AIX
The main function is to extract the data from DB2 tables and FTPed to outside the company's firewall directly.
pls find the attachment and help me out..i have only one day to do this (1 Reply)
Discussion started by: priyanka3006
1 Replies
8. AIX
Please help me in creating the script in AIX.
requirement is;
The new component's main function is to extract the data from DB2 tables and company's firewall directly.
The component function needs to check the timestamp in the DB2 tables ((CREDAT and CRETIM) with the requested timestamp and... (1 Reply)
Discussion started by: priyanka3006
1 Replies
9. Solaris
Hi All,
We are not able to grow a UFS filesystem since its size will be going over a TB and it wasn't created using -T with newfs.
Hence we have decided to take the backup of all the files on another filesystem and recreate it using -T with newfs.
Please recommend the most reliable... (2 Replies)
Discussion started by: vishalaswani
2 Replies
10. Shell Programming and Scripting
I need to copy from specified lines and paste the data into several other lines.
XX123450008 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
XX123451895 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
......
XX123452012 xx.x xx.x xx.x xx.x xx.x xx.x xx.x... (13 Replies)
Discussion started by: ncwxpanther
13 Replies
LEARN ABOUT DEBIAN
bos_removehost
BOS_REMOVEHOST(8) AFS Command Reference BOS_REMOVEHOST(8)
NAME
bos_removehost - Removes a database server machine from the CellServDB file
SYNOPSIS
bos removehost -server <machine name> -host <host name>+
[-cell <cell name>] [-noauth] [-localauth] [-help]
bos removeh -s <machine name> -ho <host name>+
[-c <cell name>] [-n] [-l] [-he]
DESCRIPTION
The bos removehost command removes the entry for each database server machine specified with the -host argument from the
/etc/openafs/server/CellServDB file on the server machine named by the -server argument.
CAUTIONS
After executing this command (and waiting for the Update Server to propagate the changes, if it is used), restart the database server
processes on all database server machines to force election of a quorum that includes the new set of machines listed in the
/etc/openafs/server/CellServDB file. The OpenAFS Quick Start Guide explains in more detail how to add and remove database server machines.
OPTIONS
-server <machine name>
Indicates the server machine on which to change the /etc/openafs/server/CellServDB file. Identify the machine by IP address or its host
name (either fully-qualified or abbreviated unambiguously). For details, see bos(8).
In cells that use the Update Server to distribute the contents of the /etc/openafs/server directory, it is conventional to specify only
the system control machine as a value for the -server argument. Otherwise, repeat the command for each file server machine. For further
discussion, see bos(8).
-host <host name>+
Specifies the fully-qualified host name (such as "fs2.abc.com") of each database server machine to remove from the CellServDB file.
-cell <cell name>
Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see bos(8).
-noauth
Assigns the unprivileged identity "anonymous" to the issuer. Do not combine this flag with the -localauth flag. For more details, see
bos(8).
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The bos command interpreter presents the ticket
to the BOS Server during mutual authentication. Do not combine this flag with the -cell or -noauth options. For more details, see
bos(8).
-help
Prints the online help for this command. All other valid options are ignored.
EXAMPLES
The following command removes the former database server machine "db2.abc.com" from the CellServDB file on the system control machine
"fs1.abc.com".
% bos removehost -server fs1.abc.com -host db2.abc.com
PRIVILEGE REQUIRED
The issuer must be listed in the /etc/openafs/server/UserList file on the machine named by the -server argument, or must be logged onto a
server machine as the local superuser "root" if the -localauth flag is included.
SEE ALSO
KeyFile(5), UserList(5), bos(8), bos_addhost(8), bos_listhosts(8)
The OpenAFS Quick Start Guide at <http://docs.openafs.org/QuickStartUnix/>.
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BOS_REMOVEHOST(8)