15.10 - DiskEvents - Teradata Database

Teradata Database SystemFE Macros

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

DiskEvents

Returns all disk events logged in the DBC.SW_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 DiskEvents macro report is based on event codes 033-11036-00, 033-11038-00, and 033-11094-00.

For a complete description of this event, see the “Parallel Database Extensions (PDE) Messages” chapter of Messages.

You can also use a SELECT query to view events in the DBC.SW_Event_Log (see “Determining Contents of the DBC.SW_Event_Log” on page 11).

Example  

The following statement generates a report of all Disk Events for the last seven days:

Exec DiskEvents (Date-6,);

Example  

The following statement generates a report of Disk Events between September 30, 2012 and January 31, 2013:

Exec DiskEvents ('2012-09-30' , '2013-01-31');

Example  

The following statement generates a report of Disk Events between August 9, 2012 and February 20, 2013:

Exec DiskEvents ('2012-08-09','2013-02-20');

The resulting report follows:

exec systemfe.diskevents('2012-08-09','2013-02-20');
 
 *** Echo accepted. 
 *** Total elapsed time was 2 seconds.
 *** Query completed. 691 rows found. 5 columns returned. 
 
13/02/19                    Disk Events Between 2012-01-01 and 2013-02-20                      12:09
 
 
    Date            Time Message Text
-------- --------------- --------------------------------------------------------------------------------
13/02/02 18:41:16.381378 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000D00000026 (38:13:1:0)
                         State       = 0x03, Sector   = 0x0080, Length   = 0x00000200
                         Attr        = 0x00, Vproc ID = 0x000D, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         18:41:16.757614 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000900000026 (38:9:1:0)
                         State       = 0x03, Sector   = 0x0080, Length   = 0x00000200
                         Attr        = 0x00, Vproc ID = 0x0009, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         18:41:16.860288 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000B00000024 (36:11:1:0)
                         State       = 0x03, Sector   = 0x0099, Length   = 0x00000200
                         Attr        = 0x00, Vproc ID = 0x000B, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         18:41:16.892315 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000A00000025 (37:10:1:0)
                         State       = 0x03, Sector   = 0x0083, Length   = 0x00000200
                         Attr        = 0x00, Vproc ID = 0x000A, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         18:41:16.981832 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000C00000024 (36:12:1:0)
                         State       = 0x03, Sector   = 0x008A, Length   = 0x00000400
                         Attr        = 0x00, Vproc ID = 0x000C, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         18:41:17.066148 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000800000025 (37:8:1:0)
                         State       = 0x03, Sector   = 0x0083, Length   = 0x00000200
                         Attr        = 0x00, Vproc ID = 0x0008, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
         18:41:17.422217 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000700000025 (37:7:1:0)
                         State       = 0x03, Sector   = 0x0095, Length   = 0x00000200
 
 
13/02/19                   Disk Events Between 2012-01-01 and 2013-02-20                         12:09
 
    Date            Time Message Text
-------- --------------- --------------------------------------------------------------------------------
13/02/02 18:41:17.422217 Attr        = 0x00, Vproc ID = 0x0007, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
13/02/03 14:16:44.075227 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000A00000026 (38:10:1:0)
                         State       = 0x03, Sector   = 0x042A, Length   = 0x00000200
                         Attr        = 0x00, Vproc ID = 0x000A, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         14:16:44.155212 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000C00000026 (38:12:1:0)
                         State       = 0x03, Sector   = 0x0455, Length   = 0x00000400
                         Attr        = 0x00, Vproc ID = 0x000C, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         14:16:44.203279 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000D00000027 (39:13:1:0)
                         State       = 0x03, Sector   = 0x0461, Length   = 0x00000200
                         Attr        = 0x00, Vproc ID = 0x000D, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         14:16:44.207242 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000800000029 (41:8:1:0)
                         State       = 0x03, Sector   = 0x0442, Length   = 0x00000600
                         Attr        = 0x00, Vproc ID = 0x0008, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         14:16:44.523432 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000900000025 (37:9:1:0)
                         State       = 0x03, Sector   = 0x0432, Length   = 0x00000400
                         Attr        = 0x00, Vproc ID = 0x0009, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         14:16:44.655585 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5
                         Cylinder ID = 0x0x0001000700000027 (39:7:1:0)
                         State       = 0x03, Sector   = 0x0427, Length   = 0x00000400
                         Attr        = 0x00, Vproc ID = 0x0007, Error    = 0x00000010
                         Class       = 0x01, Flags    = 0x0000, OS Error = 0xFFFFFFFB
 
         14:16:44.875817 Event number 33-11094-00 (severity 10, category 9) Received OS I/O
                         error.
                         Extent driver error TVSA_E_SYSTEM: OS Error -5...