Using DB2 on the iSeries OS ver 5.2
I am trying to connect to the iSeries using MS Access & an ODBC
connection. I get an error saying that the SYSKEYCST in library QSYS2
is missing. I understand that SYSKEYCST is a catalog table so I am

I'm new to the world of the as400, but not to the world of SQL and
relational databases.   I would like to create a view on our as400
machine, but I understand that creating a view will create some sort of
lock on any 'files' that our RPG code references so they cannot be

Hi, All.
Is federated procedures between DB2 databases currently not supported
in WebSphere Federation Server 9.1 ???
I recieve next error when trying to create DB2 federated procedure :

DB2 LUW 8.2.7 FP14 Red Hat AS2.1
Since upgrading to FP14, I occasionally see this in db2diag.log.
It looks to me like a "db2start" has occurred, which really concerned
me initially, but the DB is just humming along - everything is fine.

Having a hard time with a UDF. Wonder if folk might care to take a look
and tell me what's up.
All of this kicked off from trying to build a set of C++ iostream
derived classes that can make

Hi All;
Am running DB2 LUW v8.2 (FP10) on AIX and having trouble with SQL
stored procedure bind options.
I have run the following code expecting to be able to change the

I'm new to DB2.
Is there a way to know the date format of the DB2 instance from a SQL
query?
I guess the date format or the country code is stored in a system

  i have a pb of configuer db2 express-C with ubuntu6.10 version
desktop. In fact, i had installed db2 9.1Express-C and i can't start
the control center and everytime it shows: ./db2cc 27 : db2javit not
found. but i had checked that there is the file db2javit,  so i can't

Anyone knows what do these mean?
 Primary log position(file, page, LSN) = S0000009.LOG, 0,
00000000036B0000
 Standby log position(file, page, LSN) = S0000008.LOG, 357,

The query:
   DELETE FROM CONNECTION_USERS
   WHERE CONNECTION_USERS.APPLICATION_ID = APPLICATION_ID()
causes a table scan to always happen in the unique indexed primary keyed

I use db2 8.1 fixpack 3 on AIX.
I recieved the following message in the diaglog
======================================================
ADM7513W  Database manager has started.

I use db2 8.1 fixpack 3 on AIX platform.
I am recieving the following messages every time I restart the instance
for a full offline backup.
=======================================================================

Hi, Friends,
I have oneconcern on my stragety on db2 backup.
My db2 databse backup imdage with size 100G.
On the server, it has two directories which I can use to backup:

We currently have an 8-way Itanium system running Red Hat Linux as our
primary production database server.  The server is about 3 years old
and we're looking at a replacement.  Due to the lack of user base,
we've decided to move away from Itanium.

Hi, we are using db2 V8.2 on windows, i try to deleted the data from
the table but i change my mind and stop the process, then if i do
db2stop, seems it is doing a rollback and take the same amount of time
as delete rows to try to stop the server, is there any better way to do