/usr/share/doc/condor/html/8_3

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<!--Converted with LaTeX2HTML 2008 (1.71)
original version by:  Nikos Drakos, CBLU, University of Leeds
* revised and updated by:  Marcus Hennecke, Ross Moore, Herb Swan
* with significant contributions from:
  Jens Lippmann, Marek Rouchal, Martin Wilck and others -->
<HTML>
<HEAD>
<TITLE>8.3 Quill</TITLE>
<META NAME="description" CONTENT="8.3 Quill">
<META NAME="keywords" CONTENT="ref">
<META NAME="resource-type" CONTENT="document">
<META NAME="distribution" CONTENT="global">

<META NAME="Generator" CONTENT="LaTeX2HTML v2008">
<META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css">

<LINK REL="STYLESHEET" HREF="ref.css">

<LINK REL="next" HREF="8_4_CondorView_Client.html">
<LINK REL="previous" HREF="8_2_Using_Condor.html">
<LINK REL="up" HREF="8_Contrib_Source.html">
<LINK REL="next" HREF="8_4_CondorView_Client.html">
</HEAD>

<BODY  BGCOLOR=#FFFFFF >

<DIV CLASS="navigation"><!--Navigation Panel-->
<A NAME="tex2html2455"
  HREF="8_4_CondorView_Client.html">
<IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A> 
<A NAME="tex2html2449"
  HREF="8_Contrib_Source.html">
<IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A> 
<A NAME="tex2html2443"
  HREF="8_2_Using_Condor.html">
<IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A> 
<A NAME="tex2html2451"
  HREF="Contents.html">
<IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A> 
<A NAME="tex2html2453"
  HREF="Index.html">
<IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="index.png"></A> 
<BR>
<B> Next:</B> <A NAME="tex2html2456"
  HREF="8_4_CondorView_Client.html">8.4 The CondorView Client</A>
<B> Up:</B> <A NAME="tex2html2450"
  HREF="8_Contrib_Source.html">8. Contrib and Source</A>
<B> Previous:</B> <A NAME="tex2html2444"
  HREF="8_2_Using_Condor.html">8.2 Using Condor with</A>
 &nbsp; <B>  <A NAME="tex2html2452"
  HREF="Contents.html">Contents</A></B> 
 &nbsp; <B>  <A NAME="tex2html2454"
  HREF="Index.html">Index</A></B> 
<BR>
<BR></DIV>
<!--End of Navigation Panel-->
<!--Table of Child-Links-->
<A NAME="CHILD_LINKS"><STRONG>Subsections</STRONG></A>

<UL CLASS="ChildLinks">
<LI><A NAME="tex2html2457"
  HREF="8_3_Quill.html#SECTION00931000000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">1</SPAN> Installation and Configuration</A>
<UL>
<LI><A NAME="tex2html2458"
  HREF="8_3_Quill.html#SECTION00931100000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">1</SPAN>.<SPAN CLASS="arabic">1</SPAN> Configuration Variables</A>
</UL>
<BR>
<LI><A NAME="tex2html2459"
  HREF="8_3_Quill.html#SECTION00932000000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">2</SPAN> Four Usage Examples</A>
<LI><A NAME="tex2html2460"
  HREF="8_3_Quill.html#SECTION00933000000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">3</SPAN> Quill and Security</A>
<LI><A NAME="tex2html2461"
  HREF="8_3_Quill.html#SECTION00934000000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN> Quill and Its RDBMS Schema</A>
<UL>
<LI><A NAME="tex2html2462"
  HREF="8_3_Quill.html#SECTION00934100000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">1</SPAN> Administrative Tables</A>
<LI><A NAME="tex2html2463"
  HREF="8_3_Quill.html#SECTION00934200000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">2</SPAN> Daemon Tables</A>
<LI><A NAME="tex2html2464"
  HREF="8_3_Quill.html#SECTION00934300000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">3</SPAN> Files Tables</A>
<LI><A NAME="tex2html2465"
  HREF="8_3_Quill.html#SECTION00934400000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">4</SPAN> Interface Tables</A>
<LI><A NAME="tex2html2466"
  HREF="8_3_Quill.html#SECTION00934500000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">5</SPAN> Jobs Tables</A>
<LI><A NAME="tex2html2467"
  HREF="8_3_Quill.html#SECTION00934600000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">6</SPAN> Machines Tables</A>
<LI><A NAME="tex2html2468"
  HREF="8_3_Quill.html#SECTION00934700000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">7</SPAN> Matchmaking Tables</A>
<LI><A NAME="tex2html2469"
  HREF="8_3_Quill.html#SECTION00934800000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">8</SPAN> Runtime Tables</A>
<LI><A NAME="tex2html2470"
  HREF="8_3_Quill.html#SECTION00934900000000000000"><SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">9</SPAN> System Tables</A>
</UL></UL>
<!--End of Table of Child-Links-->
<HR>

<H1><A NAME="SECTION00930000000000000000"></A><A NAME="sec:Quill"></A>
<A NAME="50389"></A>
<BR>
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN> Quill
</H1>
<A NAME="50668"></A>
<A NAME="50391"></A>
<A NAME="50669"></A>
<A NAME="50393"></A>
Quill is an optional component of Condor that maintains a mirror 
of Condor operational data
in a relational database.  The <SPAN  CLASS="textit">condor_quill</SPAN> daemon updates
the data in the relation database, and the <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon
maintains the database itself.

<P>
As of Condor version 7.5.5,
Quill is distributed only with the source code.
It is not included in the builds of Condor provided by UW,
but it is available as a feature that can be enabled by those who compile
Condor from the source code.
Find the code within the <TT>condor_contrib</TT> directory, 
in the directories <TT>condor_tt</TT> and <TT>condor_dbmsd</TT>.

<P>

<H2><A NAME="SECTION00931000000000000000"></A><A NAME="sec:Quill-Installation"></A>
<BR>
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">1</SPAN> Installation and Configuration
</H2>

<P>
Quill uses the <SPAN  CLASS="textit">PostgreSQL</SPAN> database management system.
Quill uses the <SPAN  CLASS="textit">PostgreSQL</SPAN> server as its back end
and client library, 
<SPAN  CLASS="textit">libpq</SPAN> to talk to the server.
We <SPAN  CLASS="textbf">strongly recommend</SPAN> the use of version 
8.2 or later due to its integrated facilities of certain key 
database maintenance tasks, and stronger security features.

<P>
Obtain <SPAN  CLASS="textit">PostgreSQL</SPAN> from

<P>
<A NAME="tex2html96"
  HREF="http://www.postgresql.org/ftp/source/">http://www.postgresql.org/ftp/source/</A>
<P>
Installation instructions are detailed in:
<A NAME="tex2html97"
  HREF="http://www.postgresql.org/docs/8.2/static/installation.html">http://www.postgresql.org/docs/8.2/static/installation.html</A>
<P>
Configure <SPAN  CLASS="textit">PostgreSQL</SPAN> after installation:

<P>

<OL>
<LI>Initialize the database with the <SPAN  CLASS="textit">PostgreSQL</SPAN> command 
<code>initdb</code>.

<P>
</LI>
<LI>Configure to accept TCP/IP connections.
For <SPAN  CLASS="textit">PostgreSQL</SPAN> version 8,
use the <TT>listen_addresses</TT> variable in 
<TT>postgresql.conf</TT> file as a guide.
For example,
<TT>listen_addresses = '*'</TT>
means listen on any IP interface.

<P>
</LI>
<LI>Configure automatic vacuuming.
Ensure that these variables with these defaults are
commented in and/or set properly in the 
<TT>postgresql.conf</TT> configuration file:
<PRE>
# Turn on/off automatic vacuuming
autovacuum = on

# time between autovacuum runs, in secs
autovacuum_naptime = 60

# min # of tuple updates before vacuum
autovacuum_vacuum_threshold = 1000

# min # of tuple updates before analyze
autovacuum_analyze_threshold = 500

# fraction of rel size before vacuum
autovacuum_vacuum_scale_factor = 0.4 

# fraction of rel size before analyze
autovacuum_analyze_scale_factor = 0.2

# default vacuum cost delay for 
   # autovac, -1 means use 
   # vacuum_cost_delay
autovacuum_vacuum_cost_delay = -1  

# default vacuum cost limit for 
   # autovac, -1 means use
   # vacuum_cost_limit
autovacuum_vacuum_cost_limit = -1
</PRE>

<P>
</LI>
<LI>Configure <SPAN  CLASS="textit">PostgreSQL</SPAN> to accept TCP/IP connections from 
specific hosts.
Modify the <TT>pg_hba.conf</TT> file 
(which usually resides in the <SPAN  CLASS="textit">PostgreSQL</SPAN> server's data directory).
Access is required by the <SPAN  CLASS="textit">condor_quill</SPAN> daemon,
as well as the database users
``<SPAN  CLASS="textbf">quillreader</SPAN>'' and ``<SPAN  CLASS="textbf">quillwriter</SPAN>''.
For example, to give
database users ``<SPAN  CLASS="textbf">quillreader</SPAN>'' and ``<SPAN  CLASS="textbf">quillwriter</SPAN>''
password-enabled access to all databases on current machine from any
machine in the 128.105.0.0/16 subnet, add the following:

<P>
<TABLE CELLPADDING=3>
<TR><TD ALIGN="LEFT">host</TD>
<TD ALIGN="LEFT">all</TD>
<TD ALIGN="LEFT">quillreader</TD>
<TD ALIGN="LEFT">128.105.0.0</TD>
<TD ALIGN="LEFT">255.255.0.0</TD>
<TD ALIGN="LEFT">md5</TD>
</TR>
<TR><TD ALIGN="LEFT">host</TD>
<TD ALIGN="LEFT">all</TD>
<TD ALIGN="LEFT">quillwriter</TD>
<TD ALIGN="LEFT">128.105.0.0</TD>
<TD ALIGN="LEFT">255.255.0.0</TD>
<TD ALIGN="LEFT">md5</TD>
</TR>
</TABLE>

<P>
Note that in addition to the database specified by
the configuration variable <TT>QUILL_DB_NAME</TT>,
the <SPAN  CLASS="textit">condor_quill</SPAN> daemon also needs access to the database
"template1".
In order to create the database in the first place, 
the <SPAN  CLASS="textit">condor_quill</SPAN> daemon needs to connect to the database.

<P>
</LI>
<LI>Start the <SPAN  CLASS="textit">PostgreSQL</SPAN> server service. See the
installation instructions for the appropriate method to start the service at
<A NAME="tex2html98"
  HREF="http://www.postgresql.org/docs/8.2/static/installation.html">http://www.postgresql.org/docs/8.2/static/installation.html</A>
<P>
</LI>
<LI>The <SPAN  CLASS="textit">condor_quill</SPAN> and <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemons and client tools connect
to the database as users ``<SPAN  CLASS="textbf">quillreader</SPAN>'' and 
``<SPAN  CLASS="textbf">quillwriter</SPAN>''.
These are database users, not operating system users.
The two types of users are quite different from each other.
If these database users do not exist,
add them using the 
<SPAN  CLASS="textit">createuser</SPAN> command supplied with the installation.
Assign them with appropriate passwords;
these passwords will be used by the Quill tools to connect
to the database in a secure way.
User ``<SPAN  CLASS="textbf">quillreader</SPAN>'' should not be allowed to create
more databases nor create more users.
User ``<SPAN  CLASS="textbf">quillwriter</SPAN>'' should
not be allowed to create more users,
however it should be allowed to create more databases.
The following commands create the two users
with the appropriate permissions,
and be ready to enter the corresponding passwords when prompted.

<P>
<PRE>
/path/to/postgreSQL/bin/directory/createuser quillreader \
	--no-createdb --no-createrole --pwprompt

/path/to/postgreSQL/bin/directory/createuser quillwriter \
	--createdb --no-createrole --pwprompt
</PRE>
<P>
Answer ``no'' to the question about the ability for role creation.

<P>
</LI>
<LI>Create a database for Quill to store data in
with the <code>createdb</code> command. 
Create this database with the ``<SPAN  CLASS="textbf">quillwriter</SPAN>'' user as the owner.
A sample command to do this is
<PRE>
createdb -O quillwriter quill
</PRE><code>quill</code> is the database name to use with the <TT>QUILL_DB_NAME</TT>
configuration variable.

<P>
</LI>
<LI>The <SPAN  CLASS="textit">condor_quill</SPAN> and <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemons need read and write access
to the database.
They connect as user ``<SPAN  CLASS="textbf">quillwriter</SPAN>'',
which has owner privileges to the database.
Since this gives all access to the ``<SPAN  CLASS="textbf">quillwriter</SPAN>'' user,
its password cannot be stored in a public place 
(such as in a ClassAd).
For this reason, the ``<SPAN  CLASS="textbf">quillwriter</SPAN>'' password is stored
in a file named <TT>.pgpass</TT> in the Condor spool directory.
Appropriate protections on this file guarantee secure access to the database.
This file must be created and protected by the site administrator;
if this file does not exist as and where expected, the <SPAN  CLASS="textit">condor_quill</SPAN>
and <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemons log an error and exit.
The <TT>.pgpass</TT> file contains a single line that
has fields separated by colons and is properly terminated by
an operating system specific newline character (Unix) or CRLF (Windows).
The first field may be either the machine name and fully qualified domain,
or it may be a dotted quad IP address.
This is followed by four fields containing:
the TCP port number, 
the name of the database,
the "quillwriter" user name,
and the password.
The form used in the first field must exactly match the value set for 
the configuration variable <TT>QUILL_DB_IP_ADDR</TT>  <A NAME="50745"></A>.
Condor uses a string comparison between the two, and it does not resolve the
host names to compare IP addresses.
Example:
<PRE>
machinename.cs.wisc.edu:5432:quill:quillwriter:password
</PRE>
<P>
</LI>
</OL>

<P>
After the <SPAN  CLASS="textit">PostgreSQL</SPAN> database is initialized and running, 
the Quill schema
must be loaded into it.  First, load the plsql programming language
into the server:

<P>
<PRE>
createlang plpgsql [databasename]
</PRE>

<P>
Then, load the Quill schema from the sql files in the <TT>sql</TT> subdirectory
of the Condor release directory:

<P>
<PRE>
psql [databasename] [username] &lt; common_createddl.sql
psql [databasename] [username] &lt; pgsql_createddl.sql
</PRE>
where <code>[username]</code> will be <code>quillwriter</code>.

<P>
After <SPAN  CLASS="textit">PostgreSQL</SPAN> is configured and running, Condor must also be
configured to use Quill, since by default Quill is configured to be off.

<P>
<DL>
<DT></DT>
<DD>Add the file <TT>.pgpass</TT> to the 
  <TT>VALID_SPOOL_FILES</TT> variable, since <SPAN  CLASS="textit">condor_preen</SPAN> must
  be told not to delete this file.
  This step may not be necessary, depending on which version of Condor 
  you are upgrading from. 

<P>
</DD>
<DT></DT>
<DD>Set up configuration variables that are specific to the installation,
and check that the <TT>HISTORY</TT> variable is set.
<PRE>
HISTORY                 = $(SPOOL)/history
QUILL_ENABLED           = TRUE
QUILL_USE_SQL_LOG       = FALSE
QUILL_NAME              = some-unique-quill-name.cs.wisc.edu
QUILL_DB_USER           = quillwriter
QUILL_DB_NAME           = database-for-some-unique-quill-name
QUILL_DB_IP_ADDR        = databaseIPaddress:port
# the following parameter's units is in seconds
QUILL_POLLING_PERIOD    = 10
QUILL_HISTORY_DURATION 	= 30
QUILL_MANAGE_VACUUM     = FALSE
QUILL_IS_REMOTELY_QUERYABLE = TRUE
QUILL_DB_QUERY_PASSWORD =  password-for-database-user-quillreader
QUILL_ADDRESS_FILE      = $(LOG)/.quill_address
QUILL_DB_TYPE           = PGSQL
# The Purge and Reindex intervals are in seconds
DATABASE_PURGE_INTERVAL	= 86400
DATABASE_REINDEX_INTERVAL = 86400
# The History durations are all in days 
QUILL_RESOURCE_HISTORY_DURATION  = 7
QUILL_RUN_HISTORY_DURATION = 7
QUILL_JOB_HISTORY_DURATION = 3650
#The DB Size limit is in gigabytes
QUILL_DBSIZE_LIMIT      = 20
QUILL_MAINTAIN_DB_CONN  = TRUE
SCHEDD_SQLLOG           = $(LOG)/schedd_sql.log
SCHEDD_DAEMON_AD_FILE   = $(LOG)/.schedd_classad
</PRE>
<P>
</DD>
</DL>

<P>
The default Condor configuration file should already contain definitions
for <TT>QUILL</TT> and <TT>QUILL_LOG</TT>.  
When upgrading from a previous version that did not have Quill to
a new one that does, define these two configuration variables.

<P>
Only one machine should run the <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon.  
On this machine, add it to the <TT>DAEMON_LIST</TT> configuration variable.
All Quill-enabled machines should also run the <SPAN  CLASS="textit">condor_quill</SPAN> daemon.
The machine running the <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon can also 
run a <SPAN  CLASS="textit">condor_quill</SPAN> daemon.  An example <TT>DAEMON_LIST</TT>
for a machine running both daemons,
and acting as both a submit machine and a central manager might 
look like the following:

<P>
<PRE>
DAEMON_LIST  = MASTER, SCHEDD, COLLECTOR, NEGOTIATOR, DBMSD, QUILL
</PRE>
<P>
The <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon will need configuration file entries
common to all daemons.
If not already in the configuration file, add the following entries:

<P>
<PRE>
DBMSD = $(SBIN)/condor_dbmsd
DBMSD_ARGS = -f
DBMSD_LOG = $(LOG)/DbmsdLog
MAX_DBMSD_LOG = 10000000
</PRE>

<P>

<H3><A NAME="SECTION00931100000000000000"></A><A NAME="sec:Quill-Config"></A>
<BR>
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">1</SPAN>.<SPAN CLASS="arabic">1</SPAN> Configuration Variables
</H3>

<P>
<A NAME="50488"></A>
These macros affect the Quill database
management and interface to its representation of the job queue.

<P>
<DL>
<DD><A NAME="param:Quill"></A></DD>
<DT><STRONG><TT>QUILL</TT>  <A NAME="50770"></A></STRONG></DT>
<DD>The full path name to the <SPAN  CLASS="textit">condor_quill</SPAN> daemon.

<P>
<A NAME="param:QuillArgs"></A></DD>
<DT><STRONG><TT>QUILL_ARGS</TT>  <A NAME="50775"></A></STRONG></DT>
<DD>Arguments to be passed to the <SPAN  CLASS="textit">condor_quill</SPAN> daemon upon its invocation.

<P>
<A NAME="param:QuillLog"></A></DD>
<DT><STRONG><TT>QUILL_LOG</TT>  <A NAME="50780"></A></STRONG></DT>
<DD>Path to the Quill daemon's log file.

<P>
<A NAME="param:QuillEnabled"></A></DD>
<DT><STRONG><TT>QUILL_ENABLED</TT>  <A NAME="50783"></A></STRONG></DT>
<DD>A boolean variable that defaults to <TT>False</TT>.
  When <TT>True</TT>, Quill functionality is enabled.
  When <TT>False</TT>, the Quill daemon writes a message to its log and exits.
  The <SPAN  CLASS="textit">condor_q</SPAN> and <SPAN  CLASS="textit">condor_history</SPAN> tools then do not use Quill.

<P>
<A NAME="param:QuillName"></A></DD>
<DT><STRONG><TT>QUILL_NAME</TT>  <A NAME="50793"></A></STRONG></DT>
<DD>A string that uniquely identifies an instance of the <SPAN  CLASS="textit">condor_quill</SPAN>
  daemon, as there may be more than <SPAN  CLASS="textit">condor_quill</SPAN> daemon per pool.
  The string must not be the same as for any <SPAN  CLASS="textit">condor_schedd</SPAN> daemon.

<P>
See the description of <TT>MASTER_NAME</TT> in
  section&nbsp;<A HREF="3_3_Configuration.html#param:MasterName">3.3.9</A> on page&nbsp;<A HREF="3_3_Configuration.html#param:MasterName"><IMG  ALIGN="BOTTOM" BORDER="1" ALT="[*]" SRC="crossref.png"></A>
  for defaults and composition of valid Condor daemon names.

<P>
<A NAME="param:QuillUseSQLLog"></A></DD>
<DT><STRONG><TT>QUILL_USE_SQL_LOG</TT>  <A NAME="50803"></A></STRONG></DT>
<DD>In order for Quill to store historical job information or resource
  information, the Condor daemons must write information to the SQL logfile.
  By default, this is set to <TT>False</TT>, and the only information Quill
  stores in the database is the current job queue.
  This can be set on a per daemon basis. For example, to store information
  about historical jobs, but not store execute resource information, set
  <TT>QUILL_USE_SQL_LOG</TT> to <TT>False</TT> and set
  <TT>SCHEDD._QUILL_USE_SQL_LOG</TT> to <TT>True</TT>.

<P>
<A NAME="param:QuillDBName"></A></DD>
<DT><STRONG><TT>QUILL_DB_NAME</TT>  <A NAME="50811"></A></STRONG></DT>
<DD>A string that identifies a database within a database server.

<P>
<A NAME="param:QuillDBUser"></A></DD>
<DT><STRONG><TT>QUILL_DB_USER</TT>  <A NAME="50814"></A></STRONG></DT>
<DD>A string that identifies the <SPAN  CLASS="textit">PostgreSQL</SPAN> user that Quill 
  will connect as to the database.
  We recommend ``<SPAN  CLASS="textbf">quillwriter</SPAN>'' for this setting. 
  There is no default setting for <TT>QUILL_DB_USER</TT>, 
  so it must be specified in the configuration file. 

<P>
<A NAME="param:QuillDBType"></A></DD>
<DT><STRONG><TT>QUILL_DB_TYPE</TT>  <A NAME="50820"></A></STRONG></DT>
<DD>A string that distinguishes between database system types.
  Defaults to the only database system currently defined,
  <code>"PGSQL"</code>.

<P>
<A NAME="param:QuillDBIPAddr"></A></DD>
<DT><STRONG><TT>QUILL_DB_IP_ADDR</TT>  <A NAME="50823"></A></STRONG></DT>
<DD>The host address of the database server. It can be either an IP address
  or an IP address.
  It must match exactly what is used in the <TT>.pgpass</TT> file.
  More than one Quill server can talk to the same database
  server.  This can be accomplished by letting all the 
  <TT>QUILL_DB_IP_ADDR</TT> values point to the same database server.

<P>
<A NAME="param:QuillPollingPeriod"></A></DD>
<DT><STRONG><TT>QUILL_POLLING_PERIOD</TT>  <A NAME="50828"></A></STRONG></DT>
<DD>The frequency, in number of seconds, at which the Quill daemon
  polls the file <TT>job_queue.log</TT> for updates.
  New information in the log file is sent to the database.
  The default value is 10.
  Since Quill works by periodically sniffing the log file for updates and 
  then sending those updates to the database, 
  this variable controls the trade off between the currency of query results 
  and Quill's load on the system, which is usually negligible.

<P>
<A NAME="param:QuillNotRespondingTimeout"></A></DD>
<DT><STRONG><TT>QUILL_NOT_RESPONDING_TIMEOUT</TT>  <A NAME="50832"></A></STRONG></DT>
<DD>The length of time, in seconds, before the <SPAN  CLASS="textit">condor_master</SPAN>
  may decide that the <SPAN  CLASS="textit">condor_quill</SPAN> daemon is hung due to 
  a lack of communication,
  potentially causing  the <SPAN  CLASS="textit">condor_master</SPAN> to kill and
  restart the <SPAN  CLASS="textit">condor_quill</SPAN> daemon.
  When the <SPAN  CLASS="textit">condor_quill</SPAN> daemon is processing a very long log file, it 
  may not be able to communicate with the master. 
  The default is 3600 seconds, or one hour. It may be
  advisable to increase this to several hours. 

<P>
<A NAME="param:QuillMaintainDBConn"></A></DD>
<DT><STRONG><TT>QUILL_MAINTAIN_DB_CONN</TT>  <A NAME="50845"></A></STRONG></DT>
<DD>A boolean variable that defaults to <TT>True</TT>.
  When <TT>True</TT>, the <SPAN  CLASS="textit">condor_quill</SPAN> daemon
  maintains an open connection the database server,
  which speeds up updates to the database.
  As each open connection consumes resources at the database server,
  we recommend a setting of <TT>False</TT> for large pools.

<P>
<A NAME="param:QuillDatabasePurgeInterval"></A></DD>
<DT><STRONG><TT>DATABASE_PURGE_INTERVAL</TT>  <A NAME="50853"></A></STRONG></DT>
<DD>The interval, in seconds, between scans of the database to identify and
  delete records that are beyond their history durations. 
  The default value is 86400, or one day.

<P>
<A NAME="param:QuillJobHistoryDuration"></A></DD>
<DT><STRONG><TT>QUILL_JOB_HISTORY_DURATION</TT>  <A NAME="50856"></A></STRONG></DT>
<DD>The number of days after entry into the database that a job will
  remain in the database.
  After <TT>QUILL_JOB_HISTORY_DURATION</TT> days, the job is deleted.
  The job history is the final ClassAd, and contains all information 
  necessary for <SPAN  CLASS="textit">condor_history</SPAN> to succeed.
  The default is 3650, or about 10 years. 

<P>
<A NAME="param:QuillRunHistoryDuration"></A></DD>
<DT><STRONG><TT>QUILL_RUN_HISTORY_DURATION</TT>  <A NAME="50862"></A></STRONG></DT>
<DD>The number of days after entry into the database that extra information 
  about the job will remain in the database.
  After <TT>QUILL_RUN_HISTORY_DURATION</TT> days, the records are deleted.
  This data includes matches made for the job, file transfers the job 
  performed, and user log events.
  The default is 7 days, or one week. 

<P>
<A NAME="param:QuillResourceHistoryDuration"></A></DD>
<DT><STRONG><TT>QUILL_RESOURCE_HISTORY_DURATION</TT>  <A NAME="50866"></A></STRONG></DT>
<DD>The number of days after entry into the database that a resource record will
  remain in the database.
  After <TT>QUILL_RESOURCE_HISTORY_DURATION</TT> days, the record is 
  deleted.
  The resource history data includes the ClassAd of a compute slot,
  submitter ClassAds, and daemon ClassAds.
  The default is 7 days, or one week. 

<P>
<A NAME="param:QuillDBSizeLimit"></A></DD>
<DT><STRONG><TT>QUILL_DBSIZE_LIMIT</TT>  <A NAME="50870"></A></STRONG></DT>
<DD>At intervals of time set by <TT>DATABASE_PURGE_INTERVAL</TT>,
  the <SPAN  CLASS="textit">condor_quill</SPAN> daemon estimates the size of the database. 
  If the size of the database exceeds the limit set by this variable, 
  the <SPAN  CLASS="textit">condor_quill</SPAN> daemon will e-mail the administrator a warning. 
  This size is given in Gbytes, and defaults to 20. 

<P>
<A NAME="param:QuillManageVacuum"></A></DD>
<DT><STRONG><TT>QUILL_MANAGE_VACUUM</TT>  <A NAME="50878"></A></STRONG></DT>
<DD>A boolean value that defaults to <TT>False</TT>.
  When <TT>True</TT>, the <SPAN  CLASS="textit">condor_quill</SPAN> daemon takes on 
  the maintenance task of vacuuming the database.
  As of <SPAN  CLASS="textit">PostgreSQL</SPAN> version 8.1, the database
  can perform this task automatically; 
  therefore, having the <SPAN  CLASS="textit">condor_quill</SPAN> daemon vacuum is not necessary.
  A value of <TT>True</TT> causes warnings to be written to the log file.

<P>
<A NAME="param:QuillShouldReindex"></A></DD>
<DT><STRONG><TT>QUILL_SHOULD_REINDEX</TT>  <A NAME="50889"></A></STRONG></DT>
<DD>A boolean value that defaults to <TT>True</TT>.
  When <TT>True</TT>, the <SPAN  CLASS="textit">condor_quill</SPAN> daemon will re-index the database
  tables when the history file is purged of old data. So, if Quill is
  configured to never delete history data, the tables are never re-indexed.

<P>
<A NAME="param:QuillDatabaseReindexInterval"></A></DD>
<DT><STRONG><TT>DATABASE_REINDEX_INTERVAL</TT>  <A NAME="50896"></A></STRONG></DT>
<DD>Because <SPAN  CLASS="textit">PostgreSQL</SPAN> does not aggressively maintain the index 
  structures for deleted tuples, it can lead to bloated index structures.
  This variable is the interval, in seconds, 
  between re-index commands on the database.
  The default value is 86400, or one day.
  This is only used when the <TT>QUILL_DB_TYPE</TT> is set to
  <code>"PGSQL"</code>.

<P>
<A NAME="param:QuillIsRemotelyQueryable"></A></DD>
<DT><STRONG><TT>QUILL_IS_REMOTELY_QUERYABLE</TT>  <A NAME="50901"></A></STRONG></DT>
<DD>A boolean value that defaults to <TT>True</TT>.
  Thanks to <SPAN  CLASS="textit">PostgreSQL</SPAN>,
  one can now remotely query both the job queue and the history tables. 
  This variable controls whether this remote querying 
  feature should be enabled.  
  Note that even if <TT>False</TT>, one can still query the job queue 
  at the remote <SPAN  CLASS="textit">condor_schedd</SPAN> daemon.

<P>
<A NAME="param:QuillDBQueryPassword"></A></DD>
<DT><STRONG><TT>QUILL_DB_QUERY_PASSWORD</TT>  <A NAME="50909"></A></STRONG></DT>
<DD>Defines the password string needed by <SPAN  CLASS="textit">condor_q</SPAN> to gain read
  access for remotely querying the Quill database.
  In order for the query tools to connect to a database, 
  they need to provide the password that is assigned to the 
  database user ``<SPAN  CLASS="textbf">quillreader</SPAN>''. 
  This variable is then advertised by the <SPAN  CLASS="textit">condor_quill</SPAN> daemon
  to the <SPAN  CLASS="textit">condor_collector</SPAN>.  
  This facility enables remote querying: remote <SPAN  CLASS="textit">condor_q</SPAN> query tools first 
  ask the <SPAN  CLASS="textit">condor_collector</SPAN> for
  the password associated with a particular Quill database, 
  and then query that database.  
  Users who do not have access to the <SPAN  CLASS="textit">condor_collector</SPAN> 
  cannot view the password, and as such cannot query the database.

<P>
<A NAME="param:QuillAddressFile"></A></DD>
<DT><STRONG><TT>QUILL_ADDRESS_FILE</TT>  <A NAME="50925"></A></STRONG></DT>
<DD>When defined, it specifies the path and file name of a local file
  that contains the IP address and port number of the Quill daemon.
  By using the file, tools executed on the local machine do not need
  to query the central manager in order to find the <SPAN  CLASS="textit">condor_quill</SPAN> daemon.

<P>
<A NAME="param:DBMSD"></A> 
</DD>
<DT><STRONG><TT>DBMSD</TT>  <A NAME="50930"></A></STRONG></DT>
<DD>The full path name to the <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon.
  The default location is <TT>$(SBIN)/condor_dbmsd</TT>.

<P>
<A NAME="param:DBMSDArgs"></A></DD>
<DT><STRONG><TT>DBMSD_ARGS</TT>  <A NAME="50936"></A></STRONG></DT>
<DD>Arguments to be passed to the <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon upon its invocation.
  The default arguments are <code>-f</code>.

<P>
<A NAME="param:DBMSDLog"></A></DD>
<DT><STRONG><TT>DBMSD_LOG</TT>  <A NAME="50941"></A></STRONG></DT>
<DD>Path to the <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon's log file.
  The default log location is <TT>$(LOG)/DbmsdLog</TT>.

<P>
<A NAME="param:DBMSDNotRespondingTimeout"></A></DD>
<DT><STRONG><TT>DBMSD_NOT_RESPONDING_TIMEOUT</TT>  <A NAME="50947"></A></STRONG></DT>
<DD>The length of time, in seconds, before the <SPAN  CLASS="textit">condor_master</SPAN>
  may decide that the <SPAN  CLASS="textit">condor_dbmsd</SPAN> is hung due to a lack of communication,
  potentially causing  the <SPAN  CLASS="textit">condor_master</SPAN> to kill and
  restart the <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemon.
  When the <SPAN  CLASS="textit">condor_dbmsd</SPAN> is purging or re-indexing a very large database, 
  it may not be able to communicate with the master. 
  The default is 3600 seconds, or one hour. 
  It may be advisable to increase this to several hours. 

<P>
</DD>
</DL>

<P>

<H2><A NAME="SECTION00932000000000000000"></A><A NAME="sec:Quill-Example"></A>
<BR>
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">2</SPAN> Four Usage Examples
</H2>

<P>

<OL>
<LI>Query a remote Quill daemon on <TT>regular.cs.wisc.edu</TT>
for all the jobs in the queue
<PRE>
	condor_q -name quill@regular.cs.wisc.edu
	condor_q -name schedd@regular.cs.wisc.edu
</PRE>
There are two ways to get to a Quill daemon: directly using its name as 
specified in the <TT>QUILL_NAME</TT> configuration variable, or indirectly
by querying the <SPAN  CLASS="textit">condor_schedd</SPAN> daemon using its name.
In the latter case, <SPAN  CLASS="textit">condor_q</SPAN> will detect 
if that <SPAN  CLASS="textit">condor_schedd</SPAN> daemon is being serviced by a database, and if so, directly query it.
In both cases, the IP address and port of the database server hosting the data of 
this particular remote Quill daemon can be figured out by the <TT>QUILL_DB_IP_ADDR</TT> 
and <TT>QUILL_DB_NAME</TT> variables specified in the <TT>QUILL_AD</TT>
sent by the quill daemon to the collector and in the <TT>SCHEDD_AD</TT> sent by
the <SPAN  CLASS="textit">condor_schedd</SPAN> daemon.  

<P>
</LI>
<LI>Query a remote Quill daemon on <TT>regular.cs.wisc.edu</TT> for all historical 
jobs belonging to owner einstein.
<PRE>
	condor_history -name quill@regular.cs.wisc.edu einstein
</PRE>

<P>
</LI>
<LI>Query the local Quill daemon for the average time spent in the queue 
for all non-completed jobs. 
<PRE>
	condor_q -avgqueuetime
</PRE>
The average queue time is defined as the average of
<TT>(currenttime - jobsubmissiontime)</TT> over all jobs which are neither
completed <TT>(JobStatus == 4)</TT> or removed <TT>(JobStatus == 3)</TT>.

<P>
</LI>
<LI>Query the local Quill daemon for all historical jobs completed since 
Apr 1, 2005 at 13h 00m.
<PRE>
	condor_history -completedsince '04/01/2005 13:00'
</PRE>
It fetches all jobs
which got into the 'Completed' state on or after the
specified time stamp.  It use the <SPAN  CLASS="textit">PostgreSQL</SPAN> date/time
syntax rules, as it encompasses most format options.  See
<A NAME="tex2html99"
  HREF="http://www.postgresql.org/docs/8.2/static/datatype-datetime.html">http://www.postgresql.org/docs/8.2/static/datatype-datetime.html</A>
for the various time stamp formats.

<P>
</LI>
</OL>

<P>

<H2><A NAME="SECTION00933000000000000000"></A><A NAME="sec:Quill-Security"></A>
<BR>
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">3</SPAN> Quill and Security
</H2>

<P>
There are several layers of security in Quill, some provided by Condor and
others provided by the database.  First, all accesses to the database
are password-protected.

<P>

<OL>
<LI>The query tools, <SPAN  CLASS="textit">condor_q</SPAN> and
<SPAN  CLASS="textit">condor_history</SPAN> connect to the database as user ``<SPAN  CLASS="textbf">quillreader</SPAN>''.
The password for this user can vary from one database to another and
as such, each Quill daemon advertises this password to the collector.
The query tools then obtain this password from the collector and
connect successfully to the database.  Access to the database by the
``<SPAN  CLASS="textbf">quillreader</SPAN>'' user is read-only, as this is sufficient for the
query tools.  The <SPAN  CLASS="textit">condor_quill</SPAN> daemon ensures this protected access using the sql
GRANT command when it first creates the tables in the database.  Note that
access to the ``<SPAN  CLASS="textbf">quillreader</SPAN>'' password itself can be blocked by
blocking access to the collector, a feature already supported in Condor.

<P>
</LI>
<LI>The <SPAN  CLASS="textit">condor_quill</SPAN> and <SPAN  CLASS="textit">condor_dbmsd</SPAN> daemons, on the other hand,
need read and write access to the database.
As such, they connect as user ``<SPAN  CLASS="textbf">quillwriter</SPAN>'',
who has owner privileges to the database.  Since this gives all
access to the ``<SPAN  CLASS="textbf">quillwriter</SPAN>'' user, this password cannot
be stored in a public place (such as the collector).  For this
reason, the ``<SPAN  CLASS="textbf">quillwriter</SPAN>'' password is stored in a file called
<TT>.pgpass</TT> in the Condor spool directory.
Appropriate protections on this file guarantee secure access to the database.
This file must be created and protected by the site administrator;
if this file does not exist as and where expected, the <SPAN  CLASS="textit">condor_quill</SPAN>
daemon logs an error and exits.

<P>
</LI>
<LI>The <TT>IsRemotelyQueryable</TT> attribute in the Quill ClassAd advertised
by the Quill daemon to the collector can be used by site administrators
to disallow the database from being read by all remote Condor query tools.

<P>
</LI>
</OL>

<P>

<H2><A NAME="SECTION00934000000000000000"></A><A NAME="sec:Quill-Schema"></A>
<BR>
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN> Quill and Its RDBMS Schema
</H2>

<P>

<P>
<SPAN  CLASS="textbf">Notes:</SPAN>

<UL>
<LI>The type ``timestamp(<SPAN  CLASS="textit">precision</SPAN>) with timezone'' is
abbreviated ``ts(<SPAN  CLASS="textit">precision</SPAN>) w tz.''
</LI>
<LI>The column O. Type is an abbreviation for Oracle Type.
</LI>
<LI>The column P. Type is an abbreviation for PostgreSQL Type.
</LI>
</UL>
Although the current version of Condor does not support Oracle, we
anticipate supporting it in the future, so Oracle support in this
schema document is for future reference.
<BR>
<BR>
<BR>

<P>

<H3><A NAME="SECTION00934100000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">1</SPAN> Administrative Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of currencies Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">datasource</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>Identifier of the data source.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastupdate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>Time of the last update sent to the database from the data source.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of error_sqllogs Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">logname</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Name of the SQL log file causing a SQL error.</TD>
</TR>
<TR><TD ALIGN="LEFT">host</TD>
<TD ALIGN="LEFT">varchar(50)</TD>
<TD ALIGN="LEFT">varchar(50)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The host where the SQL log resides.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastmodified</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The last modified time of the SQL log.</TD>
</TR>
<TR><TD ALIGN="LEFT">errorsql</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The SQL statement causing an error.</TD>
</TR>
<TR><TD ALIGN="LEFT">logbody</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The body of the SQL log.</TD>
</TR>
<TR><TD ALIGN="LEFT">errormessage</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The description of the error.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">INDEX:</SPAN> Index named error_sqllog_idx on (logname, host, lastmodified)</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of maintenance_log Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=245><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">eventts</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=245>Time the event occurred.</TD>
</TR>
<TR><TD ALIGN="LEFT">eventmsg</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=245>Message describing the event.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of quilldbmonitor Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=295><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">dbsize</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=295>Size of the database in megabytes.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of quill_schema_version Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=259><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">major</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=259>Major version number.</TD>
</TR>
<TR><TD ALIGN="LEFT">minor</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=259>Minor version number.</TD>
</TR>
<TR><TD ALIGN="LEFT">back_to_major</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=259>The major number of the old version this version is compatible to.</TD>
</TR>
<TR><TD ALIGN="LEFT">back_to_minor</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=259>The minor number of the old version this version is compatible to.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of throwns Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">filename</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The name of the log that was truncated.</TD>
</TR>
<TR><TD ALIGN="LEFT">machine_id</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The machine where the truncated log resides.</TD>
</TR>
<TR><TD ALIGN="LEFT">log_size</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The size of the truncated log.</TD>
</TR>
<TR><TD ALIGN="LEFT">throwtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>The time when the truncation occurred.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934200000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">2</SPAN> Daemon Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of daemons_horizontal Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">mytype</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The type of daemon ClassAd, e.g. ``Master''</TD>
</TR>
<TR><TD ALIGN="LEFT">name</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The name identifier of the daemon ClassAd.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>Time when the daemon last reported to Quill.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselftime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The time when the daemon last collected information about itself.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfcpuusage</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The amount of CPU this daemon has used.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfimagesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The amount of virtual memory this daemon has used.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfresidentsetsize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The amount of physical memory this daemon has used.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfage</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>How long the daemon has been running.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatesequencenumber</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The sequence number associated with the update.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatestotal</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The number of updates received from the daemon.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatessequenced</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The number of updates that were in order.</TD>
</TR>
<TR><TD ALIGN="LEFT">updateslost</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The number of updates that were lost.</TD>
</TR>
<TR><TD ALIGN="LEFT">updateshistory</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>Bitmask of the last 32 updates.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime_epoch</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The equivalent epoch time of last heard from.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (mytype, name)</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> mytype and name cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of daemons_horizontal_history Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">mytype</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The type of daemon ClassAd, e.g. ``Master''</TD>
</TR>
<TR><TD ALIGN="LEFT">name</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The name identifier of the daemon ClassAd.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>Time when the daemon last reported to Quill.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselftime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The time when the daemon last collected information about itself.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfcpuusage</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The amount of CPU this daemon has used.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfimagesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The amount of virtual memory this daemon has used.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfresidentsetsize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The amount of physical memory this daemon has used.</TD>
</TR>
<TR><TD ALIGN="LEFT">monitorselfage</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>How long the daemon has been running.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatesequencenumber</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The sequence number associated with the update.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatestotal</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The number of updates received from the daemon.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatessequenced</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The number of updates that were in order.</TD>
</TR>
<TR><TD ALIGN="LEFT">updateslost</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>The number of updates that were lost.</TD>
</TR>
<TR><TD ALIGN="LEFT">updateshistory</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>Bitmask of the last 32 updates.</TD>
</TR>
<TR><TD ALIGN="LEFT">endtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=166>End of when the ClassAd is valid.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of daemons_vertical Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">mytype</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>The type of daemon ClassAd, e.g. ``Master''</TD>
</TR>
<TR><TD ALIGN="LEFT">name</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>The name identifier of the daemon ClassAd.</TD>
</TR>
<TR><TD ALIGN="LEFT">attr</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">val</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Attribute value.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Time when the daemon last reported to Quill.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (mytype, name, attr)</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> mytype, name, and attr cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of daemons_vertical_history Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">mytype</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT">varchar(100)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>The type of daemon ClassAd, e.g. ``Master''</TD>
</TR>
<TR><TD ALIGN="LEFT">name</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>The name identifier of the daemon ClassAd.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Time when the daemon last reported to Quill.</TD>
</TR>
<TR><TD ALIGN="LEFT">attr</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">val</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Attribute value.</TD>
</TR>
<TR><TD ALIGN="LEFT">endtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>End of when the ClassAd is valid.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of submitters_horizontal table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">name</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Name of the submitter ClassAd.</TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Name of the schedd where the submitter ad is from.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Last time a submitter ClassAd was sent to Quill.</TD>
</TR>
<TR><TD ALIGN="LEFT">idlejobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of idle jobs of the submitter.</TD>
</TR>
<TR><TD ALIGN="LEFT">runningjobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of running jobs of the submitter.</TD>
</TR>
<TR><TD ALIGN="LEFT">heldjobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of held jobs of the submitter.</TD>
</TR>
<TR><TD ALIGN="LEFT">flockedjobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of flocked jobs of the submitter.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of submitters_horizontal_history table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">name</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT">varchar(500)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Name of the submitter ClassAd.</TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Name of the schedd where the submitter ad is from.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Last time a submitter ClassAd was sent to Quill.</TD>
</TR>
<TR><TD ALIGN="LEFT">idlejobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of idle jobs of the submitter.</TD>
</TR>
<TR><TD ALIGN="LEFT">runningjobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of running jobs of the submitter.</TD>
</TR>
<TR><TD ALIGN="LEFT">heldjobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of held jobs of the submitter.</TD>
</TR>
<TR><TD ALIGN="LEFT">flockedjobs</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>Number of flocked jobs of the submitter.</TD>
</TR>
<TR><TD ALIGN="LEFT">endtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=223>End of when the ClassAd is valid.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934300000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">3</SPAN> Files Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of files Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">file_id</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Unique numeric identifier of the file.</TD>
</TR>
<TR><TD ALIGN="LEFT">name</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>File name.</TD>
</TR>
<TR><TD ALIGN="LEFT">host</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Name of machine where the file is located.</TD>
</TR>
<TR><TD ALIGN="LEFT">path</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Directory path to the file.</TD>
</TR>
<TR><TD ALIGN="LEFT">acl_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Not yet used, null.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastmodified</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Timestamp of the file.</TD>
</TR>
<TR><TD ALIGN="LEFT">filesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Size of the file in bytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">checksum</TD>
<TD ALIGN="LEFT">varchar(32)</TD>
<TD ALIGN="LEFT">varchar(32)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>MD5 checksum of the file.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> file_id</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> file_id cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of fileusages Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Global identifier of the job that used the file.</TD>
</TR>
<TR><TD ALIGN="LEFT">file_id</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT">int</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Numeric identifier of the file.</TD>
</TR>
<TR><TD ALIGN="LEFT">usagetype</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Type of use of the file by the job, e.g., input, output, command.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">REFERENCE:</SPAN> file_id references files(file_id)</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of transfers Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Unique global identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_name</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Name of the file on the source machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_host</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Name of the source machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_port</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Source port number used for the transfer.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_path</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Path to the file on the source machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_daemon</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Condor demon performing the transfer on the source machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_protocol</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The protocol used on the source machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_credential_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Not yet used, null.</TD>
</TR>
<TR><TD ALIGN="LEFT">src_acl_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Not yet used, null.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_name</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Name of the file on the destination machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_host</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Name of the destination machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_port</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Destination port number used for the transfer.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_path</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Path to the file on the destination machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_daemon</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Condor daemon receiving the transfer on the destination machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_protocol</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The protocol used on the destination machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_credential_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Not yet used, null.</TD>
</TR>
<TR><TD ALIGN="LEFT">dst_acl_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Not yet used, null.</TD>
</TR>
<TR><TD ALIGN="LEFT">transfer_intermediary_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Not yet used, null; will use someday if a proxy is used.</TD>
</TR>
<TR><TD ALIGN="LEFT">transfer_size_bytes</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric (38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Size of the data transfered in bytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">elapsed</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of seconds that elapsed during the transfer.</TD>
</TR>
<TR><TD ALIGN="LEFT">checksum</TD>
<TD ALIGN="LEFT">varchar(256)</TD>
<TD ALIGN="LEFT">varchar(256)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Checksum of the file.</TD>
</TR>
<TR><TD ALIGN="LEFT">transfer_time</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time when the transfer took place.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_modified</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Last modified time for the file that was transfered.</TD>
</TR>
<TR><TD ALIGN="LEFT">is_encrypted</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>(boolean) True if the file is encrypted.</TD>
</TR>
<TR><TD ALIGN="LEFT">delegation_method_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Not yet used, null.</TD>
</TR>
<TR><TD ALIGN="LEFT">completion_code</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Indicates whether the transfer failed or succeeded.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934400000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">4</SPAN> Interface Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of cdb_users Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=245><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">userid</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=245>Unique identifier of the user</TD>
</TR>
<TR><TD ALIGN="LEFT">password</TD>
<TD ALIGN="LEFT">character(32)</TD>
<TD ALIGN="LEFT">character(32)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=245>Encrypted password</TD>
</TR>
<TR><TD ALIGN="LEFT">admin</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=245>(boolean) True if the user has administrator privileges</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of l_eventtype Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">eventtype</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Numeric type code of the event.</TD>
</TR>
<TR><TD ALIGN="LEFT">description</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Description of the type of event associated with the eventtype code.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of l_jobstatus Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">jobstatus</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Numeric code for job status.</TD>
</TR>
<TR><TD ALIGN="LEFT">abbrev</TD>
<TD ALIGN="LEFT">char(1)</TD>
<TD ALIGN="LEFT">char(1)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Single letter code for job status.</TD>
</TR>
<TR><TD ALIGN="LEFT">description</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Description of job status.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> jobstatus</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> jobstatus cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934500000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">5</SPAN> Jobs Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of clusterads_horizontal Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Name of the schedd the job is submitted to.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">owner</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>User who submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobstatus</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Current status of the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobprio</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Priority for this job.</TD>
</TR>
<TR><TD ALIGN="LEFT">imagesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Estimate of memory image size of the job in kilobytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">qdate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time the job was submitted to the job queue.</TD>
</TR>
<TR><TD ALIGN="LEFT">remoteusercpu</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Total number of seconds of user CPU time the job used on remote machines.</TD>
</TR>
<TR><TD ALIGN="LEFT">remotewallclocktime</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Committed cumulative number of seconds the job has been allocated to a machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">cmd</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Path to and filename of the job to be executed.</TD>
</TR>
<TR><TD ALIGN="LEFT">args</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Arguments passed to the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobuniverse</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The Condor universe used by the job.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (scheddname, cluster_id)</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> scheddname and cluster_id cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of clusterads_vertical Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Name of the schedd that the job is submitted to.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">attr</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">val</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute value.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (scheddname, cluster_id, attr)</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of jobs_horizontal_history Table - Part 1 of 3</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">scheddbirthdate</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The birth date of the schedd where the job is submitted.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">qdate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time the job was submitted to the job queue.</TD>
</TR>
<TR><TD ALIGN="LEFT">owner</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT">varchar(30)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>User who submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Unique global identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">numckpts</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of checkpoints written by the job during its lifetime.</TD>
</TR>
<TR><TD ALIGN="LEFT">numrestarts</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of restarts from a checkpoint attempted by the job in its lifetime.</TD>
</TR>
<TR><TD ALIGN="LEFT">numsystemholds</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of times Condor-G placed the job on hold.</TD>
</TR>
<TR><TD ALIGN="LEFT">condorversion</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Version of Condor that ran the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">condorplatform</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Platform of the computer where the schedd runs.</TD>
</TR>
<TR><TD ALIGN="LEFT">rootdir</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Root directory on the system where the job is submitted from.</TD>
</TR>
<TR><TD ALIGN="LEFT">iwd</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Initial working directory of the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobuniverse</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The Condor universe used by the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">cmd</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Path to and filename of the job to be executed.</TD>
</TR>
<TR><TD ALIGN="LEFT">minhosts</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Minimum number of hosts that must be in the claimed state for this job, before the job may enter the running state.</TD>
</TR>
<TR><TD ALIGN="LEFT">maxhosts</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Maximum number of hosts this job would like to claim.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobprio</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Priority for this job.</TD>
</TR>
<TR><TD ALIGN="LEFT">negotiation_user_name</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>User name in which the job is negotiated.</TD>
</TR>
<TR><TD ALIGN="LEFT">env</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Environment under which the job ran.</TD>
</TR>
<TR><TD ALIGN="LEFT">userlog</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>User log where the job events are written to.</TD>
</TR>
<TR><TD ALIGN="LEFT">coresize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Maximum allowed size of the core file.</TD>
</TR>
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Table Continues on Next Page</SPAN></SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of jobs_horizontal_history Table - Part 2 of 3</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">killsig</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Signal to be sent if the job is put on hold.</TD>
</TR>
<TR><TD ALIGN="LEFT">stdin</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The file used as stdin.</TD>
</TR>
<TR><TD ALIGN="LEFT">transferin</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>(boolean) For globus universe jobs. True if input should be transferred to the remote machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">stdout</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The file used as stdout.</TD>
</TR>
<TR><TD ALIGN="LEFT">transferout</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>(boolean) For globus universe jobs. True if output should be transferred back to the submit machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">stderr</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The file used as stderr.</TD>
</TR>
<TR><TD ALIGN="LEFT">transfererr</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>(boolean) For globus universe jobs. True if error output should be transferred back to the submit machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">shouldtransferfiles</TD>
<TD ALIGN="LEFT">varchar (4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Whether Condor should transfer files to and from the machine where the job runs.</TD>
</TR>
<TR><TD ALIGN="LEFT">transferfiles</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Depreciated. Similar to shouldtransferfiles.</TD>
</TR>
<TR><TD ALIGN="LEFT">executablesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Size of the executable in kilobytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">diskusage</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Size of the executable and input files to be transferred.</TD>
</TR>
<TR><TD ALIGN="LEFT">filesystemdomain</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Name of the networked file system used by the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">args</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Arguments passed to the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastmatchtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time when the job was last successfully matched with a resource.</TD>
</TR>
<TR><TD ALIGN="LEFT">numjobmatches</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of times the negotiator matches the job with a resource.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobstartdate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time when the job first began running.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobcurrentstartdate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time when the job's current run started.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobruncount</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of times a shadow has been started for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">filereadcount</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of read(2) calls the job made (only standard universe).</TD>
</TR>
<TR><TD ALIGN="LEFT">filereadbytes</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of bytes read by the job (only standard universe).</TD>
</TR>
<TR><TD ALIGN="LEFT">filewritecount</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of write calls the job made (only standard universe).</TD>
</TR>
<TR><TD ALIGN="LEFT">filewritebytes</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of bytes written by the job (only standard universe).</TD>
</TR>
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Table Continues on Next Page</SPAN></SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of jobs_horizontal_history Table - Part 3 of 3</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">fileseekcount</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of seek calls that this job made (only standard universe).</TD>
</TR>
<TR><TD ALIGN="LEFT">totalsuspensions</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of times the job has been suspended during its lifetime</TD>
</TR>
<TR><TD ALIGN="LEFT">imagesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Estimate of memory image size of the job in kilobytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">exitstatus</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>No longer used by Condor.</TD>
</TR>
<TR><TD ALIGN="LEFT">localusercpu</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of seconds of user CPU time the job used on the submit machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">localsyscpu</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of seconds of system CPU time the job used on the submit machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">remoteusercpu</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of seconds of user CPU time the job used on remote machines.</TD>
</TR>
<TR><TD ALIGN="LEFT">remotesyscpu</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of seconds of system CPU time the job used on remote machines.</TD>
</TR>
<TR><TD ALIGN="LEFT">bytessent</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of bytes sent to the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">bytesrecvd</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of bytes received by the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">rscbytessent</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of remote system call bytes sent to the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">rscbytesrecvd</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of remote system call bytes received by the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">exitcode</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Exit return code of the user job. Used when a job exits by means other than a signal.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobstatus</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Current status of the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">enteredcurrentstatus</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time the job entered into its current status.</TD>
</TR>
<TR><TD ALIGN="LEFT">remotewallclocktime</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Cumulative number of seconds the job has been allocated to a machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastremotehost</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The remote host for the last run of the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">completiondate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time when the job completed; 0 if job has not yet completed.</TD>
</TR>
<TR><TD ALIGN="LEFT">enteredhistorytable</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time when the job entered the history table.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (scheddname, scheddbirthdate, cluster_id, proc_id)</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> scheddname, scheddbirthdate, cluster_id, and proc_id cannot be null</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">INDEX:</SPAN> Index named hist_h_i_owner on owner</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of jobs_vertical_history Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=209><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=209>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">scheddbirthdate</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=209>The birth date of the schedd where the job is submitted.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=209>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=209>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">attr</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=209>Attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">val</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=209>Attribute value.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (scheddname, scheddbirthdate, cluster_id, proc_id, attr)</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> scheddname, scheddbirthdate, cluster_id, proc_id, and attr cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of procads_horizontal Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobstatus</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Current status of the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">imagesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Estimate of memory image size of the job in kilobytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">remoteusercpu</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Total number of seconds of user CPU time the job used on remote machines.</TD>
</TR>
<TR><TD ALIGN="LEFT">remotewallclocktime</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Cumulative number of seconds the job has been allocated to a machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">remotehost</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Name of the machine running the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Unique global identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">jobprio</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Priority of the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">args</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Arguments passed to the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">shadowbday</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The time when the shadow was started.</TD>
</TR>
<TR><TD ALIGN="LEFT">enteredcurrentstatus</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Time the job entered its current status.</TD>
</TR>
<TR><TD ALIGN="LEFT">numrestarts</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Number of times the job has restarted.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (scheddname, cluster_id, proc_id)</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> scheddname, cluster_id, and proc_id cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of procads_vertical Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">attr</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">val</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute value.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934600000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">6</SPAN> Machines Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of machines_horizontal Table - Part 1 of 2</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">machine_id</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Unique identifier of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">opsys</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Operating system running on the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">arch</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Architecture of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">state</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Condor state of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">activity</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Condor job activity on the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">keyboardidle</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of seconds since activity has been detected on any keyboard or mouse associated with the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">consoleidle</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of seconds since activity has been detected on the console keyboard or mouse.</TD>
</TR>
<TR><TD ALIGN="LEFT">loadavg</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Current load average of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">condorloadavg</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Portion of load average generated by Condor</TD>
</TR>
<TR><TD ALIGN="LEFT">totalloadavg</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>&nbsp;</TD>
</TR>
<TR><TD ALIGN="LEFT">virtualmemory</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Amount of currently available virtual memory in kilobytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">memory</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Amount of RAM in megabytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">totalvirtualmemory</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>&nbsp;</TD>
</TR>
<TR><TD ALIGN="LEFT">cpubusytime</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time in seconds since cpuisbusy became true.</TD>
</TR>
<TR><TD ALIGN="LEFT">cpuisbusy</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>(boolean) True when the CPU is busy.</TD>
</TR>
<TR><TD ALIGN="LEFT">currentrank</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The machine owner's affinity for running the Condor job which it is currently hosting.</TD>
</TR>
<TR><TD ALIGN="LEFT">clockmin</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of minutes passed since midnight.</TD>
</TR>
<TR><TD ALIGN="LEFT">clockday</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The day of the week.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time when the Condor central manager last received a status update from this machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">enteredcurrentactivity</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time when the machine entered the current activity.</TD>
</TR>
<TR><TD ALIGN="LEFT">enteredcurrentstate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time when the machine entered the current state.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatesequencenumber</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Each update includes a sequence number.</TD>
</TR>
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Table Continues on Next Page</SPAN></SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of machines_horizontal Table - Part 2 of 2</SPAN></SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">updatestotal</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The number of updates received from the daemon.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatessequenced</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The number of updates that were in order.</TD>
</TR>
<TR><TD ALIGN="LEFT">updateslost</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The number of updates that were lost.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Unique global identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime_epoch</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The equivalent epoch time of lastreportedtime.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> machine_id</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of machines_horizontal_history Table - Part 1 of 2</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">machine_id</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Unique identifier of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">opsys</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Operating system running on the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">arch</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Architecture of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">state</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Condor state of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">activity</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Condor job activity on the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">keyboardidle</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of seconds since activity has been detected on any keyboard or mouse associated with the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">consoleidle</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of seconds since activity has been detected on the console keyboard or mouse.</TD>
</TR>
<TR><TD ALIGN="LEFT">loadavg</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Current load average of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">condorloadavg</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Portion of load average generated by Condor</TD>
</TR>
<TR><TD ALIGN="LEFT">totalloadavg</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>&nbsp;</TD>
</TR>
<TR><TD ALIGN="LEFT">virtualmemory</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Amount of currently available virtual memory in kilobytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">memory</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Amount of RAM in megabytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">totalvirtualmemory</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>&nbsp;</TD>
</TR>
<TR><TD ALIGN="LEFT">cpubusytime</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time in seconds since cpuisbusy became true.</TD>
</TR>
<TR><TD ALIGN="LEFT">cpuisbusy</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT">varchar(5)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>(boolean) True when the CPU is busy.</TD>
</TR>
<TR><TD ALIGN="LEFT">currentrank</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The machine owner's affinity for running the Condor job which it is currently hosting.</TD>
</TR>
<TR><TD ALIGN="LEFT">clockmin</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Number of minutes passed since midnight.</TD>
</TR>
<TR><TD ALIGN="LEFT">clockday</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>The day of the week.</TD>
</TR>
<TR><TD ALIGN="LEFT">lastreportedtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time when the Condor central manager last received a status update from this machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">enteredcurrentactivity</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time when the machine entered the current activity.</TD>
</TR>
<TR><TD ALIGN="LEFT">enteredcurrentstate</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Time when the machine entered the current state.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatesequencenumber</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=173>Each update includes a sequence number.</TD>
</TR>
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Table Continues on Next Page</SPAN></SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of machines_horizontal_history Table - Part 2 of 2</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=194><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">updatestotal</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=194>The number of updates received from the daemon.</TD>
</TR>
<TR><TD ALIGN="LEFT">updatessequenced</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=194>The number of updates that were in order.</TD>
</TR>
<TR><TD ALIGN="LEFT">updateslost</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=194>The number of updates that were lost.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=194>Unique global identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">end_time</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=194>The end of when the ClassAd is valid.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of machines_vertical Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">machine_id</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Unique identifier of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">attr</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT">varchar(2000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">val</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute value.</TD>
</TR>
<TR><TD ALIGN="LEFT">start_time</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Time when this attribute-value pair became valid.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> (machine_id, attr)</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> machine_id and attr cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of machines_vertical_history Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">machine_id</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Unique identifier of the machine.</TD>
</TR>
<TR><TD ALIGN="LEFT">attr</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">val</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Attribute value.</TD>
</TR>
<TR><TD ALIGN="LEFT">start_time</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Time when this attribute-value pair became valid.</TD>
</TR>
<TR><TD ALIGN="LEFT">end_time</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Time when this attribute-value pair became invalid.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934700000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">7</SPAN> Matchmaking Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of matches Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">match_time</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>Time the match was made.</TD>
</TR>
<TR><TD ALIGN="LEFT">username</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>User who submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>Name of the schedd that the job is submitted to.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>Unique global identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">machine_id</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>Identifier of the machine the job matched with.</TD>
</TR>
<TR><TD ALIGN="LEFT">remote_user</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>User that was preempted.</TD>
</TR>
<TR><TD ALIGN="LEFT">remote_priority</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT">real</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=216>The preempted user's priority.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of rejects Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">reject_time</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Time when the job was rejected.</TD>
</TR>
<TR><TD ALIGN="LEFT">username</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>User who submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Unique global identifier for the job.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934800000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">8</SPAN> Runtime Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of events Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Global identifier of the job that generated the event.</TD>
</TR>
<TR><TD ALIGN="LEFT">run_id</TD>
<TD ALIGN="LEFT">numeric(12,0)</TD>
<TD ALIGN="LEFT">numeric(12,0)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Identifier of the run that the event is associated with.</TD>
</TR>
<TR><TD ALIGN="LEFT">eventtype</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Numeric type code of the event.</TD>
</TR>
<TR><TD ALIGN="LEFT">eventtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Time the event occurred.</TD>
</TR>
<TR><TD ALIGN="LEFT">description</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Description of the event.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of generic_messages Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">eventtype</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>The type of event.</TD>
</TR>
<TR><TD ALIGN="LEFT">eventkey</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>The key of the event.</TD>
</TR>
<TR><TD ALIGN="LEFT">eventtime</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>The time of the event.</TD>
</TR>
<TR><TD ALIGN="LEFT">eventloc</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>The location of the event.</TD>
</TR>
<TR><TD ALIGN="LEFT">attname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>The attribute name.</TD>
</TR>
<TR><TD ALIGN="LEFT">attval</TD>
<TD ALIGN="LEFT">clob</TD>
<TD ALIGN="LEFT">text</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>The attribute value.</TD>
</TR>
<TR><TD ALIGN="LEFT">attrtype</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=238>The attribute type.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of runs Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">run_id</TD>
<TD ALIGN="LEFT">numeric(12)</TD>
<TD ALIGN="LEFT">numeric(12)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Unique identifier of the run.</TD>
</TR>
<TR><TD ALIGN="LEFT">machine_id</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Identifier of the machine where the job ran.</TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">spid</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Subprocess identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Identifier of the job that was run.</TD>
</TR>
<TR><TD ALIGN="LEFT">startts</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Time when the job started.</TD>
</TR>
<TR><TD ALIGN="LEFT">endts</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT">ts(3) w tz</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Time when the job ended.</TD>
</TR>
<TR><TD ALIGN="LEFT">endtype</TD>
<TD ALIGN="LEFT">smallint</TD>
<TD ALIGN="LEFT">smallint</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>The type of ending event.</TD>
</TR>
<TR><TD ALIGN="LEFT">endmessage</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>The ending message.</TD>
</TR>
<TR><TD ALIGN="LEFT">wascheckpointed</TD>
<TD ALIGN="LEFT">varchar(7)</TD>
<TD ALIGN="LEFT">varchar(7)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Whether the run was checkpointed.</TD>
</TR>
<TR><TD ALIGN="LEFT">imagesize</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>The image size of the executable.</TD>
</TR>
<TR><TD ALIGN="LEFT">runlocalusageuser</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>The time the job spent in usermode on execute machines (only standard universe).</TD>
</TR>
<TR><TD ALIGN="LEFT">runlocalusagesystem</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>The time the job was in system calls.</TD>
</TR>
<TR><TD ALIGN="LEFT">runremoteusageuser</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>The time the shadow spent working for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">runremoteusagesystem</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>The time the shadow spent in system calls for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">runbytessent</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Number of bytes sent to the run.</TD>
</TR>
<TR><TD ALIGN="LEFT">runbytesreceived</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=180>Number of bytes received from the run.</TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">PRIMARY KEY:</SPAN> run_id</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT" COLSPAN=4><SPAN><SPAN  CLASS="textbf">NOT NULL:</SPAN> run_id cannot be null</SPAN></TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>

</DIV>

<P>

<H3><A NAME="SECTION00934900000000000000">
<SPAN CLASS="arabic">8</SPAN>.<SPAN CLASS="arabic">3</SPAN>.<SPAN CLASS="arabic">4</SPAN>.<SPAN CLASS="arabic">9</SPAN> System Tables</A>
</H3>
<DIV ALIGN="CENTER">
<TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of dummy_single_row_table Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=288><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">a</TD>
<TD ALIGN="LEFT">varchar(1)</TD>
<TD ALIGN="LEFT">varchar(1)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=288>A dummy column.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of history_jobs_to_purge Table</SPAN></SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">cluster_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Cluster identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">proc_id</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Process identifier for the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">globaljobid</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=230>Unique global identifier for the job.</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</DIV>
<P>
<DIV ALIGN="CENTER"><TABLE CELLPADDING=3 BORDER="1">
<TR><TD ALIGN="CENTER" COLSPAN=4><SPAN><SPAN  CLASS="textbf">Attributes of jobqueuepollinginfo Table</SPAN></SPAN></TD>
</TR>
<TR><TH ALIGN="LEFT"><SPAN  CLASS="textbf">Name</SPAN></TH>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">O. Type</SPAN></TD>
<TD ALIGN="LEFT"><SPAN  CLASS="textbf">P. Type</SPAN></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187><SPAN  CLASS="textbf">Description</SPAN></TD>
</TR>
<TR><TD ALIGN="LEFT">scheddname</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>Name of the schedd that submitted the job.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_file_mtime</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last modification time of the file.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_file_size</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT">numeric(38)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last size of the file in bytes.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_next_cmd_offset</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last offset for the next command.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_cmd_offset</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT">integer</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last offset of the current command.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_cmd_type</TD>
<TD ALIGN="LEFT">smallint</TD>
<TD ALIGN="LEFT">smallint</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last type of command.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_cmd_key</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last key of the command.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_cmd_mytype</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last my ClassAd type of the command.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_cmd_targettype</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The last target ClassAd type.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_cmd_name</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The attribute name of the command.</TD>
</TR>
<TR><TD ALIGN="LEFT">last_cmd_value</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT">varchar(4000)</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH=187>The attribute value of the command.</TD>
</TR>
</TABLE>
</DIV>

<P>

<P>
<A NAME="51763"></A>

<DIV CLASS="navigation"><HR>
<!--Navigation Panel-->
<A NAME="tex2html2455"
  HREF="8_4_CondorView_Client.html">
<IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A> 
<A NAME="tex2html2449"
  HREF="8_Contrib_Source.html">
<IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A> 
<A NAME="tex2html2443"
  HREF="8_2_Using_Condor.html">
<IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A> 
<A NAME="tex2html2451"
  HREF="Contents.html">
<IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A> 
<A NAME="tex2html2453"
  HREF="Index.html">
<IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="index.png"></A> 
<BR>
<B> Next:</B> <A NAME="tex2html2456"
  HREF="8_4_CondorView_Client.html">8.4 The CondorView Client</A>
<B> Up:</B> <A NAME="tex2html2450"
  HREF="8_Contrib_Source.html">8. Contrib and Source</A>
<B> Previous:</B> <A NAME="tex2html2444"
  HREF="8_2_Using_Condor.html">8.2 Using Condor with</A>
 &nbsp; <B>  <A NAME="tex2html2452"
  HREF="Contents.html">Contents</A></B> 
 &nbsp; <B>  <A NAME="tex2html2454"
  HREF="Index.html">Index</A></B> </DIV>
<!--End of Navigation Panel-->
<ADDRESS>
condor-admin@cs.wisc.edu
</ADDRESS>
</BODY>
</HTML>
condor-doc 7.8.2~dfsg.1-1+deb7u3 / usr / share / doc / condor / html / 8_3_Quill.html
