I'm using Db2 9.5 for LUW.
i have file which need to be loaded into the table and its residing
the server path c:\load.
now i have invoked the load command from claint, but it's giving error

(Infosphere Warehouse v9.5.1)
Encountered a problem migrating a single partition to multi-partition
Database.
Got a SQL error (don't have the exact code but it was something like

Looking back on it - knowing what I know now - I should have run
setup.exe by right clicking and explicitly running as an
Administrator.
Well, here I am. I installed DB2 Express-C from an account that is a

I find this expression in Oracle query:
cast(convert(char(10)
                    ,dateadd(d,i,start),120)  as datetime ) as taskday.
How to convert it in DB2?

Background
UDB 8.2, EEE, Lots of users, runing on AIX with an Switch 2, running
QP, running datastage PX
Here is the behavior we observe.  Over time the paging on the AIX box

We are using 8.2.9 Windows 64 edtion, in one of our projects we need
to recreate a few lager tables which have  many millions of rows each,
we have used concurrent Java threads to read from data source and do
batch inserts to the target tables concurrently, to speed up the

why mon_heap_sz is reporting a memory error though i haven't started
any event monitor ?
i have increased that value but without success
bug with 9.1 fixpack 5 ?

How does a SYSIBMADM schema created. Is this a default in V9 ? , bcos
i dont see it created by default in V8+ .
Thanks & Regards,
Kamalnath.V

What are the current query size limits (bytes) for various DB2
products?

I need to create an MQT on a nickname, the requirement is that I need
to transfer data from source to target when required (this is because
the nickname is slow - i can't implement required indices on the
source table - tooo large).

I'm new to DB2.  I want to remove large number of rows in a table
without filling up the transaction log space.  To this end we can
repeatedly remove a fixed number of rows followed by commit.  In
Sybase, one can write a simple transact SQL using rowcount and while

I developed a Stored Procedure for generic paging from any table. It is
working fine:
--#SET TERMINATOR !
CREATE PROCEDURE TAB_SEL_ANYPAGE(TNAME CHAR(20),PREDICATE VARCHAR(1000),

I'm working with a data model which is managed in the AllFusion ERwin
tool.
Within the modeler, some of the FK relationships are 'non-mandatory' -
which is to say that for a given child value, a parent value is

Our perl DBI is built on DB2 8.2. It runs fine on 8.2
However it does not run on 9.1. After the connect to the database, at the first
SQL it gives this error
"sql0818n A timestamp conflict occurred sqlstate 51003"

This is highly unusual. I do this only out of desperation. I am DB2
DBA on unix and recent had to take on Oracle admin as well. This
question is really about Oracle export/import.  Why I post here
( please allow me once ) because