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 PHP
pdo_ibm-dsn
PDO_IBM-DSN(3) 1 PDO_IBM-DSN(3)
PDO_IBM DSN - Connecting to IBM databases
The PDO_IBM Data Source Name (DSN) is based on the IBM CLI DSN. The major components of the PDO_IBM DSN are:
o DSN prefix
- The DSN prefix is ibm:.
o DSN
- The DSN can be any of the following:
o a) Data source setup using
db2cli.ini or odbc.ini
o b) Catalogued database name i.e. database alias in the DB2 client catalog
o c) Complete connection string in the following format: DRIVER={IBM DB2 ODBC DRIVER};DATABASE=
database;HOSTNAME= hostname;PORT= port;PROTOCOL=TCPIP;UID= username;PWD= password; where the parameters represent the fol-
lowing values:
o $database
- The name of the database.
o $hostname
- The hostname or IP address of the database server.
o $port
- The TCP/IP port on which the database is listening for requests.
o $username
- The username with which you are connecting to the database.
o $password
- The password with which you are connecting to the database.
Example #1
PDO_IBM DSN example using db2cli.ini
The following example shows a PDO_IBM DSN for connecting to an DB2 database cataloged as DB2_9 in db2cli.ini:
$db = new PDO("ibm:DSN=DB2_9", "", "");
[DB2_9]
Database=testdb
Protocol=tcpip
Hostname=11.22.33.444
Servicename=56789
Example #2
PDO_IBM DSN example using a connection string
The following example shows a PDO_IBM DSN for connecting to an DB2 database named testdb using the DB2 CLI connection string syn-
tax.
$db = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=testdb;" .
"HOSTNAME=11.22.33.444;PORT=56789;PROTOCOL=TCPIP;", "testuser", "tespass");
PHP Documentation Group PDO_IBM-DSN(3)