Example: Generating a Report of Disk Events Between August and February - Advanced SQL Engine - Teradata Database

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kak1592015099875.ditamap
dita:ditavalPath
kak1592015099875.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantage™

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