|
> - the NODE4 field seems to contain the node address rather than the
> node name;
The NODE4 field contains whatever is returning as an entity_out
from "Show node4 ... All Identifiers". In V1.2 it's an address.
You can find all identifiers attributes in the corresponding fields,
for example, name of the node4 is stored in the field NAME.
> - the TIME_STAMP field seems to contain the time that the record was
> written rather than the time that the data was collected. The
> field TIME_COUNTERS seems to contain this data.
The TIME_STAMP field contains a schedule time for a poll.
The MCC_EXP_EXPORT_TIME contains time when record is written in
the table.
You can find more details in the Historical Data Services Use
manual.
> Is the above correct and if so, should the Datatrieve procedures be
> changed to reflect this ?
I do not understand which procedures to change? As far as I know The
Report package works with the current exporter's database.
Sam
|
| Hello,
We too are currently having this problem with the reporting package.
I have included data here in order to make the problem clearer.
We have exported data for the 10th of November starting at 00:00 from
our historical database. Using Datatrieve we see we have 31 records of
the following format:
DTR> show ready
Ready sources:
MCC_NODE4_LINE: Relation, Rdb, snapshot read, consistency
<_CDD$TOP.MCC_RPTS.MCC_EXPORT;1>
No loaded tables.
DTR> list
Null print list.
DTR> find mcc_node4_line with line=ethernet
"ETHERNET" not field, assumed literal.
[31 records found]
DTR>
NODE4 : 1.453
LINE :
ETHERNET
TIME_STAMP : 16-Nov-1992
MCC_EXPORT_SEQUENCE : BYLR01LINE
MCC_EXPORT_SEQUENCE_NUMBER : 30
MCC_EXPORT_POLL_STATUS : 0
EXP_EXPORT_TIME : 16-Nov-1992
TIME_IDENTIFIERS : 16-Nov-1992
EXP_CVR_IDENTIFIERS : 3
EXP_CVR1_IDENTIFIERS : 14
NAME :
TIME_STATUS : 16-Nov-1992
EXP_CVR_STATUS : 3
EXP_CVR1_STATUS : 14
NMFOPERATIONALSTATE : 0
SUBSTATE : 0
STATE : 0
TIME_COUNTERS : 10-Nov-1992
EXP_CVR_COUNTERS : 1
EXP_CVR1_COUNTERS : 1
COUNTER_CREATION_TIME : 10-Nov-1992
MULTICAST_BLOCKS_SENT : 0
MULTICAST_BYTES_SENT : 0
USER_BUFFER_UNAVAILABLE : 0
SYSTEM_BUFFER_UNAVAILABLE : 0
DATA_OVERRUN : 0
UNRECOGNIZED_FRAME_DESTINATION : 0
RECEIVE_FAILURE : 11
COLLISION_DETECT_FAILURE : 0
SEND_FAILURE : 0
BLOCKS_SENT_MULTIPLE_COLLISION : 576
BLOCKS_SENT_SINGLE_COLLISION : 97
BLOCKS_SENT_INITIALLY_DEFERRED : 7422
MULTICAST_BLOCKS_RECEIVED : 194175
MULTICAST_BYTES_RECEIVED : 19127098
LOCAL_STATION_ERRORS : 0
REMOTE_STATION_ERRORS : 0
LOCAL_BUFFER_ERRORS : 0
REMOTE_BUFFER_ERRORS : 0
LOCAL_REPLY_TIMEOUTS : 0
REMOTE_REPLY_TIMEOUTS : 0
DATA_ERRORS_OUTBOUND : 0
DATA_ERRORS_OUTBOUND : 0
DATA_ERRORS_INBOUND : 0
DATA_BLOCKS_SENT : 70195
DATA_BLOCKS_RECEIVED : 261026
BYTES_SENT : 9462348
BYTES_RECEIVED : 26501148
SECONDS_SINCE_LAST_ZEROED : 13152
TIME_CHARACTERISTICS : 9-Nov-1992
EXP_CVR_CHARACTERISTICS : 1
EXP_CVR1_CHARACTERISTICS : 1
DOS_MODEM_TYPE : 0
DOS_STOP_BITS : 0
DOS_STATION_ADDRESS :
ADMINISTRATIVESTATE : 0
HARDWARE_ADDRESS : 08-00-2B-1B-5D-8
TRANSMIT_PIPELINE : 0
BUFFER_SIZE : 0
SWITCH : 0
HANGUP : 0
MICROCODE_DUMP :
INTERFACE : 0
NETWORK :
STREAM_TIMER : 0
DELAY_TIMER : 0
DEAD_TIMER : 0
SCHEDULING_TIMER : 0
MAXIMUM_WINDOW : 0
MAXIMUM_RETRANSMITS : 0
MAXIMUM_BLOCK : 0
HOLDBACK_TIMER : 0
RETRANSMIT_TIMER : 0
SERVICE_TIMER : 0
COMMUNICATION_MODE : 0
LINE_SPEED : 10000000
CLOCK : 0
PROTOCOL : 6
DUPLEX : 0
CONTROLLER : 0
RECEIVE_BUFFERS : 64
DEVICE :
LNA-0
COUNTER_TIMER : 0
SERVICE : 0
TIME_REFERENCES : 16-Nov-1992
EXP_CVR_REFERENCES : 3
EXP_CVR1_REFERENCES : 2
TEXT_FILE :
REMARKS :
MAIL_ACCOUNT :
PHONE_NUMBER :
RESPONSIBLE_PERSON :
IMPLEMENTATION_DESC
LOCATION :
TIME_INITIAL_ATTRIBUTES : 16-Nov-1992
EXP_CVR_INITIAL_ATTRIBUTES : 3
EXP_CVR1_INITIAL_ATTRIBUTES : 14
INITIAL_DOS_MODEM_TYPE : 0
INITIAL_DOS_STOP_BITS : 0
INITIAL_DOS_STATION_ADDRESS :
INITIAL_HARDWARE_ADDRESS :
INITIAL_STATE : 0
INITIAL_TRANSMIT_PIPELINE : 0
INITIAL_BUFFER_SIZE : 0
INITIAL_SWITCH : 0
INITIAL_HANGUP : 0
INITIAL_MICROCODE_DUMP :
INITIAL_INTERFACE : 0
INITIAL_NETWORK :
INITIAL_STREAM_TIMER : 0
INITIAL_DELAY_TIMER : 0
INITIAL_DEAD_TIMER : 0
INITIAL_SCHEDULING_TIMER : 0
INITIAL_MAXIMUM_WINDOW : 0
INITIAL_MAXIMUM_RETRANSMITS : 0
INITIAL_MAXIMUM_BLOCK : 0
INITIAL_HOLDBACK_TIMER : 0
INITIAL_RETRANSMIT_TIMER : 0
INITIAL_SERVICE_TIMER : 0
INITIAL_COMMUNICATION_MODE : 0
INITIAL_LINE_SPEED : 0
INITIAL_CLOCK : 0
INITIAL_PROTOCOL : 0
INITIAL_DUPLEX : 0
INITIAL_CONTROLLER : 0
INITIAL_RECEIVE_BUFFERS : 0
INITIAL_DEVICE :
INITIAL_COUNTER_TIMER : 0
INITIAL_SERVICE : 0
INITIAL_NAME :
TIME_STATISTICS : 16-Nov-1992
EXP_CVR_STATISTICS : 4
EXP_CVR1_STATISTICS : 2010
EXP_TIME_DURATION :
ETHERNET_CONTENTION : 0.0000E+00
COUNT_OF_UNRECOGN_FRAME_DESTINA : 0.0000E+00
COUNT_OF_USER_BUFFERS_UNAVAILAB : 0.0000E+00
COUNT_OF_SYSTEM_BUFFERS_UNAVAIL : 0.0000E+00
COUNT_OF_DATA_OVERRUN_BLOCKS : 0.0000E+00
COUNT_OF_COLLISI_DETECT_FAILURE : 0.0000E+00
COUNT_OF_FRAME_RECEIVE_FAILURES : 0.0000E+00
COUNT_OF_FRAME_SEND_FAILURES : 0.0000E+00
COUNT_OF_SELECTION_TIMEOUTS : 0.0000E+00
COUNT_OF_SELECTI_INTERVA_ELAPSE : 0.0000E+00
COUNT_OF_REMOTE_STATION_ERRORS : 0.0000E+00
COUNT_OF_LOCAL_STATION_ERRORS : 0.0000E+00
COUNT_OF_REMOTE_BUFFER_ERRORS : 0.0000E+00
COUNT_OF_LOCAL_BUFFER_ERRORS : 0.0000E+00
COUNT_OF_REMOTE_REPLY_TIMEOUTS : 0.0000E+00
COUNT_OF_LOCAL_REPLY_TIMEOUTS : 0.0000E+00
INBOUND_DATA_FRAME_ERRORS : 0.0000E+00
OUTBOUND_DATA_FRAME_ERRORS : 0.0000E+00
ERROR_PERCENT : 0.0000E+00
INBOUND_MULTICAST_PERCENT : 0.0000E+00
MULTIPLE_COLLISION_PERCENT : 0.0000E+00
SINGLE_COLLISION_PERCENT : 0.0000E+00
DEFERRED_PERCENT : 0.0000E+00
INBOUND_BLOCK_RATE : 0.0000E+00
OUTBOUND_BLOCK_RATE : 0.0000E+00
AVERAGE_INBOUND_BLOCK_SIZE : 0.0000E+00
AVERAGE_OUTBOUND_BLOCK_SIZE : 0.0000E+00
INBOUND_UTILIZATION : 0.0000E+00
OUTBOUND_UTILIZATION : 0.0000E+00
INBOUND_DATA_BLOCKS : 0.0000E+00
OUTBOUND_DATA_BLOCKS : 0.0000E+00
INBOUND_BYTES : 0.0000E+00
OUTBOUND_BYTES : 0.0000E+00
DURATION : 0.0000E+00
When we try to make reports we must enter the following values:
*** Node4 Line Traffic Report ***
- Please enter a Node Name or * for all nodes-
: 1.453
- Please enter a Line Id or * for all lines-
: ethernet
- Please enter a beginning date in the format DD-MMM-YYYY e.g (10-MAY-1990) -
: 16-nov-1992
-Please enter beginning hour in the format hh (e.g. 09)-
: 00
- Please enter an ending date in the format DD-MMM-YYYY e.g (21-MAY-1990) -
: 16-nov-1992
-Please enter ending hour in the format hh (e.g. 14)-
: 24
- hour entered must be from 0 - 23
-Please enter ending hour in the format hh (e.g. 14)-
: 23
- Please enter a report file name e.g. node4_line_traffic.rpt-
: disk$data:[mcc_reports_files]bylr01_line_traffic.rpt
- Your report file name will be DISK$DATA:[MCC_REPORTS_FILES]BYLR01_LINE_TRAFFI
C.RPT -
- It will be created when the batch job for this report is completed -
Job MCC_RPTS_NODE4_LINE_TRAFFIC_DTR (queue BYLV21_BATCH, entry 506) started on B
YLV21_BATCH
and we get the following report:
DECmcc Phase-IV Line Traffic Report 17-Nov-1992
Page 1
Time Interval: 16-Nov-1992 - 16-Nov-1992 23:00
Node_name: 1.453
Line_id:ETHERNET Line_speed: 10000000 Line_mode: N/A
Total KBytes KData_Blocks Average Average Peak Peak Ethernet
(Octetes) (SDUs) Bytes/Data_Block Bytes/Sec Bytes/Sec Date Time Contention
------------ ------------ ---------------- --------- --------- --------- -----------
In: 38,695 In: 345 116 1,605 2,517 10-Nov-1992 07:30 1.91258064
out: 7,508 Out: 52
Total: 46,204 Total: 397
Successful Polls: 16 out of 31 total polls
This is the same as David pointed out in his note:
1. we have to give the node number not name
2. we have to give a begin and end time of when we exported the data not
when it was recorded by the historian. So we get a report with the title
that the data is from the 16-nov with a "PEAK DATE TIME" of 10-NOV-1992.
I believe this is what David, in the original note, was trying to point out when
he mentioned that perhaps the Datatrieve procedures should be changed
to reflect this. Perhaps the problem is, that the procedures are written
for "currently" exported data not "historically" exported data.
And lastly maybe I don't understand the fields correctly, but there doesn't
seem to be any times associated with the "time stamps", only dates. So how
can you extract data for a certain hour of the day?
Also is there an easy way to tell for what times you have data for in
you rdb database? (I don't mean a show exporting)?
Hope this helps,
Julie Ann
|