Hi, Friends,
I have finised  upgrade our DB2 from 32-bit to 64-bit anf everything
went smoothly.
We tested more than 50 SQCs adn all aree OK except two SQCs.

I WROTE A QUERY WHICH COMPARES 2 STRINGS  AND PRINTS NOMATCH CHARACTERS AND
THEIR POSITIONS IN STRINGS.  IT IS WORKING PERFECT:
WITH T1 (COL_LENGTH) AS
    (SELECT LENGTH('ABCD$FMT')

Am out of the working world now but working on a project that requires
me to know what the output looks like from an IBM mainframe DCLGEN
operation.
In my days it would look something like the example below. Would it

i currently evaluating db2 express-c and therefor i wanted to migrate my
current database from mysql5 to the express-c... i didn't get it working
with mysqldump, and finally found the ibm data migration toolkit. But
whenever i want to start the conversation i get this exception:

This is a classic design flaw where someone failed to model durations
with (start, end) temporal pairs and need to fix it:
CREATE TABLE Foobar
(event_date DATET NOT NULL PRIMARY KEY,

I am about to make some changes to a process we have. The new process
will have a new table who's job it is to store temporarily data such
as customer, clerkno,productno, storeno , amount, time.
On a new request from a front-end i will select against the primary

I have DB2 9.1 on Solaris 10.
I am quite new to DB2, please forgive my limited knowledge.
I have a DBM CFG with
 Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

Is there a way to declare exit/continue handler for what ever errors
that happen in a compound statement?The reason I am asking this is, I
am doing more than one dcl in the statement, I may get a 'table
already exists' or 'parent row not found' errors. I just want to log

Probably a stupid question, but is there an easy way to determine how
much a table has changed since last time stats where updated? What I'm
trying to figure out is whether there is a need to do runstats on a
particular table or not.

we use Toplink (TopLink - 4.6.0 (Build 417) with a DB2 Database 7.2. i
know really old versions, but we could change to e newer one ;-)
Sometimes we got some problems with update or insert statements --
numeric value out of range. The SQL statements should be right. We

Hi, All,
We have DB2 ESE V8.2 on aix5l box.
I found on the aix box, DB2 has a lot files under /proc.
You can see from the following:

Can someone tell me how do i grant a Read privilage on all the tables
in a schema X to a different user who is not the owner of the Schema .
I dont want to grant him the Alterin privilage to the user.I just want
the user to read the tables in a schema for which he is not the owner.

Imagine 2 hosts: host A runs Oracle 10g , host B runs IBM DB2 v9. I
have to write a shell script (bask/Korn...) that checks if a database
instance is up and running and does a bunch of other stuff.
For instance, I can do something like this on host A (the host for the

I'm looking for a tool that can capture all the sql transactions for a
period of time (24 hours or so ) from our production server and replay
it exactly as entered on our performance tuning server.  Does anyone
know of such a tool from IBM or another vendor?

when subtracting 2 timestamps from each other the result is duration.
() But in DB2 the format is a bit funny:
lets say we have 59,5 seconds. If we have one second more, the result
is: 100,5. This mechanism works for seconds, minutes, hours, days.