I've worked with DB2 clusters in the past. I'm trying to get a good overview of the various layers of setup with SQL Server EE High Availability...

lee

10-09-2009 08:31 AM
lee

Hi o/s = windows login user = siva db2 connect to database user swami using **** <=========connected===>

Sivaswami Jeganathan

10-09-2009 06:07 AM
Ian

All, I'm looking to retrieve the instance owner home directory from the catalog/administrative views/... to use in a stored procedure, but I can't...

Frederik

10-08-2009 05:51 PM
Ian

Hello, As DBA IO received a call for support but can't help. A developper receive the following error, I assume there is a syntax error but...

bernard

10-07-2009 08:35 AM
bernard

Hi everybody, i'm looking for a documentation that could help me to create good stored procedure. Ex of questions that I have : - I would like to...

Karlitos

10-07-2009 08:30 AM
--CELKO--

I found that the file db2diag.log on my box is growing more and more. Is there a way to limit is size? Is it possible to limit the registration...

Franco Lombardo

10-06-2009 02:51 AM
Frederik

I'm running DB2 Express C 9.5 on Windows 95 SP3. Sometimes I find in the event log the error ADM6019E "All pages in buffer pool bpname (ID bpid) are...

Franco Lombardo

10-05-2009 10:37 AM
Mark A

Hello I tried to unload from a table or tabspace using BMC or IBM both are not working with ROWID. I wanted to have that tableapce with shrlevel...

sri

10-04-2009 03:50 PM
The Boss

I am an Oracle and SQL Server DBA, but i was asked a question about DB2. It seems we have a local Windows server application that has a DB2...

Mark D Powell

10-03-2009 10:54 AM
Troels Arvin

With the type 2 driver, TCP/IP access is not needed since one can just connect to the local database name without supplying and TCP/IP node or server...

Mark A

10-03-2009 06:25 AM
Mark A

Hi , We have plans to have production as the only Enterprise and set all other DB2 DB to workgroups. Can anyone tell me how can I downgrade from...

db2dba

10-01-2009 07:18 PM
db2dba

I noticed i db2diag.log a number of messages typically looking like: 2009-10-01-15.58.00.237090+120 E109392854E668 LEVEL: Error (OS) PID :...

Lennart

10-01-2009 09:16 AM
Lennart

Within the confines of a stored procedure how do I declare a cursor to return a result set to the client application, and also update a non- returned...

esmith2112

09-30-2009 08:27 AM
esmith2112

Hello, In a previous thread, I asked you why my code in a prepared statement didn't work. I've again several bugs. Here's an example with the table...

Michael B

09-30-2009 04:54 AM
Michael B

Anyone tried out the DB2_RESOURCE_POLICY with NUMA enabled on RHEL5. Even the sample xml resource policy file does not seem to work when I tested...

NJS

09-29-2009 09:09 PM
NJS

Have you registered yet for Episodes 2 & 3 of The DB2Night Show on Oct 1 and 15th respectively? http://www.DB2NightShow.com His kickoff Episode on...

thatdbaCLK

09-27-2009 11:22 AM
thatdbaCLK

Hi, i offer 400 pvu db2 enterprise with 5 months maintainance 9.5 for 40.00 Euro ( Listprise 180.000 Euro !!! ) regards klaus

klaus heller

09-25-2009 01:57 PM
klaus heller

UDB ver 9.5 LUW..... Im passing an XML document into my stored proc and before the proc puts that xml document into a table i am needing to parse it...

Herb

09-25-2009 09:37 AM
Herb

im getting the below given error in FileNet application. Please tell me whether it is DB2 related or it is a non DB2 error. if it is other. can any...

kavin

09-25-2009 07:50 AM
Serge Rielau

Hello, I waant to know how DB2 does scheduling on SMP. Rely on the OS or pin the process itself to individual processor. Also it take advantage of...

RNBJ

09-23-2009 06:27 PM
RNBJ

Hi, I'm trying to migrate a database from a Linux-IA32 V9.1 server onto a Linux-x86-64 server running 9.7 What I get is SQL2570N An attempt to...

alexs

09-23-2009 01:07 PM
Lennart

C:\Program Files\IBM\SQLLIB\bnd>db2 bind db2lkfun.bnd blocking all grant public LINE MESSAGES FOR...

Arun Srinivasan

09-23-2009 07:42 AM
Arun Srinivasan

Hello In order to solve a locking problem with the help of db2pd, i need to find the row that is acced by different sessions. db2pd gives...

wbehrent

09-22-2009 06:22 AM
Arun Srinivasan

Hi I have a table that has blob column. I used the cursor for select * from <> load from cur1 of cursor insert into <> nonrecoverable; but it just...

Arun Srinivasan

09-22-2009 03:38 AM
Arun Srinivasan

Submission date extended to Monday, September 28, 2009. See: http://www.ca.com/us/products/collateral.aspx?cid=201986 CA, in conjunction with IDUG...

thatdbaCLK

09-21-2009 10:27 AM
thatdbaCLK

Given a table of values and the ROW_NUMBER() function it is pretty easy to compute the traditional Median. Example: CREATE TABLE Foobar(x INTEGER...

--CELKO--

09-21-2009 07:21 AM
--CELKO--

Could someone notify IBM documentation that the event type DLOCKWHISTAVAL in table SYSCAT.EVENTS is not documented in either the 9,5 or 9.7...

Mark A

09-21-2009 03:46 AM
Serge Rielau

On Sep 11, 9:52*pm, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote: They still offering db2 for free to Oracle customers as well?

Serge Rielau

09-21-2009 02:48 AM
Noons

1) Is there any tool for v8 to v9/v9.5 migration 2) Can Migration just be done through backup and restore for v8 to v9.1 and v9.5 ? and config...

Sivaswami Jeganathan

09-20-2009 03:05 AM
Spider

Hi This is related to DB2 replication , Since this is my first time doing the DB2 replication, I want to know if DB2 replication can be done on the...

rick

09-18-2009 12:36 PM
Lennart

*** SCRIPT START: Connection: 10.30.5.10-BCULINP-PCFPROD (bculinp) Sep-18-2009 10:40:08 *** create procedure db2instt.proc1(OUT MSG...

Arun Srinivasan

09-18-2009 01:18 AM
Mark A

Argh - IBM's Partnerworld website's search capability is just horrible. Can anyone provide the link to DB2 9.7 Data Studio Administration Console? I...

dunleav1

09-17-2009 02:25 PM
dunleav1

Hi, Can you explain me why the DB2 function 'position' return this error : PreparedStatement prepareStatement =...

Michael B

09-17-2009 06:41 AM
Michael B

All, On this DB2 Fixpack 4a HIPER APAR page (http://www-01.ibm.com/support/ docview.wss?rs=71&uid=swg21396574), they mention this APAR: APAR...

Frederik

09-17-2009 04:54 AM
thatdbaCLK

"CLAIM_DOS_YR") (PART "P1" STARTING(0) ENDING(1997) IN "TS_PD_CCDB_DAT_001", PART "P2" STARTING(1998) IN "TS_PD_CCDB_DAT_001", PART "P3"...

Arun Srinivasan

09-16-2009 08:31 AM
Arun Srinivasan

(DB2 LUW v8x) Colleagues, I need to clarify something that I've seen inconsistent discussions regarding. I'd like to know if for a given UPDATE or...

jefftyzzer

09-16-2009 05:01 AM
Mark A

(DB2 LUW v8x) Colleagues, I need to clarify something that I've seen inconsistent discussions regarding. I'd like to know if for a given UPDATE or...

jefftyzzer

09-15-2009 03:09 PM
jefftyzzer

(DB2 LUW v8x) Colleagues, I need to clarify something that I've seen inconsistent discussions regarding. I'd like to know if for a given UPDATE or...

jefftyzzer

09-15-2009 03:05 PM
jefftyzzer

hi Just want to know if we can have two keys to data partition - or two sets. Like create table clients ( client_cd...

Arun Srinivasan

09-15-2009 01:48 PM
Ian

Hi all, I've written a java prog to read a squid webcache log file formatted so that each line is an xml record of the form (real squid og shown...

alexs

09-15-2009 10:31 AM
alexs

Hi folks, (DB/2 V 9.5 on linux) I created an update query using NULL value in WHERE clause. The program uses bound parameters. The update returns...

Axel Richter

09-15-2009 12:33 AM
Axel Richter

Is it the case that if "VARCHAR2 compatibility" is set for a database, that columns defined as VARCHAR behave with VARCHAR2 semantics? I...

Frank Swarbrick

09-14-2009 12:56 PM
Frank Swarbrick

Hello, I'm new to db2. I have Informix database on AIX and ODBC application on Windows. I'm trying to connect to Informix database using odbc client...

Robert

09-14-2009 07:52 AM
Robert

How Business Intelligence and GIS are becoming more integrated. Most people may think of geographic information systems (GIS) simply as Google maps...

JTP PR

09-14-2009 06:52 AM
JTP PR

I am trying to work out an olap query to allocate parts in stock to customer orders. Imagine to have a purchase order table like this: OrderID,...

Massimiliano Campagnoli

09-13-2009 08:59 AM
Tonkuma

Hi all. Does the REORG TABLE command execute also the REORG INDEXES ALL? I mean, after a REORG TABLE, do I need to reorganize the indexes too? I'm...

Franco Lombardo

09-11-2009 08:32 PM
Mark A

I am in the process of trying to help track down any failed Dynamic SQL Statements that might be sent to a DB2 LUW database . Failed Statements...

doug.partch@aciworldwide.com

09-11-2009 01:25 PM
Mark A

Hi, I am using a cursor in one of my stored procedure which is formed by union of queries on a certain set of tables. At Power-5 server with DB2 V9.1...

DivyaPrakash Jha

09-11-2009 01:04 PM
Serge Rielau

I know HADR is not a part of expressC version of DB2 9.7 . I came across a great article from ppl at Toronto about new HADR features and how they've...

Arun Srinivasan

09-11-2009 08:56 AM
Arun Srinivasan

I have an application that runs a query something like this: select resp_desc, count(*) from userid.survey_fact a, userid.client_service_dim...

Greig

09-11-2009 01:04 AM
Ian