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