Thursday, 12 June 2014

How to export and load using compression & named pipes

How to export and load using compression & named pipes

How to export and load using compression & named pipes
---- EXPORT ----

mkfifo /tmp/mypipe

gzip -c < /tmp/mypipe > employee.del.gz &

db2 "export to /tmp/mypipe of del select * from db2inst1.employee"

rm /tmp/mypipe

---- LOAD ----

mkfifo /tmp/mypipe

cat employee.del.gz | gzip -dc > /tmp/mypipe &

db2 "load from /tmp/mypipe of del replace into db2inst1.employee nonrecoverable"

rm /tmp/mypipe

No comments:

Post a Comment