Skip Headers

Oracle Access Manager Installation and User's Guide
Release 9.2.0.1.0 for IBM AS/400

Part Number A97616-01
Go To Table Of Contents
Contents

Go to previous page

Index

A  B  C  D  E  F  G  H  I  K  L  M  N  O  P  Q  R  S  T  U  V  W 


A

Activation groups, 1-10
ACTGRP, 1-10
commands
CRTSQLxxx, 1-10
STRSQL, 1-10
ADD command, 7-15
ADDLIBLE command, 4-7, 6-2
ADDRDBDIRE command, 5-3, 5-4, 5-8
AM400_COM program
defined, 7-2
commands, 7-15
ADD, 7-15
FORCE, 7-17
LIST, 7-17
MODIFY, 7-15
QUERY, 7-16
REMOVE, 7-15
SET, 7-16
SHUTDOWN, 7-15
STARTUP, 7-15
STATUS, 7-15
Privileged ID field, 7-12
privileged userids, 7-11
with LIST command, 7-17
AM400_RID
with LIST command, 7-17
AM400_RID program
defined, 7-2
altering the environment, 7-14
starting, 7-12
startup parameter, 7-11
with DATAQUEUE_TIMEOUT parameter, 7-9
with resolve-in-doubt transactions, 7-5
with two-phase commit, 7-4
Architecture, 1-3
architecture
components, 1-5
ARD interface, B-4
AUTOCREATE CONTROLLER parameter, 5-7
AVG function, 6-6

B

Blocksize data area, 6-6
bugs fixed as of this release, 2-2

C

CALL command, 8-3, 8-6
CALL procedure, 8-7
CALL statement, 8-6
Change or Enter New Server Attributes panel, 7-10
Change Privileged Ids (Relative to AM400_COM) panel, 7-12
Change RID (Resolve In Doubt) Options panel, 7-8
Changes and enhancements, 2-2
CHAR datatype, 8-9
Checklists
enabling two-phase commit, 7-7
installation, 4-2
Oracle Net
TCP/IP AS/400 configuration, 5-6
post-installation, 4-6
CHG2PCPRM command, 6-3, 6-15, 7-8, 7-11
CHGSQLDBG command, 6-3, 6-10
CHGSQLDFLT command, 6-3, 6-4, 7-2, 8-2, B-6
CHGSQLNET command
Access Manager commands, 6-3
enabling Oracle Net tracing, 5-2
network parameters panel, 6-8
CHGUSRPRF command, 4-5
CHKSQLDFLT command, 2-4
Clauses
FOR FETCH ONLY, 6-6
CLEANUP_DELAY parameter, 7-9, 7-14, 7-16
Commands
ADDLIBLE, 4-7
AM400_COM program, 7-15
ADD, 7-15
FORCE, 7-17
LIST, 7-17
MODIFY, 7-15
QUERY, 7-16
REMOVE, 7-15
SET, 7-16
SHUTDOWN, 7-15
STARTUP, 7-15
STATUS, 7-15
CHG2PCPRM, 7-8, 7-11
CHGSQLDFLT, 7-2
CHGSQLNET, enabling Oracle Net tracing, 5-2
CHGUSRPRF, 4-5
CHKSQLDFLT, 2-4
COMMIT, 1-9, 2-6, 7-3, 7-4, 7-13
COMMIT HOLD, 2-6
CREATE TABLE, 8-2
CRTLINETH, 5-7
CRTLINSDLC, 5-7
CRTLINTRN, 5-7
CRTLINX25, 5-7
CRTSQLXXX, 2-6
CRTSQLxxx, 1-10
DB2/400
CONNECT TO, 8-2
SET CONNECTION, 8-4
DSPJOBLOG, 4-5
DSPLIND, 5-7
EDTF, defining TNSNAMES entry, 5-7
GRANT, 7-13
IBM
CALL, 1-6
CRTSQL, 8-4
LODRUN, 4-3
Oracle Access Manager, 6-2, 6-3
ADDLIBLE, 6-2
CALL, 8-3, 8-6
CHG2PCPRM, 6-15
CHGSQLDBG, 6-10
CHGSQLDFLT, 6-4, 8-2, B-6
COMMIT, 6-7
CRTORAPKG, 6-12, 8-3
CRTSQLxxx, 6-5
DESCRIBE TABLE, 8-6
DISCONNECT, 8-5
RELEASE ALL, 8-5
ROLLBACK, 6-7
SELECT, 8-6
RELEASE, 8-5
ROLLBACK, 1-9, 2-6, 7-4, 7-13
SQL*Net
ADDRDBDIRE, 5-3, 5-4, 5-8
WRKMBRPDM, 5-7
STRSBS, 7-12
STRSQL, 1-10
COMMIT command, 1-9, 2-6, 6-7, 7-3, 7-4, 7-13
COMMIT HOLD command, 2-6
commit phase, defined, 7-3
commit point site, defined, 7-2
COMMIT statement, 8-4, 8-5
Commitment control resource, 6-7
Components, 1-5
Application Requester Driver interface, 1-5
AS/400 application, 1-5
Oracle Access Manager, 1-5
Oracle server, 1-5
SQL client manager, 1-5
SQL*Net, 1-5
Configuring Oracle Access Manager, 6-1
Configuring SQL*Net TCP/IP, 5-6
TNSNAMES entry, 5-7
CONNECT statement, 1-8
CONNECT TO command, 8-2
CONNECT TO statement, 8-4
Connecting
through Oracle Net, 5-3
through TCP/IP, 5-5
to Oracle server
from precompiled application, 8-3
Connection management, 8-4
COUNT(*) function, 6-6
CREATE statement, 6-7
CREATE TABLE command, 8-2
CRTLINETH command, 5-7
CRTLINSDLC command, 5-7
CRTLINTRN command, 5-7
CRTLINX25 command, 5-7
CRTORAPKG command, 6-3, 6-12, 8-3
CRTSQL command, 8-4
CRTSQLxxx command, 1-8, 2-6, 6-5

D

Data areas
blocksize, 6-6
Data Definition Language (DDL), 2-6
Data Manipulation Language (DML), 2-6
DATAQUEUE_TIMEOUT parameter, 7-9, 7-14, 7-16
Datatypes
conversion of Oracle to DB2/400, 8-9
DB2/400, 8-9
LONG, 2-6
LONG RAW, 2-6
TIME, 2-5
TIMESTAMP, 2-5
DATE datatype, 8-9
DB2/400
commands
CONNECT TO, 8-2
SET CONNECTION, 8-4
CONNECT syntax, 8-4
conversion of Oracle datatypes, 8-9
statements
CONNECT TO, 8-4
DECLARE PROCEDURE, 8-7
DEAD_CHECK_COUNTER parameter, 7-9, 7-16
DECIMAL datatype, 8-9
DECLARE PROCEDURE statement, 8-7
default datatypes precision and scale, 2-4
Defining Oracle Access Manager, 5-4
RDB entry, 5-4
TNSNAMES entry, 5-4
DELETE statement, 2-5
DESCRIBE TABLE command, 8-6
Describing tables, 8-6
Description field, 7-11
Diagnosing problems
Oracle Access Manager, 6-10, 6-14
DISCONNECT command, 8-5
Distributed database, 1-9
Distributed unit of work, 1-9
Documentation
recommended, 3-4
DROP statement, 6-7
DSPJOBLOG command, 4-5
DSPLIND command, 5-7

E

EDTF command, defining TNSNAMES entry, 5-7
error
ORA-0090, invalid CREATE command, 8-2
ORA-1457, when using STRSQL, 2-4
Error code processing
Oracle Access Manager, 8-10
EXEC SQL statement, 2-5

F

Features, 1-6
datatype conversions, 1-7
distributed applications, 1-7
leveraging existing applications, 1-6
SQL language, 1-6
universal access, 1-7
Fields
SQLERRMC, 8-10
SQLSTATE, 8-10
Files
ORA(TNSNAMES), 5-4
Oracle Access Manager
QCBLLESRC, 8-3
QRPGLESRC, 8-3
QSQLCSRC, 8-3
SQL*Net
ORA(TNSNAMES), 5-4
FLOAT datatype, 8-9
FOR FETCH ONLY clause, 6-6
FORCE option, 7-13
Functions
AVG, 6-6
COUNT(*), 6-6
MAX, 6-6
SUM, 6-6
TO_CHAR, 6-14
TO_DATE, 6-14

G

GETRESULTS procedure, 8-7
GRANT command, 7-13

H

Hardware requirements, 3-2
HOLD parameter, 2-6

I

IBM
commands
CALL, 1-6
CRTSQL, 8-4
Distributed Relational Databases, 1-9
implied commit, defined, 7-3
IN OUT parameter, 8-7
IN parameter, 8-7
In-doubt transactions, 7-5
resolving, 7-5
Install Oracle Access Manager Product panel, 4-3
Installation, 4-1
checklist, 4-2
choosing the library, 4-3
default values, 4-2
finish installation, 4-5
logging on to AS/400, 4-2
mount product CD, 4-3
select installation library name, 4-3
start install process, 4-3
verify installation parameters, 4-4
verify successful installation, 4-5
INTEGER datatype, 8-9
Introduction
Oracle Access Manager, 1-1

K

known problems and restrictions, 2-4

L

Language types
values
*C, 6-13
*COBOL, 6-13
*RPG, 6-13
Libraries
Oracle Access Manager, 6-2
Oracle Access Manager installation, 6-2
LIST command, 7-17
LODRUN command, 4-3
LONG datatype, 2-6, 8-9
LONG RAW datatype, 2-6, 8-9

M

MAX function, 6-6
Members
name format, 5-2
Messages
Oracle Access Manager
processing, 8-10
MODIFY command, 7-15

N

Network
requirements, 3-3
NLS, 6-7
languages, B-5
NUMBER datatype, 8-9

O

Operating system
requirements, 3-3
Options
FORCE, 7-13
Oracle Access Manager
USER, 6-5
USING, 6-5
ORA(TNSNAMES) file, 5-3, 5-4
ORA-0090 error, invalid CREATE command, 8-2
ORA-1457 error, when using STRSQL, 2-4
Oracle Access Manager
architecture, 1-3
calling, 1-8
commands, 6-2
ADDLIBLE, 6-2
CALL, 8-3, 8-6
CHG2PCPRM, 6-15
CHGSQLDBG, 6-10
CHGSQLDFLT, 6-4, 8-2, B-6
COMMIT, 6-7
CRTORAPKG, 6-12, 8-3
CRTSQLxxx, 6-5
DESCRIBE TABLE, 8-6
DISCONNECT, 8-5
ROLLBACK, 6-7
SELECT, 8-6
commitment control resource, 6-7
configuring, 6-1
connect processing, 1-8
connecting
from AS/400 precompiled application, 8-3
to Oracle server, 8-2
connection management, 8-4
conversion of Oracle datatypes to DB2/400 datatypes, 8-9
DB2/400
CONNECT syntax, 8-4
statements
CONNECT TO, 8-4
debugging, 6-10
defining to Oracle server, 5-4
describing tables, 8-6
diagnosing problems, 6-10, 6-14
error code processing, 8-10
explicit connection, 8-4
features, 1-6
files
QCBLLESRC, 8-3
QRPGLESRC, 8-3
QSQLCSRC, 8-3
implicit connection, 8-4
installation library, 6-2
introduction, 1-1
library, 6-2
message processing, 8-10
NLS support, B-2
options
USER, 6-5
USING, 6-5
package creation, 1-8
parameters
PASSWORD, 6-5
RDB, 8-4
stored procedures, 8-7
IN, 8-7IN OUT, 8-7OUT, 8-7
performance
SQL*Net trace, 6-8
programs
SAMP1C, 8-3
SAMP1CBL, 8-3
SAMP1RPG, 8-3
sample
C, A-2COBOL, A-5RPG, A-7
RELEASE ALL command, 8-5
SQL statement processing, 1-8
statements
CALL, 8-6
COMMIT, 8-4, 8-5
CONNECT TO, 6-5
DDL
CREATE, 6-7DROP, 6-7
ROLLBACK, 8-4, 8-5
SELECT, 6-6, 8-3
stored procedures, 8-6
advantages, 8-6
declaring, 8-7
GETRESULTS, 8-7
tracing values
*ADMIN, 6-9
*OFF, 6-9
*USER, 6-9
16, 6-9
two-phase commit
default options panel, 6-7
Oracle Access Manager Debugging Options panel, 6-10
Oracle Access Manager for AS/400, 1-8
Oracle Access Manager Network Parameters panel, 6-8
Oracle Net
connecting through, 5-3
trace options, 6-8
tracing members, 5-2
Oracle server
connecting to, 8-2
defining Oracle Access Manager to, 5-4
Oracle Server Name field, 7-11
ORACLE_SERVER parameter, 7-10, 7-11, 7-13
OUT parameter, 8-7

P

Panels
Change or Enter New Server Attributes, 7-10
Change Privileged Ids (Relative to AM400_COM), 7-12
Change RID (Resolve In Doubt) options, 7-8
Install Oracle Access Manager Product, 4-3
Oracle Access Manager Debugging Options, 6-11
Oracle Access Manager Network Parameters, 6-8
Verify Oracle Access Manager Install, 4-4
Parameters
AUTOCREATE CONTROLLER, 5-7
CLEANUP_DELAY, 7-9, 7-14, 7-16
DATAQUEUE_TIMEOUT, 7-9, 7-14, 7-16
DEAD_CHECK_COUNTER, 7-9, 7-16
HOLD, 2-6
Oracle Access Manager
PASSWORD, 6-5
RDB, 8-4
USER, 6-5
ORACLE_SERVER, 7-10, 7-13
ROBCNNMTH, 2-6
SERVER_STARTUP_TIMEOUT, 7-16
SQL*Net
TNSNAMES.ORA, 5-2
STARTUP, 7-11, 7-16
stored procedures, 8-7
IN, 8-7
IN OUT, 8-7
OUT, 8-7
TRACE_LEVEL, 7-9, 7-16
two-phase commit
ORACLE_SERVER, 7-11
verify installation parameters, 4-4
Password for Oracle Id field, 7-11
PASSWORD parameter, 6-5
Phrases
SIMPLE CALL WITH NULLS, 2-5
Post-installation, 4-6
add Oracle Access install library to library list, 4-7
checklist, 4-6
configure SQL*Net, 4-7
configure two-phase commit (optional), 4-8
retest connectivity to Oracle server, 4-8
test connectivity to Oracle server, 4-7
precision, default datatype, 2-4
prepare phase, defined, 7-2
Privileged Oracle Id field, 7-11
Privileges
GRANT command, 7-13
required, 7-13
Procedures
CALL, 8-7
GETRESULTS, 8-7
Processor
requirements, 3-2
Product set, 2-2
Programs
AM400_COM, 7-11, 7-12, 7-14, 7-17
AM400_RID, 7-5, 7-14, 7-17
Oracle Access Manager
SAMP1C, 8-3
SAMP1CBL, 8-3
SAMP1RG, 8-3
sample
C, A-2
COBOL, A-5
RPG, A-7

Q

QCBLLESRC file, 8-3
QRPGLESRC file, 8-3
QSECOFR security administration userid, 7-12
QSQLCSRC file, 8-3
QUERY command, 7-16

R

RAW datatype, 8-9
RDB entry, 5-4
RDB parameter, 8-4
RELEASE ALL command, 8-5
RELEASE command, 8-5
Release information, 2-1
Remote unit of work, 1-9
REMOVE command, 7-15
Requirements
communications, 3-3
hardware, 3-2
CD-ROM drive, 3-2
disk space, 3-2
processor, 3-2
software, 3-3
additional, 3-3
communications, 3-3
operating system, 3-3
Oracle server, 3-3
PTF, 3-3
ROBCNNMTH parameter, 2-6
ROLLBACK command, 1-9, 2-6, 6-7, 7-4, 7-13
ROLLBACK statement, 8-4, 8-5
ROWID datatype, 8-9

S

SAMP1C program, 8-3
SAMP1CBL program, 8-3
SAMP1RPG program, 8-3
Sample programs
Oracle Access Manager
C, A-2
COBOL, A-5
RPG, A-7
scale, default datatype, 2-4
SELECT command, 8-6
SELECT statement, 2-5, 6-6, 8-3
SERVER_STARTUP_TIMEOUT parameter, 7-16
SET command, 7-16
SET CONNECTION command, 8-4
SHUTDOWN command, 7-15
SID, system identifier, 5-8
SIMPLE CALL WITH NULLS phrase, 2-5
SMALLINT datatype, 8-9
Software requirements, 3-3
SQL statements
processing, 1-8
SQL*Net
checklists
TCP/IP AS/400 configuration, 5-6
commands
ADDRDBDIRE, 5-3, 5-4, 5-8
CRTLINETH, 5-7
CRTLINSDLC, 5-7
CRTLINTRN, 5-7
CRTLINX25, 5-7
DSPLIND, 5-7
WRKMBRPDM, 5-7
configuration, 4-7
TCP/IP, 5-6
file names, 5-2
files
ORA(TNSNAMES), 5-4
parameters
TNSNAMES.ORA, 5-2
token ring address, 5-7
SQLERRMC field, 8-10
SQLSTATE field, 8-10
STARTUP command, 7-15
STARTUP parameter, 7-11, 7-16
Startup Parameter field, 7-11
Statements
DB2/400
CONNECT TO, 8-4
DECLARE PROCEDURE, 8-7
DELETE, 2-5
EXEC SQL, 2-5
Oracle Access Manager
CALL, 8-6
COMMIT, 8-4, 8-5
CONNECT TO, 6-5
DDL
CREATE, 6-7DROP, 6-7
ROLLBACK, 8-4, 8-5
SELECT, 6-6, 8-3
SELECT, 2-5
SQL
processing, 1-8
UPDATE, 2-5
STATUS command, 7-15
Stored procedures, 2-5, 8-6
advantages, 8-6
declaring procedures, 8-7
GETRESULTS procedure, 8-7
parameters, 8-7
IN, 8-7
IN OUT, 8-7
OUT, 8-7
STRSBS command, 7-12
STRSQL, 6-14, 8-2
STRSQL command, 1-10
SUM function, 6-6
SYS.PENDING_SESSIONS$ table, 7-13
SYS.PENDING_TRANS$ table, 7-13
system identifier (SID), 5-8
System requirements
hardware, 3-2
disk space, 3-2
processor, 3-2
software
additional software, 3-3
DB2/400 Query Manager, 3-3
network, 3-3
operating system, 3-3

T

Tables
SYS.PENDING_SESSIONS$, 7-13
SYS.PENDING_TRANS$, 7-13
TCP/IP
AS/400 configuration
define physical line, 5-7
define TNSNAMES entry, 5-7
configuring SQL*Net, 5-6
Terminology
two-phase commit
AM400_COM program, 7-2
AM400_RID program, 7-2
commit phase, 7-3
commit point site, 7-2
implied commit, 7-3
prepare phase, 7-2
two-phase commit parameter, 7-2
TIME datatype, 2-5
TIMESTAMP datatype, 2-5
TNS, 5-1
TNSNAMES
defining for TCP/IP, 5-7
entry, 5-4
TNSNAMES.ORA parameter, 5-2
TO_CHAR function, 6-14
TO_DATE function, 6-14
Token ring address, 5-7
TRACE_LEVEL parameter, 7-9, 7-16
Tracing
values
*ADMIN, 6-9
*OFF, 6-9
*USER, 6-9
16, 6-9
Transparent Networking Substrate See TNS
Two-phase commit
AM400_COM program, 7-11, 7-12, 7-14, 7-17
AM400_RID program, 7-4, 7-5, 7-9, 7-11, 7-14, 7-17
altering, 7-14
starting, 7-12
commands
AM400_COM program, 7-15
ADD, 7-15FORCE, 7-17LIST, 7-17MODIFY, 7-15QUERY, 7-16REMOVE, 7-15SET, 7-16SHUTDOWN, 7-15STARTUP, 7-15STATUS, 7-15
CHG2PCPRM, 7-8, 7-11
CHGSQLDFLT, 7-2
COMMIT, 7-3, 7-4, 7-13
GRANT, 7-13
ROLLBACK, 7-4, 7-13
STRSBS, 7-12
default options panel, 6-7
enabling, 7-7
add or remove AM400_COM privileged userids, 7-11
change Oracle Access Manager commit default, 7-8
change the AM400_RID options, 7-8
checklist, 7-7
start the AM400_COM program (optional), 7-13
start the subsystem that runs AM400_RID program, 7-12
fields
description, 7-11
Oracle server name, 7-11
password for Oracle id, 7-11
privileged Oracle id, 7-11
startup parameter, 7-11
overview, 7-2
panels
Change or Enter New Server Attributes, 7-10
Change Privileged Ids (Relative to AM400_COM), 7-12
Change RID (Resolve In Doubt) Options, 7-8
parameters
CLEANUP_DELAY, 7-9, 7-14, 7-16
DATAQUEUE_TIMEOUT, 7-9, 7-14, 7-16
DEAD_CHECK_COUNTER, 7-9, 7-16
ORACLE_SERVER, 7-10, 7-11, 7-13
SERVER_STARTUP_TIMEOUT, 7-16
STARTUP, 7-11, 7-16
TRACE_LEVEL, 7-9, 7-16
process, 7-4
commit phase, 7-4
phase 1, 7-4
phase 2, 7-4
prepare phase, 7-4
resolve in-doubt transactions, 7-5
tables
SYS.PENDING_SESSIONS$, 7-13
SYS.PENDING_TRANS$, 7-13
terminology, 7-2
AM400_COM program, 7-2
AM400_RID program, 7-2
commit phase, 7-3
commit point site, 7-2
implied commit, 7-3
prepare phase, 7-2
two-phase commit parameter, 7-2
two-phase commit parameter, defined, 7-2

U

UPDATE statement, 2-5
USER option, 6-5
USER parameter, 6-5

V

VARCHAR datatype, 8-9
VARCHAR2 datatype, 8-9
Verify Oracle Access Manager Install panel, 4-4

W

WRKMBRPDM command, 5-7

Go to previous page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents