Filter
Top Products
CHAPTER 5 Moving Data In and Out of Databases
187
Interpreting notification messages
By default, Adaptive Server IQ displays information about your database
during insert and load operations.
The statistics in these messages indicate when you need to perform
maintenance and optimization tasks, such as adding more dbspaces. The
messages also report on the progress of the load. This section explains each
notification message.
At the start of the insert is a description of the operation, such as this one:
In table ’partsupp’, the full width insert
of 5 columns will begin at record 1.
1998-07-28 13:03:47 0002 Insert Started:
1998-07-28 13:03:47 0002 partsupp
1998-07-28 13:03:48 0002 [20270]:
=n*** File: /remote/rip/tpcd_data/scale_1/partsupp.tbl
Each time it inserts the number of records specified in the NOTIFY load option,
Adaptive Server IQ sends a message like this:
1998-07-28 13:03:49 0002 [20897]: 100000 Records, 2
Seconds
Mem: 469mb/M470
Main Blks: U63137/6%, Buffers: U12578/L7
Temporary Blks: U273/0%, Buffers: U1987/L1960
Main I: L331224/P22 O: D25967/P7805 C:D0
Temporary I: L25240/P8 O: D4749/P0 C:D0
The first line shows how many rows Adaptive Server IQ has read since the last
notification message, and the number of seconds taken reading them. Even if
Adaptive Server IQ reads the same number of messages each time, the amount
of time will vary depending on the data read (for example, how many data
conversions are required). Reported time intervals smaller than 1 second are
usually reported as “0 Secs”.
Memory message
This message displays memory usage information:
Mem: 469mb/M470