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 – Requires EXECUTE permission on the sp_iqlmconfig system procedure to display content of page.

View any other database property page – None required.

Modify the following properties on the Settings page requires:
  • Include SQL statement information option – Requires EXECUTE permission on the sa_server_option system procedure to modify this setting.
  • Collect Information about deadlocks option – Requires DBA authority.
  • Clear Deadlock Information Now option – Requires DBA authority.

Modify any other database property – Requires DBA authority.
SAP Sybase IQ 16.0
View database license management property page –
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sp_iqlmconfig system procedure to display content of page.
  • If the system procedure security model* of the selected database is set to Invoker, you require the SERVER OPERATOR system privilege to display content of page.

View any other database property page – None required.

Modify the following properties on the Settings page requires:
  • Refresh button – Requires SERVER OPERATOR or ALTER DATABASE system privilege.
  • Collect Information about deadlocks option – Requires SET ANY SYSTEM OPTION system privilege.
  • Include SQL statement information option –
    • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_server_option system procedure to modify this setting.
    • If the system procedure security model* of the selected database is set to Invoker, you require the SERVER OPERATOR system privilege to display content of page.
  • Clear Deadlock Information Now option – Requires SERVER OPERATOR system privilege.
Modify properties on the license management page –
  • Requires SERVER OPERATOR system privilege.
*The system procedure security model of the selected database appears on the General page of database properties.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console, select IQ Servers > Schema Objects > Databases.
  3. 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.
  4. View or modify the properties.
    • When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
    • If you do not have privileges to modify properties, Sybase 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 Sybase 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 Sybase 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.
  5. Click OK.
Parent topic: Databases
Related tasks
Creating a Database
Creating a Database Using a CSV File
Setting Database Options
Authenticating a Login Account for a Managed Resource
Related reference
Database Privilege Summary