| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Is there a query from a snapshot table, or some other method, to
monitor that a database is using trusted context connections? My
company is...
Ultrak The DBA
|
Today 05:50 PM
The Boss  | 3 | 4 |
| | | Greetings. I'm trying to execute a DB2 command such as:
SELECT P.ITEM_NO,
D.FILE_NAME
FROM PRODDB2.PART P
LEFT JOIN ...
DavidFilmer
|
Today 05:14 PM
Mark A | 1 | 2 |
| | | For traditional reporting, the dimensions of who, what, and when
(customer, product, time), are well covered, however, the "Where" gets
little...
JTP PR
|
Today 05:46 AM
JTP PR | 0 | 2 |
| | | On my XP sp3 box, I tred to upgrade my DB2 Express C 9.5 to 9.71, but I
received the error SQL5055C during the DB2EXTSEC phase.
Now I can't open...
Franco Lombardo
|
Yesterday 12:09 PM
Franco Lombardo | 2 | 16 |
| | | I installed DB2 9.5.1 a while back on Windows XP. After completing that
installation, whenever I open Firefox, I get asked which profile I want...
Rhino
|
Yesterday 10:33 AM
Rhino | 2 | 12 |
| | | I have a Primary Key Index that has 11 columns in it. 80 million row
table.
The index is 100% clustered and has nlevels = 4.
We have an Update...
jafastinger
|
03-08-2010 03:41 PM
jafastinger | 3 | 5 |
| | | 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 03:32 PM
Troels Arvin | 2 | 15 |
| | | 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 01:08 AM
Lennart | 2 | 21 |
| | | 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 03:45 PM
Ian | 3 | 15 |
| | | 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 02:29 PM
Ian | 2 | 6 |
| | | 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 12:10 PM
Ian | 1 | 11 |
| | | 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 10:53 AM
Naresh Chainani | 3 | 5 |
| | | 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 08:19 AM
--CELKO-- | 2 | 16 |
| | | 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 02:10 AM
Ian | 1 | 9 |
| | | 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 08:40 AM
Damir | 0 | 9 |
| | | 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 06:42 PM
Kiram | 0 | 8 |
| | | 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 05:00 AM
JTP PR | 0 | 12 |
| | | 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 05:17 PM
Ian | 4 | 25 |
| | | 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 05:53 AM
Jurgen Haan | 0 | 10 |
| | | 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 09:04 AM
Serge Rielau | 1 | 20 |
| | | 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 08:42 AM
Mia | 0 | 12 |
| | | 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 05:20 AM
.. | 0 | 14 |
| | | Do you know that you can find solar cells for less than 1 USD per Watt
on www.ebay.com ?
Regards.
..
|
02-28-2010 05:17 AM
.. | 0 | 11 |
| | | Hello,
Situation: New x86-64 Red Hat Enterprise Linux 5.4 (64 bit) server with
plenty of RAM (192GB) and DB2 ESE v. 9.7 FP1. The server has one...
Troels Arvin
|
02-26-2010 12:04 PM
whatever | 1 | 35 |
| | | 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 05:45 PM
Kiram | 2 | 19 |
| | | 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 05:54 PM
Mark A | 4 | 25 |
| | | 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 04:05 PM
Serge Rielau | 1 | 16 |
| | | We'd like to use the auto_del_rec_obj and rec_his_retentn cfg
parameters to delete old backup images and archived log files. This is
working fine,...
Frederik Engelen
|
02-23-2010 12:21 PM
Steve Pearson (news only) | 7 | 46 |
| | | 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 08:41 AM
Madhan | 0 | 13 |
| | | Hi,
I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except
the following issue from...
Tony
|
02-22-2010 04:05 PM
Mark A | 3 | 25 |
| | | 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 02:18 PM
Ian | 3 | 23 |
| | | 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 04:29 PM
Ian | 7 | 46 |
| | | 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 10:19 AM
k_rus | 0 | 10 |
| | | 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 05:27 AM
danfan | 1 | 19 |
| | | Use VALUES, like this ....
------------------------------ Commands Entered
------------------------------
WITH tableA(x,y) AS(
VALUES ('x1' ,...
cjflorian@gmail.com
|
02-15-2010 10:59 AM
cjflorian@gmail.com | 2 | 22 |
| | | I made a web. For those people who want learn and earn by
internet .please visit the...
John Smith
|
02-13-2010 05:09 AM
John Smith | 0 | 28 |
| | | 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 08:20 AM
MarkB | 1 | 33 |
| | | 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 10:12 AM
Justin | 0 | 21 |
| | | 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 08:29 AM
MarkB | 1 | 22 |
| | | 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 08:52 AM
kevan | 1 | 25 |
| | | db2 => select TABNAME, CARD, FPAGES, NPAGES, OVERFLOW from
sysstat.tables where tabname like 'ENTITY%'
TABNAME ...
cjflorian@gmail.com
|
02-09-2010 12:13 AM
Hardy | 8 | 52 |
| | | 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 03:39 PM
Mark A | 2 | 16 |
| | | "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 01:39 PM
Serge Rielau | 3 | 41 |
| | | 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 11:21 AM
Mark A | 1 | 16 |
| | | Yellowfin Business Intelligence an entirely new dimension in Location
Intelligence has provide Jet Interactive with a significant
competitive...
JTP PR
|
02-07-2010 12:19 AM
JTP PR | 0 | 26 |
| | | 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 10:38 AM
whatever | 3 | 46 |
| | | 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 08:21 AM
MarkB | 6 | 49 |
| | | 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 01:47 AM
Willem Fischer | 3 | 26 |
| | | 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 11:05 PM
Serge Rielau | 3 | 42 |
| | | 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 07:57 PM
Tonkuma | 6 | 39 |
