Using the logDevice Property

To specify a non-default location for the log directory, set the logDevice attribute on the database connection URL when you create the database. (This attribute is meaningful only when you are creating a database.) You can specify logDevice as either an absolute path or a path relative to the directory where the JVM is being executed.

Setting logDevice on the database connection URL adds an entry to the service.properties file. If you ever move the log manually, alter the entry in service.properties. If you move the log back to the default location, remove the logDevice entry from service.properties.

To check the log location for an existing database, you can retrieve the logDevice attribute as a database property. Issue the following statement:

VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')