| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | One of my favourite features of db2 is transactional ddl. There are a
few things (such as reorg) one have to look out for, but I find it
extremely...
Lennart Jonsson
|
Yesterday 07:23 AM
Lennart Jonsson  | 3 | 6 |
| | | My understanding is that a runstats will automatically invalidate packages that include the table on
which the runstats is done. That would imply...
Mark A
|
05-22-2013 12:49 PM
Helmut Tessarek | 1 | 2 |
| | | Hello,
I am applying for a job as db2 engineer and one of the requirement is to Certify DB2 v10. Company is moving from db2 9.7 to 10. I do not...
db2admin
|
05-22-2013 10:55 AM
Helmut Tessarek | 1 | 2 |
| | | Some observations, more out of curiosity than anything else:
$ db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code...
Lennart Jonsson
|
05-18-2013 12:28 AM
Mark A | 10 | 30 |
 | | On Thursday, May 9, 2013 1:25:17 AM UTC-7, Mark A wrote:
Oh no! Please don't puke, once it gets inside your keyboard there is NO WAY to get that...
Cindy Ross
|
05-15-2013 02:42 PM
Helmut Tessarek | 19 | 52 |
| | | BLU Acceleration in DB2 10.5 for Linux, UNIX and Windows delivers results from data-intensive analytic workloads with speed and precision that is...
russellcindy8@gmail.com
|
05-15-2013 02:08 PM
russellcindy8@gmail.com | 0 | 1 |
| | | We have group of server IDs, and group of user IDs. We are trying to find the best way to restrict the server IDs(generic - like db2adm) to connect...
Arun Srini
|
05-10-2013 11:21 AM
Arun Srini | 3 | 27 |
| | | We have group of server IDs, and group of user IDs. We are trying to find the best way to restrict the server IDs(generic - like db2adm) to connect...
Arun Srini
|
05-09-2013 01:44 PM
Arun Srini | 0 | 5 |
| | | Using DB2 Express-C 10.1.2 LUW on Win 7 Pro SP1 both 64-Bit, I have the below listed example portion of a SP.
The INSERT statement using the...
Fin
|
05-08-2013 07:03 PM
Fin | 2 | 17 |
| | | On Thu, 02 May 2013 04:21:53 -0700, Canwin P wrote:
I'm just a guest on this group and DB2 newbie, but I'm not sure that this
is the right place...
Mladen Gogala
|
05-02-2013 04:32 PM
Helmut Tessarek | 3 | 22 |
| | | Full...
janette.pelletier@yahoo.com.au
|
05-02-2013 08:27 AM
janette.pelletier@yahoo.com.au | 0 | 17 |
| | | Is it possible to install DB2 client product(s) so that the same system
can connect to host databases like DB2 Connect can, *and* can also
create and...
Cindy Ross
|
04-29-2013 07:42 AM
Cindy Ross | 7 | 36 |
| | | Have a stored procedure that runs the following
CALL SYSPROC.ADMIN_CMD ('RUNSTATS ON TABLE SDBXXX.TABLENAME with distribution and detailed indexes...
ultratruth@gmail.com
|
04-27-2013 06:42 AM
bwmiller16@gmail.com | 1 | 23 |
| | | Hi,
I am looking for somebody able to manage an IBM DB2 Express-C server in the cloud for me (I am a web developper) : installation, monitoring,...
floconsdepaques@gmail.com
|
04-26-2013 11:02 AM
floconsdepaques@gmail.com | 0 | 12 |
| | | Hi Team,
My env details
DB2 v9.5 , AIX 5x
As given in infocenter :
"If you do not specify the INCREASESIZE clause when you enable the auto-resize...
Satish Mullapudi
|
04-24-2013 11:48 AM
Helmut Tessarek | 1 | 18 |
| | | I have a 10.1 Infosphere warehouse setup and I'm having a rather peculiar issue now and again when I reboot my nodes (I have 2).
After rebooting...
fritalian@gmail.com
|
04-17-2013 01:17 PM
fritalian@gmail.com | 3 | 27 |
| | | There is some general confusion about pureXML and DB2 Bufferpools. The word seems to be that
pureXML uses DB2 bufferpools, but when we get down to...
Mark A
|
04-17-2013 12:23 PM
Helmut Tessarek | 16 | 62 |
| | | I've got the db2 per terabyte licensing on Infosphere Warehouse v10.1 and I'm trying to figure out how to determine how much of my license I'm...
fritalian@gmail.com
|
04-16-2013 05:24 PM
TheBoss | 2 | 22 |
| | | I just got this message from someone in the organisation of this lovely DB2conference in Dubrovnik and I thought I pass it on here.
"Dear DB2...
Frederik Engelen
|
04-14-2013 01:39 PM
Frederik Engelen | 0 | 15 |
| | | Hi All,
The version of DB2 am using is 9.7.0.5.
We have two environments where we have deployed one stored procedure where it is working fine in one...
Satish Mullapudi
|
04-13-2013 10:13 AM
Mark A | 4 | 38 |
| | | Join DB2 expert and Distinguished Engineer Berni Schiefer on May 8th for a technical tour of the new features of DB2 10.5 with BLU Acceleration. ...
russellcindy8@gmail.com
|
04-10-2013 03:03 PM
russellcindy8@gmail.com | 0 | 16 |
| | | May 3, 2013 in Orlando, Florida, 8 AM to 2PM.
Presenters Chris Eaton, Danny Arnold and Eric Alton are not to be missed!
This event is being...
russellcindy8@gmail.com
|
04-10-2013 02:53 PM
russellcindy8@gmail.com | 19 | 53 |
| | | Top Business Intelligence predictions for 2013 - P1
Full...
janette.pelletier@yahoo.com.au
|
03-27-2013 11:20 PM
janette.pelletier@yahoo.com.au | 0 | 26 |
| | | I'm not able to start my copy of DB2 9.5. I'm running Windows XP SP3 and
everything else is working just fine. When I try to start the...
Rhino
|
03-26-2013 02:15 PM
Justin | 1 | 35 |
| | | When running a very simple ingest command, it returns an error.
The environment is DPF v10.1
testfile.del is a simple file with two integers...
Justin
|
03-26-2013 02:09 PM
Justin | 8 | 25 |
| | | Good morning,
a question about vectored I/O vs Block-Based I/O while reading pages from disks.
As far as I have understood if you enable vectored...
Massimiliano Campagnoli
|
03-21-2013 02:29 PM
Mark A | 3 | 42 |
| | | I'm trying to compare io patterns as seen through a db2pd -d <database> -bufferpools report. The databases are "identical" and the same stress tests...
stavrogin
|
03-21-2013 12:57 PM
Jeremy Rickard | 1 | 25 |
| | | I thought some of you might be interested in this...
Summary: Welcome to the IBM DB2 Technology Preview. Here's a more active
approach to explore...
Helmut Tessarek
|
03-18-2013 09:36 AM
Helmut Tessarek | 4 | 33 |
| | | Given the following :
CREATE TABLE ABC
(COL1 VARCHAR(10) NOT NULL,
COL2 INTEGER NOT NULL,
COL3 INTEGER,
COL4 INTEGER,
COL5 INTEGER);
INSERT INTO...
Fin
|
03-18-2013 12:19 AM
Fin | 2 | 36 |
| | | Given a table of:
CREATE TABLE ABC
(COL1 VARCHAR(10),
COL2 INTEGER,
COL3 INTEGER,
COL4 INTEGER,
COL5 INTEGER);
How can I get the results that would...
Fin
|
03-16-2013 08:53 PM
Fin | 2 | 18 |
| | | I am trying to convert some oracle sql to db2.
The current issue is:
to_char(trunc(root_ah_runtime/3600), 'FM999999990') || ':' ||...
ultratruth@gmail.com
|
03-14-2013 07:43 PM
Helmut Tessarek | 6 | 53 |
| | | I create a SQL file like this :
" delete from ...
;
insert into ...
;
commit
;
"
Toralf Förster
|
03-10-2013 09:34 AM
Lennart Jonsson | 6 | 37 |
| | | During a db2rbind of ALL, I am getting the following error on 4 tables. Anyone got any ideas as to what is causing the problem ? The rebind log is...
Fin
|
03-09-2013 01:50 AM
Fin | 3 | 26 |
| | | The next DB2 Tech Talk can help extend your OLTP skills to include DB2. As data grows, so do the number of data warehouse applications because they...
russellcindy8@gmail.com
|
03-07-2013 04:43 PM
russellcindy8@gmail.com | 0 | 24 |
| | | Hello,
I have installed on Centos 6.3
PHP 5.3.3
DB2 ADCL 8.1 with fixpack 18
PECL ibm_db2 Driver Version 1.9.5
All works fine. I can connect to my...
ulrich45131@googlemail.com
|
03-03-2013 02:01 PM
Massimiliano Campagnoli | 17 | 45 |
| | | Hi.
We've been performance testing an application where a several users do a select and an immediate-after-that update on the same row in a...
gimme_this_gimme_that@yahoo.com
|
03-02-2013 02:54 AM
Lennart Jonsson | 4 | 28 |
| | | Hi Team,
My env is DB2 9.7 , RHEL
I have seen that db2 +c "insert into test values (1)" doesn't show the records insert into test from another...
Satish Mullapudi
|
03-01-2013 01:18 PM
Lennart Jonsson | 2 | 22 |
| | | Hi Team,
My env is DB2 9.7 , RHEL
when doing the bewlo:
1. db2 +c "insert into test values (1)"
2. open another session & issue "select count(*)...
Satish Mullapudi
|
03-01-2013 08:34 AM
Satish Mullapudi | 0 | 16 |
| | | On AIX 6.1, DB2 9.7.6
The customer is adding more main memory to AIX. They understand they can add memory dynamically to AIX but are not sure about...
bwmiller16@gmail.com
|
02-28-2013 06:00 AM
bwmiller16@gmail.com | 3 | 37 |
| | | When no application are connected the lock monitor switch is off but as soon as I connect to the sample application it is turned on by default.
Why ?...
Massimiliano Campagnoli
|
02-26-2013 01:21 PM
Helmut Tessarek | 3 | 21 |
| | | Good morning all.
I've just discovered that DB2 V8.2 at latest fixpack (FP18) does not work properly on linux kernel newer than 2.6.21.
Namely the...
Massimiliano Campagnoli
|
02-26-2013 11:01 AM
Helmut Tessarek | 1 | 18 |
| | | Hi,
I am trying to move a database from db2 expc from a linux server to a development machine running win xp sp3 32 bits. Both machines are on db2...
jtuchel@objektfabrik.de
|
02-26-2013 10:46 AM
Helmut Tessarek | 5 | 23 |
| | | I'm executing a SQL statement that calls a FUNCTION.
When the DBAs do an EXPLAIN on a SQL statement that uses it using ? as parameters a table a...
gimme_this_gimme_that@yahoo.com
|
02-22-2013 04:18 PM
Helmut Tessarek | 1 | 25 |
| | | Hi Team,
My env. details : Db2 UDB v9.7, RHEL , 16GB RAM.
Am facing a strange situation ! Am getting two different explain plans for the same kind of...
Satish Mullapudi
|
02-22-2013 07:53 AM
Peter H. Coffin | 3 | 25 |
| | | Hello,
ich have to insert a jpg picture with max 300k into a blob column of a DB2 8.2 Database. With java it works, but with I get an error...
ulrich45131@googlemail.com
|
02-21-2013 07:44 PM
Peter H. Coffin | 7 | 35 |
| | | Hi Team,
My env details:
DB2 UDB 9.7 16GB RAM RHEL
Satish Mullapudi
|
02-21-2013 01:09 PM
Helmut Tessarek | 3 | 28 |
| | | Hi
I have a view created using 'UNION ALL' over two tables with around 5 exclusive columns between them. The exclusive ones are varchars and...
Arun Srini
|
02-19-2013 01:14 PM
Jerry Stuckle | 24 | 85 |
| | | I have three scripts called extract_data_1.sql, extract_data_2.sql,
and extract_data_3.sql each of which exports data from a DB2 UDB
database (in...
annecarterfredi@gmail.com
|
02-15-2013 08:26 AM
Lennart Jonsson | 8 | 119 |
| | | Just an inquisitive question. I have col1, col2, col3 as primary key of a multi-partition table having 80 columns and to house around 100 mil rows....
Arun Srini
|
02-14-2013 11:37 AM
Arun Srini | 0 | 24 |
| | | The Boss wrote:
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
chester_perry@yahoo.co.uk
|
02-11-2013 12:31 PM
Lennart Jonsson | 4 | 290 |
