| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | 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 01:01 PM
whatever  | 4 | 5 |
| | | 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 01:55 PM
Arun Srini | 5 | 6 |
| | | 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 01:39 PM
whatever | 1 | 2 |
| | | 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 04:35 AM
Prax | 0 | 1 |
| | | Macquarie University generates new insights with Yellowfin Business
Intelligence
Macquarie University today launched the first phase of a...
janpelletier@yahoo.ca
|
05-18-2011 08:06 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Why does this SQL statement work
SELECT
CASE
WHEN A.DAILYDOWNLOADSIZE is null THEN 0
else bigint(A.DAILYDOWNLOADSIZE)
END...
kg6ypx
|
05-17-2011 02:38 PM
kg6ypx | 4 | 5 |
 | | https://www-304.ibm.com/support/docview.wss?uid=swg24029745
Some interesting SQL Enhancements:
* Pass ROWs and ARRAY's of ROWs between
JDBC and SQL...
Serge Rielau
|
05-16-2011 08:33 AM
Serge Rielau | 16 | 17 |
| | | 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 07:55 PM
Tonkuma | 1 | 2 |
| | | 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 07:39 PM
ichabod | 2 | 3 |
| | | 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 01:45 AM
iza.klosinska | 0 | 2 |
| | | 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 06:17 PM
The Boss | 2 | 3 |
| | | 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 11:53 AM
Lennart Jonsson | 4 | 5 |
| | | 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 10:54 AM
brunoalsantos | 4 | 5 |
| | | 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 07:14 AM
Serge Rielau | 2 | 3 |
| | | 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 07:03 AM
Bruce | 1 | 2 |
| | | 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 10:19 AM
Bruce | 3 | 4 |
| | | 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 05:45 AM
Ian | 7 | 8 |
| | | 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 05:42 PM
Ian | 1 | 2 |
| | | 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 04:09 PM
Frederik Engelen | 5 | 6 |
| | | "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 03:03 PM
Mark A | 0 | 2 |
| | | 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 09:48 AM
fitz | 0 | 1 |
| | | Hi ,
Can someone tell me what happens when we issue a rollforward stop and
a rollforward complete.
Kamal.
Gladiator
|
04-27-2011 05:53 AM
Gladiator | 5 | 6 |
| | | 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 05:06 AM
stefan.albert | 3 | 4 |
| | | 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 01:22 PM
--CELKO-- | 9 | 10 |
| | | 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 07:42 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | 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 03:00 AM
joklassen | 7 | 8 |
| | | 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 09:40 AM
Serge Rielau | 1 | 2 |
| | | 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 08:59 AM
Ian | 1 | 2 |
| | | 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 10:01 PM
Mark A | 0 | 1 |
| | | 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 05:50 PM
Tonkuma | 8 | 9 |
| | | 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 04:29 PM
db2admin | 0 | 1 |
| | | 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 01:10 PM
Serge Rielau | 0 | 1 |
| | | 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 10:11 AM
Lennart Jonsson | 10 | 11 |
| | | 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 03:41 PM
Serge Rielau | 1 | 2 |
| | | 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 10:54 AM
stefan.albert | 2 | 3 |
| | | 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 07:54 AM
PSD to XHTML Conversion Services and PSD to HTML C | 0 | 1 |
| | | 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 07:48 AM
Joydeep Chakrabarty | 2 | 3 |
| | | 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 12:56 PM
larry | 3 | 4 |
| | | 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 07:34 PM
The Boss | 2 | 3 |
| | | 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 02:24 PM
Lennart Jonsson | 1 | 2 |
| | | 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 03:48 AM
oddbande | 10 | 11 |
| | | 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 03:23 PM
Marc Rauzier | 3 | 4 |
| | | 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 01:39 PM
Frederik Engelen | 3 | 4 |
| | | International Business Intelligence (BI) software vendor, Yellowfin,
has partnered with data management experts, Ingres Corporation,
certifying...
janpelletier@yahoo.ca
|
04-06-2011 07:32 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Firstly I must admit to being constantly confused by the sheer scale
of REORG complexities on both tables and indexes.
I have a table that when I...
Fin
|
04-06-2011 07:21 AM
Bruce | 5 | 6 |
| | | For several years now IBM maintenance is a bundle that covers
"support" and "right to use new versions". Most software vendors have
and most of the...
Bernard
|
04-05-2011 05:14 AM
Bernard | 2 | 3 |
| | | "The" book for coding SQL PL procedures "DB2 SQL PL: Essential Guide
for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS" is still on its
2nd...
oddbande
|
04-04-2011 05:21 PM
Serge Rielau | 2 | 3 |
| | | Business Intelligence (BI) expert and founder of Dresner Advisory
Services, Howard Dresner, is set to co-host an exclusive live Webinar
on Mobile BI...
janpelletier@yahoo.ca
|
04-03-2011 06:38 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | DB2 LUW v9.5 fp7;
Consider the following statement:
MERGE INTO ADA.T_VMSTAT_CONV AS I USING
(
...
)
as INDATA (MACHINE_ID, COLLECT_TIME,...
Michel Esber
|
03-31-2011 03:57 PM
Michel Esber | 0 | 2 |
| | | I've learned to live with the cryptic but powerful syntax of the DB2 LOAD command, but I wish there was a way to sprinkle comments inside it, like...
Doug B
|
03-31-2011 03:34 PM
ch | 4 | 5 |
