I am trying to understand the logging and archiving features of DB2
V8.2 And I have a couple of questions:
1. When I issue update db cfg using newlogpath /path, the logpath in
db cfg is /path/NODE0000 and the db2 logs go there. But when I use

Hello, I know this is a question very simple but I can't remember how
see if a table has indexes.
Can you help me?
Thank you

DB2Connect Informational tokens are "DB2 v8.1.0.96", "s050811",
"U803921", FixPak "10".
I am getting txxxxxx.0000 files approximately every 14 minutes that
look like:

What is the best way to migrate entire database from one operating
system of Unix (ie:Solaris 7) to another Unix opearting system (ie:AIX
5.2)?
Thanks in advance.

I came across a weird situation today. We have a simple sql statement
with some java code thrown around it which executes in about 1-2
seconds. However when put in input parameter markers in the same sql
stmt, do a preparestatement and then bind the appropriate parameters

publib.boulder.ibm.com has been rather unstable lately, so I figured I
should install a local copy of the documentation web pages.
I grabbed the Windows-version of the offline version of "DB2 9
Documentation" from

Does anyone know if there will be a fixpack 15, or what the last V8
fixpack will likley be?

I use db2 v8.1 fixpack 3 on AIX 5.1.
I used to get a memory heap error few months ago.
I sorted it out by setting the NUM_POOLAGENTS and MAXAGENTS equal.
Also there was an issue with the event monitor reaching max space

We are currently using Userexit to archive DB2 logs. I updated the db
cfg as follows:
db2 update db cfg for capfpk02 using LOGARCHMETH1 DISK:/cfpkloc4/
archivedlogfiles/capfpk02

I in the process of converting a set of Java stored procedures to SQL/PL
and I am using the Developers Workbench (DWB).  All of my DB2
installations are V9 FP1.  I recently applied the DWB update and now I
am having problems getting the SP to run or debug within the workbench.

I need to cleanse some data. Some of the data consists of CHARs of the
form '2006-12-24' which are to be converted to DATE values.
Some of the values are known to be invalid (such as '0000-00-00' or
'2006-02-45'), and those values need to be converted to NULLs.

I am using the ibm_db2 PECL drive in PHP for connecting to or DB2
database.  I created a persistent connection and things seemed to work
fine at first.  However, after a few tests / connections, I started to
get this error when running through my queries: [IBM][CLI Driver]

We have recently moved a ClearQuest database to db2 V8 on linux. We
take a full compressed backup on sundays (~400Mb) and compressed
incremental/incremental delta other weekdays. What puzzles me is that
despite low activity in the database, the delta backups are the same

We've got a DB2 installed on AIX server;
now I can't find many records related to a specif table, so my opinion
is that these records have been CANCELLED in a way I don't Know maybe
with some delete instructions..

I just installed the runtime client on my windows machine. when i go
inside the SQLLIB\bin folder i can see db2.exe. is it possible to use
this db2 bundled with runtime client for command line processing?
Because all the documents tell you to get an administration/