While developing in DB2, I am trying to store information in session
variables for auditing purposes.  I am currently working in v8.2 for
UNIX but we will be going to v9.1 before we deploy to production (so
any answers for either are appreciated).

I try to run a SQL which inserts data into a table. i get this error.
SQL0659N  Maximum size of a table object has been exceeded
Can anyone suggest what i can do, I tried reorg, i did drop few
indexes, but of no use. Is there any other way i can get rid of this.

When using a CallableStatement with the IBM DB2 Universal JDBC Driver
the executeUpdate and getUpdateCount() methods on CallableStatement
always return -1. According to the JDBC specification it should return
the number of rows affected by the stored procedure and 0 if no rows

Would appreciate your help with this.
Is doing a db2 load from a v9 client to a v8 server supported?
Thanks a lot.
JJ

Running DB2 8.2.5 and version 9 with fixpack2 on AIX 5.3 supporting
both SAP netweaver and non-SAP applications.
In implementing auto-reorg and auto-runstats, what is the guidance
regarding doing a rebind of packages?

i'm really newbie in IBM DB2 but I have to know how is IBM DB2 Dialcet
called? In oracle we have PL/SQL, in SQL Server we have T-SQL. What
about DB2? Is it SQL PL, or DB2 SQL Dialect?
Thanks in advance for any reposne.

there are some files residing in the path /usr/opt/WBI Monitor/
EventQueueDBContainer like
rw-------   1 db2inst1 db2grp1       12288 Nov 26 09:18 SQL00003.INX
-rw-------   1 db2inst1 db2grp1        4096 Nov 26 09:18 SQL00003.DAT

Seeing the downloads for both these products on the same page, I
downloaded them both.
Cannot get Net Search Extender to recognize V9.5.  Cannot issue any
NSE commands.

Scenario:
1.System date is changed to year 2008, per say Nov 2008
2. An offline backup of DB2 is taken
3. System date is made current ( year 2007 )

Is there any way to find the SQL that is causing the Locks.
I am using SYSPROC.SNAPSHOT_LOCK to find out the locks on the table,
but i am unable to find out which SQL statement was responsible for
the lock.

Can anyone answer this question with certainty?
I'm playing with Discovery. I have a very simple network with two PCs
connected to a router via ethernet. The two PCs are running Windows XP (SP2)
and each have a copy of DB2 Personal Edition V8 on them.

I am trying to create a second instance on a Windows XP machine that has DB2
Personal Edition installed. It's not going awfully well so I thought I'd ask
some questions here.
My 'db2icrt db2test' command was successful.

Running DB2 8.2.5 and 9 with fix pack 2.
Is there any way to update a table space level health indicator
command line or do you have to use the Health Monitor.
I want to shut down the ts.ts_op_status health indicator.

I need to use commands mentioned in title
in my c# application,
I know about REXX and  SQLDB2 API, but I want create independent application
any suggestions?

My server has crushed, and all i could recover was database dirs/files.
Can i somehow recover the database from these?
It's like:
db2inst1/NODE0000/...