DB2 Mainframe and midrange server access

 

+
Search Tips   |   Advanced Search

Scenarios

• Direct access to mainframe and midrange servers
• Direct access to mainframe and midrange servers with DB2 Connect Personal Edition
• DB2 Connect Enterprise Edition as a connectivity server
• DB2 Connect and Web applications
• DB2 Connect and IBM WebSphere
• DB2 Connect as a Java application server
• DB2 Connect on the Web server
• DB2 Connect and application servers
• DB2 Connect and transaction processing monitors

Overview

• Administering DB2 Connect systems

  • DB2 Connect overview
  • Functions delivered in Version 9 and previous releases
  • Host databases
  • DB2 Connect and SQL statements
  • DB2 Connect administration utilities
  • WebSphere Federation Server and DB2 Connect

Migrating to DB2 Connect Version 9.5

• Migration essentials for DB2 Connect
• Pre-migration tasks
• Migrating DB2 Connect servers
• Post-migration tasks

Installing

• DB2 Setup Wizard national language support

  • Displaying the db2setup command in your national language
  • Language identifiers for running the DB2 Setup wizard in another language
  • Changing the DB2 product interface language (Windows)
  • Changing the DB2 product interface language (Linux and UNIX)
  • Conversion of character data

  Prerequisites

  • Disk and memory requirements
  • IBM Software Development Kit for Java levels for DB2 products

  Additional Linux and UNIX requirements

  • Preparing to install DB2 for Linux on zSeries

  Kernel parameters (Linux and UNIX)

  • Modifying kernel parameters (HP-UX)
  • Recommended kernel configuration parameters (HP-UX)
  • Modifying kernel parameters (Linux)
  • Modifying kernel parameters (Solaris Operating System)

• DB2 Connect Enterprise Edition

  • AIX

    • Installation requirements
    • Mounting CD-ROMs

  • HP-UX

    • Installation requirements
    • Mounting CD-ROMs

  • Linux

    • Installation requirements
    • Mounting CD-ROMs

  • Solaris

    • Installation requirements
    • Mounting CD-ROMs

  • Windows

    • Installation requirements
    • Required user accounts for installation of DB2 server products (Windows)
    • LDAP: Extending the directory schema
    • Installing without Administrator authority

• Typical steps for installing DB2 Connect Personal Edition

  • Installing DB2 Connect Personal Edition (Linux)

    • Installation requirements
    • Mounting CD-ROMs

  • Installing DB2 Connect Personal Edition (Solaris)

    • Installation requirements
    • Mounting CD-ROMs

  • Installing DB2 Connect Personal Edition (Windows)

    • Installation requirements
    • Required user accounts for installation of DB2 Connect Personal Edition
    • LDAP: Extending the directory schema
    • Installing without Administrator authority

  Maintaining license keys

  Using the License Center

  • Registering DB2 Connect license keys
  • Setting the license type

  Using the db2licm command

  • Registering DB2 Connect license keys
  • Setting the license type
  • Server requirements for client connections

  Post-installation tasks

  • Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows)
  • Applying fix packs

  Uninstalling

  • DB2 Connect (Windows)
  • DB2 Connect (Linux and UNIX)

Configuring

Adding database connections using the Configuration Assistant

• Configuring a database connection by searching the network
• Configuring a database connection manually
• Testing database connections
• Preparing DB2 for i5/OS and DB2 Universal Database for iSeries for connections from DB2 Connect

• DB2 Universal Database for OS/390 and z/OS

  • Host databases
  • Configuring TCP/IP
  • Configuring DB2 Universal Database for OS/390 and z/OS
  • DB2 for VSE & VM

• DB2 Connect Sysplex support

  • Considerations for Sysplex exploitation
  • DB2 Sysplex exploitation
  • Configuration requirements

  Configuring connections to mainframe and midrange servers

  • With the Configuration Assistant (CA)
  • With the command line processor (CLP)

  Cataloging mainframe and midrange servers

  • Managing connections
  • Removing a DCS (host database)
  • Setting the license type using the db2licm command
  • Setting the license type using the License Center

Administering

• Binding applications and utilities (DB2 Connect)
• Moving data with DB2 Connect
• Automatic client reroute description and setup (DB2 Connect)
• Distributor technologies

Administering DB2 Connect systems

Overview

• Access DB2 data from remote clients
• Accessing DB2 data from the web using Java
• Accessing host or System i DB2 data using DB2 Connect EE
• Direct access to mainframe and midrange servers with DB2 Connect Personal Edition
• Binding database utilities on DB2 Connect
• Considerations for Sysplex exploitation
• Conversion of character data
• Support for database application development
• Host and System i support for DB2 Connect
• Understanding the DB2 administration server
• Administering local and remote instances and databases with the DB2 administration tools (available on Linux and Windows)
• Managing communications and viewing SQL access plans

• DB2 UDB for z/OS health monitor overview

  • Starting, stopping and refreshing the DB2 UDB for z/OS health monitor
  • Viewing, submitting, and saving recommended actions
  • Viewing health alert summaries
  • Viewing health alert objects

• Distributed Relational Database Architecture (DRDA)

  • DRDA and data access
  • DB2 Connect and DRDA
  • Remote unit of work
  • Distributed requests

• Updating database directories

  • System database directory values
  • Node directory values
  • DCS directory values
  • Directory customization worksheet
  • Defining multiple entries for the same database
  • Handling BiDi data
  • DB2 Connect and SQL statements

• Multisite updates

  • Enabling Multisite Updates using the Control Center
  • Testing Multisite Update using the Control Center
  • Multisite update and sync point manager
  • Configuring DB2 Connect with an XA compliant transaction manager
  • DB2 Connect support for loosely coupled transactions

• SQLCODE mapping

  • Turning off SQLCODE mapping
  • Tailoring the SQLCODE mapping

Monitoring

• Monitoring connections for remote clients
• Monitoring performance using the Windows performance monitor
• Using the GET SNAPSHOT commands
• DCS application status

Developing database applications

• Running your own applications

Security

• Trusted connections through DB2 Connect

  • Creating a trusted connection through CLI
  • Switching users on a trusted connection through CLI

• DB2 Connect authentication considerations

  • Kerberos support
  • Hints and tips about z/OS and OS/390 security
  • Security types supported with DB2 Connect

Tuning

• DB2 Connect performance
• Optimizing ODBC access
• Application design

Connection management

• Connection pooling
• Connection concentrator
• Connection pooling and connection concentrator
• Connection concentrator required with WebSphere MQ Transaction Manager and DB2 for OS/390

DB2 Connect tuning

• Host database tuning
• Network tuning considerations
• System resources contention
• DB2 Connect performance troubleshooting
• Tuning DB2 for OS/390 and z/OS
• Increasing DB2 Connect data transfer rates
• Extra query block
• RFC-1323 Window scaling
• High availability and load balancing for mainframe and midrange server connectivity
• Host data conversion
• Data types for character data
• Network hardware
• CLI/ODBC application performance tuning

Troubleshooting

• Troubleshooting DB2 Connect

  • Gathering relevant information
  • Initial connection is not successful
  • Problems encountered after an initial connection
  • Collecting data

  DB2 traces

  • Obtaining a DB2 trace using db2trc
  • Dumping a DB2 trace file
  • Formating a DB2 trace file

• DRDA traces

  • Obtaining a DRDA trace using db2drdat
  • DRDA trace output
  • DRDA trace output file analysis
  • DRDA trace output file samples
  • Subsequent buffer information for DRDA

  Messages

  • DB2 Connect interpretations