| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
In order to avoid duplicate records to be created, the program (COBOL)
requires user to check if the record they want to create already
exists...
du_bing@hotmail.com
|
06-07-2011 11:26 AM
Tonkuma  | 1 | 33 |
| | | International Business Intelligence (BI) vendor, Yellowfin, has been
recognized amongst the world’s elite BI vendors, outperforming
established...
janpelletier@yahoo.ca
|
06-05-2011 07:50 AM
janpelletier@yahoo.ca | 0 | 29 |
| | | International Business Intelligence (BI) vendor, Yellowfin, has
announced that it will launch the new version of its BI solution –
Yellowfin 5.2:...
janpelletier@yahoo.ca
|
06-02-2011 09:12 AM
janpelletier@yahoo.ca | 0 | 34 |
| | | Firstly, please forgive my ignorance as I am very new to Foreign Keys
and am trying to learn in a very steep learning curve. Previously all
my...
Fin
|
06-02-2011 04:33 AM
Ian | 1 | 29 |
| | | Hi,
The db2diag.log is not working In Standby Server and no new line
written into it for few days.
Can Any One give the solution to resolve this...
ilaya raj
|
05-30-2011 08:33 PM
Bruce Miller | 2 | 32 |
| | | Hello all,
DB2 v9.5 LUW Fixpack 5.
create table TESTE (
MACHINE_ID VARCHAR (24),
LOGIN_NAME VARCHAR (32),
EVENT_TIME TIMESTAMP,
OPERATION CHAR (1)...
brunoalsantos
|
05-26-2011 01:31 PM
Lennart Jonsson | 1 | 32 |
| | | Hello all,
DB2 V9.5 LUW Fixpack 5.
Is there in DB2 a function that returns the checksum of a string, like
the sum of UNIX?
In Unix/Linux:
$ echo...
brunoalsantos
|
05-25-2011 04:01 PM
brunoalsantos | 3 | 31 |
| | | I'm having all manner of problems trying to create a UDF that contains
a simple CASE statement in Express-C 9.7.4.
Say for example the...
Fin
|
05-24-2011 07:11 PM
Serge Rielau | 3 | 35 |
| | | Hi all,
we're having problems upgrading a V9.1 to a v9.7
The scripts for compatibility checks pass but
/opt/ibm/db2/V9.7/instance/db2iupgrade -d -u...
Edoardo
|
05-23-2011 12:01 PM
whatever | 4 | 36 |
| | | I just want to know how db2 can allow creating columns with spaces
between them . I was able to create this in db2 udb 9.7
create table...
Arun Srini
|
05-21-2011 12:55 PM
Arun Srini | 5 | 35 |
| | | DB2 Version : LUW, DB2 v9.7.0.3
Operating Sys: AIX 5.3
Type : DPF (more than 40 nodes on different LPARs)
Size: more than 10 TB
Issue: User Joe...
Prax
|
05-20-2011 12:39 PM
whatever | 1 | 34 |
| | | DB2 Version : LUW, DB2 v9.7.0.3
Operating Sys: AIX 5.3
Type : DPF (more than 40 nodes on different LPARs)
Size: more than 10 TB
Issue: User Joe...
Prax
|
05-20-2011 03:35 AM
Prax | 0 | 32 |
| | | Macquarie University generates new insights with Yellowfin Business
Intelligence
Macquarie University today launched the first phase of a...
janpelletier@yahoo.ca
|
05-18-2011 07:06 AM
janpelletier@yahoo.ca | 0 | 41 |
| | | Why does this SQL statement work
SELECT
CASE
WHEN A.DAILYDOWNLOADSIZE is null THEN 0
else bigint(A.DAILYDOWNLOADSIZE)
END...
kg6ypx
|
05-17-2011 01:38 PM
kg6ypx | 4 | 46 |
| | | will DB2 use the index for a SQL like this?
i have an index on the A table like this +ORD_NBR+LD_STP_NBR
+REC_STT
Select .....
from .....
where...
Herb
|
05-13-2011 06:55 PM
Tonkuma | 1 | 43 |
| | | I am running windows 7 professional (64 Bit) with the 64 bit version
of DB2 9.7.4. I am using the 32 bit version of Oorexx 4.1.0. I have
moved...
ichabod
|
05-12-2011 06:39 PM
ichabod | 2 | 43 |
| | | Hi,
I have problem with PureXML. I have two tables, for examle:
table Document
id int not null
invoice xml not null
table Contractor
id int not...
iza.klosinska
|
05-12-2011 12:45 AM
iza.klosinska | 0 | 41 |
| | | hi
I am using vs2.0 sp1 and back-end server db2 9.7(fixpack1).I am
getting the following error if am installing db2 9.7 (fixpack4).
Could not load...
ilaya raj
|
05-11-2011 05:17 PM
The Boss | 2 | 35 |
| | | In many database systems you can perform a select without from, for
exapmle "SELECT 1" but DB2 doesn't allow this. In others like Oracle,
you can use...
M N
|
05-11-2011 10:53 AM
Lennart Jonsson | 4 | 38 |
| | | Hi all,
DB2 V9.5 Fp5 LUW.
CREATE TABLE "CLT "."TBL_COLLECT_SW_LNX" (
"MACHINE_ID" VARCHAR(24) NOT NULL ,
"SW_ID" DECIMAL(8,0) NOT NULL...
brunoalsantos
|
05-11-2011 09:54 AM
brunoalsantos | 4 | 49 |
| | | I am migrating from version 8.1 of DB2 to 9.7. Right now I have the
9.7 Express-C version installed on my laptop. I am using the 64-bit
version with...
ichabod
|
05-11-2011 06:14 AM
Serge Rielau | 2 | 47 |
| | | Hi to all readers!
If you or your company is experiencing problems with any databases,
then we can tend to the problem! And have it back at you in a...
Johan Steytler
|
05-11-2011 06:03 AM
Bruce | 1 | 61 |
| | | Has anyone heard of a table going into reorg pending state without a schema
change being made? Possibly related to automatic maintenance?
Mark A
|
05-09-2011 09:19 AM
Bruce | 3 | 53 |
| | | Table T
(
MACHINE_ID varchar(24) not null,
COLLECT_TIME TIMESTAMP not null,
DISK_ID varchar(60) not null,
BYTES bigint not null,
DISKIO integer not...
Michel Esber
|
05-07-2011 04:45 AM
Ian | 7 | 37 |
| | | what happens if a long calculation (update) is working on a table
using "alter table not logged initially" and other users try to access
the same...
John Hopfield
|
05-05-2011 04:42 PM
Ian | 1 | 35 |
| | | All -
DB2 LUW 9.1.4 under AIX 6...How to tell how many and which are active
DB's I have under an instance...given this:
Max number of concurrently...
Bruce
|
04-28-2011 03:09 PM
Frederik Engelen | 5 | 43 |
| | | "Bruce Miller" <brucewmillerdba (AT) gmail (DOT) com> wrote
I would say that bufferpools are the major difference, but not the...
Mark A
|
04-28-2011 02:03 PM
Mark A | 0 | 54 |
| | | A. G. Lisi's E8 model may be showing us what both our space & time
really are.
(Click link below.)
http://www.amperefitz.com/e8.htm
Crystals and...
fitz
|
04-28-2011 08:48 AM
fitz | 0 | 37 |
| | | Hi ,
Can someone tell me what happens when we issue a rollforward stop and
a rollforward complete.
Kamal.
Gladiator
|
04-27-2011 04:53 AM
Gladiator | 5 | 35 |
| | | Hi everyone ,
Is there any way to find out the SQL using more CPU Cycles. Not the
CPU time but more CPU cycles .
Thanks in advance,
Kamal
Gladiator
|
04-27-2011 04:06 AM
stefan.albert | 3 | 53 |
| | | Given:
with T (s,t) as (
values (1,1), (2,2), (3,3), (2,4),
(2,5), (3,6), (2,7), (0,8)
)
select s, t from T order by t
S T
-----------...
Lennart Jonsson
|
04-26-2011 12:22 PM
--CELKO-- | 9 | 53 |
| | | Sex sells. And, although it may seem absurdly out of context, it
definitely sells Business Intelligence (BI) software.
Though somewhat ironic, many...
janpelletier@yahoo.ca
|
04-26-2011 06:42 AM
janpelletier@yahoo.ca | 0 | 46 |
| | | Hi all,
does anyone know of a way to enable the Oracle data dictionary-
compatible views in a database that was created without the
appropriate...
joklassen
|
04-26-2011 02:00 AM
joklassen | 7 | 46 |
| | | i am using UDB 9.5 on windows... am trying to select 2 columns into
2 variables and can not get it to work...i can use the set if only
pulling one...
Herb
|
04-25-2011 08:40 AM
Serge Rielau | 1 | 42 |
| | | Hi,
I am getting the error when i runstats for a table SQL2310N The
utility could not generate statistics. Error "-668" was returned.
Also The...
kavin
|
04-24-2011 07:59 AM
Ian | 1 | 42 |
| | | Anyone have any benchmarks on running a large OLTP application on DB2 LUW
9.5 or 9.7 on RH Linux with Intel CPU hyperthreading turned on,...
Mark A
|
04-22-2011 09:01 PM
Mark A | 0 | 44 |
| | | Hello,
DB2 V9.5 FP7,
db2 "select B.NAME, COUNT(distinct A.ID), COUNT(A.ID) from (values (1),
(2),(3),(4)) as A (ID), (values...
Michel Esber
|
04-18-2011 04:50 PM
Tonkuma | 8 | 45 |
| | | Hello,
I have following questions
1. I am trying to find out of I can store db2 catalog information
inside Microsoft Active Directory. All of my db2...
db2admin
|
04-14-2011 03:29 PM
db2admin | 0 | 39 |
| | | Some tooling that I hope will make problem determination easier.
Comments welcome of course.
http://tinyurl.com/4xwvoad
Cheers
Serge
--
Serge...
Serge Rielau
|
04-14-2011 12:10 PM
Serge Rielau | 0 | 50 |
| | | How do I count number of rows in tables in a schema? I am using DB2 on
ZOS.
Thanks,
Joydeep
Joydeep Chakrabarty
|
04-13-2011 09:11 AM
Lennart Jonsson | 10 | 65 |
| | | I am using DB2 9.5 FP7 on Linux. I can't find the packages for some
application written UDF's (SQL). Do SQL UDF's have packages?
Also, if a column...
Mark A
|
04-11-2011 02:41 PM
Serge Rielau | 1 | 44 |
| | | Hi Group,
I've a short question:
Thinking about blocked bufferpool (yes, we use this) sizing...
Does DB2 ever use blocked area (or vectored only)...
stefan.albert
|
04-11-2011 09:54 AM
stefan.albert | 2 | 38 |
| | | web design services, XHTML Conversion Services, Offshore outsourcing
web design & SEO Expert Acedezines provides best services for your
website...
PSD to XHTML Conversion Services and PSD to HTML CSS Conversion Services, PSD to Joomla, Drupal, Wor
|
04-11-2011 06:54 AM
PSD to XHTML Conversion Services and PSD to HTML C | 0 | 44 |
| | | Hi,
I have downloaded and installed put_line function from IBM website. But
whenever I try to use that function I am getting error :
SQL0444N ...
Joydeep Chakrabarty
|
04-11-2011 06:48 AM
Joydeep Chakrabarty | 2 | 44 |
| | | Hi,
What is the best procedure to purge data from production db2 databases
without interuption of service and also with minimal or no risk?. I
need...
kavin
|
04-10-2011 11:56 AM
larry | 3 | 39 |
| | | I am very new to COntent Manger IBM and this question may not be
appropriate for this group bu I will give it a try anyway. We have
Content Manager...
bontemps
|
04-08-2011 06:34 PM
The Boss | 2 | 46 |
| | | Correct.
Only PUBLISHed routines/types/variables are visible outside the module.
Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW, IBM...
Serge Rielau
|
04-08-2011 01:24 PM
Lennart Jonsson | 1 | 53 |
| | | From the administrative view sysibmadm.bp_hitratio I get a high
negative value ( -89%) on one of the bufferpools. I didn't think that
could be...
oddbande
|
04-07-2011 02:48 AM
oddbande | 10 | 47 |
| | | I have 2 files. One is an existing file that we have had on our system
for years and was created with DDS. The other one was just created
using SQL...
Jeff
|
04-06-2011 02:23 PM
Marc Rauzier | 3 | 33 |
| | | Hello, DB2 V9.7
Is there a way to tell (db2 call) whether crash recovery is running or
is needed without trying to capture the data from the...
shorti
|
04-06-2011 12:39 PM
Frederik Engelen | 3 | 42 |
