| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | The phenomenal interest in social networking and Web 2.0 technologies
at the enterprise level is both unprecedented and growing rapidly.
But why? ...
JTP PR
|
01-27-2011 05:53 AM
JTP PR  | 0 | 1 |
| | | Hello,
Regarding reclaimable storage:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/
com.ibm.db2.luw.admin.dbobj.doc/doc/c0055392.html...
Troels Arvin
|
01-25-2011 03:49 AM
Kel | 1 | 2 |
| | | So, I'm trying to retrieve a certain statement from the db2 logs using
the db2logread API
I've got the beginning and ending LSN's and I believe I've...
Ken Snyder
|
01-24-2011 07:49 PM
Ken Snyder | 0 | 1 |
| | | Are there any examples of programs doing DDF accounting in DB2?
Thank you,
DO
Devout Occamist
|
01-19-2011 09:07 PM
Helmut Tessarek | 3 | 4 |
| | | Hello,
Setup:
Latest 64-bit Windows client on Windows Server 2008 connecting to a DB2
9.7 server (running on Linux) with latest fixpack. The...
Troels Arvin
|
01-19-2011 09:23 AM
Troels Arvin | 13 | 14 |
| | | Hi there,
I'm running DB2 9.5 under Linux and I'm trying to run the CREATE
SERVER command, but
I get an error message about the authorization id and...
Bill
|
01-18-2011 05:36 PM
The Boss | 3 | 4 |
| | | Hello,
Let's say I have a large table which needs to be reloaded from scratch
with (lots of) new data. The table has a clustering index and a...
Troels Arvin
|
01-18-2011 02:07 PM
Mark A | 3 | 4 |
| | | Hello,
We would like to inform you that we have updated our list with the
following new titles.
You can contact us directly at...
Student.Plus@Hotmail.com
|
01-17-2011 03:14 AM
Student.Plus@Hotmail.com | 0 | 1 |
| | | Is there a particular reason why on update cascade is not supported by
db2, or is it just that no one has asked for it?
/Lennart
Lennart Jonsson
|
01-16-2011 04:44 AM
Lennart Jonsson | 0 | 1 |
| | | All,
DB2 LUW v9.5 FP 5.
Has anyone implemented or could point articles to an UDF that returns
the Subnet ID of a (IP, NetMask)...
Michel Esber
|
01-15-2011 03:05 PM
Lennart Jonsson | 4 | 5 |
| | | Guys,
DB2 LUW v9.5 fp5
Not sure if I am missing something obvious, but:
select MIN(COLLECT_TIME), MAX(COLLECT_TIME)...
Michel Esber
|
01-15-2011 12:02 PM
Ian | 3 | 4 |
| | | Kaspersky Anti-Virus Personal 2011 11.0.2.556
Avira AntiVir Personal - Free Antivirus...
alagmy2030
|
01-13-2011 07:01 PM
alagmy2030 | 0 | 1 |
| | | We've just migrated, in our development environment, an 8.2 instance
to 9.7. The developers started to test their apps against the 9.7
database, and...
Richard
|
01-13-2011 11:03 AM
Richard | 3 | 4 |
| | | Hello Lennart,
In comp.databases.ibm-db2, you recently wrote:
Ah, it's to be interpreted as a tablespace container file, it seems.
I would very...
Troels Arvin
|
01-12-2011 05:03 PM
Troels Arvin | 2 | 3 |
| | | Anybody has experience restoring 9.5 database back to 9.1 ?
Our environment is WIN 2003 64 bit. Thank you in advance.
By the way, any doubt I had...
Richard
|
01-10-2011 02:13 PM
Serge Rielau | 8 | 9 |
| | | The event monitors are explained in great detail...
Willem Fischer
|
01-07-2011 11:27 AM
The Boss | 1 | 2 |
| | | The event monitors are explained in great detail...
Willem Fischer
|
01-07-2011 09:12 AM
Willem Fischer | 1 | 2 |
| | | I found that truncate table statement is not correctly replicated via
ASN replication. Truncate is rollforward compatible, so capture
program should...
hsn_
|
01-05-2011 12:37 PM
Naresh Chainani | 1 | 2 |
| | | We ran db2iupgrade against an 8.2 instance to bring it
to 9.7FP3a. The output from db2iupgrade says:
DBI1266I Refer to the log file...
Richard
|
01-04-2011 03:34 PM
Richard | 0 | 1 |
| | | All,
In the new TSA scripts from 9.5 FP7 there was a new script added:
rovingV95_failover.ksh
For 9.7FP3a, this was listed as an APAR but the...
Frederik Engelen
|
12-27-2010 09:38 AM
Frederik Engelen | 0 | 1 |
| | | All right I bite, with the disclaimer that this is my personal opinion.
If you see a feature a s a dimension, then with every feature that you
add a...
Serge Rielau
|
12-21-2010 06:29 PM
Will Honea | 6 | 7 |
| | | hi,
is this normal for bp hit ratio to be low and asynchronous reads ratio
to be high while running runstats with distributions ?
db2admin
|
12-21-2010 06:08 PM
Frederik Engelen | 2 | 3 |
| | | Steve,
Thanks. I see Spike in IO when runstats start
Here is the link to spreadsheet. If you see at midnight, there is a huge spike in...
db2admin
|
12-21-2010 02:11 PM
db2admin | 0 | 1 |
| | | Anybody have a copy of Version 8 for Windows install?
I have a backup of a system and need to restore to the same version.
Thank you
Ralph Young
|
12-17-2010 06:47 AM
Mark A | 1 | 2 |
| | | I realize this topic has been covered many times. I'm looking at the
9.7 upgrade steps outlined on the IBM website. It says, for 8.2
databases, I...
Richard
|
12-16-2010 12:07 PM
Richard | 5 | 6 |
| | | Hi.
We have several cases where, in reading the documentation, we should
be creating indexes with PAGE SPLIT HIGH (instead of PAGE SPLIT
SYMETRIC,...
ChrisC
|
12-15-2010 01:24 PM
ChrisC | 0 | 1 |
| | | Greetings,
how can I find out what MQTs are defined on a particular table?
Regards,
Damir
Damir
|
12-12-2010 12:59 AM
Lennart Jonsson | 3 | 4 |
| | | Hi folks,
Is it possible to create a task right from the DB2 CLP instead of
using the IBM Task Center (GUI) ?
DB2 DEV server : DB2 Express-C /...
Charles M.
|
12-11-2010 04:38 AM
Frederik Engelen | 9 | 10 |
| | | God alone can give life but human alone can save it. Do you REALLY
want to donate your blood? Please Sign up ........................
ask4blood.com
|
12-09-2010 12:58 PM
ask4blood.com | 0 | 1 |
| | | International Business Intelligence (BI) vendor, Yellowfin, has
released the new version of its BI solution – Yellowfin 5.1 Socialize,
Visualize &...
JTP PR
|
12-09-2010 06:22 AM
JTP PR | 0 | 1 |
| | | hi,
we have some server connecting to database server running 9.5 FP 4 on
AIX and locking account. this server must have wrong password. how to
find...
db2admin
|
12-06-2010 03:07 PM
Frederik Engelen | 1 | 2 |
| | | Finding the best beer by geography
We kicked-off the selection process by perusing an awesome web site
www.beerme.com , which has a great beer list...
JTP PR
|
12-06-2010 06:31 AM
JTP PR | 0 | 1 |
| | | Hi,
Db2 LUW v9.5 fp5.
Following this thread: http://tinyurl.com/36hhfqf
create view testing_predicate_pushdown as
with
disks as (
Michel Esber
|
12-02-2010 12:22 PM
ChrisC | 4 | 5 |
| | | There is no ROI in Business Intelligence; unless you make a decision.
Yellowfin has launched its 5.1 release to an expectant international
audience...
JTP PR
|
12-02-2010 06:40 AM
JTP PR | 0 | 1 |
| | | Hi,
I found that simply copying a databases' files to the target directory
(C:\MYINST) and then doing "db2 catalog db MYDB" works better than...
Willem Fischer
|
12-01-2010 02:03 PM
Helmut Tessarek | 2 | 3 |
| | | We have setup a new physical server, with a number of virtual servers on
top of it. When we run db2start on any of the virtual servers we get:
~]$...
Lennart Jonsson
|
11-30-2010 02:52 AM
Lennart Jonsson | 5 | 6 |
| | | What is the best way to identify which statements in the package cache
that reads from a certain table? I'm not to happy with:
select ...
from...
Lennart Jonsson
|
11-25-2010 07:16 PM
Willem Fischer | 5 | 6 |
| | | We're in the planning stages for a DB2 upgrade from 8.2 & 9.1 to 9.7
FP3a. I've never applied a fix pack or upgraded an instance to a
newer version....
Richard
|
11-25-2010 01:15 AM
Helmut Tessarek | 2 | 3 |
| | | Db2 LUW v9.5 fp5,
drop table DISK;
create table DISK (IS_EXTERNAL CHAR, DISK_NUMBER SMALLINT, VOLUME_ID
SMALLINT, DISK_SIZE BIGINT, VOLUME_SIZE...
Michel Esber
|
11-24-2010 09:36 AM
Ian | 7 | 8 |
| | | Yellowfin is launching the latest release of its Business Intelligence
(BI) platform – Yellowfin 5.1 – and you’re invited!
Join us in an exclusive...
JTP PR
|
11-24-2010 05:58 AM
JTP PR | 0 | 1 |
| | | I have an external function that we use in our CRM system, and my
application owners would like to know the last time it was bound in
the database. ...
AntiVirus DBA
|
11-23-2010 06:36 AM
Helmut Tessarek | 1 | 2 |
| | | I wonder which scripting language you are using for scripting both
Windows and AIX.
- Write everything twice, once for bash, once for DOS batch?
-...
Willem Fischer
|
11-22-2010 10:36 AM
Haider Rizvi | 8 | 9 |
| | | Gartner says social computing to change the face of IT and business
Gartner has identified the impact of social media as one of four broad
trends...
JTP PR
|
11-21-2010 07:10 AM
JTP PR | 0 | 1 |
| | | Dear Everyone,
as you know the price of the Oil is more and more increasing, while
the oil supply is decreasing. Moreover Oil
is causing wars,...
........
|
11-19-2010 07:02 AM
........ | 0 | 1 |
| | | Hi Willem,
Yeah, we have been discussing internally the creation of this
generated column. I have in fact created this column and studied the
access...
Michel Esber
|
11-18-2010 11:00 AM
Lennart Jonsson | 12 | 13 |
| | | Hello, I need to track a packages usage of DDF CPU.
I have a basic understanding of SMF 101, but I can't seem to match DDF
CPU to packages.
Can...
Lost In The Outer Spiral Arm
|
11-18-2010 08:51 AM
Lost In The Outer Spiral Arm | 0 | 1 |
| | | Hi all,
I am trying to implement UDF which will truncate 4 tables as part of
UDF. The reason to choose DB2 UDF as apposed to DB2 Procedure is one
of...
Gilroy Gonsalves
|
11-17-2010 03:56 PM
Gagan Kumar | 5 | 142 |
| | | I thought that dbm cfg parameters would stay the same when a database
is restored, but that the db cfg parameters would get overwritten by
params in...
Richard
|
11-17-2010 12:01 PM
Frederik Engelen | 1 | 2 |
| | | I’m using DSNDQWAS to map SMF 101. Mapping DSNDQWA0 isn’t difficult.
I’m seeing records that don’t match beyond QWA01PSN.
For example –
000000 ...
mvsguy
|
11-17-2010 09:42 AM
mvsguy | 2 | 3 |
| | | Hello, on DB2 V9.7:
"The use of the CREATE EVENT MONITOR FOR DEADLOCKS statement and the
automatically started DB2DETAILDEADLOCK event monitor, to...
shorti
|
11-16-2010 04:24 AM
globomike | 1 | 2 |
