home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 16 Announce
/
16-Announce.zip
/
295185.zip
/
295185.ANN
Wrap
Text File
|
1995-05-02
|
191KB
|
3,112 lines
DATA BASE : ALET PAGE: 1
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
DATE 950502
CATEGORY AS22, AS20, AS47, AS50, AS10
TITLE DB2 VERSION 2
ABSTRACT *-------------------------------------------------------------------*
| IN BRIEF . . . |
The DB2 Version 2 family of products builds upon the
outstanding quality and reliability of Version 1 and provides
these additional benefits:
o EXTENSIBILITY -- Provides the ability to build or buy
extensions to the database to support your specific
business needs
o PRODUCTIVITY -- Provides open standards-based interfaces,
integrated development tools, and easy access to data
o REDUCED COSTS -- Effectively and efficiently exploits
client/server technology for mission-critical applications,
including the ability to manage the environment
o SECURE DATA ASSETS -- Protects your data against
corruption, loss, or unauthorized access, regardless of the
location of the data
o REDUCED RISK -- Leverages existing investments in data,
applications, and people, on the mainframe or desktop
o SCALABILITY -- Supports growth from laptop to massively
parallel databases
PLANNED AVAILABILITY DATE: July 28, 1995
(R) Registered trademark of International Business Machines
Corporation
** Company, product, or service name may be a trademark or
service mark of others.
+ Trademark of Microsoft Corporation
(1) Trademark of Ziff Communications Company and used by IBM
Corporation under license
(TM) Trademark of International Business Machines Corporation
| |
*-------------------------------------------------------------------*
IBM announces availability of DB2 (R) for OS/2 (R) and DB2 for
AIX (R) Version 2, and beta programs for DB2 Version 2 on HP-UX**,
the Solaris** Operating Environment, Windows+ NT**, and SINIX**, the
Siemens-Nixdorf UNIX (1) operating system. Also announced are new
releases of the Distributed Database Connection Services (DDCS)
products for OS/2 and AIX, the DB2 Software Developer's Kit (SDK)
for Windows, a beta version of DB2 client support for Apple**
System 7**, and a beta program for a complementary product, a DB2
stored procedure builder.
DB2 Version 2 provides significant additional value with
support for more advanced database applications, larger, more highly
available databases, greater distributed capability, and higher
performance.
o ADVANCED DATABASE APPLICATIONS -- You can store additional forms
of information and extend functionality through object-oriented
DATA BASE : ALET PAGE: 2
extensions, multimedia datatypes, business rules, and support for
complex data relationships. User-defined data types and
user-defined functions allow you to tailor function to your
specific business needs. Support for large object datatypes
extends this to include documents, graphics, image, audio, video
and any other digital format. Database-enforced integrity
constraints and database-managed triggers allow you to define
business rules once to the database rather than multiple times.
o LARGE, HIGHLY AVAILABLE DATABASES -- DB2 Version 2 has features
to better control data placement, perform operations online,
operate on smaller subsets of data, operate in parallel, and load
data more quickly.
o HIGH PERFORMANCE -- The DB2 database engine supports greater
parallelism and exploits SMP hardware architectures. It includes
more advanced optimizer technology, including query-rewrite, to
better support popular 4GLs, graphical user interface (GUI)
builders, and other ad hoc query workloads. DB2 for AIX
Version 2 has achieved industry-leading TPC-C benchmark results.
o DISTRIBUTED DATABASE -- DB2 Version 2 can make it much easier to
manage the accessibility and integrity of distributed data with
multi-site updating across DB2 for OS/2 and DB2 for AIX servers,
with application server support for MVS, VM, OS/400 (R), and
non-IBM clients through DRDA (TM), and through support of data
replication with DataPropagator (TM) Relational.
o ADDITIONAL ENHANCEMENTS -- Improved application development
support, compatibility with the DB2 family, standards support,
manageability, connectivity, client support, and packaging.
DB2 Version 2 introduces a common server code base on Intel**
and RISC platforms. This provides equivalent function while using
operating system services and optimization to fully leverage each
environment. Beta programs for DB2, DDCS, and DB2 SDK Version 2 on
HP-UX, the Solaris Operating Environment, and Windows NT begin at
selected test sites in July 1995. The beta program for DB2 Version 2
on SINIX begins September 1995. The beta program for the DB2 SDK and
Client Application Enabler for Apple's System 7 will begin in
July 1995.
The DB2 stored procedure builder allows both client-side GUI
applications and server-side stored procedures and user-defined
functions to be built using the BASIC language. The beta program for
the DB2 stored procedure builder will begin in July 1995.
PRODNO 41H2114
41H2112
41H2121
41H2120
41H2126
41H2128
41H2127
41H2133
41H2138
41H2142
41H2451
OVERVIEW DESCRIPTION
DATA BASE : ALET PAGE: 3
DB2 Version 2 products have common functionality across the
operating system platforms. The following descriptions of the DB2
Version 2.1 products apply to all platforms unless specifically
stated otherwise.
DB2 SERVER PRODUCTS
DB2 Version 2.1 adds the following capabilities to the extremely
successful Version 1 products, which are trusted by thousands of the
world's corporations to store their business data:
SUPPORT OF ADVANCED OBJECT-ORIENTED AND MULTIMEDIA APPLICATIONS:
Relational DBMSs (RDBMSs) are used extensively in the DBMS
marketplace, where there is a heavy reliance on them for
mission-critical applications. Many users of RDBMSs are moving
toward nontraditional, object-oriented applications, requiring
support for a wider variety of real-world data. Examples include
more effective handling of text, voice, and image data within RDBMSs.
This trend has been accelerated by client/server tools and 4GLs with
powerful user interfaces for nontraditional data.
DB2 Version 2.1 enables new applications that require
high-speed access to voice, video, image, and text data stored in the
database. Object-oriented techniques can be used during database
design, application development, and execution, allowing enhanced
productivity. A new class of applications, exploiting the power of
expressing SQL queries recursively, is also enabled with DB2
Version 2.1.
DB2 offers extensive support for nontraditional applications
in addition to continuing to provide traditional application support
that is fully integrated with the database architecture:
o LARGE OBJECTS (LOBS): Large object support allows multimedia
objects such as documents, video, image, and voice to be stored
in the database and manipulated like other database objects. The
size of any one LOB can range up to 2GB. Many LOB columns can be
defined in each table, with the exact number depending on the
total length of the row including overhead. LOB data is directly
maintained in the database, and SQL is used for storage and
retrieval. LOBs defined as containing character data respect the
code page of the clients, and the server will handle code page
conversion if the client code page support does not match the
LOB.
A powerful set of built-in functions, such as search,
substring, and concatenation, are supported for LOBs. Additional
functions can be defined at any time by means of user-defined
functions (UDFs).
Implementation of LOB support considers customers'
performance requirements by allowing database users or
administrators to:
- Insert LOBs into the database directly from a file on the
client
- Access only those portions of a LOB that are needed by the
application, not the whole LOB
- Defer or avoid materialization of LOBs
- Choose whether changes to the LOB column will be logged or
not
DATA BASE : ALET PAGE: 4
- Store LOB data in separate table spaces architected
specifically for optimal LOB handling
o USER-DEFINED TYPES (UDTS): UDTs allow users to define new data
types which are represented in the database using built-in types.
For example, a user can define two currency types: CDOLLAR for
Canadian dollars and USDOLLAR for U.S. dollars. These types are
distinct in the sense that they should not be directly compared
to one another or to the DECIMAL type, although the DECIMAL type
might be chosen for the internal representation of both UDTs in
the database. UDTs, like built-in types, can be used for columns
of tables as well as parameters of functions, including
user-defined functions (UDFs). For example, a user can define a
data type such as ANGLE (which varies between 1 and 360) and a
set of UDFs to act on it, such as SINE, COSINE, and TANGENT.
o USER-DEFINED FUNCTIONS (UDFS): Application developers often need
to create their own suite of functions specific to their
application or domain. UDFs make this possible, expanding the
scope of DB2 to include customized business or scientific
functions.
For example, a retail store could define a price data type
for tracking the cost of items it sells. This store might also
wish to define a sales tax function, which would take a given
price value as input, compute the applicable sales tax, and
return this data to the application.
These functions can operate over all database types,
including LOBs and UDTs. UDFs allow queries to contain powerful
computation and search predicates to filter irrelevant data close
to the source of the data. The SQL optimizer treats UDFs exactly
like built-in functions, such as SUBSTR and LENGTH. Applications
may be developed using a variety of application language
environments, such as C, C++, COBOL, and FORTRAN, while sharing a
set of common UDTs and UDFs.
o TRIGGERS: A trigger defines a set of actions that is executed
when TRIGGERED by an insert, update, or delete operation on a
specified base table. Triggers can be used to:
- Support general forms of integrity, such as business rules
- Update summary data automatically
- Perform validation of input data
- Automatically generate a value for a newly inserted row
- Write to other tables for audit-trail purposes
- Support alerts through electronic mail, for example
Global enforcement of business rules is possible because a
defined trigger is used for any application that accesses the
database. Maintenance of applications and databases can be
easier because, if a business policy changes, only a change in
the corresponding trigger is needed instead of changes in each
application program.
Triggers allow greater flexibility in the database and
allow the database manager to capture more of the semantics of
the data. For example, a user may define a trigger that
increments the number of employees each time a new row is
inserted into the EMPLOYEE table.
DATA BASE : ALET PAGE: 5
When combined with UDFs, triggers can be used to implement
event alerts that signal users or other applications that a given
event has occurred within the database. For example, if a member
of the personnel department wanted to be notified whenever an
engineer's salary was changed to exceed $100,000, DB2's
triggering mechanism can be used. Thus trigger support can
provide considerable power and flexibility.
DB2 supports both STATEMENT-LEVEL and ROW-LEVEL triggers.
Triggers can be defined to run BEFORE or AFTER INSERT, UPDATE, or
DELETE operations. Using a BEFORE trigger performs an action
before processing a triggered operation. Using an AFTER trigger
enables processing of additional functions after the triggered
operation.
Multiple triggers per table can be created. Triggers can
also cascade, initiating other triggers. All database activities
initiated by triggers are protected by the transactional
semantics. Thus a ROLLBACK statement would cause all database
operations performed by a trigger to be rolled back, preserving
database integrity.
The flexibility of this new technology can also be applied
to existing data stored in DB2 Version 1 databases. New columns
with new attributes of any type can be added to existing tables,
and then triggers and constraints can be defined on these tables.
Such changes do not modify the contents of existing tables in any
way.
o CONSTRAINTS: Check constraints are generally used to enforce
business rules not covered by key uniqueness or referential
integrity constraints. Check constraints specify conditions that
must not be false for each row of a table or column value of a
row. For example, a user may define constraints on the EMPLOYEE
table that specify that the job of an employee can only be one of
"Sales," "Mgr," or "Clerk." This allows you to restrict values to
a particular domain.
o RECURSIVE SQL QUERIES: Changes to the SQL optimizer enable DB2
Version 2.1 databases to support not only bills-of-material
queries, but also the more powerful forms of recursive queries
such as path expression queries. Examples of queries that become
possible with recursion are:
- Bills-of-material queries where a user wants to return
subparts of parts, and subparts of the subparts, and so on.
- Path expression queries, where a user wants to calculate the
lowest-cost plane fares on multi-hop routes. For example,
the following query can be formulated using recursive SQL:
Return all possible flights from Toronto to Perth without
making a stopover in London or Chicago and with no more than
three plane changes.
The optimizer is capable of making sophisticated
transformations and optimizations for recursive queries and
nonrecursive queries, resulting in selection of better access
plans for improved performance.
The synergy among these extensions gives more power to the
application developer. Complex structures can be modeled as UDTs on
DATA BASE : ALET PAGE: 6
LOBs with their methods implemented as UDFs and their integrity rules
specified as triggers or constraints. For example, MATRIX could be a
UDT defined on a BLOB, and UDFs could be MULTIPLY that does matrix
multiplication, and ROW that retrieves a given row of a matrix.
The combined exploitation of the user-defined types and
functions allows hiding the representation of the data and the
definition of a set of functions that interpret the data. They
enable the creation of function libraries, which can be developed
outside of the database and then added to it, thereby extending
database functionality. This support for RELATIONAL EXTENDERS makes
it very easy to integrate new types of applications directly with the
database. Relational extenders are being developed by IBM for text,
image, audio, video, and fingerprint information. For further
information about the IBM database extenders, see Preview Software
Announcement 295-179.
SUPPORT FOR VERY LARGE AND HIGHLY AVAILABLE DATABASES: Customers use
DB2 databases in mission-critical applications to manage rapidly
growing databases. A number of enhancements to DB2 Version 2.1
provide higher operational capacity, more flexibility, improved
performance, better data integrity, and higher availability:
o DATABASE PARTITIONING (TABLE SPACES): With Version 2, database
administrators can partition a database into parts called TABLE
SPACES. When creating a table, the name of the BASE, INDEX, and
LONG table space can be specified. Using INDEX and LONG table
spaces to store indexes and LOB data, respectively, allows these
structures to be kept separate from the rest of the table data.
This flexibility can be used to increase database performance and
availability. A table space can be spread over one or more
physical storage devices, providing media-spanning capability.
o FLEXIBLE SPACE ALLOCATION: Administrators may also increase the
size of table spaces by adding more devices or storage space
without stopping the database. The data in a table space is
automatically rebalanced for maximum performance. Additionally,
database administrators have great flexibility over the placement
of data. For example, they can place data, indexes, and LOBs,
which all belong to the same table, in separate table spaces on
different devices for maximum performance and operational
considerations.
o BACKUP AND RECOVERY OF DATABASE PARTITIONS: Administrators may
perform backup and recovery at the table space level instead of
at the database level. If a table space contains a single table,
then the backup or recovery of that table space is equivalent to
table-level backup or recovery.
o SUPPORT FOR ONLINE OR OFFLINE BACKUP AND RECOVERY: Table spaces
can be online or offline during the backup process. During
recovery, all table spaces other than the one being recovered can
remain online. In case of an input/output (I/O) error (disk
failure, for example), only the affected table space will be
disabled pending recovery. The rest of the database remains
operational.
o PARALLEL BACKUP AND RECOVERY: It is possible to perform the
backup/recovery of a database or table space in parallel to/from
DATA BASE : ALET PAGE: 7
multiple devices. Doing backup/recovery in parallel reduces the
elapsed time requirements for these key maintenance tasks.
o HIGH-SPEED LOAD UTILITY: A high-speed LOAD utility significantly
increases the speed of doing data loads while ensuring
recoverability of the data being loaded.
LOAD is intended for either bulk loading of new tables or
appending large amounts of data to existing tables. A new CHECK
DATA function works in conjunction with the LOAD utility (or
other-vendor-supplied load utilities) to force revalidation of
table constraints following a LOAD.
The LOAD utility is restartable and recoverable. If a
failure occurs while loading data, users have the option to
continue the load without starting from the beginning. To ensure
recoverability, a backup copy of the loaded table is created
during the LOAD processing.
Indexes are built as the data is being loaded, and table
statistics can be gathered at load time as well. These
capabilities ensure that the data being loaded is ready for full
use at the completion of the LOAD.
o CACHING OF DYNAMIC SQL ACCESS PLANS: The compiled sections for
dynamic SQL statements are cached on a per-user basis by DB2
Version 2.1 server, reducing the need to recompile dynamic SQL
from "once per unit of work" to "only as required." This improves
the performance of dynamic SQL statements that repeat in
different units of work by avoiding the overhead of statement
compilation.
o HIGH AVAILABILITY: The support for partitioning a database into
separately recoverable table spaces, online backup and recovery,
parallel backup and recovery tasks, and the high-speed LOAD
utility all minimize the time required to perform administration
tasks and enhance the availability of DB2 Version 2.1 databases.
These enhancements allow you to create and effectively manage
very large databases limited in size only by the amount of physical
storage that can be assigned to the system.
DISTRIBUTED DATABASE ACCESS: With DB2 Version 2.1 databases and the
accompanying products, the application developer and database
administrator have greater flexibility in distributing data and
applications across various platforms:
o DRDA APPLICATION SERVER: The Distributed Relational Database
Architecture (TM) (DRDA) Application Server (AS) capability
allows DB2 for MVS, DB2 for VSE and VM (SQL/DS (TM)), and DB2 for
OS/400 applications (or any other application that implements the
DRDA Application Requestor functionality) to access data located
in DB2 for OS/2 and AIX databases. With this capability,
thousands of existing database applications running on the MVS,
VSE, VM, and OS/400 platforms are able to access data stored in
the DB2 Version 2.1 Server workstation databases. Note: The DRDA
Application Requester function is provided with the DDCS
products.
o DISTRIBUTED UNIT OF WORK: The support for Distributed Unit of
Work (DUOW) functionality, also known as TWO-PHASE COMMIT,
provides the capability for an application to read and/or update
DATA BASE : ALET PAGE: 8
tables in more than one database from within a single unit of
work, with full data integrity.
For example, you can query tax tables in a DB2 for MVS
database and simultaneously update a DB2 for OS/400 payroll
database. Or, money withdrawn from a bank account in one country
can be deposited into an account in another during the same
transaction. Because these simultaneous transactions are
performed within the scope of a single transaction, the integrity
of the data is assured, even in the case of equipment failure.
DB2 for OS/2 Version 2.1, DB2/6000 (TM) Version 1 and 1.2,
and DB2 for AIX Version 2.1 databases can participate in a
two-phase commit coordinated by the DB2 transaction manager.
With DB2 for AIX Version 2.1, more than one DB2 for AIX database
can participate as a managed resource in a transaction
coordinated by an XA Transaction Manager such as CICS (TM)/6000
or Encina**.
With DB2 for AIX Version 2.1, applications that run under
CICS/6000 (TM) or AIX Encina Monitor have the ability to perform
a two-phase commit with DB2 for MVS or with any other database
complying with the DRDA2 architecture.
This combination of DB2 for AIX with CICS/6000 and Encina
is the first one in the industry to provide a complete and secure
two-phase commit capability between the DB2 for MVS databases and
local area network (LAN)-based databases for UNIX applications.
DATA REPLICATION: DB2 Version 2.1 databases can access replicas of
data from multiple sources including DB2 (MVS, VM, VSE, OS/400),
IMS/ESA (R), and VSAM flat files. This is provided by IBM's Data
Replication products: DataPropagator Non-Relational, DataPropagator
Relational, and DataRefresher (TM). These products are
interoperable, enhance data as it is being replicated, automate the
replication process, and provide intuitive graphical user interfaces
for ease of administration from a workstation control point.
PERFORMANCE ENHANCEMENTS: Users and administrators of DB2 Server
Version 2.1 will notice significant performance improvements in a
variety of scenarios:
o SQL OPTIMIZER WITH QUERY REWRITE CAPABILITY: Major enhancements
to the SQL optimizer strengthen DB2's leadership position in
query optimization for traditional applications, and also extend
this robust support to new application domains enabled by the
object-oriented extensions described earlier. This new
optimization technology provides the function and performance
needed by customers to analyze and exploit vast amounts of
valuable information stored in their databases.
The increasing importance of decision support applications
represents an important customer trend that can result in very
complex database queries. These queries may have been written by
end users, generated by automatic tools, or produced as a result
of many point-and-click application interfaces popular in today's
DOS, Windows, OS/2, and UNIX environments.
The optimizer incorporates a very sophisticated query
rewrite phase that automatically transforms a complex query into
a simpler query that is easy to optimize. As a result, the end
DATA BASE : ALET PAGE: 9
user will realize the best possible performance regardless of the
way a query is structured.
The optimizer also looks at a greater number of
alternatives in its search for the best query execution plan, as
well as employing more sophisticated techniques of modeling the
cost of different ways of fetching the data from disk. All these
techniques can result in orders of magnitude of performance
improvement for complex queries as compared to existing SQL
optimizer technology.
o EXPLAIN FACILITY: The new EXPLAIN facility offers detailed
information about the access plans chosen by the DB2 database to
process SQL statements. This EXPLAIN information helps users in
their database design by allowing them to:
- Create more efficient database designs to achieve desired
performance objectives
- Model the impact of environment changes on SQL statements
- Determine ways in which the performance of applications can
be improved (such as by adding indexes or updating table
statistics)
o NON-UNIFORM DISTRIBUTION STATISTICS: Historically, query
optimizers have assumed that the data values in a column are
uniformly distributed (that is, each value occurs the same number
of times). However in most customer databases, except in
artificial benchmarks, this is rarely true. For almost all
secondary columns in a table, there is typically a small set of
values. Some of these values are very common while others are
very rare.
When the data values don't occur with equal frequency,
there is a non-uniform distribution of values in that column.
DB2 Version 2.1 introduces a new set of column-level
statistics to allow the optimizer to recognize many non-uniform
distributions. This allows the optimizer to more accurately
estimate the number of qualifying rows, resulting in better
access plans.
o DATA PREFETCH: Prefetching of data pages into the buffer pool
can improve performance by reducing the time spent waiting for
input/output to complete. To prefetch pages means that one or
more pages are retrieved from disk in anticipation of their use.
DB2 Version 2.1 supports two categories of prefetch: sequential
prefetch, a mechanism that reads consecutive data pages into the
buffer pool before the pages are required by the application, and
list prefetch, or list sequential prefetch, a way to access data
pages efficiently, even when the data pages needed are not
consecutive.
o PARALLEL INPUT/OUTPUT: DB2 Version 2.1 can perform many
input/output operations in parallel on behalf of a single query.
This can improve the application response time, especially when
the application performs a table scan. Parallel input/output is
enabled by setting a database configuration parameter, and it can
be tuned by controlling the number of prefetch servers that are
created.
o BIG BLOCK READS: This capability allows several pages to be read
DATA BASE : ALET PAGE: 10
from disk using a single input/output operation. Reading several
disk pages at a time reduces the CPU usage and elapsed time for
input/output, and improves query response time.
o DIRECT MEDIA ACCESS (RAW DEVICE SUPPORT): DB2 for AIX
Version 2.1 has the ability to store data directly on a device,
without incurring the overhead of using files, for improved
performance and data integrity. The administrator can choose to
define a table space that uses devices, or uses the native file
system.
o ASYNCHRONOUS BUFFER WRITERS: Pages of data are moved from disk
to the buffer pool in order to read or modify data. If a buffer
page has been modified, it must be written back to disk before
being reused. DB2 buffer writers write out most changed pages to
disk, so the database agents executing user queries always find
empty buffers. This means that database agents will not have to
wait for a write to disk before freeing a buffer page, and the
user transactions will run faster.
o INPUT/OUTPUT PARALLELISM FOR BACKUP AND RECOVERY TASKS: Using
several input/output devices in parallel for backup and recovery
reduces the elapsed times.
o HIGH-SPEED LOAD UTILITY: The high-speed LOAD utility
dramatically reduces the time needed to load contents of a table
into the database.
These and many other DB2 Version 2.1 enhancements provide
significantly improved performance characteristics for all types of
database activities, including:
o Decision support queries
o OLTP applications
o Utilities
THREAD SUPPORT ON OS/2: New to DB2 for OS/2 is the use of operating
system threads instead of processes. The use of threads results in
significantly reduced memory requirements needed to support multiple
users. Reducing memory requirements allows administrators to
allocate more memory to other uses, such as larger DB2 buffer pools,
which can result in increased performance.
DATABASE ADMINISTRATION: Managing multiple systems with diverse
configurations in a client/server environment can be complex and time
consuming. As an aid to administrators, DB2 Version 2.1 provides
several facilities to help manage in this environment:
o DATABASE SYSTEM MONITOR: The database system monitor application
program interfaces (APIs) and commands provide a wide variety of
statistical information about the operation of DB2 servers.
The SNAPSHOT MONITOR capability can be used to collect
point-in-time data. It can be used, for example, to determine
how many users are connected to the database or which
applications are using the database.
The EVENT MONITOR capability is used to query the status
of a database over a period of time. This can allow
administrators to collect information about transient events such
as deadlocks and transaction completions. Event monitoring can
provide complete summary information for transactions, making it
possible to implement a charge-back accounting scheme. The
DATA BASE : ALET PAGE: 11
database event monitor can also record a detailed trace of SQL
statements executed for a particular transaction, or record the
details of deadlocks when they occur.
The snapshot and event monitor capabilities are used by
the new Performance Monitor function. The Performance Monitor is
an industrial-strength tool to aid in performance tuning and
problem determination in a client/server environment.
Performance Monitor can show performance data graphically, and
can indicate possible problem areas visually to help track down a
performance problem. Performance Monitor also ships with a
default profile to provide useful monitoring right from the first
day of operation. This tool enables system administrators,
database administrators, and application developers to:
- Determine and analyze performance problems in database
applications
- Tune applications and SQL statements for better performance
- Identify exception conditions through user-definable
conditions
- Capture and analyze historical performance information
The Performance Monitor function will not be available for
the initial release of DB2 Version 2.1. All customers who
purchase DB2 for OS/2 Version 2.1 and DB2 for AIX Version 2.1
prior to the availability of Performance Monitor are entitled to
this function. IBM will provide instructions for acquiring
Performance Monitor at a time closer to the availability.
o VISUAL EXPLAIN: Visual Explain is an easy-to-use yet robust tool
for analyzing and tuning SQL statements. This tool provides an
intuitive graphical view of the access plan chosen by the DB2
optimizer for an SQL statement. Visual Explain allows database
administrators and application developers to:
- See the access plan used by the database for a given SQL
statement
- Tune SQL statements for better performance
- Determine the source of problems in database transactions
o REMOTE ADMINISTRATION: Database administrative tasks, such as
monitoring, backup, and recovery, can be invoked from remote
client workstations. For example, a database administrator can
initiate a backup of one or more remote servers from a single
client workstation.
o RECOVERY HISTORY FILE: To make the task of administering the
database easier, a history file for each database keeps track of
operational activities such as backups, recoveries, and table
loads. An interface is provided, allowing a database
administrator to query and manage the database history file.
o SNMP SUBAGENT: Integration of systems and database management in
Version 2.1 will include a new component, a DB2 Simple Network
Management Protocol (SNMP) Subagent. This subagent allows
standards-based monitoring and management of DB2 servers from an
SNMP management platform such as NetView (R) for AIX or NetView
for OS/2. For example, from a NetView for AIX console, a system
administrator can monitor the status of a DB2 for AIX or DB2 for
OS/2 server.
DATA BASE : ALET PAGE: 12
The SNMP subagent supports the following standards:
- RFC 1157: A Simple Network Management Protocol
- RFC 1697: A Management Information Base (MIB) for management
of relational database management systems
o ADMINISTRATOR'S TOOLKIT: With the availability of the
Performance Monitor function, a client installation option called
Administrator's Toolkit will be enabled. This client is a
tightly integrated group of database administration tools and is
provided with the DB2 for AIX and OS/2 Server product. This is
not a separately orderable product.
Performance Monitor, along with Visual Explain and the
Database Director, will provide a comprehensive set of database
administration and management tools. Easy-to-use, intuitive
graphical user interfaces are provided with the tools in the
Toolkit. These tools bring industrial-strength yet easy-to-use
support to the Version 2.1 environment. The DB2 Administrator's
Toolkit also scales easily to DataHub (R), IBM's database
management tool for heterogeneous enterprise management. The
similar look and feel between the DB2 Administrator's Toolkit and
DataHub helps to minimize training as the scope of your database
administration needs changes.
The ability to partition the database into table spaces, the
new LOAD utility, and the enhancements to backup and restore tasks
all significantly improve the ability to administer large and small
databases.
In addition to the built-in management functions in DB2
products, the DataHub product family provides the capability of
managing multiple DB2 (OS/2, AIX, MVS, VM, and OS/400) databases from
a single workstation control point.
MIGRATION TO DB2 VERSION 2.1: To preserve customer investments in
DB2/2 (TM) and DB2/6000 Versions 1 and 1.2, a migration facility will
be included that automatically migrates these databases to the
Version 2.1 format without modifying the user data. Applications
that currently work with Versions 1 and 1.2 will continue to work
without change.
DDCS PRODUCTS
DDCS products provide applications with the ability to connect to
databases that conform to DRDA protocols. DDCS products provide the
DRDA Requester function.
o DISTRIBUTED UNIT OF WORK: With DDCS Version 2.3, applications
can now work better with distributed data. DDCS now allows
applications to access data from multiple databases within the
same unit of work or transaction.
o INTEGRATION WITH TRANSACTION MONITORS: DDCS provides for tight
integration of DRDA databases with transaction monitors such as
CICS and Encina. When a transaction monitor and DDCS are
installed on the same workstation, databases accessible through
DDCS behave as Resource Managers. This allows applications to
update multiple databases and other resources involved in a
transaction, such as shared file systems, with complete
integrity. For example, an application program written for a
transaction monitor such as CICS can withdraw money from a bank
DATA BASE : ALET PAGE: 13
account in Osaka and deposit funds into an account in Singapore.
o PREFETCH: This function is new to DDCS Version 2.3. It is
designed to improve the response times for queries that return
large result sets. Previous versions of DDCS used a technique
called blocking to improve performance for such queries. DDCS
Version 2.3 continues to utilize blocking in combination with
Prefetch to further enhance response time by anticipating future
requests for data. DDCS will try to fetch rows of data for an
open cursor before the application actually requests the data.
Typically, this will result in data being available much faster
because it has already been transmitted over the network. This
function is completely transparent to application programs and
does not require any changes to DRDA servers.
o STORED PROCEDURES: DDCS Version 2.3 now supports invocation of
stored procedures. The SQL92 level of function for stored
procedure calls is supported. Stored procedures can greatly
improve performance of applications by minimizing network
traffic. A stored procedure is an executable module stored on
the database server that is comprised of SQL statements and
application logic that are performed frequently. When a call to
a stored procedure is made, only the instruction to invoke a
procedure is passed to the database server instead of passing
individual SQL statements. Because stored procedures execute on
the database server, intermediate results are assembled on the
same machine and are not sent over the network. This can result
in a significant reduction in network traffic and improved
overall performance.
DDCS can be used to invoke stored procedures on database
servers that support them such as DB2 for MVS Version 4 and DB2
for OS/400 Version 3.
o COMPOUND SQL: Compound SQL is especially beneficial for
applications that perform a large number of insert and update
operations. Compound SQL allows application programmers to block
a number of SQL statements together and send them to the database
server for execution as one block of statements, minimizing
network traffic. Only the last SQL statement in the Compound SQL
group returns results to the application. Therefore, Compound
SQL is more appropriate for SQL statements that do not need to
return data after every statement. SQL INSERT and UPDATE
statements are good candidates for grouping into Compound SQL.
Compound SQL does not require any changes to the DRDA servers.
Applications accessing any of the DRDA servers can benefit from
using Compound SQL. The DB2 IMPORT utility has been enhanced to
use Compound SQL to provide improved performance.
o CHARGE-BACK ACCOUNTING: Many organizations practice procedures
where individual users or departments are charged for the
resources they use on a database server. DDCS Version 2.3 can
now pass an account string to a DRDA server such as DB2 for MVS.
This feature allows existing charge-back procedures to fully
apply to users accessing the DRDA server through DDCS. DDCS
Version 2.3 provides great flexibility in assigning accounting
information without requiring excessive involvement of database
DATA BASE : ALET PAGE: 14
administrators. Unique account information can be assigned to
individual users or to all requests coming through a particular
DDCS machine.
o ADDITIONAL BIND OPTIONS: DDCS Version 2.3 now supports all bind
options provided by the IBM DB2 family of databases for increased
programmer productivity and application portability.
o LOWER SOLUTION PRICE: For customers who require DDCS
connectivity function, but do not require a local data store,
DDCS for OS/2 Version 2.3 greatly reduces the total solution
cost. Version 2.3 of DDCS for OS/2 no longer requires that a
corresponding DB2 for OS/2 product be purchased. Customers who
do require RDBMS function on the DDCS workstation can purchase
and install the appropriate DB2 Version 2.1 product. This
function is offered in previous versions of DDCS for AIX, DDCS
for HP-UX, and DDCS for the Solaris Operating Environment.
DB2 SOFTWARE DEVELOPER'S KITS
The DB2 Software Developer's Kits (DB2 SDK) provide programmers with
a development environment for building database applications that
access and manage data stored in IBM relational database management
systems. The DB2 SDK products provide graphical and command-line
tools, documentation, and code samples for developing database
applications on workstation platforms supported by DB2. All DB2
Software Developer's Kits provide facilities for developing
applications using embedded SQL, the DB2 Call Level Interface, and
the DB2 administrative APIs.
DB2 SDK Version 2.1 precompilers are provided for developing
embedded SQL applications using C, C++, COBOL, and FORTRAN
programming languages, and support a number of key development tools
on each DB2-supported platform. DB2 SDKs also provide a documented
API, allowing application development tool providers to implement
precompiler support for DB2 directly within their products, and
offering developers even more language and tool options. DB2 SDKs
also support the development of database applications using the REXX
programming language.
The DB2 Call Level Interface is a C and C++ application
programming interface for access to the DB2 family of databases.
Developers using the DB2 Call Level Interface do not need to use
precompilers or manage complex SQL data structures. The DB2 Call
Level Interface in Version 2.1 incorporates large portions of the
X/Open** SQL Call Level Interface and Microsoft**'s Open Database
Connectivity (ODBC) Version 2 specifications, and is closely aligned
with the emerging ISO Call Level Interface specification.
Investments developers make in learning these specifications can be
applied directly to DB2 Call Level Interface development.
With DB2 SDK Version 2.1, developers using DB2 precompilers or
the DB2 Call Level Interface can fully exploit the new DB2
Version 2.1 capabilities.
The Command Line Processor is included in each DB2 SDK,
providing an interactive SQL capability to prototype SQL statements
and perform ad hoc queries. It also supports batch and interactive
submission of database commands, allowing developers and
administrators to manage a local or remote LAN-connected database
DATA BASE : ALET PAGE: 15
server.
The DB2 SDK for OS/2 and the DB2 SDK for AIX include a
graphical Visual Explain tool. Visual Explain can help developers
and database administrators easily understand the decisions made by
DB2 Version 2.1's new optimizer, simplifying the task of optimizing
application performance.
The DB2 SDK can also help improve the programmer's ability to
exploit the database server, by allowing applications developed with
the DB2 Software Developer's Kits to be bound using the full range of
bind options supported by the database server being accessed.
DB2 Version 2.1 includes a number of enhancements that improve
the portability of applications between the workstation and host
database servers. A number of DB2 for MVS SQL statements are now
supported by the DB2 Version 2.1 databases, such as ALIAS, HEX and
DIGITS scalar functions, and OPTIMIZE FOR n ROWS, among many others.
DB2 Version 2.1 also provides relief for a number of constraints,
reducing the amount of work needed to migrate applications and data.
These constraints include the number of tables that can be referenced
in an SQL statement, the number of host variables allowed in a
program, and the list of reserved words.
DB2 SDK Version 2.1 includes an MVS Flagger. This tool
analyzes embedded SQL statements within an application program, and
identifies the use of SQL statements that are not supported on DB2
for MVS. Where programmers use workstation tools to develop
applications that will execute on the MVS platform, the Flagger will
save time and effort by reducing the number of syntax errors when
migrating DB2 applications to MVS.
CLIENT APPLICATION ENABLERS
The IBM DB2 Client Application Enablers allow application programs
running on DOS, Windows, OS/2, AIX, HP-UX, and Solaris Operating
Environment client workstations to access data stored in any of the
IBM DB2 relational databases. The Client Application Enablers
provide run-time access to applications that support ODBC, and those
developed with DB2 Software Developer's Kits. The DB2 Version 2
Client Application Enablers have been enhanced with the following
functions:
o Support for TCP/IP allows DOS, Windows, and OS/2 users to use
TCP/IP to access DB2 for OS/2 database servers and DDCS for OS/2
gateways.
o The OS/2 TCP/IP implementation (TCPBEUI) provided with LAN Server
Version 4.0 is supported by DB2 for OS/2 Version 2.1. TCPBEUI
enables NetBIOS subsystems and applications, like DB2/2
configured for NetBIOS, to run on the TCP/IP stack.
o Support for Winsockets for DB2 Client Application Enablers for
Windows allows Windows users to connect to any DB2 server using
any TCP/IP protocol that is compliant with the Winsockets.
o Call Level Interface support provided for Windows and OS/2
clients fully supports Microsoft ODBC Level 1, and nearly all
Level 2 functions. Windows applications coded using the
Microsoft ODBC specification can access data stored in any of the
DB2 family of relational databases. This ODBC driver has been
tested with a number of popular Windows applications available in
DATA BASE : ALET PAGE: 16
the marketplace today.
Use the Client Application Enablers to access the DB2 family
on a local area network (LAN) using these protocols:
COMMUNICATION DB2 FOR DB2 FOR DB2 FOR DB2 FOR
PROTOCOLS OS/2 AIX HP-UX SOLARIS
CLIENT SUPPORTED V2 V2 V1.2 V1.2
DB2 Client NetBIOS Yes No No No
Application Enabler IPX/SPX Yes Yes Yes (1) Yes (1)
for DOS V1.2 TCP/IP Yes Yes Yes Yes
APPC No No No No
DB2 Client NetBIOS Yes No No No
Application Enabler IPX/SPX Yes Yes Yes (1) Yes (1)
for Windows V2.1 TCP/IP Yes Yes Yes Yes
APPC No No No No
DB2 Client NetBIOS Yes No No No
Application Enabler IPX/SPX Yes Yes No No
for OS/2 V2.1 TCP/IP Yes Yes Yes Yes
APPC Yes Yes No No
DB2 Client NetBIOS No No No No
Application Enabler IPX/SPX No No No No
for AIX V2.1 TCP/IP Yes Yes Yes Yes
APPC Yes Yes Yes Yes
DB2 Client NetBIOS No No No No
Application Enabler IPX/SPX No No No No
for HP-UX V1.2 TCP/IP Yes Yes Yes Yes
APPC Yes Yes No No
DB2 Client NetBIOS No No No No
Application Enabler IPX/SPX No No No No
for Sun Solaris V1.2TCP/IP Yes Yes Yes Yes
APPC Yes Yes No No
(1) Provided by the FireFox**, Inc. NOV*IX** for NetWare**
product
Client Application Enablers for a number of DB2-supported
clients are now provided with the DB2 for OS/2 and DB2 for AIX server
products in the DB2 Client Pack. Client Application Enablers for
OS/2, AIX, HP-UX, DOS, Windows, and the Solaris Operating Environment
are available. Client support for additional workstation operating
systems, as it is developed, will be available at no charge to
customers of DB2 Version 2.1 server products.
DB2 PACKAGING CHANGES
The DB2 Version 2 product packaging has been enhanced as follows:
o The Client Support function for AIX is integrated into the DB2
for AIX and DDCS for AIX products.
o All DB2 client application enablers are provided with DB2 for
OS/2 and AIX Server, and DDCS for OS/2 and AIX Multi-User Gateway
products.
o In Version 2.3, DDCS for OS/2 no longer has a prerequisite of
DB2 for OS/2.
NOTE: The DB2 SDK for DOS and DB2 Client Application Enabler for DOS
will be maintained at the current Version 1.2 level of support.
A DB2 STORED PROCEDURE BUILDER
Version 2.1 of DB2 for OS/2 and DB2 for AIX provides additional
DATA BASE : ALET PAGE: 17
support for stored procedures and user-defined functions (UDFs). The
DB2 stored procedure builder lets application programmers work in an
OS/2, AIX, or Windows 3.1 development environment to easily and
quickly develop BASIC client applications as well as the BASIC stored
procedures and UDFs that run with DB2 for OS/2 and DB2 for AIX. From
this development environment, the programmer can automatically
distribute the procedures and functions to the target server, and
build, debug, and execute the stored procedures and UDFs on the
server. If the programmer is developing the database procedure or
function on OS/2 or AIX and has DB2 for OS/2 or DB2 for AIX installed
locally, the procedure or function can be unit tested and debugged
locally before being distributed to the target server for final
testing and execution.
The DB2 stored procedure builder provides a complete BASIC
visual development environment for quickly creating client
applications that call the stored procedures and user-defined
functions. The visual builder follows a drag-and-drop paradigm
similar to that of other popular visual builders where the programmer
moves graphical user interface (GUI) components to an application
form and writes BASIC scripts to manipulate the components. The same
BASIC scripting capability is used to create the DB2 for OS/2 and DB2
for AIX server procedures. Calls to DB2 are made via embedded
dynamic and static SQL or calls to the DB2 Call Level Interface;
access to non-IBM relational data is via an ODBC call level
interface.
BASIC was chosen as the language for the DB2 stored procedure
builder because it is easy to learn and is widely used in the
industry for desktop applications. Developers may prefer BASIC for
development of database stored procedures because it has no pointers,
is interpreted, and is a typed language.
The server procedures created with the stored procedure
builder can be called by many types of client applications, including
those written with the builder as well as clients written with IBM
COBOL, VisualAge (TM), Microsoft Visual Basic**, or any C or C++
client application. A DB2 stored procedure builder run-time is
required on the server platform to interpret the server procedure,
regardless of what type of client calls the procedure. The run-time
is shipped with the DB2 stored procedure builder product.
This DB2 stored procedure builder will be available to a
limited set of customers in July 1995 for beta evaluation and
testing. When these customers confirm that product function and
quality objectives have been met, IBM will announce the general
availability and information about pricing and ordering of a product
based on this DB2 stored procedure builder.
The DB2 stored procedure builder will be provided on CD-ROM.
STATEMENT OF GENERAL DIRECTION
When users of the beta versions of the DB2 Version 2 products for
HP-UX, the Solaris Operating Environment, Windows NT, SINIX, and
System 7 confirm that function and quality objectives have been met,
IBM will announce the general availability and information about
pricing and ordering.
IBM intends to make Performance Monitor available for DB2 for
DATA BASE : ALET PAGE: 18
OS/2 and DB2 for AIX by the end of 1995 and to make this function
available in an update to the program package. IBM intends to
provide DB2 stored procedure builder support for server procedures on
DB2 for MVS as well as on other platforms where the DB2 family
supports stored procedures.
CUSTINFO PUBLICATIONS
The following publications are provided in DB2 Version 2
program packages as described in the PACKAGING section. These
publications are also available separately for a fee. To order,
contact your IBM representative.
FORM PART
TITLE NUMBER NUMBER
DB2 for OS/2 Planning Guide S20H-4784 20H4784
DB2 for OS/2 Installation and
Operation Guide S20H-4785 20H4785
DB2 for AIX Planning Guide S20H-4758 20H4758
DB2 for AIX Installation and
Operation Guide S20H-4757 20H4757
DDCS for OS/2 Installation and
Configuration Guide S20H-4795 20H4795
DDCS for AIX Installation and
Configuration Guide S20H-4794 20H4794
Installing and Using OS/2
Clients S20H-4782 20H4782
Installing and Using AIX
Clients S20H-4666 20H4666
Installing and Using Windows
Clients S20H-4789 20H4789
DOS Client Installation
Supplement S20H-4949 20H4949
Software Developer's Kit
for OS/2 Building Your
Applications S20H-4787 20H4787
Software Developer's Kit
for AIX Building Your
Applications S20H-4780 20H4780
Software Developer's Kit
for Windows Building Your
Applications S20H-4792 20H4792
Application Programming
Guide S20H-4643 20H4643
Command Reference S20H-4645 20H4645
API Reference S20H-4984 20H4984
Administration Guide S20H-4580 20H4580
Database System Monitor
Guide and Reference S20H-4871 20H4871
Information and Concepts Guide S20H-4664 20H4664
Call Level Interface Guide
and Reference S20H-4644 20H4644
Messages Reference S20H-4808 20H4808
Problem Determination Guide S20H-4779 20H4779
SQL Reference S20H-4665 20H4665
DATA BASE : ALET PAGE: 19
IBM DDCS User's Guide S20H-4793 20H4793
DB2 for OS/2 Master Index S20H-4788 20H4788
DB2 for AIX Master Index S20H-4781 20H4781
An online Glossary is also provided.
DISPLAYABLE SOFTCOPY PUBLICATIONS
Publications for DB2 for OS/2 and DB2 for AIX are offered in
displayable softcopy form. All displayable manuals are included in
the basic machine-readable material. The files are shipped on the
same media type as the basic machine-readable material. The CD-ROM
contains PostScript** files that can be used to produce high-quality
reproductions of the documentation on local laser printers. These
files are not provided in diskette program packages.
The displayable manuals on the DB2 for OS/2 CD-ROM can be used
with the BookManager (R) READ licensed programs in any of the
supported environments. Terms and conditions for use of the
machine-readable files are shipped with the files. The displayable
manuals on the DB2 for AIX CD-ROM can be used with the IPF/X utility.
EDUCATION SUPPORT
The appropriate curriculum will be updated, as necessary, to
include the enhancements described in this announcement. Details of
the education support will be provided by product availability
through separate Education Announcements.
Call IBM Education and Training at 800-IBM-TEACH (426-8322)
for education catalogs, schedules, and enrollments.
TECHINFO TECHNICAL INFORMATION
SPECIFIED OPERATING ENVIRONMENT
HARDWARE REQUIREMENTS
For DB2 for OS/2, DDCS for OS/2, DB2 SDK for OS/2, and DB2 SDK for
Windows Version 2 products:
o The system unit must have a drive capable of reading 3.5-inch
diskettes or a CD-ROM.
o Refer to the DB2 FOR OS/2 PLANNING GUIDE for fixed disk and
memory requirements.
For DB2 for AIX, DDCS for AIX, and DB2 SDK for AIX Version 2
products:
o The system unit must have a drive capable of reading a CD-ROM or
8-mm tape.
o Refer to the DB2 FOR AIX PLANNING GUIDE for fixed disk and memory
requirements.
SOFTWARE REQUIREMENTS
DB2 FOR OS/2
o IBM OS/2 Version 2.11 or later (including OS/2 Warp).
o Communications: DB2 for OS/2 supports APPC, NetBIOS, TCP/IP, and
Novell** IPX/SPX protocols for both server and client function.
The communication software you require depends on the protocol
you wish to use. The database server can accept requests from
multiple protocols concurrently. If you wish to use several
protocols, ensure that you have all the required products
installed.
- For APPC connectivity, IBM Communications Manager/2
Version 1.1 or later.
- For IPX/SPX connectivity, Novell NetWare Requester for OS/2
DATA BASE : ALET PAGE: 20
Version 2.10 (also shipped with NetWare 3.x and NetWare 4.x).
NetWare Requester for OS/2 Version 2.11 is required for OS/2
Warp.
- For NetBIOS connectivity, you must install the LAN Adapter
and Protocol Support (LAPS) available in one of the following
products: IBM NTS/2 Version 1.0, IBM OS/2 Extended Services
(R) 1.0, IBM Communications Manager/2 Version 1.1, or IBM
OS/2 LAN Requester (shipped with IBM OS/2 LAN Server
Version 2.0 or later).
- For TCP/IP connectivity, IBM TCP/IP Version 2.0 for OS/2
(with APAR PN63689) or later.
DB2 SNMP SUBAGENT ON OS/2
o Simple Network Management Protocol (SNMP) products include IBM
NetView for AIX and IBM NetView for OS/2. DB2 provides support
for SNMP management products via the DB2 SNMP Subagent, included
as a component of the DB2 server. SNMP management products such
as NetView allow centralized management of both hardware and
software components of a system. The DB2 SNMP Subagent allows
DB2 servers to be managed just like any other SNMP-managed
resource. The software requirements for using the SNMP Subagent
on OS/2 are as follows: DPI 1.1 support provided by TCP/IP
Version 2.0 or later.
WINDOWS CLIENT ON OS/2
o To run Windows DB2 applications on your OS/2 workstation, you
must install either the DB2 Client Application Enabler for
Windows or DB2 SDK for Windows products. The software
prerequisites, listed later in this section, are the same except
OS/2 Version 2.1 or later is used instead of Windows Version 3.1.
DB2 CLIENT APPLICATION ENABLER FOR OS/2
o The DB2 Client Application Enabler for OS/2 requires OS/2
Version 2.0 with Servicepak Level XR06055, or later (including
OS/2 Warp), and one of the following communications products:
- For APPC connectivity, IBM Communications Manager/2
Version 1.0 or later.
- For IPX/SPX connectivity, Novell NetWare Client for OS/2
Version 2.10.
- For NetBIOS connectivity, you must install the LAN Adapter
and Protocol Support (LAPS) available in one of the following
products: IBM NTS/2 Version 1.0, IBM OS/2 Extended Services
1.0, IBM Communications Manager/2 Version 1.1, or IBM OS/2
LAN Requester (shipped with IBM OS/2 LAN Server Version 2.0
or later).
- For TCP/IP connectivity, IBM TCP/IP Version 2.0 or later.
DB2 SOFTWARE DEVELOPER'S KIT FOR OS/2
o The DB2 Software Developer's Kit for OS/2 product has the same
software requirements as DB2 Client Application Enabler for OS/2.
DDCS FOR OS/2
o DDCS for OS/2 Single-User and DDCS for OS/2 Multi-User Gateway
can be used alone or with DB2 for OS/2. DDCS for OS/2
Single-User cannot accept requests from database clients for host
access. DDCS for OS/2 Multi-User Gateway contains the
communications support to allow DRDA host access from all DB2
DATA BASE : ALET PAGE: 21
database clients.
o DDCS for OS/2 has the same operating system and communications
requirements as DB2 for OS/2.
o For DDCS for OS/2 to access DRDA Application Servers such as DB2
for MVS/ESA (TM), SQL/DS, and DB2 for OS/400, you must also have
APPC protocol support installed on your system. The following
product is supported: IBM Communications Manager Version 1.1 for
OS/2 or later.
DRDA DATABASES
o In addition to other DRDA-compliant database management systems,
DDCS for OS/2 and DB2 for OS/2 support the following IBM
relational database products:
- DB2 for MVS Version 2.3.
- DB2 for MVS/ESA Versions 3.1 and 4.1.
- SQL/DS Version 3.3 or later.
- DB2 for OS/400 Versions 2.2 and 3.1.
o Various APARs and/or PTFs are required with the above products.
SUPPORTED COMPILERS FOR DB2
o Applications that access DB2 for OS/2 can be written in any of
the languages supported for the platform on which you are
developing. An application development environment is provided
with DB2 for OS/2 Single-User and DB2 SDK for OS/2. The
supported languages include C, C++, COBOL, and FORTRAN compiled
languages, and the REXX interpreter is supported where available.
DB2 for OS/2 provides precompilers for these languages. Writing
an application in a compiled language gives the programmer a high
level of flexibility.
o For database applications that run on an OS/2 platform, you can
use any of the following compilers:
- IBM C Set++ Version 2.1
- IBM VisualAge C++ Version 3.0.
- WATCOM FORTRAN 77 32 Version 9.5.
- IBM COBOL VisualSet for OS/2 Version 1.1.
- Micro Focus COBOL Version 3.1 or later.
- IBM Procedures Language 2/REXX (supplied as part of OS/2).
o For database applications that run on Windows, use any of the
following compilers:
- Microsoft Visual C++ Version 1.5.
- Borland** C++ Version 4 or 4.5.
- Micro Focus** COBOL Version 3.1 or later.
o For database applications that run on AIX, use any of the
following compilers:
- IBM XL C Version 1.2.1 or 1.3.
- IBM C for AIX Version 3.1.
- IBM C Set++ for AIX Version 2.1 or 3.1.
- IBM AIX XL FORTRAN Version 2.3 or 3.2.
- IBM COBOL Set for AIX Version 1.1.
- Micro Focus COBOL Version 3.1 or later.
- IBM REXX/6000 (available as PRPQ 5764-057).
o For database applications that run on HP-UX, use any of the
following compilers:
- HP C/ANSI C for Series 700 or 800.
DATA BASE : ALET PAGE: 22
- FORTRAN 77/HP-UX for Series 700 or 800.
o For database applications that run on Solaris, use any of the
following compilers:
- C Set++ for the Solaris Operating Environment Version 1.
- SPARCompiler C** 2.0.1.
- SPARCompiler FORTRAN** 2.0.1.
- Micro Focus COBOL Version 3.1.
o Precompilers are provided for the compilers listed.
DB2 FOR AIX
o DB2 for AIX requires one of the following operating systems:
- IBM AIX Version 3.2.4.
- IBM AIX Version 3.2.5.
- IBM AIX Version 4.1 or later.
o DB2 for AIX supports APPC, IPX/SPX, and TCP/IP for server
function; and APPC and TCP/IP for client function. The
communication software you require depends on the protocol you
wish to use. The database server can accept requests from
multiple protocols concurrently. If you wish to use several
protocols, ensure that you have all the required products
installed.
o If you have IBM AIX Version 3.2.4 or 3.2.5 installed, you will
need one of the following protocols:
- For APPC connectivity: IBM AIX SNA Server/6000 Version 2.1 or
later.
- For IPX/SPX connectivity: IBM AIX NetBIOS and IPX
Support/6000 Version 1.1.
- For TCP/IP connectivity: The TCP/IP component of the
operating system must be installed.
o If you have IBM AIX Version 4.1 or later installed, you will need
one of the following protocols:
- For APPC connectivity: IBM SNA Server/6000 Version 2.2.
- For IPX/SPX connectivity: IBM NetWare for AIX Version 3.11B
or IBM NetBIOS and IPX Support/6000 Version 2.1.
- For TCP/IP connectivity: The TCP/IP component of the
operating system must be installed.
GRAPHICAL USER INTERFACE REQUIREMENTS
o To use the Database Director tool, you must have the following
software installed on your system:
- IBM AIXwindows (R) Version 1.2.3 or later.
- Motif** Version 1.2 (x11r5).
TRANSACTION MANAGERS
o If you wish to write applications using a transaction manager,
you must install one of the following:
- IBM CICS/6000 Version 1.2.
- Tuxedo** System/T Version 4.2.2.
- Encina TP Monitor Version 1.3.
To support DRDA two-phase commit with Encina Monitor or CICS/6000
against DB2 for MVS/ESA Version 3.1 or DB2 for OS/400
Version 3.1, you also require Encina PPC Gateway Version 1.3 with
APARs IX49555 and IX50207.
HIGH AVAILABILITY USING HACMP
o The IBM AIX High Availability Cluster Multi-Processing/6000
DATA BASE : ALET PAGE: 23
(HACMP/6000 (TM)) system enables clustered RISC System servers to
recover from server, disk, network, or network interface
failures. To use HACMP with DB2 for AIX, install the following
on your system: IBM HACMP/6000 Version 2.1 or later.
DB2 SNMP SUBAGENT ON AIX
o Simple Network Management Protocol (SNMP) products include IBM
NetView for AIX and IBM NetView for OS/2. DB2 provides support
for SNMP management products via the DB2 SNMP Subagent, included
as a component of the DB2 server. SNMP management products such
as NetView allow centralized management of both hardware and
software components of a system. The DB2 SNMP Subagent allows
DB2 servers to be managed just like any other SNMP-managed
resource.
o No additional software is required to use the DB2 SNMP Subagent.
DB2 CLIENT APPLICATION ENABLER FOR AIX
o The DB2 Client Application Enabler for AIX has the same software
requirements as DB2 for AIX.
DB2 SOFTWARE DEVELOPER'S KIT FOR AIX
o The DB2 Software Developer's Kit for AIX product has the same
software requirements as DB2 for AIX.
DDCS FOR AIX
o DDCS for AIX can be used alone or with DB2 for AIX. DDCS for AIX
Multi-User Gateway contains the communications support to allow
DRDA database access for all DB2 Client Application Enablers.
o DDCS for AIX has the same operating system, inbound client, and
transaction management requirements as DB2 for AIX Server.
o For DDCS for AIX to access DRDA Application Servers such as DB2
for MVS/ESA, SQL/DS, and DB2 for OS/400, you must also have APPC
protocol support installed on your system. The following
products are supported:
- If you have IBM AIX Version 3.2.4 or 3.2.5 installed, you
will need one of the following protocols: IBM AIX SNA
Server/6000 Version 2.1 or later, or IBM Desktop SNA 1.1 IBM
SNA Services/6000 Version 1.2 with PTF U417689.
- If you have IBM AIX Version 4.1 installed, you will need the
following: IBM SNA Server/6000 Version 2.2.
DRDA DATABASES
o In addition to other DRDA-compliant database management systems,
DDCS for AIX and DB2 for AIX support the following IBM relational
database products:
- DB2 for MVS Version 2.3.
- DB2 for MVS/ESA Versions 3.1 and 4.1.
- SQL/DS Version 3.3 or later.
- DB2 for OS/400 Versions 2.2 and 3.1.
o You should consult with your host database coordinator to
determine that the appropriate prerequisites and security
considerations have been considered and installed to support both
the AIX and database environments.
ADSTAR (R) DISTRIBUTED STORAGE MANAGER
o If you plan to use the ADSTAR Distributed Storage Manager
facilities for backing up and restoring your databases, you must
have the ADSTAR Distributed Storage Manager product installed on
DATA BASE : ALET PAGE: 24
your server. The ADSTAR Distributed Storage Manager API
Version 1.2.7, which allows the database manager to interface
with the host product, is included with DB2 for AIX.
DB2 CLIENT APPLICATION ENABLER FOR WINDOWS VERSION 2.1
o Windows Version 3.1 or later.
o One of the following for NetBIOS connectivity:
- IBM LAN Support Program Version 1.2.1, or later.
- IBM DOS LAN Requester (shipped with IBM OS/2 LAN Server
Version 2.0, or later).
o One of the following for IPX/SPX connectivity:
- Novell NetWare Requester for DOS (shipped with Novell NetWare
Version 3.x or 4.x) plus WINUP9 or later update kit for
Windows clients (provided by Novell).
- NetWare Workstation for DOS/Windows Version 1.0, or later,
plus WINUP9 or later update kit for Windows clients (provided
by Novell).
o One of the following for TCP/IP connectivity:
- IBM TCP/IP for DOS Version 2.1.0.4, or later.
- FTP Software, Inc., PC/TCP** Network Software for DOS
Version 2.2, or later.
- FireFox NOV*IX for NetWare Version 2.0, or later, and Novell
NetWare Requester for DOS (shipped with Novell NetWare
Version 3.x or 4.x) plus DOSUP9 or later update kit for DOS
clients and WINUP9 or later update Kit for Windows clients
(provided by Novell).
DB2 SOFTWARE DEVELOPER'S KIT FOR WINDOWS
o The DB2 Software Developer's Kit for Windows product has the same
software requirements as DB2 Client Application Enabler for
Windows.
COMPATIBILITY: To preserve customer investments in DB2/2 and
DB2/6000 Versions 1 and 1.2, a migration facility will be included
which automatically migrates these databases to the Version 2.1
format without modifying the user data. Applications that currently
work with Versions 1 and 1.2 will continue to work without change.
DB2 for OS/2 Version 2.1 and DDCS for OS/2 Version 2.1 not
only support DB2/2 and DDCS/2 Version 1 and 1.2 applications but also
continue to maintain upward compatibility for applications that were
written to utilize the application programming interfaces in previous
releases of Extended Services database products.
o Existing databases from Extended Services (ES) Version 1.0 or ES
with Database Server can be migrated to the DB2 for OS/2
Version 2.1 environment via a migrate command or API.
o An OS/2 database client using NetBIOS or APPC can also access
down-level ES Version 1.0 database servers. Additionally, DOS
and Windows clients can access ES Version 1.0 and DB2/2
Version 1.0 database servers using NetBIOS.
o Existing 16-bit OS/2 applications written in C, COBOL, or FORTRAN
will continue to run with DB2 for OS/2 Version 2.1 without the
need for recompilation or relinking. However, although not
required, it is recommended that these applications be recompiled
and relinked to access the new DB2/2 Version 1.2 interfaces
directly in order to enhance performance.
DATA BASE : ALET PAGE: 25
LIMITATIONS: OS/2 Query Manager is no longer provided with DB2 for
OS/2. The IBM Visualizer family of products is recommended for
enhanced query support.
DB2 Version 1 clients will not be able to exploit some DB2
Version 2 interfaces. Limitations are described in the PLANNING
INFORMATION document for the platform.
PERFORMANCE CONSIDERATIONS: DB2 Version 2 has several tools to help
you manage your database performance:
o The Database System Monitor can be used to:
- Better understand how the database manager works
- Improve database and application performance
- Tune configuration parameters
- Determine the source and cause of problems
- Understand user and application activity within the database
manager
o The Database System Monitor for DDCS can aid in determining the
source of an error when using DDCS in a gateway environment.
o Visual Explain graphically shows the access plan for an SQL
statement chosen by the database manager's optimizer. With this
information, you can:
- Tune SQL statements for better performance
- Model the impact of environment changes on SQL statements
- Determine the source of problems in SQL statements
o With the Performance Monitor you can:
- Define your own statistics, in addition to the default set
provided
- Determine and analyze performance problems in the database
manager or database applications
- Tune SQL statements for better performance
- Identify exception conditions based on thresholds you define
Also provided are methods of tuning DB2 performance, including
adjusting configuration parameters, SQL optimization, directory
caching, and I/O tuning.
A sample program, DB2BATCH, is provided for benchmarking the
performance of SQL statements. This sample program provides more
accurate results than benchmarks performed with the command-line
processor since the time taken for the command-line processor
operations is not part of the results.
PLANNING INFORMATION
CUSTOMER RESPONSIBILITIES: Support for five concurrent users is
included in the basic license of DB2 for OS/2 Version 2.1 Server, DB2
for AIX Version 2.1 Server, DDCS for OS/2 Version 2.3 Multi-User
Gateway, and DDCS for AIX Version 2.3 Multi-User Gateway. DB2 SDK
for AIX includes support for one developer. Customers will need to
plan for how many users or developers will be simultaneously using
the DB2 Version 2.1 products to determine how many additional user or
developer entitlements are required. A concurrent user or developer
entitlement is required for each workstation connected to the DB2
product. Multiple connections to a single DB2 product from the same
workstation count as only one user or developer.
When ordering DB2 for AIX for installation on POWERparallel
(TM) SP2 (TM) systems, each node that operates DB2 for AIX requires a
DATA BASE : ALET PAGE: 26
separate license.
When using multiple DB2 for AIX licenses on nodes of an SP2
system or in a cluster of RS/6000 (TM) machines using HACMP/6000, the
concurrent user entitlements are permitted to float between the DB2
licenses. A separate user entitlement for each DB2 for AIX license
that a user may attach to is not required in this configuration. The
aggregate number of DB2 for AIX user entitlements must be equal to or
greater than the number of concurrent users.
SERVICES: The following fee services are available from IBM for DB2
for OS/2:
o DB2 for OS/2 Installation and Configuration Service
Installation and Configuration Service will assist the
customer by having skilled IBM resources install and configure
DB2 for OS/2 and the associated Client Application Enabler
clients. The following areas will be addressed as part of the
installation and configuration service:
- Install the DB2 for OS/2 product.
- Define and configure the DB2 for OS/2 security system.
- Modify appropriate DB2 for OS/2 Database Manager
configuration parameters.
- Migrate or create the customer's database.
- Configure and implement the desired communications protocol.
- Install and configure Client Application Enabler for
connectivity to DB2 for OS/2.
- Ensure coexistence and interoperability for DB2 for OS/2 with
LAN Server or NetWare.
- Configure ODBC (if desired).
Upon completion of this service, DB2 for OS/2 and any
Client Application Enabler clients will be installed and
configured with a customer database and available for data
loading.
o DDCS for OS/2 Installation and Configuration Service
This consulting service will help your organization
implement a tailored DDCS for OS/2 client/gateway/host
environment. During this engagement, our experts work with your
staff to plan, install, and customize DDCS for OS/2 to support
your planned usage. This service will address security options,
communication configuration, and performance-related parameters.
The following areas will be addressed as part of the
installation and configuration service:
- Installation of DDCS for OS/2 on gateway
- Tailoring of DRDA host database environment
- Tailoring of DDCS for OS/2
- Tailoring of communication software at host
- Tailoring of communication software at the gateway
- Installation of DB2 for OS/2 utility package at the host
database
- Verification of connection to the host using the DB2 for OS/2
command-line processor
- Recommendation for BIND parameters
- Demonstration of problem determination tools for DDCS for
OS/2
DATA BASE : ALET PAGE: 27
Upon completion of this service, DDCS for OS/2 will be
installed and configured to support your planned usage.
o DB2 for OS/2 Performance Tuning Service
The DB2 for OS/2 Performance Tuning Service is designed to
help the customer learn how to best utilize the database server
and network for performance. Working with the customer, a
skilled IBM resource will review the key components that impact
the performance of the DB2 for OS/2 environment.
- OS/2 System Performance -- Tune key OS/2 configuration
parameters.
- DB2 for OS/2 Configuration -- Tune Database and Database
Manager configuration parameters and review database storage
utilization.
- Application and Database Design -- Review database design
relative to performance requirements and review design of key
application programs.
- Communications Manager (CM) -- Tune key CM-related
parameters.
Upon completion of this service, an assessment of the
current database environment will be documented and given to the
customer, including recommendations on ways to improve database
performance.
o DB2 for OS/2 Design Review
The DB2 for OS/2 Design Review Service is a broad offering
tailored to address any specific issue that a customer may have
related to the use of the DB2 for OS/2 product. A design review
can cover a broad spectrum of concerns including:
- Application design
- Database design
- Data migration
- Backup/recovery strategy
- Security concerns
- Performance
As a service tailored to meet each customer's needs, the
review can be customized not only to resolve existing problems
but to help a customer develop a design that avoids problems.
o DB2 for OS/2 Advanced Backup and Recovery Service
The Advanced Backup and Recovery Service assists the
customer with designing, developing, and implementing a robust
DB2 for OS/2 recovery strategy. During the assessment of the
customer recovery needs, the following issues are discussed:
- Database manager configuration
-- Primary and secondary log files
-- Log file size and location
-- Linear vs. circular log schemes
-- Standard vs. nonstandard media
- Developing recovery processes
-- Database backup and version control
-- Log file archival and management
-- Database restore and log file retrieval
-- Roll-forward and point-in-time recovery
After completion of this service, a turnkey solution can
DATA BASE : ALET PAGE: 28
be provided based on the customer backup/recovery requirements.
CONTACT
The above services will be delivered by qualified IBM personnel such
as those in the Personal Systems Competency Center or the
Availability and Services Centers. For information and details
regarding these services, please contact the Personal Systems
Competency Center at 800-547-1283 or IBMLink (TM) ID:
DALVM41B(OS2AAC).
The following fee services are available from IBM for DB2
Version 2 UNIX platforms:
o DB2 for UNIX Planning Service
The DB2 for UNIX Planning Service will assist the customer
in developing a plan to successfully install and configure the
DBMS. Skilled technical resources from IBM will work with the
customer to step through the planning for issues key to
successful implementation. These issues include:
- Identify any hardware and software prerequisites.
- Define instance name.
- Develop a disk layout and table placement strategy.
- Determine appropriate number of log files and log file size.
- Define TCP/IP port names and numbers.
- Define a Data Definition Language development strategy.
- Define a data loading/migration strategy.
- Define any client configuration requirements.
- Define security requirements.
- Define required backup/recovery strategy.
- Identify any additional tools/utilities of value.
After completion of this Planning Service, the decisions
made will provide customers with the required information to
successfully install and configure the DBMS at their site.
o DB2 for UNIX Installation and Configuration Service
The DB2 for UNIX Installation and Configuration Service
will assist the customer by having skilled IBM technical
resources install and configure the DBMS. The following areas
will be addressed as part of this Installation and Configuration
Service:
- Install the appropriate DB2 for UNIX product.
- Create a group and a user that will be the instance owner
group.
- Create the database instance.
- Create physical database components.
- Modify appropriate Database Manager configuration parameters.
- Create the customer's database.
- Configure database logs.
- Verify Data Definition Language (tables, indexes, and so on).
- Verify data load/migration strategy.
Upon completion of this service, a DB2 for UNIX DBMS
product will be installed and configured with a customer database
defined and available for data loading.
o DB2 for UNIX Performance Tuning Service
The DB2 for UNIX Performance Tuning Service is designed to
help the customer improve the performance of an existing database
DATA BASE : ALET PAGE: 29
environment. Working with the customer, a skilled IBM resource
will perform a high-level review of three key components that
impact the performance of the DBMS environment.
o UNIX System
- Review key UNIX performance information with the customer's
UNIX system administrators.
o DBMS Configuration
- Review Database and Database Manager Configuration
parameters.
- Review database storage utilization.
o Application and Database Design
- Review database design relative to performance requirements.
- Review performance of key application programs.
- Make recommendations on database design or application
program design to improve performance.
Upon completion of this service, an assessment of the
current database environment will be presented to the customer,
including recommendations on ways to improve database
performance.
o DB2 for UNIX Design Review
The DB2 for UNIX Design Review Service is a broad offering
tailored to address any specific issue that customers may have
related to the use of their DBMS product. A design review can
cover a broad spectrum of concerns including:
- Application design
- Database design
- Data migration
- Backup/recovery strategy
- Security concerns
- Performance
As a service tailored to meet each customer's needs, the
review can be customized not only to resolve existing problems
but to help a customer develop a design that avoids problems.
The Design Review process includes specific requirements
for the customer to provide IBM with the documentation needed to
conduct the review. This documentation (specific to the
customer's issues) should be prepared by the customer and passed
to IBM for review by the review team prior to the meeting. At
the review meeting, the customer's issues will be addressed and
recommendations made to resolve these issues. At the conclusion
of the service, the design review team will provide the customer
with a report summarizing the findings and recommendations of the
design review team.
CONTACT
The AIX Support Family Project Office in Roanoke, Texas, is available
to assist customers with AIX Support Family information, contracts,
pricing, and billing information. The Project Office may be
contacted by:
o Telephone: 817-962-6902 or 800-CALL-AIX (225-5249), Option 8
o Facsimile: 817-962-6723
o IBMLink ID: DALVM41B(CALLAIX)
Office hours are from 8:00 a.m. to 6:00 p.m. central time,
DATA BASE : ALET PAGE: 30
Monday through Friday, excluding holidays. A voice mail message may
be left if calling during other hours.
CONVERSION: The DB2 for OS/2 and AIX Version 2 products are shipped
with an installation utility that must be run prior to migration of
DB2 Version 1 or 1.2 databases. The utility checks for table schema
that are invalid for DB2 Version 2.
PACKAGING: License keys are required for installation of all DB2,
DDCS, and DB2 SDK Version 2 products. A key is not required for
installation of DB2 SDK for Windows. The keys are provided in the
CD-ROM and diskette packages only.
DB2 for OS/2 Version 2 products are available on CD-ROM and/or
3.5-inch diskettes. The CD-ROM also contains softcopy publications
in BookManager READ format.
DB2 for AIX Version 2 products must be ordered on CD-ROM but a
supplementary 8-mm tape option is also available. The CD-ROM and
tape versions contain all product code as well as the Postscript and
.INF files for all publications. The key is provided with the CD-ROM
package only. Customers who choose the 8-mm tape option must also
order a CD-ROM version of the DB2 for AIX product in order to acquire
a key. The basic license for the DB2 for AIX product is provided
only in the CD-ROM package. The charge for the 8-mm tape option is
only for the media.
The pregenerated license key label is on one sheet of paper
packaged with the product. The format of the key label is as
follows:
P/N: ........ The product part number
Prd: .................. The product name
S/N: ........ The label serial number
Key: .................... The product access key
These labels are not transferable and should be kept in a
secure place. The products cannot be used until the keys are
entered. Each key label is unique (unique label serial number and
the key). If the key is lost, you can obtain a replacement key from
IBM by contacting Central Service. You will have to fax a copy of
the proof of purchase to IBM.
DB2 for OS/2, DDCS for OS/2, DB2 for AIX, and DDCS for AIX
consist of two components: the base DB2 software which executes on
the server and a Client Pack package of DB2 Client Application
Enablers which provide DB2 attachment support for a number of
workstation operating systems. The Client Pack code can be
distributed to any workstation attached to the DB2 Version 2 product.
Both components are licensed under the IPLA.
The Client Pack CD-ROM contains the most recent version of
every available Client Application Enabler. The documentation
included with the Client Pack is a User's Guide or Installation
Supplement for each client in hardcopy, BookManager, and .INF format.
Also included are 3.5-inch diskettes for those client platforms for
which diskette is the common installation medium. The contents of
the Client Pack will be refreshed as Client Application Enablers are
updated or new Client Application Enablers are developed. Customers
and remarketers will be able to acquire updates for the Client Pack
by electronic distribution.
DATA BASE : ALET PAGE: 31
The Client Application Enabler can be installed and used
without entering an access key.
A description of the DB2 Version 2 functional contents of each
available package follows:
o The DB2 Server package contains the DB2 database, client support,
administration tools, a command-line processor, and the Client
Pack. The Client Pack contains a CD-ROM, diskettes, and
publications for currently available DB2 Client Application
Enablers for all platforms. The Client Pack will also contain
the Administrator's Toolkit.
o The DB2 Single-User package contains the DB2 database,
application development tools, administration tools, an
application development command-line processor, Visual Explain,
and the Client Application Enabler for the platform. The DB2 for
OS/2 Version 2.1 Single-User package also contains the Client
Application Enablers for DOS and Windows.
o The DDCS Multi-User Gateway package contains the DRDA Application
Requestor, client support, administration tools, a command-line
processor, and the Client Pack.
o The DDCS for OS/2 Version 2.3 Single-User package contains the
DRDA Application Requestor, administration tools, a command-line
processor, and the Client Application Enablers for OS/2, DOS, and
Windows.
o The DB2 SDK package contains application development tools,
Visual Explain, administration tools, an application development
command-line processor, and the Client Application Enabler for
the platform.
One copy of the following publications is supplied
automatically with the program package for DB2 for OS/2 Version 2.1
Server:
FORM PART
TITLE NUMBER NUMBER
DB2 for OS/2 Planning Guide S20H-4784 20H4784
DB2 for OS/2 Installation
and Operation Guide S20H-4785 20H4785
DOS Client Installation
Supplement S20H-4949 20H4949
Installing & Using OS/2
Clients S20H-4782 20H4782
Installing & Using Windows
Clients S20H-4789 20H4789
One copy of the following publications is supplied
automatically with the program package for DB2 for OS/2 Version 2.1
Single-User:
FORM PART
TITLE NUMBER NUMBER
DB2 for OS/2 Planning Guide S20H-4784 20H4784
DB2 for OS/2 Installation
and Operation Guide S20H-4785 20H4785
DOS Client Installation
Supplement S20H-4949 20H4949
Installing & Using OS/2
DATA BASE : ALET PAGE: 32
Clients S20H-4782 20H4782
Installing & Using Windows
Clients S20H-4789 20H4789
Software Developer's Kit
for OS/2 Building Your
Applications S20H-4787 20H4787
One copy of the following publications is supplied
automatically with the program package for DDCS for OS/2 Version 2.3
Single-User and Multi-User Gateway:
FORM PART
TITLE NUMBER NUMBER
DDCS for OS/2 Installation
and Configuration Guide S20H-4795 20H4795
DOS Client Installation
Supplement S20H-4949 20H4949
Installing & Using OS/2
Clients S20H-4782 20H4782
Installing & Using Windows
Clients S20H-4789 20H4789
One copy of the following publications is supplied
automatically with the program package for DB2 SDK for OS/2
Version 2.1:
FORM PART
TITLE NUMBER NUMBER
Installing & Using OS/2 Clients S20H-4782 20H4782
Software Developer's Kit for
OS/2 Building Your
Applications S20H-4787 20H4787
One copy of the following publications is supplied
automatically with the program package for DB2 for AIX Version 2.1
Server:
FORM PART
TITLE NUMBER NUMBER
DB2 for AIX Planning Guide S20H-4758 20H4758
DB2 for AIX Installation
and Operation Guide S20H-4757 20H4757
DOS Client Installation
Supplement S20H-4949 20H4949
Installing & Using AIX
Clients S20H-4666 20H4666
Installing & Using OS/2
Clients S20H-4782 20H4782
Installing & Using Windows
Clients S20H-4789 20H4789
One copy of the following publications is supplied
automatically with the program package for DB2 for AIX Version 2.1
Single-User:
FORM PART
TITLE NUMBER NUMBER
DB2 for AIX Planning Guide S20H-4758 20H4758
DB2 for AIX Installation
and Operation Guide S20H-4757 20H4757
DATA BASE : ALET PAGE: 33
Installing & Using AIX
Clients S20H-4666 20H4666
Software Developer's Kit
for AIX Building Your
Applications S20H-4780 20H4780
One copy of the following publications is supplied
automatically with the program package for DDCS for AIX Version 2.3
Multi-User Gateway:
FORM PART
TITLE NUMBER NUMBER
DDCS for AIX Installation
and Configuration Guide S20H-4794 20H4794
DOS Client Installation
Supplement S20H-4949 20H4949
Installing & Using AIX
Clients S20H-4666 20H4666
Installing & Using OS/2
Clients S20H-4782 20H4782
Installing & Using Windows
Clients S20H-4789 20H4789
One copy of the following publications is supplied
automatically with the program package for DB2 SDK for AIX Version
2.1:
FORM PART
TITLE NUMBER NUMBER
Installing & Using AIX
Clients S20H-4666 20H4666
Software Developer's Kit
for AIX Building Your
Applications S20H-4780 20H4780
One copy of the following publications is supplied
automatically with the program package for DB2 SDK for Windows
Version 2.1:
FORM PART
TITLE NUMBER NUMBER
Installing & Using Windows
Clients S20H-4789 20H4789
Software Developer's Kit
for Windows Building Your
Applications S20H-4792 20H4792
The following optional publications, provided in the DB2
Version 2.1 Product Library, will be available July 28, 1995. These
DB2 Version 2.1 publications are non-platform-specific, meaning that
they can be used with either DB2 for OS/2 or DB2 for AIX Version 2.1:
FORM PART
TITLE NUMBER NUMBER
Application Programming Guide S20H-4643 20H4643
Command Reference S20H-4645 20H4645
API Reference S20H-4984 20H4984
FORM PART
TITLE NUMBER NUMBER
Administration Guide S20H-4580 20H4580
DATA BASE : ALET PAGE: 34
Database System Monitor Guide
and Reference S20H-4871 20H4871
Information and Concepts Guide S20H-4664 20H4664
Call Level Interface Guide
and Reference S20H-4644 20H4644
Messages Reference S20H-4808 20H4808
Problem Determination Guide S20H-4779 20H4779
SQL Reference S20H-4665 20H4665
IBM DDCS User's Guide S20H-4793 20H4793
DRDA Connectivity Guide SC26-4783 20H4798
An online Glossary is also provided.
SECURITY, AUDITABILITY, AND CONTROL
The announced programs use the security and auditability
features of the workstation operating system.
User management is responsible for evaluation, selection, and
implementation of security features, administrative procedures, and
appropriate controls in application systems and communication
facilities.
ORDERING ORDERING INFORMATION
Orders for new licenses will be accepted now. Shipments will
begin on the planned availability date.
To order these programs for order type, specify the order type
number, feature number, part number, program name, medium, and
quantity.
PROGRAM PACKAGE: Program medium with documentation.
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME MEDIUM
5871-AAA 0598 41H2112 DB2 for OS/2 V2.1 Single-User CD-ROM
5871-AAA 0599 41H2113 DB2 for OS/2 V2.1 Single-User 3.5
5871-AAA 0600 41H2114 DB2 for OS/2 V2.1 Server CD-ROM
5871-AAA 0601 41H2115 DB2 for OS/2 V2.1 Server 3.5
5871-AAA 0602 41H2116 DB2 for OS/2 V2.1 Entitlement
for 1 Additional User
5875-XXX 0119 41H2117 DB2 for OS/2 V2.1 Entitlement
for 5 Additional Users
5875-XXX 0120 41H2118 DB2 for OS/2 V2.1 Entitlement
for 10 Additional Users
5875-XXX 0121 41H2119 DB2 for OS/2 V2.1 Entitlement
for 50 Additional Users
5871-AAA 0603 41H2120 DDCS for OS/2 V2.3 Single-User 3.5
5871-AAA 0604 41H2121 DDCS for OS/2 V2.3 Multi-User
Gateway 3.5
5871-AAA 0605 41H2122 DDCS for OS/2 V2.3 Entitlement
for 1 Additional User
5875-XXX 0122 41H2123 DDCS for OS/2 V2.3 Entitlement
for 5 Additional Users
5875-XXX 0123 41H2124 DDCS for OS/2 V2.3 Entitlement
for 10 Additional Users
5875-XXX 0124 41H2125 DDCS for OS/2 V2.3 Entitlement
for 50 Additional Users
5871-AAA 0606 41H2126 DB2 SDK for OS/2 V2.1 3.5
DATA BASE : ALET PAGE: 35
5871-AAA 0607 41H2127 DB2 for AIX V2.1 Single-User CD-ROM
5871-AAA 0608 41H2128 DB2 for AIX V2.1 Server CD-ROM
5871-AAA 0609 41H2129 DB2 for AIX V2.1 Entitlement
for 1 Additional User
5875-XXX 0125 41H2130 DB2 for AIX V2.1 Entitlement
for 5 Additional Users
5875-XXX 0126 41H2131 DB2 for AIX V2.1 Entitlement
for 10 Additional Users
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME MEDIUM
5875-XXX 0127 41H2132 DB2 for AIX V2.1 Entitlement
for 50 Additional Users
5871-AAA 0614 41H2133 DDCS for AIX V2.3 Multi-User
Gateway CD-ROM
5871-AAA 0615 41H2134 DDCS for AIX V2.3 Entitlement
for 1 Additional User
5875-XXX 0129 41H2135 DDCS for AIX V2.3 Entitlement
for 5 Additional Users
5875-XXX 0130 41H2136 DDCS for AIX V2.3 Entitlement
for 10 Additional Users
5875-XXX 0131 41H2137 DDCS for AIX V2.3 Entitlement
for 50 Additional Users
5871-AAA 0610 41H2138 DB2 SDK for AIX V2.1 CD-ROM
5871-AAA 0611 41H2139 DB2 SDK for AIX V2.1 Entitlement
for 1 Additional Developer
5875-XXX 0128 41H2140 DB2 SDK for AIX V2.1 Entitlement
for 5 Additional Developers
5871-AAA 0613 41H2421 DB2 for AIX Products Media
Option -- 8-mm Tape 8 mm
5871-AAA 0612 41H2142 DB2 SDK for Windows V2.1 3.5
ADDITIONAL LICENSE COPIES: Authorizes the customer who has a program
package to make a single copy of the program and printed
documentation.
The authorization is given by sending the customer an invoice
for an Additional License Copy (the ICA must be in effect) or by
sending the customer a Proof of Additional License certificate (the
ICA is not required). The Proof of Additional License certificate
has its own part number and feature number.
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AAA 0301 41H2391 DB2 for OS/2 V2.1 Single-User
Additional License without Certificate
5872-AAA 0302 41H2392 DB2 for OS/2 V2.1 Server
Additional License without Certificate
5872-AAA 0303 41H2393 DB2 for OS/2 V2.1 Entitlement
for 1 Additional User
Additional License without Certificate
5872-AAA 0304 41H2394 DDCS for OS/2 V2.3 Single-User
Additional License without Certificate
5872-AAA 0305 41H2395 DDCS for OS/2 V2.3 Multi-User Gateway
DATA BASE : ALET PAGE: 36
Additional License without Certificate
5872-AAA 0306 41H2396 DDCS for OS/2 V2.3 Entitlement
for 1 Additional User
Additional License without Certificate
5872-AAA 0307 41H2397 DB2 SDK for OS/2 V2.1
Additional License without Certificate
5872-AAA 0308 41H2398 DB2 for AIX V2.1 Single-User
Additional License without Certificate
5872-AAA 0309 41H2399 DB2 for AIX V2.1 Server
Additional License without Certificate
5872-AAA 0310 41H2400 DB2 for AIX V2.1 Entitlement
for 1 Additional User
Additional License without Certificate
5872-AAA 0311 41H2401 DDCS for AIX V2.3 Multi-User Gateway
Additional License without Certificate
5872-AAA 0312 41H2402 DDCS for AIX V2.3 Entitlement
for 1 Additional User
Additional License without Certificate
5872-AAA 0313 41H2403 DB2 SDK for AIX V2.1
Additional License without Certificate
5872-AAA 0314 41H2404 DB2 SDK for AIX V2.1 Entitlement
for 1 Additional Developer
Additional License without Certificate
5872-AAA 0315 41H2405 DB2 SDK for Windows V2.1 Additional
License without Certificate
5872-AAA 0316 41H2406 DB2 for OS/2 V2.1 Single-User
Proof of Additional License Certificate
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AAA 0317 41H2407 DB2 for OS/2 V2.1 Server
Proof of Additional License Certificate
5872-AAA 0318 41H2408 DB2 for OS/2 V2.1 Entitlement
for 1 Additional User
Proof of Additional License Certificate
5872-AAA 0319 41H2409 DDCS for OS/2 V2.3 Single-User
Proof of Additional License Certificate
5872-AAA 0320 41H2410 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Certificate
5872-AAA 0321 41H2411 DDCS for OS/2 V2.3 Entitlement
for 1 Additional User
Proof of Additional License Certificate
5872-AAA 0322 41H2412 DB2 SDK for OS/2 V2.1
Proof of Additional License Certificate
5872-AAA 0323 41H2413 DB2 for AIX V2.1 Single-User
Proof of Additional License Certificate
5872-AAA 0324 41H2414 DB2 for AIX V2.1 Server
Proof of Additional License Certificate
5872-AAA 0325 41H2415 DB2 for AIX V2.1 Entitlement
for 1 Additional User
Proof of Additional License Certificate
5872-AAA 0326 41H2416 DDCS for AIX V2.3 Multi-User Gateway
DATA BASE : ALET PAGE: 37
Proof of Additional License Certificate
5872-AAA 0327 41H2417 DDCS for AIX V2.3 Entitlement
for 1 Additional User
Proof of Additional License Certificate
5872-AAA 0328 41H2418 DB2 SDK for AIX V2.1
Proof of Additional License Certificate
5872-AAA 0329 41H2419 DB2 SDK for AIX V2.1 Entitlement
for 1 Additional Developer
Proof of Additional License Certificate
5872-AAA 0330 41H2420 DB2 SDK for Windows V2.1 Proof of
Additional License Certificate
ADDITIONAL LICENSE COPIES -- VALU: When the Volume Discount Exhibit
-- Volume Additional License Usage (VALU) applies, authorization to
make additional license copies begins on the start date specified in
the Addendum for Volume Discount.
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AA2 0301 41H2391 DB2 for OS/2 V2.1 Single-User
Additional License without
Certificate -- VALU
5872-AA2 0302 41H2392 DB2 for OS/2 V2.1 Server
Additional License without
Certificate -- VALU
5872-AA2 0303 41H2393 DB2 for OS/2 V2.1 Entitlement
for 1 Additional User
Additional License without
Certificate -- VALU
5872-AA2 0304 41H2394 DDCS for OS/2 V2.3 Single-User
Additional License without
Certificate -- VALU
5872-AA2 0305 41H2395 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License without
Certificate -- VALU
5872-AA2 0306 41H2396 DDCS for OS/2 V2.3 Entitlement
for 1 Additional User
Additional License without
Certificate -- VALU
5872-AA2 0307 41H2397 DB2 SDK for OS/2 V2.1
Additional License without
Certificate -- VALU
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AA2 0308 41H2398 DB2 for AIX V2.1 Single-User
Additional License without
Certificate -- VALU
5872-AA2 0309 41H2399 DB2 for AIX V2.1 Server
Additional License without
Certificate -- VALU
5872-AA2 0310 41H2400 DB2 for AIX V2.1 Entitlement
for 1 Additional User
DATA BASE : ALET PAGE: 38
Additional License without
Certificate -- VALU
5872-AA2 0311 41H2401 DDCS for AIX V2.3 Multi-User Gateway
Additional License without
Certificate -- VALU
5872-AA2 0312 41H2402 DDCS for AIX V2.3 Entitlement
for 1 Additional User
Additional License without
Certificate -- VALU
5872-AA2 0313 41H2403 DB2 SDK for AIX V2.1
Additional License without
Certificate -- VALU
5872-AA2 0314 41H2404 DB2 SDK for AIX V2.1 Entitlement
for 1 Additional Developer
Additional License without
Certificate -- VALU
5872-AA2 0315 41H2405 DB2 SDK for Windows V2.1 Additional
License without
Certificate -- VALU
5872-AA2 0316 41H2406 DB2 for OS/2 V2.1
Single-User Proof
of Additional License
Certificate -- VALU
5872-AA2 0317 41H2407 DB2 for OS/2 V2.1 Server Proof
of Additional License
Certificate -- VALU
5872-AA2 0318 41H2408 DB2 for OS/2 V2.1 Entitlement
for 1 Additional User Proof
of Additional License
Certificate -- VALU
5872-AA2 0319 41H2409 DDCS for OS/2 V2.3
Single-User Proof
of Additional License
Certificate -- VALU
5872-AA2 0320 41H2410 DDCS for OS/2 V2.3 Multi-User
Gateway Proof
of Additional License
Certificate -- VALU
5872-AA2 0321 41H2411 DDCS for OS/2 V2.3 Entitlement
for 1 Additional User Proof
of Additional License
Certificate -- VALU
5872-AA2 0322 41H2412 DB2 SDK for OS/2 V2.1 Proof
of Additional License
Certificate -- VALU
5872-AA2 0323 41H2413 DB2 for AIX V2.1 Single-User Proof
of Additional License
Certificate -- VALU
5872-AA2 0324 41H2414 DB2 for AIX V2.1 Server Proof
of Additional License
Certificate -- VALU
5872-AA2 0325 41H2415 DB2 for AIX V2.1 Entitlement
DATA BASE : ALET PAGE: 39
for 1 Additional User Proof
of Additional License
Certificate -- VALU
5872-AA2 0326 41H2416 DDCS for AIX V2.3 Multi-User Gateway
Proof of Additional License
Certificate -- VALU
5872-AA2 0327 41H2417 DDCS for AIX V2.3 Entitlement
for 1 Additional User Proof
of Additional License
Certificate -- VALU
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AA2 0328 41H2418 DB2 SDK for AIX V2.1 Proof
of Additional License
Certificate -- VALU
5872-AA2 0329 41H2419 DB2 SDK for AIX V2.1 Entitlement
for 1 Additional Developer Proof
of Additional License
Certificate -- VALU
5872-AA2 0330 41H2420 DB2 SDK for Windows V2.1 Proof of
Additional License
Certificate -- VALU
DOCUMENTATION: Separate documentation with no media.
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5876-AAA 0014 41H2451 DB2 Version 2.1
Product Library
PROGRAM PACKAGE UPGRADE: Program medium with documentation.
Customers who purchased additional user or developer
entitlements for the following programs are authorized to use the
same number of entitlements for additional users or additional
developers on the corresponding DB2 Version 2 products:
o DB2/2 Version 1.2 Client/Server
o DDCS/2 Version 2.2 Multi-User Gateway
o DB2/6000 Version 1.2
o DDCS/6000 Version 1.2
o DB2 SDK/6000 Version 1.2
Customers of DB2/6000 Version 1 or DDCS/6000 Version 1 are
authorized to use the number of additional user entitlements on the
corresponding DB2 Version 2 products that is equivalent to the usage
level purchased with the DB2/6000 Version 1 product.
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5873-AAA 0033 41H2452 DB2 for OS/2 V2.1 Single-User from
ES 1.0, 3.5-inch diskette
5873-AAA 0034 41H2453 DB2 for OS/2 V2.1 Single-User from
ES 1.0, CD-ROM
5873-AAA 0035 41H2454 DB2 for OS/2 V2.1 Single-User from
DB2/2 V1 or V1.2 Single-User,
DATA BASE : ALET PAGE: 40
3.5-inch diskette
5873-AAA 0036 41H2455 DB2 for OS/2 V2.1 Single-User from
DB2/2 V1 or V1.2 Single-User,
CD-ROM
5873-AAA 0037 41H2456 DB2 for OS/2 V2.1 Server from DB2/2 V1
or V1.2 Client/Server, 3.5-inch diskette
5873-AAA 0038 41H2457 DB2 for OS/2 V2.1 Server from DB2/2 V1
or V1.2 Client/Server, CD-ROM
5873-AAA 0039 41H2458 DB2 for OS/2 V2.1 Server from ES 1.0
with Database Server,
3.5-inch diskette
5873-AAA 0040 41H2459 DB2 for OS/2 V2.1 Server from ES 1.0
with Database Server,
CD-ROM
5873-AAA 0041 41H2460 DB2 for OS/2 V2.1 Server from ES 1.0,
DB2/2 V1/1.2/2.1 Single-User,
3.5-inch diskette
5873-AAA 0042 41H2461 DB2 for OS/2 V2.1 Server from ES 1.0,
DB2/2 V1/1.2/2.1 Single-User,
CD-ROM
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5873-AAA 0043 41H2462 DDCS for OS/2 V2.3 Single-User from
DDCS/2 V1, V2.1, or V2.2 Single-User,
3.5-inch diskette
5873-AAA 0044 41H2463 DDCS for OS/2 V2.3 Multi-User Gateway
from DDCS/2 V1 or V2.1 Multi-User,
3.5-inch diskette
5873-AAA 0045 41H2464 DDCS for OS/2 V2.3 Multi-User Gateway
from DDCS/2 V2.2 Multi-User,
3.5-inch diskette
5873-AAA 0046 41H2465 DDCS for OS/2 V2.3 Multi-User Gateway
from DDCS/2 V1, V2.1, V2.2, or V2.3
Single-User, 3.5-inch diskette
5873-AAA 0047 41H2466 DB2 SDK for OS/2 V2.1 from DB2 SDK/2
V1 or V1.2, 3.5-inch diskette
5875-UPG 0132 41H2467 DB2 for OS/2 V2.1 Entitlement for 10
Additional Users from ES 1.0 or DB2/2 V1
Distributed Client Application Enabler
Features
5873-AAA 0048 41H2468 DB2 for AIX V2.1 Server from DB2/6000
V1 or V1.2, CD-ROM
5873-AAA 0049 41H2469 DB2 for AIX V2.1 Server from DB2 for
AIX V2.1 Single-User, CD-ROM
5873-AAA 0050 41H2470 DDCS for AIX V2.3 Multi-User Gateway from
DDCS/6000 V1 or V1.2, CD-ROM
5873-AAA 0051 41H2471 DB2 SDK for AIX V2.1 from DB2 SDK/6000
V1 or V1.2, CD-ROM
5873-AAA 0052 41H2472 DB2 SDK for Windows V2.1 from DB2 SDK/DOS
V1 or V1.2, 3.5-inch diskette
ADDITIONAL LICENSE COPY UPGRADE: Authorizes the customer who has a
DATA BASE : ALET PAGE: 41
program package upgrade to make a single copy of the program and
printed documentation.
The authorization is given by sending the customer an invoice
for an Additional License Copy Upgrade (the ICA must be in effect) or
by sending the customer a Proof of Additional License Upgrade
certificate (the ICA is not required). The Proof of Additional
License Upgrade certificate has its own part number and feature
number.
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5874-AAA 0080 41H2641 DB2 for OS/2 V2.1 Single-User
Additional License Upgrade from
ES 1.0
5874-AAA 0081 41H2642 DB2 for OS/2 V2.1 Single-User
Additional License Upgrade from
DB2/2 V1 or V1.2 Single-User
5874-AAA 0082 41H2643 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
DB2/2 V1 or V1.2 Client/Server
5874-AAA 0083 41H2644 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
ES 1.0 with Database Server
5874-AAA 0084 41H2645 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
ES 1.0, DB2/2 V1/V1.2/V2.1
Single-User
5874-AAA 0085 41H2646 DDCS for OS/2 V2.3 Single-User
Additional License Upgrade from
DDCS/2 V1, V2.1, or V2.2 Single-User
5874-AAA 0086 41H2647 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License Upgrade from
from DDCS/2 V1 or V2.1 Multi-User
5874-AAA 0087 41H2648 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License Upgrade from
DDCS/2 V2.2 Multi-User
5874-AAA 0088 41H2649 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License Upgrade from
DDCS/2 V1, V2.1, V2.2, V2.3 Single-User
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5874-AAA 0089 41H2650 DB2 SDK for OS/2 V2.1
Additional License Upgrade from
DB2 SDK/2 V1 or V1.2
5874-AAA 0090 41H2651 DB2 for AIX V2.1 Server from
Additional License Upgrade from
DB2/6000 V1 or V1.2
5874-AAA 0091 41H2652 DB2 for AIX V2.1 Server
Additional License Upgrade from
DB2 for AIX V2.1 Single-User
5874-AAA 0092 41H2653 DDCS for AIX V2.3 Multi-User Gateway
DATA BASE : ALET PAGE: 42
Additional License Upgrade from
DDCS/6000 V1 or V1.2
5874-AAA 0093 41H2654 DB2 SDK for AIX V2.1
Additional License Upgrade from
DB2 SDK/6000 V1 or V1.2
5874-AAA 0094 41H2439 DB2 SDK for Windows V2.1
Additional License Upgrade from
DB2 SDK/DOS V1 or V1.2
5874-AAA 0095 41H2655 DB2 for OS/2 V2.1 Single-User
Proof of Additional License
Upgrade from ES 1.0
5874-AAA 0130 41H3125 DB2 for OS/2 V2.1 Single-User
Proof of Additional License
Upgrade from DB2/2 V1 or V1.2
Single-User
5874-AAA 0096 41H2656 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
DB2/2 V1 or V1.2 Client/Server
5874-AAA 0131 41H3126 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
ES 1.0 with Database Server
5874-AAA 0132 41H3127 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
ES 1.0, DB2/2 V1/V1.2/V2.1
Single-User
5874-AAA 0097 41H2657 DDCS for OS/2 V2.3 Single-User
Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, or V2.2
Single-User
5874-AAA 0098 41H2658 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V1 or V2.1 Multi-User
5874-AAA 0133 41H3128 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V2.2 Multi-User
5874-AAA 0134 41H3129 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, V2.2, V2.3
Single-User
5874-AAA 0099 41H2659 DB2 SDK for OS/2 V2.1 Proof of
Additional License Upgrade from
DB2 SDK/2 V1 or V1.2
5874-AAA 0100 41H2660 DB2 for AIX V2.1 Server Proof of
Additional License Upgrade from
DB2/6000 V1 or V1.2
5874-AAA 0135 41H3130 DB2 for AIX V2.1 Server Proof of
Additional License Upgrade from
DB2 for AIX V2.1 Single-User
5874-AAA 0101 41H2661 DDCS for AIX V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/6000 V1 or V1.2
5874-AAA 0102 41H2662 DB2 SDK for AIX V2.1 Proof of
DATA BASE : ALET PAGE: 43
Additional License Upgrade from
DB2 SDK/6000 V1 or V1.2
5874-AAA 0103 41H2440 DB2 SDK for Windows V2.1 Proof of
of Additional License Upgrade
from DB2 SDK/DOS V1 or V1.2
ADDITIONAL LICENSE COPY UPGRADE -- VALU: When the Volume Discount
Exhibit -- Volume Additional License Usage (VALU) applies,
authorization to make additional license copies begins on the start
date specified in the Addendum for Volume Discount.
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5874-AA2 0080 41H2641 DB2 for OS/2 V2.1 Single-User
Additional License Upgrade from
ES 1.0 -- VALU
5874-AA2 0081 41H2642 DB2 for OS/2 V2.1 Single-User
Additional License Upgrade from
DB2/2 V1 or V1.2 Single-User -- VALU
5874-AA2 0082 41H2643 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
DB2/2 V1 or V1.2 Client/Server -- VALU
5874-AA2 0083 41H2644 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
ES 1.0 with Database Server -- VALU
5874-AA2 0084 41H2645 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
ES 1.0, DB2/2 V1 or
V1.2 Single-User -- VALU
5874-AA2 0085 41H2646 DDCS for OS/2 V2.3 Single-User
Additional License Upgrade from
DDCS/2 V1, V2.1, or V2.2 Single-User
-- VALU
5874-AA2 0086 41H2647 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License Upgrade from
from DDCS/2 V1 or V2.1 Multi-User -- VALU
5874-AA2 0087 41H2648 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License Upgrade from
DDCS/2 V2.2 Multi-User -- VALU
5874-AA2 0088 41H2649 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License Upgrade from
DDCS/2 V1, V2.1 or 2.2 Single-User -- VALU
5874-AA2 0089 41H2650 DB2 SDK for OS/2 V2.1
Additional License Upgrade from
DB2 SDK/2 V1 or V1.2 -- VALU
5874-AA2 0090 41H2651 DB2 for AIX V2.1 Server
Additional License Upgrade from
DB2/6000 V1 or V1.2 -- VALU
5874-AA2 0091 41H2652 DB2 for AIX V2.1 Server
Additional License Upgrade from
DB2 for AIX V2.1 Single-User -- VALU
5874-AA2 0092 41H2653 DDCS for AIX V2.3 Multi-User Gateway
Additional License Upgrade from
DATA BASE : ALET PAGE: 44
DDCS/6000 V1 or V1.2 -- VALU
5874-AA2 0093 41H2654 DB2 SDK for AIX V2.1
Additional License Upgrade from
DB2 SDK/6000 V1 or V1.2 -- VALU
5874-AA2 0094 41H2439 DB2 SDK for Windows V2.1
Additional License Upgrade from
DB2 SDK/DOS V1 or V1.2 -- VALU
5874-AA2 0095 41H2655 DB2 for OS/2 V2.1 Single-User
Proof of Additional License
Upgrade from ES 1.0 -- VALU
5874-AA2 0130 41H3125 DB2 for OS/2 V2.1 Single-User
Proof of Additional License
Upgrade from DB2/2 V1 or V1.2
Single-User -- VALU
5874-AA2 0096 41H2656 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
DB2/2 V1 or V1.2 Client/Server -- VALU
5874-AA2 0131 41H3126 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
ES 1.0 with Database Server -- VALU
5874-AA2 0132 41H3127 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
ES 1.0, DB2/2 V1/V1.2/V2.1
Single-User -- VALU
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5874-AA2 0097 41H2657 DDCS for OS/2 V2.3 Single-User
Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, or V2.2
Single-User -- VALU
5874-AA2 0098 41H2658 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V1 or V2.1 Multi-User -- VALU
5874-AA2 0133 41H3128 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V2.2 Multi-User -- VALU
5874-AA2 0134 41H3129 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, V2.2, V2.3
Single-User -- VALU
5874-AA2 0099 41H2659 DB2 SDK for OS/2 V2.1 Proof of
Additional License Upgrade from
DB2 SDK/2 V1 or V1.2 -- VALU
5874-AA2 0100 41H2660 DB2 for AIX V2.1 Server Proof of
Additional License Upgrade from
DB2/6000 V1 or V1.2 -- VALU
5874-AA2 0135 41H3130 DB2 for AIX V2.1 Server Proof of
Additional License Upgrade from
DB2 for AIX V2.1 Single-User -- VALU
5874-AA2 0101 41H2661 DDCS for AIX V2.3 Multi-User Gateway
Proof of Additional License Upgrade
DATA BASE : ALET PAGE: 45
from DDCS/6000 V1 or V1.2 -- VALU
5874-AA2 0102 41H2662 DB2 SDK for AIX V2.1 Proof of
Additional License Upgrade from
DB2 SDK/6000 V1 or V1.2 -- VALU
5874-AA2 0103 41H2440 DB2 SDK for Windows V2.1 Proof of
of Additional License Upgrade
from DB2 SDK/DOS V1 or V1.2 -- VALU
PROGRAM UPGRADE
The program package upgrade option allows currently licensed
users of DB2/2, DDCS/2, DB2 SDK/2, ES 1.0, ES 1.0 with Database
Server, DB2/6000, DDCS/6000, DB2 SDK/6000, and DB2 SDK/DOS products
to obtain the new function for a program upgrade charge. The program
upgrade to the DB2 for OS/2 and DB2 for AIX products will be
available July 28, 1995. Orders will be accepted after the planned
availability date. These upgrades will be available through IBM
Authorized Personal Computer Dealers and Industry Remarketers --
Personal Computers certified to market IBM Authorized Advanced
Products. The remarketer will require a Proof of License for each
upgrade ordered.
Customers can also order upgrades through the local IBM office
using the IBM Personal Computer/System Program IBM US Upgrade and
Certification Order Form included with this announcement.
The order can be placed only through the local IBM office
using the IBM Personal Computer/System Program IBM US Upgrade and
Certification Order Form included with this announcement.
The total quantity of upgrades acquired for a specific program
cannot exceed the total quantity of program packages and/or
additional licenses previously acquired for that program. Proof of
License for upgrade eligibility for additional license upgrades is a
copy of this invoice or a previously acquired Proof of Additional
License certificate.
Additional license upgrades can be entered through the local
IBM office using the IBM US Upgrade and Certification Order Form
included in this announcement or ordered through an authorized
remarketer.
TERMS AND CONDITIONS
LICENSING: The programs described in this announcement are licensed
under the terms and conditions of the IBM International Program
License Agreement. A copy of the agreement is included in the
program package.
ADDITIONAL LICENSE: The IBM Customer Agreement (ICA) must be in
effect, or a Proof of Additional License certificate must be
acquired.
LIMITED WARRANTY: Program -- Yes. Media -- Three months.
ADDITIONAL LICENSES: Yes. Media -- Not applicable.
PROGRAM SERVICES: Program services will be available until
July 31, 1997. The statement of service included with the program
describes this service.
GETTING STARTED PERIOD: A 60-day getting started period is provided
by the Personal Systems and AIX Support Lines for the first license
in an enterprise location, site, or centralized help desk.
VOLUME ORDERS: The additional licenses and additional license
DATA BASE : ALET PAGE: 46
upgrades are eligible for volume discounting under the terms of the
IBM Customer Agreement and the Exhibit for Volume Additional License
Usage. These programs are included in Category B. For information
regarding other volume orders, contact your IBM representative.
AUTHORIZATION FOR COPY AND USE ON HOME/PORTABLE COMPUTER: Not
applicable for these programs.
NATIONAL EDUCATION LICENSE FEE: A National Education License Fee
(NELF) is available under the terms and conditions of the Education
Allowance Amendment to the IBM Customer Agreement. The NELF, which
represents a 30% discount off the single unit price, is not subject
to any further discount or allowance.
CHARGES
PART ONE-TIME
NUMBER PROGRAM DESCRIPTION CHARGE
DB2 FOR OS/2 VERSION 2.1 SINGLE-USER
41H2112 Program Package, CD-ROM $ 495
41H2113 Program Package, 3.5 inches 525
41H2391 Additional License 475
41H2452 Upgrade from ES 1.0, 3.5 inches 295
41H2453 Upgrade from ES 1.0, CD-ROM 245
41H2454 Upgrade from DB2/2 V1 or V1.2, 3.5 inches 200
41H2455 Upgrade from DB2/2 V1 or V1.2, CD-ROM 170
41H2641 Additional License Upgrade
from ES 1.0 225
41H2642 Additional License Upgrade
from DB2/2 V1 or V1.2 155
41H2406 Proof of Additional License 475
41H2655 Proof of Additional License
Upgrade from ES 1.0 225
41H3125 Proof of Additional License
Upgrade from DB2/2 V1 or V1.2
Single-User 155
DB2 FOR OS/2 VERSION 2.1 SERVER
41H2114 Program Package, CD-ROM 1,995
41H2115 Program Package, 3.5 inches 2,045
41H2392 Additional License 1,895
41H2116 Entitlement for 1 Additional User 100
41H2393 Entitlement for 1 Additional User
Additional License 100
41H2117 Entitlement for 5 Additional Users 475
41H2118 Entitlement for 10 Additional Users 900
41H2119 Entitlement for 50 Additional Users 4,275
41H2456 Upgrade from DB2/2 V1 or V1.2
Client/Server, 3.5 inches 825
41H2457 Upgrade from DB2/2 V1 or V1.2
Client/Server, CD-ROM 795
41H2458 Upgrade from ES 1.0 with Database
Server, 3.5 inches 1,025
41H2459 Upgrade from ES 1.0 with Database
Server, CD-ROM 995
41H2460 Upgrade from ES 1.0, or DB2/2
V1/V1.2/V2.1 Single-User, 3.5 inches 1,700
DATA BASE : ALET PAGE: 47
41H2461 Upgrade from ES 1.0, or DB2/2
V1/V1.2/V2.1 Single-User, CD-ROM 1,650
41H2643 Additional License Upgrade
from DB2/2 V1 or V1.2
Client/Server 765
41H2644 Additional License Upgrade
from ES 1.0 with Database
Server 965
41H2645 Additional License Upgrade
from ES 1.0, or DB2/2
V1/V1.2/V2.1 Single-User 1,600
PART ONE-TIME
NUMBER PROGRAM DESCRIPTION CHARGE
41H2467 DB2 for OS/2 V2.1 Entitlement
for 10 Additional Users from ES 1.0
or DB2/2 V1 Distributed Client
Application Enabler Features $ 150
41H2407 Proof of Additional License 1,895
41H2408 Proof of Additional License
for 1 Additional User 100
41H2656 Proof of Additional License Upgrade
from DB2/2 V1 or V1.2 Client/Server 765
41H3126 Proof of Additional License Upgrade
from ES 1.0 with Database Server 965
41H3127 Proof of Additional License Upgrade
from ES 1.0, DB2/2 V1/V1.2/V2.1
Single-User 1,600
DDCS FOR OS/2 VERSION 2.3 SINGLE-USER
41H2120 Program Package, 3.5 inches 500
41H2394 Additional License 450
41H2462 Upgrade from DDCS/2 V1/V2.1/V2.2
Single-User, 3.5 inches 200
41H2646 Additional License Upgrade
from DDCS/2 V1/V2.1/V2.2
Single-User, 3.5 inches 180
41H2409 Proof of Additional License 450
41H2657 Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, or V2.2
Single-User 180
DDCS FOR OS/2 VERSION 2.3 MULTI-USER GATEWAY
41H2121 Program Package, 3.5 inches 3,995
41H2395 Additional License 3,895
41H2122 Entitlement for 1 Additional User 100
41H2396 Entitlement for 1 Additional User
Additional License 100
41H2123 Entitlement for 5 Additional Users 475
41H2124 Entitlement for 10 Additional Users 900
41H2125 Entitlement for 50 Additional Users 4,275
41H2463 Upgrade from DDCS/2 V1/V2.1
Multi-User Gateway, 3.5 inches 1,600
41H2464 Upgrade from DDCS/2 V2.2
Multi-User Gateway, 3.5 inches 1,500
DATA BASE : ALET PAGE: 48
41H2465 Upgrade from DDCS/2
V1/V2.1/V2.2/V2.3 Single-User, 3.5 inches 3,495
41H2647 Additional License Upgrade
from DDCS/2 V1/V2.1
Multi-User Gateway, 3.5 inches 1,570
41H2648 Additional License Upgrade
from DDCS/2 V2.2
Multi-User Gateway, 3.5 inches 1,470
41H2649 Additional License Upgrade
from DDCS/2 V1/V2.1/V2.2/V2.3
Single-User, 3.5 inches 3,495
41H2410 Proof of Additional License 3,895
41H2411 Proof of Additional License for
1 Additional User 100
41H2658 Proof of Additional License Upgrade
from DDCS/2 V1 or V2.1 Multi-User 1,570
41H3128 Proof of Additional License Upgrade
from DDCS/2 V2.2 Multi-User 1,470
41H3129 Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, V2.2, V2.3
Single-User 3,495
PART ONE-TIME
NUMBER PROGRAM DESCRIPTION CHARGE
DB2 SDK FOR OS/2 VERSION 2.1
41H2126 Program Package, 3.5 inches $ 295
41H2397 Additional License 265
41H2466 Upgrade from DB2 SDK/2 V1 or
V1.2, 3.5 inches 120
41H2650 Additional License Upgrade
from DB2 SDK/2 V1 or
V1.2, 3.5 inches 100
41H2412 Proof of Additional License 265
41H2659 Proof of Additional License Upgrade
from DB2 SDK/2 V1 or V1.2 100
DB2 FOR AIX VERSION 2.1 SINGLE-USER
41H2127 Program Package, CD-ROM 995
41H2398 Additional License 945
41H2413 Proof of Additional License 945
DB2 FOR AIX VERSION 2.1 SERVER
41H2128 Program Package, CD-ROM 3,750
41H2399 Additional License 3,575
41H2129 Entitlement for 1 Additional User 750
41H2400 Entitlement for 1 Additional User
Additional License 750
41H2130 Entitlement for 5 Additional Users 3,200
41H2131 Entitlement for 10 Additional Users 6,000
41H2132 Entitlement for 50 Additional Users 28,000
41H2468 Upgrade from DB2/6000 V1 or V1.2
Client/Server, CD-ROM 1,500
41H2469 Upgrade from DB2/6000 V2.1 Single-
User, CD-ROM 2,750
41H2651 Additional License Upgrade
DATA BASE : ALET PAGE: 49
from DB2/6000 V1 or V1.2
Client/Server 1,475
41H2652 Additional License Upgrade
from DB2/6000 V2.1 Single-User 2,700
41H2414 Proof of Additional License 3,575
41H2415 Proof of Additional License
for 1 Additional User 750
41H2660 Proof of Additional License
Upgrade from DB2/6000 V1 or V1.2 1,475
41H3130 Proof of Additional License
Upgrade from DB2 for AIX V2.1
Single-User 2,700
DDCS FOR AIX VERSION 2.3 MULTI-USER GATEWAY
41H2133 Program Package, CD-ROM 3,000
41H2401 Additional License 2,850
41H2134 Entitlement for 1 Additional User 600
41H2402 Entitlement for 1 Additional User
Additional License 600
41H2135 Entitlement for 5 Additional Users 2,550
41H2136 Entitlement for 10 Additional Users 4,800
41H2137 Entitlement for 50 Additional Users 22,500
41H2470 Upgrade from DDCS/6000 V1 or V1.2,
CD-ROM 1,200
41H2653 Additional License Upgrade
from DDCS/6000 V1 or V1.2,
CD-ROM 1,150
41H2416 Proof of Additional License 2,850
41H2417 Proof of Additional License
for 1 Additional User 600
41H2661 Proof of Additional License Upgrade
from DDCS/6000 V1 or V1.2 1,150
PART ONE-TIME
NUMBER PROGRAM DESCRIPTION CHARGE
DB2 SDK FOR AIX VERSION 2.1
41H2138 Program Package, CD-ROM $ 495
41H2403 Additional License 465
41H2139 Entitlement for 1 Additional Developer 295
41H2404 Entitlement for 1 Additional Developer
Additional License 265
41H2140 Entitlement for 5 Additional Developers 1,245
41H2471 Upgrade from DB2 SDK/6000 V1 or V1.2,
CD-ROM 195
41H2654 Additional License Upgrade
from DB2 SDK/6000 V1 or V1.2,
CD-ROM 165
41H2418 Proof of Additional License 465
41H2419 Proof of Additional License
for 1 Additional Developer 265
41H2662 Proof of Additional License Upgrade
from DB2 SDK/6000 V1 or V1.2 165
DB2 FOR AIX PRODUCTS MEDIA OPTION
41H2421 8-mm Tape 169
DATA BASE : ALET PAGE: 50
DB2 SOFTWARE DEVELOPER'S KIT FOR WINDOWS VERSION 2.1
41H2142 Program Package, 3.5 inches 295
41H2405 Additional License 265
41H2472 Upgrade from DB2 SDK/DOS V1 or V1.2,
3.5 inches 120
41H2439 Additional License Upgrade from
DB2 SDK/DOS V1 or V1.2, 3.5 inches 100
41H2420 Proof of Additional License 265
41H2440 Proof of Additional License Upgrade
from DB2 SDK/DOS V1 or V1.2 100
DB2 VERSION 2.1 PRODUCT LIBRARY
41H2451 Version 2.1 Hardcopy 199
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AA2 0301 41H2391 DB2 for OS/2 V2.1 Single-User
Additional License without
Certificate -- VALU
5872-AA2 0302 41H2392 DB2 for OS/2 V2.1 Server
Additional License without
Certificate -- VALU
5872-AA2 0303 41H2393 DB2 for OS/2 V2.1 Entitlement
for 1 Additional User
Additional License without
Certificate -- VALU
5872-AA2 0304 41H2394 DDCS for OS/2 V2.3 Single-User
Additional License without
Certificate -- VALU
5872-AA2 0305 41H2395 DDCS for OS/2 V2.3 Multi-User Gateway
Additional License without
Certificate -- VALU
5872-AA2 0306 41H2396 DDCS for OS/2 V2.3 Entitlement
for 1 Additional User
Additional License without
Certificate -- VALU
5872-AA2 0307 41H2397 DB2 SDK for OS/2 V2.1
Additional License without
Certificate -- VALU
5872-AA2 0308 41H2398 DB2 for AIX V2.1 Single-User
Additional License without
Certificate -- VALU
5872-AA2 0309 41H2399 DB2 for AIX V2.1 Server
Additional License without
Certificate -- VALU
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AA2 0310 41H2400 DB2 for AIX V2.1 Entitlement
for 1 Additional User
Additional License without
Certificate -- VALU
5872-AA2 0311 41H2401 DDCS for AIX V2.3 Multi-User
DATA BASE : ALET PAGE: 51
Gateway Additional License
without Certificate -- VALU
5872-AA2 0312 41H2402 DDCS for AIX V2.3 Entitlement
for 1 Additional User
Additional License without
Certificate -- VALU
5872-AA2 0313 41H2403 DB2 SDK for AIX V2.1
Additional License without
Certificate -- VALU
5872-AA2 0314 41H2404 DB2 SDK for AIX V2.1 Entitlement
for 1 Additional Developer
Additional License without
Certificate --VALU
5872-AA2 0315 41H2405 DB2 SDK for Windows V2.1 Additional
License without
Certificate -- VALU
5872-AA2 0316 41H2406 DB2 for OS/2 V2.1 Single-User
Proof of Additional License
Certificate -- VALU
5872-AA2 0317 41H2407 DB2 for OS/2 V2.1 Server
Proof of Additional License
Certificate -- VALU
5872-AA2 0318 41H2408 DB2 for OS/2 V2.1 Entitlement
for 1 Additional User Proof
of Additional License
Certificate -- VALU
5872-AA2 0319 41H2409 DDCS for OS/2 V2.3 Single-User
Proof of Additional License
Certificate -- VALU
5872-AA2 0320 41H2410 DDCS for OS/2 V2.3 Multi-User
Gateway Proof
of Additional License
Certificate -- VALU
5872-AA2 0321 41H2411 DDCS for OS/2 V2.3 Entitlement
for 1 Additional User Proof
of Additional License
Certificate -- VALU
5872-AA2 0322 41H2412 DB2 SDK for OS/2 V2.1 Proof
of Additional License
Certificate -- VALU
5872-AA2 0323 41H2413 DB2 for AIX V2.1 Single-User Proof
of Additional License
Certificate -- VALU
5872-AA2 0324 41H2414 DB2 for AIX V2.1 Server Proof
of Additional License
Certificate -- VALU
5872-AA2 0325 41H2415 DB2 for AIX V2.1 Entitlement
for 1 Additional User Proof
of Additional License
Certificate -- VALU
5872-AA2 0326 41H2416 DDCS for AIX V2.3 Multi-User
Gateway Proof of Additional License
DATA BASE : ALET PAGE: 52
Certificate -- VALU
5872-AA2 0327 41H2417 DDCS for AIX V2.3 Entitlement
for 1 Additional User Proof
of Additional License
Certificate -- VALU
5872-AA2 0328 41H2418 DB2 SDK for AIX V2.1 Proof
of Additional License
Certificate -- VALU
5872-AA2 0329 41H2419 DB2 SDK for AIX V2.1 Entitlement
for 1 Additional Developer Proof
of Additional License
Certificate -- VALU
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5872-AA2 0330 41H2420 DB2 SDK for Windows V2.1 Proof
of Additional License
Certificate -- VALU
5874-AA2 0080 41H2641 DB2 for OS/2 V2.1 Single-User
Additional License Upgrade from
ES 1.0 -- VALU
5874-AA2 0081 41H2642 DB2 for OS/2 V2.1 Single-User
Additional License Upgrade from
DB2/2 V1 or V1.2 Single-User -- VALU
5874-AA2 0082 41H2643 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
DB2/2 V1 or V1.2 Client/Server -- VALU
5874-AA2 0083 41H2644 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
ES 1.0 with Database Server -- VALU
5874-AA2 0084 41H2645 DB2 for OS/2 V2.1 Server
Additional License Upgrade from
ES 1.0, DB2/2 V1, or
V1.2 Single-User -- VALU
5874-AA2 0085 41H2646 DDCS for OS/2 V2.3 Single-User
Additional License Upgrade from
DDCS/2 V1, V2.1, or V2.2
Single-User -- VALU
5874-AA2 0086 41H2647 DDCS for OS/2 V2.3 Multi-User
Gateway Additional License Upgrade
from DDCS/2 V1 or V2.1
Multi-User -- VALU
5874-AA2 0087 41H2648 DDCS for OS/2 V2.3
Multi-User Gateway
Additional License Upgrade from
DDCS/2 V2.2 Multi-User -- VALU
5874-AA2 0088 41H2649 DDCS for OS/2 V2.3 Multi-User
Gateway Additional License Upgrade
from DDCS/2 V1, V2.1, or 2.2
Single-User -- VALU
5874-AA2 0089 41H2650 DB2 SDK for OS/2 V2.1
Additional License Upgrade from
DATA BASE : ALET PAGE: 53
DB2 SDK/2 V1 or V1.2 --VALU
5874-AA2 0090 41H2651 DB2 for AIX V2.1 Server
Additional License Upgrade from
DB2/6000 V1 or V1.2 -- VALU
5874-AA2 0091 41H2652 DB2 for AIX V2.1 Server
Additional License Upgrade from
DB2 for AIX V2.1
Single-User -- VALU
5874-AA2 0092 41H2653 DDCS for AIX V2.3 Multi-User
Gateway Additional License Upgrade
from DDCS/6000 V1 or V1.2 -- VALU
5874-AA2 0093 41H2654 DB2 SDK for AIX V2.1
Additional License Upgrade from
DB2 SDK/6000 V1 or V1.2 -- VALU
5874-AA2 0094 41H2439 DB2 SDK for Windows V2.1
Additional License Upgrade from
DB2 SDK/DOS V1 or V1.2 -- VALU
5874-AA2 0095 41H2655 DB2 for OS/2 V2.1 Single-User
Proof of Additional License
Upgrade from ES 1.0 -- VALU
5874-AA2 0130 41H3125 DB2 for OS/2 V2.1 Single-User
Proof of Additional License
Upgrade from DB2/2 V1 or V1.2
Single-User -- VALU
5874-AA2 0096 41H2656 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
DB2/2 V1 or V1.2 Client/Server -- VALU
5874-AA2 0131 41H3126 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
ES 1.0 with Database Server -- VALU
5874-AA2 0132 41H3127 DB2 for OS/2 V2.1 Server Proof of
Additional License Upgrade from
ES 1.0, DB2/2 V1/V1.2/V2.1
Single-User -- VALU
ORDER
TYPE FEATURE PART
NUMBER NUMBER NUMBER PROGRAM NAME
5874-AA2 0097 41H2657 DDCS for OS/2 V2.3 Single-User
Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, or V2.2
Single-User -- VALU
5874-AA2 0098 41H2658 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V1 or V2.1 Multi-User
-- VALU
5874-AA2 0133 41H3128 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V2.2 Multi-User -- VALU
5874-AA2 0134 41H3129 DDCS for OS/2 V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/2 V1, V2.1, V2.2, V2.3
Single-User -- VALU
DATA BASE : ALET PAGE: 54
5874-AA2 0099 41H2659 DB2 SDK for OS/2 V2.1 Proof of
Additional License Upgrade from
DB2 SDK/2 V1 or V1.2 -- VALU
5874-AA2 0100 41H2660 DB2 for AIX V2.1 Server Proof of
Additional License Upgrade from
DB2/6000 V1 or V1.2 -- VALU
5874-AA2 0135 41H3130 DB2 for AIX V2.1 Server Proof of
Additional License Upgrade from
DB2 for AIX V2.1 Single-User -- VALU
5874-AA2 0101 41H2661 DDCS for AIX V2.3 Multi-User Gateway
Proof of Additional License Upgrade
from DDCS/6000 V1 or V1.2 -- VALU
5874-AA2 0102 41H2662 DB2 SDK for AIX V2.1 Proof of
Additional License Upgrade from
DB2 SDK/6000 V1 or V1.2 -- VALU
5874-AA2 0103 41H2440 DB2 SDK for Windows V2.1 Proof of
of Additional License Upgrade
from DB2 SDK/DOS V1 or V1.2 -- VALU
ADDITIONAL LICENSES CHARGE: Customers who pay a one-time charge for
additional licenses may copy machine-readable program materials and
printed documentation previously acquired from IBM in a program
package. One copy may be made for each additional license ordered.
PROGRAM UPGRADE CHARGE: Program upgrade charges will apply for
upgrades from DB2/2 Versions 1 and 1.2, DDCS/2 Versions 1, 2.1, and
2.2, DB2 SDK/2 Versions 1 and 1.2, Extended Services 1.0, Extended
Services with Database Server 1.0, DB2/6000 Versions 1 and 1.2,
DDCS/6000 Versions 1, 2.1, and 2.2, DB2 SDK/6000 Versions 1 and 1.2,
and DB2 SDK/DOS Versions 1 and 1.2 to the new DB2 for OS/2, DB2 for
AIX, and DB2 SDK for Windows Version 2 products.
- - - E N D O F P R I N T O U T - - -