Index

P

partitioning : column-wise Publishing some of the columns in a table
Creating articles containing some of the columns in a table
partitioning : row-wise Publishing some of the rows from a table
Creating articles containing some of the rows in a table
passthrough mode : Adaptive Server Enterprise Using passthrough mode
passthrough mode : batches Operations not replicated in passthrough mode
passthrough mode : for Adaptive Server Anywhere Using passthrough mode
passthrough mode : operations not replicated Operations not replicated in passthrough mode
passthrough mode : operations not replicated in Operations not replicated in passthrough mode
passthrough mode : starting PASSTHROUGH statement
passthrough mode : stopping PASSTHROUGH statement
passthrough mode : uses Uses and limitations of passthrough mode
passthrough SQL Remote table : about sr_passthrough table
PASSTHROUGH statement : syntax PASSTHROUGH statement
PASSTHROUGH statement : using Using passthrough mode
passthrough statements : multi-tier installations Uses and limitations of passthrough mode
password control parameter : FTP message system FTP message control parameters
Password control parameter : VIM message system VIM message control parameters
passwords : the extraction utility Adaptive Server Enterprise features unsupported in Adaptive Server Anywhere
Path control parameter : VIM message system VIM message control parameters
patience : Message Agent Requesting resends
performance : design tips Design tips for performance
performance : incoming messages Tuning incoming message polling
performance : Message Agent Tuning Message Agent performance
performance : message sending Tuning the message sending process
performance : number of subscriptions Who gets what?
performance : publications Who gets what?
performance : replication throughput Tuning Message Agent performance
Tuning Message Agent performance
performance : replication turnaround time Tuning Message Agent performance
performance : SQL Remote Tuning Message Agent performance
performance : threading Tuning throughput by controlling Message Agent threading
performance : updates UPDATE statement
permissions : consolidate Granting and revoking REMOTE and CONSOLIDATE permissions
permissions : CONSOLIDATE GRANT CONSOLIDATE statement
permissions : granting CONSOLIDATE Granting CONSOLIDATE permissions
permissions : multi-tier installations Assigning permissions in multi-tier installations
permissions : publish Add the publisher and remote user to the database
Grant PUBLISH and REMOTE at the consolidated database
Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
permissions : remote Add the publisher and remote user to the database
Grant PUBLISH and REMOTE at the consolidated database
Granting and revoking REMOTE and CONSOLIDATE permissions
permissions : remote dba GRANT REMOTE DBA statement
REVOKE REMOTE DBA statement
permissions : revoking CONSOLIDATE REMOTE RESET statement
REVOKE CONSOLIDATE statement
permissions : revoking PUBLISH REVOKE PUBLISH statement
permissions : revoking REMOTE Revoking REMOTE and CONSOLIDATE permissions
permissions : SQL Remote administration Management overview
platforms : supported operating systems Supported platforms and environments
polling : messages Tuning incoming message polling
pop3_host control parameter : SMTP message system SMTP message control parameters
pop3_password control parameter : SMTP message system SMTP message control parameters
pop3_userid control parameter : SMTP message system SMTP message control parameters
port control parameter : FTP message system FTP message control parameters
PowerDynamo : SQL Remote The mobile Intranet
primary key errors : about Replication errors
primary key pool : about Ensuring unique primary keys
The primary key pool
The primary key pool
primary key pools : about Ensuring unique primary keys
primary key pools : replenishing Filling and replenishing the key pool
Filling and replenishing the key pool
primary key pools : replicating Replicating the primary key pool
Replicating the primary key pool
primary key pools : summary Primary key pool summary
Primary key pool summary
primary keys : in publications How statements are replicated
primary keys : publications Design issues overview
Design issues overview
primary keys : replication Designing to avoid referential integrity errors
Designing to avoid referential integrity errors
primary keys : SQL Remote Designing to avoid referential integrity errors
Designing to avoid referential integrity errors
primary keys : uniqueness Ensuring unique primary keys
The primary key pool
Ensuring unique primary keys
The primary key pool
procedure groups : the extraction utility Adaptive Server Enterprise features unsupported in Adaptive Server Anywhere
procedures : passthrough mode Operations not replicated in passthrough mode
procedures : replicating Replication of procedures
procedures : SQL Remote Replication of procedures
procedures : SQL Remote Open Server Other issues
procedures : statements corresponding to Adaptive Server Enterprise procedures and Adaptive Server Anywhere statements
profiles : Microsoft Exchange MAPI message control parameters
publication design : for Adaptive Server Anywhere CHAPTER 7. SQL Remote Design for Adaptive Server Anywhere
publication design : for Adaptive Server Enterprise CHAPTER 8. SQL Remote Design for Adaptive Server Enterprise
publication design : for many subscribers Publishing a subset of rows using a subscription expression
Creating an article using a subscription column
publication design : using subscription expression Publishing a subset of rows using a subscription expression
Creating an article using a subscription column
publication SQL Remote table : about SYSPUBLICATION table
sr_publication table
publications : about Publications and subscriptions
publications : column-wise partitioning Publishing some of the columns in a table
Creating articles containing some of the columns in a table
publications : creating Add publications and subscriptions
Create publications and subscriptions
Create the publication and subscription
Creating publications
Creating publications
CREATE PUBLICATION statement
publications : creating using Sybase Central Creating publications for Adaptive Server Anywhere using Sybase Central
Creating publications for Adaptive Server Enterprise using Sybase Central
publications : design at consolidated database Design overview
publications : designing CHAPTER 6. Principles of SQL Remote Design
Design overview
Replication errors and conflicts
Publication design for Adaptive Server Anywhere
Design issues overview
Designing to avoid referential integrity errors
Designing to avoid referential integrity errors
Publication design for Adaptive Server Enterprise
Design issues overview
Designing to avoid referential integrity errors
Designing to avoid referential integrity errors
UPDATE statement
publications : dropping Dropping publications
DROP PUBLICATION statement
publications : example A sample publication
publications : foreign keys Design issues overview
Partitioning tables that do not contain the subscription expression
Design issues overview
Partitioning tables that do not contain the subscription column
The Contact example
publications : locking Design issues overview
Design issues overview
publications : many-to-many example The Policy example
The publication
Territory realignment with a many-to-many relationship
The Policy example
The publication
publications : many-to-many relationships Sharing rows among several subscriptions
Sharing rows among several subscriptions
publications : notes Notes on publications
publications : performance Who gets what?
Design tips for performance
publications : primary keys Design issues overview
Designing to avoid referential integrity errors
Ensuring unique primary keys
The primary key pool
Design issues overview
Designing to avoid referential integrity errors
Ensuring unique primary keys
The primary key pool
publications : referential integrity Designing to avoid referential integrity errors
Designing to avoid referential integrity errors
publications : row-wise partitioning Publishing some of the rows from a table
Creating articles containing some of the rows in a table
publications : setting up Creating publications
Creating publications
publications : simple Publishing a whole table
Creating whole-table articles
publications : subqueries Partitioning tables that do not contain the subscription expression
publications : tables in many publications Who gets what?
publications : transactions Design issues overview
Design issues overview
publications : updates UPDATE statement
publications : using a WHERE clause Publishing a subset of rows using a WHERE clause
Creating an article using a WHERE clause
publications : whole tables Publishing a set of tables
publications SQL Remote view : about SYSPUBLICATIONS view
sr_publications view
publish permissions Add the publisher and remote user to the database
Grant PUBLISH and REMOTE at the consolidated database
GRANT PUBLISH statement
publish permissions : granting Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
publish permissions : managing Managing SQL Remote permissions
publish permissions : remote permissions Add the publisher and remote user to the database
Grant PUBLISH and REMOTE at the consolidated database
publish permissions : revoking Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
REVOKE PUBLISH statement
publisher Add the publisher and remote user to the database
publisher : about Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
publisher : adding to a database Grant PUBLISH and REMOTE at the consolidated database
publisher : address Working with message types
ALTER REMOTE MESSAGE TYPE statement
CREATE REMOTE MESSAGE TYPE statement
DROP REMOTE MESSAGE TYPE statement
publisher : creating Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
Granting and revoking PUBLISH permissions
publisher : GRANT PUBLISH statement GRANT PUBLISH statement
publisher : remote GRANT REMOTE statement
publisher SQL Remote table : about sr_publisher table