OI feedback
IBM DATABASE 2 (DB2) RELEASE 1 IS ANNOUNCED
o 5740-XYR

Contents


Announcement Letter Number ZP83-0746 dated June 7, 1983
Europe Middle East Africa - Last Revised on June 7, 1983



Brief Description of Announcement, Charges, and Availability

Customer Letter Section


*****************************************************************
*                                                               *
*  IBM PROGRAMMING INFORMATION                      JUNE 1983   *
*                                                               *
*  IBM PROGRAMMING INFORMATION                                  *
*                                 for Europe, the Middle East   *
*  IBM PROGRAMMING INFORMATION               and Africa.        *
*                                                               *
*****************************************************************
*                                                               *
* This document is provided as general customer information     *
* only. IBM products and services which are announced and       *
* available in your country can be ordered under the applicable *
* standard agreements, terms, conditions and prices in effect   *
* at the time. For further information please contact your      *
* local IBM representative.                                     *
*                                                               *
*****************************************************************
=================================================================
IBM DATABASE 2 (DB2) RELEASE 1 IS ANNOUNCED
o 5740-XYR
IBM  Database  2  (DB2)  is IBM's relational Data Base Management
System  Program  Product for the MVS/XA and MVS/370 environments.
It   may  coexist  with  an  complements  information  management
System/Virtual  storage  (IMS/VS)  Version  1 Data Base System in
these environments.
DB2  supports  a  relational  data model.  A DB2 Data Base can be
thought  of  as a collection of tables.  Data is defined in terms
of  tables  and  accessed  through  operations  on  tables.  Data
definition,  retrieval,  manipulation, and control operations are
supported  by the Structured Query Language (SQL).  SQL is a high
level,  nonnavigational  data language available to users through
an  interactive terminal and through application programs written
in COBOL, FORTRAN, PL/I, or Assembler Language.
IBM  Database  2  may be accessed concurrently by the IMS/VS Data
Communication  feature, by CICS/OS/VS, by TSO users, and by batch
jobs.   Figure 1 shows the configurations that are possible using
IMS/VS  Data  Base  system  and/or  DB2  as  Data  Base Managers.
Application  programs  running  under  control of the IMS/VS Data
Communication  feature  or CICS/OS/VS may access DB2 Data, IMS/VS
Data Base Data, or both.
DB2 operates as an MVS subsystem.  DB2 is designed to utilize the
XA  architecture,  including  31-bit virtual addressing and large
real  storage.   DB2's  architecture provides for very large Data
Bases  (up to 64 gigabytes (64,000,000,000 bytes) per table).  It
is  supported by a comprehensive set of Data Base utilities which
operate  online.  Its security and authorization mechanism offers
field  content security and allows various levels of authority to
be delegated to users as appropriate.
-------------      +  ------------    ------------   ------------
| IMS/VS    |         |CICS/OS/VS|    |   TSO    |   |          |
| TERMINAL  |         | TERMINAL |    | TERMINAL |   |   JCL    |
-------------      +  ------------    ------------   ------------
     |                     |               |              |
     |                     |               |              |
-----------------------------------------------------------------
|    |                     |               |              |     |
| --------      +      ----------      ----------      -------- |
|| IMS/VS |           |CICS/OS/VS|    | TSO      |    |  TSO   ||
||   DC   |           |          |    | ONLINE   |    | BATCH  ||
| --------      +     ------------     ----------      -------- |
|    | |                  |  |            |               |     |
|    | |           --------  ---------    |    -----------      |
|    |  ----------)-------------     | +  |    |                |
|    |            |             |    |    |    |                |
|    |            |             |    |    |    |      MVS/XA    |
|  --------   --------       +---------------------   or MVS/370|
| | IMS/VS | | IMS/VS |      |    IBM DATABASE 2   |   OPERATING|
| |   DB   | |   DB   |      |                     |     SYSTEM |
|  --------   --------       +---------------------       +     |
|      |            |                     |                     |
------+------------ --------------------- ----------------------
       |            |                     |
       |            |                     |
        -----------  +------------  +       --------------
       |            | |            |        |              |
       |   IMS/VS   | |   IMS/VS   |        |    IBM       |
       |   DATA     | |   DATA     |        | DATABASE 2   |
       |   BASES    | |   BASES    |        | DATA BASES   |
       |            | |            |        |              |
       |            | |            |        |              |
        ------------ + ------------ +        --------------
Figure 1.  The IBM DATABASE 2 environment
HIGHLIGHTS
IBM DATABASE 2 is an easy-to-install, easy-to-use program product
supporting  the  relational data model with a high level language
to access DB2 data.  DB2 offers many functions in support of both
traditional  data  base  application  areas  and  the Information
Center.   Specific highlights include:
o RELATIONAL  DATA  MODEL:   DB2  provides a basic tabular
  data  structure.  Data is viewed by the user as a series
  of rows and columns.
o STRUCTURED  QUERY LANGUAGE (SQL):  SQL is an easy-to-use
  high-level  language  used  for  data manipulation, data
  definition,  and  control.   It is not dependent on data
  paths,  placement or order when accessing the relational
  data bases.
o CONTINUOUS OPERATIONS: Data definitions may be dynamically
  changed without stopping DB2.  Also, data base utilities can
  be run without stopping DB2.
o CONCURRENT ACCESS TO DATA: DB2 may be accessed concurrently
  by the IMS/VS Data Communication Feature, by CICS/OS/VS, by
  TSO   users  and  by  batch  jobs.   Additionally,  application
programs
  running under control of the IMS/VS Data Communication Feature
  or CICS/OS/VS may access DB2 data, IMS/VS Data Base Data, or
  both.
o APPLICATION PROGRAMMING: Users may access and manipulate
  DB2  data  using  SQL through application programs
  written in COBOL, FORTRAN, PL/I and assembler language.
o DB2 INTERACTIVE (DB2I): DB2I is an interactive facility based
  on Interactive System Productivity Facility (ISPF).  Users may
  access and manipulate DB2 data interactively through DB2I.
  Additionally, other operations such as the DB2 data base
  utilities may be invoked through DB2I.
o BASE  FOR QUERY MANAGEMENT FACILITY (QMF):  QMF operates
  with  DB2  data  in the MVS/XA and MVS/370 environments.
  See  the  QMF  Announcement  Letter  for details on this
  product.
o LARGE  PROCESSOR  SUPPORT:   DB2 operates in the MVS/XA
  and  MVS/370 environments, thus providing support for the
  full  range  of  processors supported by those operating
  systems.
PRODUCT DESCRIPTION
RELATIONAL DATA MODEL
DB2's    relational    data    model    is    easy-to-learn   and
easy-to-use.
o SIMPLE DATA STRUCTURE -- The basic data structures in DB2 are
  tables.   A DB2 data base may contain many tables; the simple
  tabular data format protects the user from having to know and
  cope with more complicated representations of the data in
  storage.  All relationships are represented by data in
  tables so users do not have to 'navigate' through data
  structures.  The user may experience an increase in
  productivity, because there is no need to concentrate on
  how the data is to be accessed, but only on what data is to
  be accessed.
o STRUCTURED  QUERY  LANGUAGE (SQL) -- SQL is a high level
  non-navigational  language.   SQL  statements  reference
  data  by name and/or value and not by data access paths,

  data placement, or order.
  SQL, in a single statement, can access:
  - One or more columns from a row of a table
  - One  or  more columns from multiple rows of a single
    table.
  - One  or  more columns from multiple rows of multiple
    tables.
  - One or more columns calculated from other columns
SQL  can  be  used  for retrieval, insertion, deletion, updating,
data definition, commitment of changes, and granting and revoking
of DB2 authorization.  SQL is consistent; it provides essentially
the same features and syntax whether it is used as an interactive
language  or  invoked  from  a COBOL, FORTRAN, PL/I, or assembler
program.
o HIGH  PRODUCTIVITY--  Both  the  data structures and the
  data language are simple.  As a result:
  - The  amount  of data processing knowledge, training,
    and  experience  required  to become productive with
    DB2 is minimal.
  - Data  base  administrators  can  design, define, and
    modify data bases quickly.
  - Application   programmers   can   develop   programs
    quickly, and hence can be highly productive.
  - Using  SQL  interactively, some users may create and
    maintain  their  own  data bases without traditional
    application programming or data administration.
  Therefore,  the application program backlog in many data
  base installations can be reduced.
o CONTINUOUS  OPERATION-- DB2 can operate for long periods
  without  interruption.   Many of the activities that may
  require  other systems to stop running do not stop DB2's
  operation.
  - DB2 is a separate MVS subsystem and can be available
    even when IMS/VS, CICS/OS/VS, or TSO is unavailable.
  - Data  definitions  may be added, deleted, or changed
    interactively without stopping DB2.
  - DB2  utilities  can  perform their functions without
    stopping  activity  on  other  data  bases.  In some
    cases,  concurrent activity on the same data base is
    permitted.
  These capabilities allow user data bases to evolve with-
  out  disrupting  ongoing  processes and tables that have
  already been established.
o NEW  DATA  BASE APPLICATIONS AND USERS -- In addition to
  DB2  use  in  the  traditional  application  areas,  its
  ease-of-use  characteristics  will attract many new data
  base users.  DB2 will provide an excellent foundation
  for decision support systems and Information Centers.
  Application areas where DB2 is particularly applicable
  include:
  - Decision support systems.
  - Environments  where  changing requirements make
    preplanning difficult or impossible.
  - Applications  involving exhaustive searches or
    unanticipated queries.
  - Situations where demanding time constraints necessitate
    getting the application 'on-the-air' quickly.
  - Applications  with  modeling  characteristics -- the
    need to answer 'what if' questions.
  - Analysis of data extracted from existing systems.
  - Short-term  data  bases when an extensive design and
    development cycle is not warranted.
  - In combination with QMF, DB2 provides new opportunities for
    non-DP professionals to gain interactive access to data
    through query (SQL and QBE) and reporting capabilities.
ACCESS TO DATA
IBM   DATABASE   2   data   may   be accessed concurrently by the
IMS/VS  Data  Communication  Feature,  by  CICS/OS/VS, and by TSO
users.    TSO   programs   may   be   invoked interactively or by
using   JCL.    Application programs running under the control of
the   IMS/VS  Data Communication Feature or CICS/OS/VS may access
DB2 data, IMS/VS Data Base data, or both.
Users   can   operate  on  DB2  data interactively and/or through
applications  written  in  COBOL,  FORTRAN  (for TSO users only),
PL/I,  and  assembler  language.   In  all cases, they access and
manipulate the data using the SQL language.
DB2  interactive  (DB2I)  is  an  ISPF-based interactive facility
(ISPF  means  Interactive  System  Productivity  Facility  -- see
'Software Requirements').  Using DB2I, an authorized user can:
o Enter  most  SQL  statements and view the results at the
  terminal.
o Enter DB2 commands
o Perform  other programming-related DB2 functions such as
  precompilation.
o Run TSO-based applications
o Invoke the DB2 data base utilities
  For example, using DB2I, application programmers can create and
  edit most SQL statements they plan to include in their
  programs, execute those statements, and receive and review the
  results at their terminals.  They can also create, load, and
  delete test tables.  They can use DB2I to check the contents of
  existing tables.  DB2I is a powerful tool for application
  programmers, data base administrators, and system
  administrators.
  The   Query   Management   Facility  (QMF)  program  product
  (5668-972)  provides query and report writing capability for
  DB2  data  bases.  It allows non-DP professionals to create,
  save,  modify, and execute queries and produce reports.  QMF
  provides these functions in an easy-to-use way.  Queries may
  be  created  using  either  SQL  or  Query-By-Example  (QBE)
  syntax.   Subject  to DB2 authorization, QMF allows creation
  and maintenance of DB2 data bases, tables, indexes, etc..
  DB2I and QMF are complementary.  DB2I will be used primarily
  by  DP professionals in the application development process.
  QMF  will  be  used  primarily by non-DP professionals as an
  easy-to-use alternative to writing application programs.
TECHNOLOGY EXTENDED
DB2  operates  in the MVS/XA and MVS/370 environments.  DB2 takes
advantage   of  many  new  and  existing  hardware  and  software
technologies.   It  operates with IMS/VS and CICS/OS/VS, so users
familiar  with  these  systems  don't  have  to learn a new  data
communication  (online) system.  At the same time, DB2 provides a
simple  data  base system for new users who may not  be concerned
with  data  communications.   DB2  is  designed to utilize the XA
architecture,  including 31-bit virtual addressing and large real
storage.
o LARGE TABLES -- DB2's architecture allows tables to be
  very large, up to 64 gigabytes in size.
  Large tables can be divided into smaller parts that can
  be reorganized and recovered individually to improve
  their manageability.
o INTEGRATED RECOVERY -- DB2 has a comprehensive and integrated
  recovery mechanism.  It has disk logging and automatic log
  archiving capabilities, automatic recovery on restart, and
  utilities to perform commonly needed recovery functions, such
  as image copy.  DB2 recovery is fully coordinated with the
  recovery of IMS/VS and CICS/OS/VS, with which it may operate.
  DB2 communicates with both IMS/VS and CICS/OS/VS so that
  potential inconsistencies can be resolved without loss of data.
o SECURITY -- DB2 has a very flexible and comprehensive
  authorization mechanism.  The flexibility and power of the
  the authorization mechanism allows installations  to choose
  to centralize control, decentralize control, or use these
  in combination.  For example, the authority to control
  particular data bases can be delegated to individual users
  or to groups of users outside the central organization.
ADDITIONAL DB2 DETAILS
RELATIONAL DATA MODEL
o DATA STORAGE --
  - TABLES  AND  TABLE SPACES -- Tables are logical data
    structures  consisting  of rows and columns.  One or
    more  tables  are  stored in a table space.  In DB2,
    table  spaces,  not  data bases, are the recoverable
    structure.   A table space, and therefore the tables
    it  contains, can be very large, up to approximately
    64 gigabytes.
  - PARTITIONED TABLE SPACES -- To make large table spaces
    manageable, DB2 supports partitioned table spaces.  A
    table space can be divided into partitions on the basis
    of ranges of data values.  Partitions also can be
    reorganized or recovered independently, reducing the time

    the table space is unavailable.  Partitioning also allows
    active data to be stored on fast devices and inactive data
    on slower devices.
  - VIEWS -- A DB2 view is an alternative representation
    of  the data in one or more tables.  Once a view has
    been  defined, it can be used in most SQL statements
    just  as a table would be.  A view has two important
    advantages  as  a means of representing data in DB2:
    views  protect  sensitive  data  and  views  further
    reduce complexity.
  - STORAGE GROUPS -- With DB2, users need not be concerned with
    defining MVS data sets.  One or more storage groups can be
    defined indicating which DASD volumes are available for
    use.  DB2 then invokes access method services functions of
    the Data Facility Product to define, extend, and delete
    date sets within the storage groups as required.
  - DATA BASES -- A DB2 data base is a collection of table spaces
    (and, by extension, tables and indexes).  The data base is an
    operational tool.  Data bases may be started and stopped
    independently.  A data base can be considered an entity for
    authorization purposes.
  - INDEXES  --  Indexes  can  be defined by the user to
    provide  for  faster access to data in a table.  The
    index  key  is  made  up  of  one  or  more columns.
    Indexes can be defined interactively and created and
    deleted online.
  - DB2  CATALOG  --  The DB2 system catalog is a set of
    maintained tables that contain information about the
    data and objects that DB2 manages.  Authorized users
    can  retrieve  the  data in these tables in the same
    way  as  any other DB2 table -- with SQL statements.
    DB2  catalog  tables  contain information about, for
    example,  tables,  columns,  indexes,  storage,  and
    authorization.
o STRUCTURED QUERY LANGUAGE (SQL) -- SQL is much more than a
  query language.  It is also an easy-to-use data manipulation,
  data definition, and control language.  Administrators,
  analysts, programmers, and interactive users all use SQL.
  - Application programmers may embed SQL statements in COBOL,
    FORTRAN, PL/I, and assembler language programs to define a
    complete application.  They can also test the 'data base'
    portions of these applications by trying out their SQL
    statements using the DB2 interactive facility (DB2I) before
    embedding them in their programs.  SQL has similar
    capabilities and syntax whether entered interactively or
    embedded in an application program.
  - Data base administrators use SQL to define or change
    data  base  descriptors.   They  can also define and
    delete tables, indexes, and entire data bases.
  - System  administrators  use  SQL to grant and revoke
    authorization  of all other users to data.  Properly
    authorized   interactive   users   can  use  SQL  to
    retrieve, create, and modify data from a terminal.
o AUTOMATIC ACCESS PATH SELECTION --
  DB2 uses information maintained within the DB2 system to
  'navigate'  to  requested data.  DB2 users don't have to
  know  how  data  is  represented  in storage in order to
  retrieve and use it.
  DB2's ability to select access paths is important in minimizing
  program maintenance.  For example, an administrator might
  decide to eliminate a seldom-used index.  Programs which
  previously used the index would have their access paths
  automatically and dynamically reestablished by DB2 the next
  time they were executed.  The logic of the application
  programs themselves is unaffected and no program maintenance
  is required to cope with this change.
o SET LEVEL OPERATION -- The SQL language is based on
  mathematical set-level operations.  Therefore, when DB2
  processes data, it returns, updates, or deletes the entire
  set of data that meets the conditions specified by the user.
  This can reduce the application programming necessary to
  accomplish a given task.
ACCESS TO DATA
DB2I  -  AN INTERACTIVE TOOL -- DB2 provides users an interactive
online   tool.    Called   DB2I  for  DB2  interactive,  it  uses
Interactive  System  Productivity  Facility  (ISPF) to help users
perform  tasks  interactively.   To  use  DB2I, users sign on  to
TSO,  enter  ISPF,  and  select  the  menu  for  DB2I.  That menu
supports several activities.  For example:
o SQL processor using file input (SPUFI) is an online function
  through which DB2 users can submit SQL statements.  They can
  execute those statements and receive the results at the
  terminal.  Using SPUFI, for example, application programmers
  can create their own test tables and can test SQL statements
  prior to inclusion in programs; data base administrators can
  use SPUFI to define and administer data and to grant and
  revoke the authority to access data and programs; and system
  administrators can use it to grant and revoke privileges
  or to query the DB2 system catalog.
ONLINE   HELP   --   To   help   insure ease-of-use, DB2 provides
online  help  information.  By pressing a program function key on
the    display  terminal,  DB2I  users  can  retrieve  panels  of
information   that  explain  DB2  functions  in detail.  Over 500
panels are available.
TSO  help text is also provided to aid the application programmer
or   data  base  administrator  who  is  entering  DB2  commands,
precompiling, or using utilities directly from TSO.
THE  DB2  PRECOMPILER  --  Before  a DB2 COBOL, FORTRAN, PL/I, or
assembler program is compiled (or assembled), the DB2 precompiler
processes  it  to  extract  the  SQL  statements  for  subsequent
processing within DB2.
Since  the precompiler executes independently of DB2, programmers
may  precompile  programs without access or reference to the rest
of the DB2 system.
SECURITY, RECOVERY, UTILITIES, AND INSTALLATION
SECURITY  AND  AUTHORIZATION  -- DB2 provides two mechanisms that
allow installations to protect data.
o AUTHORIZATION STATEMENTS -- Authorization statements in SQL
  are used to grant and revoke authority for all levels of
  data, command, and program access in DB2.  These authorization
  statements permit an installation to ensure that only properly
  authorized users perform data base operations.
o VIEWS  --  Views  play  an important role in controlling
  access  to  sensitive  data.   A view that presents only
  certain  rows or columns in a table can be defined.  The
  user  or  application  accesses only the data defined in
  the view; other data in the table is not available.
  The ability to define views combined with the ability to grant
  and revoke authorization to access those views and the tables
  on which they are based gives DB2 installations the control
  they need to keep valuable and sensitive data secure from both
  unauthorized and inadvertent activities.
RECOVERY  --  DB2  protects  data  from  three  types of failure:
system,  media,  and  application.  Applications and transactions
that  use  DB2  data  operate  across  subsystem  boundaries; DB2
supports  fully  synchronized  recovery  across these boundaries.
The  points  at  which changes to the data base are committed are
synchronized  so  that  recovery  can be coordinated if a failure
occurs at any point.
o On  system  failure,  a  restart  of  DB2  automatically
  restores  data  to  a  consistent  state  by backing out
  uncommitted changes and completing the processing of the
  committed changes.
  Restart  can be speeded and simplified since not all the
  data  bases that were online at the time of failure need
  to  be available when DB2 is restarted.  Some data bases
  can be started later if the installation chooses.
o DB2  makes  provisions for media recovery (e.g., failure
  of  a disk device or failure of a read or write to disk)
  by providing disk logging and, optionally, dual logging.
  DB2 tracks log data sets and image copies so that recovery
  from media failures is simplified.
o If an application program fails, DB2 isolates the work

  associated  with the failing program.  It then backs out all
  uncommitted data changes dynamically, without interfering
  with other system activities.
UTILITIES  -- DB2 provides a number of fully integrated data base
utility programs.  They  are  executed  online.  The long-running
ones  are  restartable.  These utilities may be initiated by JCL,
using  supplied  TSO  CLISTs (command list, a set of TSO commands
that  perform  a complete task when executed), or through the use
of  ISPF  panels supplied with DB2.  The major utilities provided
with  DB2  are:  load,  image  copy,  recovery,  reorganize,  and
statistics.
INSTALLATION  -- DB2 has been designed for easy installation.  No
system   generation  process is required.  Tailoring a DB2 system
is   accomplished by supplying parameters to supplied TSO CLISTs.
Tailoring is simplified through use of supplied ISPF dialogs.
PLANNED AVAILABILITY
IBM DATABASE 2 availability is planned for 3rd Quarter 1984.
SPECIFIED OPERATING ENVIRONMENT
HARDWARE REQUIREMENTS
IBM  DATABASE  2  is  designed  to  operate on the IBM processors
supported  by  MVS/SP  V2 R1.1 or MVS/SP V1 R3.  For the IBM 3033
processor, it is recommended that hardware Cross Memory Extension
Feature (6850) be used.  The processors must have sufficient real
storage  to  satisfy the combined requirements of IBM DATABASE 2,
MVS/XA or MVS/370, appropriate Data Facility Product, appropriate
access  methods,  batch requirements, and other customer-required
applications.  The   configuration   must  include sufficient I/O
devices  to  support  the  requirements for system output, system
residence,  and  system  data  sets.   Sufficient  direct  access
storage must be available to satisfy the user information storage
requirements  and  may  consist  of  any  direct  access facility
supported by the system configuration and the programming system.
EXTERNAL   STORAGE:   DB2  is  independent  of both DASD and tape
device  type.  Any DASD or tape device supported by Data Facility
Product  may  be  used.  The following data sets are supported by
the device types shown:
o Active recovery log data sets            DASD
o Archive recovery log data sets           DASD, tape, MSS
o Image copy data sets                     DASD, tape, MSS
o Bootstrap data set                       DASD
o Data base data sets                      DASD, MSS
o DB2 catalog data sets                    DASD
o Work data sets (for utilities)           DASD, tape, MSS
Note: DB2 may be used with MSS (IBM 3850 Mass Storage Subsystem),
with  appropriate  prerequisite  program  support.  DB2 data base
data set internal format precludes the use of VSAM utilities such
as  IMPORT,  EXPORT and REPRO as well as programs which use them,
such  as  DASD  Migration Aid (5668-002) and the MVS Hierarchical
Storage Manager (HSM) (5740-XRB).
DATA   COMMUNICATIONS  DEVICES:  DB2 uses the system console.  An
installation can control DB2 operations from:
o The system console
o Authorized IMS/VS terminals
o Authorized CICS/OS/VS terminals
o TSO terminals operated by authorized users
For   the   data   communication   devices   supported by IMS/VS,
CICS/OS/VS, and TSO, see the appropriate documentation.
SOFTWARE REQUIREMENTS
OPERATING  SYSTEM  AND  SUPPORT PROGRAMS: IBM DATABASE 2 requires
the following licensed programs (or their equivalents):
1. For MVS/Extended Architecture (MVS/XA) environment (with
   the appropriate prerequisites for each product):
   o MVS/System    Product-JES2   (5740-XC6)   or   -JES3
     (5665-291) Version 2 Release 1.1
   o MVS/XA Data Facility Product (5665-284) Release 1.1
   o MVS TSO Extensions (TSO/E) Release 1 (5665-285)
2. For MVS/370 environment (with the appropriate prerequisites
   for each product):
   o MVS/System Product-JES2 (5740-XYS) or -JES3 (5740-XYN)
     Version 1 Release 3
   o MVS/370 Data Facility Product (5665-295) Release 1
   o MVS  TSO  Command  Package Release 1.1 (5740-XT6) or
     MVS TSO Extensions (TSO/E) Release 1 (5665-285)
3. For both MVS/XA and MVS/370 environments:
   o OS/VS Sort/Merge Release 5 (5740-SM1)
   o For functional ease-of-use: Interactive System Productivity
     Facility (ISPF) (5668-960) and (ISPF/PDF) (5665-268)
   o System Modification Program (SMP) Release 4
The  other  programs (or their equivalents) that may be used with
IBM Database 2 are:
o Query Management Facility (QMF) Release 1 (5668-972)
o Data Extract (DXT) Release 1 (5668-973)
o Information  Management  System/Virtual Storage (IMS/VS)
  Version 1 Release 3 (5740-XX2)
o Customer  Information  Control System/OS/Virtual Storage
  (CICS/OS/VS) Version 1 Release 6 (5740-XX1)
o Resource   Access  Control  Facility  (RACF)  Release  5
  (5740-XXH)
o OS/VS COBOL Compiler and Library (5740-CB1)
o TSO Assembler Prompter (5734-CP2)
o TSO COBOL Prompter (5734-CP1)
o OS PL/I Optimizing Compiler and Libraries (5734-PL1,
  5734-LM4, 5734-LM5, or composite 5734-PL3)
o VS FORTRAN Compiler and Library (5748-FO3)
o OS Assembler H (5734-AS1)
o Assembler H Version 2 (5668-962)
COMPATIBILITY/CONVERSION
SQL/DS:   The  SQL  language  used  by IBM's relational data base
management   system   for   DOS/VSE   and  VM systems, the SQL/DS
program product (5748-XXJ), is broadly compatible with DB2's SQL.
It  is possible to move most data from SQL/DS to DB2 by unloading
it   from   SQL/DS  tables  with  the  SQL/DS  data base services
utility   and   then loading it into DB2 tables with the DB2 load
utility.
Information on conversion of SQL/DS programs and data to DB2 will
be  provided in the IBM DATABASE 2 Application Programming Guides
and  the  IBM  DATABASE  2  Data Base Planning and Administration
Guide.
VIRTUAL STORAGE CONSIDERATIONS
The   DB2   storage   requirements   are   dependent  on  various
configuration  and  workload  parameters  including the number of
users  and  their  usage  patterns,  the  number and size of data
bases,  and  the  number  and  complexity  of  applications.  The
following  estimates of virtual storage requirements are provided
for general guidance.
o For MVS/XA systems:
  Common Storage Area (CSA) - Most of the DB2-required areas
  reside in the extended CSA.  The residual CSA requirement
  is expected to be less than 100K bytes.
  Private Address Space - Most modules, control blocks and
  buffers reside in the extended private area.  The minimum
  residual private address space requirement is approximately
  2.5M bytes.
o For MVS/370 systems:
  CSA - The minimum CSA is approximately
  512K bytes.  The typical CSA requirement is expected to
  be 512-532K bytes.
  Private Address Space - For
  planning purposes the practical minimum virtual
  storage requirements for private address space should be
  considered  to  be  4.5-5.0M bytes.  However, some users
  with minimum requirements may have DB2 systems requiring
  less than 4.5M bytes.  Virtual storage requirements grow
  as the number of concurrent users and/or defined tables
  grows.  Thus, the user should consider the maximum address
  space size that will be available to DB2 as part of his
  or her overall capacity planning procedures.
PERFORMANCE CONSIDERATIONS
The   performance   of  IBM  DATABASE  2  in  a  virtual  storage
environment   is   highly   dependent  on  the  system  resources
available,  the  programs  that  operate  concurrently  and their
relative   priorities,   and  system  and  application  data  set
placement. Performance also depends on the paging characteristics
and  storage  reference  patterns  of  DB2  and  its  application
programs,  the  allocation  of  data  sets to particular devices,
table sizes, indexes created, and many other factors.
Performance   of  DB2  is  also  dependent  upon  the  amount  of
concurrent  demand  for  processor time by DB2 and other users of
the system.
It  is  IBM's  intent  to provide improved DB2 utilization of IBM

308x class processors through the facilities of MVS/XA.
DATA SECURITY AND AUDITABILITY
The IBM DATABASE 2 function is subject to all the controls in its
environment  such  as  those  provided  by  the operating system,
access  methods,  and  subsystems with which it is communicating.
Customer   management   is   responsible   for   the   selection,
application,   and  adequacy  of  those  controls.   For  further
description  of  the  security  available  in DB2, see 'Security,
Recovery, Utilities, and Installation'.
IMS/VS and CICS/OS/VS also have security capabilities. (See those
program  products'  descriptions for details.)  Also, through the
Security  Access  Facility  (SAF) router of the operating system,
Resource Access Control Facility (RACF) (5740-XXH) may be used to
control access at the data set level.
MVS SYSTEM INTEGRITY
IBM   will   accept   APARs   describing   situations  where  the
installation  of  IBM  DATABASE  2  introduces an exposure to the
system   integrity   of   MVS.   This  program is intended to run
authorized.
CHARGES
Consult   your  IBM  marketing  representative  for the following
applicable charges:
INITIAL LICENSE CHARGE
o Basic license
o DSLO
MONTHLY CHARGE
o Basic license
o DSLO
MONTHLY LICENSED PROGRAM SUPPORT CHARGES
MONTHLY MULTIPLE LICENSED PROGRAM SUPPORT CHARGES
TERMS AND CONDITIONS
WARRANTED
o Basic license: Yes, in accordance with the Agreement for
                 IBM Licensed Programs.
o DSLO: Not applicable
SOURCE MATERIALS
A  subset  of  the  source materials for DB2 will be available as
restricted   materials.    The  subset  available  will  be  some
assembler  macros  to  assist  in  system  tailoring  and  record
mapping,  as  well  as sample programs written in COBOL, FORTRAN,
PL/1, and assembler.
The  remaining  source  materials  will  not be made available to
customers.   A  'Restricted Materials Amendment' to the Agreement
for  IBM  Licensed  Programs  must  be signed prior to a customer
receiving  any  licensed  program  materials  for  this  licensed
program.
TESTING PERIOD
o Basic License: 60 days
o DSLO: None
PROGRAM  SERVICES:  Central  Service,  including  the IBM Support
Center,   for   the   Basic   License  will  be  available  until
discontinued   by  IBM  upon  twelve  (12) months written notice.
Central   service,  including  the  IBM  Support Center, for DSLO
licenses  will  only  be  provided  through the customer location
designated for the Basic License.
LOCAL  LICENSED  PROGRAM  SUPPORT: Local Licensed Program Support
will  be  available  until  discontinued  by IBM upon twelve (12)
months  written  notice and will be provided under the terms  and
conditions  of  the Agreement for Local Licensed Program  Support
for   IBM   Licensed  Programs  at  the Monthly Licensed  Program
Support   Charge,  Monthly  Multiple  Licensed  Program   Support
Charge, or will be provided at the applicable programming service
service rate.
Local  Licensed  Program  Support  under this agreement will only
be   furnished  through the customer location designated for  the
Basic License and will be provided by IBM Customer Engineering.
INSTALLATION   LICENSE   APPLIES:    No.   A  separate license is
required   for   each  designated  machine  on which the licensed
program   materials  will be used except as otherwise provided by
IBM.
ORDER INFORMATION: Consult your IBM Marketing Representative.
END OF DOCUMENT

Close [x]

Close [x]