If JavaScript is disabled, please continue to the
sitemap
.
Infor Lawson Administration: Data Access Using Oracle--UNIX
Home
Home
Back
Back
Forward
Forward
Search
Help
Copy URL
PDF
Print this page
Help
Help
Copy URL
Copy URL
Topic URL copied to clipboard
PDF
PDF
Print
Hide the Table of Contents
Show the Table of Contents
Data Access Overview
Configuring the Database
Installing and Configuring the Database
Configuring Database Users
Configuring the Database Server (ladb)
Managing Data
Implementing Dictionary Modifications
Finding and Fixing Dictionary Issues
Copying, Importing, and Exporting Lawson Data
Physical Data Storage Management
Database Installation and Configuration
Database Installation and Configuration Overview
Lawson Database Interface Architecture
Lawson System Tiers
Where Do Lawson Files Reside?
The Database Services Interface
What Is the Process Chain?
The Role of the Environment in Data Management
Creating the Database
Database Installation and Configuration Requirements
Required database components and settings
Database Preinstallation Tasks
What Is an Instance?
Planning for Your Tablespaces
Creating Tablespaces
Database Configuration Parameters
Encryption of Data at Rest
Configuring the Database Interface
What Is the Lawson Database Driver Configuration File?
Variables in the database driver configuration file
Editing the Lawson Database Driver Configuration File
Enabling a Connect String
***
To secure the Lawson Database Driver Configuration File
Adding the Shared Library Path to the lawson.env file
Configuring Database Users and Authentication
Database User Authentication Overview
Database Service
Database User Authentication Options
Database Driver Configuration File
Creating or Changing a Database Service
Activating the Database Service: Next Steps
Setting Up a Database Service to Use Oracle Proxy Authentication
Configuring the Database Server
Infor Lawson Database Server Configuration File (ladb.cfg)
Kernel Parameter Adjustments
FOREIGN or USERS Changes
USERS Changes
Kernel Parameter Reference
Solaris 10 Parameter Changes
Utilities for Managing ladb
Stopping and Starting the Lawson Database Server
To stop the database server
To start the database server
Managing the Data Dictionary
Lawson Data Dictionary Structure
Understanding Lawson Data Organization
Product Line Structural Definition
Creating or Modifying Product Lines and Data Areas
What Is the Database Definition (dbdef) Tool?
Modifying Product Lines Using Database Definition
How Do I Create a New Data Area?
Defining Data Areas and Data IDs Using Database Definition
Edit Data Area Utility (editda)
Specifying Data Area Attributes Using the editda Utility
editda Syntax
Directives File Syntax
Automatic Data Area Generation Script
To configure the ASP script for your database installation
To run the ASP data area generation script
Enabling and Disabling Variable Length Character Strings
Setting Database Spaces
Database Spaces
Defining Database Spaces
Deleting database spaces
Why Must I Set File Sizes?
Setting File Sizes
How Is a Database Space Saved Using the Empty Database Type?
Assigning a Table to an Empty Database Space
To create an empty database space
To assign a table to the empty database space
How Is a Database Space Saved Using a Virtual Index?
Creating a Virtual Index for a Table
Implementing Dictionary Modifications
What Is the Process for Implementing Database Modifications?
How Does the Database Reorganization Utility Work?
Reorganizing the Database
To implement modifications to a product line
To implement modifications to data areas
Finding and Fixing Dictionary Issues
What Is the Verify Database Utility?
Verifying the Dictionary
What Is the Build Data Definition Language Utility?
Using the Build Data Definition Language Utility to Fix Dictionary Mismatches
Managing Lawson Data
Lawson Tools for Data Management
Dumping and Loading Data Files
To dump from a Lawson database file to a flat file
To load data from a dbdump-formatted flat file into a Lawson database file
Copying, Updating, and Replicating Data
Comparing Lawson Data Dictionaries
cmpdict Output
Copying Lawson Data with dbcopy
Configuring Database Change Logs for dbupdate
Enabling database change logging
Disable database change logging
Updating Lawson Data Between Data Areas with dbupdate
Copying data using SQL code
Properties File
Directives File
Populating the Directives File
Table Partitioning and Storage Parameters
Estimating Physical Disk Usage
What Is the Disk Usage Utility?
Using the Disk Usage Utility in Online Mode
Using the Disk Usage Utility in Offline Mode
Estimating Space Requirements Using the Disk Usage Utility
Working with Storage Parameters
What Are Storage Parameters and Storage Parameter Tables?
How Are Storage Parameter Tables Used?
Creating the Storage Parameter Tables
Viewing Storage Parameter Tables
Changing Storage Parameters
Working with Lawson DBA Tables
What is the Build Lawson Tables Script?
What Is the dbatables11/dbatables12 Utility?
What Are law_dba_table Table Descriptions?
What Are law_dba_index Table Descriptions?
Populating the law_dba_table and law_dba_index Tables
To populate the law_dba_table and law_dba_index tables by running the dbatables utility
To populate the law_dba_table and law_dba_index tables by using the SQL utility
What Are law_dba_clauses Column Descriptions?
Defining Multiple Index Locations
Defining Extent Sizes
Implementing Lawson Database Security
What Is the Build Security Utility?
Implementing Lawson Security Constraints in the Database
Example: SQL Output File (Lawson Security and Resource Management)
Improving Performance
Analyzing Performance
What Are Timed Statistics?
What Is the Timed Statistics Log?
How Can I Analyze Timed Statistics?
Changing the Status of Timed Statistics Collection
To change the status of timed statistics collection using the database server configuration file
To change the status of timed statistics collection using the dbadmin utility
Configuring Record Caching
Record Caching
Array Fetch Buffers
Control Fetch and Insert Size for a Program
Caching Records for an Individual Program and Files
To turn record caching on
To turn caching off
To monitor caching
To turn monitoring off
Enabling Database Joins
Database Joins Overview
Database Joins Process Flow
Enabling Generation of Joins for an Application
Diagnosing Errors
Where Do I Look for Error Information?
How Do I Interpret the Error Information?
What Must I Know Before Calling Infor Support?
SQL Conventions
Accessing Data
Lawson Implementation of SQL Conventions
Naming Columns
Additional Columns
Open link in new tab
Open link in new window
Copy link to clipboard