32-Bit ODBC Administrator

ODBC is a programming interface that enables applications to access data in database management systems that use Structured Query Language (SQL) as a data access standard.

Use the following steps to set up the Personal Communications ODBC data source:
  1. Select the 32-bit ODBC Administrator icon from the Windows® Control Panel. The Data Sources window appears.
  2. Select IBM® DB2® ODBC Driver data source in the Data Sources (Drivers) list. Then click Finish.
  3. Click Add Database. The Personal Communications Add Database SmartGuide appears to prompt you through the set up.
  4. Select the Manually Configure a Connection to a DB2® Database radio button.
  5. Specify the information to set up the data source, by clicking Next.
  6. When you are finished specifying the information, click Done.
  7. You will be prompted to test the connection. To test the connection, click OK.
Note:
  1. Personal Communications uses ODBC 32-bit drivers. Applications, such as Lotus® 1-2-3® included in the Lotus® SmartSuite® 96 package, require a 16-bit driver and will not work with Personal Communications. You should see your product vendor for a version that utilizes 32-bit ODBC drivers (Lotus 1-2-3® included in Lotus® SmartSuite® 97 for example).
  2. To successfully test the DB2® connection, you must start the Personal Communications SNA subsystem with the appropriate configuration data. This configuration data must include the following:
    • Node definition
    • Device definition
    • Connection definition
    • Partner LU definition
    • Mode definition (IBMRDB must be created)
    • CPI-C Side Information

    You might also need to include a Local LU 6.2 definition.

    For more information on SNA Node operations, refer to Administrator's Guide and Reference.

Following is a sample .ACG file: 
NODE=(
     ANYNET_SUPPORT=ANYNET_SUPPORTED
	  CP_ALIAS=YOURALIAS
     DEFAULT_PREFERENCE=NATIVE
     DISCOVERY_SUPPORT=DISCOVERY_CLIENT
     FQ_CP_NAME=YOUR.CPNAME              * <---- Modify w/ CP Name
     NODE_ID=05D00000
     NODE_TYPE=END_NODE
     REGISTER_WITH_CDS=1
     REGISTER_WITH_NN=1
)
PORT=(
     PORT_NAME=LAN0_04
     DLC_DATA=00000000000004
     DLC_NAME=LAN
     IMPLICIT_CP_CP_SESS_SUPPORT=1
     IMPLICIT_DEACT_TIMER=0
     IMPLICIT_DSPU_SERVICES=NONE
     IMPLICIT_HPR_SUPPORT=1
     IMPLICIT_LIMITED_RESOURCE=NO
     LINK_STATION_ROLE=NEGOTIABLE
     MAX_IFRM_RCVD=8
     MAX_RCV_BTU_SIZE=32767
     PORT_TYPE=SATF
     PORT_LAN_SPECIFIC_DATA=(
          ACK_DELAY=100
          ACK_TIMEOUT=3000
          ADAPTER_NUMBER=0
          BUSY_STATE_TIMEOUT=60
          IDLE_STATE_TIMEOUT=30
          LOCAL_SAP=04
          MAX_RETRY=10
          OUTSTANDING_TRANSMITS=16
          POLL_TIMEOUT=3000
          POOL_SIZE=16
          REJECT_RESPONSE_TIMEOUT=30
          TEST_RETRY_INTERVAL=8
          TEST_RETRY_LIMIT=5
          XID_RETRY_INTERVAL=8
          XID_RETRY_LIMIT=5
     )
)
LINK_STATION=(
     LS_NAME=LINKMVS
     ACTIVATE_AT_STARTUP=1
     ADJACENT_NODE_TYPE=APPN_NODE
     AUTO_ACTIVATE_SUPPORT=0
     CP_CP_SESS_SUPPORT=1
     DEFAULT_NN_SERVER=0
     DEST_ADDRESS=40000000000000      * <---- Modify w/ Dest
     DISABLE_REMOTE_ACT=0
     DSPU_SERVICES=NONE
     ETHERNET_FORMAT=0
     HPR_SUPPORT=0
     LIMITED_RESOURCE=NO
     LINK_DEACT_TIMER=0
     LINK_STATION_ROLE=USE_ADAPTER_DEFAULTS
     MAX_IFRM_RCVD=0
     MAX_SEND_BTU_SIZE=32767
     NODE_ID=05D00000
     PORT_NAME=LAN0_04
     SOLICIT_SSCP_SESSION=0
     TARGET_PACING_COUNT=1
     TG_NUMBER=0
     USE_DEFAULT_TG_CHARS=1
)
DLUR_DEFAULTS=(
     DEFAULT_PU_NAME=YOURALIAS    * <---- Modify w/ your name
     DLUS_RETRY_LIMIT=3
     DLUS_RETRY_TIMEOUT=5
)
LOCAL_LU=(
     LU_NAME=LUNAME               * <---- Modify w/ LU Name
     LU_ALIAS=LUALIAS             * <---- Modify w/ LU Alias
     LU_SESSION_LIMIT=0
     NAU_ADDRESS=0
     ROUTE_TO_CLIENT=0
     DEFAULT_POOL=0
)
.
.
.
PARTNER_LU=(
     FQ_PLU_NAME=PARTNER.LUNAME       * <---- Modify w/ Partner Info
     CONV_SECURITY_VERIFICATION=1
     MAX_MC_LL_SEND_SIZE=32767
     PARALLEL_SESSION_SUPPORT=1
     PARTNER_LU_ALIAS=RBNAME          * <---- Modify w/ Location/RDBNAME
     PREFERENCE=USE_DEFAULT_PREFERENCE
)
CPIC_SIDE_INFO=(
     SYM_DEST_NAME=DB2CPIC            * <----- Needed for ODBC configuration
     CONVERSATION_SECURITY_TYPE=NONE
     MODE_NAME=IBMRDB
     PARTNER_LU_NAME=USIBMNM.NM57DB21 * <---- Modify w/ Partner Info
     TP_NAME=DB2DRDA                  * <---- Modify w/TP Name (per DB2 help)
     TP_NAME_TYPE=APPLICATION_TP
)
VERIFY=(
     CFG_MODIFICATION_LEVEL=13
     CFG_VERSION_LEVEL=1
)