# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! #
# DMYN version 1.9 Log Save File
# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! #
# Fri Mar 20 14:39:32 PST 1998
# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! #
######################### Initial State Recovery ###################
Good Afternoon
Welcome to DataMynah. Check out the Help menu if you have never used this product before, or even if it has been a while since your last use.
Send mail to de@ucolick.org with comments and suggestions.
what do you know about
I know about the following entities (database tables):
Acontexts, Agents, Agenttypes, Formats, Ktlgrp, Mbundles, Mcontexts, Media, Memes,
Mmaps, Mpaths, Mpinouts, Pcontexts, Rtconfigs, Rtdevicedescrip, Rtdevices, Timing
Try the Help menu at upper right for more help.
lookup hitmplog
Looking up hitmplog ... please wait a moment...
Finished looking up hitmplog.
'hitmplog' is a table (#3399) in the context database:
It has a longer name of 'keck.dbo.hitmplog'.
This table has the following attributes:
toyclock, airpress, coolflow, dwrn2lv, ionpump, lampfan, lampname,
pwrblokr, relhum, resn2lv, tempcool, tempdet, tempin, templamp,
tempout, temprack, temptv, tvfan, tvon, utbfans, utbn2fil, utbtemp,
vaultfan, date
The database designers have described it thus:
'Table definition for the HIRES Temp Log data, used as a prototypical
example of telemetry from any KTL instrument.'
For more information about Memes you could try the command
DESCRIBE and the meme name or id number.
*** user clicked on the word "relhum" which was highlighted
'relhum' is a real (#265) in the context hires1:
It has a longer name of 'relative-humidity'.
It is a field in the hitmplog table.
The database designers have described it thus:
'Semantics Unknown'
For more information about Memes you could try the command
DESCRIBE and the meme name or id number.
*** user clicked on utbtemp
'utbtemp' is a real (#400) in the context keck1ccd:
It has a longer name of 'ccd-utility-board-temperature'.
It is a field in the hitmplog table.
The database designers have described it thus:
'Temperature of the CCD controller utility board.'
For more information about Memes you could try the command
DESCRIBE and the meme name or id number.
what is the max date of hitmplog
{Feb 6 1996 3:10PM}
what is the min date of hitmplog
{Dec 4 1995 6:18PM}
get the hitmplog from Dec 9 through Dec 14 1995
Created DataSet 1
Dataset D1 is date-encoded, so it supports time-based queries.
718 is too many records for easy display.
Suggest you use the 'view' command to see them.
copy d1 sample
Dataset D1 has been copied to sample
get d1 from the night of Dec 9 1995
Created DataSet 2
78 is too many records for easy display.
Suggest you use the 'view' command to see them.
help data
**** the modern version of this cmd pops up a tab notebook
**** containing this information:
-----------------------------------------------------------
Data set D1 contains 718 records
Each record has the following fields:
toyclock airpress coolflow dwrn2lv ionpump lampfan lampname pwrblokr relhum resn2lv
tempcool tempdet tempin templamp tempout temprack temptv tvfan tvon utbfans utbn2fil
utbtemp vaultfan date t__yoe t__moy t__woy t__doy t__dom t__dow t__hod t__moh t__som
t__tick
The English query that created it was:
get the hitmplog from Dec 9 through Dec 14 1995
The SQL query was:
select * into omnibus.guest.Data_de890430756_D1 from keck.dbo.hitmplog where date between '12/09/1995 14:06' and '12/14/1995 14:06'
The original table/subject was Hitmplog
-----------------------------------------------------------
Data set D2 contains 78 records
Each record has the following fields:
toyclock airpress coolflow dwrn2lv ionpump lampfan lampname pwrblokr relhum resn2lv
tempcool tempdet tempin templamp tempout temprack temptv tvfan tvon utbfans utbn2fil
utbtemp vaultfan date t__yoe t__moy t__woy t__doy t__dom t__dow t__hod t__moh t__som
t__tick
The English query that created it was:
get d1 from the night of Dec 9 1995
The SQL query was:
select * into omnibus.guest.Data_de890430756_D2 from omnibus.guest.Data_de890430756_D1 where t__tick between 818557200 and 818604000
The original table/subject was Hitmplog
-----------------------------------------------------------
Data set sample contains 718 records
Each record has the following fields:
toyclock airpress coolflow dwrn2lv ionpump lampfan lampname pwrblokr relhum resn2lv
tempcool tempdet tempin templamp tempout temprack temptv tvfan tvon utbfans utbn2fil
utbtemp vaultfan date t__yoe t__moy t__woy t__doy t__dom t__dow t__hod t__moh t__som
t__tick
The English query that created it was:
get the hitmplog from Dec 9 through Dec 14 1995
The SQL query was:
select * into omnibus.guest.Data_de890430756_D1 from keck.dbo.hitmplog where date between '12/09/1995 14:06' and '12/14/1995 14:06'
The original table/subject was Hitmplog
average d2 by the hour of day
Created DataSet 3
0 0 0.0057166666666666659 108.241753 1424 28.230794333333336 57.717199833333325 -0.306724 -119.92368466666666 2.7574373333333337 0.025605166666666665 3.034653333333333 8.9070636666666676 2.1224380000000003 4.333333333333333 1995 12 50 344 10 1 31 0 818584256.0
1 0 0.0057983333333333333 108.241753 1424 28.153482999999998 57.934398333333341 -0.27507350000000003 -119.99013400000001 2.8754951666666666 0.093427499999999997 2.8854443333333335 9.3953450000000007 2.2028636666666666 4.416666666666667 1995 12 50 344 10 1 31 0 818587914.66666663
2 0 0.0060220000000000004 108.241753 1424 27.848307166666661 57.872341666666671 -0.25246600000000002 -119.98064050000001 2.9518853333333333 0.116035 2.6051118333333334 9.655761833333333 2.2006900000000003 4.416666666666667 1995 12 50 344 10 1 32 0 818591520.0
3 0 0.0055541666666666665 105.66849266666668 1424 28.019205833333334 57.819153 -0.24794449999999998 -119.88571066666667 3.0167013333333332 0.1635105 2.7588426666666668 9.7696939999999994 2.2224266666666668 4.666666666666667 1995 12 50 344 10 1 32 0 818595114.66666663
4 0 0.0056761666666666662 98.910252833333331 1424 28.080240833333335 57.788124333333336 0.00073716666666663827 -119.9046965 3.0583688333333332 0.28559066666666666 3.1816016666666669 9.8795573333333326 2.3963200000000002 5.0 1995 12 50 344 10 1 32 0 818598720.0
5 0 0.0058798333333333333 94.523806333333326 1424 28.312174500000001 57.765960999999997 0.070820000000000008 -119.91418983333335 3.1139256666666668 0.35115216666666665 3.2584666666666666 10.038249 2.4658773333333333 4.833333333333333 1995 12 50 344 10 1 32 0 818602325.33333337
17 0 0.0063071666666666658 33.658423833333337 1412 27.498372333333332 72.526595999999998 -2.4159964999999999 -119.99962483333336 2.9310518333333335 -0.72270050000000008 0.8259078333333334 7.9671219999999998 0.82041266666666657 4.75 1995 12 49 343 9 7 30 0 818559040.0
18 0 0.0065309999999999995 29.276555666666667 1412 27.628580833333334 72.828018166666666 -2.1673148333333332 -120.01861183333335 2.9194774999999997 -0.67974633333333345 1.1446725000000002 7.8979489999999997 0.96387466666666677 4.75 1995 12 49 343 9 7 31 0 818562666.66666663
19 0 0.0064903333333333341 24.839742833333332 1412 27.868652166666667 72.885643000000002 -2.3165238333333331 -120.03759766666667 2.9241073333333332 -0.70913616666666668 1.1356296666666668 7.946777 0.90518566666666667 4.583333333333333 1995 12 49 343 9 7 31 0 818566250.66666663
20 0 0.0064496666666666669 20.283881500000003 1412 28.112793 72.823585666666673 -2.4657326666666664 -120.05658349999999 2.9356814999999998 -0.81313000000000002 1.0180711666666666 7.8694660000000001 0.80302333333333331 4.583333333333333 1995 12 49 343 9 7 31 0 818569866.66666663
21 0 0.0061443333333333341 15.279303166666667 1412 28.316243500000002 72.770393666666664 -2.6420704999999995 -120.09455383333331 2.914847833333333 -0.90129899999999996 0.93894500000000003 7.7392579999999995 0.69651366666666659 5.0 1995 12 49 343 9 7 31 0 818573461.33333337
22 0 0.0057166666666666659 32.170328166666671 1412 28.344726499999997 65.953017666666668 -1.6925588333333332 -120.09455499999997 2.808364333333333 -0.60514183333333327 1.9065426666666667 7.7555340000000008 1.1725466666666666 4.083333333333333 1995 12 49 343 9 7 31 0 818577056.0
23 0 0.0037436666666666664 108.241753 1424 28.381347666666667 54.543441833333333 -0.93747083333333336 -119.99013283333333 2.6972506666666667 -0.23211933333333332 2.8017966666666667 8.3211265000000001 1.7376996666666669 4.583333333333333 1995 12 49 343 9 7 31 0 818580661.33333337
average sample by the hour of day
Created DataSet 4
24 is too many records for easy display.
Suggest you use the 'view' command to see them.
help data
-----------------------------------------------------------
Data set D4 contains 24 records
Each record has the following fields:
Hr_Of_Dy avg_toyclock avg_airpress avg_dwrn2lv avg_pwrblokr avg_relhum avg_resn2lv
avg_tempcool avg_tempdet avg_tempin avg_templamp avg_tempout avg_temprack avg_temptv
avg_utbtemp avg_t__yoe avg_t__moy avg_t__woy avg_t__doy avg_t__dom avg_t__dow avg_t__moh
avg_t__som avg_t__tick
The English query that created it was:
average sample by the hour of day
The SQL query was:
select t__hod Hr_Of_Dy,avg(toyclock) avg_toyclock,avg(airpress) avg_airpress,avg(dwrn2lv) avg_dwrn2lv,avg(pwrblokr) avg_pwrblokr,avg(relhum) avg_relhum,avg(resn2lv) avg_resn2lv,avg(tempcool) avg_tempcool,avg(tempdet) avg_tempdet,avg(tempin) avg_tempin,avg(templamp) avg_templamp,avg(tempout) avg_tempout,avg(temprack) avg_temprack,avg(temptv) avg_temptv,avg(utbtemp) avg_utbtemp,avg(t__yoe) avg_t__yoe,avg(t__moy) avg_t__moy,avg(t__woy) avg_t__woy,avg(t__doy) avg_t__doy,avg(t__dom) avg_t__dom,avg(t__dow) avg_t__dow,avg(t__moh) avg_t__moh,avg(t__som) avg_t__som,avg(t__tick) avg_t__tick into omnibus.guest.Data_de890430756_D4 from omnibus.guest.Data_de890430756_sample group by t__hod
The original table/subject was Sample
-----------------------------------------------------------
Data set D1 contains 718 records
Each record has the following fields:
toyclock airpress coolflow dwrn2lv ionpump lampfan lampname pwrblokr relhum resn2lv
tempcool tempdet tempin templamp tempout temprack temptv tvfan tvon utbfans utbn2fil
utbtemp vaultfan date t__yoe t__moy t__woy t__doy t__dom t__dow t__hod t__moh t__som
t__tick
The English query that created it was:
get the hitmplog from Dec 9 through Dec 14 1995
The SQL query was:
select * into omnibus.guest.Data_de890430756_D1 from keck.dbo.hitmplog where date between '12/09/1995 14:06' and '12/14/1995 14:06'
The original table/subject was Hitmplog
-----------------------------------------------------------
Data set D2 contains 78 records
Each record has the following fields:
toyclock airpress coolflow dwrn2lv ionpump lampfan lampname pwrblokr relhum resn2lv
tempcool tempdet tempin templamp tempout temprack temptv tvfan tvon utbfans utbn2fil
utbtemp vaultfan date t__yoe t__moy t__woy t__doy t__dom t__dow t__hod t__moh t__som
t__tick
The English query that created it was:
get d1 from the night of Dec 9 1995
The SQL query was:
select * into omnibus.guest.Data_de890430756_D2 from omnibus.guest.Data_de890430756_D1 where t__tick between 818557200 and 818604000
The original table/subject was Hitmplog
-----------------------------------------------------------
Data set sample contains 718 records
Each record has the following fields:
toyclock airpress coolflow dwrn2lv ionpump lampfan lampname pwrblokr relhum resn2lv
tempcool tempdet tempin templamp tempout temprack temptv tvfan tvon utbfans utbn2fil
utbtemp vaultfan date t__yoe t__moy t__woy t__doy t__dom t__dow t__hod t__moh t__som
t__tick
The English query that created it was:
get the hitmplog from Dec 9 through Dec 14 1995
The SQL query was:
select * into omnibus.guest.Data_de890430756_D1 from keck.dbo.hitmplog where date between '12/09/1995 14:06' and '12/14/1995 14:06'
The original table/subject was Hitmplog
-----------------------------------------------------------
Data set D3 contains 13 records
Each record has the following fields:
Hr_Of_Dy avg_toyclock avg_airpress avg_dwrn2lv avg_pwrblokr avg_relhum avg_resn2lv
avg_tempcool avg_tempdet avg_tempin avg_templamp avg_tempout avg_temprack avg_temptv
avg_utbtemp avg_t__yoe avg_t__moy avg_t__woy avg_t__doy avg_t__dom avg_t__dow avg_t__moh
avg_t__som avg_t__tick
The English query that created it was:
average d2 by the hour of day
The SQL query was:
select t__hod Hr_Of_Dy,avg(toyclock) avg_toyclock,avg(airpress) avg_airpress,avg(dwrn2lv) avg_dwrn2lv,avg(pwrblokr) avg_pwrblokr,avg(relhum) avg_relhum,avg(resn2lv) avg_resn2lv,avg(tempcool) avg_tempcool,avg(tempdet) avg_tempdet,avg(tempin) avg_tempin,avg(templamp) avg_templamp,avg(tempout) avg_tempout,avg(temprack) avg_temprack,avg(temptv) avg_temptv,avg(utbtemp) avg_utbtemp,avg(t__yoe) avg_t__yoe,avg(t__moy) avg_t__moy,avg(t__woy) avg_t__woy,avg(t__doy) avg_t__doy,avg(t__dom) avg_t__dom,avg(t__dow) avg_t__dow,avg(t__moh) avg_t__moh,avg(t__som) avg_t__som,avg(t__tick) avg_t__tick into omnibus.guest.Data_de890430756_D3 from omnibus.guest.Data_de890430756_D2 group by t__hod
The original table/subject was Hitmplog
chart d1
Dataset D1 Quick Analysis:
Statistical Summary of Numeric Fields:
Min Max Avg StdDev
------------ ------------ ------------ ------------
toyclock 818547307.0000 818978399.0000 0.0000 0.000000
airpress 0.0020 0.0081 0.0059 0.000596
dwrn2lv 6.6758 108.2418 66.2930 32.273264
pwrblokr 1305.0000 1424.0000 0.0000 1371.482605
relhum 20.8252 29.1748 25.3066 2.450823
resn2lv 36.2500 98.2979 65.5302 15.261358
tempcool -2.9541 2.2683 -0.5997 1.059202
tempdet -120.2369 -119.3826 -119.9089 0.124091
tempin 2.6648 5.2343 3.8141 0.616052
templamp -0.9465 1.8342 0.5273 0.587045
tempout 0.7897 5.0218 2.5334 0.868701
temprack 7.6660 11.7432 9.5598 0.927970
temptv 0.6422 4.2678 2.3083 0.723160
utbtemp 3.0000 9.0000 5.0411 1.022780
Enumerated Fields Detected:
airpress : 0.0019530000000000001 0.0023189999999999999 0.0029299999999999999 0.003052 0.0032959999999999999 0.0035400000000000002 0.0036619999999999999 0.003784 0.0039060000000000002 0.0040280000000000003 0.00415 0.0042719999999999998 0.0043949999999999996 0.0045170000000000002 0.0046389999999999999 0.0047609999999999996 0.0048830000000000002 0.0050049999999999999 0.0051269999999999996 0.0052490000000000002 0.0053709999999999999 0.0054929999999999996 0.0056150000000000002 0.0057369999999999999 0.0058589999999999996 0.0059810000000000002 0.0061040000000000001 0.0062259999999999998 0.0063480000000000003 0.0064700000000000001 0.0065919999999999998 0.0067140000000000003 0.0068360000000000001 0.0069579999999999998 0.0070800000000000004 0.0072020000000000001 0.0073239999999999998 0.0074460000000000004 0.0075680000000000001 0.0080569999999999999
pwrblokr : 1305 1311 1318 1324 1330 1336 1341 1342 1352 1358 1364 1365 1370 1394 1400 1412 1418 1424
tempdet : -119.38259100000001 -119.667374 -119.724335 -119.781288 -119.838249 -119.895203 -119.952164 -120.009117 -120.066078 -120.12303199999999 -120.179993 -120.236946
utbfans : 0 1
utbn2fil : 0 1
utbtemp : 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0
Nonfunctional (constant) fields detected:
coolflow : 1
ionpump : 1
lampfan : 0
lampname : none
tvfan : 0
tvon : 0
vaultfan : 1
chart d3
Dataset D3 Quick Analysis:
Statistical Summary of Numeric Fields:
Min Max Avg StdDev
------------ ------------ ------------ ------------
hr_of_dy 0.0000 23.0000 11.0000 9.336309
avg_toyclock 0.0000 0.0000 0.0000 0.000000
avg_airpress 0.0037 0.0065 0.0058 0.000716
avg_dwrn2lv 15.2793 108.2418 68.2752 41.267626
avg_pwrblokr 1412.0000 1424.0000 1418.0000 6.244998
avg_relhum 27.4984 28.3813 28.0611 0.279779
avg_resn2lv 54.5434 72.8856 63.9406 7.675874
avg_tempcool -2.6421 0.0708 -1.2037 1.086600
avg_tempdet -120.0946 -119.8857 -119.9916 0.069418
avg_tempin 2.6973 3.1139 2.9157 0.114667
avg_templamp -0.9013 0.3512 -0.2791 0.467512
avg_tempout 0.8259 3.2585 2.1151 0.966230
avg_temprack 7.7393 10.0382 8.7033 0.920251
avg_temptv 0.6965 2.4659 1.5931 0.702151
avg_utbtemp 4.0833 5.0000 4.6154 0.262508
Nonfunctional (constant) fields detected:
avg_toyclock : 0
chart d4
Dataset D4 Quick Analysis:
Statistical Summary of Numeric Fields:
Min Max Avg StdDev
------------ ------------ ------------ ------------
hr_of_dy 0.0000 23.0000 11.0000 7.089490
avg_toyclock 56478262.0000 56480211.0000 56479236.0000 287.364410
avg_airpress 0.0051 0.0063 0.0059 0.000321
avg_dwrn2lv 21.6300 108.2418 66.3552 29.295830
avg_pwrblokr 1363.0000 1373.0000 1369.0000 3.071609
avg_relhum 23.8127 27.1232 25.3062 1.065511
avg_resn2lv 58.1738 73.9929 65.5134 6.987557
avg_tempcool -1.7545 0.4633 -0.5982 0.833018
avg_tempdet -119.9920 -119.8174 -119.9089 0.049331
avg_tempin 3.6426 3.9496 3.8141 0.091644
avg_templamp -0.0490 1.0443 0.5281 0.395081
avg_tempout 1.6556 3.2924 2.5345 0.635067
avg_temprack 8.5221 10.5745 9.5617 0.774599
avg_temptv 1.5347 2.9967 2.3093 0.544868
avg_utbtemp 4.5000 5.4500 5.0407 0.235958
chart sample
Dataset sample Quick Analysis:
Statistical Summary of Numeric Fields:
Min Max Avg StdDev
------------ ------------ ------------ ------------
toyclock 818547307.0000 818978399.0000 0.0000 0.000000
airpress 0.0020 0.0081 0.0059 0.000596
dwrn2lv 6.6758 108.2418 66.2930 32.273264
pwrblokr 1305.0000 1424.0000 0.0000 1371.482605
relhum 20.8252 29.1748 25.3066 2.450823
resn2lv 36.2500 98.2979 65.5302 15.261358
tempcool -2.9541 2.2683 -0.5997 1.059202
tempdet -120.2369 -119.3826 -119.9089 0.124091
tempin 2.6648 5.2343 3.8141 0.616052
templamp -0.9465 1.8342 0.5273 0.587045
tempout 0.7897 5.0218 2.5334 0.868701
temprack 7.6660 11.7432 9.5598 0.927970
temptv 0.6422 4.2678 2.3083 0.723160
utbtemp 3.0000 9.0000 5.0411 1.022780
Enumerated Fields Detected:
airpress : 0.0019530000000000001 0.0023189999999999999 0.0029299999999999999 0.003052 0.0032959999999999999 0.0035400000000000002 0.0036619999999999999 0.003784 0.0039060000000000002 0.0040280000000000003 0.00415 0.0042719999999999998 0.0043949999999999996 0.0045170000000000002 0.0046389999999999999 0.0047609999999999996 0.0048830000000000002 0.0050049999999999999 0.0051269999999999996 0.0052490000000000002 0.0053709999999999999 0.0054929999999999996 0.0056150000000000002 0.0057369999999999999 0.0058589999999999996 0.0059810000000000002 0.0061040000000000001 0.0062259999999999998 0.0063480000000000003 0.0064700000000000001 0.0065919999999999998 0.0067140000000000003 0.0068360000000000001 0.0069579999999999998 0.0070800000000000004 0.0072020000000000001 0.0073239999999999998 0.0074460000000000004 0.0075680000000000001 0.0080569999999999999
pwrblokr : 1305 1311 1318 1324 1330 1336 1341 1342 1352 1358 1364 1365 1370 1394 1400 1412 1418 1424
tempdet : -119.38259100000001 -119.667374 -119.724335 -119.781288 -119.838249 -119.895203 -119.952164 -120.009117 -120.066078 -120.12303199999999 -120.179993 -120.236946
utbfans : 0 1
utbn2fil : 0 1
utbtemp : 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0
Nonfunctional (constant) fields detected:
coolflow : 1
ionpump : 1
lampfan : 0
lampname : none
tvfan : 0
tvon : 0
vaultfan : 1
plot avg_relhum, avg_dwrn2lv from d4 against
plot avg_relhum, avg_dwrn2lv from d4
plot avg_relhum, avg_dwrn2lv from d4
plot avg_relhum, avg_dwrn2lv from d4 over
plot avg_relhum, avg_dwrn2lv from d4 across
help commands
Mynah Commands:
ANALYZE BACK BE CHART COUNT DO
EXISTS EXPORT FIND FORWARD FREEZE GOTO
HELP LOOKUP LOSE PLOT RETURN SAVE
SHEET THAW VIEW WHATIS XGOBI
**** user clicks on EXPORT
EXPORT (export , file )
Usage : EXPORT commands export a table or dataset in various ASCII file formats for use in other utilities.
Example: export data5 TSV
gobi d4
Wrote XGOBI file D4 and doc file D4.col.
If you don't know how to use XGOBI, see your local data maven for help.
gobi sample
Wrote XGOBI file sample and doc file sample.col.
If you don't know how to use XGOBI, see your local data maven for help.
sheet d4
Made spreadsheet number 0 for D4