Export from DB2

Posted on 2006-04-03
Last Modified: 2006-11-18
I was told by someone that the most efficient way to extract data from certain tables, certain columns, and certain dates every 15 mins would be to use the export utility.  Is this true?  If not, is there a better way?  The database is running on a AIX platform.  Thanks in advance.
Question by:jhughes4
    LVL 7

    Accepted Solution


    Yea thats the best way to do it.  You can also select and re-direct it to a flat file, but export would be the best option. If you are on a partition db / EEE you can try parallel export which would be faster.

    Here is the command syntax, if you don't have it already

    LVL 7

    Expert Comment

    yes, export will work fine and you can use any customised sql with it.

    Syntax here:
    LVL 3

    Expert Comment

    You can also setup replication (Capture and Apply) to automate the copies.  It is quite straightforward.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now