{"id":11159,"date":"2024-03-14T13:32:08","date_gmt":"2024-03-14T13:32:08","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/"},"modified":"2025-08-04T08:19:14","modified_gmt":"2025-08-04T08:19:14","slug":"how-can-i-export-data-from-multiple-tables-at-once-in-db2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/","title":{"rendered":"Export Multiple Tables in DB2: db2move Guide"},"content":{"rendered":"

In DB2 database, you can use the db2move tool to export data from multiple tables at once. Here are the steps to export data from multiple tables at once using the db2move tool.<\/p>\n

    \n
  1. First, create a file list containing the names of the tables to be exported. Write each table name on a new line and save the file as tables.lst.<\/li>\n
  2. Export data from multiple tables using the db2move command. Execute the following command in the command line:<\/li>\n<\/ol>\n
    db2move <database_name> export -sn <schema_name> -aw -tn @tables.lst\r\n<\/code><\/pre>\n
    The  is the name of the database from which data is to be exported, and the  is the name of the schema containing the tables to be exported.<\/p>\n
      \n
    1. The db2move command will export the data of all tables listed in the tables.lst file to the export directory in the current location.<\/li>\n<\/ol>\n
      Please note that the exported data will be saved in the export directory as a comma-separated text file. You can restore the data by importing these files into the target database.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In DB2 database, you can use the db2move tool to export data from multiple tables at once. Here are the steps to export data from multiple tables at once using the db2move tool. First, create a file list containing the names of the tables to be exported. Write each table name on a new line […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[7813,935,3477,8992,2163],"class_list":["post-11159","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-tools","tag-db2","tag-db2move","tag-export-data","tag-sql-tables"],"yoast_head":"\nExport Multiple Tables in DB2: db2move Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Quickly export data from multiple DB2 tables using db2move. Step-by-step tutorial with command examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export Multiple Tables in DB2: db2move Guide\" \/>\n<meta property=\"og:description\" content=\"Quickly export data from multiple DB2 tables using db2move. Step-by-step tutorial with command examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T13:32:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T08:19:14+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"Export Multiple Tables in DB2: db2move Guide\",\"datePublished\":\"2024-03-14T13:32:08+00:00\",\"dateModified\":\"2025-08-04T08:19:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/\"},\"wordCount\":174,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Database Tools\",\"DB2\",\"DB2MOVE\",\"Export Data\",\"SQL Tables\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/\",\"name\":\"Export Multiple Tables in DB2: db2move Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T13:32:08+00:00\",\"dateModified\":\"2025-08-04T08:19:14+00:00\",\"description\":\"Quickly export data from multiple DB2 tables using db2move. Step-by-step tutorial with command examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export Multiple Tables in DB2: db2move Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Export Multiple Tables in DB2: db2move Guide - Blog - Silicon Cloud","description":"Quickly export data from multiple DB2 tables using db2move. Step-by-step tutorial with command examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/","og_locale":"en_US","og_type":"article","og_title":"Export Multiple Tables in DB2: db2move Guide","og_description":"Quickly export data from multiple DB2 tables using db2move. Step-by-step tutorial with command examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T13:32:08+00:00","article_modified_time":"2025-08-04T08:19:14+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"Export Multiple Tables in DB2: db2move Guide","datePublished":"2024-03-14T13:32:08+00:00","dateModified":"2025-08-04T08:19:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/"},"wordCount":174,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Database Tools","DB2","DB2MOVE","Export Data","SQL Tables"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/","name":"Export Multiple Tables in DB2: db2move Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T13:32:08+00:00","dateModified":"2025-08-04T08:19:14+00:00","description":"Quickly export data from multiple DB2 tables using db2move. Step-by-step tutorial with command examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-export-data-from-multiple-tables-at-once-in-db2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Export Multiple Tables in DB2: db2move Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=11159"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11159\/revisions"}],"predecessor-version":[{"id":154929,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11159\/revisions\/154929"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=11159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=11159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=11159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}