I'm trying to rollforward my database to end of logs and complete, the
first error message i get is - SQL6063N rollforward recovery on
database X has stopped on node "0" due to change in log file size,
when i re-issue the command I get the " unexpected system error

I have a Oracle procedure which contains around 4000-5000 lines, which
i'm trying to convert it to DB2. I have changed the body of the
procedure to DB2 syntax and when i try to create the procedure, it is
giving ambigious error..

I am using an UPDATE statement through java program. It works fine on
windows. But When I moved the same code over to OS/390, I get the
following error
java.sql.SQLException: DB2JDBCSection Received Error in Method

I try to copy a table from production system (DB2 UDB EEE V7.2 + fixpak5)
to the testing system (DB2 UDB V8.1 + fixpak4a).
I moved the data from productions system by using the following steps:
On production system:

Hi IBMers,
I haven't used the db2 v8.1 on my win OS for a while, now, all of a
sudden, it became a stranger to me or vice versa, to start with, db2
db server can no longer starts, it complained about logon failure, I

DB2 Version 7.1 FP11 on Windows XP
I have a text file containing SQL. The text file was created using db2look.
CONNECT TO MYDB user db2admin using xxxxxx;
------------------------------------------------

I am setting up a database which requires some tables to store Thai
language data, as well as English data. For this, during the DB
creation of the test database, I set the following properties for the
DB:

Thanks guys for answering my previous question.
I created the users according to db2 installation manual as db2fenc1(
fenced user) and dasusr1( administration server user) during
installation but all the configuration using control center, im doing

Please see my error:
[db2inst1@kslnx sqllib]$ db2 "values abs(1)"
SQL0440N  No authorized routine named "ABS" of type "FUNCTION" having
compatible arguments was found.  SQLSTATE=42884

I'm using DB2 V7.2 FP8 on AIX 4.3.3.
When I query syscat.indexes or syscat.tables for PCTFREE on a table
and index that I have created (and updated statistics on), I get a
value of -1. I'm not sure what the CREATE INDEX statement was for the

Hai
        I have installed db2 8.1 on linux machine. The current db2
users are instance user(db2inst1), fenced user(db2fenc1) and
db2as(administration server).  To start using the database do I have

Greetings All,
Machine : IBM Netfinity 4 CPU
Os      : Win NT with latest service pack
Product : DB2 UDB     Release: 7.2

I have a great experience with DB (Oracle and others) and I am using DB2
now.
Then, I have few questions:
1. How drop a schema (user) and all objects of this schema, like a Oracle

it looks like that , by default, info integrator will use mixed case
when installing (on informix system) so tables etc. names look like
utCCDwhatever - however our environment is such that DELIMIDENT is not
turned on (the env. variable to allow mixed case). Does anyone know

Hai,
     I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My
machine is Intel XEON 64bit. The installation went well except for the
creation of tools catalog. When I tried to install the tools catalog