We have DB2 version 7 fixpak 14 on AIX 5.1. We have nicknames to
another RDBMS tables. These nicknames have views and specification only
indexes.
I would like to know how we can extract the definition of these

Can someone tell me whether Wombats live only in Australia,
or also on other continents?
Apart from zoos, of course.
We all know that Wombats are to be found in Zoos.

I am trying to remove files from stored procedure using Linux OS
commands
I know smoe udf needs to be developed either in c or java, but nowhere
code is available

Hello, How can I identity the list of columns (with the table in which
it is located)  present in a database which has
[1] A blank or NULL value for ALL rows  ( if the column is CHAR)
[2] A zero (0) for ALL the rows (if it is a numeric column)

For the past some days i could see the below error on my diag logs,
MESSAGE : Unable to create or attach to the segment used for fenced
routine
         communications. Decrease the amount of database shared memory

Could some one share with me some information on the Interrupt port
being used in DB2. Whats the significance of this port in both EE and
EEE environments.

We have DB2 7 fixpak 14 on AIX 5.1. There are federated links
(nicknames) established for tables in Informix database.
One of the table was modified in Informix. The table has now got 3 new
columns. These columns are not seen in DB2 nickname definition. When we

My SQL returns a NULL in a datefield if there is no date in that field.
If there is a NULL in this column, I want to replace it with spaces in
my SELECT statement when I am selecting these records.  Can any of you
experts out there help me with a sample SQL.

I have a data set which I need to analyze but I am having a problem
figuring out a structure for the database - or whether there are better
ways of attacking the problem.
The base data set is a large number of replies to a survey

hi ! , i am sorry to every one of you all ! i was very new to this
group i was not knowing that i should'nt use cap's .

We decided to root for a backup strategy using online incremental
backups which include the log files (avail since DB v8.2). Now I
wondered, if DB2 automtically deletes the archived logfiles after
executing of online backup using that option or if we still need to

I have a small C++ program which connects to different DB2 instances
including local DB2 ESE v9.1 on WinXP x64 (AMD64 version of DB2) and remote
z/OS DB2 v7 using the same "db2api.lib" from v9.2.
64-bit version of the program works perfectly (linked with 64-bit library

Is there a way to find the running SQL associated with a db2 connection?

We got error when try restore offline backup db from v7.2 to v9.1.
SQL2514N  The RESTORE was not successful.  The backup used to restore the
database contained a database with a release number that is not compatible
with the installed version of the database manager.

I was wandering if someone could explain to me (or point to some
manual) the process of mapping the addresses of host variables by DB2.
Especially I would like to know when DB2 decides to reinitialize the
addresses and even more when it decides not to do it.