Using DB2 8.2 FP 9 - 32bit on Solaris 5.8 and a tape management tool
of Veritas, the archive hangs on occassion.  The error is "shmat
failed" in the db2diag.log.  Then DB2 hangs and self corrects.
This seems to occur when a backup kicks off, initiating an archive.

DB2 LUW 8.2 FP15
When going from FP14 to FP15, is it necessary to
issue the db2updv8 command for each database?
Is this only intended to be used when moving from

             will  changes done on a  table data After  a load   with
nonrecoverable option on a archive loging enabled Database be
recorded  in  logs   if  we  don't  do  a  complete backup  after
load ?

I'm using JDBC to connect to DB2. I have a binary data (array of bytes) and
want to save them.
Is it possible to write an INSERT statement to do this:
INSERT INTO TABLE (ID, BYTES) VALUES(1, '0x33 0x34') -- for example

Up until now, I've been working with V& DB2 UDB databases, using
Embarcadero DBArtisan as my GUI tool. I also have other tools that I
use in my day-to-day job so running directly on the server via the CLP
is not a viable option.

Try every thing I know to remove this alias
I know there been other posting I read each one none seem to work.
Thank You
DLWasler

When i do a "db2 list applications", i get the required applications
with their ip addresses.
However, some of the application Ids are ip addresses while some
application Ids are arbitrary(like GA500A2B.K105.014AC7050331) and of

I dropped a not null column from a table.
After that i reorganized the table.
However, an update statement is giving error like
"(Reason "column number out of range".)  SQLSTATE=58004"

Can any one help me to get some documents regarding DB2 disaster
recovery with step by step procedures.
Thanks & Regards
```````````````````````````

For a new project, we have DB2 Express (DB2 ExpC with support) on
Windows Server 2003. We got HADR up and running for the database but
were unable to find the binaries for TSA.
As per TSA pages, TSA 2.3 is supported on Windows 2003. How can we

hi people
I'm searching a Java package similar to the XSU of Oracle for DB2 but
I haven't found nothing.
Do you know if it exists anything like that?

Hi people,
I have a Java application working with Oracle.
I need it works with DB2 and the problem is that it uses the
OracleXMLQuery class.

I have two databases in hadr, this morning i issued a "takeover ... by
force" because the normal takeover didn't worked. Now i have two standard
databases, and if i try to put the old primary database in standby mode i
can't but it's not in rollforward pending state.

I have a situation where many people will be connecting to DB2 through
various clients and applications.
Since people just connect to the Database through a client and leave
it as it is, the connections become more(even if he doesn't query

I'm trying to hook up some MS stuff to my DB2 LUW 8.2 FP14.
Can anyone provide any guidance on .Net Framework Data Provider
for DB2?  Is there one?  Where can I get it? I've been trawling
thru microsoft.com and my eyes are crossing.