| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | Hello,
Setup: 9.7.1 (64 bit) running on x86_64 Red Hat Enterprise Linux 5.4.
Often, when I take look at the list of applications, I see a session...
Troels Arvin
|
03-06-2010 02:32 PM
Troels Arvin | 2 | 243 |
|  | A while ago I discovered a transaction that had been active for a long
time. The statement where against a infrequently accessed table, and
caused no...
Lennart
|
03-06-2010 12:08 AM
Lennart | 2 | 406 |
|  | Setup:
- Server with data residing on an XIV storage system. The XIV storage
system spreads data over all available disks with no knobs to...
Troels Arvin
|
03-05-2010 02:45 PM
Ian | 3 | 242 |
|  | Anybody has a write-up on installation and usage of Ruby with DB2 9.5
ESE on AIX 5.3/6.1?
TIA
Asphalt Blazer
|
03-05-2010 01:29 PM
Ian | 2 | 200 |
|  | Hi,
here i have given my requirement details please give me some
idea..........
i have created a new user(user2) in db2 database.now In that...
karthic
|
03-05-2010 11:10 AM
Ian | 1 | 186 |
|  | Hi all,
what are the possible ways to convert a non partitioned index to a
partitioned index in DB2 V9.7.1?
According to the InfoCenter, the only...
Damir
|
03-05-2010 09:53 AM
Naresh Chainani | 3 | 187 |
|  | Hello All,
I have a query that returns the following results. We get multiple
rows back, with all the same info except for the...
eliane
|
03-05-2010 07:19 AM
--CELKO-- | 2 | 423 |
|  | Hello,
DB2 v. 9.7.1.
During certain special workloads (e.g. parallel REORGs/RUNSTATs), I've
seen the server consuming 450MB/s with 25000IO/s (yes,...
Troels Arvin
|
03-05-2010 01:10 AM
Ian | 1 | 183 |
|  | Hi all,
the command:
call SYSPROC.EVMON_FORMAT_UE_TO_TABLES ('LOCKING', NULL, NULL, NULL, NULL,
NULL, NULL, -1, 'SELECT * FROM...
Damir
|
03-04-2010 07:40 AM
Damir | 0 | 213 |
|  | Hi,
I get different results when I try to find the fenced user id of the
instance and I need some help determining the right one so that I...
Kiram
|
03-03-2010 05:42 PM
Kiram | 0 | 182 |
|  | The Yellowfin BI team have produced a new paper on "Location
Intelligence", the mashup of BI with GIS
Extract
More than 70% of your organizational...
JTP PR
|
03-03-2010 04:00 AM
JTP PR | 0 | 164 |
|  | Consider a table and a query referring to only a subset of the columns
in that table. How early in the query evaluation is the projection
carried...
jbdhl
|
03-02-2010 04:17 PM
Ian | 4 | 373 |
|  | Hi all.
I'm looking for db2 9.5 express-c for LUW (linuxx86_64).
The ibm site only lets me download 9.7, but I need 9.5 since I have a 9.5
instance...
Jurgen Haan
|
03-02-2010 04:53 AM
Jurgen Haan | 0 | 183 |
|  | As I understand when you set the DB2_COMPABILITY_VECTOR registry
variable it allows execution of PL/SQL in DB2, but this only affects
databases...
oddbande
|
03-01-2010 08:04 AM
Serge Rielau | 1 | 400 |
|  | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the...
Mia
|
03-01-2010 07:42 AM
Mia | 0 | 207 |
|  | Driving and Car Maintenance: Transportation accounts for 66% of U.S.
oil use -mainly in the form of gasoline. Luckily, there are plenty of
ways to...
..
|
02-28-2010 04:20 AM
.. | 0 | 203 |
|  | Do you know that you can find solar cells for less than 1 USD per Watt
on www.ebay.com ?
Regards.
..
|
02-28-2010 04:17 AM
.. | 0 | 199 |
|  | Hi, I get this error SQL0101N error for the Select Query. I know that
I am selecting all the colums from 10 tables and passing like 200
values to the...
Kiram
|
02-25-2010 04:45 PM
Kiram | 2 | 345 |
|  | For DB2 Version 9.5, does setting swappiness= 0 (/proc/sys/vm/swappiness) on
RHEL 5 sufficiently limit Linux file system caching, or is there some...
Mark A
|
02-23-2010 04:54 PM
Mark A | 4 | 431 |
|  | Hello,
i have a little performance problem with DB2 UDF:
i've created 2 UDFs:
EAN_128(EanCodeReq VARCHAR(4), Id bigint) returns...
boris brinza
|
02-23-2010 03:05 PM
Serge Rielau | 1 | 185 |
|  | Use IQ 20/20 to produce stunning Reports and Dashboards from your DB2
data as well as other data sources.
If you have invested time and money into...
Madhan
|
02-23-2010 07:41 AM
Madhan | 0 | 188 |
|  | Hi,
I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except
the following issue from...
Tony
|
02-22-2010 03:05 PM
Mark A | 3 | 317 |
|  | Hi,
I would like to use AUTHENTICATION=DATA_ENCRYPT parameter on my
database for increased security. But I cannot find any in depth
articles about it...
Asphalt Blazer
|
02-22-2010 01:18 PM
Ian | 3 | 452 |
|  | I am running DB2 V9.5 on AIX. We have a fairly small database (2
million records max on main table). We use COUNT(*) periodically. We
also...
shorti
|
02-18-2010 03:29 PM
Ian | 7 | 477 |
|  | Hi,
I am working with WebSphere Federation Server v9.5. for LUW Developer
Edition. What are the limitations of the developer edition? I was not
able...
k_rus
|
02-18-2010 09:19 AM
k_rus | 0 | 227 |
|  | Hi!
How does DB2 choose the victim when a deadlock is detected?
Can it be configured in any way?
Last night a long-running batch transaction was...
danfan
|
02-17-2010 04:27 AM
danfan | 1 | 194 |
|  | Use VALUES, like this ....
------------------------------ Commands Entered
------------------------------
WITH tableA(x,y) AS(
VALUES ('x1' ,...
cjflorian@gmail.com
|
02-15-2010 09:59 AM
cjflorian@gmail.com | 2 | 221 |
|  | I made a web. For those people who want learn and earn by
internet .please visit the...
John Smith
|
02-13-2010 04:09 AM
John Smith | 0 | 273 |
|  | Hi,
I'm writing scripts to monitor our databases. They should be somewhat
universal, i.e. run on on DB2 versions 8+ (yes, we still have some...
Willem Fischer
|
02-11-2010 07:20 AM
MarkB | 1 | 439 |
|  | I am using the db2 9.7 client software to install visual studio add-
in.
The error message: The operation could not be completed. The
requested...
Justin
|
02-10-2010 09:12 AM
Justin | 0 | 245 |
|  | Can i add the DB2 Connect Personal Edition V9.7 license file (from a
commercially licensed copy) to a directory in my DB2 Express-C V9.7
installation...
Mark A
|
02-10-2010 07:29 AM
MarkB | 1 | 236 |
|  | Hi all,
I'm trying to install the above 2 packages on windoze 7 (64 bit)
VmWare image and for both of them I get an error message saying that
the...
alexs
|
02-09-2010 07:52 AM
kevan | 1 | 393 |
|  | db2 => select TABNAME, CARD, FPAGES, NPAGES, OVERFLOW from
sysstat.tables where tabname like 'ENTITY%'
TABNAME ...
cjflorian@gmail.com
|
02-08-2010 11:13 PM
Hardy | 8 | 365 |
|  | And I thought professional whiners in cdi claim that Oracle is
more than IBM + Microsoft combined after IBM took over Informix.
Taken from today's...
dba6319@gmail.com
|
02-08-2010 02:39 PM
Mark A | 2 | 312 |
|  | "Mark A" <noone (AT) nowhere (DOT) com> дÈëÏûÏ¢
news:hk7apt$bm3$1 (AT) news (DOT) eternal-september.org...
it has been years from the first time I...
Hardy
|
02-07-2010 12:39 PM
Serge Rielau | 3 | 312 |
|  | Hi All,
I am using DB2 9.1 on Z/OS . i have complied and run my application
program which has a simple select on a table on its primary key....
Shishir
|
02-07-2010 10:21 AM
Mark A | 1 | 248 |
|  | Yellowfin Business Intelligence an entirely new dimension in Location
Intelligence has provide Jet Interactive with a significant
competitive...
JTP PR
|
02-06-2010 11:19 PM
JTP PR | 0 | 222 |
|  | I'm working on some deadlock analysis, and when I parse the output of
the deadlock event monitor, I discover that for over half of my 26
deadlocks in...
Ember
|
02-05-2010 09:38 AM
whatever | 3 | 384 |
|  | I have two question,
we are using the "with ur" in some sqls that can read uncommitted
rows, so that has improved concurrency, but "for read only" is...
Arun Srini
|
02-05-2010 07:21 AM
MarkB | 6 | 336 |
|  | I'm looking for documentation on db2pd that is complete to some
extend. At the moment I'm doing a lot of guesswork, but there must be
many more...
Willem Fischer
|
02-05-2010 12:47 AM
Willem Fischer | 3 | 389 |
|  | Hi,
I'm running Db2 V9.7FP1 64 bit on two Linux servers. I've got a number
of databases living on the "primary" server that I'd like to
replicate...
alexs
|
02-01-2010 10:05 PM
Serge Rielau | 3 | 245 |
|  | Hi All.
I just trying to understand why a stored procedure call takes more
time to response than an ODBC request. My company use JDEdwards with
DB2...
Charlie
|
02-01-2010 06:57 PM
Tonkuma | 6 | 217 |
|  | Hello,
When sizing a new server, I can choose between 96GB of very fat RAM
(1333MHz DDR3), or 128GB of slightly slower RAM (1066MHz DDR3)....
Troels Arvin
|
01-31-2010 08:36 PM
Hardy | 5 | 277 |
|  | FREE Animations you can e-mail
(click link):
http://www.amperefitz.com/contact.html
THOUSANDS of FREE Animations
Enjoy,
fitz
|
01-31-2010 05:58 PM
fitz | 0 | 255 |
|  | I am new to using table partitioning, but now we want to use it on a
couple of tables. But when trying this we have experienced something I
consider...
oddbande
|
01-31-2010 12:35 PM
oddbande | 5 | 219 |
|  | I downloaded the "IBM Data Server Driver for ODBC and CLI (CLI Driver)" from
here, but I can't install it: in the zip file there is no "setup.exe"...
Franco Lombardo
|
01-29-2010 08:31 AM
Larry | 3 | 176 |
|  | Anyone have the expertise to answer any of these questions? I
appreciate the help.
shorti
|
01-28-2010 12:57 PM
shorti | 6 | 256 |
|  | Hello,
I may be installing a new DB2 v. 9.7 Enterprise Edition (64 bit) on a
Linux server soon. The database will contain around 10TB of data...
Troels Arvin
|
01-28-2010 07:36 AM
Hardy | 1 | 191 |
|  | I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer...
Virgina Hernandez
|
01-27-2010 01:38 PM
Virgina Hernandez | 0 | 295 |
|  | Hi,
I am trying to create a function in db2 that takes in a parameter, and
returns 1 value. I can make it work as long as there is no input
parameter...
andyhe
|
01-25-2010 08:09 AM
Hardy Wang | 11 | 431 |