I restored a database backup of db2 version 8.1.3  in DB2ExpressC edition
DB2 8.2.5 .Note that the OS in both cases in windows.It was smooth and
without any issues.There are about 800 user defined stored procedures and
functions.Till now all are behaving nicely.But still I think I ...

We are getting the following error while compiling the UserExit
program. Not sure where the problem is. We are using the IBM supplied
UserExit sample program. We have changed some variables according to
our environment.

Hello, everybody.
I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with
Examples", but still unable to answer this simple question.
I need to perform the full database backup for at least these two goals:

All,
In the past there have been complaints that the search facility of the
Information Center left a lot to be desired.
So for those who care there is news that the DB2 9 Information Center

I get a lot of such messages in the db2diag.log on the gateway:
I think I have to set the MONITOR SWITCHES off on the machine, where
the
messages come from

This is more a hypothetical question, but anyhow...we have the following
problem:
There is a possibility that, in the near future, we are to make a DB2
snapshot of a AS/400-based table to a Windows platform. Now, since we

Can you please help me with a step by step procedure to transfer files
from my PC to DB2-AIX and vice versa. I am new to both.
Example transferring a sql file to run from PC to DB2 on AIX.
PC-> OS windows

Hello Everyone! Newbie here...
I can't configure any remote clients to connect to my DB2 server, I am
able to run and connect local from the server, but if I try to connect
with a user and specify password it fails with the dreaded SQL30082N. I

What are the options available in DB2 to backdown from Fixpak 12 to Fixpak
10. The environment is 64 Bit AIX 5 system.
I have run the following tools after installing fixpak 12:
db2iupdt on all instances

Can anyone tell me how to change the date type of a column from
smallint to decimal in db2?
Thanks
Regards

I try to restore 2 database from V8 fix pack 12 to V9
One of them can restore OK while the other give the below error message
Can any one give me some hint of how to fix this problem
SQL2519N  The database was restored but the restored database was

           I have a doubt regarding the dropping of a column.
           As i've seen, we have an option like
          "alter table <table name> drop column <column name>" in
oracle.

I am using DB2 UDB 8.1 on linux platform.
I want to import or read .asc file from DB2 stored procedure. This file
contains encryption and decryption key in multiple lines. I have
following problem when i use load command or import command

db2 8.1.3 Windows
I have folowing table structures
CREATE TABLE tb_RTB(
EMP_ID    INTEGER,

I want to increase the SMS filesystems (two). Not having done this
before, I am not too sure about any possible consequences. From my
reading the planning guide, it seems I can simply add more space to the
filesystem (being system managed) as I would any other filesystem.