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