Index
Go Up to Main Page
Contents
Numerics
A
- A locks
- abort on overflow
- abort on truncation, Sybase ASE query option
- abstract... parameters
- ACCENT_SENSITIVITY
- access check... configuration options
- access methods
- access patterns, I/O
- accounts
- ACHKP status code
- ACM OPERATION
- activating roles
- active
- ACTIVE FOR BEGIN_DIALOG option
- active_instance_count
- activity query options, MySQL
- Ad Hoc Distributed Queries
- Add Cluster Column
- Add Database Object File(s) to Project Wizard
- add/modify login trigger object action
- add-drop-table MySQL option
- ADDING disk (ASM) state
- additional network memory
- add-locks MySQL option
- Address Windowing Extensions
- admin_move_table
- AES... algortihms
- affected pool
- affinity... server configuration options
- AFTER triggers
- AFTER UPDATE OF options
- agents
- aggregate functions, pasting syntax
- aggregate, MySQL functions
- alarms
- alerts
- alerts, SQL Agent
- Alias configuration parameter
- aliases
- Alignment index partition setting
- ALL views
- allocate extent object action
- allocate max shared memory
- Allow Bit Data setting
- Allow Duplicate Rows index setting
- allow nulls setting
- allow parallel setting
- Allow Reverse Scans index setting
- allow updates
- ALLOW_NULLS_BY_DEFAULT
- allow... Sybase configuration parameters
- allow-keywords MySQL option
- ALLPAGES
- ALTER event, trigger trigger handling
- ALTER SYSTEM SET
- ALTER SYSTEM SET "_recyclebin"=
- ALTER_REBUILD
- alter, rename style
- analysis reports, Capacity Analyst
- analytical functions, pasting syntax
- Analyze Code
- analyze tables object action
- ANALYZE trigger event
- ancestors, PostgreSQL tables
- ANSI
- ANSI NULL
- APF reads
- app_ctl_heap_sz
- Append Data setting
- Append, materialized query tables
- appgroup_mem_sz
- appl_memory
- applheapsz
- Application Processes Explorer node
- applications
- attributes of connected
- bind to database
- binds attempted
- cache/workspace details
- causing bottlenecks
- currently connected
- direct authorities
- executing
- highest read/writes
- idle
- indirect authorities
- list of, resource usage
- memory pool usage
- percentage waiting on locks
- precompiles attempted
- specific, SQL activity
- SQL activity
- time waiting on prefetchers
- top bottlenecked
- top CPU
- top I/O
- top memory
- waiting on locks
- aq_tm_processes
- ARBDP status code
- archive databases
- archive log
- archive_lag_target
- ARCHIVED LOG
- archretrydelay
- AREO* status code
- AREST status code
- arguments, pasting to SQL Editor
- arithabort
- AS DEFAULT
- AS FILETABLE argument
- as locator
- Asc Sort, indexes
- ascending scans
- AS ON clause
- ASM
- asm_... options
- ASP files, opening
- Assisting Parallel Sequential setting
- ASSOCIATE_STATISTICS
- asymmetric keys
- async
- async read ratio
- async write ratio
- AT SHUTDOWN durability option
- AT(COMMIT) clause
- attach database object action
- audit
- audit_... options
- auditing parameter
- AuditingTypes
- authentication, datasources
- authorization owner, full-text catalogs
- auto close
- auto commit status
- auto create statistics
- auto format options, ISQL
- auto format, DDL extract options
- auto growth
- auto identity
- auto replace strings
- auto shrink
- auto update statistics
- autovacuum settings
- auto_db_backup
- AUTO_INCREMENT query option
- auto_maint
- auto_prof_upd
- auto_reorg
- auto_runstats
- auto_stats_prof
- auto_stmt_stats
- auto_tbl_maint
- AUTOBACKUP ASM template
- autocommit
- autoconnect, restricting
- auto-create, databases without
- AUTOEXTEND, datafiles at extent limit
- auto-grow
- auto-increment, MySQL tables
- automatic bufferpool size
- automatic rebinds statistic
- automatic size setting
- auto-param attempts, failed
- auto-reload files, ISQL Editor
- auto-reload, options
- autorestart
- auto-save, files
- auto-shrink, databases with
- auto-update, databases without
- AUXW status code
- average cap size
- average disk queue length
- Average Size package setting
- avg_appls
- awe enabled
B
- back_log
- background_... options
- backup
- capacity/growth statistics
- certificate, object action
- compression default
- control files
- corruption control file stats
- databases
- databases requiring
- datafile control file stats
- growth reports
- last time
- MySQL databases
- piece control file stats
- PostgreSQL
- redolog control file stats
- server status
- set control file stats
- spfile control file stats
- statistics
- backup devices
- backup_pending
- backup_tape_io_slaves
- base table type, locks
- basedir
- batch delimiter
- batch execution
- batch files
- Batch Mode execution
- BCP Utility
- BEFORE triggers
- BEFORE UPDATE OF options
- Oracle Triggers
- PostgreSQL Triggers
- begin transaction ON/OFF
- begin/end, matching check
- BerkeleyDB storage engine
- Big Endian encoding
- big selects
- big table query option
- big-tables
- bind options
- bind package object action
- bind size
- Bind Time package setting
- bind to temporary database action
- bind variables
- Binder package setting
- binding
- binding logins to
- binlog_cache_size
- bit data, user datatypes
- bitmap index type
- bitmap_merge_area_size
- blank_trimming
- BlankPadding
- blk_log_dsk_fu
- blob filters
- BlobArenas
- block I/O requests
- Block Size setting
- blocked connections
- blocked process threshold
- blocked processes
- blocked sessions
- blocking locks
- blocking users, current
- blocks
- BLOCKSIZE
- body
- BOM encoding
- bookmarks
- bookmarks, Explorer
- boundary values, partition functions
- BROKEN disk group state
- broken job
- broker, SQL Agent
- Browser
- browser
- Browsers
- btree index method
- buffer
- buffer cache
- Buffer Manager
- Buffer Partition
- buffer pools
- buffer results
- buffer size
- buffer_... options
- BUFFERCOUNT
- Buffered Inset package setting
- bufferpools
- buffers
- build procedure object action
- bulk_insert_buffer_size
- bulkadmin server role
- BY PASSWORD
C
- C
- C lock duration
- C lock type
- c2 audit mode
- cache
- CACHE argument
- caching strategy
- calendaring syntax
- call, system, per second
- called on NULL input option
- Called on Null Input setting
- cancel thread action
- CANCEL, ADMIN_MOVE TABLE
- Capabilities configuration parameter
- Capacity Analyst
- caps per ccb
- carriage return
- CASCADE
- cascade
- CASCADE delete rule
- CASCADE, MySQL foreign key
- case
- case, changing
- case, matching
- CaseSensitive configuration parameters
- CAST FROM
- Castout setting
- catalog cache
- Catalog Metadata
- catalog, datasource
- catalogcache_sz
- categories
- categories, datasource
- categories, reassigning
- categories, stored outline
- CCSID
- certificate
- Certificate setting
- certificates
- chained
- chained row fetch ratio
- chained tables
- chains
- change category object action
- change job’s owner action
- change owner object action
- change schema object action
- change status action
- change status object action
- changed option, check tables
- CHANGETRACKING ASM template
- CHANGGE TRACKING, full-text indexes
- changing case
- changing database devices
- CHAR
- character set
- character set, client
- character strings
- character type
- character_set_... options
- CHARDEL
- CharSet configuration parameter
- check constraints
- creating for IBM DB2
- creating for IBM DB2 for OS/390 and z/OS
- creating for Microsoft SQL Server
- creating for Oracle
- creating for PostgreSQL
- creating for Sybase ASE
- editor, DB2 LUW
- editor, DB2 Z/OS
- editor, Oracle
- editor, SQL Server
- editor, Sybase
- hiding source text
- modifying for IBM DB2
- support for
- table, DB2 LUW
- tablespaces, checking
- check data operation, tablespaces
- check disk group operation
- Check Flag table setting
- check index operation
- check password for digit
- check pending states
- check policy/expiration
- check tables object action
- Checking Syntax
- checkpoint
- Checkpoint... configuration parameter
- checkpoints
- checkpoints, redo log groups
- 2011
- CHECKSUM backup options
- Checksum configuration parameter
- checksum tables object action
- CHECKTABLE DBCC option
- CHKP status code
- Chkpt... configuration parameters
- chngpgs_thresh
- circuits
- clean pg_dump option
- clean pg_restore option
- cis... options
- CKPT PROGRESS
- clean buffer grab rate
- CLEANUP, ADMIN_MOVE TABLE
- client_... options
- clients
- clipboard, line end options
- CLOB
- clock algorithm scans
- clone
- Close index setting
- Close primary key setting
- clr enabled
- Cluster Factor setting
- Cluster Factor, primary keys
- Cluster Ration setting
- cluster_... options
- CLUSTER, ADMIN_MOVE TABLE
- clustered indexes, SQL Server
- clustered setting
- ClusteredIndexes
- CLUSTER ON parameter
- clusters
- CNTRLTYPE
- coalescing tablespaces
- Code Analyst
- code analyst
- Code Formatting
- Code Page package setting
- Code Size setting
- Code Templates
- Code Workbench
- codepage
- codeset
- COLDEL
- collate_info
- collation
- Collation Compatible Server setting
- Collation configuration parameter
- collation_... options
- Collecting sample statistics
- Collection Analysis Viewer
- collections, Capacity Analyst
- colors
- colors/fonts
- column inserts pg_dump option
- columns
- PostgreSQL foreign keys
- column filtering
- columns
- cluster
- deleting statistics
- dimension
- distinct values in
- distribution key
- dropping unused
- filtering for materialized view logs
- foreign key mapping, Sybase
- full-text indexes
- functions, pasting syntax
- indexes, Oracle
- managing, DB2 LUW indexes
- managing, DB2 Z/OS indexes
- MySQL foreign keys
- MySQL tables
- pasting names to SQL Editor
- PostgreSQL indexes
- return, DB2 functions
- summary, tables/views
- tables, DB2 LUW
- tables, DB2 z/OS
- triggers, oracle
- unique keys editor, Sybase
- updating statistics, Sybase
- view statistics
- views, SQL Server
- comma-delimited data
- comma-delimited file type
- command line startup, DBArtisan
- command line startup, Rapid SQL
- COMMENT
- COMMENT attribute
- commenting/uncommenting code
- COMMENT ON COLUMN statement
- commit
- commit memory/limit ratio
- commit_... options
- commit, stop database option
- CommitFile configuration parameter
- committed transactions
- CommLink
- common criteria compliance enabled
- communication
- compact
- compatible
- Compatible Level setting
- compatible= MySQL option
- compile options
- compiled objects, hiding text
- complete-insert MySQL option
- composite limit
- COMPOUND triigers
- compress MySQL option
- Compress setting
- COMPRESSED
- compressed rows
- CompressedBTrees
- Compression
- compression
- COMPRESSIONbackup options
- concat null yields null
- concurrent licenses
- concurrent_insert
- CONCURENTLY parameter
- conditions
- configuration file Sybase parameter
- configuration parameters
- configuration parameters, DB2 LUW
- configured size, data cache pool
- confirmation dialogs
- conn_id, Sybase IQ locks
- conn_name, Sybase IQ locks
- Conn... configuration parameters
- ConnCreateTime
- connect string, database links
- connect time
- connect_timeout
- Registry Keys
- CONNECTED disk group state
- connected users, Sybase IQ
- connection
- connection entries
- connection memory
- connection, Sybase IQ locks
- CONNECTION LIMIT setting
- connections
- connections, troubleshooting
- connectivity options
- ConnHandle
- constraints
- PostgreSQL tables
- consumers
- containers
- containers, tablespace, reducing
- CONTAINS SQL function setting
- CONTENT=parameter
- context switches
- contiguous file creation
- continue nodegroup redistribution option
- CONTINUE_AFTER_ERROR backup options
- Control Files
- control files
- control_file... options
- control_management_pack_access
- CONTROL, DATAFILE, ONLINELOG, ARCHIVELOG, TEMPFILE, BACKUPSET, PARAMETERFILE ASM template
- controller number
- CONVERSION_ERROR
- conversion, functions, pasting syntax
- convert tables object action
- COPY CORRUPTION
- copy end of line options
- Copy index setting
- copy operations
- Copy primary key setting
- copy read hits
- COPY status code
- Copy To Copy operation
- COPY_USE_LOAD, ADMIN_MOVE TABLE
- COPY_WITH_INDEXES, ADMIN_MOVE TABLE
- COPY, ADMIN_MOVE TABLE
- COPY-ONLY backup options
- core_dump_dest
- cost threshold for parallelism
- counters
- country
- CPU
- cpu_count
- cpu... Sybase parameters
- CREATE
- create alias object action
- CREATE FUNCTION
- Create Like
- CREATE LOGIN call
- CREATE OR REPLACE TRIGGER
- create pg_dump option
- create pg_restore option
- CREATE SYMMETRIC KEY
- create_... options
- CREATE_JOB AUTO_DROP attribute
- CREATE_NEW
- Created setting
- CREATEDB setting
- create-options MySQL option
- Creating
- Creating Objects
- CREATION_DISPOSITION
- creator
- cross db ownership chaining
- curly braces, matching check
- Curr... configuration parameters
- curread change w/ open cursors
- current
- current audit table
- current waits
- CURRENT_TIMESTAMP pseudocolumn
- CurrentData package setting
- Cursor Blocking package setting
- cursor close on commit
- cursor management, SQL Agent
- cursor threshold
- cursor_... options
- cursors
- custom, pg_dump option
- custom, pg_restore option
- CYCLE argument
- cycle numbers, IBM LUW sequences
- cycle numbers, sequences
- Cycle When Reach Max/Min setting
D
- daily archive log summary
- DASD storage
- data
- Data Access Server setting
- Data Blks/Key
- data block storage
- data cache
- data caches
- DATA CAPTURE NONE/CHANGES
- data capture option
- Data Dictionary
- data dictionary
- Data Editor
- Data editor
- data editor
- Data Export
- Data Export Wizard
- data files
- Data Import
- Data Import Wizard for IBM DB2 for Windows/Unix
- Data Load
- Data Load
- Data Load Wizard
- data map hits, DB2
- data map hits, Oracle
- data map hits, Sybase
- Data Pages setting
- data pump export wizard
- data pump import wizard
- DATA_OPTIONS parameter, data pump
- DATABASE BLOCK CORRUPTION
- database devices
- DATABASE INCARNATION
- database links
- database locks
- Database Mail XPs 0 0 0 1 Yes
- Database Manager
- Database Monitor
- Database partition Group table setting
- database triggers
- database_consistent
- database_level
- database_memory
- databasemanager configuration file parameters
- databases
- analysis, objects/users/size
- archive
- associated triggers
- Backing Up
- backing up, MySQL
- capacity/growth statistics
- checkpoint, Oracle
- checkpoint, SQL Server and Sybase
- configuration settings
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, MySQL
- creating, SQL Server
- creating, Sybase
- detaching
- editor, DB2 LUW
- editor, IBM DB2 Z/OS
- editor, MySQL
- editor, SQL Server
- editor, Sybase
- Explorer node
- exporting, DB2 LUW
- growth reports
- heap utilization
- hiding source text
- hottest files
- index/table details
- low on space
- movings logs between devices’transaction logs
- number of
- offline
- open
- publishing HTML reports
- quiescing
- requiring backup
- restoring, MySQL
- restoring, PostgreSQL
- resynchronizing
- same disk
- setting online/offline
- shrinking
- size/objects comparison
- space statistics
- space summary
- starting
- stopping
- string search
- support for
- suspect
- temporary, Sybase
- unquiescing
- updating statistics
- with suspect pages
- without auto-create
- without auto-update
- datadir
- DATAFILE
- DATAFILE COPY
- DATAFILE HISTORY
- datafiles
- DATAGUARDCONFIG ASM template
- DATALINK integrity
- DATAPAGES
- Datasource Explorer
- datasource explorer
- datasource groups
- datasource index
- datasources
- auto-discovering
- basic viewing/organization options
- catalog option
- categories
- connecting (explicit)
- connecting to
- discovering automatically
- dropping storage paths
- editing
- export/import
- filtering objects/nodes view
- groups
- HTML reports
- indexing
- locking ISQL editor to
- locking SQL Editor to
- modifying
- options/preferences
- registering like an existing
- registering manually
- specifying catalog storage
- trouble-shooting connections
- unregistering
- viewing properties
- datatype
- datatypes
- date formats
- Date Time Format package setting
- date_format
- date/time
- datetime_format
- db chaining
- DB Protocol package setting
- db_... options
- db_collname
- db_mem_thresh
- DB2 Export API Call
- DB2 for Linux, Unix, and Windows
- DB2 for z/OS
- DB2 Import API Call
- DB2 LUW
- db2... .exe locations
- DB2GENERAL parameter style
- DBA views
- DBAs
- DBCC
- dbcreator server role
- DBETE status code
- DBFileFragments
- dbheap
- DBID table setting
- DBINFO option
- DBInfo parameter
- DBINFO setting
- dbms platforms, restricting
- DBMS_JAVA
- DBMS_JAVA package
- DBMS_JOB.BROKEN
- DBMS_JOB.SUBMIT
- DBMS_SCHEDULER.CREATE_JOB
- DBMS_SCHEDULER.CREATE_PROGRAM
- DBMS_SCHEDULER.CREATE_SCHEDULE
- DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT
- DBMS_SCHEDULER.ENABLE/DISABLE
- DBMS_SCHEDULER.RUN_JOB
- DBMS_SCHEDULER.SET_ATTRIBUTE
- DBMS_SCHEDULER.STOP_JOB
- dbo use only
- DBremot
- DBRMs
- DBWR
- dbwr_io_slaves
- DDF
- DDL
- DDL Editor
- ddl in tran
- DDL triggers
- ddl_lock_timeout
- DDWQT setting
- deactivating roles
- deadlock... Sybase parameters
- deadlocks
- deallocate unused space
- Dec31 package setting
- decflt_rounding
- Decimal Point package setting
- DECPLUSBLANK
- DECPT
- decryption
- DECRYPTION BY...
- DEFAULT
- default binding
- default full-text language
- default language
- default location, proxy databases
- default to local cursor
- default trace enabled
- Default Value setting
- default_week_format
- default... Sybase parameters
- default-character-set=charset MySQL option
- defaults
- defaults, foreign keys, functions, indexes, materialized tables
- Defer Prepare package setting
- DEFER(PREPARE)
- deferrable
- PostgreSQL foreign keys
- Deferable primary key setting
- Deferrable/Deferred unique key setting
- Deferred primary key setting
- Deferred Write Threshold setting
- deferred, create bufferpools
- Definer package setting
- degee of parallellism
- Degree package setting
- degree, bind packages
- degree, binding packages
- Degrees settting738–739
- DEL, export
- delay_key_write
- delayed disk I/O
- delayed_insert_limit
- delayed_insert_timeout
- delayed_queue_size
- delayed-insert MySQL option
- delete MySQL option
- delete rule
- delete rule CASCADE delete rule
- delete rule, update rule
- delete rule"Oracle foreign keys
- DELETE statements
- delete statistics object operation
- DELETED OBJECT
- delete-master-logs MySQL option
- DELETEs
- deletes
- delimited data
- delimited identifiers
- Density setting
- dependencies
- deprecated features, SQL Agent.
- DES... algorithms
- descending scans
- DESTROY
- detach database object action
- details history, event monitor
- deterministic option
- Deterministic setting
- DEV category
- Developer Network
- device
- device fragments
- device I/O contention
- device type
- device type, dump device
- devices
- dft_degree
- dft_extent_sz
- dft_loadrec_ses
- dft_mttb_types
- dft_prefetch_sz
- dft_queryopt
- dft_refresh_age
- dft_sqlmathwarn
- dg_broker_config_file1
- dg_broker_config_file2
- dg_broker_start
- diagnostic_dest
- difference, visual
- dimensions, columns
- direct authorities, applications
- direct reads/writes
- DIRECTIO
- directories
- directory pg_dump option
- directory pg_restore option
- dirty read restarts/requests
- disable
- DISABLE clause
- disable job object action
- disable keys object action
- DISABLE TRIGGER810–811
- DISABLE TRIGGER
- Disable Triggers
- DISABLE_RI_CHECK
- disable... Sybase parameters
- disabled environments
- disable-keys MySQL option
- disable_... pg_dump options
- disable pg_restore option
- disallow results from triggers
- DISASSOCIATE_STATISTICS
- disconnect ASM connection operation
- disconnects statistic
- Discover Datasources
- discover_db
- disk
- average queue length, SQL Server
- average queue length, Sybase
- busy time
- database/log on same
- device summary
- devices summary/details
- free space, DB2
- free space, Oracle
- free space, Sybase
- I/O structure contention
- I/O time
- outstanding I/O
- percent time reads/writes
- percentage busy time
- percentage time servicing requests
- queue length, average
- read/write time
- space free
- space, details
- space, total
- space, used
- total space
- total/available statistics, Oracle
- total/available statistics, SQL Server
- transfers
- transfers per second, Oracle
- transfers per second, Sybase
- usage statistics
- used space
- disk groups
- disk i/o structures
- DISK INIT
- DISK MIRROR
- disk_asynch_io
- diskadmin server role
- DiskRead... configuration parameters
- DiskWrite
- DISMOUNTED disk group state
- dispatchers
- Display
- -DISPLAY DATABASE(*) LIMIT(*)
- DISPLAY DATABASE(*) LIMIT(*)
- -DISPLAY DATABASE(*) LIMIT(*) LOCKS
- DISPLAY DATABASE(*) LIMIT(*) LOCKS
- -DISPLAY DATABASE(*) SPACENAM(*)
- DISPLAY DATABASE(*) SPACENAM(*)
- Distinct Keys setting
- Distinct Keys setting"Oracle unique keys
- distinct values, column
- Distributed Queries
- distributed_lock_timeout
- distribution key columns
- Distribution Server setting
- distribution statistics
- DIVIDE_BY_ZERO_ERROR
- dlchktime
- dml_locks
- DMS tablespaces
- DO INSTEAD clause
- DOL scans
- domains
- drivers, default
- DriveType
- DROP
- drop by category object action
- drop clone, object action
- drop java object action
- drop login trigger object action
- DROP PENDING state
- DROP statements
- DROP STORAGE clause
- drop unused columns object action
- drop Unused object action
- drop, Java
- drop, object action
- DROPPED disk (ASM) state
- DROPPING disk (ASM) state
- drs_start
- DSYNC
- dtm... Sybase parameters
- dump devices
- dump file
- dump on conditions
- dump utility, MySQL
- DUMPSET ASM template
- dupicate keys
- durability, Sybase databases
- DWQT setting
- dyn_query_mgmt
- DYNAMIC
- dynamic allocation on demand
- Dynamic Rules package setting
- Dynamic setting
- Dynamic Sizing settings
- dynamic SQL
- dynamic SQL, flushing
E
- e locks
- EARLY_PREDICATE_EXECUTION
- Editing
- Editing Result Sets
- Editing SQL Scripts
- editor, IBM DB2 LUW
- editors
- aliases, DB@ LUW
- aliases, DB2 Z/OS
- aliases, Sybase
- asymmetric keys, SQL Server
- backup devices, SQL Server
- bufferpool, IBM DB2 Z/OS
- bufferpools, IBM DB2 LUW
- certificates, SQL Server
- check constraints, DB2 LUW
- check constraints, DB2 Z/OS
- check constraints, Oracle
- check constraints, SQL Server
- check constraints, Sybase
- clusters, Oracle
- database devices, Sybase
- database links, Oracle
- databases, DB2 LUW
- databases, IBM DB2 Z/OS
- databases, MySQL
- databases, Sybase
- datbases, Sybase
- defaults, SQL Server
- defaults, Sybase
- directories, Oracle
- dump devices, Sybase
- event monitor, IBM DB2 LUW
- extended procedures, Sybase
- foreign key, Sybase
- foreign keys, DB2 LUW
- foreign keys, IBM DB2 Z/OS
- foreign keys, MySQL
- foreign keys, Oracle
- foreign keys, SQL Server
- functions, DB2 LUW
- functions, DB2 Z/OS
- functions, Oracle
- functions, SQL Server
- functions, Sybase
- groups, IBM DB2 LUW
- groups, Oracle
- groups, Sybase
- indexes, DB2 z/OS
- indexes, IBM LUW
- indexes, MySQL723–724
- indexes, Oracle
- indexes, SQL Server
- indexes, Sybase
- job queues, Oracle
- libraries, Oracle
- logins, SQL Server
- logins, Sybase
- materialized query tables
- materialized view logs, Oracle
- nodegroups, IBM DB2 LUW
- options/preferences
- outline, Oracle
- packages, IBM DB2 Z/OS
- packages, IBM LUW
- packages, Oracle
- plans, IBM DB2 Z/OS
- primary keys, IBM LUW
- primary keys, MySQL723–724
- primary keys, Oracle
- primary keys, SQL Server
- primary keys, Sybase
- primary keys, z/OS
- procedures, IBM DB2 Z/OS
- procedures, IBM LUW
- procedures, Oracle
- procedures, SQL Server
- procedures, Sybase
- profiles, Oracle
- remote server, SQL Server
- remote server, Sybase
- roles, Oracle
- roles, SQL Server
- roles, Sybase
- rollbacksegments, Oracle
- rules, SQL Server
- segments, Sybase
- sequences, IBM LUW
- sequences, Oracle
- stogroups, IBM DB2 Z/OS
- structured types, IBM LUW
- synonyms, DB2 Z/OS
- synonyms, Oracle
- tables, DB2 LUW
- tables, DB2 Z/OS
- tables, MySQL
- tables, Sybase
- tablespaces, DB2 LUW
- tablespaces, DB2 Z/OS
- tablespaces, Oracle
- triggers, DB2 Z/OS
- triggers, IBM DB2 LUW
- triggers, Oracle
- triggers, SQL Server
- triggers, Sybase
- type bodies, Oracle
- types, Oracle
- unique keys, DB2 z/OS
- unique keys, IBM DB2 LUW
- unique keys, MySQL723–724
- unique keys, Oracle
- unique keys, SQL Server
- unique keys, Sybase
- user datatypes, DB2 LUW
- user datatypes, IBM DB2 Z/OS
- user datatypes, SQL Server
- user messages, SQL Server
- users, DB2 Z/OS
- users, IBM DB2 LUW
- users, MySQL
- users, Oracle
- users, SQL Server
- users, Sybase
- views, DB2 LUW
- views, DB2 Z/OS
- views, Oracle
- views, SQL Server
- views, Sybase
- EditProcedure table setting
- EKM provider enabled
- emailing scripts
- Idera products, access
- Idera SQL Debugger for IBM DB2
- Idera SQL Debugger for IBM DB2 for Windows/Unix
- Idera SQL Debugger for Sybase
- ENABLE ALWAYS TRIGGER
- enable job object action
- enable keys object action
- Enable Query Rewrite materialized view setting
- ENABLE REPLICA TRIGGER
- ENABLE TRIGGER810–811
- Enable Triggers
- enable_ddl_logging
- enable_xmlchar
- enable... Sybase parameters
- Enable/Disable Filetable(s) action
- enable/disable job action
- Enable/Disable object action
- enabled environments
- Enabled primary key setting
- Enabled setting
- EnableQueryOptimization setting
- enabling/disabling
- encoding
- Encoding package setting
- Encoding Scheme database setting
- encoding, Java
- ENCRYPTED PASSWORD setting
- Encrypted setting
- encryption
- encryption algorithm
- ENCRYPTION BY PASSWORD
- ENCRYPTION BY...
- encryption keys
- ENCRYPTION_PASSWORD parameter, data pump
- END_DATE attribute
- Endian encoding
- end-of-line options
- enforced foreign key
- Enforcing Index settings
- engine
- ENGINE= option
- enqueue waits
- environments
- environments, disabled/enabled
- environments, packages
- environments, plans
- Erase primary key setting
- error logs
- error messages
- Error Size setting
- ERROR, check tables results
- ERROR, repair tables results
- errorlog... Sybase parameters
- errors
- Errors materialized view setting
- esp... Sybase parameters
- ESTIMATE parameter, data pump
- estmate size, object action
- ETSQLX files, directory
- ETStart/ETEnd tags
- event
- Event Monitors
- event monitors
- event... Sybase parameters
- events
- ew locks
- Excel file type
- Excel, Microsoft
- exceptions
- exchange data, object action
- EXCLUDE parameter, data pump
- exclusive lock escalations
- EXEC sp_configure
- executable codesize + overhead
- Executing Scripts
- execution
- execution information
- execution plans
- EXEMPT INACTIVE LOCK parameter
- EXISTING KEYS option
- expdp.exe
- Expected Row Size setting
- expire_logs_days
- expired password
- expiry date
- EXPITEDATE backup options
- Explain Level/Snapshot/Mode setting
- Explain package setting
- explain plans
- Explicit Bind Time package setting
- Explorer
- export
- Expr configuration parameters
- expression
- expressions
- ExtendDB
- extended cache size
- extended insert MySQL option
- extended option, check tables819–820
- extended option, repair tables action
- extended procedures
- extended storage
- EXTENDED_JOIN_SYNTAX
- extending a container
- Extends setting
- ExtendTempWrite
- Extent Size tablespace setting
- extents
- external action option
- External Action setting
- External Action setting"DB2 LUW functions
- external applications
- external functions
- External Name setting
- Externally setting
- extract operation
- extract, object action
- extraction
F
- failarchpath
- failed auto-param attempts
- failed login attempts
- failed logins, Sybase
- FAILED RUNS attribute
- failure group
- fal_... options
- fast communication manager
- FASTUPDATE option
- fast option, check tables
- fast_... options
- Favorites tab
- feature lockdown
- fenced option
- Fenced setting
- fields
- fields... MySQL option
- file
- file execution facility
- File Factor setting
- File Group setting
- File Group setting"SQL Server primary keys
- File Growth Rate setting
- file_mapping
- filegroups
- fileio_network_adapters
- FILENAME
- files
- FileSize configuration parameter
- filestream access level
- FILESTREAM_ON argument
- FILETABLE_... arguments
- FILETABLE_NAMESPACE
- FileVersion
- fill factor (%)
- Fill Factor setting
- filtering
- Final Cal setting
- final call option
- Final Call setting
- Fire On Delete/Update/Insert setting, rule
- Fire On Insert/UpdateDelete
- First Key index setting
- First Key setting
- First n Keys setting
- first virtual page, database device
- first-slave MySQL option
- FIXED
- fixed server roles
- fixed_date
- flag, binding packages
- FLASHBACK ASM template
- FLASHBACK LOG
- flashback recycle bin entry action
- flashback table object action
- FLASHBACK_SCN parameter, data pump
- FLASHBACK_TIME parameter, data pump
- Floating Output Window View
- flush
- flush cache object action
- flush tables object action
- flush_time
- flushes, log
- flush-logs MySQL option
- fonts
- FOR clause
- For Data setting
- For Data table setting
- FOR EACH ROW
- FOR LOAD
- FOR PROXY_UPDATE
- FOR UPDATE OF options
- FOR VALUES arguments
- FOR/AFTER argument, database ddl triggers
- FOR/AFTER argument, server ddl triggers
- FORCE attribute
- FORCE disk group option
- FORCE disk mounting option
- FORCE GENERATED set integrity option
- force MySQL option, backup
- force MySQL option, import
- FORCE, ADMIN_MOVE TABLE
- force, start database option
- FORCING disk (ASM) state
- FOREIGN ARCHIVED LOG
- foreign keys
- foreign_key_checks
- format
- formatting
- Formatting Code
- Formatting Result Sets
- fragmentation
- fragmented datafiles, top
- fragments
- fragments, database
- free buffer wait average
- free list waits
- free packages object action
- Free Page primary key setting
- free shared pool percentage
- free space
- free space threshold, segments
- freed memory
- freelists
- FreePage... configuration parameters
- freespace scans
- FROM ASSEMBLY/EXECUTABLE FILE/FILE
- FROM FILE/ASSEMBLY/ASSEMBLY/PROVIDER
- FROM PROVIDER
- ft_... options
- ft... options
- FULL ACCESS set integrity option
- FULL durability option
- Full Keys
- FULL parameter
- FullCompare
- full-text catalogs
- full-text indexes
- fully qualiied names
- Function Path package setting
- function path, DB2
- function path, Oracle
- Function-Based index setting
- functions
- changing owners
- changing schema
- creating synonyms to
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, MySQL
- creating, Oracle
- creating, PostgreSQL
- creating, SQL Server
- DB2 LUW triggers, path
- DB2 z/OS triggers, path
- editor, DB2 LUW
- editor, DB2 Z/OS
- editor, Oracle
- editor, SQL Server
- editor, Sybase
- extract options
- hiding source text
- hot
- migration options
- password verification
- pasting SQL to editor
- support for
- wizard, Sybase
G
- GBP Cache primary key setting
- gc_files_to_locks
- gcs_server_processes
- GENERATE NEW KEYS option
- Generate Numbers in Order setting
- Generate Package
- Generate Procedure
- Generate Select Statement
- Generate Statements
- GENERATED ALWAYS... options, DB2 LUW
- GENERATED ALWAYS... options, DB2 z/OS
- generated column, set integrity
- generators
- GetData
- Gets setting
- gin method
- gist index method
- glbtmp table type, locks
- GID, prepared transactions
- global database statistics
- global_... options
- global... Sybase parameters
- GlobalDBId
- Globally setting
- grace period, password
- GRANT
- Graph Types
- GRECP status code
- grid properties, results window
- group commit sleeps
- Group Member database setting
- Group Menber package setting
- group_concat_max_len
- groupheap_ratio
- groups
- groups, datasource
- grow by parametere, segments
- growth rate
- GUARANTEED RESTORE POINT
H
- H lock duration
- H lock status
- hadr_... options
- hash
- hash chain length, average
- hash composite
- hash joins
- hash_area_size
- Hash... configuration parameter
- have_... options
- header
- headers
- heap memory per user
- heap size
- heap size, initial/max
- heap size, JDBC
- HEAP storage engine
- HELP parameter, data pump
- hi_shared_memory_address
- hide text object operation
- HIERARCHY (STARTING)
- HIGH redundancy
- high water mark
- high watermarks
- Hiperpool Sequential Steal Threshold setting
- Hiperpool Size setting
- histogram tuning factor
- Histogram... configuration parameters
- historgram steps
- historical waits
- history file details
- history table
- history, event monitor
- hit ratios
- host
- hot/hottest
- HPSEQT setting
- hs_autoregister
- HTML
- http functions, pasting syntax
- HUNG disk (ASM) state
- hyperlinks, object action feature
- hysteresis
I
- I lock duration
- I/O
- access patterns, Oracle
- access patterns, SQL Server
- activity, Oracle query option
- asynchronous, limit
- average bytes per transaction
- block requests/reads
- busy time
- bytes per operation, DB2
- bytes per operation, Sybase
- delayed, number of
- details/summary, DB2
- details/summary, Oracle
- details/summary, Sybase
- device contention
- device statistics
- disk time
- errors, number of
- extents/pages statistics
- hot database statistics
- large, deferred
- large, hit ratio
- large, requests
- lock activity statistics
- maintenance-related operations
- network, statistics
- outstanding/pending, maximum
- percentage busy
- percentage time servicing requests
- physical read/write statistics
- read/write error count
- rollback statistics
- SQL activity
- SQL Server busy
- statistics, Sybase ASE query option
- structure contention
- synchronous operations
- tablespace settings
- top applications
- top hogs
- top process, DB2
- top process, Oracle
- top process, Sybase
- top waits by wait time
- total read/writes
- total reads/writes
- transfer rate
- user-related object activity
- vectored requests/reads
- i/o... Sybase parameters
- ICOPY status code
- IDENTIFIED BY clause
- identity
- Identity Column setting
- Identity Gap setting
- identity in nonunique index
- IDENTITY_VALUE
- identity... Sybase parameters
- idle server time
- idle time
- Idle... configuration parameters
- ifile
- IGNORE DELETE TRIGGERS clause
- Ignore Duplicate Key setting
- Ignore Duplicate Rows index setting
- ignore overflow
- -ignore-lines= MySQL option
- Image Copies
- images
- immedaite offline mode
- IMMEDIATE CHECKED set integrity option
- IMMEDIATE clause
- immediate latch hit ratio
- immediate, create bufferpools
- impdp.exe
- import
- import data (from file)
- IN PATH
- inaccessible tablespaces
- inactive
- inactive threads
- inbound packets
- include columns
- Include Longvar Columns setting
- INCLUDE parameter, data pump
- INCREMENT BY argument
- incremental refresh
- IndAdd
- index
- Index Buffer Pool database setting
- index create memory (KB)
- Index Level setting
- Index Level, primary keys
- Index Page Ratio setting
- Index Tablespace setting
- Index Type index setting
- INDEX_ADVISOR... options
- index_id, Sybase IQ locks
- index, datasource
- Indexes
- indexes
- activity, Oracle query option
- allocating extents to
- capacity/growth statistics
- check index/data consistency
- compressing
- copy to copy
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, MySQL
- creating, Oracle
- creating, SQL Server
- creating, Sybase
- deallocating unused space
- default segment warning
- disabling, SQL Server
- editor, DB2 z/OS
- editor, IBM LUW
- editor, MySQL723–724
- editor, Oracle
- editor, SQL Server
- editor, Sybase
- estimating size
- extents allocated to
- level trend
- maintenance from insets/updates/deletes
- MySQL tables
- open
- pages copied/extended storage
- pasting SQL to editor
- purging, recycle bin
- rebuilding, SQL Server
- recreating, missing
- reorganizing, SQL Server
- RunStats operation
- same tablespace indexes warning
- segment placing
- set statistics action
- shrinking
- space summary
- spinlock contention
- table, DB2 LUW
- tables, same tablespace
- tables, Sybase
- updating statistics
- indexes, Sybase
- indexrec Index
- IndexStatistics
- indirect authorities, applications
- IndLookup
- indoubt
- indoubt transactions
- in-doubt xact resolution
- INFER_SUBQUERY_PREDICATES
- INFO, check tables results
- INFO, repair tables results
- Inherit Special Registers setting
- INHERITS clause
- INIT backup options
- init_... options
- INIT, ADMIN_MOVE TABLE
- initial extent
- initial heap size
- initial heap size, JDBC option
- Initial Transactions
- initialization parameters
- INMEMORY
- inputs
- inserts pg_dump option
- in-memory databases
- InnoDB storage engine
- innodb_... options
- input parameters
- INSERT statements
- INSERT statments
- insert_id
- INSERTs
- Installation
- instance
- Instance Parameter Configuration
- INSTANCE SPACE RESERVATION
- instance_... options
- INSTANCE_STICKINESS attribute
- instances
- INSTEAD OF trigger timing
- interactive timeout MySQL query option
- interactive_timeout
- internal rollbacks statistic
- inter-node communication
- interrupts
- Intra-partition package setting
- invalid objects
- invisible
- IOToRecover
- IQ status node
- IQCmdType
- IQConnID
- IQCursors
- IQStore
- IQthreads
- iqtosa_count
- IS lock state
- ISAM storage engine
- isolation
- isolation level
- Isolation Level package setting
- isolation, bind packages
- ISQL editor
- ISQL WIndow
- ISQL Window
- IsValid index setting
- IX lock state
- IXF export
J
- JAVA
- Java
- Java Classes
- java classes
- java load object action
- Java Resources
- Java Sources
- java_... options
- JavaHeapSize
- JavaNSSize
- jConnect
- JDBC
- JDKVersion
- job config files directory
- Job Queues
- job queues
- JOB_ACTION attribute
- JOB_PRIORITY attribute
- job_queue_processes
- JOB_WEIGHT attribute
- job... Sybase parameters
- JOBNAME
- JOBNAME=
- jobs
- jobs, SQL Agent
- join indexes
- join_buffer_size
- JOIN_OPTIMIZATION
- joins
- JScript
- JVM options
K
- Katakana Charset package setting
- Keep Dynamic package setting
- KEEP, ADMIN_MOVE TABLE
- Kerberos authentication
- key columns, cluster
- KEY INDEX
- key size, clusters
- key_... options
- key_buffer_size
- KEY_SOURCE
- Keyboard Commands
- keyboard preferences
- keys
- kill action
- Killing Processes
L
- Label table setting
- language
- large I/O
- LARGE_DOUBLES_ACCUMULATOR
- large_files_support
- large_pool_size
- LargeProcedureIDs
- Last Bind Time package setting
- last hour performance statistics
- Last Modified setting
- LAST RECID
- Last Runstats setting
- last transaction log dump
- last virtual page, database device
- last_insert_id
- LAST_INSERT_ID()
- LastIdle
- LastIQCmdTime
- LastReqTime
- latches
- layout, query plans
- lazy writes
- lc_time_names
- LDAP
- ldap_directory... Oracle initialization
- Leaf Blocks setting
- Leaf Blocks settings
- Leaf Pages settings
- LEFT, partitojn function range
- LGWR
- libraries
- license
- licensing
- lifetime, password
- Lightweight Directory Access Protocol. See also LDAP
- lightweight pooling 0 0 0 1 No
- line feed
- line numbers
- lines MySQL option
- --lines--terminated-by MySQL option
- link options
- linked servers
- list composite
- list partitions
- literals, parameterized
- Little Endian encoding, results
- Live Mode execution
- load average
- load averages
- load data
- Load Java
- LOAD_MSGPATH, ADMIN_MOVE TABLE
- LOB
- range-
- local connections
- local MySQL option
- local_infile
- local_listener
- locale
- localhost, MySQL users
- Locality index partition setting
- locator, as
- lock button (SQL Editor/datasource)
- lock connections
- lock contention, average
- Lock Isolation package setting
- Lock Scheme setting
- Lock Size setting
- lock table object action
- lock time, account
- lock_class, Sybase IQ locks
- lock_duration, Sybase IQ locks
- lock_name, Sybase IQ locks
- lock_type, Sybase IQ locks
- lock... Sybase parameters
- lockdown, feature
- locked objects
- locking
- locklist Maximum storage
- locks
- all/blocking details
- and SQL Agent
- applications waiting on
- applications/connections waited statistic
- average per second/transaction
- average wait time
- cancelling
- capacity/growth statistics
- count, by database/lock type
- currently active
- details by application
- escalations
- I/O activity statistics
- list utilization
- number of timeouts, sample period
- number of times escalated
- requests required waits
- support summary
- table, Sybase IQ
- timed out
- timeouts
- total escalations
- type/database details
- wait time
- Locksize, materialized query tables
- LockTablePages
- lock-tables MySQL option, backup
- lock-tables MySQL option, import
- locktimeout Lock timeout
- log files
- LOG HISTORY
- log parameter
- log semaphore contention
- log_... options, MySQL
- log_... options, Oracle
- log_retain_status
- Log... configuration parameters
- log... Sybase parameters
- logarch... options
- logbufsz
- logfile
- LOGFILE parameter
- LOGFILE=
- logfilsiz
- Logged Initially setting
- logging
- allocations/writes/flushes
- backup of, statistics
- binary, MySQL query option
- cache read hit ratio
- cache reads count
- capacity/growth statistics
- database files
- diabling, MySQL Query option
- errors, size/type statistics
- flushes count
- hottest file
- index setting
- low on space, SQL Server
- low on space, Sybase
- materialized query table options
- materialized view logs738–739
- near max size
- number of errors in
- PostgreSQL
- primary key index constraints
- SQL options
- SQL options/preferences
- table setting
- top waits
- unique keys
- without auto-growth
- Logging, SQL
- logging, SQL
- loghead
- logical reads
- loggins
- LOGIN PROFILE parameter
- login triggers
- login/logout operations
- logindexbuild
- LogIndexBuild setting
- logins
- accounting details
- activating/deactivating roles
- adding to server roles
- adding user accounts to database
- adding/modifying login triggers
- associating with users
- bind to database
- binding to temporary databases
- changing password
- copying from existing
- creating, SQL Server
- creating, Sybase
- dropping login triggers
- editing, SQL Server
- editor, SQL Server
- editor, Sybase
- extracting with user
- lock exemption
- login trigger configured
- number of, DB2
- number of, Oracle
- number of, SQL Server
- number of, Sybase
- profile limits
- remote servers, add/modify/drop, SQL Server
- remote servers, add/modify/drop, Sybase
- role assignment
- role permissions
- server triggers, SQL Server
- support summary
- unbinding from temporary databases
- LOGON
- LOGONLY cache type
- logonly data cache
- logpath
- logretain
- logs
- logsecond
- LOGSEGMENT
- logsegment
- LONG
- long operations, Oracle
- long size
- Long Tablespace setting
- long_query_time
- longvarchar types
- longvarchar types, data editor
- low priority updates, MySQL query option
- low watermarks
- low_priority_updates
- lower high water mark operation
- lower_case_file_system
- lower_case_table_names
- LowestIQCursorState
- LPL status code
- LSTOP status code
- LTM... configuration parameters
M
- M lock duration
- Mailing Result Sets
- maintenance operations
- Make Unique setting
- Make Unique setting"DB2 z/OS unique keys
- manage ASM connection operation
- MAPI
- MapPages
- mapping
- master database, object creation warning
- Master View materialized view setting
- master-data MySQL option
- match case
- Match Full setting
- materialized query tables
- Materialized View Logs
- materialized view logs
- materialized views
- mathc full
- mathematical functions, pasting syntax
- max degree of parallelism
- max errors before aborting
- Max Extents
- max full-text crawl range
- Max Row Size setting
- max server memory (MB)
- Max Size of Non-Leaf Index Row setting
- max text repl size (B)
- Max Transactions
- max worker threads
- max_... options, MySQL
- max_... options, Oracle
- max_allowed_packet= MySQL option
- MAX_FAILURES attribute
- max_log
- MAX_RUNS attribute
- Max... configuration parameters
- max... Sybase parameters
- maxappls
- MAXDOP
- maxfilop
- maximums
- autogrowth size
- errors before abort, ISQL
- errors before abort, Oracle query option
- errors before abort, SQL Server
- errrors before abort, Sybase query option
- extents, clusters
- extents, materialized views
- join size, MySQL
- row count, MySQL
- rows per page, primary keys
- rows per page, tables
- rows per page, unique keys
- transactions, clusters
- transactions, materialized views
- maxlocks
- MAXTRANSFERSIZE
- MAXVALUE argument
- MDI Tab Swapping
- MDL read hits, DB2
- MDL read hits, Oracle
- MDL read hits, Sybase
- media retention
- medium option, check tables
- memory
- allocated to buffer cache
- allocated to open databases
- allocated to open indexes
- allocated to procedure cache
- allocated to user connections
- application details
- application, pool usage
- available
- available/total statistics
- buffer pool, configuration
- commit memory/limit ratio
- details/summary statistics
- freed
- freed/destroyed
- paged, used
- pages, database content
- pool, percentage utilization
- RAM available
- sort ratio
- storage engine, MySQL
- swap available
- swap, used
- top application
- top hogs
- top process, DB2
- top process, Oracle
- top process, Sybase
- total
- total physical installed
- total vs target
- total/available statistics
- virtual, available
- memory manager
- memory_max_target
- memory_target
- memory... Sybase parameters
- menu preferences
- merge publish
- MERGE tables, MySQL
- message anchors
- message integrity/confidentialty
- messages
- messages, language
- METHOD N
- methods
- Microsoft Excel
- Microsoft SQL Server Agent
- migration
- migration, schema
- min memory per query (KB)
- min server memory (MB
- min_dec_div_3
- mincommit
- MINIMIZE_STORAGE
- Minimum Extents
- minimum extents
- minimum password length
- MINVALUE argument
- mirror object action
- MIRROR redundancy
- mirroring database devices
- mirrorlogpath
- missing indexes, recreating
- MIXED cache type
- Mixed Character Set package setting
- mixed data cache
- Mode
- Mode materialized view setting
- MODIFIED SQL DATA functionn settting
- Modify Cluster Column
- modify conflicts
- modify recovery operation
- modify statistics operation
- monitor heap
- mount disk groups operation
- MOUNTED disk group state
- move table object action
- MOVE, ADMIN_MOVE TABLE
- MRG_MyISAM storage engine
- MRU replacement
- MRU Replacement Strategy setting
- Msg_text , check tables results
- Msg_text , repair tables results
- Msg_type , check tables results
- Msg_type, repair tables results
- msg... Sybase parameters
- MTTR
- MultiByteCharSet
- Multi-node Bound package setting
- multipage_alloc
- multi-part names
- multipartition environment, inter-node communication
- Multithreading
- mutual authentication
- mview table type, locks
- MyISAM storage engine
- myisam_... options
- MySQL
- mysqldump
- mysqlimport
N
- n
- named variables
- named_pipe
- NamedConstraints
- Navigator
- NCHAR
- nchar
- NCLOB
- nested triggers
- net_... options
- net_buffer_length= MySQL option
- network
- network activity
- network output queue length
- network packet size (B)
- NETWORK_LINK parameter, data pump
- new parameter
- newlogpath
- Next Extent
- Next Extent setting
- next extent, clusters
- next extent, materialized views
- next used filegroup action
- NEXT VALUE FOR function
- nls_... options
- no-... pg_dump options
- no-... pg_restore options
- NO ACTION delete rule
- NO ACTION delete/update rule
- NO ACTION, MySQL foreign key
- NO BOM/ENDIAN encoding
- NO CACHE argument
- no chkpt on recovery
- NO CYCLE argument
- no free space acctg
- NO RECOVERY durability option
- No Sort index setting
- No Sort unique key setting
- NO SQL function setting
- NO_COMPRESSION backup options
- NO_STATS, ADMIN_MOVE TABLE
- NO_TARGET_LOCKSIZE, ADMIN_MOVE TABLE
- No. of Block Pages setting
- NOAUDIT
- NOCHARDEL
- NOCHECKSUM backup options
- NOCREATEDB setting
- noclear sysmon option
- NOSUPERUSER setting
- no-create-db MySQL option
- no-create-info MySQL option
- no-data MySQL option
- NodeAddr
- NODEFER(PREPARE)
- nodegroups
- nodes
- NODOUBLEDEL
- NOEXEC
- NOFORCE disk group option
- NOFORCE disk mounting option
- NOFORMAT backup options
- NOINIT backup options
- NOLOGFILE
- NON_ANSI_NULL_VARCHAR
- NON_CLUSTER, ADMIN_MOVE TABLE
- non-clustered index, same segment warning
- NONE update/delete rule
- nonuniique
- nonunique index type
- nonunique indexes
- Norely primary key setting
- NOREPAIR clause, disk groups
- NOREWIND backup options
- NORMAL disk (ASM) state
- normal offline mode
- NOSKIP backup options
- NOT ENFORCED option
- Not For Replication setting
- NOT NULL, PostgreSQL tables
- notifications
- notifications, SQL Agent
- NOUNLOAD backup options
- NoValidate index constraint status
- NSU lock state
- ntext
- num_db_backups
- num_freqvalues
- num_iocleaners
- num_ioservers
- num_log_span
- num_quantiles
- numarchretry
- Number of Extents unique key setting
- number of... Sybase parameters
- number, user message
- NUMBLOCKPAGES
- numeric functions, pasting syntax
- numeric roundabout
- numsegs
- NVARCHAR
- nvarchar
- nvarchar(max)
- NVARCHAR2
O
- o/s file descriptors
- O7_DICTIONARY_ACCESSIBILITY
- OAM Page Ratio setting
- OBID table setting
- object actions
- object editors
- object lockwait timing
- object operations
- object properties action
- Object Status
- object types
- object_... options
- objects, database
- associated with users
- at maximum extent
- copying names
- creating
- dropping
- editors
- extracting DDL
- extraction
- filtering from tree view
- growth reports
- included in datasource index
- invalid
- locked
- migration
- navigating, Explorer
- no room to expand
- open
- owning user, DB2 Z/OS
- problem
- publishing HTML reports
- reloads
- searching for strings
- segments, associated
- space usage details
- suspect
- tablespace details
- tablespace-associated
- transferring ownership
- user dependencies
- viewing/organization options
- visual difference
- OF clause
- offline
- OFFLINE RANGE
- offline, setting databases
- ogprimary
- OIDS
- olap_page_pool_size
- old_passwords
- Ole Automation Procedures
- OLE methods
- OMF
- ON ALL SERVER argument
- ON COMMIT, PostgreSQL
- ON DATABASE argument
- ON DELETE
- ON FILEGROUP
- PostgreSQL foreign keys
- ON UPDATE
- ON_CHARSET_CONVERSION_FAILURE
- OneNote style tabs
- PostgreSQL foreign keys
- online
- Op, check tables results
- Op, repair tables results
- open (logs/error logs) action
- open cursors
- open databases and objects
- open databases memory
- open indexes memory
- open objects
- OPEN SYMMETRIC KEY
- open the key object action
- open_... options
- OPEN_EXISTING
- open_files_limit
- open... Sybase parameters
- Operative package setting
- operator class option
- operators
- operators, SQL Agent
- Optimal Size setting
- Optimization Hint package setting
- optimization hints, bind packages
- optimization, view queries
- optimization... Sybase parameters
- optimize for ad hoc workloads
- optimize tables object action
- optimizer hints, pasting syntax
- optimizer_... options
- Options
- options
- options (application)
- options/preferences
- Oracle
- Oracle job queue
- oracle job queues
- OS
- os_... options
- outbound packets
- outlines
- outln_pkg.drop_by_cat
- outln_pkg.drop_unused
- output parameters
- Output Window
- outstanding disk I/O
- outputs
- overflow
- Overflow Rows setting
- overflowlogpath
- Overhead setting
- owners
- ownership (objects), transferring
P
- P lock duration
- P lock type
- p locks
- pack keys
- package bodies
- package cache
- Package Size package setting
- Package Source package setting
- packages
- packet size
- packets
- Pad Index setting
- page activity
- page faults
- Page Fetch Pairs setting
- Page Fetch Pairs setting"DB2 z/OS indexes
- page settings
- Page Size tablespace setting
- Page Stealing Algorithm setting
- Page Writes package setting
- page... Sybase parameters
- paged memory
- paged memory available
- PageRelocations
- pages
- pages (memory)
- Pages Reserved setting
- PageSize
- pagesize
- paging
- paging (memory)
- paralellism, maximum degree of, indexes
- paralellism, maximum degree of, primary keys
- paralellism, maximum degree of, unique keys
- Parallel Degree setting
- Parallel Execution index settings
- Parallel Instances setting
- PARALLEL parameter, data pump
- parallel queries
- Parallel Query Option
- parallel query option
- parallel query ratio
- Parallel Sequential setting
- parallel_... options
- Parameter CCSID setting
- Parameter Style setting
- parameterized literals
- parameters
- parent_path_locator
- parentheses, matching check
- PARFILE parameter, data pump
- PARITY redundancy
- parse execute ratio
- Parsed Size setting
- parsing
- partition functions
- partition scheme
- partition schemes
- Partition Type index setting
- PARTITION_OPTIONS parameter, data pump
- partition... Sybase parameters
- range-
- Partitioning
- partitions
- associated with bufferpools
- buffer throughput
- capacity/growth statistics
- editing in DB2 Z/OS tables
- for materialized query tables
- indexes, Oracle
- indexes, SQL Server
- moving nodegroups
- primary keys, Oracle
- tables, DB2 LUW
- tables, SQL Server
- tables, Sybase
- tablespace
- truncate operation
- unique keys, Oracle
- password
- password, Developer Network
- passwords
- paste sql statement
- paster end of line options
- path, database device default
- paths
- pause, server
- pckcachesz
- PDS Name package setting
- per object statistics active
- Percent Free primary key setting
- Percent Free setting
- percent free, extents
- Percent Free,/Used setting
- Percent Increase setting
- percent increase, extents
- percent increase, materialized views extents
- percent used, extents
- percent... Sybase parameters
- Performance Analyst
- Performance Analyst for DB2
- Performance Analyst for Microsoft SQL Server
- Performance Analyst for Oracle
- performance databases
- Performance Explorer node
- performance monitoring option
- PERIOD... clauses
- permanent generation size
- permission cache entries
- permissions
- PGA
- pga_aggregate_target
- pg_dump
- pg_prepared_xacts
- pg_restore
- PGSTEAL setting
- PH timeout (s)
- PH1
- physical memory, total installed
- physical name
- physical name, dump device
- pid_file
- Piece Size index settin
- Piece Size index setting
- Piece Size primary key setting
- pin read hits
- pinned objects
- piped sorts
- pipe-delimited file type
- PL/SQL Debugger
- PL/SQL Profiler
- PL/SQL Profiling
- placement, databases
- plain text pg_dump option
- Plan Cache, SQL Agent
- plan text... Sybase parameters
- plans
- platforms
- plscope_settings
- plsql_... options
- pools
- population status object action
- port parameter
- position lock duration
- post-data pg_dump option
- post-data pg_restore option
- post threshold sorts
- Postgres
- postponed threads
- PP lock type
- pre-data pg_dump option
- pre-data pg_restore option
- pre_page_sga
- precision
- precision, function parameters
- Precompile Timestamp package setting
- precompiles
- precomplie options
- precompute rank
- preferences
- preferences (application)
- prefetch
- Prefetch Size setting
- prefetch strategy
- Prefetch Strategy setting
- prefetch, async
- prefetchers
- prelink options
- preload_buffer_size
- prepare batch query option
- prepared statements
- prepared transactions
- prepared_stmt_count
- PreserveSource
- primary
- primary keys
- Primary Space Allocation
- prinmary keys
- print... Sybase parameters
- priority boost
- priority changes, total
- private key, certificate
- private SGA
- private sort memory
- private workspaces
- privileged mode
- problem jobs
- problem objects
- problem tablespaces
- procedure cache
- procedure cache size
- procedure plan
- procedure plans
- Procedure... configuration parameters
- Procedures
- procedures
- aged out of cache
- building
- creating for Oracle
- creating synonyms to
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, Oracle
- creating, SQL Server
- creating, Sybase
- DDL string search
- details by user
- editor, IBM DB2 Z/OS
- editor, IBM LUW
- editor, Oracle
- editor, SQL Server
- editor, Sybase
- extract options
- files, opening
- hiding source text
- hot
- job queue
- migration options
- number executed, sample interval
- pasting SQL to editor
- reads from disk
- requests (execution)
- requests from disk
- process wait events
- processadmin server role
- processes
- active
- active user
- active users
- bottlenecks, top
- cancelling
- currently blocked
- currently running
- inactive
- inactive users
- inactive, user
- internal executed, sample interval
- number of
- number on server
- support summary
- top CPU, Oracle
- top CPU, Sybase
- top I/O, DB2
- top I/O, Oracle
- top I/O, Sybase
- top memory, DB2
- top memory, Oracle
- top memory, Sybase
- total on server
- workload-based statistics
- processes parameter
- processes, DB2
- processor
- percent time working
- percent time, user mode
- percentage busy time
- percentage time working, DB2
- queue length, DB2
- queue length, Oracle
- queue length, SQL Server
- queue length, Sybase
- queue, number of threads
- speed, DB2
- speed, Oracle
- speed, SQL Server
- speed, Sybase
- threads in queue
- type, DB2
- type, Oracle
- PROD category
- profiles
- programs
- project management
- Projects
- Adding Database Objects
- Adding Files
- Build Order
- Closing
- Creating
- Creating From a Database
- Creating From a Version Control Project
- Creating From Existing Files
- Creating Without Initialization
- Executing Files
- File Properties
- Management
- New Project
- Opening a File
- Opening a Recent Project
- Opening an Existing Project
- Project Management
- Properties
- Setting the Build Order
- Subfolder Properties
- Subfolders
- Working with
- protocol_version
- protocol= MySQL option, backup
- protocol= MySQL option, import
- PROVIDER_KEY_NAME, asymmetric keys
- PROVIDER_KEY_NAME, symmetric keys
- proxy tables
- PRUNE set integrity option
- PSRBD status code
- public, database device
- Publication Server setting
- published
- Publisher/Subscriber setting
- purge recycle bin action
- purge recycle bin entry action
- purging, recycle bin
Q
- QA category
- Qualifier package setting
- queries
- query
- Query Buiilder
- Query Builder
- Adding a Join
- Auto Join Properties
- Auto Joins
- Auto Layout
- Building a CREATE VIEW Statement
- Building a DELETE Statement
- Building a Query
- Building a SELECT Statement
- Building an INSERT Statement
- Building an UPDATE Statement
- Column Properties
- Creating a Clause
- Creating a GROUP BY Clause
- Creating a HAVING Clause
- Creating a WHERE Clause
- Creating an AND Clause
- Creating an ORDER BY Clause
- Design
- Display Options
- DML Tab
- Editing Joins
- Execution Properties
- Explorer
- files, opening
- General Properties
- Getting Started
- Inserting an AND or OR Clause
- Joins
- Keyboard Commands
- Moving Additional Tables to the SQL Diagram Pane
- Moving Columns in the SQL Statement Tree
- Moving Tables
- Moving Tables and Columns in the SQL Statement Tree
- Moving Tables and Views
- Moving Tables in the SQL Statement Tree
- Opening Queries
- options/preferences
- Removing a Join
- Results Tab
- Saving Queries
- Saving Queries as XML
- Schema Change Detection
- Selecting a Statement
- Selecting ALL Columns
- Selecting an Instance or Database
- Selecting Columns
- Selecting Columns in the SQL Diagram Pane
- Selecting Columns in the SQL Statement Tree
- Selecting DISTINCT Columns
- Selecting Tables
- Setting Column Properties
- setting options/preferences
- SQL Diagram Pane
- SQL Statement Pane
- SQL Tab
- Statement Properties
- Subqueries
- Syntax Checker
- Table Properties
- Table Shortcut Menus
- Tables in the SQL Diagram Pane
- Tables/Views Tab
- Toolbar
- Using
- Using Data Editor with Query Builder
- View Properties
- Working with Tables in the SQL Diagram Pane
- Workspace Window Options
- query cache type mySQL query option
- query governor cost limit
- Query Optimization package setting
- QUERY parameter, data pump
- query plans
- query rewrite, materialized views
- query wait (s)
- query_... options, MySQL
- query_... options, Oracle
- QUERY_PLAN_... options
- QUERY_ROWS_RETURNED_LIMIT
- QUERY_TEMP_SPACE_LIMIT
- QUERY_TIMING
- Query... configuration parameters
- QUERY= parameter
- queue length, average
- quick MySQL option
- quick option, check tables
- quick option, checksum tables
- quick option, repair tables action
- quiesce database action
- quiesce instance action
- quiesce tablespace object action
- quiesces
- quotas, user
- quoted identifier
- quoted identifiers
- QUOTED_IDENTIFIER
- quote-names MySQL option
- quotes
- quote-all-identifiers pg_dump option
R
- R lock status
- R lock type
- RAM
- random_page_cost
- range
- range partitions
- range_alloc_block_size
- range-hash/list composite
- ratios
- RBDP, status code
- RBDP* status code
- rdbms_server_dn
- read
- read access
- read committed with lock
- read only
- read_... options
- read_only_open_delayed
- 2011
- reads
- activity level, log
- average disk queue requests
- average queue length
- average queued
- block I/O requests
- byte count
- bytes per transaction
- disk time
- elapsed time
- error count
- logical
- number of physical
- number of, server
- number of, total
- paging statistics
- physical I/O statistics
- physical, per second
- procedure requests from disk
- queued requests average
- ratios, writes
- rows, total
- total count
- transfer rate
- transfers per second
- vectored I/O requests
- READS SQL DATA function setting
- reassign by category object action
- rebalance disk group operation
- rebalance object action
- rebalance status
- REBIND
- rebind package
- rebind plans
- rebinds
- REBUILD
- rebuild
- rebuild full-text catalogs action
- Rebuild Index
- rebuild outlines object action
- rec_his_retentn
- RECID
- recompilations
- recompile object action
- recompute statiistics
- RECONFIGURE/GO/EXEC sp_configure
- records
- recover abort action
- recover commit action
- recover tables operation
- RECOVERY DESTINATION
- recovery interval (min)
- recovery interval in minutes
- Recovery Status setting
- recovery_parallelism
- RecoveryUrgency
- RECP status code
- recursive triggers
- Recursive... configuration parameter
- recycle bin
- recyclebin
- redistribute object action
- REDO LOG
- redo log
- redo log groups
- REDO THREAD
- redo_transport_user
- Reduce option, tablespaces
- reducing a container
- redundancy, ASM templates
- redundancy, disk groups
- referential contraints
- refit object action
- REFP status code
- Refresh Method materialized view setting
- refresh table object action
- refresh, materialized query tables
- registration code
- registration, product
- registry
- regular expression
- regular expressions
- regular expressions, file search
- reinitialize object action
- RELAXED polcy, caches
- relay_... options
- RELDP status code
- release
- Release Bound package setting
- reloads, object
- RelocatableHeapPages
- Rely primary key setting
- Rely unique key setting
- REMAP_DATA parameter, data pump
- REMAP_DATAFILE parameter, data pump
- REMAP_SCHEMA
- REMAP_TABLE parameter, data pump
- REMAP_TABLESPACE
- remote access
- remote admin connections
- remote connections
- remote login timeout (s)
- remote proc trans
- remote query timeout (s)
- remote server pre-read packets
- remote servers
- remote_... options
- RemoteTrunc
- REMOVABLE RECOVERY FILES
- RENAME
- rename action style
- Reoptvar package setting
- reordering parameters
- REORG, ADMIN_MOVE TABLE
- reorganization, tables
- reorganize
- reorganize full-text catalogs action
- Reorganize Tablespace
- REORP status code
- REPAIR clause, disk groups
- repair tables object action
- REPEAT_INTERVAL attribute
- Replacement Strategy setting
- REPLAY, ADMIN_MOVE TABLE
- replication
- replication throughput details
- Replication XPs
- replication_dependency_tracking
- reports
- ReqType
- request blocks
- requests, dirty read
- Reserve Page Gap setting
- Reserved Pages setting
- Resize
- resizing a container
- Resource Cost
- Resource Limit Wizard
- Resource Limits
- resource pool statistics
- Resource Release package setting
- resource_... options
- response time
- responses, SQL Agent
- restart sequence
- restart sequence action
- RESTART WITH argument
- RESTARTABLE attribute
- restarts, dirty read
- restore
- PostgreSQL databases
- RESTORE POINT
- restore point
- RESTORE VERIFYONLY
- restore_pending
- Restoring Databases
- RESTP status code
- RESTRICT delete/update rule
- RESTRICT WHEN DELETE TRIGGERS clause
- restrict_access
- RESTRICT,MySQL foreign key
- RESTRICTdelete rule
- RestrictDrop setting
- RestrictDrop table setting
- restricted tablespaces
- Result Sets
- result_... options
- results
- results (ISQL) options
- Results editor
- results window
- results, SQL
- resumable_timeout
- resume, server
- resynchronize object action
- RETAINDAYS backup options
- return values
- returns
- returns, functions
- reuse max, password
- REUSE STORAGE clause
- reuse time, password
- REUSE_DATAFILES
- REUSE_DUMPFILES
- Reverse index setting
- Reverse primary key setting
- reverse scans, indexes
- Reverse unique key setting
- REVOKE
- REWIND backup options
- Right Outer Joins
- RIGHT, partition function range
- RMAN CONFIGURATION
- RMAN STATUS
- RO status code
- Roles
- roles
- rollback
- Rollback Segments
- rollback segments
- rollback_segments
- RollbackLogPages
- rollbacks
- rollbacks, materialized views
- rollfwd_pending
- rortate log object action
- roundrobin partitions
- row
- Row Compression setting
- row count
- row counts
- Row Movement property
- Row Movement setting
- Row Organization setting
- row_identifier, Sybase IQ locks
- row... Sybase parameters
- ROWPAGES
- rows
- RPC Out Server setting
- rpc security model
- rpl_recovery_rank
- RSA_212/1024/2048
- rtm thread idle wait period
- rule binding
- Rules
- rules
- Run Job object action
- run job object action
- run script with batch execution
- running jobs detail
- runstats
- RunStats Index operation
- RunStats Tablespace operation
- runtime variables MySQL query option
S
- S lock state
- S lock type
- s locks
- safe updates, MySQL query option
- SALT, Oracle columns
- sample query response time
- sampling percent
- satoiq_count
- save point function setting
- scalar functions, pasting syntax
- scalar, return
- scale
- Scale setting
- scan for startup procs
- scan point revalidations
- schedule
- scheduler (Oracle)
- scheduler, Microsoft
- schedules
- schedules, SQL Agent
- schema
- schema object operation
- Schema Path package setting
- SCN
- scratch database
- Scratchpad Length setting
- scratchpad option
- Scratchpad setting
- Scratchpad settings
- screen tips
- script execution facility
- Script Files
- scripts
- search
- sec_... options
- secondary
- secondary database devices
- secondary indexes, uniqueness
- secondary logs
- Secondary Space Allocation
- section pg_dump option
- section pg_restore option
- sectors
- secure default login
- secure_auth
- security model a/b
- Security Policy setting
- securityadmin server role
- Segment Name setting
- Segment setting
- segmented tablespaces
- segments
- SELECT
- Select * From operation
- select into/bulkcopy/pllsort
- select on syscomments.text
- SELECT statements
- self_tuning_mem
- semantic validation
- send doneinproc tokens
- Separate... configuration parameters
- seq_page_cost
- seqdetect
- sequences
- sequencess
- Sequential Pages setting
- Sequential Steal setting
- serial number
- serial write enforcement
- serial_reuse
- server
- Printing
- Saving
- server roles
- server system variables
- server trigger recursion
- server triggers
- server_id
- serveradmin server role
- SERVERERROR
- servers
- service_names
- Session Details
- Session Files
- Session Information
- Session Recording
- session_... options
- sessions
- sessions Per User setting
- SET "_recyclebin"=
- SET DEFAULT update/delete rule
- SET GLOBAL...
- set integrity object operation
- SET NULL delete rule
- SET NULL update/delete rule
- SET NULL, MySQL foreign key
- SET NULLdelete rule
- set online/offline object operation
- SET Options, SQL Server query option
- SET ROLE
- SET SCHEMA option
- set statistics action
- SET STATISTICS clause
- SET STORAGE clause
- set undo object operation
- set working set size
- SET...
- set... options
- setting lock time
- Setting Scope Level
- setupadmin server role
- sga_... options
- shadow_core_dump
- shadows
- shared memory starting address
- shared sort memory
- shared workspaces
- shared_... options, MySQL
- shared_... options, Oracle
- sheapthres_shr
- Shortcut Menus
- shortcuts
- show advanced options
- Show Only My Objects
- Show System Objects
- SHOW_STATISTICS DBCC option
- SHOWCONTIG DBCC option
- shrink object operation
- Shrinks setting
- shutdown
- Side option
- single user
- single user database
- single-transaction MySQL option
- SIX lock state
- size
- size of... Sybase parameters
- Size setting
- SKIP backup options
- skip_... options
- skip_unusable_indexes
- skip-comments MySQL option
- skip-set-charset MySQL option
- slave_... options
- sleep ratio, latch
- slow_launch_time
- Smart Docking
- SMO and DMO XPs
- SMS tablespaces
- SMTP
- smtp_out_server
- softmax
- sort
- sort heap space
- sort heaps
- Sort in Tempdb setting
- sort_... options
- sort_buffer_size
- sort, index setting
- sortheap
- sorting
- sorts
- Source SIze setting
- Source Size setting
- source text, hiding
- SOURCE_EDITION parameter, data pump
- sp_add_alert
- sp_add_job
- sp_add_jobstep
- sp_add_notification
- sp_add_operator
- sp_addalias
- sp_addremotelogin
- sp_addsegment
- sp_addsrvrolemember
- sp_adduser
- sp_bindcache
- sp_cacheconfig
- sp_cachestrategy
- sp_changedbowner
- sp_configure
- SP_DBEXTEND
- sp_dbextend
- sp_dboption
- SP_DISKDEFAULT
- sp_hidetext
- sp_iqconnection
- sp_iqhelp procedure
- sp_iqstatus
- sp_poolconfig
- sp_remoteoption
- sp_rename action style
- sp_sequence_get_range
- sp_start_job
- sp_stop_job
- sp_sysmon noclear
- sp_tempdb bind
- sp_tempdb unbind
- sp_update_job
- space
- clusters
- database object summary
- database usage details
- databases low on
- deallocating unused
- device details
- device summary, DB2
- device summary, Sybase
- device summary/details
- disk, details
- disk, free
- disk, total
- fragment summary
- free, disk
- I/O statistics
- indexes/tables summary
- logs low on
- top user accounts
- total used/free
- total/available statistics
- used, disk
- used/free statistics
- Space Analyst
- Analysis Report
- Convert to Dictionary-Managed
- Convert to Locally-Managed
- Database Devices Tab
- Database Overview Tab
- Databases Tab, SQL Server
- Databases Tab, Sybase
- Datafiles Tab
- Extract
- Files/Filegroups Tab
- Functionality
- Indexes Tab, Oracle
- Indexes Tab, Sybase
- Licensing
- LOB data
- Map
- Map Tab
- Objects Tab
- Open
- Opening
- Options
- options/preferences
- options/preferences/defaults
- Product Design
- Reports
- Storage Overview Tab
- Tables Tab, Oracle
- Tables Tab, Sybase
- Tablespace Map Tab
- Tablespace Status
- Thresholds Options
- Space Analyst Expert Guide
- Space Analyst for IBM DB2 for Open Systems
- Space Analyst for IBM DB2 for Windows/Unix
- Space Analyst for Microsoft
- Space Analyst for Microsoft SQL Server
- Space Analyst for Oracle
- Space Analyst for Sybase ASE
- Space Management Wizard
- space utilization
- space-delimited data
- special registers
- specific name, methods, DB2 LUW
- spfile
- spgist index method
- spinlocks
- SQL
- activity by application
- activity, applications
- bind variable parameterization
- DDL statements executed statistic
- dynamic statements executed
- dynamic statements/sec statistic
- dynamic, cache statistics
- executed during migration
- execution details
- files, opening
- I/O activity
- logging options
- method type, DB2 LUW
- parameter style
- parse execute ratio
- pasting syntax
- recent activity
- recompilations/sec triggered
- reloads
- sample, by user
- script directory
- statement count
- statements executed statistics
- statements failed
- static statements executed
- static statements/sec statistic
- top results
- top statements (execution)
- sql
- SQL * Loader
- SQL * Loader Utility
- SQL Access Level setting
- SQL batch capture
- SQL Big Selects MySQL query option
- SQL Editor
- SQL editor
- sql editor
- SQL Error package setting
- SQL execution
- SQL Logging
- SQL Mail XPs 0 0 0 1
- SQL Perfmon Integration
- SQL Scripting
- SQL SELECT
- SQL Server
- SQL Server Agent. See Agent, SQL Server
- sql server clock tick length
- SQL SERVER EVENT ALERT
- SQL SERVER PERFORMANCE CONDITION ALERT
- sql text pipe active
- sql text pipe max messages
- SQL Warn/Math Warn package setting
- sql_... options, MySQL
- sql_... options, Oracle
- SQL_FLAGGER_ERROR_LEVEL
- SQL_FLAGGER_WARNING_LEVEL
- sql92_security
- SQLFILE parameter, data pump
- sqltune_category
- square brackets, matching check
- stack... Sybase parameters
- staging tables
- STANDBY DATABASE MATRIX
- Start Database operation
- start date
- start mail session
- START WITH argument
- START_DATE attribute
- start/stop job action
- stat_heap_sz
- statement triggers
- statement... Sybase parameters
- static SQL statements/sec statistic
- statistics
- Statistics Recompute setting
- statistics.computng, SQL Server indexes
- STATS backup option
- status
- status bar
- Status package setting
- STATUS parameter, data pump
- STATUS, check tables results
- STATUS, repair tables results
- Stay Resident procedure setting
- step execution facility
- step values
- steps, SQL Agent
- stmtheap
- Stogroups
- stogroups
- Stop database operation
- Stop Job object action
- STOP status code
- STOP_ON_ERROR backup options
- STOP_ON_WINDOW_CLOSE attribute
- STOPE status code
- STOPLIST
- STOPP status code
- Storage
- storage
- storage engine
- Storage Group database setting
- Storage Group primary key setting
- storage_engine
- stored outlines
- stored procedures
- storge paths, dropping
- STREAMS_CONFIGURATION parameter, data pump
- strict dtm enforcement
- STRICT policy, caches
- String Delimiter package setting
- STRING_RTRUNCATION
- StringHistogramsFix
- strings
- stripe
- STRIPLZEROS
- Structured Types
- structured types
- style
- subfolders
- subject, certificate
- Subpartition type index setting
- subscribed
- Subscription Server setting
- subsystem
- SUID parameter
- summary reports, Capacity Analyst
- SUPERUSER setting
- suspect databases, SQL Server
- suspect databases, Sybase
- suspect pages, databases with
- SUSPEND
- suspend audit when device full
- sw locks
- swap memory
- SWAP, ADMIN_MOVE TABLE
- switch logfile action
- switch online object operation
- syb_sendmsg port number
- Sybase
- Sybase ASE
- Sybase IQ
- Sybasse IQ
- symmetric keys
- sync_... options
- synchronous I/O operations
- SyncTrunc
- synonyms
- syntax
- Syntax Check
- syntax, pasting into editor
- sysadmin server role
- SYSDATE pseudocolumn
- SysEntries package setting
- sysmon, noclear option
- sysstatistics flush interval
- SYSTEM
- system
- system calls
- system change number
- system diagnostics, pasting syntax
- system functions
- system indexes
- System Required setting
- system tables
- SYSTEM tablespace
- system triggers
- system_time_zone
- system/configuration options
- systemwide password expiration
T
- T lock type
- Tab Menu
- tab MySQL option
- tab-delimited data
- tab-delimited file type
- table
- table locks, Sybase IQ
- Table Status setting
- Table Tablespace setting
- Table Type setting
- table_... options
- TABLE_EXISTS_ACTION
- table_name, Sybase IQ locks
- table_type, Sybase IQ locks
- TableBitMaps
- tables
- activity, Oracle query option
- alias creation shortcut
- allocating extents to
- analyzing
- associated triggers
- capacity/growth statistics
- chained
- changing owners
- changingschema
- check for errors
- checksum
- column summary
- copying from existing
- creating synonyms to
- creating views from
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, Oracle
- creating, SQL Server
- creating, Sybase
- DDL string search
- deallocating unused space
- default segment warning
- deleting statistics
- disabling keys
- dropping clone
- dropping unused columns
- editor, DB2 LUW
- editor, DB2 Z/OS
- editor, MySQL
- editor, Sybase
- enabling keys
- estimating size
- event monitor, event type
- exchange data, clone
- extents allocated to
- extracting data as XML
- flashback
- flushing
- growth reports
- hiding source text
- high watermark, block
- hot
- indexes, same tablespace
- list of quiescers
- lock escalations
- locking
- moving between tablespaces
- moving tables in the SQL Diagram Pane
- optimizing
- partitioning for Oracle
- pasting SQL to editor
- recompiling
- recover from recycle bin
- reorganization record
- repairing
- segment placing
- selecting all data from
- shrinking
- space summary
- storage engine
- support for
- temporal
- truncating
- updating statistics
- TABLESPACE
- Tablespace Buffer Pool database setting
- tablespaces
- abnormal, count
- and dropping storage paths
- and materialized views
- cached blocks
- capacity/growth statistics
- changing owners
- changing status
- check data
- check index operation
- coalescing
- container details
- copy to copy
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, Oracle
- creating, PostgreSQL
- database placement
- datafile sizes
- datafiles at extent limit
- default, setting
- details, all on database
- DMS, total space
- DMS, utilization > 80%
- editor, DB2 LUW
- editor, DB2 Z/OS
- editor, Oracle
- extent details
- extents, rebalance status
- files closed
- for materialized query tables
- growth/failure prediction reports
- highest reads/writes
- in unique keys
- inaccessible containers
- inaccessible/offline statistic
- index creation warning
- low on space, DMS
- lowering high water mark
- materialized view logs
- modify recovery operation
- modify statistics operation
- moving tables between
- object creation warnings
- object details
- offline
- primary key settings
- problem
- purge recycle bin options
- quiesced statistic
- quiescing
- rebalancing
- RunStats Index operation
- RunStats operation
- segment management
- set undo action
- space by object type
- support for
- switching online
- tables/indexes in same
- user default/temporary
- user quotas
- tablespaces, restricted status
- TablesQualTriggers
- tabs
- take checkpoint action
- tape retention in days
- tape stacking option
- tar, pg_dump option
- tar pg_restore opton
- TARGET_EDITION parameter, data pump
- target, SQL Agent job
- targetmap nodegroup redistribution option
- task context switches
- task scheduler
- tcp no delay
- Technical Requirements
- tempdb percent full
- TempFileName
- templates
- temporal tables
- temporary databases
- temporary object activity
- temporary offline mode
- temporary tables
- temporary tables, migration options
- TempTablePages
- TempTableSpaceKB
- TempWorkingSpaceKB
- territory Database
- TEXT
- text
- text prefetch size
- The
- THREAD INSTANCE NAME MAPPING
- thread_... options
- threads
- Threadsafe function setting
- Threadsafe setting
- threshold cleaners triggered
- thresholds
- thresholds/alarms
- time formats
- time series functions, pasting syntax
- time slice
- time_... options
- time-based settings
- timeout
- timeouts
- Timestamp package setting
- timestamp parameter
- TIMESTAMPFORMAT
- timing, trigger
- timing, triggers
- timing, triggers
- tmp_table_size
- tmpdir
- toast settings
- Token Matching Capability
- tokens
- Toolbars
- toolbars
- Tools
- Tools Menu
- top I/O waits
- top log file waits
- top memory process
- top... statistics
- bottlenecked events
- CPU process, DB2
- CPU process, Oracle
- CPU process, Sybase
- database file waits
- fragmented datafiles
- I/O hogs
- I/O process, DB2
- I/O process, Oracle
- I/O process, Sybase
- I/O waits
- latch misses
- memory hogs
- memory process, Oracle
- memory process, Sybase
- processes
- session bottlenecks
- sessions
- space, user accounts
- SQL details
- SQL results
- SQL statements
- system bottlenecks
- workload-based
- torn page detection
- Total Keys setting
- Total Pages Modified setting
- total priority changes
- Total Rows Modified Since Last setting
- Total Sections package setting
- total... Sybase parameters
- traces
- trackmod
- transaction
- transaction log analysis
- transaction log files
- transaction log writes
- transaction_... options
- transactional analysis
- transactions
- TransactionsSpanLogs
- Transact-SQL compatibility
- transfer ownership
- transfer rate
- Transfer Rate setting
- transfer rate, DB2
- transfer rate, Oracle
- transfers
- transfers per second.disk
- transform noise words 0 0 0 1
- TRANSFORM_DATAFILES parameter, data pump
- TRANSFORM_FULL_CHECK parameter, data pump
- TRANSFORM_TABLESPACES parameter, data pump
- transmission
- transmission rate statistics
- transmission statistics
- transparent data encryption
- TRANSPORTABLE parameter, data pump
- traverse order
- TriggerPages
- triggers
- adding login
- changing status
- columns firing, Oracle
- columns firing, PostgreSQL
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, Oracle
- creating, PostgreSQL
- creating, SQL Server
- DB2 z/OS events
- DDL string search
- dropping login
- editor, DB2 Z/OS
- editor, IBM DB2 LUW
- editor, Oracle
- editor, SQL Server
- editor, Sybase
- enabling/disabling
- events, DB2 LUW
- firing events, Oracle
- function path
- function path, DB2 LUW
- hiding source text
- login
- pasting SQL to editor
- support for
- support for, summary
- timing, DB2 LUW
- timing, DB2 z/OS
- type, DB2 LUW
- type, DB2 z/OS
- trouble-shooting, connections
- trunc log on chkpt
- TRUNCATE
- truncate object operation
- truncate trigger
- Truncating
- truncation
- tsm_mgmtclass
- tsm_nodename
- tsm_owner
- tsm_password
- T-SQL Debugger for Microsoft
- TSQL_VARIABLES
- two digit year cutoff
- txn to pss ratio
- TxnID
- type
- Type Bodies
- type bodies
- types
U
- U lock state
- UI
- UID pseudocolumn
- ULC flushes
- unbind from temporary database action
- unbinding logins from
- UNCHECKED set integrity option
- undrop disk operation
- UNICHAR
- unicode
- UNICODE encoding
- Unicode support
- unified login required
- uniform nodegroup redistribution option
- unique
- unique auto_identity index setting
- unique index type
- unique keys
- unique setting
- 2012
- UniqueIdentifier
- uniqueness, secondary indexes
- UNITEXT
- units of work
- UNIVARCHAR
- range-
- UNKNOWN disk (ASM) state
- UNKNOWN disk group state
- Unlimited Max Size setting
- UNLOAD backup options
- unload data
- unlock button (SQL Editor/datasource)
- unlogged table, PostgreSQL
- unmirror object operation
- unnable process search count
- unnamed variables
- UNPROTECTED redundancy
- unquiesce object operation
- unregistering datasources
- unused space, deallocating
- update rule
- UPDATE statements
- UPDATE STATISTICS
- update statistics object action
- UPDATEs
- updates
- UPDATEUSAGE DBCC option
- upgrade version
- usage
- use FRM file option, repair tables action
- use security services
- USE statements
- USE_CURRENT_SESSION attribute
- Used Pages setting
- used space
- user ... Sybase parameters
- user connections
- User Datatypes
- user datatypes
- user ID, Developer Network
- user interface preferences
- user messages
- user mode
- user mode thread execution time
- user mode, percent time processor in
- user mode, processor time in
- user options
- user processes
- USER pseudocolumn
- USER views
- user_exit_status
- user_id, Sybase IQ locks
- userexit
- user-related I/O operations
- users
- active, processes
- alias definition
- assigned to logins, SQL Server
- assigned to logins, Sybase
- assigning to groups (Groups Editor)
- assigning to groups (User Editor)
- assigning to profiles
- changing password
- connected, Sybase IQ
- copying from existing
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, MySQL
- creating, Oracle
- creating, SQL Server
- creating, Sybase
- database links, associated
- editor, DB2 Z/OS
- editor, IBM DB2 LUW
- editor, MySQL
- editor, Oracle
- editor, SQL Server
- editor, Sybase
- extracting logins with
- hiding source text
- purge recycle bin options
- quiescing database to
- quiescing instance to
- role assigment
- support for
- tablespace quotas
- top account space
- use-set session authorization pg_dump option
- use-set-session-authorization pg_restore option
- UT status code
- UTF encoding
- UTF save options
- util_heap_sz
- Utilities
- Archive Activity
- Chained Row Analysis
- Data Export Wizard for IBM DB2 for Windows/Unix
- Data Export Wizard for Oracle
- Data Import Wizard for IBM DB2 for Windows/Unix
- Data Load Wizard for Microsoft SQL Server and Sybase ASE
- Data Unload Wizard for Microsoft SQL Server and Sybase ASE
- Database Backup Wizard
- Database Monitor
- Free Space Deficit
- Instance Parameter Configuration
- Logfile
- Maximum Extent Limits
- Pinned Code
- Resource Limits
- Session Information
- utility, start database option
- utilization
- UTRO status code
- UTRW status code
- UTUT status code
V
- Valid package setting
- VALID UNTIL setting
- Validate index constraint status
- Validate package setting
- Validate unique key setting
- validation, bind packages
- ValidProc table setting
- VARCHAR
- varchar
- VARCHAR2
- VariableHashSize
- variables
- VBScript
- VC Files Tab
- VCAT
- VCAT Catalog primary key setting
- vectored I/O requests
- vendoropt
- verbose pg_dump option
- verbose pg_restore option
- verify function, password
- VERIFY, ADMIN_MOVE TABLE
- version
- Version Control
- version control
- VERSION parameter, data pump
- version_... options
- Vertical Deferred Write Threshold setting
- victim page cleaners
- view
- view job history action
- ViewPages
- views
- alias creation shortcut
- associated triggers
- changing owners
- changing schema
- column summary
- creating from a table
- creating synonyms to
- creating, DB2 LUW
- creating, DB2 z/OS
- creating, Oracle
- creating, PostgreSQL
- creating, SQL Server
- DDL string search
- editor, DB2 LUW
- editor, DB2 Z/OS
- editor, Oracle
- editor, SQL Server
- editor, Sybase
- hiding source text
- pasting SQL to editor
- query optimization
- support for
- update statistics, DB2 LUW
- updating statistics
- virtual address, Sybase databases
- virtual columns
- virtual machine options, Java
- visual difference
- visual style
- Volatile setting
- Volatile table setting
- Volatile, materialized query tables
- VPPSEQT setting
- VPSEQT setting
- VPSIZE setting
- VPTYPE setting
- VSTART
W
- W lock status
- W lock type
- w locks
- wait event timing
- wait events
- wait statistics, SQL Agent
- wait time
- wait_timeout
- waits
- activity, Oracle query option
- buffer busy, count
- current
- details, by event
- enqueue
- file, top
- free list
- historical
- lock requests requiring
- log file, top
- on execution plans
- session, total/wait time percentages
- sessions on
- system statistics
- system, total/wait time percentages
- time, locks
- top bottlenecks
- total, statistic
- Waits setting
- WARNING, check tables results
- WARNING, repair tables results
- Warnings
- warnings
- wash size
- wastage, redo logs
- WEPR status code
- WHAT argument, job queue
- WHERE
- Windows
- Windows authentication
- WITH ALGORITHM
- WITH DATA
- WITH DEFAULT_LOCATION clause
- WITH DURABILITY= parameter
- WITH NO DATA
- WITH OIDS
- WITH OVERRIDE
- WITH PASSWORD523–524
- WITH PRIVATE KEY
- WITH PRIVATE KEY clause
- WITH SCRATCH_DATABASE
- WITH SUBJECT
- Without Login setting
- Wizard
- wizards
- wizards, default directories
- wlm_collect_int
- WMI EVENT ALERT
- WORKFILE database type
- workload
- workload group, SQL Agent
- workspaces
- Wraps setting
- write access
- writes
- activity level, log
- average disk queue requests
- average queue length
- average queued
- byte count
- bytes per transaction
- bytes written to disk
- disk time
- elapsed time
- error count
- number of
- paging statistics
- physical I/O statistics
- physical, number of
- physical, per second
- queued requests average
- ratios, reads
- total count
- transfer rate
- transfers per second
- Writes setting
- WSF export
X
- X lock state
- xact coordination interval
- XID, prepared transactions
- XML
- XML file type, results
- xmltype
- xp_cmdshell
- xp_cmdshell context
- XQUERY
- XTRANSPORT ASM template