Home Home Screenshots Download Documentation Contact Licensing Licensing

Documentation: Aqua Data Studio 6.0 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Sybase IQ
  VII. Informix
  VIII. PostgreSQL
  IX. MySQL
  Memory Configuration
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser and Scripting
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Key Mappings
  VI. Custom Keymap Profiles
  VII. Options
  VIII. Settings
  Query Window
  I. Basics
  II. Toolbar
  III. Server Side Comments
  IV. SQL Automation
  V. Variable Binding
  VI. Results
  VII. Save Results
  VIII. Auto-completion
  IX. SQL Formatter
  X. Permissions
  XI. Parameterized
  Editors
  I. SQL Editor
  II. Text Editor
  III. HTML Editor
  IV. XML Editor
  V. Regular Expressions
  Image Viewer
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure/Package Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool
  VII. Execution Monitor
  Difference Tools
  I. Schema Diff
  II. Tab Diff
  III. Directory Diff
  IV. File Diff
  V. Copy History Diff
  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
  SQL Server DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
  V. SQL Agent Manager
  Sybase DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
Instance Manager - Provides manageability of a Sybase instance allowing a user to view and modify server parameters and server version information.

Toolbar Operations -

Refresh : Will refresh all tabs in the instance manager from the database
Edit Parameter: Edit the value of the currently selected parameter
Find: Find tool to search the grid of the current tab
Find Next: Find the next instance of the previous find

General Tab - Provides a summary of the Sybase instance

DBMS_NAME: Name of the DBMS
DBMS_VER: Version of the DBMS
DBE_NAME: Unused
OWNER_TERM: Adaptive Server's term for a table owner (the second part of a three-part name)
TABLE_TERM: Adaptive Server's term for a table (the third part of a three-part name)
MAX_OWNER_NAME_LENGTH: Maximum length of the name for a table owner (the second part of a three-part name)
IDENTIFIER_CASE: The case sensitivity of user-defined names (table names, column names, and stored procedure names) in the database
        (the case in which these objects are presented in the system catalogs)
COLUMN_LENGTH: The maximum number of characters for a column name
TABLE_LENGTH: The maximum number of characters for a table name
USERID_LENGTH: The maximum number of characters for a user name
TX_ISOLATION: The initial transaction isolation level the server assumes, corresponding to an isolation level defined in SQL92
COLLATION_SEQ: The assumed ordering of the character set for this server
MAX_QUAL_LENGTH: Maximum length of the name for a table qualifier (the first part of a three-part table name)
QUALIFIER_TERM: Adaptive Server's term for a table qualifier (the first part of a three-part name)
SAVEPOINT_SUPPORT: Does the underlying DBMS support named savepoints?
MULTI_RESULT_SETS: Does the underlying DBMS or the gateway itself support multiple results sets (can multiple statements be sent through
        the gateway, with multiple results sets returned to the client)?
NAMED_TRANSACTIONS: Does the underlying DBMS support named transactions?
SPROC_AS_LANGUAGE: Can stored procedures be executed as language events?
REMOTE_SPROC: Can stored procedures be executed through the remote stored procedure APIs in DB-Library?
ACCESSIBLE_TABLES: In sp_tables, does the gateway return only tables, views, and so on, that are accessible by the current user
        (that is, the user who has at least select privileges for the table)?
ACCESSIBLE_SPROC: In sp_stored_procedures, does the gateway return only stored procedures that are executable by the current user?
MAX_INDEX_COLS: Maximum number of columns in an index for the DBMS
RENAME_TABLE: Can tables be renamed?
RENAME_COLUMN: Can columns be renamed?
DROP_COLUMN: Can columns be dropped?
INCREASE_COLUMN_LENGTH: Can column size be increased?
DDL_IN_TRANSACTION: Can DDL statements appear in transactions?
DESCENDING_INDEXES: Are descending indexes supported?
SP_RENAME: Can a stored procedure be renamed?
SYS_SPROC_VERSION: The version of the catalog stored procedures currently implemented



Sybase Instance Manager
Sybase Parameters Tab - Sybase instance parameters

Parameter: Name of the parameter
Value: Value of the parameter
Run: Current value
Min: Minimum value of the parameter
Max: Maximum value of the parameter
Dynamic: Indicates whether the parameter can be changed during a session (dynamic), can be changed on the server restart (static) or not changeable (read-only)

Sybase Instance Manager - Parameters
Home Screenshots Downloads Documentation Support Licensing Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved