DB2NYTT - Newsletter from IBM DB2 Data Management Software ...

basesprocketData Management

Oct 31, 2013 (3 years and 5 months ago)


DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002


DB2 for Linux, Unix and Windows V8 är allmänt tillgänglig sedan i går, 21 nov, för internet
nedladdning. En CD med V8 kan Du få efter 27 december. Kommentarerna från betatestare är att DB2
V8 innehåller en mängd instressanta funktioner och ett avsevärt förbättrat och snabbare Java GUI.
Om Du önskar mer detaljer kring funktioner, packetering eller priser samt om Du vill ha en 90-dagars
utvärderings CD, kontaktar Du bara mig. Kom ihåg att migrera DB2-servrar till V8 innnan klienterna

Nu kan Du hitta alla årets tidigare DB2NYTT på Lennart Henängs utmärkta DB2-portal på
http://www.henfield.se/db2 Där finns dessutom ett alldeles nytt DB2 diskussionsforum på svenska.
Mer information nedan. Registrera Dig och deltag i DB2-debatten på: http://www.henfield.se/forum/

Vi var ca 25 svenskar på IDUG i Lissabon i oktober som fick höra mycket spännade ny information kring
framtiden för DB2 for zOS (DB2 vNext). Dessa presentationer kan Du hitta på:
För Din information planerar vi ett IBM DB2 Update Seminarie på IBM Kista den 4 mars, där dessa
nyheter kommer att presenteras. Du kommer att få en inbjudan men notera redan nu i kalendern.

Mats Mohlin
IBM Software Sales
S-164 92 Stockholm, Sweden
Phone: +468-793 4760 Mobile: +4670-793 4760
Mail: mats.mohlin@se.ibm.com

The document represents the author's best view at the time of writing and is subject to change. The assumptions and IBM
internal assessments in this document are based on information from press reports, industry consultants, and public statements.
They represent the opinion of the authors, not the opinion of the IBM Corporation. All other trademarks are the property of
their respective owners.

2002-11-22 Page 1 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

DB2 Announcements
IBM DB2 Universal Database V8.1 for Linux, UNIX and Windows

Nov 21, DB2 Version 8.1 became generally available. At the conclusion of a most successful beta
program, the new DB2 ships with more than 438 new functions, including:
• innovative self-managing and self-tuning capabilities;
• XML and Web Services;
• advanced performance, scalability and availability features;
• easy-to-use application development enhancements.
The new DB2 comes with simplified packaging and aggressive pricing to meet the needs of small,
medium, and large customers, and it further lowers the DB2 five-year total cost of ownership (TCO)
advantage over key a competitor.

Here are some key highlights of the new DB2:

Autonomic: The large and distributed data management systems are rapidly becoming too complex for
humans to effectively configure, manage, optimize and diagnose. New DB2 autonomic features, such as,
Configuration Advisor or Health Center, reduce the complexity of managing database systems. The self-
tuning Configuration Advisor enables database administrators (DBAs) to eliminate the need for manual
tuning of performance related parameters, enabling users to accomplish performance tuning tasks in a
matter of minutes instead of several days. The self-managing Health Center feature automatically updates
DBAs on various operational parameters, alerts them to offline situations, and advises them on required
corrective actions, resulting in higher DBA productivity, lower DBA skill requirements and efficient
system operations.

Virtual: The new DB2 federated Web Services enhanced capability enables customers to access or
consolidate distributed information through a single SQL query from other Web Service providers, as if
the information resided in DB2 itself.

Open: Continuing on its long tradition of supporting open standards, such as, SQL, Java, X/Open,
ODBC, the new DB2 has further enhanced its support for open standards, such as, XML, and Web
Services. This support enables businesses to exchange information easily within or outside of their
enterprise. XML document storage and retrieval are an integral part of the new DB2, and this support is
provided by a combination of SQL language and XML Extender enhancements.

Integrated: The new DB2 enables deep integration with leading ISV applications, such as, SAP, J.D.
Edwards, other middleware software, such as WebSphere, and system platforms, such as, Linux, to
reduce time to market and lower operating costs.

2002-11-22 Page 2 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

Robust Foundation: New DB2 advance performance features include the innovative Multidimensional
Data Clustering (MDC) feature, which improves performance of certain complex query workloads by as
much as 90 percent. Various new DB2 online utilities and availability enhancements decrease planned
outages by up to 85%. The null and default compression feature results in more than 50% disk space
savings in certain applications, furthering DB2 data scalability.

Aggressive Pricing and Simplified Packaging: The new DB2 has priced its Workgroup Server
Unlimited Edition (WSUE) aggressively for SMB market. A First Albany Corp. analyst said, "This will
take DB2 back to a 2-to-1 price advantage versus Oracle Standard Edition, which sells for $15,000 per
CPU”, as quoted in a Reuters article "IBM to slash some database prices"
The new DB2 is also shipping simplified packaging for large enterprises by merging DB2 Enterprise
Edition and DB2 Enterprise Extended Edition into one package called DB2 Enterprise Server Edition
(ESE) with a separately licensed option called DB2 Database Partitioning Feature (DPF) for database
partitioning within a single hardware server or across a cluster of hardware servers.
New features
Some of all the 438 new features in DB2 V8 were listed and described in previous DB2NYTT No 3
2002 that is available at http://www.henfield.se/db2nytt/

Below is a short summary of the new features in DB2 V8:
• Innovative Manageability
- Configuration Advisor puts the knowledge of a seasoned DBA at your fingertips
- Health Center/Monitor keeps your database functioning
- Memory Vizualizer let's you dynamically see and control DB2's memory usage
- Advisors to deliver expert advice on index and materialized query tables
- Simplified management of large scale partitioned databases
• New Levels of Integrated Information
- Federated Web Services allows combination of data from web service providers
- XML Productivity Tools simplify integrating XML
• Robust e-business Foundation
- Connection Concentrator for more user scalability
- Dynamic configuration
- In-place online reorg
- Online load
- Online storage management
- Null and default compression
- Replication enhancements
- New client architecture
• Integrated Business Intelligence.
- Multidimensional data clustering improves performance of complex queries
- Real-time and bulk scoring of data
• Enhanced Application Development Productivity
- Development Center
- WebSphere integration
- Microsoft integration

2002-11-22 Page 3 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

Statement of General Direction
IBM is restructuring and enhancing its offerings to further focus on integrating diverse and distributed
information. Some of these information integration activities are currently showcased at IBM's demo web
site - http://xperanto.dfw.ibm.com/demo/
• In particular, IBM is restructuring the federated features previously available as DB2 Relational
Connect V7.2 and DB2 Life Sciences Data Connect V7.2. These features will not be offered
directly with DB2 V8, but will be reintroduced in a subsequent announcement.
• IBM plans to release IBM DB2 Query Patroller V8 that will work with DB2 UDB V8.
• IBM intends to release DB2 Universal Database on Linux for the IBM eServer iSeries and
pSeries platforms.

All statements regarding IBM's plans, directions, and intent are subject to change or withdrawal without

More information or trial CD
If you need further details on the new DB2 features, packaging and pricing or if you want a CD with a 90
days trial version of V8, please contact me / Mats

The DB2 V8 manuals:
All the manuals, including a What’s New book be available at:
The DB2 V8 announcement letter:
DB2 V8 information:

Planned Availability Dates
• November 21, 2002 Electronic Software Delivery.
• December 27, 2002 for CD Physical Delivery.

2002-11-22 Page 4 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

IBM DB2 Connect V8.1
DB2 Connect is an industry-leading solution integrating zSeries and iSeries server data with client-server
and web applications.

DB2 Connect provides access to data sources that include DB2 servers running on OS/390, zOS,
z/VM, VSE/ESA, and OS/400 operating systems. In addition, DB2 Connect gives you access to non-
relational data such as CICS, IMS, VSAM, MQSeries, and other mainframe data sources.

The federated database function of DB2 Connect allows programmers to address multiple DB2 and
Informix Dynamic Server (IDS) databases in the same SQL statement. When used with optional
technologies delivered by the DB2 Relational Connect and DB2 Life Sciences Data Connect follow on
products (refer to Statement of Direction above), this capability is extended to databases from Oracle,
Sybase, and Microsoft.

DB2 Connect V8.1 offers:
• Performance and scalability
- New client architecture delivers greatly improved performance for ADO, ODBC, OLE DB,
DB2 CLI, JDBC and SQLJ applications
- Enhanced scalability
- Improved performance for large result set transfers
• Improved Application Availability
- Enhanced OLE DB provider provides support distributed transactions coordinated by
Microsoft Transaction Server
- Improved handling of DB2 for OS/390 subsystem outages in a datasharing environment
• Innovative Manageability
- Dynamic configuration of DB2 Connect server parameters
- Health Center/Monitor
- Memory Vizualizer
- Control Center with new features for managing DB2 for OS/390 and IMS systems
• Programmer Productivity
- Enhanced OLE DB provider offers support for LOB data types
- New Type 4 JDBC driver
- Development Center with debugging capability
- WebSphere Studio integration
- Microsoft Visual Studio integration

The announcement letter: http://isource.ibm.com/cgi-bin/goto?it=eme_announ&on=ZP020270
More information: http://www.ibm.com/software/data/db2/db2connect
Planned Availability Dates:
• November 21, 2002 for Eectronic Software delivery.
• December 27, 2002 for Physical CD Delivery.
• November 21, 2003 withdrawal of V7.2 Media and Documentation Packs

2002-11-22 Page 5 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

DB2 for z/OS and OS/390, V7 Enhanced - Development/Control Center V8
DB2 UDB for z/OS and OS/390, V7 is now enhanced with new and updated client function:
• DB2 Administration Server
- Supports administrative tasks for Development Center, Control Center and Replication
• DB2 Development Center
- Builds and deploys JAVA and SQL Stored Procedures
- Builds SQL Table functions
- Extracts data from XML documents
• DB2 Control Center -- New support for DB2 adminstrators to:
- Copy an entire DB2 subsystem
- Select and apply operations to multiple table objects
- Parallelize execution of utilities
- Provide support for DB2 UNLOAD Utility
- Generate and customize JCL for batch job execution
The announcement letter: http://isource.ibm.com/cgi-bin/goto?it=eme_announ&on=ZP020423
DB2 V8 information: http://www.ibm.com/software/data/db2/udb/
Planned Availability Date: December 27, 2002
This feature can be ordered by users of DB2 Universal Database Server for z/OS and OS/390, V7.

DB2 Warehouse Manager for z/OS V8.1
Enhancements in V8.1 of DB2 Warehouse Manager for z/OS:
• DB2 integration and exploitation
- DB2 ESE Load Support
- Integrated Control Center and Replication Center
• Extended platform support
- Warehouse Server on AIX
- Linux Agent support
• Improved performance
• Usability and functionality improvements, including
- Support wait for multiple steps
- Support select from source
- SQL Update" capability
- UPDATE target warehouse
• Information Catalog Manager enhancements
The announcement letter: http://isource.ibm.com/cgi-bin/goto?it=eme_announ&on=ZP020323
Planned Availability Date: December 27, 2002

2002-11-22 Page 6 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

IBM DB2 Everyplace V8.1
IBM DB2 Everyplace allows you to:
• Enable mobile workers to be more productive through "no boundaries" access to enterprise
applications and data
• Quickly develop leading edge mobile and embedded applications for use in the enterprise
• Enable a small footprint, high performance, multiplatform, enterprise ready, relational database, and
synchronization architecture for mobile, wireless, or embedded computing
• Select one of two Editions:
- IBM DB2 Everyplace Database Edition
- IBM DB2 Everyplace Enterprise Edition
The announcement letter: http://isource.ibm.com/cgi-bin/goto?it=eme_announ&on=ZP020364
More information and evaluation copy download: http://www.ibm.com/software/data/db2/everyplace/
Availability Date: August 30, 2002

New and Enhanced IBM Data Management Tools for DB2 and IMS
Eleven new and enhanced IBM Data Management Tools to support IMS and DB2 will be made available
this year.
• IBM Application Recovery Tool for IMS and DB2 Databases is the new name of the IBM DB2
Recovery Manager for z/OS program.
• Two new IMS licensed programs
• Three new program versions - two IMS and one DB2
• Six new program releases - four IMS, one DB2, and one supporting both IMS and DB2

Below is a short description of the new Data Propagator V8. To view the complete list of IBM Data
Management Tools, visit our Web site at: http://www.ibm.com/software/data/db2imstools

Planned Availability Dates:
Product Name Availability Date
Application Recovery Tool for IMS and DB2 V1.2 September 13, 2002
DB2 DataPropagator for z/OS, V8 ( more info below) December 6, 2002
DB2 Path Checker for z/OS, V1.2 September 27, 2002

IMS Index Builder for z/OS, V2.3 September 20, 2002
IMS Batch Backout Manager for z/OS, V1 September 20, 2002
IMS Buffer Pool Analyzer for z/OS, V1 September 20, 2002
IMS Database Control Suite for z/OS, V2.2 September 27, 2002
IMS DEDB Fast Recovery for z/OS, V2.2 October 25, 2002
IMS Performance Analyzer for z/OS, 3.2 October 25, 2002
IMS Batch Terminal Simulator for z/OS, V3 December 6, 2002
IMS Image Copy Extensions for z/OS, V2 December 6, 2002

2002-11-22 Page 7 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

DB2 DataPropagator for z/OS, V8:
The new DPROPR Version 8 includes the following enhancements:
• A new user interface is provided. The user interface for previous DataPropagator releases was the
general purpose DB2 Control Center interface. A new Replication Center User Interface is tailored
to DataPropagator.
• The Capture and Apply programs have improved flexibility and availability and support ARM in
the z/OS environment. In addition:
- Capture provides support for:
- Enhanced signaling
- Greater control over capture and recapture granularity
- More flexibility in setting up your operational environment
- Apply provides support for:
- More frequent commits
- Replicating changes to target-key columns
- Starting the Apply program so that it allows for referential integrity
• The ASNLOAD exit routine and the Replication Analyzer program have been improved and
tailored for DB2 DataPropagator V8.
• Performance and concurrency improvements include:
- Fewer joins between replication tables.
- Use of load utility enhancements to allow faster full refreshes of target tables.
- The ability for multiple Capture programs to concurrently read from the same DB2 log, data
sharing group log, or journal.
- The ability for DB2 log read to run concurrently with pruning.
• A Replication Alert Monitor that supplies automated monitoring with e-mail notification for the
Capture and Apply programs
• The ability for you to use status commands to query the status of the Capture, Apply, and Monitor
programs on demand
• A new trace facility with compact output can be stopped and started independently of Capture and
Apply execution

If you plan to migrate to DPROPR V8 please first check for the latest migration information at:
and search for migration

2002-11-22 Page 8 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

IBM DB2 Intelligent Miner for Data V8.1
IBM DB2 Intelligent Miner for Data V8.1 Supports DB2 UDB V8.1 and Provides New Visualization
Functions. DB2 IM V8.1 places increased focus on bringing the value of data mining to more business
intelligence users. Enhancements include integration with business intelligence tools. Additional business
intelligence offerings leverage product enhancements to deliver end-to-end mining solutions to the
business analyst.
Joint SAP and IBM technology pilots are underway to enable SAP users to utilize Intelligent Miner to
mine data sourced from their SAP Business Warehouse.

Enhanced capabilities of the V8 product let you:
• Analyze business information more effectively with:
- New visualizers for Associations, Tree Classification, Demographic Clustering, and Gain
- Extended data exploration
• Improve productivity through:
- Predictive Model Markup Language (PMML) model support
- Export to spreadsheet
- Copy to clipboard
- Print Visualizations
• Control costs with new scalability options:
- DB2 UDB V8.1 support
- Parallel processing support
• Take advantage of powerful resources through enhanced mining solutions:
- SAP Business Warehouse integration

The announcement letter: http://isource.ibm.com/cgi-bin/goto?it=eme_announ&on=ZP020426
DB2 IM V8 information: http://www.software.ibm.com/iminer/fordata/
Planned Availability Date: November 21, 2002: Electronic Software Delivery (eSD)
December 27, 2002: Physical Delivery

IBM DB2 OLAP Server for iSeries, V8.1
DB2 OLAP Server for iSeries, V8.1, based on Hyperion Essbase 6.5, incorporates significant
improvements in the areas of scalability, performance, ease of use, and administration.
• Combines the high performance of multidimensional OLAP with relational scalability
• Lets you exploit hardware with parallel calculation and data load
• Gives you a single point of administration for managing multiple OLAP servers
• Allows you to integrate information from multiple data sources
• Enables you to automate the discovery of atypical patterns in your cubes

The announcement letter: http://isource.ibm.com/cgi-bin/goto?it=eme_announ&on=ZP020480
Planned Availability Date: November 15, 2002, for Electronic Software Delivery
December 6, 2002, for Media Packs

2002-11-22 Page 9 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

IBM Informix Announcements
News in IBM Informix Online Version 5.2
Below are some words on interesting news in the new Online V5.2 from my Informix colleague Rickard

IBM announces the general availability of IBM Informix OnLine Extended Edition version 5.20
A new product name for two popular Informix products: Informix OnLine and Informix STAR. With this
release, IBM adds distributed computing to a proven database server at no extra cost!

Support for greater than 2 GB chunk offsets: This performance related feature allows you to utilize the
entire capacity of the disk drive without partitioning it into smaller logical devices and employing logical
volume managers. Thereby, increasing your ROI in maximizing your use of the latest computer
hardware with its larger storage capacity and saving you the cost of purchasing third party storage
management solutions.

Support for Pipe Connectivity: This allows the Rapid Application Development (RAD) tools -- such as
IBM Informix 4GL and IBM Informix SQL, version 7.31 or later -- to use pipes to communicate with
OnLine Extended Edition 5.20 servers running on the same machine, instead of having to use a TCP/IP
loopback connection with Informix Star or Informix Net. Customers who use OnLine Extended Edition
5.20 with the 7.31 tools therefore save the cost of purchasing Informix Net or Informix Star separately,
and customers who are still using the version 4.x tools can upgrade to OnLine Extended Edition 5.20 and
take advantage of the many language enhancements in the version 7.31 tools.

Finally, IBM is also announcing IBM Informix OnLine Extended Edition for Linux version 5.20:
Linux is a major platform for database and application servers. IBM Informix OnLine Extended Edition
for Linux gives you a proven, easy-to-manage database offering high performance, stability and
reliability. Together, Linux and IBM Informix OnLine Extended Edition for Linux are the building
blocks for success in e-business. For the Linux users in all of us, you will receive all of the benefits of
IBM Informix OnLine Extended Edition for the low price of $199*.

By popular demand from IIUG, IBM is also proud to announce IBM Informix OnLine Personal
Edition version 5.20. It is a single user product available only on Linux that provides all the same
functionality of IBM Informix OnLine but at an economical cost of only $49*. IBM Informix OnLine
Personal Edition allows individuals to quickly become familiar with the easy-of-use and multi-media
capability of this proven and trusted relational database management system. Individual users developing
database applications on IBM Informix OnLine Personal Edition can be assured that they can easily
export and import their finished database application to the multi-user, online transaction processing, and
reliable, IBM Informix OnLine Extended Edition.

Orders for these products can be fulfilled through IBM's Passport Advantage or by contacting your local
IBM representative.

* Prices are US process current as of November 12, 2002, exclude applicable taxes, and are subject
to change by IBM without notice. Suggested retail price, dealer prices may vary.

2002-11-22 Page 10 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

Selected IBM Informix Products Now Available through Passport Advantage

Selected Informix products have been added to the IBM Passport Advantage program to support IBM's
commitment of fully integrating Informix into the IBM Data Management family. The Passport
Advantage program enables worldwide volume licensing of software from IBM, including DB2,
WebSphere, Lotus, and Tivoli. This complete, flexible offering covers licenses and Software
Maintenance for IBM distributed products.

The following Informix products are now available through the IBM Passport Advantage offering:
• IBM Informix OnLine Extended Edition V5.2
• IBM Informix OnLine Extended Edition for Linux V5.2
• IBM Informix OnLine Personal Edition V5.2
• IBM Informix SE Personal Edition V7.25
• IBM Informix NET V5.2
• IBM Informix ESQL/C Development V5.2
• IBM Informix ESQL/C Runtime V5.2
• IBM Informix 4GL V7.31 (AIX 5.1 64-bit)
• IBM Informix SQL V7.31 (AIX 5.1 64-bit)
• IBM Informix Dynamic Server V9.30 (32/64-bit Reliant UNIX and 32-bit UnixWare)

There is some information about Online V5.2 below and information about the other products can be
found in the IBM announcement letter at:

Planned Availability Date:
• November 15, 2002 (except for IBM Informix 4GL, IBM Informix SQL, and the SCO OS)
• November 25, 2002 Electronic Delivery for IBM Informix 4GL and IBM Informix SQL
• December 6, 2002 SCO operating system only
• January 17, 2003 CD-ROM IBM Informix 4GL and IBM Informix SQL only)

2002-11-22 Page 11 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

Other news
Information about DB2 for zOS future (vNext)
Below are links to some new interesting information around DB2 for zOS. Some links are to
presentations on the next version called vNext that has been given at DB2 Technical conferences and
• Were you unable to get to recent conferences and still need the information?
• Have you had problems finding answers to your questions?
• Would you like to see hints and tips for some of the techniques you use?
• Do you want to get recent technical presentations?
Get on the web now. Click on the Support entry on your DB2 web page. We have added many hundreds
of answers to frequently asked questions and hints and tips documents.

• The URL for DB2 for z/OS page: http://www.ibm.com/software/data/db2/os390/index.html

• This is where to get all the presentations mentioned below:

• News: DB2 for z/OS: http://www.ibm.com/software/data/db2/os390/techdocs2/z01.pdf

• Overview of what we expect for DB2 zOS Vnext:

• Introduction to Vnext Catalog Changes:

• DB2 Developer Domain articles: http://www7b.boulder.ibm.com/dmdd/
Curt Cotner http://www7b.boulder.ibm.com/dmdd/library/techarticle/0209cotner/0209cotner.html
Roger Miller http://www7b.boulder.ibm.com/dmdd/library/techarticle/0206miller/0206miller.html

• DB2 for zOS support pages: http://www.ibm.com/software/data/db2/os390/support.html

• DB2 for zOS manuals. Most of the key books are just updated - October 2002.
http://www.ibm.com/software/data/db2/os390/library.html All versions
http://www.ibm.com/software/data/db2/os390/v7books.html V7 books

2002-11-22 Page 12 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

DB2 diskussionsforum på svenska!
Jag publicerar här ett mail från Lennart Henäng i sin helhet. Detta är ett mycket lovvärt och intressant
initiativ. Gör som jag, surfa dit, registreara Dig och deltag i den svenska DB2 debatten.

Som användare av DB2 har man emellanåt ett stort behov av att kommunicera med likasinnade. DB2-L
finns ju förvisso, men det är tidskrävande att följa den eftersom det är så många inlägg per dag men
också för att ganska mycket inte är relevant. Det kan ju också vara trevligt att få kommunicera på

Min förhoppning är att DB2-användare hittar hit och börjar kommunicera med varandra om problem, nya
funktioner, utvärdering av produkter, kul events, bra webbsidor osv.

Vi börjar med ett (1) forum, men om det blir ett stort intresse så är det inga problem att skapa flera. Vi får
försöka att hitta en struktur som passar allteftersom.

Som vanligt så blir forumet inget mer än vad vi gör det till, det går ju ut på att dela funderingar, frågor
och svar med varandra. Det här mailet går bara till en handfull personer som jag råkar ha mailadressen
till, så sprid gärna informationen till andra DB2are!

Adressen till forumet är : http://www.henfield.se/forum/index.php?c=2
eller enklare http://www.henfield.se/forum/ (tar dig till alla forum).

Och... kommentarer mottages gärna!

Med vänliga hälsningar
Lennart Henäng, Henfield AB

2002-11-22 Page 13 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

BI & Data Warehousing High End Competitive Analysis Report 2002
Survey.Com has published a paper called "Business Intelligence & Data Warehousing High End
Competitive Analysis Report 2002”. This report shows that some of the industry analysts have been
wrong on a few topics.

Survey Highlights:
• 147 DBAs, Systems Administrators, and executives took the survey in North America
• DB2 EEE requires 19 people to support the warehouse/mart in contrast to Teradata's 29. Teradata
hides their high support costs in the SQL programming department where industry analysts failed
to look for additional TCO costs. This refutes Teradata's position that you need fewer laborers to
support Teradata warehouses.
• DB2 EEE DBA's support 3 Terabytes of disk, Teradata DBA's 2.9 TB, and Oracle RAC DBAs
supports only 1.4TB.
• DB2 EEE warehouses average 38 CPUs, Teradata 40, Oracle 10. Oracle implementations are
relatively small, denormalized data marts suggesting a lack of scale-out capability

The FREE report can be downloaded from: http://www.survey.com/products/reports.html

You can now buy software online - directly from IBM
For the first time customers can now buy software online directly from IBM in all 4 Nordic countries. A
broad range of software products on most platforms can be bought at full price via the web. Customers
can pay with credit card and are fulfilled directly from Lotus Distribution within max. 10 days.

Pay and download immediately - will be added, making it very easy for you to retrieve the wanted
product instantly.

Check out the software catalogue on the following addresses:
The catalogue is full of small but very descriptive information about each product.

2002-11-22 Page 14 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

DB2 Alert – DB2 support info via email.
If you'd like to know about critical or pervasive DB2 technical support issues as they happen, we invite
you to subscribe to DB2 Alert. DB2 Alert is a free e-mail service that will notify you of:
• High impact pervasive (HIPER) APARs
• FixPak annoucements
• Other important technical support issues of which all DB2 distributed customers should be aware.

DB2 Alert applies to DB2 distributed (DB2 for UNIX, Linux, Windows, or OS/2) products only.

To SUBSCRIBE or UNSUBSCRIBE to DB2 Alert, please visit the DB2 Technical Support site at:
and follow the "DB2 Alert" link.

If you don't want to subscribe to DB2 Alert, you can still read about current HIPER APARs, FixPak
news, and other important DB2 annoucements on the "Support News" area of the DB2 Technical Support

2002-11-22 Page 15 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

DB2 redbooks and papers
The Redbooks home page is http://www.redbooks.ibm.com where you can read html or download the full
pdf file. To buy a paper book visit http://www.fatbrain.com and search for the title.

The below list is the result of a search on DB2 and contains some of Redbooks, Redpieces and
Redpapers published after March 2002

First a pointer to a book written by my colleague Svante Lindquist. It is 354 pages of DB2 and
WebShere tuning tips:

• DB2 UDB/WebSphere Performance Tuning Guide, SG24-6417

Then without any special order a seletion from the result of my search on DB2

• DB2 for z/OS and OS/390 Version 7 Selected Performance Topics, SG24-6894-00
• Large Objects with DB2 for z/OS and OS/390, SG24-6571
• DB2 for z/OS and OS/390 : Squeezing the Most Out of Dynamic SQL, SG24-6418
• DB2 for z/OS DM Tools for Database Administration and Change Management, SG24-6420
• Application Recovery Tool for IMS and DB2 Databases A Data Recovery Guide, SG24-6837-00
• DB2 UDB's High-Function Business Intelligence in e-business , SG24-6546-00
• The Practical Guide to DB2 Data Replication V8, SG24-6828
• DB2 OLAP Server V8.1: Using Advanced Functions, SG24-6599
• DB2 UDB Backup and Recovery with ESS Copy Services, SG24-6557
• DB2 UDB Exploitation of NAS Technology, SG24-6538
• DB2 Web Query Tool Version 1.2, SG24-6832-00
• DB2 Table Editor Tool Version 4.2, SG24-6833-00
• DB2 UDB e-business Guide, SG24-6539
• Automatic Configuration for IBM DB2 Universal Database, REDP0441

2002-11-22 Page 16 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

• DB2 Warehouse Management: High Availability and Problem Determination Guide, SG24-6544
• Setup of the DB2 Application Development Environment for Stored Procedures, REDP0183
• SAP on DB2 UDB for OS/390 and z/OS: High Availability Solution Using System Automation,
SG24-6836 http://www.redbooks.ibm.com/abstracts/sg246836.html
• SAP on DB2 UDB for OS/390 and z/OS: Implementing Application Servers on Linux for
zSeries, SG24-6847-00 http://www.redbooks.ibm.com/abstracts/sg246847.html

• Striving for Optimal Journal Performance on DB2 Universal Database for iSeries, SG24-6286
• IMS DataPropagator Implementation Guide, SG24-6838-00
• IMS Version 7 Java Update, SG24-6536-00

2002-11-22 Page 17 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

Short news from the web

• DB2 for OS/390 and z/OS V7 for distributed platform users. If you know DB2 for Linux, UNIX,
and Windows, you can leverage those skills to learn DB2 on OS/390 and z/OS. Using analogies to
DB2 distributed concepts, author Raul Chong explains the basics of mainframe concepts and
installing and administering DB2 S/390. Chong discusses application development, tools, locking and
concurrency, and much more. http://www.ibm.com/partnerworld/developer/r/n/d0327c and

• DB2 Development Center - DB2 Version 8 promises to be an exciting release for developers. Check
out the new DB2 Development Center, which is a rapid iterative development environment for
building stored procedures, user-defined functions, and more.
DB2 Development Center http://www.ibm.com/partnerworld/developer/r/n/d0327a
Additional article on new V8 tools. http://www.ibm.com/partnerworld/developer/r/n/d0327b

• DB2 V8 Enhancements in DB2 for Linux, UNIX, and Windows. If you're curious about what
"multidimensional clustering" is, Matt Huras, IBM DB2 architect, explains why you should care. He
also gives an overview of some of the other technical highlights in DB2 V8.1.

• Using Dynamic SQL and the SQLDA with DB2 Large Objects (LOBs) This tutorial gives you
step-by-step instructions for uploading and retrieving LOBs using dynamic SQL and the SQL
descriptor area (SQLDA). Sample code in C++ is used to demonstrate the techniques.

• DB2 Certification Program, registration and sample tests. Get detailed information on the DB2
Universal Database and Business Intelligence, Content Management and Informix certification tracks,
including recommended education and sample tests. Get the big picture of what it's like to take an
exam and what you need to study for View details on the registration process and test enrollment.

• Production to Development - Moving Databases. Moving a database from one system to another
can be a complex job. Wouldn't it be nice if you could move all of the database objects in one clean,
automated operation? Using DB2's backup and restore utility to move a database is the easiest way,
bar none. This article discusses how you can fully automate the movement of a production database to
a development machine in order to perform tests on the most current production data.

• Download a quick reference to Common DB2 UDB Command Line Processor (CLP)
Commands. This handy deskside reference, although not complete, can help you remember most of
the commonly used commands, especially if you are new to DB2 for Unix and Windows.

2002-11-22 Page 18 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

• DB2 add-ins for Visual Studio 6.0. Good stuff for developers in DB2 V8! The DB2 Development
Add-Ins for Visual Studio 6.0 are designed to provide database developers with server-side
development features similar to what is provided using the new DB2 Development Center, and client-
side development features such as automatic ActiveX Data Objects (ADO) code generation for your
server objects, and source control management using Visual Source Safe.

• Getting the most from hash joins on DB2 UDB for Unix, Linux and Windows. Hash joins can
significantly improve the performance of certain queries when the system is tuned properly. This
paper explains how hash join works and how to properly tune your system to be able to exploit its
potential. http://www.ibm.com/partnerworld/developer/r/n/d0330c

• An Introduction to Linux for DB2 DBAs. This article is written for Database Administrators
(DBAs) who are searching to gather specific information about configuring X Windows and
networking on Red Hat Linux 7.3 and SuSE Linux 7.3. Get an overview of general Linux
administration functions and tasks that a DBA would need to accomplish either using the command
line or a Graphical User Interface (GUI) and System Administration tools while administering DB2-
related tasks. http://www.ibm.com/partnerworld/developer/r/n/d0329a

• If Web services and DB2 are important to you, this centralized list of resources can help you stay on
top of what's new. Start out by reading Grant Hutchison's article on "DB2 Web Services - The Big
Picture." http://www.ibm.com/partnerworld/developer/r/n/d0329b

• Creating Web Services on Linux to access DB2. This tutorial walks through the process of creating
two stored procedures using CLP and the stored procedure builder and then shows you how to turn
those procedures into Web services. http://www.ibm.com/partnerworld/developer/r/n/d0325a

• JSPs, WebSphere, and DB2 on the IBM eServer zSeries. This article includes a step-by-step guide
to creating and running Java stored procedures using the WebSphere Application Server and DB2 for
the eServer, zSeries. Also included are considerations for stored procedures and EJBs.

• Creating an XML-based Customer Repository using DB2 XML Extender. This tutorial
introduces DB2 XML Extender and shows you how to set up DB2 to support an XML-based
customer repository, and how to import an existing EAR file in to the Application Developer
configuration of WebSphere Studio. It also explains the interaction between the application and
database. Finally, this tutorial demonstrates how this all works using a sample application.

• Tips for Using Emacs with DB2. See how you can use your Emacs editor to interact with DB2
easily and efficiently. This article includes information about syntax highlighting, starting an SQL
session, executing commands, and much more.

2002-11-22 Page 19 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

• DB2 7.2 and Visual Basic 6.0: Bound and Unbound ADO Forms. This article gives step-by-step
directions on how to develop DB2 applications that use bound and unbound data forms, as well as
guidance on which type of form to use for your application.

• This Paper describes IBM Information integration technology that enables integrated, real-time
access to traditional and emerging data sources,transforms information to meet the needs of business
analysts and manages data placement for performance, currency and availability. Download the pdf
from: http://www.ibm.com/partnerworld/developer/r/n/d0328a

• From Data Management to Information Integration. The boundaries that have traditionally
existed between DBMSs and other data sources are increasingly blurring, and there is a great need for
an information integration solution that provides a unified view of all of these services. This article
proposes a platform that extends a federated database architecture to support both relational and
XML as first class data models, and tightly integrates content management services, workflow,
messaging, analytics, and other enterprise application services.

• Fundamentals of IBM Federated Server and Relational Connect. Data federation is a key
component to your ability to integrate data from diverse backend data sources. This detailed guide
provides you with information to help you get started with DB2 federated capability.

• Writing a table editor Java GUI for DB2. Ever wanted a simple, user-friendly interface to
manipulate data in DB2 tables? Our authors have written a table editor GUI that you can try for
yourself, or you can just read about their experiences with coding the Java application.

• WebSphere DB2 Performance Benchmark Sample on Windows 2000. The WebSphere
Performance Benchmark Sample, a.k.a. Trade2, provides a collection of workloads for characterizing
performance of the WebSphere Application Server. This article focuses on the steps for installing
Trade2 and configuring the software. It provides an excellent starting point for those who are new to
administrating and running WebSphere applications in a WebSphere and DB2 environment.

• This performance study measures the scalability of SAP BIW with DB2 UDB EEE on a clustered
hardware architecture like IBM RS/6000 SP. The results show that SAP BIW scales well on DB2
UDB EEE. Based on good results on a single SP node, impressive performance increases are achieved
when adding additional SP nodes. http://www.ibm.com/partnerworld/developer/r/n/d0332b

• A Quick Reference for Tuning DB2 EEE. This article presents techniques for tuning DB2 Extended
Enterprise Edition (EEE), including memory usage, buffer pools, and tuning tools. Perl scripts are
provided to help you collect and analyze the DB2 snapshot data and to provide hints to improve
database performance. http://www.ibm.com/partnerworld/developer/r/n/d0319a

2002-11-22 Page 20 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

• Sample UDFs to ease migration from Oracle or Sybase. Ready to port your application from
Oracle or Sybase to DB2? This handy set of SQL UDFs can help make that move a little bit easier by
providing the same or similar functionality in DB2 for certain functions you might be using in Oracle
or Sybase. http://www.ibm.com/partnerworld/developer/r/n/d0319c

• Migrating to DB2 is easier than ever. IBM makes migrating to DB2 easy through a variety of IBM
consulting services, tools and products that ensure your switch will be as painless and quick as
possible - whether you are looking to do a wholesale migration or integrating your existing system
with IBM DB2. Check out our new migration toolkits for Microsoft SQL, Sybase and Oracle.

• Using DB2 instead of Microsoft Acces. This tutorial contains information on modifying Microsoft
Visual Basic samples to use IBM DB2 UDB as a data source instead of Microsoft Access for the
Microsoft Duwamish Books sample. http://www.ibm.com/partnerworld/developer/r/n/d0329c

• DB2 UDB for iSeries Porting Guide: SQL Server to iSeries. Use this updated guide to port your
SQL Server 2000 applications to DB2 UDB or iSeries Version 5 Release 2 (V5R2). A very brief
registration is required. http://www.ibm.com/partnerworld/developer/r/n/e0332b

• Tuning Informix DSS Queries. This article describes how he was able to use the tuning techniques
described in this article to bring the response time for one query down from 40 days to 15 minutes!
Download pdf-file from: http://www.ibm.com/partnerworld/developer/r/n/d0319d

• Informix intro to Data Fragmentation. Are you looking to increase parallelization and throughput?
Fragmentation may be the answer. Here is a simple overview that can help you make the decision on
whether fragmentation is right for you. http://www.ibm.com/partnerworld/developer/r/n/d0328c

• Informix Developer Zone: Optimizing Large Database Imports. When moving from one machine
to another, large databases can pose special challenges. This article provides a sample script that you
can modify to make the job easier and faster. http://www.ibm.com/partnerworld/developer/r/n/d0330a

• Predicate Inference in Informix Dynamic Server. This article explains how the IDS optimizer can
use query rewrite rules that infer relationships among predicates that aren't explicitly stated, making
life easier for SQL application developers. http://www.ibm.com/partnerworld/developer/r/n/d0324b

• Informix Query Directives: Examples and Analysis. Query directives offers us a world of
opportunities to directly influence the optimizer's decision upon query execution plan. Unfortunately,
not many programmers and developers pay attention to query directives and even fewer use query
directives in their SQL statements and programs. In this article, author Jianing Fan describes in detail
what query directives are and their role in query optimizing and performance and demonstrates how
they work with some concrete examples. http://www.ibm.com/partnerworld/developer/r/n/d0320a

2002-11-22 Page 21 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

DB2 Events 2003

• DB2 V8 update seminar, March 4, IBM Kista Stockhom. Invitations will be sent to
DB2NYTT subscribers.

• DB2/IMS + CICS Nordic Region Conference May 26 - 28, at Radisson SAS Hotel Århus,
Denmark http://www.gse-nordic.org/calendar.htm

• IDUG 2003--North America, May 19-23, Las Vegas, NV, USA

• DB2 and IMS Technical Conference featuring BI, Sep -Oct 2003 Location TBD

For information on IBM Technical Conferences see http://www.ibm.com/services/learning/conf

DB2 Education Classes and DB2 certifications
Är du ny som DBA inom DB2 och behöver utbilda dig i år?
2 sista DBA-kurserna i år är:
• För dig som jobbar på Unix/NT: CF21 och CF23, DB2 UDB Administration Workshop for
Unix/NT går den 9-12 december.
• För dig som jobbar inom z/OS: CF83, DB2 UDB for z/OS and OS/390 Database Administration
Workshop part 1. Denna går också den 9-12 december.

Är du säker på att du kan allt om SQL som är värt att veta?
Om inte så börja det nya året med att delta på kursen CF13SS DB2 SQL Workshop for Experinced Users
den 20-21 januari!

You can find all the detailed information for these and other Swedish DB2 classes at:
and the class schedule dates for Sweden at:

For enrollment and a more detailed agenda please see

For IBM classes in other countries: http://www.ibm.com/services/learning/global/product/dbase.html
Any questions to Anna Rödholm 08-7931403, 070-7931403 or anna_rodholm@se.ibm.com

Information about Swedish certification info at: http://www.ibm.com/services/learning/se/info/certif.shtml

2002-11-22 Page 22 of 23
DB2NYTT - Newsletter from IBM DB2 Data Management Software Sweden No. 4– 2002

Helpful DB2 Websites - now updated

IBM Data Management home: http://www.ibm.com/software/data
DB2 for z/OS home: http://www.ibm.com/software/data/db2/os390/index.html
DB2 UDB for Unix,Linux and Windows http://www-3.ibm.com/software/data/db2/udb/
DB2 UDB for Windows home: : http://www.ibm.com/software/data/db2/udb/udb-nt
IBM DM Div product Support: http://www.ibm.com/software/data/support
DB2 manuals all platforms: http://www.ibm.com/software/data/db2/library/
DB2 Unix-Widows manuals, fixp, support: http://www.ibm.com/software/data/db2/udb/winos2unix/support
DB2 Developer Domain: http://www.ibm.com/software/data/developer
DB2 portal på svenska http://www.henfield.se/db2
DB2 diskussionsforum på svenska: http://www.henfield.se/forum/index.php?c=2
DB2 White Papers: http://www.ibm.com/software/data/pubs/papers
DB2 Skill & Certification: http://www.ibm.com/software/data/db2/skills
DB2 education: http://www.ibm.com/software/data/education.html
DB2 Events Calendar: http://www.ibm.com/software/data/events
DB2 Solutions & Case Studies: http://www.ibm.com/software/data/solutions
DB2 Business Partners Solutions: http://www.ibm.com/software/data/partners/solutions
DB2 Magazine (for a free subscription): http://www.db2mag.com
DB2 UDB benchmark status: http://ibm.com/software/data/db2/benchmarks
IBM Redbooks: http://www.redbooks.ibm.com
IBM Data Management Education: http://www.ibm.com/software/data/education.html
IBM University Site: http://www.ibm.com/university/visit6
DB2 scholar program: http://www.ibm.com/software/data/highered

TPC Benchmarks: http://www.tpc.org
Ideas Int. Benchmark Gateway: http://www.ideasinternational.com/benchmark/bench.html

Siebel for Customer Relationships: http://www.ibm-siebel.com/us
DB2 with the SAP application: http://www.ibm.com/software/db2sap
DB2 with the Baan application: http://www.ibm.com/software/db2baan
DB2 with PeopleSoft applications: http://www-3.ibm.com/software/data/partners/ae1partners/peoplesoft/
Subscribe to IBM Newsletters
• The previous DB2NYTT can be found at http://www.henfield.se/db2nytt/

• A DB2 portal where you can subscribe to a DB2 Newsletter is http://www.db2times.com
• Rolf Loeben IBM Germany distributes short mails called "DB2 Hotline", with news around DB2
for OS/390. Send Rolf a mail : loeben@de.ibm.com if you want to be on his distribution list
• IBM is offering IBM eNews as an extra service for European customers. IBM eNews is an
electronic newsletter, published monthly in local language, which offers customers country
relevant information based on their specific interest areas. To subscribe for IBM eNews in the
current Scandinavian versions, please click on the relevant link below:
Sweden: http://isource.ibm.com/cgi-bin/goto?on=Sweden_Subscribe
Denmark: http://isource.ibm.com/cgi-bin/goto?on=Denmark_Subscribe
Norway: http://isource.ibm.com/cgi-bin/goto?on=Norway_Subscribe
Finland: http://isource.ibm.com/cgi-bin/goto?on=Finland_Subscribe

This DB2NYTT newsletter is informally distributed by me to DB2 friends in Sweden via e-mail.
If you want to start/stop subscription please send e-mail to mats.mohlin@se.ibm.com

2002-11-22 Page 23 of 23