Hey guys,
I was looking through the topic archives for some sources of practice
exams for DB2 certs and found this:
http://www-306.ibm.com/software/data/education/cert/assessment.html

since we upgraded to db2 v9 and java 1.5 we get an illegal access error
if we call a method of another stored procedure class, located in
another .jar file, from one stored procedure (by call I mean calling
the java-method directly from java). With db2 v8.2 and java 1.4 this

I am building an effective dated file that shows results to date.
In part 1 of the select I
I process a larges set of input and genrate records for each date in the
processing period for which there has been activity

Hi All..
I have just build up the new db2 server and  after building up i come
to knew that i have to configure the  db2 to authenticate over the PAM.
I am not able to connect remotely to the db2 server because of the

On a multi-partition instance, can you create a database on a single
parition? How???
The db architects want to use one instance for four databases where
only one is big enough for a multi-partition. The other three are

I have a table with a number of fields, one being a date.
What I'm looking to do is take a date variable, and then select only
one row - that being the one that contains the next date value in
chronological order. So, as an example, if the table contains

I am currently in the process of gathering info/experiences for an
incoming Linux DB2 clustering phase we actually know nothing about
(since we are doing it for the first time ever), so I would really
appreciate if you could share some of your experience here or recommend

I have installed DB2 9 Enterprise Edition on my laptop (Windows xp prof.
ed.). But when I try to connect to any of my local databases I get this
error:
SQL30082N  Security processing failed with reason "19" ("USERID DISABLED or

If I have a license for DB2 V9 ESE for the appropriate number of CPU's
on my server, do I need a separate additional license for Range

I really like the construction:
select * from new table (update ....) X
but I noticed that it cant be used as:
insert into T select * from new table (update ....) X

I need to increase the length of CD column from char(5) to char(7) in
DB2 V8.2. I am doing it this way:
1. create new_table with CD char(7)
2. do 'insert into new_table select * from Original_table'

   I've installed DB2 V8.1 (base) on AIX 5.3 (TL5) and it all works.
   When I update it to FP13 (having done nothing else to the system at
all), it dies. Here is the db2diag.log file.
   Is anyone else having any difficulties with FP13?

Does this mean that only one of the two offending SQL statements
finished?  The other did not?
2006-10-04-22.16.02.828568   Instance:xrprod   Node:000
PID:11482(db2agent (CLINK_P))   Appid:C0A80AD6.AE97.061005051554

If I have a license for DB2 V9 ESE for the appropriate number of CPU's
on my server, do I need a separate additional license for Range
Partitioning (like I need for DPF).

 This is a very general problem which iam sure application programmers
all over have faced.
How does one handle the warnings that DB2 issues ? Should they be
ignored or treated the same as errors (i.e. as failures).