Infor Lawson Administration: Data Access Using IBM DB2 on a z/OS Database Server

Home

Back

Forward

  • Help
  • Copy URL
  • PDF
  • Print this page

Help

Copy URL

Topic URL copied to clipboard

PDF

Print

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
Prerequisite Installation Steps
Before You Begin
Database Preinstallation Tasks
ASCII Definition of the Lawson Database
Using DB2 Connect
Cataloging an IBM DB2 OS/390 Database
Using Runstats
Creating Table Spaces
Configuring Lawson System Foundation for 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
***
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
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 and Virtual Indexes
Database Spaces
Defining Database Spaces
Define a database space
Deleting database spaces
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
Special Lawson Tables to Support OS/390 Features
What Is Table Partitioning?
Lawson DBA Tables (law_dba tables)
Descriptions of law_dba Tables
Implementing IBM DB2 for zSeries Partitioning
Implementing Lawson Security
What Is the Build Security Utility?
Implementing Lawson Security Constraints in the Database
Example: SQL Output File (Lawson Security and Resource Management)
Error Processing
Improving Performance
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
What is the Build Lawson Tables Script?
What is the law_dba_strings table?
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
  • Links
  • docs.infor.com
  • Send Feedback on Current Topic
  • Product Support
  • Open link in new tab
  • Open link in new window
  • Copy link to clipboard