Skip to Content

Exporting data

Related topics

Discovering Db2 subsystems and browsing catalogs

Use the following procedure to export data in .csv format to the location that you chose. The output includes the column headings.

To export data

  1. Select or create a Db2 object view that contains the object or objects that you want to export. For more information, see Creating a Db2 object view.
  2. Navigate to and select your source object or objects. For more information, see Navigating to an object.
  3. Perform one of the following actions:
    • To export all objects in the view, right-click anywhere in the results pane and select Select All; then right-click again and select Export data.
    • To export specific objects, select one or more object entries, right-click, and select Export Data.
  4. If prompted, select a location for the exported data. The default file name is export_data.csv.
  5. Save the file.

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Command Center for Db2 13.2