Home About Holdings Missions Sitemap Helpdesk

The last job you submited is either finished or stopped. We display the log file for you to check the status. If the status file doesn't end with "EOF", it means there might be something wrong for some reasons. Please resubmit your job again.

2001-02-26 15:14:10   GATOR search started.
2001-02-26 15:14:11   Output file: /work/TMP_AAAjKXX2_/Gator/ntmass.pt_src_cat_0116133
2001-02-26 15:14:11   Working space:  /work/TMP_AAAjKXX2_/Gator
 
  Back to Status Page    

  2001-02-26 15:14:12    ----------- Run DDGEN -----------
2001-02-26 15:14:12   Generate Data Dictionary:
ddgen /work/TMP_AAAjKXX2_/Gator/table.tbl /work/TMP_AAAjKXX2_/Gator/table16133_dd -a u
2001-02-26 15:14:13   [struct stat="OK", msg="ddgen"]
 
 
2001-02-26 15:14:13    ----------- Run DBIN -----------
2001-02-26 15:14:13    Load user's table into database:
dbin /work/TMP_AAAjKXX2_/Gator/table.tbl dd /work/TMP_AAAjKXX2_/Gator/table16133_dd -s @rmt_pebble -dbn isistmp -dbt table16133_tbl -dbd table16133_dd
2001-02-26 15:14:29    [struct stat="OK", msg="6 rows of data are loaded into database"]
 
 
2001-02-26 15:14:29    ----------- Run Compare -----------
2001-02-26 15:14:29    Compare two set of data:
tbl_compare 60 /work/TMP_AAAjKXX2_/Gator/table.tbl /xpf/ntmass.pt_src_cat.xpf /work/TMP_AAAjKXX2_/Gator/table16133.xrf
2001-02-26 15:14:52   [struct stat="OK", sources=6, matches=21]
 
 
2001-02-26 15:14:52    ----------- Run DDGEN -----------
2001-02-26 15:14:52 Generate data dictionary for compare file:
ddgen /work/TMP_AAAjKXX2_/Gator/table16133.xrf /work/TMP_AAAjKXX2_/Gator/table16133.xrf_dd -a x
2001-02-26 15:14:53   [struct stat="OK", msg="ddgen"]
 
 
2001-02-26 15:14:53    ----------- Run DBIN -----------
2001-02-26 15:14:53    Load compare file into database:
dbin /work/TMP_AAAjKXX2_/Gator/table16133.xrf dd /work/TMP_AAAjKXX2_/Gator/table16133.xrf_dd -s @rmt_pebble -dbn isistmp -dbt xrf16133 -dbd xrf16133_dd
2001-02-26 15:14:55   [struct stat="OK", msg="21 rows of data are loaded into database"]
 
 
2001-02-26 15:14:55    ----------- ISISQL --------------
2001-02-26 15:14:55    Connect to the DBMS server:
connect @rmt_pebble
2001-02-26 15:14:55    [struct stat="OK", msg="connect: @rmt_pebble"]
 
 
2001-02-26 15:14:55    Choose database:
database ntmass
2001-02-26 15:14:55    [struct stat="OK", database="ntmass"]
 
 
2001-02-26 15:14:55    Specify catalog:
catalog pt_src_cat_01
2001-02-26 15:14:55    [struct stat="OK", msg="catalog: pt_src_cat_01."]
 
 
2001-02-26 15:14:55    Output file header:
prepend /work/TMP_AAAjKXX2_/Gator/header
2001-02-26 15:14:55    [struct stat="OK", msg="prepend: /work/TMP_AAAjKXX2_/Gator/header"]
 
 
2001-02-26 15:14:55    SQL statements:
sql select
2001-02-26 15:14:55    [struct stat="OK", msg="sql ..."]
 
 
2001-02-26 15:14:55    SQL Select List:
A.cntr_u, X.dist_x, X.pang_x,A.ra_u, A.dec_u, A.j_m_u, A.h_m_u, A.k_m_u, B.ra, B.dec, B.err_maj, B.err_min, B.err_ang, B.designation, B.j_m, B.j_msig, B.j_msigcom, B.h_m, B.h_msig, B.h_msigcom, B.k_m, B.k_msig, B.k_msigcom, B.rd_flg, B.bl_flg, B.cc_flg, B.extd_flg, B.mp_flg, B.id_opt, B.b_m_opt, B.r_m_opt, B.dist_opt, B.phi_opt, B.nopt_mchs, B.date, B.glon, B.glat, B.j_psfchi, B.h_psfchi, B.k_psfchi, B.j_m_stdap, B.j_msig_stdap, B.h_m_stdap, B.h_msig_stdap, B.k_m_stdap, B.k_msig_stdap, B.ndet_flg, B.j_h, B.h_k, B.j_k
2001-02-26 15:14:55    [struct stat="OK", msg="sql ..."]
 
 
2001-02-26 15:14:55    SQL continued:
from isistmp@rmt_pebble:table16133_tbl A, pt_src_cat_01 B, isistmp@rmt_pebble:xrf16133 X
2001-02-26 15:14:55    [struct stat="OK", msg="sql ..."]
 
 
2001-02-26 15:14:55    Constraints:
where A.cntr_u = X.cntr1_x and B.cntr=X.cntr2_x;
2001-02-26 15:14:55    [struct stat="OK", msg="sql"]
 
 
2001-02-26 15:14:55    Order file by column(s):
order by A.cntr_u, X.dist_x;
2001-02-26 15:14:55    [struct stat="OK", msg="order"]
 
 
2001-02-26 15:14:55    Output file:
output file "/work/TMP_AAAjKXX2_/Gator/ntmass.pt_src_cat_0116133"
2001-02-26 15:14:55    [struct stat="OK", file="/work/TMP_AAAjKXX2_/Gator/ntmass.pt_src_cat_0116133"]
 
 
2001-02-26 15:14:55    Set PDQ :
pdq 10
2001-02-26 15:14:55    [struct stat="OK", msg="set pdqpriority 10."]
 
 
2001-02-26 15:14:55    Submit to DBMS:
submit
2001-02-26 15:14:55    [struct stat="OK", estrows=13, estio=19]
 
 
2001-02-26 15:14:55    Start retrieval:
getrec 2500000
2001-02-26 15:14:56    [struct stat="OK", nrow=21, time=" 0 00:00:00.30773"]
 
 
2001-02-26 15:14:56    clear
2001-02-26 15:14:56    [struct stat="OK", msg="clear"]
2001-02-26 15:14:56    connect @rmt_pebble
2001-02-26 15:14:56    [struct stat="OK", msg="connect: @rmt_pebble"]
2001-02-26 15:14:56    database isistmp
2001-02-26 15:14:56    [struct stat="OK", database="isistmp"]
2001-02-26 15:14:56    drop table16133_tbl
2001-02-26 15:14:56    [struct stat="OK", msg="Table table16133_tbl is droped."]
2001-02-26 15:14:56    drop table16133_dd
2001-02-26 15:14:56    [struct stat="OK", msg="Table table16133_dd is droped."]
2001-02-26 15:14:56    drop xrf16133
2001-02-26 15:14:56    [struct stat="OK", msg="Table xrf16133 is droped."]
2001-02-26 15:14:56    drop xrf16133_dd
2001-02-26 15:14:56    [struct stat="OK", msg="Table xrf16133_dd is droped."]
2001-02-26 15:14:56    [struct stat="OK", msg="Quitting."]
 
2001-02-26 15:14:56   Your Job Finished. Click View Table to view your result.
 
Your output file is ~10.512 KB. The data retrieval takes 45 seconds.
 
-EOF-