Index
A
B
C
D
E
F
G
I
J
L
M
N
O
P
R
S
T
U
W
A
Access Control Domain
definition
editor
list
role specifications
Access Control List
definition
editor
Actions tab, Personal Options
Column Map Procedure
format numeric values
maximum database connections
monitor update frequency
report retention
show aging tabs
show currency tab
Age Function
destination format exit
source format exit
Allocation Percent
index defaults
table defaults
Apply Maintenance
add default tables
all DB Aliases
DB Alias Access
Optim Directory Access
query method
specific DB Alias
specific DBMS
update DBMS version
Archive File Collection
subsets
Archive tab, Personal Options
Archive browse index directory
Archive directory
Archive index directory
directory for Subset Extract Files
file backup device
trim search list
use index to search
Archive tab, Product Options
available file backup devices
Centera options
Centera retention period
Tivoli options
user can review data to be deleted
WORM device retention period
Attunity Upgrade
audit
(1)
,
(2)
Audit Tables dialog
(1)
,
(2)
Select Table to be Audited dialog
summary
Auditing
active status
active/user status
Audit Tables dialog
(1)
,
(2)
description of
enable/disable for tables
inactive status
Personal Options tables list
Product Options, Edit tab
PSTAUDIT2, PSTAUDIT3
(1)
,
(2)
site defaults
summary
Auditing Optim processes
B
Bind/Drop Plans
creating Optim directory
Bind or Drop Plans
creating a DB alias
Browse tab, Personal Options
auto switch
display changed data
display column attributes
display row count
maximum exclude rows
side label display
Buffer Pool
index defaults
C
Cascade Delete/Update Option
(1)
,
(2)
Character Formats
Choose Destination Location
Column Map Procedures
sample
Command Line Interface
directory configuration
examples
(1)
,
(2)
keywords
syntax
directory maintenance
examples
keywords
syntax
keywords
syntax guidelines
Commit Frequency
Conceptual Overview
Configuration
browse SQL
command buttons
completion files
dialog features
display SQL
main window
menu commands
planning for
processing log
(1)
,
(2)
Tasks menu
(1)
,
(2)
Configuration Assistant
additional workstations
description of
first workstation
Configuration File, Product Options
current Configuration File name
path to new Configuration File
switch to new file when created
Configuration Overview
Configuration phase
Configuration Window and Menus
Configure Additional Workstations
Configuration Assistant
configure options
create registry entry
DBMS client software
description of
enable/disable
ODBC interface
Optim Server
guidelines
import registry entries
process steps
Product Configuration File
task summary
Configure Application Servers
description of
process steps
Configure First Workstation
Character set
for DB alias
completion files
Configuration Assistant
configure options
create
DB alias
Multiple DB aliases
Optim directory
Optim directory tables
create/drop packages
for Optim directory
create or drop packages
for DB alias
DBMS
for DB alias
for Optim directory
description of
export registry data
load/drop sample tables
load or drop sample tables
(1)
,
(2)
Optim Security
process steps
product license key
set personal options
set product options
share connection information
task summary
Configure Options
for additional workstations
for first workstation
personal options
process steps
product options
Configure Security for an Optim Directory
Configure the Server
process steps
Confirm tab, Personal Options
before deleting
before losing DDLs
before overwriting files
Convert PST Directory Objects
(1)
,
(2)
Create
additional Optim Directory
copies of DB2 relationships
create/drop packages
create/drop procedures
create or select DB alias
primary keys
registry entry
Create tab, Personal Options
(1)
,
(2)
compile error drop
DB Alias
DB2 UDB for z/OS current rules
Limits
Object Name Highlighting
replace UDTs
set alias defaults
set index defaults
set synonym defaults
set table defaults
set trigger defaults
Credentials
(1)
,
(2)
DBMS logon credentials
DB Alias access
maintaining
Optim Directory access
Server credentials
(1)
,
(2)
Linux file access
Oracle OS Authentication
registry access
Server privileges
to run processes
to run the Server
UNC network share access
UNIX file access
Customer Information
Customer Information Dialog
D
Data Privacy Tables
descriptions
loading
(1)
,
(2)
Database
sample tables
Database Permissions
Database tab, Product Options
allow insert action delete option
allow parallel processing
allow user to lock tables
Extract using Uncommitted Read
maximum commit frequency
maximum database connections
Sybase unchained mode
DB alias
configure first workstation
create or drop packages
create or select
create or update
create or update another
description of
share connection information
specify character set for
specify DBMS for
DB Alias
create
create/update
maintain access
purging
DB2
bind/drop plans
for Optim directory
bind or drop plans
for DB alias
z/OS Buffer Pool
DBMS
type and version
Default Directories
Archive
Archive Browse Index Directory
Archive Index Directory
Data Directory
for DBMS loaders
Product Configuration File
scheduling
Temporary Work
Trace Files
Delete Processing
secured files
Dialogs
Display tab, Personal Options
column delimiters
Large Objects
main window
maximum fetch rows
maximum File menu entries
maximum history entries
menu behavior
null value indicator
system messages
tooltips and toolbars
E
Edit tab, Personal Options
(1)
,
(2)
audit tables
Audit Tables dialog
auditing active
auto switch
default data display
display column attributes
display deleted rows
display row count
null as default
prompt for variables
retain selection criteria
side label display
single view
undo levels
user supplies defaults
warn on cascade
Edit tab, Product Options
Audit Tables dialog
auditing status
force Browse Only
null as default
user supplies defaults
Email Notification
Errors tab, Personal Options
display lines
error messages font
hide empty message bar
informational messages font
warning messages font
Exit Routines
destination format exit
input to Age Function
samples
source format exit
input to Age Function
Export Registry Data
Extract Files
samples
Extract Uncommitted Data
F
File Access Definition Editor
File Access Definitions
using secured files
Functional Privileges
G
General tab, Personal Options
Caps mode
data directory
days to keep trace files
Local Optim Server (ODBC)
Product Configuration File
SQL LIKE character
temporary work directory
unchained mode
warn on cascade
z/OS code page
General tab, Product Options
abort Scheduler or command line
default calendar
maximum extract rows
maximum fetch rows
warn on cascade delete/update
Getting Started
Guardium audit
I
Image Locator Diagnostic Tool
Import Registry Data
Index Buffer Pools
Index Defaults
Informix
create/drop procedures
for Optim directory
create multiple DB aliases
create or drop procedures
for DB alias
update DBMS version
Initialize Optim Security
(1)
,
(2)
Install
(1)
,
(2)
,
(3)
,
(4)
,
(5)
,
(6)
,
(7)
completing
console
console installer
Release_Notes file
select components
silent installer
summary
Unix
silent install
Install from console
Install ODM
Install Optim Server
Red Hat Linux 3 or Solaris 8
Installation
(1)
,
(2)
additional workstations
Linux
(1)
,
(2)
planning for
system requirements
UNIX
(1)
,
(2)
workstations or server
Installation Complete
Installation phase
Installation Requirements
J
JCL File
sample
L
Large Objects, Personal Options
license agreement
License Agreement
Linux
command line
commands
customer ID
(1)
,
(2)
data directories
DB Alias
destination folder
environment variables
installation
(1)
,
(2)
,
(3)
license agreement
loader
(1)
,
(2)
LOCALE.CONF file
locale conversion
Optim Directory
pr0pass program
pstlocal configuration file
pstserv configuration file
RT4S shell script
RTSERVER shell script
RTSETENV shell script
securing
(1)
,
(2)
configuration files
(1)
,
(2)
password file
trace days
Load or Drop Data Privacy Tables
Load or Drop Sample Tables
Load tab, Personal Options
DB Alias
exception tables
path to DBMS Loaders
Teradata
error/work tables
Load tab, Product Options
additional loader parameters
DB Alias
delete when truncate fails
force at run time
Optim Directory
override loader defaults
prime new request
Lock Tables
Logon
for multiple DB aliases
saved for multiple DB aliases
Logon tab, Personal Options
always ask for password
always fail connection
connection string
for Optim Directory
set passwords
specify User ID
test database connection
M
Main Window
auto size
maximum components
Main Window and Menus
Maximum
commit frequency
extract rows
fetch rows
(1)
,
(2)
history lists
menu entries
visible components
MBCS Roundtrip Processing
Menus
Messages
errors
informational
limit lines to display
resetting
set font style
show or hide
warnings
Microsoft Debugging Utility
Multi-byte support
N
Netezza
create or drop procedures
for DB alias
Notify tab, Personal Options
Send Test eMail
(1)
,
(2)
O
Object Name Highlighting
ODBC Interface
Enable/Disable
(1)
,
(2)
Installation
ODM
(1)
,
(2)
ODM Install
ODM license
ODM Optim Connect
data source
Open Data Manager
Open Data Manager (ODM)
Archive File Collection
Archive File to XML Convertor
Connect Studio
data type conversion
installation
JDBC Thin Client
ODBC Thin Client
runtime connection
security
Optim directory
create tables for
creating
specify DBMS
Optim Directory
add default tables
create additional
creating
definition of
export registry data
maintain access
purge registry entry
registry entry
table identifier
(1)
,
(2)
typical configuration
workstation access
Optim Exit
Prerequisites for a User-Supplied Exit
(1)
,
(2)
Writing a User-Supplied Exit
(1)
,
(2)
Optim Exit in UNIX
Invalid Credentials Specified dialog
Sign Optim Exit Failed dialog
Signing a User-Supplied Exit
(1)
,
(2)
Signing an Exit during Setup
Signing Methods
(1)
,
(2)
Signing the default Exit after Installation
(1)
,
(2)
Optim Exit in Windows
Changing a Signed Exit
Sign Optim Exit dialog
Signing an Exit during Configuration
Specify Company Name dialog
Optim repository
Optim Security
Access Control Domain
(1)
,
(2)
Access Control List
(1)
,
(2)
Assigning Privileges
change administrator
(1)
,
(2)
File Access Definition
initialize
(1)
,
(2)
Object Association Privileges
Security Administrator
users in multiple roles
Optim Server
(1)
,
(2)
Access defaults
Archive defaults
Authentication
Choose Product Configuration File
Configure
Connection Defaults
default Archive directories
Default Directories
directories, limit client access to
Enable/Disable
Endpoints
Error defaults
General defaults
install under UNIX or Linux
Loader defaults
Logon dialog
Maximum Processes
Merge Current User
(1)
,
(2)
Mirror process
name
(1)
,
(2)
Network Access
Personal Options
Protocols
Security
Security defaults
Service Logon
Settings Dialog
Start as Process
Start as Service
Startup defaults
Status
Trace Files
update Configuration File
Oracle
create/drop packages
for Optim directory
create or drop packages
for DB alias
Oracle Connection Diagnostic Tool
P
Password
always require
case sensitive
connection information
credentials
for each workstation
for product options
(1)
,
(2)
Product Configuration File
Password tab, Product Options
Personal Options
(1)
,
(2)
,
(3)
,
(4)
actions
archive
browsing files
configuring
confirm
creating objects
database
DBMS loaders
display
editing data
email notification and configuration
error defaults
MBCS Roundtrip Processing
printers, language options
removable media
scheduling monitor
servers
set general defaults
to logon
Planning for Installation and Configuration
PR0CMND
Primary Keys
creating for database
(1)
,
(2)
select database tables
Printer Options
process audit
Process Audit
Processing Log
browse the log file
completed actions
Product Configuration File
additional workstations
configure workstations
creating
identify existing
set default directory
set default path for
switch configuration files
Product License Key
description of
exporting
for additional workstations
for first workstation
for your company
Product Options
(1)
,
(2)
archive
configuration file
configuring
database defaults
DBMS Loaders
editing data
Oracle
password
report
servers
set general defaults
PST Directory Objects, converting
(1)
,
(2)
Purge
DB Alias
Optim Directory
R
Registry Data
export file
from first workstation
importing data
Release_Notes file
Removable Media, Personal Options
default segment sizes
Replace UDTs, Personal Option
Report Request Editor
(1)
,
(2)
Email notification
menu commands
Report Type
Security Report
Report tab, Product Options
blank lines between levels
blank lines between rows
character column width
indent subordinate tables
line length
lines per page
minimum spaces between columns
rows per table
Required Database Permissions
Required Server Authorizations
Reset Messages
Restore Processing
secured files
S
Sample
Column Map exits
Column Map procedures
database tables
description
(1)
,
(2)
loading
(1)
,
(2)
structure
extract files
JCL file
Scheduling Monitor
directory path for
start immediately
startup options
Scheduling tab, Personal Options
secured files
Security Administrator, Optim Security
Security Report
creating
description
editing
processing
run
schedule
Segment
naming
size
Select Components
Select the Type of Install
Server Authorizations
Server tab, Personal Options
(1)
,
(2)
always ask for password
check logon
Optim Server
User ID, Password, Domain
Servers tab, Product Options
endpoint
network address
protocol
Server name
Setup
creating desktop icons
customer information
for additional workstations
Software License
Special Characters
Caps mode
underscore as SQL LIKE
SQL Server
connection string
create/drop procedures
for Optim directory
create multiple DB aliases
create or drop procedures
for DB alias
create shared procedures
for DB alias
update DBMS version
Sybase ASE
connection string
create/drop procedures
for Optim directory
create multiple DB aliases
create or drop procedures
for DB alias
create shared procedures
for DB alias
update DBMS version
System Requirements
hardware/software
T
Tasks menu
(1)
,
(2)
access Optim Directory
configure additional workstations
(1)
,
(2)
configure first workstation
(1)
,
(2)
configure options
copy DB2 relationships
create additional Optim Directory
create or update DB alias
create primary keys
create/update DB Alias
create/update Optim Directory
drop DB Alias
drop Optim Directory
(1)
,
(2)
enable/disable
ODBC Interface
Optim Server
load/drop sample data
(1)
,
(2)
maintain access
DB Alias
(1)
,
(2)
Optim Directory
purge
DB Alias
Optim Directory
purpose
update DBMS version
for DB Alias
(1)
,
(2)
for Optim Directory
(1)
,
(2)
Teradata
Account ID
Parallel Transporter (TPT)
Personal Options
(1)
,
(2)
Personal Options
Database Settings
Load Settings
(1)
,
(2)
Product Options
Database Settings
Trace File
Troubleshooting
Attunity Upgrade
Image Locator Diagnostic Tool
Microsoft Debugging Utility
Oracle Connection Diagnostic Tool
Troubleshooting Your Installation
U
UDT
Uncommitted Data, Extract
Unicode support
Uninstalling
(1)
,
(2)
cancel
do not drop all objects
drop all objects
prompt to drop all objects
Windows Control Panel
Unix
silent install
UNIX
command line
commands
customer ID
(1)
,
(2)
data directories
(1)
,
(2)
DB Alias
(1)
,
(2)
DB Alias logon
destination folder
environment variables
install Optim server
installation
(1)
,
(2)
,
(3)
license agreement
loader
(1)
,
(2)
LOCALE.CONF file
locale conversion
logon
Maximum Processes
Optim directory
Optim Directory
permission
pr0pass program
pstlocal configuration file
pstserv configuration file
RT4S shell script
RTSERVER shell script
RTSETENV shell script
securing
(1)
,
(2)
configuration files
(1)
,
(2)
password file
trace days
(1)
,
(2)
User Defined Types
Replace UDTs, Personal Option
User ID
credentials
DB alias access
required authority
W
Warn on Cascade
(1)
,
(2)
Windows Registry
access to Optim Directory
exporting entries
importing entries
Merge Current User
(1)
,
(2)
,
(3)