'Export' Tag

  • Parallel export for partitioned tables

    October 25, 2005

    db2_all “<<+$nodenum<db2 connect to $dbname; db2 export to $filename of del select * from $tablename where nodenumber($partitioningkey)=$nodenumber” Example: db2_all “<<+11<db2 connect to testdb; db2 export to /backup/test_table.del.11 of del select * from test_table where nodenumber(ID) = 11; db2 terminate” NOTE: Useful for large tables. Be sure to export all the partitions in which the table […]

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org