DB2 data to be directly downloaded to our window server



IBM's flagship relational database management system

DB2 data to be directly downloaded to our window server

Postby techtally » Thu Apr 08, 2010 10:23 pm

I am just an enduser.

Here is the situation. Almost 8 gig of DB2 data from different tables are now in tape. We need the DB2 data to be directly downloaded to our window server. We are told the cheapest alternative is: From tape it will be written to flat files in the weekend. Then we have to download these flat files by FTP and recreate the table (for example, in Access).

Thanks.

Tal
techtally
 
Posts: 3
Joined: Thu Apr 08, 2010 10:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Cost

Postby dick scherrer » Fri Apr 09, 2010 12:01 am

Hello and welcome to the forum,

Who is responsible for reformatting the data? The data on the "db2 tape" may be in a format that is not readily downloadable and used on the Windows system - this would depend on how the "db2 tape" was created.

Staging the data to a mainframe dasd device and then downloading via ftp is a very common way to do what you want. The cost of weekend transient space should be minimal.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Cost

Postby techtally » Fri Apr 09, 2010 1:01 am

Thanks for your reply. What people do save in the tape? DB2 tables in the flat file format?
techtally
 
Posts: 3
Joined: Thu Apr 08, 2010 10:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Cost

Postby techtally » Fri Apr 09, 2010 1:39 am

DB2 people DSNUPROC to upload from tape to table
techtally
 
Posts: 3
Joined: Thu Apr 08, 2010 10:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Cost

Postby dick scherrer » Fri Apr 09, 2010 6:27 am

Hello,

It would be good to download a small bit of the data and make sure that what is available is usable once downloaded.

Whoever is providing the data should also be able to provide the format of the data.

to upload from tape to table
Possibly i've misunderstood. My understanding is that the data on the tape would be extracted from the table. Is this the original data that was used to load the db2 database?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post