| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I found this post
http://groups.google.ca/group/comp.d...5694324f276587
which sounds very promising, but I'd like a more explicit example.
That is, I...
helmuterik
|
11-21-2011 09:17 AM
Lennart Jonsson  | 6 | 7 |
| | | My employer will be upgrading from DB2 LUW v8.2 to DB2 LUW v9.7 as
part of a Websphere Commerce migration. I have been asked about pros
vs cons of...
C Huntoon
|
11-18-2011 05:15 PM
juraj.hrapko@gmail.com | 4 | 5 |
| | | Hello,
There is a project at my company to migrate a large, critical
application from DB2 Z/OS to either SQL Server or DB2 LUW. I would
assume that...
jdokos
|
11-16-2011 02:30 AM
Helmut Tessarek | 1 | 2 |
| | | I'm looking to obtain the CPU usage and I/O usage for a query prior to
execution. The output from Visual Explain gives me exactly what I
want,...
Wendy
|
11-14-2011 11:38 AM
Wendy | 2 | 3 |
| | | I am seeking the client setup for DB2 on Windows 95
Is there somebody who knows where i can find these
Marten
mar.houweninge@wxs.nl
|
11-08-2011 03:36 PM
TheBoss | 2 | 3 |
| | | I am trying to get the admin_move_table command to work to move a
table from one tablespace to another. Got it to work on a simple dummy
table, but...
esmith2112
|
11-07-2011 08:46 PM
Naresh Chainani | 4 | 5 |
| | | fyi...
http://www.ibm.com/developerworks/data/bestpractices/workloadmanagement/
This is not an update of the original DB2 Workload Management best...
Helmut Tessarek
|
11-07-2011 12:57 PM
Helmut Tessarek | 0 | 1 |
| | | Simplified scenario:
with T (prio, status, credit, limit) as (
values (1,0,10,15), (2,1,2,15), (3,0,10,15),
(4,0,1,15), (5,1,10,15)
)
select prio,...
Lennart Jonsson
|
11-07-2011 03:25 AM
Lennart Jonsson | 10 | 11 |
| | | I have problems with configuring oracle database gateway for drda
One of the steps in this process is (according to the manuel) is...
marten@nowhere.invalid
|
11-06-2011 06:22 PM
TheBoss | 2 | 3 |
| | | So I have a potential bug in DB2 9.7 FP3a and am curious for some
feedback before opening a PMR.
To reproduce:
create table test1.table (c1...
Ian
|
11-05-2011 07:01 AM
Gilroy Gonsalves | 3 | 4 |
| | | DB2 V9R7.3
DB is automated storage
Does autoresize happen when running reorg offline with no tempspace
assigned?
If container cannot hold the copy of...
Pierre StJ
|
11-04-2011 07:41 PM
Helmut Tessarek | 3 | 4 |
| | | Hello,
I have a question about inserting XML data constructed from relational
data. I don't understand why an explicit XMLSERIALIZE of the...
Frederik Engelen
|
10-28-2011 03:51 AM
Henrik Loeser | 4 | 5 |
| | | http://www.ibm.com/support/docview.wss?uid=swg24031181
On the SQL front here are the highlights:
* Nested complex types support
That is multi...
Serge Rielau
|
10-27-2011 05:01 PM
Serge Rielau | 0 | 1 |
| | | Hi all -
DB2 for LUW 9.1.4...on AIX 6...
Going through a PeopleSoft migration..about 3600 tables...big boss
wants us to do a runstats AFTER a...
Bruce
|
10-27-2011 12:12 PM
Frederik Engelen | 4 | 5 |
| | | In Information...
Kiran Hariharan
|
10-25-2011 08:59 PM
Helmut Tessarek | 6 | 7 |
| | | As Task Center is deprecated as of version 9.7 for LUW I will now
start to find a replacement. Does anybody have any ideas of what I
should look...
OddB
|
10-25-2011 12:56 PM
Helmut Tessarek | 2 | 3 |
| | | Top research and analyst firm, Gartner, has added fuel to the argument
that Mobile Business Intelligence (BI) is set to become the primary
method for...
Jan
|
10-23-2011 08:48 AM
Jan | 0 | 1 |
| | | On our development node the instance owner is 'itgmsv9'.
On our production node the instance owner is 'db2tgms'.
When I restored a production backup...
Chris Briel
|
10-20-2011 01:38 PM
Chris Briel | 11 | 12 |
| | | Yellowfin, the leader in easy-to-use Business Intelligence (BI), has
been recognized in Gartner’s annual Who’s Who in Mobile BI report. The
2011...
Jan
|
10-18-2011 08:28 AM
Jan | 0 | 1 |
| | | Hello,
I need some help and advise on how to write a query in order to
allocate parts in stock to purchase orders.
Suppose you have in stock...
Massimiliano Campagnoli
|
10-14-2011 10:43 PM
--CELKO-- | 9 | 10 |
| | | Hello all,
DB2 LUW V9.5 Fp 7.
I´m looking for a software to make the data dictionary from my
database.
Has someone a tip about a good software to...
Bruno Almeida
|
10-13-2011 08:38 PM
Helmut Tessarek | 1 | 2 |
| | | Hi,
I am migrating my application from MSSQL to DB2. I had some issues
with JDBC/data type, but i was able to fix those issue except this
one.
When...
Biswa
|
10-07-2011 05:37 AM
Biswa | 2 | 3 |
| | | Hello, can somebody help me with my problem?
The subj. I've installed DB2 9.7 on Windows 7 64 and am trying to
connect to it using ODBC. I also...
Vyacheslav Pak
|
10-06-2011 07:45 AM
MarkB | 1 | 2 |
| | | Article Link
http://www.yellowfinbi.com/YFCommunityNews-Benefits-of-Mobile-Business-Intelligence-Part-Two-108062
Brief
Aberdeen Group on Mobile...
Jan
|
10-06-2011 06:41 AM
Jan | 0 | 1 |
| | | when tried to redirect restore a database with table compression enabled, found that too much storage needed than expected.
the backup image (backup...
Yonghang Wang
|
09-30-2011 03:28 PM
Yonghang Wang | 0 | 1 |
| | | values(CURRENT DECFLOAT ROUNDING MODE);
set current decfloat rounding mode round_half_even;
with t1 (sw1,total,amount) as
(
values (...
Bernard
|
09-29-2011 10:34 AM
Bernard | 1 | 2 |
| | | The integration of Web 2.0 and social media style features into
Business Intelligence (BI) applications – and other corporate
technologies and...
Jan
|
09-29-2011 07:37 AM
Jan | 0 | 1 |
| | | Hello All ,
The transaction log gets filled up by some unknown application. We
recieve the below message in the db2diag.log
There is no application...
Gladiator
|
09-19-2011 06:26 AM
stefan.albert | 3 | 4 |
| | | Hi DBAs,
We are facing an issue. when we tried to load some data from JVM
application to some tables, after loading we found that the table...
kavin
|
09-17-2011 04:27 AM
Lennart Jonsson | 1 | 2 |
| | | Hello,
We would like to inform you that we have updated our list with the
following new titles.
You can contact us directly at...
stu.p24
|
09-16-2011 12:18 AM
carlos martina | 2 | 3 |
| | | Hi all,
DB2 V9.5 Fixpack 7 LUW.
My company got a application that receives a lot of information about
softwares installed in desktops ( 80k...
Bruno Almeida
|
09-15-2011 03:57 PM
TheBoss | 6 | 7 |
| | | The following command to create a 14.6 GB tablespace took 19 minutes
to run. This strikes me as very slow. What are your experiences?
CREATE LARGE...
Desmodromic
|
09-14-2011 06:01 PM
TheBoss | 13 | 14 |
| | | Dear folks,
My company got a time critical DB2 system which got some complaints on
SQL delay recently. After investigation, it is found that the...
Guest
|
09-12-2011 02:40 PM
Helmut Tessarek | 3 | 4 |
| | | Dear folks,
My company got a time critical DB2 system which got some complaints on
SQL delay recently. After investigation, it is found that the...
Guest
|
09-11-2011 01:49 PM
Helmut Tessarek | 1 | 2 |
| | | Global Business Intelligence (BI) vendor, Yellowfin, as been invited
to present at the inaugural UK Open Source BI User Group Event in
London,...
Jan
|
09-06-2011 09:46 PM
Jan | 0 | 1 |
| | | Hi friends,
Trainings on SAN administration will be conducted from 12th of
september
interseted candidates can visit our office for further quires...
praveen.j@rrootshell.com
|
09-03-2011 06:45 AM
praveen.j@rrootshell.com | 0 | 1 |
| | | Hello,
Yonghang Wang wrote:
Linux.
I found a way to GRANT: If I use upper-case, it works:
GRANT select ON some.table TO USER "FOO.BAR"
--
Troels Arvin
|
09-02-2011 01:47 PM
Will Honea | 3 | 4 |
| | | CEO of Yellowfin's talks at 'The New World of Data' conference on the
tactical use of big data
Video Link
http://www.youtube.com/watch?v=5VK11WBco2Q
Jan
|
09-01-2011 09:47 AM
Jan | 0 | 1 |
| | | suppose I have a result set which contains data needed to be inserted
into a db2 tables, the obvious options are:
1. insert every row by a INSERT
2....
Yonghang Wang
|
08-31-2011 09:34 PM
Yonghang Wang | 7 | 8 |
| | | db2 udb 9.7.4 on AIX,
I have revoked dbadm/CREATE_NOT_FENCED/IMPLICIT_SCHEMA from pubilc and
user, but still they can create procedures.
db2 => ...
Anwei Shen
|
08-30-2011 02:51 PM
Anwei Shen | 2 | 3 |
| | | How can I force an SQL query to perform a full table scan rather than
use an index? I also need to obtain the number of rows in the table,
so all I...
Desmodromic
|
08-29-2011 03:14 PM
Manoj Sutar | 8 | 9 |
| | | Specifically, I want to know what new error codes were added in DB2 v9.7 that weren't in 9.5, as well as what were removed (if any) or changed...
ChrisC
|
08-29-2011 07:49 AM
Serge Rielau | 1 | 2 |
| | | Hi, I have a question
Have
PERFDATA Table
DAY PROG ENV CPU
01 P1 DEV 52
01 P1 DEV 52
02 P2 DEV 40
user
|
08-27-2011 11:05 AM
user | 2 | 3 |
| | | Time to Tee up and play Yellowfin's 18 design don't for effective
Dashboard design course.
The Front Nine:
Use flashy visuals and chart types when...
Jan
|
08-27-2011 08:18 AM
Jan | 0 | 1 |
| | | Db2 9.1 FP4
Optim is showing sorts per minute of 400,000. Is that a good thing.
This is a heavily used system and the cpu is very low most of the...
db2 dba
|
08-24-2011 04:14 PM
Yonghang Wang | 1 | 2 |
| | | WATCH WORLD`S MOST BEAUTIFUL CITY SCAPE...
rabia
|
08-24-2011 01:53 AM
rabia | 0 | 1 |
| | | I've got a database with a large partitioned table where each
partition is in its own tablespace. We need to create a smaller test
version of this...
Greig
|
08-23-2011 11:48 AM
Greig | 3 | 4 |
| | | Anybody have a solution for this error:
db2top -d $dbname
Function not implemented (smcr_procattr)
info: db2 9.5 fp7 on AIX 5.3
db2Harakiri
|
08-23-2011 05:55 AM
Nonejm | 7 | 8 |
| | | Hello,
I have a query which runs well in the first 15-30 minutes (lots of user-
mode CPU-time and/or lots of I/O), but which then deteriorates into...
Troels Arvin
|
08-22-2011 10:12 AM
Yonghang Wang | 7 | 8 |
| | | WATCH WORLD`S MOST BEAUTIFUL...
rabia
|
08-22-2011 05:29 AM
rabia | 0 | 1 |
