Hello, I need to add patch2=6 in db2cli.ini do disable scrollable cursor. Should I put this entry in all client machines accessing DB2 server via...

Massimiliano Campagnoli

01-11-2010 02:19 AM
MarkB

Hello, I've recently upgraded a number of DB2 (AIX) instances from v. 9.5.4 to v. 9.7.1, and I've set CUR_COMMIT to ON (yeah!). However, I have...

Troels Arvin

01-11-2010 02:14 AM
MarkB

Hi! How can I configure db2 to only accept connections from localhost? I'm using db2 Expressc v9.7 on linux. Regards G

geranium

01-07-2010 08:14 AM
Arun Srini

Hi and happy NY2010 to all, after upgrading from DB2 V9.1 to V9.5.4 (AIX), we started having a problem with some SQL statements: certain (small)...

Damir

01-07-2010 07:04 AM
Damir

I have a column batch_id and tons of rows under each batch id. I need info of batch_ids that have atleast one student whose name begins with a. I am...

Arun Srini

01-06-2010 05:20 PM
jefftyzzer

According to the manual, using "allow write acess" should allow other users to have read and write access to the table while it is...

tg

01-06-2010 12:53 PM
Naresh Chainani

My V8 HADR reference states that "Blobs and CLOBs are not replicated; however the space for them will be allocated in the standby database." Does...

Valerie

01-06-2010 06:49 AM
Serge Rielau

DB2 ESE V9.5 on AIX Is there a way to perform the alter bufferpools command in a stored procedure...I seemed to remember running into something that...

shorti

01-06-2010 06:39 AM
Serge Rielau

Hi, We are working on database connectivity with DB2 as database and db2jcc driver (DB2 v9.1.400.359). Connection get established properly to...

mahesh Bhole

12-30-2009 10:52 AM
joeNOSPAM@bea.com

Hello, I'm trying to upgrade a DB2 v. 9.5.4 (AIX 64 bit) to version 9.7.1. However, db2ckupgrade complains: ADM4104E One or more databases are...

Troels Arvin

12-29-2009 04:07 PM
Troels Arvin

Hi, I know that if I set a special register (such as CURRENT SCHEMA or CURRENT REFRESH AGE) inside a stored procedure, the special registers are set...

Ian

12-29-2009 10:43 AM
Serge Rielau

I can not get db2move work with db2 9.5 -> 9.7. I am running db2move utility on target system. Source db is 9.5.4 target db is 9.7.1 db2move test...

hsn_

12-28-2009 09:29 PM
Serge Rielau

Hi there, currently i have a problem with db2 express c 9.7 and php under linux... All programs run on a single server, that is devided into virtual...

Christian Welzel

12-27-2009 11:15 AM
Christian Welzel

Hi, I was asked to restore db2 from netbackup. By following the procedure from the netbackup, the following 2 steps were ran: (1) db2 restore db...

dolphin

12-21-2009 02:54 AM
Frederik Engelen

Problem: I have 5 systems located around the world with db2 data bases containing customer data that i support. i have telnet access to each system....

Stephen

12-18-2009 08:09 AM
Stephen

In a corporate consolidation of servers, our DB2 server got migrated to a new shared enviroment comprised of IBM P6 with 2 LPARs, 9 CPUs, 25 GB...

esmith2112

12-17-2009 03:49 AM
stefan.albert

Everything iSeries is designed to provide our visitors with a site dedicated to meeting all of their IBM iSeries needs: Access to iSeries Vendors;...

iSeries

12-16-2009 09:12 AM
iSeries

I'm really pretty new at this, as you can probably gauge from the sophistication of this question, but here goes anyways: If I had two massive...

burgermeister01@gmail.com

12-15-2009 03:19 AM
Frederik Engelen

Software and Applications built for iPhone are in true sense the display of one’s creativity, which blends well with the technology. Aquilonis has...

daisy michael

12-14-2009 11:14 PM
daisy michael

For unix, TSA installation files are included on the DB2 Installation media. But not for windows even no plattform limitation for using included...

DB2

12-14-2009 08:15 AM
DB2

Hi, I'm trying to calculate the number of items left based on the following: if date = current date then num items = X else num items = prev num of...

portaldev

12-11-2009 05:28 PM
Serge Rielau

I'm having a problem getting snapshots on my DB2 v8 FP 17a instance on AIX. Here's my procedure: 1) Set all the montior switches for my user...

AntiVirus DBA

12-09-2009 04:35 PM
AntiVirus DBA

Hello all! we're deleting huge amount of records from a table. We had a perl script to do in loop by 100, 500, 1000 etc records in a loop but...

Oleg Kozlovski

12-09-2009 04:33 AM
Oleg Kozlovski

Hello, As of Federation Server v9.7, DECFLOAT is a supported data type for DB2 data sources. Does anybody know whether it would be possible...

Frederik Engelen

12-08-2009 10:15 AM
Frederik Engelen

The Yellowfin BI team have produced a new paper on "Business Intelligence on Mobile devices". Anonymous Download Link...

JTP PR

12-08-2009 05:26 AM
JTP PR

Hi all, Does anyone have experience with impersonation within stored procedures? I would like to impersonate current user to admin user then do...

mxb1c

12-07-2009 09:25 PM
Sawan

Hi, We are facing performance issue with the following query. Is there anyway that we can optimize it? Can someone advise what type of index can be...

xeqister

12-07-2009 03:25 PM
The Boss

Hi, I am working on providing a standby DB2 database copy of a live database for a client. But client does not want to use HADR (because of cost,...

ranjit

12-07-2009 12:56 AM
Mark A

On 12/3/09 6:28 AM, shawno wrote: DB2INSTANCE should be set in the environment, not via the `db2set' command (i.e. in the DB2 registry -- not to be...

shawno

12-03-2009 05:45 PM
Ian

C:\Documents and Settings\Administrator>db2 create...

Sivaswami Jeganathan

12-02-2009 04:43 PM
hsn_

ordered_data(COL1, COL2, COL3, ORDER) AS ( select col1, col2, col3, row_number() over(ORDER BY col3) from sample_data )

esmith2112

12-02-2009 04:38 PM
Tonkuma

On Dec 1, 8:05*pm, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote: Points for your honesty :-) I am ambivalent personally, but our developers...

Damir

12-02-2009 04:26 AM
Damir

The query below never works when executed from DB2 9.5 control center FOR v_row AS SELECT label FROM component DO update gateway_authentication set...

antonio

12-01-2009 04:12 PM
antonio

Hi there, I have a problem with the connect to db2... Whenever i call "db2 connect to DB" on the system where the db2 runs, i get the following...

Christian Welzel

12-01-2009 11:39 AM
Christian Welzel

create table process_table(row_id,claim_id,seq_num) as ( SELECT w.claim_id,w.seq_num FROM ( SELECT row_number()...

Arun Srini

12-01-2009 08:52 AM
Arun Srini

Running DB2 V9.5 UDB on AIX I was wondering if there was a way to add directives to the DB2 DDL files? Specifically, I am looking for something...

shorti

11-30-2009 01:27 PM
Serge Rielau

Hi, I would like to use iBatis in a Java Stored Procedures in the newest DB2 Version on z/OS. I made some tests around this, but I got always the...

Benjamin

11-30-2009 07:26 AM
Benjamin

Hello, This is my first post to this group so please forgive me if I do anything wrong. I have some experience with DB2 previous versions and have...

Filozof71

11-30-2009 03:30 AM
Frederik Engelen

To those who have been waiting for FP1 before getting serious about DB2 9.7 its' now out there: http://bit.ly/5BxCY2 A summary of what's new can be...

Serge Rielau

11-27-2009 07:33 AM
Serge Rielau

Hi list, we are currently facing an Oracle to DB2 migration project using DB2 9.7 but we are finding certain issues that could make...

jbaron

11-26-2009 02:39 PM
Serge Rielau

After a fixpack upgrade on Db2 LUW 9.5, can one run db2updv95 on the Primary database and have everything replicate over to the Standby?...

Mark A

11-26-2009 06:02 AM
Frederik Engelen

Hi My requirement - write a function to return count from a table that is given in the argument. reason : use the function in sql like select...

Arun Srinivasan

11-25-2009 11:12 AM
Tonkuma

i spent an hour or 2 debugging this one and thought i'd share this.... DB2 allowed me to build a Proc where i had a varable that had the same name as...

Herb

11-25-2009 08:32 AM
Serge Rielau

Hi I am running an SP that don't log the loop number or anything to find it's progress (not written by me ;) ), and the dev needs info about the...

Arun Srini

11-24-2009 03:15 AM
Frederik Engelen

We have mainframe DB2 and use Federation Server to get access to Oracle databases from mainframe applications. The following is a particular...

Frank Swarbrick

11-19-2009 05:47 PM
Frank Swarbrick

I am writing to sollicit your help in collecting data for a project at the Institute of Management of Tunis in Tunisia. We have derived a...

latifa rabai

11-19-2009 03:18 PM
latifa rabai

Hi, I am not able to run any db2 commands from instance home directory while from everywhere else it is working fine. it is really strange. the...

sandeep.iitk@gmail.com

11-18-2009 11:04 AM
Ian

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 09:34 AM
Mia

Philippines, November 13, 2009 – leading Business intelligence (BI) firm, Yellowfin, today announced details of its exclusive...

JTP PR

11-18-2009 03:43 AM
JTP PR

Can anyone lend insight on performance comparisons between Linux & AIX BCUs? I'm really enjoying the BCU books - like the thoroughness, etc. ...

kenfar

11-17-2009 07:14 PM
Mark A