We are migrating a system from DB2 7.2 to DB2 8.2.2 for a SAP installation.
We have the migration guide from SAP.
SAP recommends using 16KB page sizes instead of 4KB page sizes.
What is the best route for us?  Can we export our 4KB data and IXF import it into 16KB

I want to list the User Tables which I have created (I am aware of the
Schema Name where the tables are residing).  The goal is to achieve the
following output with one single command or script:
TABLE_NAME     NUMBER_OF_ROWS     NUMBER_OF_COLS

Using classic ASP applciation with DB2 (just adding it to the apps
quiver of DBs). I am trying to do an insert and then retrieve the
auto-increment field's value using the standard ADO call of
   rsForm.Update

What is a joblog in DB2 and how to I check it. I am running DB2 version
8.2 on Windows.
Thanks.

Does anyone know how to solve this?
I am running IBM DB2 on a Linux server on a private LAN.
I am accessing it via ODBC from a Windows 2000 client
I also use the Windows 2000 machine as a VPN client

using the udb-type2-driver on z/OS DB version 7, we have a problem
getting the connection to the database. The small program we use looks
like this:
Class.forName("com.ibm.db2.jcc.DB2Driver");

I have an SAP development system running on Linux.  It is not a critical
system, but I would like a restore-able backup.  I have taken an offline
backup, but I am unable to restore it.
I am guessing I need to quiesce the database somehow and get it into an

Does IBM provide free SQL PL guide/doc ?
If so, please post URL.
Thanks!

Does anyone have any idea what might be causing this error?
2005-11-02-11.23.02.769000-360 I17004595H370      LEVEL: Severe
PID     : 3576                 TID  : 4632        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : CNTNTPUB

I have a v8.2 db2 server (FixPak 7a) running on
RedHat Enterprise linux v3 (2.4.21-37.ELsmp kernel)
Currently there is one database which appears to
badly need reorganization.  I'm new to this whole

I have a sql Stored Procedure running on aix5.1, db2 udb 8.1.2
it has a temp table, but when it's done running it does not free heap
memory, here is a snapshot of db2diag.log which becomes 100% full and
all applicatin hangup:

I have DB2 on Windows 2003 server using Server authentication.  How do I
backup up and restore the User Groups and locally defined users?  The
server is not part of a Windows' domain.
ntbackup of system state puts it into a .bks file, but how to restore

I am now designing a table for storing inventory of servers in a DB2
DB. However, I am new to SQL and would like to seek advice whether the
design could work as expect with DB2 SQL.
The high level of initial design is as follows:

Why is the following constraint invalid? I want to make sure that every
row in IS3.ANIMALS_PRIV_INDEXES matches one of those in
IS3.table_var_defn with part of the primary key fixed. Since this is
illegal with the following message, how do I achieve this result? The

I want to have a script that checks that my databases are up and
running.  I just want the scrip to connect to several databases and
check the count of a certain table.  I want this script to run every 10
minutes.  I know that every night I am taking the database down for