Hi all,
I am using IBM DB2 9.5.
I want to export data of all tables in IXf files. for that purpose i have used the command...
db2move sample export -u userid -p password
but this creates ixf files but that don't have table name as file name.
for eg. for table ASSC it should create ASSC.ixf , but instead of that it creates tab1.ixf

Please help me to resolve this issue.

You cannot use db2move to do what you want. Generate a script to do it:

select 'export to c:\temp\'||rtrim(tabname)||'.ixf of ixf select * from '||rtrim(tabschema)||'.'||rtrim(tabname)||';' from syscat.tables where type - 'T'

Andy