I'm trying to use the client reroute feature of the DB2 Universal JDBC
driver. I found documentation on this in the "Application Development
Guide: Programming Client Applications" in the section "DB2 Universal
JDBC client reroute support".

  Folks,
  I've got a java UDF that uses a scratchpad (based on Knut's dW article on user-defined aggregate functions).  The problem is that when it tries to read from the scratchpad on the first invocation of the UDF, it fails:
 select myUdf(myColumn) from myTable
 1

Posting this question on my friend's behalf
________________________________________________________________________
Question:
Let us say I have a SQLJ Java application and there is  unit of work

DB2 UDB V8.1.5 on windows 2003 Enterprise.
All DB2 admin function hang
like gb2 get snapshot, list application.
The error message comes into DB2DIAG.log every 5 minutes

  Folks,
  I know that DB2 does not (yet?) support this, but I wonder if anyone can suggest a work-around.
  I've seen article http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504greenstein/, which was very helpful for developing the scalar functions I needed, ...

  Folks, I've written the world's simplest java UDF, and it is complaining that it can't load the method.  The class seems OK, it's complaining about the method.
  The JDBC Sample UDFs (e.g., scUDFReturningErr) seem to work fine, so I made sure that I'm doing everything the same ...

import java.sql.*;
public class TESTA{
TESTA(){}
public static int product() {

I have a system that has been working fine for months, until this week.
This is the error message that I am now getting :
A DB2 problem occurred.
Sqlcode: -712 Sqlstate: 57011 , Sqlerrd.1: -140

when we run a stored proc and it results into an unhandled error, the
error message returned by db2 udb does not contain a line number that
caused an error. This makes it pretty difficult to debug those procs.
Line number have always been there in Oracle messages. When I Googled

Our DB2 8.2 FixPak9 database running on Win2K crashed with after
reporting this message
SQL0902C A system error (reason code = 9")  ocurred
I have searched the DB2 documentation as well as the Web and can't find

The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.

I want to insert in federated db TABLE1, when records get inserted into
DSY.TABLEA table.
CREATE TRIGGER DSY.TRIGA AFTER INSERT ON DSY.TABLEA
REFERENCING NEW AS TriggeredRow

I tried to issue the command: db2admin start on my db2 UDB 8.2 with AIX 5.2
server. It gives me the error:
SQL4401C  The DB2 Administration Server encountered an error during startup.
Does anyone can tell me how to fix it?

I can see no function which tests its argument to be all digits and I
see no easy way to compose such a function from translate, replace, etc.
I must be missing something simple, right?

Server = DB2 ESE 8.2 on Linux, Client = DB2 Admin Client 8.2 on Windows
Question = Can I execute "db2advis" from this Windows Client?
Kindly see the error I receive and the setup below.
Setup = As below: