I encrypted a string within a Java application. I need to store that
encrypted string in a given field in the DB2 database. Currently the
datatype for that field is char(10). I am getting a SQLCODE: -302
error, which means incompatible data types.

Can anyone help with this message?
2006-11-29-00.32.10.049000-360 E3385208H395       LEVEL: Error (OS)
PID     : 2424                 TID  : 2724        PROC : javaw.exe
INSTANCE: DB2                  NODE : 000

v8.2.1, Windows.
I have a default installation on Windows where instance owner has
administrative rights in the system.
In this case user with only CREATE_EXTERNAL_ROUTINE authority and

This is a shell question (bash), but i'm more familiar with this group,
so i hope noone minds.
I have a bash shell script which needs to query the database and return
information into a variable. This can be done with a subshell, but that

We are currently in the process of migrating our databases from a relic
of a server to a new 4 processor dual-core box with 4 gigs of RAM.
Overall, database performance is obviously dramatically improved.
However, I've noticed something odd with some of our larger tables

I have an issue, that a big select statement causes the followong
error:"SQL1585N  Es ist kein temporärer Systemtabellenbereich mit
einer ausreichenden Seitengröße vorhanden"
So I created one using:

if i have one table like table1(c1 int,c2 date,c3 varchar) and has 29
million records and i divide table into small tables each having data
for one year like table1_2005 only contains records with year(c2) =
2005.

I am trying to change my Amount column Data Type from Integer to
Decimal (precision 9 digits, scale 3, that is 6 digits to the left of
decimal and 3 digits to the right of decimal.
Here is the error message I received SQL0443N  Routine "SYSPROC.ALTOBJ"

We're running DB2 v8.2 (fix pak 11) on Red Hat Linux Enterprise 3
(kernel 2.4.21-32) on Itanium (IA64).  For a few months now, we've had
a recurring problem where a shell script that we run nightly will hang
immediately after issueing a db2 connect statement.  The script runs on

db2 8.1 fix pack 12 on AIX 5.3
This is a newly configured HADR machine.  The HADR was up and running.
I was 'playing' around some on the standby and did a db2 deactivate and
things sort of went down hill from there.

I'm getting this error when trying to start and/or stop the admin
server on a db2 v9 on AIX 5.3
Everything worked fine with v8.2. I did the upgrade by the book.
any tips would be appreciated.

I downloaded the fast path to db2 course. I am unable to run it as it
comes back with the error
"There is no audio device available for Hotmedia audio player. This is a
result of another media player controlling the audio device. Depending

Brief info on the system:
Db2 version : "DB2 v8.1.0.121" and FixPak "13".
OS : RHEL 3  2.4.21-37.0.1
Memory : 8 GB

I am unable to connect to the database on the server from the client. It
gets connected at the server.
I tried the following options:
- export/import profile using CA

We have a program running on AIX and uses DB/2. Every once in a while,
while our program is just running along, DB/2 dies due to a signal 9
being sent to one of the EDU processes:
2006-11-14-12.26.23.442685+000 E396314C794        LEVEL: Severe