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