Experiences converting CLOB/BLOB to XML

Tony Andrews

Experiences converting CLOB/BLOB to XML
I am looking for some real world experiences from people that have gone
through converting CLOBs/BLOBS that

contained prior XML data to the new V9 XML data types.



What was your approach to converting? Programmatically? and why?



What kind of space issues where encountered? Did you encounter having
to execute REORGs to get the XML data compressed after

loading?



Any other specific issue encountered?





Thanks for any input.






------------------------------------------------------------------------
---------

Tony Andrews | Trainer | Application Tuning Consultant

123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 |
[login to unmask email] <mailto:[login to unmask email]>
For more information about Themis, visit www.themisinc.com






From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Harry
Garagoski
Sent: Wednesday, December 02, 2009 9:13 AM
To: [login to unmask email]
Subject: [DB2-L] Betr: Re: [DB2-L] Is this access path correct?




Hello Scott,

Sorry no difference. Same access path


Regards,

Harry Garagoski






Van:

"Hodgin, Scott" <[login to unmask email]>

Aan:

[login to unmask email]

Datum:

02-12-2009 14:49

Onderwerp:

Re: [DB2-L] Is this access path correct?

Verzonden door:

IDUG DB2-L <[login to unmask email]>



________________________________




Out of curiosity, what does the plan say when you do this?

SELECT DISTINCT COLA, COLB , COLC, COLD, COLE
FROM CM_BK
WHERE
COLF iN
(?,?)
OR
COLG IN
(?,?,?,?,?,?,?,?)

Sometimes if you have hardcodes values, you give DB2 _too much_
information


Scott Hodgin
Database Administrator, MCITP
South Carolina Farm Bureau Insurance Company
[login to unmask email] <mailto:[login to unmask email]>




________________________________


From: IDUG DB2-L [mailto:[login to unmask email]
<mailto:[login to unmask email]> ] On Behalf Of Harry Garagoski
Sent: Wednesday, December 02, 2009 8:10 AM
To: [login to unmask email]
Subject: [DB2-L] Is this access path correct?


We have a query like this on a 300.000 row table and there is a index
on COLF (unique) and on COLG (duplicate (not much))

SELECT DISTINCT COLA, COLB , COLC, COLD, COLE
FROM CM_BK
WHERE
COLF iN
('1111410007081000','1111410007081000')
OR
COLG IN
('111410009H8','111410009H81',
'111410009H0','111410009H08','111410009H081',
'111410009H0810','111410009H08100','111410009H081000')



According to the documentation : If 2 indexable predicates are
combined with an OR, the result is indexable.
All the statistics are run, but the query's acces type = R with sort
(Distinct). So it takes to long to run.


QB_PN_O M_AT_MC_I TB_IX F_UJOG_UJOG TLM_P_QBLOCK
BINDTIME
---------+---------+---------+---------+---------+---------+---------+--
-------
01 01 0 0 R 00 N CM_BK S NNNN NNNN IS SELECT
0912011622
01 02 0 3 00 N NNNN YNNN SELECT
0912011622

Has any one an idea?


Regards,

Harry Garagoski



------------------------------------------------------------------------

De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.





________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >



________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >



------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.




________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L