home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: Product
/
Product.zip
/
DBDEMO.ZIP
/
DEMOFLS.ZIP
/
RDSREQ.TXT
< prev
next >
Wrap
Text File
|
1991-07-08
|
4KB
|
140 lines
CONFIGURING AN OS/2 DATABASE REQUESTER USING SQLLOO
IN ORDER TO CONFIGURE AN OS/2 DATABASE REQUESTER YOU NEED TO KNOW :
* YOUR LAN ADAPTER TYPE (eg. IBM TOKEN-RING 16/4)
* YOUR LOCAL LAN ADAPTER ADDRESS (12 DIGITS - YOU CAN MAKE UP THIS
NUMBER BUT IT MUST BE UNIQUE ON THE
NETWORK)
* LAN DESTINATION ADDRESS (SERVER ADDRESS - 12 digits MUST MATCH THE
LOCAL ADAPTER ADDRESS SPECIFIED ON THE
SERVER. YOU CAN FIND OUT WHAT THE SERVER
ADAPTER ADDRESS IS BY DOING :
"TYPE ACSLAN.LOG <enter>" ON THE SERVER
MACHINE.)
INSTALL THE OS/2 EE DATABASE CODE SELECTING THE OPTION TO INSTALL REMOTE
DATA SERVICES.
NEXT YOU MUST CONFIGURE THE OS/2 EE COMMUNICATIONS MANAGER TO ESTABLISH
THE CORRECT APPC PROFILES.
TO SETUP YOUR COM MGR CONFIGURATION ON THE REQUESTER :
1. START COMMUNICATIONS MANAGER
2. SELECT ADVANCED CONFIGURATIONS OPTION
3. SELECT SNA FEATURE PROFILES
4. SELECT LOCAL APPC LU PROFILE
5. SELECT CREATE - LU NAME = LU1
- LU ALIAS = LU1
- LU NAME = LU1
- DEFAULT LU = NO
- LU LOCAL ADD = 00
- LU SESSION LIMIT = 255
- MAXIMUM # OF TRANS PGMS = 0
6. SELECT PARTNER LU PROFILE
7. SELECT CREATE - LU NAME = LU2
- PARTNER LU ALIAS = LU2
- FULLY QUALIFIED PLU NAME = .LU2
- LU ALIAS = LU1
- ADAPTER/DIRECTORY ENTRY = 0
- DESTINATION ADDRESS = SERVER ADAPTER ADDRESS (12 DIGITS)
- PLU SESSION LIMIT = 1
- MAX MAPPED CONVERSATION = 32767
- LU-LU SESSION SECURITY = NO
- CONVERSATION SECURITY = YES
- CONVERSATION SECURITY VERIFIED = NO
- PERMANENT CONNECTION = NO
- SOLICIT SSCP SESSION = NO
- MODE NAME = SQLLOO
- INITIAL SESSION LIMIT = LU1ISL
8. SELECT TRANSMISSION SERVICE MODE PROFILE
9. SELECT CREATE - NAME = SQLLOO
- MODE NAME = SQLLOO
- MIN RU SIZE = 256
- MAX RU SIZE = 1920
- RECEIVE PACING LIMIT = 4
- SESSION LIMIT = 1
10. SELECT INITIAL SESSION LIMIT PROFILE
11. SELECT CREATE - NAME = LU1ISL
- INITIAL SESSION LIMIT PROFILE = LU1ISL
- (SET REMAINING OPTIONS) = 0
12. SAVE AND VERIFY NEW PROFILE
13. EXIT COM MANAGER
14. RESTART COM MGR TO ACTIVATE NEW PROFILE SETTINGS
TO SETUP DATABASE MANAGER ON YOUR MACHINE :
1. ASK THE LAN ADMINISTRATOR TO ASSIGN YOU A NETWORK USER ID & PASSWORD.
GET THE DATABASE ADMINISTRATOR TO GIVE ACCESS RIGHTS TO YOUR ID FOR
EACH DATABASE YOU WISH TO ACCESS.
2. SETUP THAT SAME ID AND PASSWORD ON YOUR REQUESTER MACHINE.
MAKE SURE THAT YOU GRANT YOUR ID ADMINISTRATOR AUTHORITY ON THE
REQUESTER SO YOU WILL BE ABLE TO CREATE LOCAL DATABASES USING THAT ID.
3. START QUERY MGR
4. CATALOG THE REMOTE WORKSTATION. DO THIS BY SELECTING "SYSTEM" THEN
CATALOG REMOTE WORKSTATION. THE VALUES REQUIRED ON THE NEXT PANEL
WILL BE :
- REMOTE WORKSTATION NAME : NODE NAME OF DATABASE SERVER
- LU PROFILE NAME : LU1
- PARTNER LU PROFILE : LU2
- TRANSMISSION SERVICE MODE PROFILE NAME : SQLLOO
5. CATALOG ALL OF THE REMOTE DATABASES THAT YOU WISH TO ACCESS. DO THIS BY
SELECTING "TOOLS" THEN "CATALOG DATABASE". THE DATABASE NAME MUST
CORRESPOND TO THE NAME ON THE SERVER, THE NICKNAME CAN BE ANY NAME
YOU WISH TO ASSIGN, THE REMOTE WORKSTATION SHOULD MATCH THE NODE
NAME OF THE SERVER WHICH CONTAINS THE DATABASE.
6. EXIT QUERYMGR
7. STOP DBM