BENEFITS OF V7.1 VS 6.1 
Author Message
 BENEFITS OF V7.1 VS 6.1
Hello,
I am debating on whether or not to begin testing upgrading from v6.1 to
v7.1. First, i would like to know what the benefits to me would be by
upgrading on the client side and server side? Is the performance better
compared to v 6.1?  More reliable? More utilities? What problems might I
encounter from the upgrade?

Thanks,
Mike McNeer



Mon, 03 Feb 2003 03:00:00 GMT
 BENEFITS OF V7.1 VS 6.1

Well, the best way to find out is reading the What's New section, of
course...
Here is my list of favorites (I'm sure Blair and others can add to
that):

SQL Procdeures,
nested store procedures,
save points,
temporary tables,
identity columns,
generated materialized columns,
SQL functions,
nested structured datatypes with inheritance,
better OLAP support (moving aggregates, tools).

And a lot more...

Cheers
Serge



Mon, 03 Feb 2003 03:00:00 GMT
 BENEFITS OF V7.1 VS 6.1
Some more v7.1 advantages:
   - Java stored procs can be reloaded without stopping and startig the
database.
   - You can call stored procs from the CLP command line.
   - Rank() function
   - Bidirectional cursors

On Thu, 17 Aug 2000 14:00:08 GMT esteemed mike did'st hold forth thusly:

Quote:
> Hello,
> I am debating on whether or not to begin testing upgrading from v6.1 to
> v7.1. First, i would like to know what the benefits to me would be by
> upgrading on the client side and server side? Is the performance better
> compared to v 6.1?  More reliable? More utilities? What problems might I
> encounter from the upgrade?

> Thanks,
> Mike McNeer




Mon, 03 Feb 2003 03:00:00 GMT
 BENEFITS OF V7.1 VS 6.1

Check this out!

To:   Server Product Support




















This is the happy meal version of the most important new features of DB2
Version 7.1.  See the manuals or your IBM rep for the full story.  I hope
you find this helpful.  Please pass it along to anyone else you know who
might be interested in the new version of DB2.  This is generally available
now FYI.

Information on Version 7.1 of DB2 features:

1.   New functionality in the control center and command center makes both
of these products more useful and easier to use in many ways.  This
includes features which make the command center friendlier and adds
features like SQL Assist which help you build SELECT, UPDATE, INSERT, and
DELETE statements.
2.   XML documents may be stored as a new data type
3.   The stored procedure builder has been enhanced to allow you to call
and test stored procedures from the command line
4.   A Java class loader has been added so Java Procedures can be refreshed
without a database restart
5.   Nested stored procedure support (you can call a stored procedure from
within a stored procedure)
6.   DB2 OLAP starter kit comes with version 7.1 allowing you to start
setting up and processing multi-dimensional OLAP tables
7.   Heterogeneous Distributed Query allows you to query across any DB2
family database or OLE DB source (access to multiple data sources in a
single SQL statement).
8.    The additional (read: extra charge) Relational Connect feature allows
you to include Oracle databases in a heterogeneous distributed query
9.    ODBC queries can be converted to static SQL providing a performance
improvement in this area
10.   User temporary tables can be defined by an application and used by an
application within a single connection.  These tables will disappear after
the application disconnects.
11.   You can create structured data types (for example, an employee data
type which has within it either base data or other (nested) structured
types.  DB2 now provides a transform function to work with these data types
(to translate between structured types and base data types).
12.   Data Base Propagator Relational (DPROPR replication) now comes with
an API that can be called from an application for more flexibility in
designing replication solutions.
13.  Full native OLE DB support as both a data provider and consumer  \
14.  Identity columns support.  This is a feature which allows you to
declare a column as an identity column and it will generate an ensured
unique value when an insert is done.  This type of column may be used to
generate a unique primary key.  This is basically the same as the Oracle
serial data type.
15.  New Database Administration function additions include:
    a.   the ability to force the currently active log to close and be
archived
    b.   online backup will automatically close and archive the active log
so you'll have the online backup plus all logs required to restore a
database
    c.    size of log files increased from a maximum of 4gb to a maximum of
32 gb.  Buy your DASD now!
    d.  You can now rename an existing tablespace.
16.   LOAD authority can now be granted to run the load utility without
granting SYSADM or DBADM authority.
 17.  USE OF TABLESPACE authority can be granted such that a user can be
granted the privilege of creating tables in only the tablespaces where you
give them permission to create tables
18.  Some add-ons which provide additional functionality to version 7 can
be purchased.  These include:
    a.  DB2 Warehouse Manager - This product provides a whole set of tools
you can use to help you set up a data warehouse/data marts.  It includes a
metadata (business information) catalog which can be used to help a user
find the information they need for decision making.  It has query governing
and workload distribution components.  It comes with sets of Java stored
procedures and used defined functions which can be used for data
transformation (e.g. cleaning dirty data, generating warehouse keys, etc.)
It comes with the industrial strength QMF for Windows which is an
easy-to-use query tool which can be used for business reports, data
sharing, application development, etc.  It also comes with the DB2 Query
Patroller which allows you to manage, govern, and schedule business
analysis queries and govern resources for better utilization.
    b. DB2 Relational Connect - This product allows you to access data from
Oracle databases and DB2 databases together within a single query.
Multiple DB2 and Oracle databases can be accessed in the single query with
this product installed.
    c.  DB2 now offers DB2 Workgroup edition on all platforms
    d.  DB2 OLAP Server Version 7 gives you full DB2 OLAP functionality for
those who need a full strength OLAP database.  The DB2 OLAP starter kit
gives you a taste of this for free with DB2 version 7 but if you have very
complex OLAP requirements you can buy this more functional version.

That's a summary of most of the important new features of DB2 version 7.1.
I hope this gives each of you some ideas as to how you might want to use
this functionality with your database-oriented systems.  I'll take credit
for any typos or errors of substance.  I just had the class and thought I'd
do this while it was fresh in my mind.



Mon, 03 Feb 2003 03:00:00 GMT
 BENEFITS OF V7.1 VS 6.1
v7 was used for all the TPC-C and TPC-H benchmarks we have published.
Internal performance tests also indicate that v7 is faster.

v7 is also supported until 12/2002 (versus 12/2001 for v6).

Quote:

> Hello,
> I am debating on whether or not to begin testing upgrading from v6.1 to
> v7.1. First, i would like to know what the benefits to me would be by
> upgrading on the client side and server side? Is the performance better
> compared to v 6.1?  More reliable? More utilities? What problems might I
> encounter from the upgrade?

> Thanks,
> Mike McNeer




Mon, 03 Feb 2003 03:00:00 GMT
 BENEFITS OF V7.1 VS 6.1
Calling stored procs from the CLP! Yeah when they work! Had loads of
problems
calling procs from the CLP, *always* work from an App, sometimes they work
from the
CLP most of the time though they error complaining about not enough parms
and expecting
0 parms!
 Apart from that though, I am in the process of upgrading our dev machines
to 7.1 lots of very
nice new features :)

Ant


Quote:

> Check this out!

> To:   Server Product Support




















> This is the happy meal version of the most important new features of DB2
> Version 7.1.  See the manuals or your IBM rep for the full story.  I hope
> you find this helpful.  Please pass it along to anyone else you know who
> might be interested in the new version of DB2.  This is generally
available
> now FYI.

> Information on Version 7.1 of DB2 features:

> 1.   New functionality in the control center and command center makes both
> of these products more useful and easier to use in many ways.  This
> includes features which make the command center friendlier and adds
> features like SQL Assist which help you build SELECT, UPDATE, INSERT, and
> DELETE statements.
> 2.   XML documents may be stored as a new data type
> 3.   The stored procedure builder has been enhanced to allow you to call
> and test stored procedures from the command line
> 4.   A Java class loader has been added so Java Procedures can be
refreshed
> without a database restart
> 5.   Nested stored procedure support (you can call a stored procedure from
> within a stored procedure)
> 6.   DB2 OLAP starter kit comes with version 7.1 allowing you to start
> setting up and processing multi-dimensional OLAP tables
> 7.   Heterogeneous Distributed Query allows you to query across any DB2
> family database or OLE DB source (access to multiple data sources in a
> single SQL statement).
> 8.    The additional (read: extra charge) Relational Connect feature
allows
> you to include Oracle databases in a heterogeneous distributed query
> 9.    ODBC queries can be converted to static SQL providing a performance
> improvement in this area
> 10.   User temporary tables can be defined by an application and used by
an
> application within a single connection.  These tables will disappear after
> the application disconnects.
> 11.   You can create structured data types (for example, an employee data
> type which has within it either base data or other (nested) structured
> types.  DB2 now provides a transform function to work with these data
types
> (to translate between structured types and base data types).
> 12.   Data Base Propagator Relational (DPROPR replication) now comes with
> an API that can be called from an application for more flexibility in
> designing replication solutions.
> 13.  Full native OLE DB support as both a data provider and consumer  \
> 14.  Identity columns support.  This is a feature which allows you to
> declare a column as an identity column and it will generate an ensured
> unique value when an insert is done.  This type of column may be used to
> generate a unique primary key.  This is basically the same as the Oracle
> serial data type.
> 15.  New Database Administration function additions include:
>     a.   the ability to force the currently active log to close and be
> archived
>     b.   online backup will automatically close and archive the active log
> so you'll have the online backup plus all logs required to restore a
> database
>     c.    size of log files increased from a maximum of 4gb to a maximum
of
> 32 gb.  Buy your DASD now!
>     d.  You can now rename an existing tablespace.
> 16.   LOAD authority can now be granted to run the load utility without
> granting SYSADM or DBADM authority.
>  17.  USE OF TABLESPACE authority can be granted such that a user can be
> granted the privilege of creating tables in only the tablespaces where you
> give them permission to create tables
> 18.  Some add-ons which provide additional functionality to version 7 can
> be purchased.  These include:
>     a.  DB2 Warehouse Manager - This product provides a whole set of tools
> you can use to help you set up a data warehouse/data marts.  It includes a
> metadata (business information) catalog which can be used to help a user
> find the information they need for decision making.  It has query
governing
> and workload distribution components.  It comes with sets of Java stored
> procedures and used defined functions which can be used for data
> transformation (e.g. cleaning dirty data, generating warehouse keys, etc.)
> It comes with the industrial strength QMF for Windows which is an
> easy-to-use query tool which can be used for business reports, data
> sharing, application development, etc.  It also comes with the DB2 Query
> Patroller which allows you to manage, govern, and schedule business
> analysis queries and govern resources for better utilization.
>     b. DB2 Relational Connect - This product allows you to access data
from
> Oracle databases and DB2 databases together within a single query.
> Multiple DB2 and Oracle databases can be accessed in the single query with
> this product installed.
>     c.  DB2 now offers DB2 Workgroup edition on all platforms
>     d.  DB2 OLAP Server Version 7 gives you full DB2 OLAP functionality
for
> those who need a full strength OLAP database.  The DB2 OLAP starter kit
> gives you a taste of this for free with DB2 version 7 but if you have very
> complex OLAP requirements you can buy this more functional version.

> That's a summary of most of the important new features of DB2 version 7.1.
> I hope this gives each of you some ideas as to how you might want to use
> this functionality with your database-oriented systems.  I'll take credit
> for any typos or errors of substance.  I just had the class and thought
I'd
> do this while it was fresh in my mind.



Mon, 03 Feb 2003 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Using ADSM (TSM) To Restore for V5.2 (Solaris) to V7.1 (Redhat 6.1)

2. DB2/UDB/Windows 6.1 vs 5.1 and bind against remote DB2/VSE db

3. Performance: DB2 6.1 vs MSSQL 7

4. DB2 6.1 that ships with Redhat 6.1

5. DB2 6.1 that ships with Redhat 6.1

6. benefits of moving to V7 tables ?

7. Benefits of multiple databases vs one database with many tables

8. Benefits of SQL Cluster vs Compaq RSO

9. Benefits of multiple databases vs one database with many tables

10. Benefits of using ADOR vs. ADO

11. Costs/Benefits of Sybase mirroring vs (HP) Unix mirroring

12. Pervasive.SQL vs Btrieve 6.10 question


 
Powered by phpBB® Forum Software