IBM Mainframe Forum

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

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.

Thanks for your reply. What people do save in the tape? DB2 tables in the flat file format?

DB2 people DSNUPROC to upload from tape to table

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?