Is there any issue re-setting system time while DB2 database is online
and the system clock is ahead. The database is actually a 24x7
operational and a unscheduled shutdown would be a problem.
Thanks,

1. client linux on ESE and accesing  ZOS SERVER,
where is the authentication done
DRDA
HOST

Does anyone have a  DB2 Connect Version 7.2 in stock, or is the latest
Connect version 8.2 compatible with the UDB Workgroup 7.2
Many thanks and Merry Christmas
Phil

Can some one help me find out the differences between  DB2 for LUW and
DB2 for z/Series .
Also, can someone tel me what considerations do I need to make if I
wish to write some SQL UDFs which will be used on all of these

Hi there..
we had a disaster on our Raid configuration running our DB2 (UDB
7.2.5).
We used Tivoli to get our data backup and we had restore succesfully 17

Running UDB 8.2.0 on Suse linux 8.1, as database administrator I do:
declare global temporary table session.animal_noises
(animal varchar(10), noises varchar(10));
insert into session.animal_noises

We are running av db2 system on Windows 4.0 and DB2 v 7.2, fixpack 9. I get
the following message in the db2diag.log file:
2004-10-06-11.58.52.578000   Instance:DB2   Node:000
PID:266(db2syscs.exe)   TID:796   Appid:none

I've some problem to import data to DB2 using the db2move and db2look
tools.
Follow the problem :
I have exported data from db2 v. 7 database on windows server, using

We have several inter-related SQL Table Functions, which all optimise
fine on their own and most of the time together. However, increasingly
as we are adding logic and making their logic more complex, the
optimiser seems to becoming more and more fragile on its ability to

   I've defined a few functions to DB2.
   I can see the entries in SYSIBM.SYSROUTINES - but where is the source
text stored.
   I want to reverse engineer the definitions.

Happy Christmas to all (who celebrate)!
It's still not clear to me... when in a java stored procedure it says:
conn = DriverManager.getConnection("jdbc:default:connection");
what driver DB2 database manager loads? Is it configurable on the

Here is what I have:
Table1 with two key fields: PartNum and WH# (warehouse number)
Table2 with only one key field: PartNum
Both tables contain a field called Price.

I want to search clob data in SQL where clause so i need some
function.Can some pls tell me whether DB2 has some function which reads
clob column and return string like oracle has something dbms_lob.substr
??

I am an application developer with some experience in mainframe based
DB2 and would like to attempt certification exam.
The "beginner exam" 700 is for DB2 UDB and I could not find any
specific exams for mainframe DB2. Does attempting 700 work for me..?

We do not have a DBA available, and this is a development environment,
hence I was asked to do the work. I am not a DBA. I need some help to
clarify my understanding of DB2 recovery and I am reading the following
as well.