| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | DB2 V9.5 on AIX,
This would be running on C code..The following query:
SELECT * FROM table1 WHERE col1 = 3 FETCH FIRST 10 ROWS ONLY
or
SELECT *...
shorti
|
11-15-2010 06:46 PM
shorti  | 5 | 6 |
| | | The following questions refer to 2 TPC benchmarks using DB2:
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp
DPF System - IBM Power 780 Server...
Mark A
|
11-14-2010 10:53 AM
Serge Rielau | 1 | 2 |
| | | Yellowfin’s latest Business Intelligence (BI) application for the
iPhone and iPad is now available from Apple’s App Store.
BI software analyzes and...
JTP PR
|
11-14-2010 06:21 AM
JTP PR | 0 | 1 |
| | | Hi all,
Its possible to create a java UDF that write some text into an
external file?
DB2 v.9.72
On WindowsXP pro
I want the possibility to write...
John Hopfield
|
11-12-2010 05:04 AM
AD | 6 | 7 |
| | | Hi,
We have been seeing strange DB2 behavior on Sun Solaris 2.10. DB2
seems to crash and complaint about not enough memory, while sar & top
clearly...
runner
|
11-10-2010 09:54 AM
Mark A | 8 | 9 |
| | | Hello,
Is this an upgrade or would/could 9.5 install separately?
Thanks
Graham
Graham Hobbs
|
11-09-2010 01:01 AM
Helmut Tessarek | 6 | 7 |
| | | I'm faced here at work (IBM) with the fact that the runtime of a SQL query
can be reduced from 7 minutes to 2-3 seconds if <conditions> is moved...
Toralf Förster
|
11-05-2010 10:13 AM
Toralf Förster | 8 | 9 |
| | | General summary:
EMC, a worldwide leader in information infrastructure, is seeking a
senior software engineer. You will be working on an R&D...
Qianmei Tang
|
11-03-2010 10:09 AM
Qianmei Tang | 0 | 1 |
| | | Postgres tips. Visual FoxPro as Client and Postgres as Backend
examples.
http://postgres-tips.narod2.ru/
Psi Operator
|
11-02-2010 03:21 PM
Psi Operator | 0 | 1 |
| | | Hi,
does anyone have any idea what the following entry in the DB2 diag log
means?
And more importantly - how significant that message is, does it...
Damir
|
11-02-2010 02:07 PM
Naresh Chainani | 1 | 2 |
| | | I want to know if there are decent db clients that would give menu
based info on database objects, including the extract ddl etc in Mac
OSx. Tried DB...
Arun Srini
|
10-28-2010 11:26 AM
asierra01 | 4 | 5 |
| | | In part one of our mini blog series exploring cross-industry uses and
benefits of data analysis – Data analysis for the Retail Industry – we
explored...
JTP PR
|
10-28-2010 06:42 AM
JTP PR | 0 | 1 |
| | | Open Source
Fully documented
Built-in regression suite
www.diffkit.org
joe
|
10-27-2010 12:19 AM
joe | 0 | 1 |
| | | New to HADR, running db2 version 9.5 on Suse LInux.
I set up HADR/TSA for both primary and failover databases. Database
gets turned over to...
Erik L
|
10-26-2010 06:24 PM
Frederik Engelen | 1 | 2 |
| | | I installed DB2 V8.2 ESE on my desktop, after removing my V9.5
client. I rebooted my desktop a number of times in the process. When
the install...
Richard
|
10-23-2010 03:33 PM
mattlinzer+ibm-db2 | 4 | 5 |
| | | V9.5 and V9.7 on AIX. I dont see anything in Info center that
restricts inserting or deleting during online, inplace REORG WITH
WRITE ACCESS but...
shorti
|
10-22-2010 12:57 PM
Mark A | 1 | 2 |
| | | What does it mean when an existing index shows up in ADVISE_INDEX?
Does it mean it should already use that index and it is not suggesting
I spend...
AntiVirus DBA
|
10-22-2010 12:23 PM
AntiVirus DBA | 0 | 1 |
| | | We have a very old V7 instance running on Windows. The box that was
home to this instance crashed recently, and our systems folks want to
migrate...
Richard
|
10-22-2010 02:53 AM
Lennart Jonsson | 6 | 7 |
| | | DB2 V9.7/AIX, Is there a place to get the timestamp of when wee hit
peak memory usage for an instance/database?
For instance, I can see the...
shorti
|
10-21-2010 05:08 PM
shorti | 3 | 4 |
| | | (Part 1)
http://www.yellowfinbi.com/YFCommunityNews.i4?newsId=99992
(Part 2)
http://www.yellowfinbi.com/YFCommunityNews.i4?newsId=100003
JTP PR
|
10-20-2010 07:04 AM
JTP PR | 0 | 1 |
| | | The IBM documentation says this:
"In order to create a partitioned database environment, you must
install DB2 Enterprise Server Edition (ESE). To...
Willem Fischer
|
10-19-2010 09:29 AM
Hardy | 4 | 5 |
| | | Why is my alter table command succesful on INcreasing the datatype
length, but not on DEcreasing the datatype length?
Currently: Dummy =...
Twan
|
10-16-2010 02:43 PM
Karl Hanson | 5 | 6 |
| | | Hello,
I'm setting up a new DB2 database on a Red Hat Enterprise Linux 5.5
server.
For the first time, I set set it up using UTF-8, thinking that...
Troels Arvin
|
10-16-2010 05:43 AM
Frederik Engelen | 14 | 15 |
| | | Hello,
Regarding the workload management features described at
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/nav/3_4 :
Are none, some, or all...
Troels Arvin
|
10-15-2010 08:20 AM
Mark A | 5 | 6 |
| | | I'm using db2 CLI client on AIX, which was set up for me by an admin.
I would like to know the hostname of the DB2 server that I'm
connecting...
DavidFilmer
|
10-13-2010 02:18 PM
ChrisC | 4 | 5 |
| | | Currently on db2 v9.5 fixpak 5
I have created a federated db. Using a view, I am joining a db2 table
in the federated db with a nickname. How can...
tg
|
10-12-2010 10:23 AM
tg | 2 | 3 |
| | | Express-C 9.7.2 LUW. I need to generate CSV text files containing dates in
a specific format. I know there is (or used to be as it's in my...
Will Honea
|
10-08-2010 03:42 PM
Will Honea | 5 | 6 |
| | | Hello, how does parameters hadr_timeout and hadr_peer_window impact
TSA capability of doing takeover (either forced or planned..depending
on whether...
RNBJ
|
10-08-2010 02:48 PM
RNBJ | 0 | 1 |
| | | In DB2 9.7, file system caching is turned OFF for all tablespaces by
default, except for the System Temporary Tablespace created by default when
a...
Martin
|
10-08-2010 02:47 PM
Hardy | 1 | 2 |
| | | Hi
We are trying to quantify the impact on the database performance due
to running queries that query the sysibmadm snapshot views and profile
whats...
Arun Srini
|
10-08-2010 02:26 PM
Hardy | 2 | 3 |
| | | Upgrading a database for a J2EE software product from v8.1 to v9.1. Cannot modify the query in vendor code. The optimization level is 5. The tables...
harry
|
10-08-2010 02:21 PM
Hardy | 2 | 3 |
| | | Hello,
We are doing the best we can acting as our own DB2 on AIX LPARs DBAs without any formal training.
In order to isolate two databases, and keep...
CW Burfle
|
10-07-2010 11:22 AM
CW Burfle | 5 | 6 |
| | | Hi,
I've the necessity to keep aligned my Company's DB2 Database with
another DB2 Database.
In the actual scenario, I have to export entire DB...
Elio
|
10-06-2010 09:55 PM
Helmut Tessarek | 5 | 6 |
| | | I am running some DDL from a IBM product called Master Data Management and
it contains the following on the first line of each script
SET CURRENT...
Mark A
|
10-05-2010 11:33 PM
Mark A | 2 | 3 |
| | | Shameless self-promotion......
Serge Rielau
|
10-05-2010 01:27 PM
Serge Rielau | 0 | 1 |
| | | Hour Reading Data
8AM 100
9AM 500
10AM ...
siva perumal
|
10-05-2010 11:47 AM
ChrisC | 3 | 4 |
| | | According the IBM download site:
NOTE:
DB2 9.7 FP3 has been released again.
DB2 9.5 FP6 has been released as DB2 9.5 FP6a
Everything looks good for...
Mark A
|
10-05-2010 08:43 AM
Mark A | 3 | 4 |
| | | I need to parse some type 101 SMF records.
I can see the data & product sections of each record, but get stuck
trying to parse these into their...
mvsguy
|
09-30-2010 08:46 AM
mvsguy | 0 | 1 |
| | | Hello,
I'm writing a simple web-interface where users may see the sessions on the
database, including
- username
- application name
- status
- which...
Troels Arvin
|
09-30-2010 03:09 AM
Helmut Tessarek | 5 | 6 |
| | | Hi,
DB2 LUW 9.5 FP5,
Consider the following DDL:
CREATE TABLE ASSET.TBL_ASSET_NETWORK_HISTORY (
MACHINE_ID VARCHAR(24) NOT NULL ,
LOCALTIME...
Michel Esber
|
09-29-2010 04:52 PM
Ian | 4 | 5 |
| | | I've taken an offline backup from one environment and copied the file
to two other enviroments. I restored the backup in the first
environment using...
Richard
|
09-29-2010 04:47 AM
stefan.albert | 2 | 3 |
| | | Hi Guys,
DB2 LUW V9.5 Fp5.
There is another issue that needs a high performance solution.
I have a class A, B or C range. For example, 10.*,...
brunoalsantos
|
09-28-2010 01:34 PM
Lennart Jonsson | 1 | 2 |
| | | Hello all.
DB2 LUW V9.5 Fp5
Anyone knows a way to transform a integer in a ip address using Scalar
Function?
Regards
Bruno.
brunoalsantos
|
09-27-2010 03:04 PM
Tonkuma | 4 | 5 |
| | | We are using db2 9.5 fixpak 5 on unix.
Does anyone know how long the truncate portion should take. I had to
monitor ours recently due to my users...
tg
|
09-24-2010 03:45 PM
tg | 0 | 1 |
| | | Hi,
is there a way (by executing a SQL statement) to find out which FKs defined
against a given table are enforced and which are not?
SYSCAT,...
Damir
|
09-23-2010 01:31 AM
Mark A | 2 | 3 |
| | | Yellowfin Business Intelligence have released a whitepaper on
measuring data quality for successfull master data management.
Download Link (No Email...
JTP PR
|
09-22-2010 09:05 AM
JTP PR | 0 | 1 |
| | | Hi All!
I'm looking for an effective way to write a query set that helps me to
check security issues as follows:
1) Database Version
Not sure if it's...
Guto
|
09-21-2010 02:28 PM
Guto | 4 | 5 |
| | | Yellowfin Business Intelligence have released a whitepaper detailing
their technical approach to a SAAS integration and deployment.
Download Link...
JTP PR
|
09-21-2010 07:39 AM
JTP PR | 0 | 1 |
| | | Hi People,
I don't do the DDL's , am just a programmer. But i have following
requirements.
I have to expand a CHAR(9) field to CHAR(12) in a table....
Shishir
|
09-20-2010 10:26 PM
Lennart Jonsson | 4 | 5 |
| | | Hey people,
I have a database I use as a stock tracker, with no online users so to
speak so I do NOT have to worry about recovery or rollbacks...
Fin
|
09-20-2010 05:21 PM
Fin | 2 | 3 |
