Results 1 to 12 of 12
  1. #1
    Join Date
    Dec 2002
    Posts
    123

    Unanswered: Backup db2 data on a cd? or csv files?

    Hi,

    We have a client that wants a copy of their data in cd/file form.. does anyone here have any experience backing up data this way? We have DB2 UDB V 8.2 and have nightly online backups of the database as well. Of course, just burning a copy of a file like DBASE.0.db2inst1.NODE0000.CATN0000.20090918050002. 001 won't be useful to the customer... any help/thoughts on this will be appreciated!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If they don't have DB2 then they will probably want delimited files. Check with them to determine which delimiter is preferred.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2002
    Posts
    123
    Thanks for the reply.. yes, they don't have db2 so it will probably have to be some other file format. They have quite a bit of data actually..what's the quickest/easiest way to export data to files.. not sure if the export command is the way to go.. since there really is a lot of data..

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2user
    Thanks for the reply.. yes, they don't have db2 so it will probably have to be some other file format. They have quite a bit of data actually..what's the quickest/easiest way to export data to files.. not sure if the export command is the way to go.. since there really is a lot of data..
    You will have to use export command one table at a time. If you have lob data (clob, blob, etc), that will complicate things, but otherwise should not be a problem. Once you do the export, then you will want to zip the files. You can fit some pretty big files on a DVD-Data disc.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Dec 2002
    Posts
    123
    no, we don't have any blob, clob data so it should be ok.. my only concern is the time it will take to export the data.. is the export command efficient for big db tables? is there another method/command that will make the process go faster? thanks so much for the replies!

  6. #6
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    First off. What will they do with this data once you give it to them? based on that you will have a better understanding on your options.

    What is that size of your db? db2 "call get_dbsize_info(?,?,?,0)"

    Are you required to provide them a copy from every backup i.e. daily?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2user
    no, we don't have any blob, clob data so it should be ok.. my only concern is the time it will take to export the data.. is the export command efficient for big db tables? is there another method/command that will make the process go faster? thanks so much for the replies!
    No, there is not another method if they do not have DB2. However, I would put WITH UR at the end of the select statements in the EXPORT command.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Dec 2002
    Posts
    123
    Quote Originally Posted by Cougar8000
    First off. What will they do with this data once you give it to them? based on that you will have a better understanding on your options.

    What is that size of your db? db2 "call get_dbsize_info(?,?,?,0)"

    Are you required to provide them a copy from every backup i.e. daily?
    Hi,

    Thanks for the response...it's basically for a customer that wants their historical load from the past 4-5 years.. my company has lost the client and they won't have access to our system soon. They still want the data given to them in some form or another since it really does belong to them. It's a little complicated since our database holds data for other clients too..so it's not holding data just for this specific customer. Our db size is currently around 61GB although I plan to remove some old data that's just been 'lying' around in tables for a while.. so hopefully it'll be atleast 5GB smaller I hope..

    1) If I go with the export route, then I will have to use select statements where the data that's exported is specific only to the customer. Am not sure if it's the optimal way since it's not just a simple dump of the whole db, but rather a subset of it based on an id. And we're talking about a lot of data.

    2) The other way to give them access to their data is to have them pay a small fee for monthly hosting and they can login to our base web application to see all the historical data. This is relatively painless since all we have to do is give them user access to a web based application and eliminates the need to export data to files/cd, etc...

    in any case, it will be nice to know the optimal way to export data to a cd/files in this scenario.. so basically I'm asking, what would you do?
    Last edited by db2user; 10-12-09 at 15:50.

  9. #9
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    As Marcus has pointed out. There is only one way to get data out. What puzzles me is it sounds like you are just a regular schmo, just like the rest of us , but have to make a decision on how you will provide this data to a client that your company lost. It has been a while since I was in this situation. Client always specified what format we should provide data in. Most likely, they will have you deal with whom ever they are using instead of you. And those people will dictate the file layout.

    Don't forget that you probably would have to include some kind of dictionary for them as well.

    Most of the time one db would hold multiple client data. Nothing is wrong with it as long as security is done right. You would have to make sure that you pull ONLY this client data.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  10. #10
    Join Date
    Dec 2002
    Posts
    123
    Thanks.. well, I'm supposed to talk to the client this week to get an idea of the format they want the data in.. I just wanted to know what options I can give them and it doesn't seem like they are planning to use another system.. so the data won't be 'moved' to a new app either.. they just want to keep it for historical purposes, that's all. In any case, thanks for the help guys!

  11. #11
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Just make sure that before you are exporting the data, delimiter that you will be using should not be part of the data. And then provide them what delimiter you have used to extract data.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  12. #12
    Join Date
    Dec 2002
    Posts
    123
    cool, thanks for the tip!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •