This is Partition wise export.
db2_all "<<+0< db2 connect to sample; db2 export to ./exp/tabname.0.ixf
of ixf select * from tabname where nodenumber(Partitionkey) = 0 ;" >
outputfilename.0
db2_all "<<+11< db2 connect to sample; db2 export to
../exp/tabname.11.ixf of ixf select * from tabname where
nodenumber(Partitionkey) = 11 ;" outputfilename.11
Need to add as per ur node entries in db2nodes.cfg file & save it as a
..sql file say test.sql and need to invoke this .sql file as like given
below.
db2 -tvf test.sql -z test.sql.out
With Regards
Balakrishnan Ethiraju
chettiar wrote:
I am new to shell scripting. I need to use the db2_all command in a
shell script can someone help.
I need to use the following command in the shell script:
db2_all <<-0< db2 conncet to sample; db2 export to ./exp/tabname.ixf
select * from ixf where dbpartitionnum(customer) = current
dbpartitionnum;
Thanks in advance.