home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: Product
/
Product.zip
/
DBDEMO.ZIP
/
DEMOFLS.ZIP
/
RDSSRV.TXT
< prev
next >
Wrap
Text File
|
1991-07-08
|
5KB
|
150 lines
CONFIGURING AN OS/2 DATABASE SERVER USING SQLLOO
IN ORDER TO CONFIGURE AN OS/2 DATABASE SERVER YOU NEED TO KNOW :
* YOUR LAN ADAPTER TYPE (eg. IBM TOKEN-RING 16/4)
* YOUR LOCAL LAN ADAPTER ADDRESS (12 DIGITS - MUST BE UNIQUE ON THE
NETWORK. YOU CAN FIND THIS ADDRESS
BY ENTERING :
"TYPE ACSLAN.LOG <enter>".)
INSTALL THE OS/2 EE DATABASE CODE SELECTING THE OPTION TO INSTALL REMOTE
DATA SERVICES. SPECIFY THE OPTION THAT ALLOWS YOU TO CREATE LOCAL DATABASES
AND THE OPTION THAT ALLOWS THOSE DATABASES TO BE ACCESSED REMOTELY.
NEXT YOU MUST CONFIGURE THE OS/2 EE COMMUNICATIONS MANAGER TO ESTABLISH
THE CORRECT APPC PROFILES.
TO SETUP YOUR COM MGR CONFIGURATION ON THE SERVER :
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 = LU2
- LU ALIAS = LU2
- LU NAME = LU2
- 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 = *PLU
- PARTNER LU ALIAS = *PLU
- FULLY QUALIFIED PLU NAME = .
- LU ALIAS = LU2
- ADAPTER/DIRECTORY ENTRY = 0
- DESTINATION ADDRESS = 00000000000
- PLU SESSION LIMIT = 255
- 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 =
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 = 253
10. EXIT "SNA FEATURE PROFILES"
11. SELECT "LAN FEATURE PROFILES"
12. MAKE SURE THAT THE 802.2 AND NETBIOS PROFILES CONTAIN SETTINGS FOR
MAXIMUM LINK STATIONS, MAXIMUM NUMBER SAPS, MAXIMUM NUMBER OF USERS
THAT ARE APPROPRIATE FOR YOUR ENVIRONMENT. THESE PROFILE SETTINGS
WILL VARY DEPENDING ON THE APPLICATIONS THAT COEXIST ON THE SERVER
WITH DBM (eg. LAN SERVER).
SEE "PARAMETER AND TUNING GUIDE FOR OPERATING SYSTEM/2 EXTENDED
EDITION AND LAN SERVER, VERSIONS 1.2 AND 1.3" FOR ASSISTANCE IN
SETTING THESE PROFILES. THIS DOCUMENT CAN BE OBTAINED FROM YOUR
IBM REPRESENTATIVE.
13. SAVE AND VERIFY NEW PROFILE
14. EXIT COM MANAGER
15. RESTART COM MGR TO ACTIVATE THESE NEW PROFILE SETTINGS.
TO SETUP DATABASE MANAGER ON YOUR SERVER :
1. YOU MUST BE LOGGED ON WITH AN ID THAT HAS ADMINISTRATOR AUTHORITY.
2. START QUERY MGR
3. IN THE "SYSTEM" MENU SELECT "RECONFIGURE DATABASE MANAGER". GO THROUGH
EACH PANEL AND SET THE PARAMETERS TO THE APPROPRIATE VALUES. INFORMATION
ON THE PROPER VALUE FOR EACH PARAMETER CAN BE FOUND IN :
a. "PARAMETER AND TUNING GUIDE FOR OPERATING SYSTEM/2
EXTENDED EDITION AND LAN SERVER, VERSIONS 1.2 AND
1.3"
b. "ONE STOP PERFORMANCE SHOPPING" - BRUCE TATE
c. "DATABASE PERFORMANCE DEMO - DATABASE PARAMETERS"
IF YOU OBTAINED THIS DOCUMENT AT AN OS/2 TECHNICAL SEMINAR THEN YOU WILL
FIND THE ABOVE DOCUMENTS ON THE DISKETTE THAT YOU WERE GIVEN AT THE
DATABASE DEMO. REFER TO THE README FILE IN THE ROOT DIRECTORY OF
THE DISKETTE FOR MORE INFORMATION. OTHERWISE YOU MAY OBTAIN COPIES
OF THE ITEM a) THROUGH YOUR IBM REPRESENTATIVE. ITEMS b) AND c) ARE
NOT GENERALLY AVAILABLE.
4. FOR EACH DATABASE ON THE SERVER : SELECT "RECONFIGURE LOCAL DATABASE"
FROM THE "TOOLS" MENU. GO THROUGH EACH PANEL AND SET THE PARAMETERS TO
THE APPROPRIATE VALUES. SEE REFERENCES ABOVE FOR INFORMATION ON THE
APPROPRIATE VALUES.
5. EXIT QUERY MGR
6. STOP DBM