create table 't1 (c1 int not null, c2 date not null)' insert into t1 values '(0,current date + 10 days)' insert into t1 values '(1,current date...

dhooghebernard9@gmail.com

10-09-2012 03:49 AM
Lennart Jonsson

The next DB2 for Linux UNIX and Windows Tech Talk is a what's new from the IOD conference for the DB2 and related product set. This will include...

crussell@us.ibm.com

10-08-2012 12:34 PM
crussell@us.ibm.com

Hi, DB2 9.5, DB2 9.7 or DB2 10 on Windows 2008 I have the following requirement which I have been searching for a solutionfor a long time, but...

Rudolf Bargholz

10-08-2012 06:54 AM
Luiz da Silva

Hello, When using wildcards in the packlist (i.e. syspacklist.name = ‘*’), how does the system resolve which packages to call for a given plan? I’d...

claes_douglas

10-02-2012 09:45 AM
claes_douglas

We are migrating an application that uses DB2 UDB 8.1.3 as its database. It's an old application and the code is missing as usual. We are trying to...

Hitesh Bagchi

09-21-2012 05:54 AM
nikhilreddyp@gmail.com

Hello folks, I'm a Windows DBA and have been asked to setup DB2 federation to query AS/400 data from DB2 on Windows. I have got federation feature...

simon4rum@gmail.com

09-20-2012 10:57 AM
simon4rum@gmail.com

Join Chris Eaton and host Serge Rielau for a discussion of DB2 Compression capabilities. He will compare DB2 10 for Linux, UNIX and Windows to...

crussell@us.ibm.com

09-19-2012 09:55 AM
crussell@us.ibm.com

I use Data Studio to deploy our z/OS 1.12 DB2 v9.1 started procs. (This has worked fine in the past, but now is presenting a problem. When I...

Lost In The Outer Spiral Arm

09-18-2012 01:23 PM
Lost In The Outer Spiral Arm

This'll start your morning off right! Just an FYI for a laugh: ---------------------------------------- The phrase "An unexpected and critical...

Bruce

09-18-2012 06:12 AM
Bruce

IDUG DB2 Tech Conference in Orlando, Florida, USA 2013 The Call for Presentations is now open! Get a FREE IDUG Conference pass! Earn the respect of...

UDBDBA

09-11-2012 11:04 AM
UDBDBA

Hello, Just a simple question: how can I obtain a dynamic "SELECT" statement ? I tried the code below but it seems that dyamic select is not allowed...

diabolik_giant

09-11-2012 05:33 AM
Bruce

All - Aix 6 and DB2 9.1.4... I've been asked to upgrade this client's DB from 9.1.4 to 9.7...fine...there is no history or documentation about the...

Bruce

09-06-2012 06:15 AM
Bruce

Hello db2-experts, I'm planning an asynchronous application driven data replication. Therefor I want to call a stored procedure in database "x" on...

Frank Mickler

09-05-2012 05:24 AM
Bruce

Join us on September 11, 2012 to learn more about the benefits and advantages of realtime operational warehousing as compared to non-realtime...

crussell@us.ibm.com

09-04-2012 12:59 PM
crussell@us.ibm.com

We can't keep a 10.1 running for more than 20 hours. It's running on a test machine that is hardly used - never more than a single user and single...

Simon Temple

09-04-2012 02:42 AM
Simon Temple

Trying to set up connectivity for clients against a newly upgraded (from 8.2 to 9.5 fixpak3a) database on AIX 5.3. However, I can't determine the...

esmith2112

09-04-2012 02:15 AM
vinodhs.1987@gmail.com

Production DB2 9.7 instance won't start with SQL1092 on db2inst1 Please help, I am really confused about this error! We have a production DB2...

jmasonlee@gmail.com

09-03-2012 02:06 AM
Lennart Jonsson

Hi All - Db2 9.7.5 on Aix 6 For the instance-level login profile at login time I have the instance profile setup to display: DB2 Status: Instance...

Bruce

08-30-2012 07:25 AM
Bruce

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

08-29-2012 03:16 AM
paelzer@gmail.com

Hey everybody. I'm here to show my blog. Acess www.trocandoideiasti.com.br.This is a blog that covers issues related to the IT field. Discussions...

trocandoideiasti@gmail.com

08-24-2012 08:15 AM
trocandoideiasti@gmail.com

does anyone have any examples of SQL PL (ideally UDF) on UDB 9.5 or

Herb

08-24-2012 07:08 AM
joachim.c.mueller@googlemail.com

I read the regEx dev works article and others online. Nothing speaks about any special treatment the underscore(_) character gets in DB2, yet when I...

Arun Srini

08-23-2012 10:09 AM
Tonkuma

Hi I am in need of this SP and the get application_handle that gets created byrunning db2updv97 script. I am in fp 2 and the DBA team is not going to...

Arun Srini

08-21-2012 08:46 AM
Arun Srini

The goal is to create a delete trigger that copies data to an archive table.. If data already exists for a rept_id, it should delete it first. In...

Justin

08-17-2012 04:10 PM
Justin

These are technical deep dive webcasts on the products, presented by IBM experts for each area. August 30 - Application Performance Management Best...

crussell@us.ibm.com

08-17-2012 02:09 PM
crussell@us.ibm.com

Hi guys, Does anyone have experience with measuring or estimating the impact(cpu, memory...) of permanently having all monitor switches turned ON?...

Luiz da Silva

08-14-2012 06:00 AM
Bruce

Fellow DB2'ers... I have a new client running SAP and DB2 9.1.4 on AIX 5.3....In the process now of getting to 9.7.6 with AIX 6.3 and current...

Bruce

08-11-2012 08:37 AM
bwmiller16@gmail.com

Hi One SP that I saw in my db declares around 30 varchars of 1000 bytes each. It has an array definition where it stores 3 char values. We frequently...

Arun Srini

08-10-2012 04:44 PM
Arun Srini

I keep getting this error... while trying to build a UDF on DB2 V9 z/os. DB2 Database Error: ERROR 42601 IBMDB2 SQL0199N The use of the reserved...

Herb

08-08-2012 03:41 PM
CRPence

Hi All: I've been working with DB2 on Windows for 6 years now and I think i get tired of it due to a number of reasons. I often hear other...

simon4rum@gmail.com

08-06-2012 09:40 AM
simon4rum@gmail.com

Can someone please advise how I can go about converting existing tablespaces to enable RECLAIMABLE Storage. Would a redirected restore do the trick ?...

Fin

08-03-2012 05:33 AM
Luiz da Silva

Can some kind soul please tell me definitively when (at what threshold) a tablespace defined as managed by automatic storage will automatically...

Fin

08-02-2012 02:16 AM
Frederik Engelen

CREATE FUNCTION test( P_CTY_ST_C VARCHAR(10), P_DATE DATE ) RETURNS CHARACTER(3) -- VERSION V1 DETERMINISTIC NO EXTERNAL ACTION BEGIN RETURN ...

Herb

08-01-2012 10:56 AM
Cindy Ross

How do I concatenate strings from a column into a single row? Whats the logic to create the function in DB2. Given is...

mark83anthony@gmail.com

07-30-2012 12:13 AM
sahilrtlrtl@gmail.com

Mark, I have made changes to two of my tablespaces (rawdata & static) both of which are now managed by automatic storage and point to containers on...

Fin

07-27-2012 08:47 PM
Fin

Hi, i want to restore database to another disk because database(backup from another server) is too large for my db2 system disk. I'm try this...

Eiichiro

07-24-2012 08:35 AM
Bruce

Hi all, im getting this error while installing db2 in linux. please help me out. DBI1149E You have to be the owner of the install copy to execute...

kavin

07-23-2012 06:30 AM
Peter H. Coffin

Full...

janette.pelletier@yahoo.com.au

07-12-2012 06:27 AM
janette.pelletier@yahoo.com.au

Hello, How can i get rows amount per partition ? It's to check correct data distribution inside table's partitions. Can I do something like...

Filippo Conti

07-11-2012 08:38 AM
Ian

This Tech Talk series is increasing in popularity, since it includes deep dives on the all new DB2 10 for LUW product. July 26th is the next date,...

crussell@us.ibm.com

07-10-2012 03:22 PM
crussell@us.ibm.com

Can anyone suggest a utility for reformatting UDB DDL into 80 byte records for DB2 Z/OS? thanks, Dave

DaveA

07-09-2012 09:41 AM
DaveA

ALL - LUW 9.7.5 on AIX 6.1. Like most DB2 shops our data resides in DMS tablespaces and unfortunately most of our tablespaces remain Pre 9.7 with...

Bruce

07-02-2012 01:32 PM
Ian

I can't find this in the manuals. I'm not interested in size of primary or secondary logs, what is a good rule of thumb for how many logs to cut in...

John

06-30-2012 02:34 AM
ttumpa1986@gmail.com

Does someone else experience problems with the docs? They seem to have vanished in thin air for me. /Lennart

Lennart Jonsson

06-26-2012 10:34 AM
Lennart Jonsson

Hello friends, I'm new here ... I am configuring DB2 to receive connections with SSL authentication, part of the DB2 setup is ok to follow the...

Rodrigo Justina

06-22-2012 09:54 AM
Rodrigo Justina

I used to think the cost of an NLJOIN between an outer and an inner subquery should be at least card(outer) * cost(inner), but the optimizer of...

Oliver Schoett

06-21-2012 06:29 AM
Oliver Schoett

Is there a cfg or other setting to stop db2taskd? I have tried to force the pid and it has no impact.

Justin

06-20-2012 10:23 AM
Helmut Tessarek

Article...

janette.pelletier@yahoo.com.au

06-20-2012 07:46 AM
janette.pelletier@yahoo.com.au

Article...

janette.pelletier@yahoo.com.au

06-20-2012 07:44 AM
janette.pelletier@yahoo.com.au

Hello all, DB2 LUW 9.5 FP 9. Which of the following comparisons have a lower cost within a merge? 1) WHEN MATCHED AND NOT (

bruno.almeida@automatos.com

06-20-2012 03:18 AM
Frederik Engelen