-
Use the following command syntax to export by database:
tset [-icf <commandfile>]| [[-c|-l] <DSN_or_tdpid>\<username>\<password> [-am <Authentication Mechanism>\<Authentication Parameter>] [-scs <Session characterset>] -ed <databasename> [-qcd <qcdname>] [-f <exportfile>] [-d -s -r -p -o -g -w -e -m] [-ux|-unx] [-xapp]]
The following examples demonstrate ways to export by database from the command line.
Syntax Example Description tset -l prod\dbc\dbc -ed db1 -dsro Export object definitions, statistics and RAS for the database dbl from the system prod. Cost parameters are also exported from the system. The exported data is saved to a file using the name prod. tset -l test\jeff -ed qcd -p -ux Export execution plans from the QCD database named qcd from the system test. Only plans captured by the user jeff are exported. The exported data is saved to a file named test. tset -c prod -ed dbc -o -f cost Export only cost parameters from the system prod. The exported data is saved to a file named cost.