Page 1 of 1

DB2 data to be directly downloaded to our window server

PostPosted: Thu Apr 08, 2010 10:23 pm
by techtally
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

Re: Cost

PostPosted: Fri Apr 09, 2010 12:01 am
by dick scherrer
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.

Re: Cost

PostPosted: Fri Apr 09, 2010 1:01 am
by techtally
Thanks for your reply. What people do save in the tape? DB2 tables in the flat file format?

Re: Cost

PostPosted: Fri Apr 09, 2010 1:39 am
by techtally
DB2 people DSNUPROC to upload from tape to table

Re: Cost

PostPosted: Fri Apr 09, 2010 6:27 am
by dick scherrer
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?