DB2 Viper Testdrive - DB2 Database

Serge Rielau

ZD-Net article:

http://news.zdnet.com/2100-9593_22-6057835.html
Download:
http://www.ibm.com/software/data/db2..._download.html
Docs:
http://publib.boulder.ibm.com/infoce...w/v9/index.jsp

Enjoy
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Apr 6 '06 #1

Subscribe Reply

1366

Kiran

Just to give a brief idea, How XML in db2 is implemented as compared
to other Databases. XML in V9 DB2 is not stored as CLOB or BLOB
internally, nor shredded and stored as relational tables. XML is stored
as XML, rather as format which is in standards with w3c to enable
XQuery access to XML data. Which means that XML can be parsed by XQuery
Language (Like SQL For Relational data) and the XML file in one or more
pages in the table space, and the file is parsed only once to access
the data (because of architecture, when compared to be internal
implementation as LOBs).

What is in for App Developer is, once you store XML file in DB2 as XML
data type, you can use XQuery to access the data, can create
relational views out of XML data. Will not need complex transformations
that need to be done in application layer for manipulating the data,
most of XML manipulation can be done in Database layer.You can store
XML which adheres to some schema and hence do the checking using
database .

Another thing I feel, new for App Developer in Viper is the Label based
access control. You can define security policy for each object, even
attributes of the object (like columns in tables) and give access to
different roles.

Do check out Viper :) it has lots of autonomic features for
Administrators ..the who member management has gone for a an overhaul,
it faster, better and less maintanence.

Apr 6 '06 #2

Eric.Jones

Serge Rielau wrote:

ZD-Net article:

http://news.zdnet.com/2100-9593_22-6057835.html Download:
http://www.ibm.com/software/data/db2..._download.html Docs:
http://publib.boulder.ibm.com/infoce...w/v9/index.jsp

Enjoy Serge

Thanks for the interesting links on v9 ...

From reading the publib doc: Tutorial for native XML data store

"You can create tables with XML columns only in databases defined with the UTF-8 code set and a
compatible territory code."

But looking through the migration task(s), there is no mention of changing DB code sets.
What is the envisioned method to enable XML features into existing DB2 v8 sites?
Should a hybrid dual-DB configuration be employed, or better to first migrate v8 DBs to UTF-8 code set?
Eric

Apr 6 '06 #3

Serge Rielau

Eric.Jones wrote:

Serge Rielau wrote:
ZD-Net article:

http://news.zdnet.com/2100-9593_22-6057835.html Download:
http://www.ibm.com/software/data/db2..._download.html
Docs: http://publib.boulder.ibm.com/infoce...w/v9/index.jsp

Enjoy Serge

Thanks for the interesting links on v9 ...

From reading the publib doc: Tutorial for native XML data store

"You can create tables with XML columns only in databases defined with
the UTF-8 code set and a
compatible territory code."

But looking through the migration task(s), there is no mention of
changing DB code sets.
What is the envisioned method to enable XML features into existing DB2
v8 sites?
Should a hybrid dual-DB configuration be employed, or better to first
migrate v8 DBs to UTF-8 code set?

The strategy as I see it right now is to move to UTF-8 in the long haul.
Migration (I prefer the word upgrade myself) typically involves enabling
a DB on an old release to a new release without exploiting new features.
That's why you will find no mention in the docs on UTF-8 due to XML.
If you have existing DBs and you cannot/want not move them to UTF-8 at
this time, yet you want to start exploiting XML I would look into a
separate DB indeed.
For new applications starting of in UTF-8 may be in order.

In a future version I'd expect that a unicode db will provide a superset
of the capabilities as non-unicode and a whole sale move to UTF-8 will
be recommended in it's own right (with or without XML as added incentive)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Apr 6 '06 #4

rAinDeEr

hi Serge,

I tried to instal the new version of Db2(Viper)..But it fails
saying that I have db2 version 7 in my system and asks me to uninstal
the older version, where as I dont have dv2 v7 installed at all..i had
v8.2 which I had uninstalled long time back.
~ Tariq Rahiman

Apr 20 '06 #5

Serge Rielau

rAinDeEr wrote:

I tried to instal the new version of Db2(Viper)..But it fails
saying that I have db2 version 7 in my system and asks me to uninstal
the older version, where as I dont have dv2 v7 installed at all..i had
v8.2 which I had uninstalled long time back.

Best post your question here:
http://www-128.ibm.com/developerwork...rum=842&cat=19

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Apr 20 '06 #6

Similar topics

1519

What is viper?

by: david | last post by:

All I can see that viper adds is XML handling. Is there a list of other new features in Viper?

DB2 Database

1233

Viper and VisualBasic

by: 2803stan | last post by:

I have an application which would very much benefit from what's described as "native XML" in Viper. It is written in VB6. >From what I read, I cannot use the "Native XML" features of VIPER without converting the source code of my app to VB.NET. That cannot be done because of the cost. Have I interpreted the information available (from Boulder) correctly? Is this the end of VisualBasic support for IBM products?

DB2 Database

1072

DB2 Viper 2 Open Beta - Enjoy

by: Serge Rielau | last post by:

http://www.ibm.com/software/data/db2/9/openbeta.html -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

DB2 Database

1469

DB2 Viper 2 beta - Compatibility features, Need your help

by: Serge Rielau | last post by:

Hi folks, My fellow team mates had some extra time on their hands so we decided to spice up DB2 with a grab-bag of compatibility features. We wouldn't mind help validating the semantics match.... So for those of you blessed or cursed with a competitive DBMS here is a list of what we've added: 1. ** DUAL Always works without prefixing a schema

Microsoft SQL Server

2073

DB2 Viper 2 beta - compatibility features Feedback needed

by: Serge Rielau | last post by:

DB2 Database

1564

DB2 Viper 2 compatibility features

by: Tonkuma | last post by:

DB2 Viper 2 compatibility features http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707rielau/ It is very interesting and must be usefull. I want to know the plan when Viper 2 will be available.

DB2 Database

6526

problem in creating testdrive for yiic

by: vjayis | last post by:

hi i m just trying to learn frameworks and had started with yii. i had downloaded the files and unzipped into the root directory(htdocs) of my xampp server. and as per the documentation i created the testdrive in command line prompt using the following command yiic webapp ..\testdrive (Windows)

PHP

9619

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10261

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10103

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10038

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7460

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6713

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5482

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4007

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2850

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General