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