Background documentationdiag_pack Locate this document in the navigation structure

 

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.

Prerequisites

You have the server authorization DBFileRead.

Structure

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>,...

Options

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)

Result

OK

In the event of errors, see Reply Format.

More Information

Database Administration, Log Files