I have taken a backup of a production database and copied it to a test
server.  I'm attempting to use the Control Center to create the
database from the backup.  However, when I get to the screen to select
the backup to restore from, there are no backup files visible through

Hi;
I am transferring data from MySql to db2 using my own java/jdbc program.
Working out ok, except for the fact that our apps use mixed-case names for
tables and columns. Although my CREATE TABLE commands issued via jdbc uses

From a table like the one below, is there an easy (ha ha) way to get a
set level of pedigree (3 or 5 generations, say?). I have seen solutions
on this group for all the ancestors, but, unless I misunderstood, no
solution for a fixed number of generations. There is always the 2^n ...

How can i insert random data into a db2 table for a graphic data type
column
Thanks,
Ganapath

I'm doing my very first steps with DB2 programming, so please forgive
me my stupid question.
I try a very simple first db-access using embedded sql with plain
C-code (MS-VC++ on windows). I did a simple

is it possible to get following things in jdbc?
db2 LIST DATABASE DIRECTORY
db2 LIST NODE DIRECTORY
thanx

This is probably something simple but I've been trying for a while now
and can't seem to get it.
I'm loading a table from an IXF file with the following command
'load from D:/db_scripts/load_test/nlm.ixf of ixf modified by

Hello people,
I would like your assistance here.
I have a DB2 V8 database on Windows 2003.
I would like to migrate this database on AIX 5.3 (keep the same

Hello all...
   well am pretty new to this DB2....i recently installed it on my
system...i was trying to create a new database but it doesnt allow me
to...it gives a error saying i need to give "start database manager"

I have DB2 UDB 8.1 Enterprise Server Installed on Linux machine.
I am connecting to that from Windows2000 Machine by using Windows
client for DB2 UDB.
Now I want to install DB2 Application  Development Client on my client

We are adding a new DB2 server to our domain.  DB2 is version
8.1.7.445, and it is installed on a Windows 2003 server.  The server is
a domain controller and the domain uses Active Directory.  It was made
a domain controller because it could not see the domain ID's or domain

How can I convert the following T-SQL construct to SQL-PL?
if @ParameterType not in ('p1', 'p2', 'p3', 'p4', 'p4', 'p5')
begin
   print 'good parameter'

Hi I have a function as below...
function PerformQuery3
{
$VAR1 = 'export to $1 of ixf messages $2.out "select * from $3"'

Env : DB2 UDB 8.2, AIX 5.3, Ascential Datastage (DS)
DS jobs are used to process the backend DB2 database. Sometimes DS job
fails with the message
APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver]

I have one table that tells me what data should be deleted. A procedure goes
over this table and deletes the data. After deleting a row an after delete
trigger is fired and inserts a row in another table, so we know what got
deleted. The problem is that sometimes these trigger ...