To be able to comprehensively diagnose a database problem, support requires a significant number of database instance log files. You use this command, together with WinRAR and WinZIP, to compress all necessary log files into an archive file.
In the DBM command, you can limit which data is packed. To do this, specify the file class(es) whose files you want to be packed into the archive.
For the hist file class, you can only specify files from a specific directory. To do this, specify the time stamp of the relevant directory.
You have the server authorization DBFileRead.
diag_pack [file=<archive>] [class_definition]
class_definition:: = <non_hist_class_definition> | <hist_class_definition>
<non_hist_class_definition> :: = class=<class_list>
<hist_class_definition>:: = class=hist[,<class_list>] date=<timestamp>
<class_list>:: = <class_spec> | <class_spec>,<class_spec>,...
Option |
Description |
---|---|
<archive> |
Name and path of the archive file that you want to create, to which the system adds the extension .tgz Take this into account, if you are specifying an archive name of your own choosing. The default values are: File name:diagpack.tgz File ID: DIAGTGZ Directory: Run directory of the database instance |
<class_spec> |
Class of files whose files you want to include in the package For possible values, see: Glossary, File Class The default value is protocol Separate multiple classes with commas. |
<timestamp> |
Time stamp of the diagnosis file. This is an additional parameter for the hist file class You determine the time stamp by displaying the list of available diagnosis files (see: diag_histlist) |
Database Administration, Log Files