Whenever I do an offline reorg I see that indexes for the table are
being rebuilt(on the db2diag.log). Does that mean I do not need to
reorg the indexes for these tables separately? This is the command I
use - reorg table <table name> allow no access

I was just messing around trying to learn things and attempted the
following:
select brch_nbr
    , sum(case when post_flag != 'P' then amount else 0 end) as sum_amount

I'm trying to call a stored procedure and it executes a external Java
class but I have this error:
SQL4304N  Java stored procedure or user-defined function "SENDMAIL",
specific name "SQL070306100655300" could not load Java class

I had to use new char array and delete it. The application Crashes
when i use delete keyword to deallocate char array. it throws an
unhandled exception. I am using sybase DB.

Could any one tell me if you have come across this error?
java.sql.SQLException: [informatica][DB2 JDBC Driver]Resource Limits
Reached( ALLOCATE MEMORY FOR NEW SQLSTT FAILED ). Diagnostic
Info: FUNCTION ID = 0049 , PROBE POINT = 0400 , TRACE POINT =

I would like to connect to a remote server, which I have already
catalogued, and get the os and db2level information.  I just realized
that even though I connect to the other server my '!hostname' and '!
db2level' commands are giving me the data for the server I am

I receives the following in the db2diag.log file many times / day :
2007-03-05-14.55.24.836553+060 E12415C457         LEVEL: Warning
PID     : 2785                 TID  : 1           PROC : db2agent
(dbname)

I have Db2 Dba position open in west virginia.
person should have green card.
please contact me if any one interested

Hey all,
I've worked with DB2 for a long time, but it looks like Windows and
user management is getting the better of me.
I'm trying to set up a DB2 9 Express-C system.  It's installed and

Whats the method to check whether a user has SECADM authority on DB2 9/
AIX. db2 get authorizations doesnt list anything related to SECADM.
Thanks,
Sam

One of the java developer is getting error
SQL10003C
There are not enough system resources to process the request. The
request cannot be processed.

My Visual Studio 2005 Query Window reports the following error when
this query runs. Any idea what might be causing it? Thanks for any
help. I have tried subsitituing for the parameter a fixed number and
same error. I also have established it does connect and close properly

Could someone pls help me understand what factors might effect the
clusterratio of an index.What action might increase this value in
syscat.indexes for a particular index.
Thanks a lot.

Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.
Thanks!

To use SQL replication between DB2 z/OS v7 and DB2 Unix V8.2 with
Replication Center or DJRA:
*  do I need Dpropr on Z/os running in V7 or V8 ?
* could I use Replication Center for subscribing on DB2 Unix V8 and DJRA on