Skip to Main Content
Getting Started with Data Management
Data Management Overview
Data Management Implementation
Using PeopleSoft Data Archive Manager
Understanding PeopleSoft Data Archive Manager
Understanding Archiving Strategy
Understanding Archiving Techniques
Accessing the Data Archive Manager Homepage
Managing Archive Objects
Defining Archive and Restore Queries
Managing Archive Templates
Managing Archive Jobs
Auditing Archive Processes
Ensuring Data Integrity
Understanding Data Integrity Tools
Running SQL Alter
Running DDDAUDIT
Running SYSAUDIT
Employing Database Level Auditing
Understanding Database Level Auditing
Creating Audit Record Definitions
Working With Auditing Triggers
Viewing Audit Information
Creating Queries to View Audit Records Details
Using Microsoft SQL Server Trigger Information
Using DB2 UDB for z/OS Trigger Information
Using DB2 UDB for Linux, Unix, and Windows (LUW) Trigger Information
Using Oracle Trigger Information
Working With The Diagnostics Framework
Understanding Diagnostics Framework
Setting Up Security for Diagnostics Framework
Running Diagnostics
Importing Post-Release Plug-Ins
Developing Diagnostic Plug-Ins
Understanding Diagnostic Plug-In Development
Developing Diagnostic Plug-Ins
Working With The Delivered PT_DIAGNOSTIC Application Package
PTDiagnostics Application Class
PTDiagnostics Class Methods
PTDiagnostics Class Properties
Diagnostic Plug-In Examples
Administering PeopleSoft Databases on Microsoft SQL Server
Server Options
Required Database Configuration
Implementing Transparent Data Encryption
Working with Indexed Views
Microsoft SQL Server Feature Considerations
Administering PeopleSoft Databases on DB2 UDB for z/OS
Understanding DB2 UDB for z/OS Administration
Monitoring Batch Programs
Associating PeopleSoft Users, Modules, and Actions with DB2 UDB Threads
Running COBOL
Administering SQR for z/OS
Updating Statistics
Setting the Number of Temporary Tables
Creating Temporary Tables
Working with Alters on DB2 z/OS
Working with Materialized Query Tables
Administering PeopleSoft Databases on DB2 UDB for Linux, UNIX, and Windows
Understanding Administration on DB2 UDB for Linux, UNIX, and Windows
Instances
Configuration Parameters
Tablespaces
Temporary Table Creation
Client Database Catalog
Meta-SQL %TruncateTable()
DB2 UDB for Linux, UNIX, and Windows Administration
Checklists and Troubleshooting
Administering PeopleSoft Databases on Oracle
Working With Oracle Connectivity
Working With Oracle Database In-Memory
Monitoring PeopleSoft Database Connections
Converting Descending Indexes
Setting the Number of Temporary Tables
Using Locally Managed Tablespaces
Maintaining Partition Definitions
Using Pluggable Databases
Using Materialized Views
Improving Process Performance with Global Temporary Tables
Implementing PSCBO_STATS for PeopleSoft Optimization
Working With Oracle Consumer Groups
Implementing Oracle Transparent Data Encryption
Protecting and Managing PeopleSoft Applications with Database Vault
Working With Oracle Security Features
Working With Oracle Transparent Application Failover
Implementing Oracle Active Data Guard
Implementing Oracle GoldenGate for PeopleSoft Off-Load Reporting
Implementing Oracle Golden Gate on Oracle 11g Database
Setting Up the PeopleSoft Installation with Oracle RAC
Working with Oracle Fine Grained Auditing
Working with Oracle SecureFiles
Implementing the Oracle Database File System
Using Oracle Data Masking
Configuring Remote Data Access
Understanding Remote Data Access
Configuring Application Servers or Process Scheduler Servers for Remote Data Access for Oracle
Configuring Application Servers or Process Scheduler Servers for Remote Data Access with DB2 UDB
Installing and Configuring the Microsoft SQL Server JDBC Driver
Archive Data Tool (Deprecated in PeopleTools 8.44)
Creating and Designing Archive Templates
Working With the Archives
Working With Archive Data
Running Data Archival Processes
Running Data Archival Reports and Audits
Mass Change
Understanding Mass Change
Defining Types
Generating SQL
Defining Templates
Selecting Prompt Tables
Configuring Date and Datetime Formatting
Building Mass Change Definitions
Creating Groups
Executing Mass Change Definitions
Performing Mass Changes in PeopleSoft Asset Management
Downloading and Uploading Data with Mass Change