Transferring files from PC to AIX-DB2

[meetalps]

Hi All,
Can you please help me with a step by step procedure to transfer files
from my PC to DB2-AIX and vice versa. I am new to both.
Example transferring a sql file to run from PC to DB2 on AIX.
PC-OS windows
DB2 on AIX platform.

Thanks.

[Larry]

There is no way to transfer an "SQL file" because databases are not files.

You have at least three options that I can think of if you are trying to
move or copy data between platforms (others may contribute more
options). Each option has its own process so you're going to have to
read up on them to get the process:

1. Replication using Data Propagator
2. Export (or using db2move if you want to move the definitions also).
3. High-Performance Unload

Larry E.

meetalps wrote:

Hi All,
Can you please help me with a step by step procedure to transfer files
from my PC to DB2-AIX and vice versa. I am new to both.
Example transferring a sql file to run from PC to DB2 on AIX.
PC-OS windows
DB2 on AIX platform.

Thanks.

[graham_martin]

To explain......

1) DDL language (create table, alter table, drop view, etc.) is
universal for DB2, be it windows, AIX, etc.
2) DML langauge (select, update, insert, delete) is also universal
3) DCL language (grant connect, etc) is also universal
4) Data transfer, using IXF and CSV is also universal

What you cannot do Windows <-AIX, is restore a database from one
platform to another.

There are subtle limitations, all documented in the DB2 Infocentre
(e.g. Windows and AIX have different directory structures, so creating
a tablespace would require using different container names).

All one big happy family at the end of the day :-)

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Larry wrote:

There is no way to transfer an "SQL file" because databases are not files.

You have at least three options that I can think of if you are trying to
move or copy data between platforms (others may contribute more
options). Each option has its own process so you're going to have to
read up on them to get the process:

1. Replication using Data Propagator
2. Export (or using db2move if you want to move the definitions also).
3. High-Performance Unload

Larry E.

meetalps wrote:

Hi All,
Can you please help me with a step by step procedure to transfer files
from my PC to DB2-AIX and vice versa. I am new to both.
Example transferring a sql file to run from PC to DB2 on AIX.
PC-OS windows
DB2 on AIX platform.

Thanks.

[meetalps]

Thanks guys,
Let me be more specific..
The database is on a server connected using putty/telnet from my laptop
running on windows xp pro. And that DB2 is installed on AIX platform.
If I have a abc.sql file provided by ETL group which performs some
insert,update,d elete operation mailed to me and saved in my documents.
How do I transfer it to my putty session where I am logged in to the
database running on AIX.

Thanks.

graham_martin wrote:

To explain......

1) DDL language (create table, alter table, drop view, etc.) is
universal for DB2, be it windows, AIX, etc.
2) DML langauge (select, update, insert, delete) is also universal
3) DCL language (grant connect, etc) is also universal
4) Data transfer, using IXF and CSV is also universal

What you cannot do Windows <-AIX, is restore a database from one
platform to another.

There are subtle limitations, all documented in the DB2 Infocentre
(e.g. Windows and AIX have different directory structures, so creating
a tablespace would require using different container names).

All one big happy family at the end of the day :-)

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Larry wrote:

There is no way to transfer an "SQL file" because databases are not files.

You have at least three options that I can think of if you are trying to
move or copy data between platforms (others may contribute more
options). Each option has its own process so you're going to have to
read up on them to get the process:

1. Replication using Data Propagator
2. Export (or using db2move if you want to move the definitions also).
3. High-Performance Unload

Larry E.

meetalps wrote:

Hi All,
Can you please help me with a step by step procedure to transfer files
from my PC to DB2-AIX and vice versa. I am new to both.
Example transferring a sql file to run from PC to DB2 on AIX.
PC-OS windows
DB2 on AIX platform.
>
Thanks.
>

[lennart]

meetalps wrote:

Thanks guys,
Let me be more specific..
The database is on a server connected using putty/telnet from my laptop
running on windows xp pro. And that DB2 is installed on AIX platform.
If I have a abc.sql file provided by ETL group which performs some
insert,update,d elete operation mailed to me and saved in my documents.
How do I transfer it to my putty session where I am logged in to the
database running on AIX.

I think you will need another program to transfer the files. In the
putty family there is also a program called pscp.exe. It's an scp clone
for windows. Download that, open a doswindow and run:

<path to pscp.exe>\pscp. exe <my_sql_file<my _user>@<myhost> :<path>/

Example:

c:\myprogs\pcsp .exe my_file.sql db2inst1@aix_ho st:/tmp/

You might have to transform the file to unixfomat. I'm not familiar
with AIX so I dont know if dos2unix is included. In worst case you can
do the newline substitution with sed

HTH

/Lennart

[mcteard]

2 more options.
1. Use ftp from a dos command window on your pc.
2. Install Samba on your AIX box which will allow you to map an AIX
file system as a network drive on your pc.

le*****@kommuni cera.umea.se wrote:

meetalps wrote:

Thanks guys,
Let me be more specific..
The database is on a server connected using putty/telnet from my laptop
running on windows xp pro. And that DB2 is installed on AIX platform.
If I have a abc.sql file provided by ETL group which performs some
insert,update,d elete operation mailed to me and saved in my documents.
How do I transfer it to my putty session where I am logged in to the
database running on AIX.

I think you will need another program to transfer the files. In the
putty family there is also a program called pscp.exe. It's an scp clone
for windows. Download that, open a doswindow and run:

<path to pscp.exe>\pscp. exe <my_sql_file<my _user>@<myhost> :<path>/

Example:

c:\myprogs\pcsp .exe my_file.sql db2inst1@aix_ho st:/tmp/

You might have to transform the file to unixfomat. I'm not familiar
with AIX so I dont know if dos2unix is included. In worst case you can
do the newline substitution with sed

HTH

/Lennart