Viewing or Modifying Database Properties

View editable and non-editable properties for the database.

Prerequisites

Database Version	Database Privileges
SAP Sybase IQ 15.3 and 15.4	View database license management property page – you must have EXECUTE permission on the sp_iqlmconfig system procedure to display the content of the page. View any other database property page – none. Modify the following properties on the Settings page - You must have: Include SQL statement information option – you must have EXECUTE permission on the sa_server_option system procedure to modify this setting. Collect Information about deadlocks option – you must have DBA authority. Clear Deadlock Information Now option – you must have DBA authority. Modify any other database property – you must have DBA authority.
SAP Sybase IQ 16.0	View database license management property page – you must have EXECUTE permission on the sp_iqlmconfig system procedure along with the SERVER OPERATOR system privilege to display the content of the page. View any other database property page – none. Modify the following properties on the Settings page: Refresh button – you must have the SERVER OPERATOR or ALTER DATABASE system privilege. Collect Information about deadlocks option – you must have the SET ANY SYSTEM OPTION system privilege. Include SQL statement information option – you must have EXECUTE permission on the sa_server_option system procedure along with the SERVER OPERATOR system privilege to modify this setting. Clear Deadlock Information Now option – you must have the SERVER OPERATOR system privilege. Modify properties on the license management page – you must have the SERVER OPERATOR system privilege.

Database Version

Database Privileges

SAP Sybase IQ 15.3 and 15.4

View database license management property page – you must have EXECUTE permission on the sp_iqlmconfig system procedure to display the content of the page.

View any other database property page – none.

Modify the following properties on the Settings page - You must have:

Include SQL statement information option – you must have EXECUTE permission on the sa_server_option system procedure to modify this setting.
Collect Information about deadlocks option – you must have DBA authority.
Clear Deadlock Information Now option – you must have DBA authority.

Modify any other database property – you must have DBA authority.

SAP Sybase IQ 16.0

View database license management property page – you must have EXECUTE permission on the sp_iqlmconfig system procedure along with the SERVER OPERATOR system privilege to display the content of the page.

View any other database property page – none.

Modify the following properties on the Settings page:

Refresh button – you must have the SERVER OPERATOR or ALTER DATABASE system privilege.
Collect Information about deadlocks option – you must have the SET ANY SYSTEM OPTION system privilege.
Include SQL statement information option – you must have EXECUTE permission on the sa_server_option system procedure along with the SERVER OPERATOR system privilege to modify this setting.
Clear Deadlock Information Now option – you must have the SERVER OPERATOR system privilege.

Modify properties on the license management page – you must have the SERVER OPERATOR system privilege.

The SAP Sybase IQ resource is authenticated and running.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects, and then select Databases.
Select the database from the right pane and either:
- Click the drop-down arrow to the right of the name and select Properties, or,
- From the Administration Console menu bar, select Resource > Properties.
The Database Properties view appears.

View or modify the properties.

When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
If you do not have privileges to modify properties, SAP Control Center displays the properties view in read-only mode.

Area	Description
General (Read-only)	Database – Name of the database. ID – A unique number assigned by the server to each database that is started on it. The ID number lets you distinguish between databases running on the same server. Capability ID – The capability bits enabled for the database. You can view a list of the capabilities that are enabled for the database on the Extended Information tab of the Database property sheet. Java location – Path to the JRE executable file. Java main user ID – The main Java user ID. Page size – Page size of the database, in bytes. Database file – Root database file for the database. Log file – Name and location of the transaction log file for the database. Mirror log file – Name and location of the mirror log file for the database. Temporary file – Location of the temporary database file. Current user – User ID of the user connected to the database. Connection ID – Connection ID for the database connection from SAP Control Center. Connection name – Connection name for the user connected to this database. Naming your connections allows multiple connections to the same database, or multiple connections to the same or different database server, to be easily identified. Communication link – Type of communications link used by the user's connection. If the connection is between a client and network server, the link type represents the network protocol being used. Total connections – Total number of current connections to the database from all users, including the SAP Control Center connection. (16.0 only) System procedure security model – The security model under which privileged system procedures execute. Valid values are: Invoker – all privileged system procedures run with the privileges of the person executing the procedure (invoker). Definer – All pre-16.0 privileged system procedures run with the privileges of the owner of the procedure (definer). All privileged system procedures introduced in 16.0 (or later) run with the privileges of the invoker.
Settings (Read-only)	Encryption type – Type of database encryption: Simple or AES. If encryption is not supported in the database, the value is None. Encryption scope – Scope of the encryption. Ignore trailing blanks – Database ignores trailing blanks in comparisons. CHAR collation sequence – Set of separators for the collation sequence of CHAR values. CHAR collation character set encoding – Character set used for CHAR values. CHAR case sensitivity – CHAR values in the database are case-sensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers. NCHAR collation sequence – Separators for the collation sequence of NCHAR values. NCHAR collation character set encoding – Character set used for NCHAR values. NCHAR case sensitivity – NCHAR values in the database are case-sensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers. Checkpoint urgency(%) – Time elapsed since the last checkpoint as a percentage of the checkpoint time setting of the database. Recovery urgency(%) – An estimate of the amount of time required to recover the database. Refresh –Update the checkpoint urgency and recovery urgency values. Collect information about deadlocks that occur in this database – Information is collected on deadlocked connections to the database. Include SQL statement information for deadlocked connections – SQL statement information is included with the deadlock connection information. Clear deadlock information now – Remove all deadlock information from the system.
Database Properties (Read-only)	A list of all database properties, including the property value and the description of the property.
License management	A list the name and value of the properties for the various licenses.

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.