Hi all. I am debugging a JDBC application. I find that a certain
query that has an order-by clause fails with a
SQL1585N  A system temporary table space with sufficient page size does not exist.
I can understand if there is not enough room for the temp data for sorting,

My background is Sybase adn MS SQLServer, so I apologize in advance if
I use the wrong terminology (please correct that too!)
We have an initiative under way to "turn auditing on" for our DB2
servers.

how to know for a particular table if it is organized by index, and which
one ?
reorg table index ind1 -> the table is organised by ind1
i wan't to know that for all table

Did you know what is the maximum character length for a name of a database or
schema ?
Thanks

I am trying to set up scheduled export in DB2.  DB2 seems to be
missing the ability to export column names for CSV.  Apparently
'method N' is only for ixf and wsf files.  I have a C#  and/or Python
app I can modify but this seems like overkill for such a simple thing.

How can I connect to the server using this username and password
db2 connect to sample user db2sample using !xnntsample
Do i have to escape the "!" character, if I would how?
Regards,

I am trying to build a simple SQL stored procedure in DB2 Stored
Procedure Builder V7.
It gives me the following message. Can someone help me to identify the
problem.

I have a table that currently contains 718000 rows. I wish to add a
column to the table. Adding this column anywhere other than the end of
the table requires exporting data, a drop and recreate, then a
re-import of data. Is there any disadvantage to adding this column to

I have an AIX Box that has DB2 7.2 (Fix Pack 6) . Can I install DB2
8.1 client as anadditional instance>
Can I have 2 instances of DB2 one with 7.2 and the other with 8.1
Thanks in advance

Does anyone have any recommendations for setting kernel.shmmax and/or
some of the other kernel parms that affect DB2, on a system that has
24-32GB of RAM available?
I am also looking for a good resouce that describes what these parms

I have created an MDC table using UDB ESE v8.1 fixpack 6 on AIX 5.1.
The table is organized by 3 columns with a product of 100 * 3 * 5
values -- only 1500 values. When I try to use the load utility to
insert only 5000 rows of data, the load fails in the build phase with

We have two machines we wish to use DPF.  They are both RH ES 2.1, with
DB2  8.2.
I read the documentation CAREFULLY, and added the following line to my
db2nodes.cfg file :

All,
We are going to be moving from Solaris to AIX and we were informed today
that with Veritas Volume Manager and Filesystem 4.0 we can import a Solaris
filesystem into AIX.

Is there a way to find Weekend date for a given date using a DB2
query? I see that there are scalar functions such as DAY, DAYOFMONTH,
DAYOFWEEK,etc are available...but couldn't find one to get a weekend
date for any given date. Any information is appreciated.

Hello freaks,
we have many problems with our online reorg and no idea how to resolve
it.
We had to do an online reorg beacause of 24 h online business.