I have just installed DB2 UDB v8 on MS Windows and set up a federated
database connection to DB2 OS/390. I have successfully created and
tested USER MAPPINGs that allow me to connect to the Federated DB with
a standard network sign-on ID that is 8+ chars, and map that id to my

I'm looking at the MQ functions, particularly for use in conjunction with
the XML Extender.  I'm working with both Linux and AIX.
I came across a mqcheck script, which fails because a library isn't found.
Google search reveals this to be the MQ Application Messaging Interface.

I'm trying to create a UDF to match the DATEDIFF function in SQLserver.  
The
reason for this is that our cobol source has to be able and run both on
SQLserver and DB2 on Z/OS.  Sinds DB2 is the more powerful we decided

I am getting a -804 returned when I call my COBOL stored procedure
using a COBOL driver program. It keeps telling me the input parms
don't match what the stored procedure is expecting. I've looked at it
100 times and don't know what I'm doing wrong. Help!!

HI,
I need to loading following data into my timestamp column
Jul 14 2000  4:51:24:123PM
Because DB2 did not recognize this data format for timestamp,

Hi,
We seem to be able to always get the following behaviour with regards to
predicate push down into views, and I wonder if somebody could confirm or deny this.
From our observations, the following assertion seems to be true ?

Running DB2 UDB for UNIX 7.2.9
If I need to increase the dbheap size, is there any other parameter that
needs to be increased along with it? I have plenty of real memory, so that
is not a problem.

Hi all, I'm not a DB/2 performance expert, so I need some input into
how the bind process works. My organization uses a binding approach
where all packages for an entire subject area are bound together into
collections, and application plans may be associated with multiple

A test team member discovered this about orphaned db2agents and the
need to bounce the engine if this happens.  My question to the DB2
community is has someone found a way to kill these WITHOUT an engine
(instance) bounce?

The DB2 Support web site has been inaccessible for sometime now, at least
since 2 pm Paris time.
Do you known when access will be made available again ?
V8 displayfixpaktable: The query returned error: -30081

hi, we are using db2 udb v8.1 on windows,  i back up one database on
one server, and try to restore on different server. so i use redirect
restore since the path for the database is different, when i do set
tablespace containers for tablespaceid, do i need to do this for

I have a C++ CLI app that uses stored procedures to get record sets
from tables. It works fine except for accessing one of the tables,
which means the general logic of the code is OK. I got the following
error:

I am having a problem with multiple simultaneous ADO connections to
DB2 using DB2 connect.  Here is the usage scenario:
- create connection #1
- execute begin transaction on connection #1

we have the following constelation:
we have subroutines written in pli that are running in batch, online (IMS)
and StoredProcedures.
now we are trying to use DLLs

hello, we are using db2 udb v8.1 on windows, i found there is the
error in db2diag.log
ADM6019E  All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in
use.