hide random home http://www.microsoft.com/TechNet/boes/bo/sna/technote/reviewer/demodrv.htm (PC Press Internet CD, 03/1996)

Updated: March 15,1996 TechNet Logo Go To TechNet Home Page

MS SNA Server 2.11 Demo Script Test Drives for the Reviewer's Guide-Contents

June, 1995

icobrnchSNA Server Setup Program
icobrnchSetup and Configure SNA Server Clients
icobrnchOperate the DEMO SDLC Link Service
icobrnchSetup and Configure ODBC/DRDA
icobrnchOperate the ODBC/DRDA Demo
icobrnchUsing SNA Server Diagnostic Tools
icobrnchModifying or Removing SNA Servers
icobrnchModifying or Removing SNA Clients


SNA Server Setup Program

Step 1: Run the SNA Server Setup Program

The SNA Server Setup program installs SNA Server, using the information you provide in various dialog boxes. Once the initial files are installed, you add and configure the link services for your SNA server. Setup then creates a configuration file on the primary SNA server. The connections, LUs, groups, and user access rights that you configure with the SNA Server Admin will also be stored in the configuration files. Setup is a graphical interface that allows you to install, configure and remove SNA Server, link services, and SNA Server client software.

To use Setup, you must be logged on as an Administrator on the Windows NT Server, because Setup requires the ability to access the Windows NT Registry.

Note on the Components Installed by Setup

graphic

Setup installs the following software components on an SNA server: SnaBase, SnaServer, Link Services, and SnaNMVT, NVRunCmd, and NVAlert. Of the components listed in this section, only SnaBase is automatically started when the Windows NT system is started. To start any other service automatically, use the Control Panel to configure the startup type for the service, as described in your Windows NT documentation.

Run Setup

  1. Insert either the SNA Server CD or the first installation disk into an appropriate drive.

For information on creating diskette images, refer to the SNA Server 2.11 README.WRI file.

  1. In File Manager or at the command prompt, change to the drive containing the CD or floppy disk.
  2. Start Setup:
    • To start Setup from File Manager, double-click on SETUP.EXE.
    • To start Setup from the command prompt, type "SETUP"

A welcome to SNA Server Setup dialog box appears.

graphic

  1. Choose the Help button to get assistance any time you are using a dialog box. When you do, Setup displays a text box explaining the choices you have at that point and the procedure to complete the dialog box.
  2. Choose the Continue button.

Select and Accept an Appropriate Licensing Mode

Licensing for the Microsoft BackOffice family of server products requires a Server License and a license for each client computer to access the server, which is called a Client Access License. These licenses are acquired separately prior to using the product. For SNA Server, Windows NT Server, and SQL Server, the Client Access License can be used in either of two licensing modes (Per Server and Per Seat) offering customers the flexibility to choose the option that best meets their needs.

SNA Server version 2.11 Setup presents a Choose Licensing Mode dialog box. You will be required to select a licensing option and accept the terms of the license agreement for Setup to complete. In this dialog box, you must indicate whether you want SNA Server version 2.11 to be installed in the Per Server or Per Seat licensing mode. Every box of SNA Server 2.11 comes with one client access license, therefore if you are unsure, for purposes of installing the SDLC Demo Link Service you can choose "per seat".

graphic

Record Identifying Information

You can record identifying information in your SNA Server software when the software licensing dialog appears.

  1. In the box marked Your name, type your name.
  2. Optionally, in the box marked Company name, type your company's name.
  3. In the box marked Product ID, type the product identification number, available on the inside back cover of this installation guide.

graphic

By entering the Product ID (PID), you make it available for display through the SNA Server version number utility, SNAVER, so that if you call for product support, you can readily identify your software when requested.

In the Confirm License Information dialog box, choose the OK button. The Installation Path dialog box, shown in the next section, appears.

Specify the Installation Path

You can use the default installation path offered by Setup (C:\SNA), or change the path.

graphic

In the Installation Path dialog box, choose the Continue button.

Setup copies the files needed by SNA Server and creates the Registry entries for all sub-services.

Select Client/Server Protocols

If Setup detects more than one client/server protocol on your computer, you must specify which protocols you are using.

graphic

You will only see the Select Client/Server Protocols dialog box if there is more than one client/server protocol on your computer.

Specify the Network Domain Name:

If you did not select Microsoft Networking (Named Pipes) as one of your client/server protocols, you must specify the name of the network domain. If your operating system is Banyan VINES (and not Microsoft Networking), you must also specify the Banyan StreetTalk™ group name.

graphic

In the appropriate box, type the network domain name.

For a TCP/IP network, you can specify the name in any of several forms: the domain name used in the Windows NT domain or the host name plus the TCP domain name. If you are using Banyan VINES (and not Microsoft Networking), the StreetTalk Group Name dialog box appears.

Select the Server Role

When installing an SNA server, the server is designated as primary, backup, or member.

graphic

The primary SNA server contains the domain-wide configuration file. The configuration file reflects the SNA Server resources for the domain, including all SNA servers, link services, LUs, and 3270 users. There can be only one primary server in the domain. Typically, the primary server is the first server installed.

A backup SNA server is a server on which the configuration file is replicated by SNA Server. There can be more than one backup server in a domain. SNA Server will load the copy of the configuration file located on a backup SNA server if the primary SNA server goes down; in this case, servers and connections can be started and stopped, but the configuration cannot be changed or saved.

A member SNA server does not contain the configuration file. One or more SNA servers can operate as member servers.

Setup copies the files to the selected location. If you are installing from floppy disks, you will be prompted to insert floppy disks as they are needed.

Install the On-Line Documents

Setup can create an icon in the SNA Server program group linked to the SNA Server on-line Table of Contents and on-line documents.

graphic

Install the SDLC Demo Link Service

Link services define the protocol used between the SNA Server software and the communications adapters installed in a computer. Link services are written to the SNADIS interface. You can install any of the link services listed in the Link Service Installation dialog box.

  1. Choose to install the DEMO SDLC Link Service from the Link Service Installation dialog box.

graphic

DEMO SDLC Link Service is capable of emulating a 3270 host or an AS/400, depending on the script file you choose and the SNA Server configuration. Script files are provided for emulations of sessions with a 3270 host or an AS/400 computer.

DEMO SDLC Link Service is installed in the same way as an SDLC link service, but rather than selecting and configuring an SDLC card type, you specify a script file that contains the messages the DEMO SDLC Link Service needs to send to SNA Server. A link service can be installed when installing SNA Server, or after SNA Server setup is complete.

  1. In the Available Link Services box of the Link Service Installation dialog box, select the DEMO SDLC Link Service. Choose the Install button.

3270 Demo Scripts

  1. Select the "3270 Continuous Demo" script file:

graphic

Choose this option for an emulation of 3270 flash. (Flash is a test transaction program which runs on the host, continuously sending screenfuls of data at the emulator. This program can be used to simulate a live host session and provides a means to demo NetView RTM data displayed in Windows NT Performance Monitor.)

  1. Select Add to choose additional Demo Link Services.

graphic

  1. Repeat Step 1 to choose to install a second demo link service.
  2. Select the "3270 Logon Demo" script file:

graphic

Choose this option for an emulation of 3270 logon and logoff to a mainframe computer.

5250 Demo Script

  1. Repeat Step 1 above to choose to install a second demo link service.
  2. Select the "5250 Logon Demo" script file:

graphic

Choose this option for a demonstration of a 5250 emulation session on an AS/400 computer. This demo script provides demonstrations of both a 5250 loop script and a SQL Query to a database on an AS/400.

The supplied demo link scripts are automatically copied to the SNARoot\SYSTEM directory by Setup.

  1. Choose "continue" to dynamically bind the demo link services to the network drivers in the Control Panel.

graphic

Completing Setup

From the SNA Server Setup Finished dialog box, you should proceed directly to SNA Server Admin to configure the connections and LUs for your link services.

graphic

  1. Choose OK.
  2. Select the "Admin" button to run the SNA Server Admin program.

The following section of this Test Drive document explains how to continue with the configuration of SNA Server.

graphic

After you have used Setup to install SNA Server, the link services and client software, you use SNA Server Admin to configure connections, LUs, and assign user rights to the LUs. Later, if you need to change or create additional link services, you can run Setup again to configure these link services.

Step 2: Run the SNA Admin Program

The SNA Server Admin program provides a graphical interface that allows you to configure connections between PCs and remote computers - IBM mainframes, AS/400 systems, or other PCs - within an IBM SNA network.

Basic Elements of SNA Server Configurations

Two important elements are used in every SNA configuration: connections and logical units (LUs). A connection is the data communication path between computers on the SNA network. An LU is a preset unit containing all the configuration information needed for a user, program, or downstream system to establish a session with a host or peer computer. Connections are configured first, and then one or more LUs can be assigned to each connection.

Multiple connections can share a single link service. Multiple LUs can share a single connection.

After LUs are configured, they can be grouped together in LU pools, to maximize access to resources. A user, LUA application, or downstream system using the pool can get LU access as long as one of the pooled LUs is available.

Starting SNA Server Admin

graphic

You can start SNA Server Admin from the Setup program or by clicking the SNA Server Admin icon.

The SNA Server Admin display is structured around several windows that appear inside the main window. The windows can be shrunk to icons, and then restored to windows. The windows are as follows:

graphic

Configuring the 3270 Continuous Demo Link

Configuring the Host Link

  1. Highlight the Servers and Connections window.

Note that the SNA Server name is highlighted (in our example, the name is "PLARSEN").

  1. Highlight the "SLDC1" service.
  2. Choose the Services_Properties menu item.

The following Connection Properties dialog box appears:

graphic

Confirm that the link service for SDLC1 is SnaDemo1. During Setup, we associated SnaDemo1 with the 3270 Continuous Demo script file.

  1. Select "Host System" for Remote End and "On Demand" for Activation method.
  2. Choose the Setup button.

The SDLC Setup dialog box appears:

graphic

  1. Choose the OK button to close the SDLC Setup dialog box.

Although the default values are not modified, steps 5-6 must be performed to properly configure the demo link connection.

  1. Choose the OK button to close the Connection Properties dialog box.

Assigning Host LUs to Host Link

  1. Highlight the Servers and Connections window.
  2. Choose the Services_Assign LUs menu item.

The Insert LU dialog box appears:

graphic

  1. Select 3270 as the New Logical Unit type.
  2. Choose the OK button to continue.

The New 3270 LU Properties dialog box appears:

graphic

  1. Configure the LU properties as follows:
    • LU Number must be 2 for the demo link service.
    • Choose any LU Name (for example, "FLASH").
    • Select LU Type "Display".
    • Select Display Model "2", "Model can be overridden".
  2. Choose the OK button to close the dialog box.

Adding new SNA Server Users

  1. Highlight the Users and Groups window.
  2. Choose the Users_New User menu item.

The Add Users and Groups dialog box appears:

graphic

  1. Highlight a user or group of users to grant rights to host LUs from this SNA Server (for example, "Everyone") from the Names list.
  2. Choose the Add button.
  3. Choose the OK button to close the Add Users and Groups dialog box.

Assigning Host LUs to Users

  1. Highlight the new user or group (in our example, "Everyone").
  2. Choose the Users_Assign LUs menu item.

The Assign User LU/Pool Sessions dialog box appears.

graphic

  1. Select the available LU to assign to the user. In our example, assign the LU "FLASH" to the group "Everyone".
  2. Choose the OK button to close the dialog box.

Configuring the 3270 Logon Demo Link

Configuring the Host Link

To configure 3270 Logon Demo Link Service, follow the directions above for the 3270 Continuous Demo Link Service. The Connection Name in our example, and will be by default, "SDLC2". The Link Service Name should be "SnaDemo2".

Assigning Host LUs to Host Link

To assign host LUs to the 3270 Logon Demo Link, follow the directions above, except be sure to choose a different LU name, such as "LOGON".

Adding new SNA Server Users

No additional users or groups need to be added.

Assigning Host LUs to Users

To assign the "LOGON" LU to everyone, follow the directions above.

Creating 3270 LU Pools

Creating LU Pools

  1. Highlight the LU Pools window of the SNA Server Admin.
  2. Choose the Pool_New Pool menu item.

The New Pool dialog box appears:

graphic

  1. Type the name of the Pool. For example "POOL".
  2. Choose the OK button to close the New Pool dialog box.

Grouping Host LUs into a Pool

  1. Highlight the LU Pools window of the SNA Server Admin.
  2. Choose the Pool_Assign LUs menu item.

The Assign Pool LUs dialog box appears:

graphic

  1. Highlight all available LUs. In our example, LUs "FLASH" and "LOGON" are available.
  2. Choose the OK button to close the Assign Pool LUs dialog box.

Assigning LU Pools to Users

  1. Highlight the new user or group (in our example, "Everyone").
  2. Choose the Users_Assign LUs menu item.

The Assign User LU/Pool Sessions dialog box appears.

graphic

  1. Select the available LU Pool to assign to the user. In our example, assign the LU Pool "POOL" to the group "Everyone".
  2. Choose the OK button to close the dialog box.

Configuring the AS/400 Demo Link

Configuring the Host Link

  1. Highlight the Servers and Connections window.

Note that the SNA Server name is highlighted (in our example, the name is "PLARSEN").

  1. Highlight the "SDLC3" service.
  2. Choose the Services_Properties menu item.

The following Connection Properties dialog box appears:

graphic

Confirm that the link service for SDLC3 is SnaDemo3. During Setup, we associated SnaDemo3 with the AS/400 Demo script file.

  1. Select "Peer System" for Remote End and "On Demand" for Activation method.
  2. Choose the Setup button.

The SDLC Setup dialog box appears:

graphic

  1. Specify the Remote Node Name. In our example, the Network Name is "APPN" and the Control Point Name is "REMOTE".
  2. Choose the OK button to close the SDLC Setup dialog box.
  3. Choose the OK button to close the Connection Properties dialog box.

Assigning Host LUs to Host Link

New functionality has been added to SNA Server Admin to automatically assign a new APPC (Remote) LU when the Connection Properties dialog box is closed, if the connection has been configured for Peer System.

The user is prompted to automatically create a new APPC Remote LU when the user completes configuring of a peer link. The prompt dialog appears automatically:

graphic

  1. Choose "Yes" to continue with creation of a new Remote APPC LU.

The APPC Remote LU Properties dialog appears:

graphic

  1. Accept the default LU Alias. In our example, the remote LU Alias is "REMOTE".
  2. Press the TAB key to automatically assign the "REMOTE" label to the LU Name and Uninterpreted LU Name.

The LU Name and Uninterpreted LU Name text boxes are automatically filled in. Leave other settings at the default values.

  1. Choose the OK button to close the dialog box.

Adding new SNA Server Users

No additional users or groups need to be added.

Assigning Host LUs to Users

  1. Highlight the new user or group (in our example, "Everyone").
  2. Choose the Users_Properties menu item.

The Group Properties dialog box appears:

graphic

  1. Choose "LOCAL" for the Local LU Alias using the drop down list box.
  2. Choose "REMOTE" for the Remote LU Alias using the drop down list box.
  3. Choose the OK button to close the dialog box.

Saving Configuration Information

Saving the SNA Server Configuration

  1. Choose the File_Save Configuration menu item.

The SNA Server configuration is saved to \\SNAroot\SYSTEM\CONFIG\COM.CFG.

Backing-up the SNA Server Configuration

  1. Choose the File_Backup menu item.
  2. Choose an appropriate location to which to backup the SNA Server configuration. In our example, save the configuration file to your root directory.
  3. Provide a file name. In our example, SNASRVR.SNA.
  4. Choose the OK button to close the dialog box.

The SNA Server configuration is backed to \\root\SNASRVR.SNA.

Finding Additional Information

The Microsoft SNA Server Installation Guide, Microsoft SNA Server Administration Guide, Microsoft SNA Server 2.11 Enhancements Guide, gives detailed information on the installation and configuration procedures.

Document Contents


Setup and Configure SNA Server Clients

Client software must be installed on the client computer in order to use SNA Server. You can install the client software either locally, via disk, or over the network.

You must be ready to specify whether the SNA Server(s) the client will be communicating with is in the local or a remote domain. Local indicates that the primary server containing the configuration file is located in the same SNA domain. Remote indicates that the server resides in a different domain. For remote, you will need to indicate the primary server name. In our example, the SNA Server name is "PLARSEN".

Installing the Windows NT-Based Client

To install over the network

  1. Locate the SNA Server client installation binaries by establishing a share to the SNA Server product CD-ROM or a server containing the installation files.
  2. Type SETUP and press enter to initiate the client Setup program.

To install from disk

  1. Type a:\setup and press enter.

The SNA Server Setup welcome dialog box appears.

  1. Choose Continue.

The Path Selection dialog box appears.

  1. Choose the path of choice. In our example, choose the default path and continue.
  2. Choose Client/Server Protocol.

The SNA Server Client Setup program will detect which LAN protocols are installed on your workstation. The Select Client/Server Protocols dialog appears:

graphic

  1. Choose the protocol of choice. In our example, choose TCP/IP.

The SNA Client Mode dialog appears:

graphic

  1. Choose Local domain if the target SNA Server is located in the same SNA domain as the client. Choose remote domain if the SNA Server is located in a different SNA domain from the target SNA Server. Choose continue.
    • If you chose Local, then the Network Domain Name dialog appears:

graphic

graphic

  1. Choose continue to further the setup of the SNA Server Client. The Optional Components dialog appears:

graphic

  1. Choose Continue to accept the defaults.

Choosing the "Install Administration Program" check box will cause Setup to install a local copy of the SNA Server Admin program. Admin allows users with sufficient privileges to administer SNA Server located anywhere on the network.

  1. Choose Continue to complete setup of the SNA Server Client.

Installing the Windows 3.x-Based Client

To install over the network

  1. Locate the SNA Server client installation binaries by establishing a share to the SNA Server product CD-ROM or a server containing the installation files.
  2. Type SETUP and press enter to initiate the client Setup program.

To install from disk

  1. Type a:\setup and press enter.

The SNA Server Setup welcome dialog box appears.

  1. Choose Continue.

The Path Selection dialog box appears.

  1. Choose the path of choice. In our example, choose the default path and continue.
  2. Choose Client/Server Protocol.

The SNA Server Client Setup program will detect which LAN protocols are installed on your workstation. The Select Client/Server Protocols dialog appears.

  1. Choose the protocol of choice. In our example, choose TCP/IP.

The SNA Client Mode dialog appears.

  1. Choose Local domain if the target SNA Server is located in the same SNA domain as the client. Choose remote domain if the SNA Server is located in a different SNA domain from the target SNA Server. Choose Continue to complete setup of the SNA Server Client.

Finding Additional Information

The Microsoft SNA Server Installation Guide and SNA Server 2.11 Enhancements Guide give detailed information on the installation procedure.

Document Contents


Operate the DEMO SDLC Link Service

3270 Continuous Demo

To run the 3270 Continuous Demo

graphic

  1. Start SNA Server Admin by double-clicking the SNA Server Admin icon in the Microsoft SNA Server group window.
  2. Start the server by selecting it in the Servers and Connections window and selecting Start Services from the Service menu.
  3. Start the 3270 Applet by double-clicking the SNA Server 3270 Applet icon in the Microsoft SNA Server group window.
  4. From the Session menu, choose Session Configuration.

graphic

Choose the "FLASH" session, which we associated with the 3270 continuous demo script file.

  1. From the Session menu, choose Connect.

graphic

The host SSCP screen appears.

  1. Type "VM" and press the ENTER key.

The host logon screen appears.

  1. Type your user ID and password and press the ENTER key.

The host logon sequence completes and the ready prompt appears:

graphic

  1. Enter the host application name. In our example, type "VM", then press the ENTER key.

The VM logon screen appears.

  1. Type the USERID and PASSWORD. In our example, type "USER", press the TAB key, then type "PASS", followed by an ENTER key.

A VM Ready prompt is displayed.

  1. Type "FLASH" and hit the ENTER key to begin the 3270 looping demo.

Successive screens flash non-interactively.

  1. From the Session menu of the 3270 Applet window, choose Disconnect.

The 3270 applet disconnects from the host.

3270 Logon Demo

To run the 3270 Logon Demo

  1. Start SNA Server Admin by double-clicking the SNA Server Admin icon in the Microsoft SNA Server group window.
  2. Start the server by selecting it in the Servers and Connections window and selecting Start Services from the Service menu.
  3. Start the 3270 Applet by double-clicking the SNA Server 3270 Applet icon in the Microsoft SNA Server group window.
  4. From the Session menu, choose Session Configuration.

Choose the "LOGON" session, which we associated with the 3270 continuous demo script file.

  1. From the Session menu, choose Connect.

The host LOGON screen appears.

  1. Type a USERID and PASSWORD. In our example, type "USER", hit the TAB key, then type "PASS", followed by an ENTER key.

A password prompt is displayed on a VM system screen.

  1. Type "PASS" to re-enter your password and press the ENTER key.

A VM READY prompt is displayed.

  1. Type "LOGOFF" to exit VM.

A blank host system screen is displayed.

  1. From the Session menu of the 3270 Applet window, choose Disconnect.

The 3270 applet disconnects from the host.

AS/400 Demo

To run the 5250 Continuous Demo

graphic

  1. Start SNA Server Admin by double-clicking the SNA Server Admin icon in the Microsoft SNA Server group window.
  2. Start the server by selecting it in the Servers and Connections window and selecting Start Services from the Service menu.
  3. Start the 5250 Applet by double-clicking the SNA Server 5250 Applet icon in the Microsoft SNA Server group window.
  4. From the Session menu, choose Connect.

The Sign-On dialog box with the user ID/password selection appears:

graphic

  1. Type the USERID and PASSWORD. In our example, type "USER", press the TAB key, then type "PASS", followed by an ENTER key.

The AS/400 logon screen appears. If the logon screen does not appear:

graphic

  1. Type the USERID and PASSWORD. In our example, type "USER", press the TAB key, then type "PASS", followed by an ENTER key.

The AS/400 Main Menu appears.

graphic

  1. Type one of the following numbers and press the ENTER key to run the available demonstrations:

10 -- 5250 Loop Demo

This will start a demonstration of 5250 flash. The 5250 Applet will cycle between the User Tasks and Display Messages screens indefinitely. (This is similar to 3270 Flash.)

Press the ESC key to stop this emulation and return to the AS/400 Main Menu.

20 -- SQL Query Demo

This will start a demonstration of running a SQL Query on an AS/400 database.

Press the ENTER key after each screen of information to step through the demonstration and return to the AS/400 Main Menu.

90 -- Sign Off

This will return you to the AS/400 Sign On screen. Entering any other number or characters other than those listed above will have no effect on the demonstration.

  1. To stop the demos at any point, choose Disconnect from the Session menu of the 5250 Applet.

The 5250 applet disconnects from the host.

Finding Additional Information

The Microsoft SNA Server 2.11 Enhancements Guide gives detailed information on the installation and configuration procedures.

Document Contents


Setup and Configure ODBC/DRDA

SNA Server version 2.11 includes the StarSQL ODBC/DRDA drivers for Windows and Windows NT clients. With these drivers, applications designed to use the ODBC interface and Structured Query Language (SQL) can access databases located on IBM hosts that use the DRDA protocol to manage distributed data, without requiring a host-based database gateway. These drivers allow ODBC-enabled applications (such as Microsoft® Excel and Microsoft® Access) to query, create, delete, and update tables in the following host databases:

The drivers are installed as an integral part of the SNA Server client software for Windows. Windows NT clients have the option of installing the software. SNA Server's Client Setup program will install an updated ODBC Administrator program to ensure that the latest ODBC 2.10 drivers exist on the local PC.

Step 1: Run the ODBC Administrator Program

To add and set up a new data source

In order to access a host-based database, the user must specify the host database as an ODBC data source by using the ODBC Administrator installed by the SNA Server Client Setup program. Typically, an ODBC-enabled application provides a method for accessing the ODBC Administrator, which is also available as a Program Manager program item or Control Panel option, depending on the operating system and the ODBC driver(s) that have been installed.

  1. Start ODBC Administrator.

The Data Sources dialog box appears:

graphic

  1. To add a new data source, choose the Add button.

The Add Data Source dialog box appears:

graphic

  1. Select StarSQL and choose the OK button.

The StarSQL Data Source Setup dialog box appears.

graphic

To set up the data source, perform the following procedure.

To configure an existing data source

  1. Start ODBC Administrator.

The Data Sources dialog box (shown in figure X.1) appears.

  1. Select the data source you want to configure, then choose the Setup button.

The StarSQL Data Source Setup dialog box (shown in figure X.2) appears.

  1. Supply the following information in the StarSQL Data Source Setup box:
    • Name. Type a name for the data source. Your application uses this name to find the appropriate driver for the data connection. The name can contain up to 32 characters. In our example, type "DEMO".
    • Description. Type a description for the data source. In our example, type "AS400". In our example, you can leave this field blank.
    • Database Server Name. Type the name of the relational database (RDB). In our example, type "REMOTE".
    • SQL Catalog Qualifier. Type the name of the SQL catalog qualifier. If you do not enter a value, the ODBC/DRDA driver uses a default value, depending on the type of host database. For a DB2/400 database, the default value is your user ID. For a DB2 database, the default value is SYSIBM. In our example, you can leave this field as "DEFAULT".
    • SQL Package Collection. Type the name of the SQL package collection. If you do not enter a value, the ODBC/DRDA driver uses your user ID. In our example, you can leave this field as "DEFAULT".
    • Read-Only. Choose this check box if you do not want to change information in the database.

If you are adding a new data source, you must set up the connection. If you are configuring an existing data source, you can change the connection setup. In our example, you can leave this check box unmarked.

To set up an ODBC/DRDA driver connection

  1. In the StarSQL Data Source Setup dialog box (shown in Figure X.2), choose the Setup button.

The StarSQL Connection Setup dialog box appears.

graphic

  1. In the Local LU box, enter the name of a local LU. The name must identify an existing local LU. In our example, type "LOCAL".
  2. In the Remote LU box, enter the name of a remote LU. The name must identify an existing LU. In our example, type "REMOTE".
  3. In the Mode Name box, enter a valid mode name. The default mode name is QPCSUPP. In our example, choose the default.
  4. To close the StarSQL Data Source Setup dialog box and accept changes, choose the OK button.

Step 2: Connecting to a Host Database

The actual method you use to select a data source and initiate a connection to a database on an IBM host depends on the application you are using. For example, to select a data source using Microsoft Query (provided with such applications as Microsoft Access and Microsoft Excel), choose the New Query or Open Query command from the File menu.

Demo ODBC/DRDA Driver Using Excel

When you select a StarSQL data source, the StarSQL connection dialog box may appear, depending on host security.

graphic

To connect to the data source, enter your user ID and password. To change settings for the data source, choose the Options button. When you are finished entering the information, choose the Connect button to establish the connection, or choose the Cancel button if you do not want to connect to the host database.

Supported Applications and Programming Environments

SNA Server ODBC/DRDA drivers support virtually all ODBC-enabled applications and programming environments. Examples of these include:

In addition to these, many other applications support the ODBC programming interface and so can access host-based databases through the ODBC/DRDA drivers.

About the ODBC API

ODBC is a call-level interface for applications that accesses multiple databases by using a single set of function calls, providing a standard database access through a common client-side interface.

Applications interact with the ODBC Driver Manager, which is a Windows Dynamic-Link Library (DLL). The Driver Manager (ODBC.DLL) interprets the application calls to the database using the ODBC/DRDA driver included with SNA Server client software. The Driver Manager loads and unloads the driver, performs status checking, and manages multiple connections between applications and data sources. The ODBC/DRDA driver manages the data source and processes the ODBC calls and SQL statements. The driver interprets the calls and issues the appropriate DRDA commands.

ODBC supports transaction commit and rollback, asynchronous processing, canceled queries, primary and foreign keys, and four levels of transaction isolation.

The ODBC/DRDA driver also supports the ability to pass SQL strings to the remote database without translation or modification. You can use native SQL features specific to the IBM databases you access as well as the ODBC extensions.

Finding Additional Information

The Microsoft SNA Server 2.11 Enhancements Guide, gives detailed information on the installation and configuration procedures.

Document Contents


Operate the ODBC/DRDA Demo

The DEMO SDLC Link Service contains an AS/400 Demo script file. In addition to terminal emulation capabilities, this script file also provides the ability to demonstrate the basic capabilities of the ODBC/DRDA driver.

Using Microsoft Excel to Demo ODBC/DRDA

Before you can demonstrate the ODBC/DRDA driver with Microsoft Excel, you must setup Excel using the Complete/Custom option in order to install Microsoft Query. To demonstrate the 32-bit ODBC/DRDA driver, you must install Microsoft Excel for Windows NT.

To run the ODBC/DRDA Demo

To demonstrate a SQL query by using the ODBC/DRDA driver and the DEMO SDLC Link Service, follow this procedure:

  1. Ensure that the AS/400 Demo Link Service is active. In our example, check for an "Active" status of the SDLC3 link service.
  2. Add and set up a StarSQL data source as described above.
  3. Start Microsoft Excel.
  4. From the Data menu in Excel, choose Get External Data.

Microsoft Query starts and the Select Data Source dialog box appears:

graphic

  1. If the data source you created in step 2 is listed in the list box. ("Demo - SNA"), select it, then choose OK and proceed to step 6.
    • Otherwise, choose the Other button.

The ODBC Data Sources dialog box appears.

The StarSQL connection dialog box appears:

graphic

  1. The StarSQL connection dialog box appears. Type any name in the User ID field and choose Connect. The Add Tables dialog box appears. In our example, leave "SNA" as the USERID and type "PASS" for the password, pressing CONNECT to continue.

The Add Tables dialog box appears:

graphic

  1. Select a table, then press the ADD button to include them in your query. In our example, choose the "AUTHORS" table only.
  2. Press the CLOSE button to continue.

You are returned to the Microsoft Query window.

  1. Select one or more column names in the Authors table list box and then drag the selection to the empty pane at the bottom of the Microsoft Query window.

The pane fills with the selected data.

  1. From the File menu, choose Return Data To Microsoft Excel.

Query exits and Excel displays the Get External Data dialog box.

  1. Choose OK to close the dialog box. Microsoft Excel adds the data to the current worksheet.

Finding Additional Information

The Microsoft SNA Server 2.11 README.WRI file, gives detailed information on the demo instructions.

Document Contents


Using SNA Server Diagnostic Tools

SNA Server Admin

When a service appears to be having difficulty, it may be helpful to gather status information before making the decision about starting, stopping, resetting, or modifying the service.

To view the status of the SNA Server

  1. In the Servers And Connections menu, select the server you want to view.
  2. From the Services menu, choose Properties, or double-click on the highlighted server.
  3. The Server Properties dialog box appears, showing the status of the server and the session.

graphic

  1. When viewing is complete, choose the Cancel button.

To view the status of a connection

  1. In the Servers And Connections window, select the connection you want to view. Under the Status column, the connection will show active, inactive, not configured, or N/A (not available).
  2. From the Services menu, choose Properties. The Connection Properties dialog box appears.
  3. When viewing is complete, choose the Cancel button.

To view the status of an LU (non-APPC)

  1. In the Servers And Connections window, select the connection used by the LU.
  2. Find the LU listed and view the Status column (inactive, in session, and so on).

To view the status of an APPC LU

  1. In the Servers And Connections window, select the local or remote APPC LU you want to view.

Under the Status column, the LU will show active, inactive, not configured, or N/A.

  1. From the Services menu, choose Properties, or double-click on a highlighted LU. The APPC LU Properties dialog box or the APPC Remote LU Properties dialog box appears.
  2. In the APPC LU Properties dialog box, choose the Status button. The APPC LU Status dialog box appears.

graphic

  1. Select the LU-LU pair your are investigating, and then choose the Zoom button. The APPC LU Status dialog box appears and will show status as inactive or will indicate the number of active sessions.
  2. When viewing is complete, choose the Close or Cancel button.

To view the 3270 LUs being used by an active user

  1. From the View menu in the Users And Groups window, choose Active Users.
  2. Select the active user.
  3. View the LUs listed in the LU or LU Pool column.

Windows NT Event Viewer Utility

This is a Windows NT utility that provides information on the sequence and type of events that led up to a particular state or situation. To assist in testing configurations and diagnosing problems, Windows NT keeps event log files, which are stored in WindowsRoot\SYSTEM32\CONFIG\*.EVT.

You may specify parameters for event logs that include the server on which event logs are to be stored, the types of events to be recorded, and any additional servers to which pop-up error messages should be routed.

To specify event types and servers for event logging

  1. Bring up the Windows NT Event Viewer.
  2. From the Options Menu, choose Logs. The Error/Audit Logging And Popups dialog box appears.

graphic

  1. In the Centralized Event Log Server dialog box, type the name of the server on which event logs should be stored (or select the server from the list that appears). To store event logs for this server on this server, select [Local System].
  2. Under the Default Audit Log Level select:
    • Detailed Problem Analysis: This log level records all events that can be recorded.
    • General Information Messages: This log level records general activity, but not all possible events.
    • Significant System Events: This log level records major system events.
    • Audit Logging Disabled: This option turns off all audit logging.
  3. In the Route All Server Popup Messages To box, type or select the additional server(s) to which pop-up error messages will be sent.
  4. When all settings are correct, choose the OK button.

To view the SNA Server Event Logs

  1. Start the Windows NT Event Viewer.
  2. From the Log Menu, choose Application.
  3. Under the Source heading, the SNA events are events whose names begin with SNA.
  4. Select an event, and from the View menu, choose Detail. Or double-click on the highlighted event to view additional information on an event.

graphic

SNA Server Trace

SNA Server Trace (SNATRACE) turns on tracing for SNA Server and Windows NT-based clients. For other clients, tracing is turned on with special commands or with lines in an initialization file. Trace files record activity between or within components of the SNA Server. The files provide detailed information about the exact sequence of events occurring within an SNA server or between an SNA server and another system on the network The trace files containing diagnostic information are located at SNAroot\TRACES\*.TRC

First, decide which software components you need information about to determine what type of trace you will need to run.

To set trace options

You can enable or disable trace options on an SNA server or a Windows NT-based client.

  1. Switch to command prompt.
  2. At the command prompt, type: "SNATRACE".

The SNA Server Trace Options dialog box appears:

graphic

  1. In the Service Name box, select a service name from the list.
  2. Under SnaBase Internal Tracing, drag the scroll box to the level of internal tracing you want for the selected service.
  3. To disable message tracing, choose the Clear button.

If the selected service is SNA Applications, select options for API tracing:

For the selected service, select options for message tracing:

To disable message tracing, choose the Clear button.

  1. Select or clear the Minimize Disk Access By Buffering Writes check box:

To minimize the writing of trace information to disk and cause the information to be held in a memory buffer until it is efficient to write it to disk, select this box.

To cause trace information to be written to disk, clear this box.

  1. Repeat steps 3-6 for each service you want to trace.
  2. Choose the OK button.

Windows NT Performance Monitor Utility

The Performance Monitor is a graphical tool that allows you to measure the performance of computers in the network. The Performance Monitor oversees SNA objects as configured by the user. You can select counters that you want to measure. It is important to note that before any SNA Server counters can be measured, one or more SNA servers must be operating.

To configure 3270 RTM Settings

The Response Time Monitor (RTM) is an IBM function that measures the length of time host responses take during a 3270 session. The SNA Server Administration Tool allows you to specify the times at which RTM should send data and define the triggers that will cause RTM to register that the host has responded. Note that the emulator that your 3270 users have must support RTM for these settings to be meaningful.

  1. From the Options menu, choose RTM Triggers. The 3270 RTM dialog box appears.

graphic

  1. Specify the following:

RTM Data Sent at. Select one or both options.

RTM Timers Run Until. Select the point on which the host is to register response.

RTM Thresholds Specify the cutoff times in tenths of a second at which RTM saves its count response and restarts count.

  1. Accept the settings by choosing the OK button.

To View 3270 RTM Settings

  1. Run the 3270 Applet using the 3270 Logon demo script.
  2. Run Windows NT Server's or Windows NT Workstation's Performance Monitor application. Performance Monitor can be started by clicking the icon found in the Administrative Tools program group, or by executing "PERFMON" at the NT Command Prompt.

The Performance Monitor application appears:

  1. Choose the Edit_Add to Chart menu item from within Performance Monitor.

The Add to Chart dialog box appears:

graphic

  1. Choose the SNA Server computer by name that you want to monitor. In our example, choose PLARSEN.
  2. Choose the Object that you want to monitor. In our example, choose SNA Logical Unit Sessions.

Choose the Instance you want to monitor. In our example, choose "LOGON".

  1. Select the ADD button to continue.

View the response time in Performance Monitor by advancing the 3270 Applet one screen at a time. The response is registered graphically by Performance Monitor.

Finding Additional Information

The Microsoft SNA Server Administration Guide, Microsoft SNA Server Planning Guide, gives detailed information on the diagnostic tools.

Document Contents


Modifying or Removing SNA Servers

When you run the SNA Server Setup program after the initial installation, Setup detects the existing configuration and presents you with a Setup Options dialog box. From Setup Options, you can:

When removing SNA Server device drivers, such as the Demo SDLC Link Service, always use SNA Server Setup. Do not use the Network option of the Windows NT Server Control Panel to remove such drivers as doing so may cause unexpected system events.

  1. From the SNA Server program group, click the SNA Server Setup icon.

graphic

A welcome to SNA Server Setup dialog box appears:

graphic

  1. Choose the Continue button.

The Setup Options dialog box appears:

graphic

To Add, Configure, or Remove a Link Service

You can configure any of the installed link services, or add a link service. If you no longer need a link service, you can remove it.

  1. Under Options in the Setup Options dialog box, shown in Figure, choose the Links button.

The Link Service Configuration dialog box appears.

  1. Choose an appropriate button.

To Change the Server Role

You can change the configuration role for an SNA server. Under Options in the Setup Options dialog box, choose the Role button. The Change SNA Server Role dialog appears. Choose the appropriate new role.

To Change Client/Server Protocol Selections

You can change client/server protocol selections after installing SNA Server.

  1. Under Options in the Setup Options dialog box choose the Protocols button.

The Select Client/Server Protocols dialog appears.

  1. When the Setup Options dialog box reappears, choose the Continue button, and then exit from SNA Server Setup.

Removing SNA Server

You can remove SNA Server at any time. However, removing SNA Server deletes all of the SNA Server files and directories from your computer, including link service files. To use SNA Server again, you must run Setup to reinstall the files from the beginning.

To remove SNA Server from an entire domain, do the following in the order given:

  1. Stop all the SNA Server components on the network, including all Host Links and active clients.
  2. Choose the Remote button.

The Confirm Removal dialog box appears:

graphic

  1. Choose the Continue button.

SNA Server Setup removes SNA Server and unbinds the Link Services from the Networks portion of the Windows NT Server Control Panel.

Finding Additional Information

The Microsoft SNA Server Installation Guide, Microsoft SNA Server Planning Guide, gives detailed information on the modifying or removing SNA Servers.

Document Contents


Modifying or Removing SNA Clients

Client Option Modification

Once a client is installed, you may want to change the options selected during Setup, such as changing the server operation from local to remote. When Setup is run, it determines whether a version of the SNA Server is already installed. If so, Setup assumes that you want to modify or remove the client software.

To modify a client running Windows NT or Windows 3.x

  1. Invoke the Setup utility (as you did during installation).
  2. When the SNA Server Setup dialog box appears, choose Continue.

The Setup Options dialog box appears.

  1. Choose Reinstall. Setup will present the same dialog boxes as those used to install the SNA Server client.
  2. Complete the dialog boxes with the chosen modifications to the client configuration.

The Setup Complete dialog box appears.

  1. Choose OK.
  2. Restart your computer to put the changes into effect.

Removing Clients

Once a client is installed, you may want to remove it.

To remove a client running Windows NT or Windows 3.x

  1. Invoke the Setup utility (as you did during installation).

The Setup Options dialog appears:

graphic

  1. Choose the Remove button.

The Confirm Removal dialog appears:

graphic

  1. Choose Continue to complete removal of the SNA Server Client.

Finding Additional Information

The Microsoft SNA Server Installation Guide, Microsoft SNA Server Planning Guide on your TechNet CD, gives detailed information on the modifying or removing SNA Server Clients.

Document Contents


search icon Click Here to Search TechNet Web Contents TechNet CD Overview TechNet logo Microsoft TechNet Credit Card Order Form
At this time we can only support electronic orders in the US and Canada. International ordering information.


TechNet logo Go To TechNet Home Page ©1996 Microsoft Corporation Microsoft homepage Go To Microsoft Home Page