[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Export from DB2

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.
0
jhughes4
Asked:
jhughes4
1 Solution
 
db2inst1Commented:

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

http://tinyurl.com/mma8e

Goodluck!
0
 
sachinwadhwaCommented:
yes, export will work fine and you can use any customised sql with it.

Syntax here:

http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/core/r0008303.htm
0
 
granbajoCommented:
You can also setup replication (Capture and Apply) to automate the copies.  It is quite straightforward.

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.ii.doc/admin/cgprc000.htm
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now