Sun Grid Engine Information Center
Accounting and Reporting Console (ARCo)
Index

ARCo Frequently-Asked Questions (FAQ)

Do I need to re-install database server and create new database every time I update/upgrade ARCo?

No. Generally, you want to keep inserting the data in the same database. You just need to re-install dbwriter and Reporting software and during the installation supply your existing database parameters. If a newer version of database model is available, your existing ARCo database model will be updated during the installation of dbwriter. See Upgrading ARCo.

Can I restore database backup into a database already containing data?

No. A database backup must only be restored into an empty database. Because ARCo database is a relational database, there are primary key constrains defined on tables. You would run into and SQL error if a primary key (unique identifier), you are trying to restore, already exists in the database.

How do I change the debug level of the dbwriter?

You specify the debug level during the installation of dbwriter.

To change the debug level:

1. Stop the dbwriter.

   $SGE_ROOT/$SGE_CELL/common/sgedbwriter stop
   

   
   

2. Edit the dbwriter configuration file ($SGE_ROOT/$SGE_CELL/common/dbwriter.conf).

   #
   # Debug level
   # Valid values: WARNING, INFO, CONFIG, FINE, FINER, FINEST, ALL
   #
   DBWRITER_DEBUG=INFO
   

   
   

3. Start the dbwriter.

   $SGE_ROOT/$SGE_CELL/common/sgedbwriter stop
   

In general, you should use the default debug level, which is info. If you use a more verbose debug level, you substantially increase the amount of data output by dbwriter.

You can specify the following debug levels:

• WARNING – Displays only severe errors and warnings.
• INFO – Adds a number of informational messages. INFO is the default debug level.
• CONFIG – Gives additional information that is related to dbwriter configuration, for example, about the processing of rules.
• FINE – Produces more information. If you choose this debug level, all SQL statements run by dbwriter are outputted.
• FINER – For debugging.
• FINEST – For debugging.
• ALL – For debugging, displays information for all levels.

How do I verify the version of the installed ARCo database model?

With Sun Grid Engine 6.1 the table sge_version was introduced. This table contains the installed versions of the ARCo database model.

Connect to your database, and as a superuser or the owner of the database objects issue an SQL command:

SELECT * FROM sge_version;