|
I think yes
gzip -1 < NAMEDPIPE_FILE > EXPORT_FILE &
causing the issue , we are writting to the pipe since we don't have enough space on filesystem to export data , we write data into Pipe and then compress in the background .
we can't do like this
db2 "export to NAMEDPIPE of del select * from test" &
gzip -1 < NAMEDPIPE > EXPORT.gz
Since if we hvae any error on export like table not found ... next step gzip is waitting for the PIPEFILE , and script itself is hanging without proceeding to next step.
Any insight ?
thanks
smithk
|