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

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

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

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

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

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

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--

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

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

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

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

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

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

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

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

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
..

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
..

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

"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

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

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

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

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

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

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

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

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

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

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

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

Anyone have the expertise to answer any of these questions? I appreciate the help.

shorti

01-28-2010 12:57 PM
shorti

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

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

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