Working with additional capabilities for DB2

After you complete the installation or migration process, you can work with additional capabilities of DB2® such as stored procedures and remote communication.

  • Installation information for procedures and functions that are supplied with DB2
    DB2 supplies a number of stored procedures and user defined functions that job DSNTIJRT defines and binds during installation or migration.
  • The IBM Data Server Driver for JDBC and SQLJ
    If you plan to run JDBC or SQLJ applications, you need to install the current version of the IBM® Data Server Driver for JDBC and SQLJ. You must complete this task after you install DB2 for z/OS® or migrate to the current version of DB2 for z/OS.
  • Connecting the IMS attachment facility
    Connecting DB2 to IMS™ requires coordination with your company's group that supports IMS systems.
  • Connecting distributed database systems
    You can use the distributed data facility (DDF) of DB2 to access data that is held by other data management systems. You can also use DDF to make your DB2 data accessible to other systems.
  • Connecting systems with VTAM
    Virtual Telecommunications Access Method (VTAM®) is a program that you can use to control remote DB2 communication.
  • Connecting systems with TCP/IP
    Transmission Control Protocol/Internet Protocol (TCP/IP) is a standard communication protocol for network communications. Previous versions of DB2 supported TCP/IP requesters, although additional software and configuration was required.
  • Configuring the DB2 command line processor
    You can use the DB2 command line processor to issue SQL statements, bind DBRMs that are stored in HFS files, and call stored procedures. To use the command line processor, ensure that your system meets the command line processor prerequisites. Then, set up your system to use the command line processor.
  • IBM Text Search for DB2 for z/OS
    IBM Text Search for DB2 for z/OS provides full-text search capability for text columns that are stored in DB2.
  • Creating database objects that support query acceleration
    If you use an accelerator, you must create a database, a table space, tables, and indexes for the accelerator to use.
Parent topic: Installing and migrating DB2