Home

	Expand Search

Installation and Reference Guide ClearConnect 1.3

About This Book

About This Book

This book explains how to install and configure client applications and server databases that use the ClearConnect product.

Throughout this document, the ClearConnect client software is referred to generically as "ClearConnect" or "ODBC Client."

This section includes the following topics:

• Who Should Read This Book
• How to Use This Book
• Synonymous Terms Used in This Guide
• Related Documents
• Style Conventions
• How to Get Help Using Sybase Products
• If You Have Questions About this Book

Who Should Read This Book

The guidelines and instructions in this guide are intended primarily for system administrators and system programmers who coordinate the installation and use of the ClearConnect software product set. In addition, the following people may be involved during various stages of setup and implementation:

• ODBC and SQL applications programmers who use the ClearConnect software to develop custom or generic applications.
• Windows systems administrators who perform the following tasks:
  • Install client machines
  • Provide SNA LU 6.2 communications support for the ClearConnect product
• VTAM/NCP systems programmers who perform the following tasks:
  • Configure the node definitions
  • Define DRDA access from ClearConnect to MVS DB2/DDF
• MVS DB2 database administrators and Communications Database (CDB) administrators who perform the following tasks:
  • Assign the appropriate database privileges
  • Configure the MVS DB2 Communications Database component

This book assumes that you have a working knowledge of system administration for your environment.

We recommend that you be familiar with the IBM DB2 SQL Reference or the X/Open SQL specification so you can understand the definition of a database and the intended result of executing SQL statements.

Because ClearConnect integrates these complex systems, we recommend a coordinated approach to setup and installation that involves all of the people mentioned in the preceding paragraphs.

How to Use This Book

This guide describes a set of tasks, with each chapter representing a task. The following table shows how this book is organized.

See	When You Are Ready To
Chapter 1 Understanding Enterprise Connect	Understand Enterprise Connect products
Chapter 2 Introducing ClearConnect	Understand what ClearConnect is and what it does Review features and functions of ClearConnect
Chapter 3 Installation Guidelines and Quick Start Steps	Fill out the Installation Worksheet Review the Quick Start Steps
Chapter 4 Setting Up the DB2 Server	Prepare for installation by configuring the following: - Mainframe DB2 DRDA server - AS/400-based DB2/400 DRDA server - DB2 "common server" DRDA server
Chapter 5 Configuring the Server Network	Prepare for installation by configuring the following: - TCP/IP network - SNA network - SNA on Windows NT and mainframe components - SNA mode name (on mainframe components)
Chapter 6 Installing and Configuring ClearConnect on the Client	Install ClearConnect on Windows clients Configure ClearConnect on the client Test connections Create, or bind, packages on the target server
Chapter 7 Troubleshooting	Use troubleshooting techniques for debugging problems that occur when installing or operating ClearConnect Diagnose common problems and review diagnostic tools
Appendix A ODBC Commands and Datatype Conversion	Review the Version 2.0 ODBC commands that ClearConnect supports Review ODBC datatype conversions that ClearConnect supports

Synonymous Terms Used in This Guide

In this guide, the following terms are used interchangeably:

• ClearConnect, ODBC Client
• Transaction name, TP Name, transaction program name, TPN
• User ID, user authid
• Bind package, create package command
• InfoHub, Platinum InfoHub

Related Documents

The following documents contain related information that you can use with this guide.

DRDA Publications

For information about DRDA connectivity, refer to the following documents:

• Distributed Relational Database (DRDA) Connectivity Guide
  (SC26-4783)
• IBM Database 2 Version 4 Installation Guide (SC26-3456)
• IBM Database 2 Version 3 Administration Guide (SC26-4374)
• IBM Database 2 Version 3 Command and Utility Reference
  (SC264-3478)
• IBM Database 2 Version 3 or 4 Application Programming and
  SQL Guide (SC26-4377)
• IBM Database 2 SQL Reference (SC26-4380)
• IBM DB2 Command Reference for Common Server (S20H-4645)

ODBC Publications

For information about ODBC, refer to the Microsoft, 1994, Microsoft ODBC 2.0 Programmer's Reference and SDK Guide, Version 2.0
(IBSN:1-55615-658-8).

X/Open Publications

For information about X/Open, refer to the following documents:

• X/Open CAE Specification, March 1995, Data Management:
  SQL Call Level Interface (CLI) (ISBN: 1-85912-081-4, C451)
• X/Open CAE Specification, March 1995, Data Management:
  SQL Call Level Interface (CLI) (ISBN: 1-85912-081-4, C451)

ITSC Redbooks Publications

For information about ITSC Redbooks, refer to the following documents:

• DB2 Distribution Database Application Implementation and Installation Primer (GG24-3400)
• Distributed Relational Database Cross Platform Connectivity and Application (SG24-4311)
• DB2-APPC/VTAM Distributed Database Usage Guide (GG24-3300)
• Distributed Relational Database Application Scenarios (GG24-3515)
• Distributed Relational Database Remote Unit of Work Implementation DB2-DB2 and DB2-SQL/DS, Volumes I and II (GG24-3715 and GG24-3716)
• Distributed Relational Database Planning and Design Guide for DB2 Users (GG24-3755)
• Client/Server Computing Application Design: a DRDA Perspective (GG24-3727)

VTAM V3/V4 Library

For information about VTAM versions 3 and 4, refer to the following documents:

• VTAM Resource Definition Reference (SC31-6438)
• Planning and Reference for NetView, NCP and VTAM (SC31-6124)
• Network Implementation Guide (SC31-6434)

Style Conventions

This book uses the following style conventions:

This type of information	Looks like this
Gateway-Library function names	TDINIT, TDCANCEL
Client-Library function names	CTBINIT, CTBCANCEL
Other executables (DB-Library routines, SQL commands) in text	the dbrpcparam routine, a select statement
Directory names, path names, and file names	/usr/bin directory, interfaces file
Variables	n bytes
SQL Server datatypes	datetime, float
Sample code	01 BUFFER PIC S9(9) COMP SYNC
User input	01 BUFFER PIC X(n)
Client-Library and Gateway-Library function argument names	BUFFER, RETCODE
Names of objects stored on the mainframe	SYCTSAA5
Symbolic values used with function arguments, properties, and structure fields	CS-UNUSED, FMT-NAME, CS-SV-FATAL
Client-Library property names	CS-PASSWORD, CS-USERNAME
Client-Library and Gateway-Library datatypes	CS-CHAR, TDSCHAR

All other names and terms are in regular typeface.

How to Get Help Using Sybase Products

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.

If you need help using a Sybase product, the following resources are available:

• Sybase Technical Support
• Sybase Professional Services
• Other sources of information

Sybase Technical Support

Sybase Technical Support provides various forms of assistance to customers who pay the applicable support fees, as defined the Software License Agreement. Assistance includes the following services:

• Identifying problems
• Offering a fix, if available
• Documenting software problems and enhancement suggestions in the Sybase customer support database
• Sharing information on new products or releases of existing products

In addition Sybase system engineers are available for technical assistance in various geographical territories.

The following subsections explain how to contact Sybase Technical Support and how to send log and trace files, if necessary.

Contacting Sybase Technical Support

You can contact Sybase Technical Support by phone or through
e-mail. Before you contact Sybase Technical Support, complete these steps:

1. Thoroughly review the documentation, especially all troubleshooting sections.

2. Be prepared to generate a trace, if Sybase Technical Support asks you to do so.

Contacting by Phone

You can reach Sybase Technical Support by calling (800) 8SYBASE.

Hours are 5:00 AM to 6:30 PM, Monday through Friday, Mountain Standard or Daylight Savings Time (MST or MDT), except holidays.

Note: Outside the continental United States and Canada, obtain the correct telephone numbers from your sales representative and record them here for future reference:______________________________.

Contacting by E-Mail

Send an e-mail to Sybase Technical Support in the following circumstances:

• If you have a general question that is not urgent, for instance, a question about configuration planning.
• If you need help with a product outside of the working hours of Sybase Technical Support, you can send an e-mail to be received as soon as personnel become available.

Use this address to send e-mail to Sybase Technical Support:

icdtech@sybase.com

Sending Log and Trace Files to Sybase Technical Support

You can send log and trace files or other documents to Sybase Technical Support using the Sybase file transfer protocol (ftp) or the Bulletin Board Service (BBS).

Note: For instructions on how to create a trace, see "Using the Trace Option", and "Trace Settings".

Using File Transfer Protocol (ftp)

To place trace output or other documents on the Sybase ftp server:

1. Save your trace output as an ASCII file.

2. In the directory where the file resides, type ftp at the command line.

3. When prompted, provide the following information:
   • Sybase server = ftp.sybase.com
   • ID = anonymous
   • Password = your e-mail address
4. Type:

   cd /pub/incoming/wcss

5. To change to binary mode, type:

   bin

6. Place one or more files into the directory.
   • To place one file in the directory, type:

         put filename

   • To place multiple files in the directory, type:

         mput filename filename filename

     When prompted, type Y and press Enter to transfer each file.

7. Notify Sybase Technical Support of the exact name of the file(s) you sent to the server. (Remember that the Unix system is case-sensitive.)

Using the Bulletin Board Service (BBS)

To send log and trace files to Sybase Technical Support or to receive software fixes using the BBS:

1. Call (303) 413-4285.

2. Use parameters 8-1-N and a baud rate of 300-14400.

Sybase Professional Services

Sybase Professional Services offers on-site consulting and training programs to help you maximize the benefits of our products.
For more information, call (303) 486-7700.

Note: Outside the continental United States and Canada, obtain the correct telephone numbers from your sales representative and record them here for future reference:______________________________.

Other Sources of Information

Other sources of information include:

Online documentation

Sybase certifications and Emergency Bug Fixes (EBFs) on the Web

Sybase OpenLine and PrivateLine on CompuServe

Fax-on-Demand

Online Documentation

Use the SyBooks(TM) and SyBooks-on-the-Web online resources to learn more about your product:

Accessing SyBooks

SyBooks documentation is on the CD that comes with your software. The DynaText browser, also included on the CD, allows you to access technical information about your product in an easy-to-use format.

Refer to Installing SyBooks in your documentation package for instructions on installing and starting SyBooks.

Accessing Sybooks-0n-the-Web

SyBooks-on-the-Web is an HTML version of SyBooks that you can access using a standard Web browser.

To use SyBooks-on-the-Web:

1. Go to the following URL:

   http://www.sybase.com

2. Choose Documentation.

Sybase Certifications and EBFs on the Web

Sybase certifications and EBFs are available through the Sybase Technical Information Library.

Accessing Product Certifications

1. Go to the following URL:

   http://techinfo.sybase.com

2. In the Browse section, choose the Hot entry.

3. Choose the topic that interests you.

Accessing EBFs through SupportPlus

1. To access EBFs, you must be a registered SupportPlus user.
   See "Registering as a SupportPlus user" for registration instructions.

2. Go to the following URL:

   http://techinfo.sybase.com

3. In the Browse section, choose the Hot entry.

4. Choose the EBF Rollups entry.

   You can research EBFs using the Technical Information Library, and you can download EBFs using Electronic Software Distribution (ESD).

5. Follow the instructions associated with the SupportPlus^SM Online Services entries.

Registering as a SupportPlus user

To use SupportPlus, you need:

• A Web browser that supports the Secure Sockets Layer (SSL), such as Netscape Navigator 1.2 or later
• An active support license
• A named technical support contact
• Your user ID and password

To register as a SupportPlus user:

1. Go to the Sybase home page at the following URL:

   www.sybase.com

2. Choose Technical Support.

3. Choose Enterprise Technical Support.

4. Choose Register for SupportPlus.

Sybase OpenLine and PrivateLine on CompuServe

Sybase OpenLine and PrivateLine are the Sybase question and answer forums on CompuServe. To access Sybase OpenLine:

1. Connect to CompuServe using the normal procedures for your site.

2. At any menu prompt, type:

   go sybase

Fax-on-Demand

Use Fax-on-Demand to receive Certification Reports, Release Summaries, Sample Programs, Technical News Letters (TNL), and Technical White Papers.

To use Fax-on-Demand:

1. Call (800) 423-8737. Outside the United States and Canada, call (303) 575-6132.

2. Select option 2 and follow the recorded instructions.

If You Have Questions About this Book

If you have any questions, comments, or suggestions about this book, contact the Sybase documentation group directly by electronic mail at:

icd_doc@sybase.com

Feel free to forward any information, comments, or questions about:

• Missing, incorrect, or unclear information
• Information you found particularly useful
• Organization or style

We will respond as promptly as possible by electronic mail. Your feedback helps us provide more accurate, detailed, and easy-to-use documentation.

Note: Please send comments about product features, functionality, or problems to your system engineer or Sybase Technical Support.

To order additional copies of Enterprise Connect documentation, see "Document Orders" on the disclaimer page following the title page.