Folks,
 I want to move the databases I have on a HP-UX system running DB2 UDB 7.2
 to and AIX box running DB2 UDB 8.1. Because they are on different versions
 and different OS I cannot backup on HP and restore on AIX.

db2 => create regular tablespace tablespace2 pagesize 4k managed by
system using ('D:\') extentsize
DB21034E  The command was processed as an SQL statement because it was
not a

We are on 8.1.6 currently on AIX.  Has anyone been able to come up
with a solution that allows the ability to do a RUNSTATS from SQL
prompt instead of the command line?  I see lots of posts about writing
a C procedure or something along those lines.  Has anyone done this?

I am using the DB2 CLP tool and want to format my text columns in a
query to truncate the results of a wide text field - 50 char field but
I want to display only the first 10 chars.
My base query:

Just recently I got hired by a large company to evaluate and document a
large banking system written in COBOL and stored on the mainframes with
DB2. The current documentation is very poorly written, so I basically
need to start from the scratch and find out how everything works with

Folks,
I am using DB2 UDB 8.1 on RedHat ES 2.1. In order to improve performance
of one of our table, I would like to preload some or all of the data into
memory when I start DB2.

I played around with SNAPSHOT_DYN_SQL and other snapshot functions, and
is a bit confused. From what I found in the manual it says that
TOTAL_EXEC_TIME represents seconds and milliseconds, but the type of
the column is bigint. Should the value be divided by 1000 inorder to

After upgrading a test database to V8.2 with FixPak7a, too see if
the production servers can be safely upgraded, I noticed that inserts
on an insertable view which consists of multiple underlying tables
stopped working. After playing with it some more, the only failure mode

Hi I am a newbie in DB2 and Mainframe.I would like to know if there is
any diffence between the Quantified Predicates:  IN , ANY, and SOME.
Thank you very much for your valuable time.
Regards,

I'm running DB2 v8.1 FP5 and am trying to link tables via ODBC from Access
2002 to my DB2 database.  Access lets me connect to the database and returns
a list of all tables I can select from, but when I select one and choose OK
(to link or import) I immediately get the following ...

I am aware that v7 Static Scrollable Cursors do not work with
pseudo-conversational CICS because of the temp work file being
destroyed but will v8 Dynamic Scrollable Cursors work with
pseudo-conversational CICS due to these cursors directly using the base

i've encountered a problem with db2image extender for db2 version 8.2
i inserted a record into table allegato_immagine:
insert into allegato_immagine values( '1',
mmdbsys.db2image(current server, 'c:\1.jpg','JPG',1,'immagine 1')

We are running on Win 2003/DB2 V8 FP7a.
My question concerns Task Center.  I have about 200 tasks created and
scheduled in Task Center.  We are going to be moving many of the
databases from this server to another V8 server and I really, really,

I am trying to use the new functionality to alter a CHAR(8) to CHAR(10)
... I figure DB2 now does all the steps automatically ... with my first
try I got the error message below !  I then tried the same operation on
a different BD\Server and it worked!  Is their someone that has ...

I have installed DB2 UDB v8.2 on Solaris 5.8. Primarily an Oracle DBA,
I am new to DB2 and looking for the sqlmon.h file every where to get
the values for monitoring status like "APPL_STATUS".
1. I cannot locate the file under $DB2PATH/include/*