15.10 - PackDisk - Teradata Database

Teradata Database SystemFE Macros

prodname
Teradata Database
vrm_release
15.00
15.10
category
Administration
featnum
B035-1103-015K

PackDisk

Returns all user-issued PackDisk related events logged in the DBC.Software_Event_Log table for a set period of time.

Syntax

where:

 

Syntax Element …

Specifies …

Fromdate

the date on which the search is to start.

The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531.

Todate

the date on which the search is to stop.

The format is 'YYYY-MM-DD'. This parameter can be coded either as a character string, for example, '2013-05-31', or as a numeric value, for example, 1130531. The default value for Todate is the current date.

Note: This macro is not case sensitive. Uppercase and lowercase letters can be used interchangeably.

Usage Notes

The PackDisk macro report is based on event codes 034‑05144-00 and 034-05145-00.

For a complete description of these events, see the “Teradata Database Messages” chapter of Messages. You can also view the events in the ListErrorCodes report (see “ListErrorCodes” on page 29).

This macro is useful to list all PackDisk requests (indicated by event code 05144), if any, and whether these requests were completed successfully (indicated by event code 05145). You can initiate PackDisk requests using the Ferret utility.

For more information on Ferret, see Utilities.

Example  

The following statement would give a report of the PackDisks for the last seven days:

Exec PackDisk (Date-6,);

Example  

The following statement would give a report of the PackDisk between January 1, 2013 and March 10, 2013:

Exec PackDisk ('2013-01-01' , '2013-03-10');

Example  

The following statement would give a report of the PackDisk between January 21, 2013, and the date of today.

Exec PackDisk ('2013-01-21',);

Note: The date specified is the same as the date the macro was run.

The resulting report follows:

Exec PackDisk ('2013-01-21',);
*** Query completed. 23 rows found. 6 columns returned.
13/01/21         PackDisks Performed Between 2013-01-21 and 2013-01-21 21:49
Vproc       Date             Time         Event
------  --------  ---------------  ------------
     0  13/01/21  21:30:20.390000   34-05144-00
                  21:30:37.290000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 0 =      1
     1  13/01/21  21:30:20.380000   34-05144-00
                  21:30:34.740000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 1 =      1
     2  13/01/21  21:30:20.380000   34-05144-00
                  21:30:37.840000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 2 =      1
     3  13/01/21  21:30:20.360000   34-05144-00
                  21:30:53.320000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 3 =      1
     4  13/01/21  21:30:20.360000   34-05144-00
                  21:30:51.280000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 4 =      1
     5  13/01/21  21:30:20.350000   34-05144-00
                  21:30:39.520000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 5 =      1
     6  13/01/21  21:30:20.320000   34-05144-00
                  21:30:30.910000   34-05145-00
                                       ------
***** Number of PackDisks On vproc 6 =      1
     7  13/01/21  21:30:20.320000   34-05144-00
                                       ------
***** Number of PackDisks On vproc 7 =    1