| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have an application which, among other things, needs to modify a DB2
schema via JDBC. Up until now, I have been getting along very well,
but today...
Peter Headland
|
05-30-2010 01:33 PM
Peter Headland  | 10 | 139 |
| | | PLAY CAR RACE GAMES:-
PLAY CAR RACE GAMES ON MY WEB SITE
AND ENJOY UR MIND FRESH AND U CAN
DOWN LOAD ALSO MY GAMES
VISIT ...
SUKANYA
|
05-30-2010 01:40 AM
SUKANYA | 0 | 69 |
| | | 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 11:07 AM
Tonkuma | 1 | 91 |
| | | 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 09:28 AM
Serge Rielau | 4 | 90 |
| | | 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 07:20 AM
Frederik Engelen | 5 | 66 |
| | | 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 05:24 PM
Helmut Tessarek | 3 | 66 |
| | | I don't think it's normal or expected....
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
k_rus
|
05-28-2010 10:36 AM
k_rus | 4 | 73 |
| | | With Gartner's Business Intelligence group listing In-Memory analytics
at the top of their recommended Business Intelligence requirements...
JTP PR
|
05-27-2010 08:10 AM
JTP PR | 0 | 41 |
| | | 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 04:08 AM
Helmut Tessarek | 6 | 62 |
| | | 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 03:15 AM
Mark A | 5 | 78 |
| | | 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 11:32 AM
Peter Headland | 10 | 122 |
| | | 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 10:55 AM
amar | 1 | 68 |
| | | 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 03:24 AM
Helmut Tessarek | 9 | 60 |
| | | 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 01:05 PM
Mainframe-Dinosaur | 0 | 55 |
| | | 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 07:44 AM
The Boss | 3 | 56 |
| | | 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 05:26 AM
Serge Rielau | 6 | 93 |
 | | 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 01:44 PM
sanjay kumar | 19 | 168 |
| | | 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 11:40 AM
kaka | 0 | 77 |
| | | 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 07:28 AM
Troels Arvin | 5 | 106 |
| | | 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 03:40 PM
sanjay kumar | 0 | 55 |
| | | Apply through the following link:
DB2 DBA - Distributed Database Administrator required at Morgan
Stanley, UK,...
Ekta Manglani
|
05-15-2010 05:14 AM
Ekta Manglani | 0 | 56 |
| | | 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 10:29 AM
kenfar | 2 | 95 |
| | | 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 07:07 AM
JTP PR | 0 | 41 |
| | | 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 08:03 AM
Frederik Engelen | 3 | 88 |
| | | 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-11-2010 12:50 AM
Helmut Tessarek | 1 | 64 |
| | | 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 08:12 PM
Helmut Tessarek | 4 | 85 |
| | | 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 09:29 AM
Richard | 3 | 52 |
| | | 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 09:25 AM
Richard | 4 | 77 |
| | | 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 08:36 PM
Larry | 3 | 91 |
| | | 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 02:17 PM
Pierre StJ | 2 | 67 |
| | | 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 06:16 AM
Lennart Jonsson | 3 | 75 |
| | | 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 07:45 AM
JTP PR | 0 | 47 |
| | | 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 02:35 AM
situ | 7 | 90 |
| | | 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 11:57 AM
Naresh Chainani | 2 | 77 |
| | | 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 08:40 AM
Bernard | 2 | 83 |
| | | 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 11:37 AM
Serge Rielau | 1 | 67 |
| | | 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 02:59 AM
Matthias Nicola | 1 | 68 |
| | | 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 06:01 PM
Matthias Nicola | 1 | 72 |
| | | 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 08:02 AM
JTP PR | 0 | 77 |
| | | 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 02:30 AM
Mark A | 2 | 68 |
| | | 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 02:30 AM
scv1977 | 2 | 62 |
| | | 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 01:48 AM
Will Honea | 0 | 66 |
| | | 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-28-2010 12:30 AM
Serge Rielau | 3 | 66 |
| | | 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 03:03 AM
Norbert Munkel | 2 | 64 |
| | | 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 12:04 PM
Tonkuma | 2 | 84 |
| | | 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 06:54 AM
JTP PR | 0 | 37 |
| | | 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 03:00 AM
scv1977 | 5 | 64 |
| | | 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 12:01 PM
Charity | 0 | 78 |
| | | 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 07:06 AM
Willem Fischer | 3 | 74 |
| | | 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 07:42 AM
Bruce | 11 | 120 |
