Index
Special Characters   A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z 

P

packet encryption: data source [dbdsn] utility Data Source utility options
packet size: data source [dbdsn] utility Data Source utility options
packet size: limiting -p server option
-pt server option
PacketSize property: description Connection-level properties
PacketsReceived property: description Connection-level properties
Server-level properties
PacketsReceivedUncomp property: description Connection-level properties
Server-level properties
PacketsSent property: description Connection-level properties
Server-level properties
PacketsSentUncomp property: description Connection-level properties
Server-level properties
page size: choosing Initialization utility options
page size: databases Creating a database using the dbinit command-line utility
page size: maximum allowed -gp server option
page size: option Setting a maximum page size
page usage: information [dbinfo] utility Information utility options
PageRelocations property: description Database-level properties
pages: displaying usage in database files The Information utility
PageSize property: description Server-level properties
Database-level properties
parallel execution: processors -gt server option
parallel execution: threads -gx server option
Password [PWD] connection parameter: about Connection parameters
Password [PWD] connection parameter: about connection parameters Connection parameters
Password [PWD] connection parameter: description Password connection parameter [PWD]
Password [PWD] connection parameter: introduction to connection parameters How connection parameters work
Password [PWD] connection parameter: tips Connection parameter tips
Password [PWD] connection parameter: using default connection parameters Using default connection parameters
passwords: changing Changing a password
passwords: default DBA authority overview
passwords: encrypting EncryptedPassword connection parameter [ENP]
passwords: LTM configuration file The LTM configuration file
passwords: minimum length MIN_PASSWORD_LENGTH option [database]
passwords: ODBC configuration Login tab
passwords: utility database Utility database passwords
PATH environment variable: description PATH environment variable
PeakCacheSize property: description Server-level properties
percent sign: modulo or comment PERCENT_AS_COMMENT option [compatibility]
PERCENT_AS_COMMENT option: compatibility option Compatibility options
PERCENT_AS_COMMENT option: description PERCENT_AS_COMMENT option [compatibility]
PERCENT_AS_COMMENT option: obtaining value Connection-level properties
Performance Monitor: Windows Performance Monitor statistics
performance: cache size -c server option
-ca server option
-ch server option
-cl server option
-cs server option
-cw server option
performance: compression Adjusting communication compression settings to improve performance
performance: disk fragmentation Pre-allocating space for database files
performance: improving Improving performance when validating databases
performance: LTM Replicating transactions in batches
performance: monitoring Database performance statistics
Performance Monitor statistics
performance: options Controlling performance and memory from the command line
performance: PowerBuilder DataWindow OPTIMIZATION_GOAL option [database]
performance: prefetch PREFETCH option [database]
performance: primary keys Controlling transaction log size
performance: result sets OPTIMIZATION_GOAL option [database]
performance: server options What else is there to it?
performance: setting priorities BACKGROUND_PRIORITY option [database]
performance: TCP/IP Tuning TCP/IP performance
performance: transaction log The transaction log
Controlling transaction log size
performance: transaction log mirrors The transaction log
performance: TRUNCATE TABLE statement TRUNCATE_WITH_AUTO_COMMIT option [database]
permissions: conflicts How user permissions are assessed
permissions: connect Creating new users
permissions: DBA authority DBA authority overview
permissions: file administration statements Permission to execute file administration statements
permissions: granting passwords Creating new users
permissions: granting remote Granting and revoking remote permissions
permissions: group Managing groups
permissions: group membership Granting group membership to existing users or groups
permissions: groups Group permissions overview
Permissions of groups
permissions: individual Managing individual user IDs and permissions
permissions: inheriting Granting users the right to grant permissions
Managing groups
permissions: integrated login permissions Using integrated logins
permissions: listing Users and permissions in the system tables
permissions: loading data -gl server option
permissions: managing Managing User IDs and Permissions
permissions: options Controlling permissions from the command line
permissions: overview Database permissions overview
permissions: passwords Changing a password
permissions: procedures Granting permissions on procedures
permissions: RESOURCE authority RESOURCE authority overview
Granting DBA and RESOURCE authority
permissions: revoking Revoking user permissions
permissions: revoking remote Granting and revoking remote permissions
permissions: setting table permissions Granting permissions on tables
permissions: tables Table and views permissions overview
Granting permissions on tables
permissions: the right to grant Granting users the right to grant permissions
permissions: triggers RESOURCE authority overview
Execution permissions of triggers
permissions: unloading data -gl server option
permissions: views Table and views permissions overview
Granting permissions on views
Granting permissions on views
Using views and procedures for extra security
permissions: WITH GRANT OPTION Granting users the right to grant permissions
personal server: about Introduction
physical layer: troubleshooting Diagnosing wiring problems
physical limitations: Adaptive Server Anywhere Size and number limitations
ping utility: TCP/IP Testing the TCP/IP protocol
ping utility: testing networks Ensure that network communication software is running
ping utility: testing Open Client Verifying the server address
ping [dbping] utility: about The Ping utility
ping [dbping] utility: exit codes Troubleshooting connections using the dbping command-line utility
ping [dbping] utility: options Ping utility options
ping [dbping] utility: syntax Troubleshooting connections using the dbping command-line utility
pinging: servers The Ping utility
PINNED_CURSOR_PERCENT_OF_CACHE database option PINNED_CURSOR_PERCENT_OF_CACHE option [database]
planning: backups Scheduling backups
Designing a backup and recovery plan
plans: caching of MAX_PLANS_CACHED option [database]
Platform property: description Server-level properties
PlatformVer property: description Server-level properties
plug-ins: registry settings Registry settings on installation
polling frequency Setting the service polling frequency
port number: database server ServerPort communication parameter [PORT]
port number: TCP/IP Starting the database server as an Open Server
-x server option
ServerPort communication parameter [PORT]
PowerBuilder DataWindow: query performance OPTIMIZATION_GOAL option [database]
PRECISION option: description PRECISION option [database]
PRECISION option: setting Database options
PRECISION property: description Connection-level properties
PREFETCH option: description PREFETCH option [database]
PREFETCH option: DisableMultiRowFetch DisableMultiRowFetch connection parameter [DMRF]
PREFETCH option: setting Database options
PREFETCH property: description Connection-level properties
PrefetchBuffer [PBUF] connection parameter: about Connection parameters
PrefetchBuffer [PBUF] connection parameter: about connection parameters Connection parameters
PrefetchBuffer [PBUF] connection parameter: description PrefetchBuffer connection parameter [PBUF]
PrefetchBuffer [PBUF] connection parameter: introduction to connection parameters How connection parameters work
PrefetchBuffer [PBUF] connection parameter: tips Connection parameter tips
PrefetchBuffer [PBUF] connection parameter: using default connection parameters Using default connection parameters
PreFetchOnOpen communication parameter: description PreFetchOnOpen communication parameter
PrefetchRows [PROWS] connection parameter: about Connection parameters
PrefetchRows [PROWS] connection parameter: about connection parameters Connection parameters
PrefetchRows [PROWS] connection parameter: description PrefetchRows connection parameter [PROWS]
PrefetchRows [PROWS] connection parameter: introduction to connection parameters How connection parameters work
PrefetchRows [PROWS] connection parameter: tips Connection parameter tips
PrefetchRows [PROWS] connection parameter: using default connection parameters Using default connection parameters
prepared statements: connection limits Managing the resources connections use
MAX_STATEMENT_COUNT option [database]
Prepares property: description Connection-level properties
PrepStmt property: description Connection-level properties
PreserveSource property: description Database-level properties
PRESERVE_SOURCE_FORMAT option: description PRESERVE_SOURCE_FORMAT option [database]
PRESERVE_SOURCE_FORMAT option: setting Database options
PREVENT_ARTICLE_PKEY_UPDATE option: description PREVENT_ARTICLE_PKEY_UPDATE option [database]
PREVENT_ARTICLE_PKEY_UPDATE option: setting Database options
primary keys: transaction log Controlling transaction log size
primary sites: adding Replication Server information Lesson 5: Add Replication Server information to the primary database
primary sites: creating Lesson 1: Set up the Adaptive Server Anywhere databases
primary sites: Replication Server Replicate sites and primary sites
Primary site components
primary sites: uses of LTM at Primary site components
priority: process -gb server option
ProcedurePages property: description Database-level properties
procedures: and Adaptive Server Anywhere LTM Using the LTM
procedures: permissions Granting permissions on procedures
procedures: permissions for creating RESOURCE authority overview
procedures: replicating Preparing procedures and functions for replication
SQL Statements for controlling procedure replication
procedures: security Using views and procedures for extra security
ProcessCPU property: description Server-level properties
ProcessCPUSystem property: description Server-level properties
ProcessCPUUser property: description Server-level properties
ProcessorArchitecture: description Server-level properties
processors: multiple Controlling performance and memory from the command line
-gt server option
processors: number used Controlling performance and memory from the command line
-gt server option
ProductName property: description Server-level properties
ProductVersion property: description Server-level properties
programming interfaces: connections Introduction to connections
properties: list of connection properties Connection-level properties
properties: list of database properties Database-level properties
properties: list of server properties Server-level properties
properties: syntax Database properties
properties: syntax of connection-level properties Connection-level properties
properties: syntax of database-level properties Database-level properties
properties: syntax of server-level properties Server-level properties
property functions: syntax Database properties
protocol stacks: TCP/IP DLL communication parameter
protocols: about Client/Server Communications
protocols: disabling shared memory -sc server option
protocols: option Selecting communications protocols
protocols: supported Selecting communications protocols
Supported network protocols
protocols: troubleshooting Troubleshooting network communications
providers: ASAProv OLE DB providers
providers: MSDASQL OLE DB providers
providers: OLE DB OLE DB providers
PUBLIC group Special groups
PUBLIC options: about Setting public options
PUBLIC options: DBA authority required Setting public options