I am trying to create a federated database using information
integrator.  When I tried creating wrapper on by right clicking on
"Federated database objects" which appears under every database, I get
the following error:

How can we increase the size of sortheap for individual sorts?
sortheap db parameter is the max mem that can be allocated for private
sorts or shared sorts so the parameter which would sorts should  be
app_ctrl_heap size or appheapsize rather than sort heap??

ZD-Net article:
http://news.zdnet.com/2100-9593_22-6057835.html
Download:
http://www.ibm.com/software/data/db2/udb/viper/index_download.html

i want to group few sql statements into one and run them in DataStage.
However, i am getting the following error:
BEGIN
DELETE FROM DEVSTGEV.STG_EV_RSKV_IO;

I have a SQL Server code which goes like this:
UPDATE ms
SET c1 = ms.c1 + ur.c1
FROM test ms

I am getting unwanted duplicate rows in my result set, so I added the
DISTINCT keyword to my outermost SELECT. My working query then returned
the following message:
DB2 SQL error: SQLCODE: -214, SQLSTATE: 42822, SQLERRMC: CASE...;ORDER BY;2

I have a requirement in which a pdf page has to be stored in the
database. What should the table definition like ?
Create table Page(
pageID integer not null,CustID integer not null,

How can we increase the size of sortheap for individual sorts?
sortheap db parameter is the max mem that can be allocated for private
sorts or shared sorts so the parameter which would sorts should  be
app_ctrl_heap size or appheapsize rather than sort heap??

On DB2 on AIX, I'm attempting to retrieve the most recent ID for each
unique Code based on its EffectiveDate.  For example, in the data
below, I want to retrieve ID BE0191026 as it has the most recent
EffectiveDate, 1/1/2001, for the records with the Code PG2SS0.  Can

I am writing a Stord proc in db2 in which I am querying(select query) a
table in the database and picking 2 values.These 2 values are inputs to
the next select query and so on.Totally I have to fire 5 queries and
finally all the required fields are populated in a Temporary table.

I was runing  load and then set integrity with for exception clause,
still the statement failed , there are some reecords in the exception
table but the actual table is still in check pending state...what s
causeing this?? i was under impression that if i use for exception the

Linux RH 4.0 running DB2 V8 FP 11.
I have a table with ~ 11M rows and running DELETE statements is really
slow. Deleting 1k rows takes more than 3 minutes. If I run select
statements on the same table, I usually fetch rows in a reasonable

I recieve this error message SQL0954C when i execute an SQL, it is
failry complex ... i've seen more complex sql's running with out any
error. We are on partitioned database with intraparallelism should i
increase the Appheapsz or app_ctrl_heap_sz??

I have the default TEMPSPACE1 (4K) in my database and another 4K
tempspace (T_0001) of bigger size. A particular query failed with "File
System full error" db2diag.log shows the following error message
2006-04-16-20.34.55.088285-240 E1002439A714       LEVEL: Error

I want to start a query with wildcard at the beginning of a string e.g.
"select column1 from table1 where name like '%string'", or at both ends
of the string, e.g. "select column1 from table1 where name like
'%string%'", the speed is a lot slower than when the wildcard is only