Personal tools
You are here: Home → DB2 → How To's → How to export and load using compression & named pipes
Navigation
Log in


Forgot your password?
 
Document Actions

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
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls