Home
Global Commands Listing
vovsql_load_jobs
Load job-logs into the SQL database. Useful also to merge the data from multiple sites (or multiple clusters). The name of the site should preferably be short.

Welcome
Global Commands Listing
- clevercopy
- cleverrename
- ftlm_accounts
  Utility to show and manage user project and custom group definitions.
- ftlm_batch_report
- ftlm_capacity
  Manages feature capacity information in the Monitor database.
- ftlm_check_db
  Perform validation of the Monitor database. User tests are for PostgreSQL and MySQL only and cannot be combined with other options.
- ftlm_data_gen
- ftlm_demo
- ftlm_deobfuscate
  Utility to deobfuscate and load checkouts that have been obfuscated by Monitor during situations where the product license was either unavailable, exceeded, or expired.
- ftlm_feature_admin
- ftlm_forecast
  This utility supports a table used to capture the forecast requirement based on a feature, account, or monthly basis. The forecast, if available, can be plotted together with usage and capacity.
- ftlm_gen_productdef
  Extract information from a supported vendor's license file to create a product/feature map.
- ftlm_html2pdf
- ftlm_licmgr_init
  Initialize the licmgr/current directory for Monitor. This is the directory where copies of the active licenses are stored. This script is normally called automatically by ftlm_licmgr.cgi.
- ftlm_lmproject
  A utility to capture the value of LM_PROJECT on the current host, for the current user.
- ftlm_merge_origins
- ftlm_migrate_db
- ftlm_parse_beta
- ftlm_parse_clearcase
- ftlm_parse_codemeterlog
  Parses and loads checkouts found in a Code Meter debug log.
- ftlm_parse_debuglog
  Parses and loads denials, and optionally checkouts, found in a FlexNet debug log.
- ftlm_parse_dsls
- ftlm_parse_dslslog
  Parses and loads denials, and optionally checkouts, found in a Dassault DSLS debug log.
- ftlm_parse_elan
  Executes the Elan license status command and parses its output to discover capacity and utilization information so that it can be recorded into server memory.
- ftlm_parse_flexlm
- ftlm_parse_flexlmlic
- ftlm_parse_flexlmoptions
  A parser to track the change of FlexNet Publisher License option files.
- ftlm_parse_ghs
- ftlm_parse_gns
- ftlm_parse_hasp
- ftlm_parse_icad
  A script to parse the output of Fujitsu's ICAD license manager. This license manager is known to output unsupported 2-byte characters (namely, Japanese characters). If parsing such an instance, a wrapper script will need to be used that converts these characters to ASCII characters.
- ftlm_parse_lmx
- ftlm_parse_lstc
- ftlm_parse_lum
- ftlm_parse_lum_denials
  Parse a LUM report for denial events.
- ftlm_parse_mathlm
- ftlm_parse_olicense
- ftlm_parse_qftest
- ftlm_parse_rlmstat
- ftlm_parse_rtdakey
  A parser to track the usage of VOV Key Licenses.
- ftlm_parse_sentinel
- ftlm_parse_silvaco
- ftlm_parse_slotsconsumption
  A parser to track the usage of slots in Accelerator. Assumes that vovslotconsumptiond is running. This parser read the property SLOTS_CONSUMPTION.
- ftlm_parse_tsystems
- ftlm_summary
  Compute summary tables.
- ftlm_tag_admin
  Manage tags in the Monitor database.
- hemgr
- hemgr_start
- hero reserve
  Create a reservation on an emulator.
- lamgr
  Altair Allocator Manager.
- lm_parse_remotelm
  Utility that will obtain and load data from a remote Monitor instance into a local instance.
- lmmgr
  Altair Monitor management script. Execute on the server. Some commands require enablement by first typing "vovproject enable licmon". If a project name other than licmon is used, use that name instead.
- nc
  Submit, query, and stop jobs. This command can also be invoked as vnc.
- nc clean
  This command cleans up obsolete log files and environment files that have been generated by jobs submitted to the scheduler.
- nc cmd
- nc debug
  Debug a problem.
- nc forget
  Forget jobs from the trace.
- nc getfield
  Get one or all fields of one or more NC jobs. Specify the jobID or use '!' for the most recent job in the current working directory.
- nc gui
  Show a grid view of the jobs in a specified set.
- nc hosts
  Show hosts in the farm. The hosts are also called taskers or vovtaskers.
- nc info
  Get information about a specific job or list of jobs.
- nc jobclass
  List classes defined for job submission
- nc list
  List jobs currently in the system.
- nc modify
  Modify scheduled jobs
- nc preempt
  Preempt the specified running jobs.
- nc rerun
  Rerun jobs already in the system.
- nc run
- nc taskerlist
  Support tasker lists. Tasker lists are named, ordered lists of taskers.
- nc stop
  Stop jobs.
- nc summary
  Get a summary report for all of my jobs.
- nc wait
  Wait for a specific job or list of jobs to complete, fail, or be forgotten.
- nc why
  Show why a job is in the state it is.
- ncmgr
  This program manages the vovserver for Accelerator.
- ncmgr cm
  ncmgr cm is a utility for performing configuration management actions.
- ncmgr rehost
- ncmgr reset
- ncmgr start
- ncmgr stop
  Shut down an Accelerator queue.
- vls
  Display information about the files. By default, all files in the current working directory are listed.
- vovacl
- vovautostart
  Execute the scripts in the *.swd/autostart directory.
- vovautostop
  Execute the scripts in the *.swd/autostop directory.
- vovauxpasswd
  Store a VOV or Windows password for one or more projects.
- vovblast
  Forget files from the trace AND DELETE THEM from the disk. The files must be specified by name. Each file argument is interpreted as a regular expression. All dependent nodes are invalidated.
- vovbuild
- vovcheck
  Basic check of configuration of VOV installation, configuration, and project setup.
- vovcheckfiles
  Check the timestamp of all files in a project. This is an expensive operation, so this script implements a semaphore to avoid concurrent checks.
- vovcleandir
  Clean up directories of all UNKNOWN files.
- vovcleanup
  Cleanup log files in host and project directory.
- vovcompresslog
- vovcone
  Apply a set of up-cone and down-cone operations starting from one or more jobs or files.
- vovconsole
- vovcrontab
  Interface to the UNIX utility crontab.
- vovdaemonmgr
  This is the command to show the status of daemons. You can also use this command to start/stop the daemons.
- vovdb_util
  Utilities for use with the VOV database.
- vovemulmgr
- vovenvcapture
  Capture the SNAPSHOT environment into a file or add it as a property to an object.
- voveventmon
  A utility to show the event stream.
- vovexport
  Generates a file in FDL (i.e. Tcl), C-Shell, or Makefile syntax from a subset of the trace.
- vovfiler_setup
  A utility to manage storage configuration items.
- vovfilerd
  A daemon to monitor filers and control Filer:XXX Resources
- vovfilerdgui
- vovfileready
- vovflowcompiler
  Generate a .pp file from a flow description in Tcl.
- vovforget
  Forget objects from the project's vovserver. The objects are typically nodes (files or jobs) and are passed by VovId or by file name. The objects may also be users, sets, or selected by option.
- vovfosterjob
- vovfsgroup
  Create, show, and modify attributes of FairShare groups. The script also controls Access Control Lists (ACL) for FairShare groups.
- vovfsprobe
  Probe to calculate latency and free space in a file system.
- vovgetflexlmdaemons
  In some situations, using other methods to set the LM_VAR_NAME variable on the fly may be preferred. The utility vovgetflexlmdaemons can be used to locate the daemons that need to be used based on the resources grabbed by Accelerator at dispatch time.
- vovgetnetinfo
  The program vovgetnetinfo is used with Accelerator and Monitor to fill in information about the hosts. vovgetnetinfo is to be run periodically from the scripts created by the vovcrontab command.
- vovinfo
  A utility related to vovgetnetinfo is vovinfo, which performs the same function as vovsh -s netinfo, but with a smaller binary. This binary can only get host and process information, and does not have Tcl/TK or the VTK API.
- vovinvalidate
  Invalidate nodes in the dependency graph. The objects are typically files or jobs, which are passed by VovId or by file name, and sets, which are passed by name.
- vovisilond
  A daemon to monitor Isilon filers and control Accelerator resources.
- vovkill
  This utility is used to kill processes.
- vovlad
  The main Allocator daemon used as part of the Allocator product to allocate licenses across multiple Accelerator sites and multiple LSF clusters.
- vovldap_query
  Utility to perfom LDAP lookups.
- vovldap_setup
  A utility to manage certain LDAP integration configuration items.
- vovldap_update_memberships
  This utility queries an LDAP server to look up configured user attributes that are used to define group memberships in the Monitor database.
- vovlicensemgr
- vovliveness
  This script is called by vovserver about once a minute. It can be used to perform maintenance tasks.
- vovlmremove
  This utility removes all the license features associated with the given job.
- vovlogchecker
  This script is normally call by the wrapper da_job which refers to the property SCRIPT_POST.
- vovloghandler
- vovlsf_lsbevent_to_jobs
- vovmake
  This is a script used to convert makefiles into FlowTracer flows.
- vovmemtime
  vovmemtime is a utility to create simulated workloads. When this program runs, it occupies a specified amount of memory and creates high CPU utilization for the requested amount of time, to simulate the activity of real design programs running.
- vovmetric
  Manipulate VOV metrics. Metrics are organized by family. Available families are design (1), server (2), and FairShare (4).
- vovnetappd
  A daemon to monitor NetApp filers and control Accelerator resources.
- vovnis_update_memberships
  This utility queries NIS to look up group members that are used to define group memberships in the Monitor database.
- vovpreemptd
  Main preemption daemon, based on the C++ implementation of preemption.
- vovpreemptmethod
  Specify which method to use for each resource this is used by the preempted job.
- vovpreemptrule
- vovprocessmgr
  Get information about and manage processes on hosts where an Altair Engineering vovtasker is running, for example, in Accelerator.
- vovproject
  The vovproject tool is used to manage a VOV project.
- vovprop
  Get, set, delete, and show properties on objects.
- vovps
  vovps lists all processes, similar to the UNIX command ps. It is useful to understand the process hierarchy of Accelerator jobs, and sometimes to find which PIDs to kill in a shell.
- vovreadlicutil
- vovreconciled
  vovreconciled is a daemon that detects "requested/not_used" resources for running jobs and removes them from the "grabbed resources" list after a certain amount of time, called "RevocationDelay"
- vovremove
  Remove files intelligently, considering the role of the file in the design flow, the size of the file, and the time it takes to generate the file. This operation works only for data in the FILE database.
- vovrename
- vovresgrab
  vovresgrab is used in conjunction with vovresreq to request resources on the fly. This utility is not meant to be invoked by the user, but only by vovresreq.
- vovresourcemgr
  vovresourcemgr is a utility for managing VOV resource maps. It may be used to create, modify, forget, and reserve resource maps.
- vovresreq
  This utility creates a job for tool vovresgrab.
- vovsearchlog
  Search log files.
- vovsecurity
  This program provides security key pair management functions for VOV.
- vovselect
  Utility to query vovserver data.
- vovserver
- vovserverdir
- vovservermgr
- vovset
  Perform basic operations on sets of nodes.
- vovsh
  The common use of vovsh is to execute a Tcl script which contains the Tcl extensions provided by Altair Accelerator.
- vovshow
  Show various types of objects in a VOV project, as well as documentation.
- vovsignfile
  Utility to obtain a security signature for files.
- vovsim getpeakusage
- vovsim_getresmaps
  Output a snapshot of an Accelerator's SW configuration to STDOUT.
- vovsim gettaskers
  Output a snapshot of an Accelerator's HW configuration to STDOUT.
- vovsim getsummary
  From the database of all jobs (e.g. sq3/jobs.sq3), get a summary report with statistics on wait times, duration, etc. The time interval defined by the -start and -end options restrict the statistics to the jobs that have been SUBMITTED in the given interval.
- vovsim scenario
- vovsim_sq3_to_jobs
- vovsim_workload_editor
  Make a copy of a SQlite database and modify its contents by duplicating and eliminating jobs based on timestamp, duration, user, and project.
- vovsql_create_tables_prediction
  Creates Monitor database schema using the database settings specified in licmon.swd/db/config.tcl. Settings can be overridden with options.
- vovsql_load_checkouts
- vovsql_load_denials
- vovsql_load_jobs
  Load job-logs into the SQL database. Useful also to merge the data from multiple sites (or multiple clusters). The name of the site should preferably be short.
- vovsql_record_one_job
  Records prediction information on one job into the FlowTracer sql database as it is running.
- vovstop
  Stop a list of objects. The jobs are normally descheduled, but if the -f (-force) option is used, then also running jobs are stopped.
- vovtasker
- vovtaskerlist
  Manipulate tasker lists.
- vovtaskermgr
- vovtaskerowner
- vovtestsocket
  Test vovserver socket connectivity.
- vovtouch
  Toggles the status of the given nodes twice, so that each node passes through a state of being INVALID.
- vovtsd
  This utility listens for requests to launch taskers for various projects, but always for the same user. The requests typically come from vovtaskermgr.
- vovusergroup
  Utility to show, create and maintain "vovusergroup" structures based on user lists, UNIX groups and LDAP groups.
- vovversion
  Print the VOV version. Optionally show more details.
- vovwait4server
  Wait for VOVserver port numbers to be determined and ready for connections.
- vovworkflowsim
- vovwxconnect
  Utility to setup a connector for Accelerator Plus to a primary queue.
- vsc
  This scripts performs "Impact Analysis" with VOV.
- vsh
  Show history of files in the dependency graph.
- vsi
  Print basic information about a project. Also useful to test whether a vovserver is running or not.
- vsm
  Monitor activity in VOV.
- vsr
  Retrace a list of files and directories. Use option -set to retrace sets of nodes.
- vst
  Show the jobs that have been executed in one or more directories. By default, vst looks at the current directory and shows only the jobs with same environment as the current one.
- vsx
  Show the inputs and outputs of nodes in the trace.
- vsy
  Analyze job status reasons.
- vsz
  Zap away problematic nodes.
- vtool
- wx
- wx clean
  This command cleans up obsolete log files and environment files that have been generated by jobs submitted to the scheduler.
- wx debug
  If a job appears to behave differently when executed by WX than when it runs without using WX, you can use this command to debug the problem.
- wx forget
- wx getfield
  Get one or all fields of one or more WX jobs.
- wx gui
  Show a grid view of the jobs in a specified set.
- wx hosts
  Show hosts in the farm. The hosts are also called taskers or vovtaskers.
- wx info
  Get information about a specific job or list of jobs.
- wx jobclass
  List classes defined for job submission
- wx list
  List jobs currently in the system.
- wx modify
  Enables modifying fields in the scheduled jobs.
- wx preempt
- wx rerun
- wx run
- wx taskerlist
- wx stop
- wx summary
  Get a summary report for all of my jobs.
- wx wait
- wxmgr
  This program manages the vovserver for Accelerator Plus.
- wxmgr cm
- wxmgr_start

View All Altair Accelerator Help

vovsql_load_jobs

Load job-logs into the SQL database. Useful also to merge the data from multiple sites (or multiple clusters). The name of the site should preferably be short.


vovsql_load_jobs: Usage Message

DESCRIPTION:
    Load job-logs into the SQL database.  Useful also to merge
    the data from multiple sites (or multiple clusters).
    The name of the site should preferably be short.

USAGE:
    % vovsql_load_jobs [OPTIONS] <listOfJobsLogs>

OPTIONS:
    -db               -- Override DB selection
    -force            -- Force loading of log files
    -site <NAME>      -- Specify a name of a site
    -notools          -- Disable processing of toolnames.
                         The toolname is normally the tail of the first
                         argument of a command. In some sites, the tools
                         are auto-generated and are unique for each
                         command, so that they have no meaning but cause
                         a tremendous overhead.
    -v                -- Increase verbosity
    -q                -- Quiet verbosity

EXAMPLES:
    % vovsql_load_jobs ./jobs/2009*
    % vovsql_load_jobs -site rome ./jobs/2009*
    % vovsql_load_jobs -db ./jobs.sq3 jobs.log
    % vovsql_load_jobs -notools  jobs.log