Hi..
Can any one know the installation steps of DB2 Version 8.1 and service
pack FP5..
My operation system WindowsXP

Here's the layout:   AIX v5.2,  DB2 v8 fp8  running in 64bit
I've got a Multi-partitioned db running on lpar4 and I want to
connect it to 2 instances running on lpar13.  We'll deal with just
1 instance on lpar13 for now.

hi gurus,
here is the problem
        i have a table with 2 columns first one is the primary key
with small int  next one is integer

I was just wondering if we can export just the schema/metadata in DB2
(i.e. just the table and column information, without the data). Is
there an easy way to do this in DB2?
Thanks in advance.

Hi, there .....
coming from the Oracle World I am wondering if there is a DB2 command
like "set linesize 1000" in SQL*Plus.
The DB2 Commandline inserts <CR> after n Characters but I want all

Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of
JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that
is installed on windows 2000?
I' m trying to access db2 from java aplication like this:

Hi..
Presently i'm trying to install IBM Db2 Software on my Windows XP
Operating systems.
I'm using IBM(R) DB2(R) Universal Database Enterprise Server Edition,

I'm a newbie with DB2 and I'd like to know if a standardized layout
exists for planning a proper installation. I'm referring to something
similar to OFA for Oracle.
I couldn't find anything googling around or checking on the IBM website

I have a primary server and backup server located in different physical
sites.
The primary server is live and ship logs to backup site every 5
minutes.

we're currently convert an old ISAM application to Java and DB2.
Among the load of problems we found the reports which have user
selections like "select all data between mm/yyyy and mm/yyyy".
Means: if the user enters "10/2004 - 10/2005" everything between

We all of a sudden find ourselves in dire straits, because we have one
of those mysteries where everything used to work, and apparently, all
of a sudden everything went to pot just in time for a major software
release. All of our Java stored procedures have developed some bad

It seems with V7 of DB2 I can now use Fetch First 1 Rows Only in a
Select stmt, whic is great, because I don't have to use a cursor.
Unfortunately, it doesn't allow ORDER BY in the same Select and the
order is important because I need to pick the next supplier in a

hi Gurus,
Presently we have code that "polls" DB2 tables checking for new data.
A much more effective method, especially for real-time systems, would
be to call Dot Net code directly from within DB2 "on insert" or "on

I am getting this:
RETCODE : ZRC=0x8B59000D=-1957101555=SQLKF_NOMEM_BUFFER_HEAP
         "No memory available in 'FCMBP Heap'"
         DIA8300C A memory heap error has occurred.

If I create the function HELLO in schema S01 as follows,
@
CREATE FUNCTION S01.HELLO()
RETURNS VARCHAR(32)