We are moving from 7.2 to 9.x. So I'm trying to restore a 7.2 backup
to a 8.1 and I'm getting a sqlcode 2038N with system error of 1062. We
have to got 8.x then move 9.x.
Here is the command that I'm using from the command line.

I've been trying the following in DB2/LUW since version 8.2 (9.1 and now
9.5) and I've never been able to get this to work.  (Not this exact SP,
which didn't exist prior to version 9, but just any SP that returns result
sets.)

The environment: Aix 5.2 with DB2 8 FP 14 all 64bit).
The situation is that another company is hosting our databases and
management has decided to move these databases in-house.
Now, the hosting company has a large (40gb memory) server with very

The chalange:
 Provide historical reports on Quantity on hand (QOH) at any given
time in history.
We currently have a historical journal of all changes to QOH and an

I''ve created a script that enable the statistics for a specific DB:
#!/bin/sh
if [ $# -eq 1 ] ; then
 echo Enabling monitoring switches for ${1}

I have several files with data I would like to import into DB2, but I
have timestamps set in a format, which DB2 can't catch - DD-MM-YYYY
HH:MM:SS
DB2 wants to get the year first. Is there a way I can say that my data

Question About Merge
DB2 V8 LUW FP 15.
Hello,
Consider table A (ID integer not null PK, Field2 varchar(50)).

Is there any way to generate the Insert scripts for a table in DB2?
Is there any db2 command for the same?
I had know about a few Oracle Clients which had such utility(like PL/
SQL developer/ TOAD).

I am trying to understand why (and when) DB2 rounds double values.
Example:
(a) Using CLP, I do this query
SELECT ref_value FROM stz_target_data WHERE version = '6.2' and g_name

I see a lot of dump file with this kind of messages on the db2dump
path, what is this ?  I looked up SQL0820N, it says the is some
connector exceeding its limit. How can I find out what the limit is
and how I can change it ?

Does anyone know how to export data from an Oracle database to a DB2
database?

DB2 manuals from IBM.
Anyone have any DCF manuals.

Am currently working on this DB2 Developer position and wanted to know
if generally most DB2 Database developers are required to work around
Cobol programming or is it just an add on to the main role of Database
Development.

We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3
which has Automatic Storage (AS) enabled. We want to disable
automatic storage on entire database and/or disable automatic storage
on all tablespaces. DB2 Manual says it once AS is enabled, it cant be

Are there advantages to choosing, say, IBM-1252 over UTF-8?  If my PC
application uses code page 1252 will it perform better because no code page
translation is required?  I assume so.  What type of performance hit might I
expect when connecting to a UTF-8 database?  What advantages ...