| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | 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 | 0 | 51 |
|  | Hi
o/s = windows
login user = siva
db2 connect to database user swami using ****
<=========connected===>
Sivaswami Jeganathan
|
10-09-2009 06:07 AM
Ian | 2 | 65 |
|  | 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 | 4 | 64 |
|  | 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 | 3 | 80 |
|  | 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-- | 1 | 91 |
|  | 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 | 11 | 154 |
|  | 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 | 8 | 112 |
|  | 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 | 1 | 65 |
|  | 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 | 6 | 99 |
|  | 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 | 2 | 169 |
|  | 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 | 2 | 75 |
|  | 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 | 0 | 200 |
|  | 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 | 8 | 66 |
|  | 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 | 5 | 135 |
|  | 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 | 2 | 177 |
|  | 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 | 0 | 195 |
|  | 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 | 0 | 84 |
|  | 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 | 1 | 65 |
|  | 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 | 1 | 59 |
|  | 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 | 2 | 136 |
|  | 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 | 2 | 69 |
|  | 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 | 0 | 44 |
|  | 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 | 1 | 87 |
|  | 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 | 0 | 75 |
|  | 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 | 0 | 46 |
|  | 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-- | 6 | 89 |
|  | 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 | 1 | 142 |
|  | 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 | 22 | 171 |
|  | 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 | 1 | 100 |
|  | 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 | 6 | 107 |
|  | *** 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 | 1 | 76 |
|  | 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 | 8 | 74 |
|  | 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 | 5 | 62 |
|  | 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 | 1 | 77 |
|  | "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 | 2 | 82 |
|  | (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 | 5 | 54 |
|  | (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 | 0 | 55 |
|  | (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 | 0 | 69 |
|  | 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 | 1 | 168 |
|  | 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 | 2 | 222 |
|  | 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 | 4 | 57 |
|  | 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 | 2 | 182 |
|  | 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 | 9 | 166 |
|  | 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 | 0 | 55 |
|  | 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 | 5 | 82 |
|  | 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 | 10 | 301 |
|  | 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 | 2 | 67 |
|  | 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 | 1 | 72 |
|  | 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 | 4 | 88 |
|  | 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 | 5 | 161 |