| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I was just playing the xmlgroup function, and i have a table with 70
columns and 10 million rows. I just gave the following query
Query :
====
select...
Arun Srini
|
05-29-2010 10:07 AM
Tonkuma  | 1 | 92 |
| | | For those of you busily enabling those Oracle applications to DB2 things
are getting (even) easier:
1. DBMS_DDL.WRAP() and...
Serge Rielau
|
05-29-2010 08:28 AM
Serge Rielau | 4 | 91 |
| | | Hi all,
DB2 LUW V9.5 Fp5.
I would like to transform a result set in a XML output.
Using my statement, I've got this result set...
brunoalsantos
|
05-29-2010 06:20 AM
Frederik Engelen | 5 | 69 |
| | | Actually I mean harder :)
Can someone tell what setups (directories,permissions,environment
variables,public key,ssh install...) are needed ?
On my...
Richard
|
05-28-2010 04:24 PM
Helmut Tessarek | 3 | 67 |
| | | I don't think it's normal or expected....
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
k_rus
|
05-28-2010 09:36 AM
k_rus | 4 | 75 |
| | | With Gartner's Business Intelligence group listing In-Memory analytics
at the top of their recommended Business Intelligence requirements...
JTP PR
|
05-27-2010 07:10 AM
JTP PR | 0 | 48 |
| | | Hi!
I have installed version 9.5.5 of db2 runtime client.
I previously had 9.1 server installed. drop the old instance and recreated a new.
I have...
danfan46
|
05-27-2010 03:08 AM
Helmut Tessarek | 6 | 65 |
| | | Are: DPF, MDC and TP (table level partitioning intro in version 9),
are they mutually exclusive ? That is if you create either a DPF or
MDC or TP...
Richard
|
05-26-2010 02:15 AM
Mark A | 5 | 82 |
| | | I am using DB2 Express 9.7 on Windows, trying to write SQL UDFs that
use CTEs.
This works in a UDF:
RETURN WITH r ( c ) AS (SELECT c FROM t);
This...
Peter Headland
|
05-22-2010 10:32 AM
Peter Headland | 10 | 127 |
| | | I'm inserting a CLOB using batch update. If the size of the CLOB
exceeds 32k, I'm getting a -102. Is there a way of inserting larger
CLOBs in a SQL...
dhroller
|
05-21-2010 09:55 AM
amar | 1 | 72 |
| | | I'm using the CLP on a Windows XP machine, DB2 ESE 9.5. I connect to
the SAMPLE database and issue the following command :
db2 select * from proj...
Morch
|
05-21-2010 02:24 AM
Helmut Tessarek | 9 | 64 |
| | | When we cut over from Version 7 to 8 of DB2 you can now put a date as
‘MM/DD/YYYY’ (USA format) in SQL SPUFI and it was accepted as a valid
date,...
Mainframe-Dinosaur
|
05-20-2010 12:05 PM
Mainframe-Dinosaur | 0 | 60 |
| | | We're running DB2 V9.1.0.4 on AIX 5.3. We're receiving this message
in db2diag.log.
2010-05-19-09.47.14.651270-240 I1089667A438 LEVEL:...
Richard
|
05-20-2010 06:44 AM
The Boss | 3 | 57 |
| | | I'm Running on DB2 9.5/AIX, currently involved in Migration from Ora
to DB2.
In oracle i've following statement.
CREATE INDEX ITEM_IDX ON...
situ
|
05-20-2010 04:26 AM
Serge Rielau | 6 | 94 |
 | | Hello,
How does a use efficiently move a table between tablespaces, given that
the user doesn't have shell access to the server hosting the...
Troels Arvin
|
05-19-2010 12:44 PM
sanjay kumar | 19 | 172 |
| | | HADR is failing during online backup. the stand by goes in the
Remote catchup pending while backup is in progress on primary. once
backup is...
kaka
|
05-19-2010 10:40 AM
kaka | 0 | 79 |
| | | Hello,
For a while, I've followed a strategy of moving away from raw devices,
and to use automatic storage - in order to simplify database...
Troels Arvin
|
05-19-2010 06:28 AM
Troels Arvin | 5 | 107 |
| | | You can find pdfs by IBM. Search for 730 preperation series, you should find the relevant material. And it's more than good for...
sanjay kumar
|
05-18-2010 02:40 PM
sanjay kumar | 0 | 56 |
| | | Apply through the following link:
DB2 DBA - Distributed Database Administrator required at Morgan
Stanley, UK,...
Ekta Manglani
|
05-15-2010 04:14 AM
Ekta Manglani | 0 | 57 |
| | | I'm running into an odd problem - I'd like to disable a user-
maintained MQT in db2 9.7.
The online documentation for db2 9.7 has been enhanced to...
kenfar
|
05-13-2010 09:29 AM
kenfar | 2 | 96 |
| | | The evolution of reporting and analytics has seen dramatic changes in
recent years. Starting with static “green bar” reports in the mid-to-
late...
JTP PR
|
05-12-2010 06:07 AM
JTP PR | 0 | 51 |
| | | Hello,
Let's say I have a large table which includes an row with values
generated from a sequence, i.e. ever-increasing values (BIGINTs); the row
is...
Troels Arvin
|
05-11-2010 07:03 AM
Frederik Engelen | 3 | 89 |
| | | This may sound like a silly question, but can someone please explain
what I need in order to be able to access my DB2 database, residing on
my XP pc...
Fin
|
05-10-2010 11:50 PM
Helmut Tessarek | 1 | 65 |
| | | We are in process of upgrading from DB2 8 to DB2 9 on AIX. AIX is
running 64-bit kernel and DB2 8.2 is running 32-bit. Our application s
also 32-bit...
shahhe@gmail.com
|
05-08-2010 07:12 PM
Helmut Tessarek | 4 | 88 |
| | | We're testing some new software, Maximo, which is a java application
that connects to our DB2 database. The DB2 version is 9.1 FP4.
We've been...
Richard
|
05-08-2010 08:29 AM
Richard | 3 | 56 |
| | | I was told to run this command to fix an issue we're having in a dev
environment.
db2 connect to my-db
db2 bind @db2cli.lst blocking all grant...
Richard
|
05-08-2010 08:25 AM
Richard | 4 | 78 |
| | | Hi,
I'm getting acquainted with Federated data. In this context I've a
question. On LUW I can create nicknames for tables on DB2 for zOS .
What is...
chuck
|
05-06-2010 07:36 PM
Larry | 3 | 92 |
| | | Hello,
Does DB2 keep checksums of data, such as data page checksums, extent
checksums, etc? - Or is it solely up to the file system or...
Troels Arvin
|
05-05-2010 01:17 PM
Pierre StJ | 2 | 69 |
| | | 9.5 LUW
Is it possible to determine whether a table is in reorg pending state,
if so how? (before one encounters either SQL0668N or...
Lennart Jonsson
|
05-05-2010 05:16 AM
Lennart Jonsson | 3 | 77 |
| | | Yellowfin is set to redefine what BI users and IT Departments will
expect from Business Intelligence vendors
Leading Business Intelligence software...
JTP PR
|
05-04-2010 06:45 AM
JTP PR | 0 | 56 |
| | | I have a huge table and I have the following requirement :
Table1
---------
client
day_of_sale
qty
Table2
---------
same ddl
Arun Srini
|
05-04-2010 01:35 AM
situ | 7 | 93 |
| | | Hello Experts,
Is it possible to execute runstats only on a specific partition of a
partitioned table in the database? Looking for an equivalent of...
Puneet
|
05-03-2010 10:57 AM
Naresh Chainani | 2 | 79 |
| | | In the UDB V9.7 Fixpack 1 the Lock wait event is included.
Is this performance/bottlebeck assesment capability retrofitted in DB2
9.5 also and if...
Bernard
|
05-03-2010 07:40 AM
Bernard | 2 | 85 |
| | | Hi!
I have the following build problem with UDF creating the following.
The simplified text does the following:
1> MSSQL2005 UDF
CREATE FUNCTION...
scv1977
|
05-02-2010 10:37 AM
Serge Rielau | 1 | 68 |
| | | Hi
I'm currently conversioning mssql to DB2(V9.7 Fix1)
The MSSQL has sources(SP,Function,XML Parsing)
In the SP(MSSQL) source, exists...
scv1977
|
05-01-2010 01:59 AM
Matthias Nicola | 1 | 69 |
| | | Hi
I have the following build problem with CODE executing the following.
The simplified code does the following(SQL16012N)
The Sample code is the...
scv1977
|
04-30-2010 05:01 PM
Matthias Nicola | 1 | 77 |
| | | Yellowfin Business Intelligence is offering customers,industry
professionals, developers, OEMS and Vendors a chance to get a walk
through of the new...
JTP PR
|
04-29-2010 07:02 AM
JTP PR | 0 | 78 |
| | | Does SYSPROC.ADMIN_COPY_SCHEMA (used to change schema names) work in a DPF
environment? Are the files exported and reloaded with DEL format (not IXF)?
Mark A
|
04-28-2010 01:30 AM
Mark A | 2 | 69 |
| | | Hi
Also conerting MSSQL to DB2(9.7),
We have problem...
I know ..
In the DB2(9.7), The MSSQL(sp_executesql) is possible to "execute
immediate"
But...
scv1977
|
04-28-2010 01:30 AM
scv1977 | 2 | 67 |
| | | Is there a simple mechanism to directly import dBase data files (V4, best I
can tell) directly into DB2 tables (V9.7)? I don't really want...
Will Honea
|
04-28-2010 12:48 AM
Will Honea | 0 | 68 |
| | | Hi,
I have a query that runs fine with SQL Server but gives me an
exception with DB2
Part of the query using join operator and the ON clause...
mark
|
04-27-2010 11:30 PM
Serge Rielau | 3 | 67 |
| | | Hi,
I need to run an old DB2 V8-Database on Power7. Our Oracle-Team told me
they needed special patches to run their O 11 on Power7. Am I going...
Norbert Munkel
|
04-27-2010 02:03 AM
Norbert Munkel | 2 | 66 |
| | | Hi!
I have the following build problem with UDF creating the following.
The simplified text does the following:
1> MSSQL2005 UDF
CREATE FUNCTION...
scv1977
|
04-26-2010 11:04 AM
Tonkuma | 2 | 90 |
| | | Yellowfin has released its latest Business Intelligence Whitepaper,
this time on "In-memory Analytics"
* No signup or email handover required, just...
JTP PR
|
04-26-2010 05:54 AM
JTP PR | 0 | 40 |
| | | Hi
I have the following build problem with SQL executing the following.
(Conversion MSSQL to DB2)
The simplified code does the...
scv1977
|
04-26-2010 02:00 AM
scv1977 | 5 | 65 |
| | | Hi please subscribe to the below newsgroup provider, they are excellent, have good retention, 20 connections, SSL etc etc and if you subscribe via...
Charity
|
04-25-2010 11:01 AM
Charity | 0 | 86 |
| | | Hi,
don't know how to call this... It's not circular references, rather
references where you have multiple paths between two tables,...
Willem Fischer
|
04-25-2010 06:06 AM
Willem Fischer | 3 | 82 |
| | | Hi all -
Running AIX 6, UDB 9.1.4.
Other than referring to the db2inst1.nfy log is there anyway to know
if a table has been created with 'not...
Bruce
|
04-23-2010 06:42 AM
Bruce | 11 | 134 |
| | | Leading web-based BI provider, Yellowfin, will unveil their milestone
5.0 release in May 2010. This release includes significant
enhancements;...
JTP PR
|
04-22-2010 08:40 AM
JTP PR | 0 | 47 |
| | | Good morning
My question is about Filesystem configuration on HP UX for DB2.
Is there any known "Best Practice" o special configuration for...
FM
|
04-22-2010 02:46 AM
FM | 2 | 78 |
