is there any way besides a trigger to create a unique number for a column in
a "insert into... select from" statement?
Thx, sr
--

There is a syscat.TABLESPACES view that contains data about the available
tablespaces of a database instance. What I would like to have a look at is,
the container paths where the tablespaces are stored. Is there a view that I
can use to get at the path data?

According to the IBM website : http://www-
106.ibm.com/developerworks/linux/library/l-ss3-db2/
If you are using Red Hat 9, with its new thread library, Native POSIX
Thread Library (NPTL), then the Java installation code used by DB2 will

   Is is possible to limit the UDB DB2 to use only 1 cpu on the 2 cpu server.
   Can you please provide me the steps or link where I could get the info.
Thanks
vijai

when i create a join view like this
create view JV104FZ.APJTINM1 (APAM32, APNO20, APQY05, PONO01, PONO05,
PONO19, POCD01, POCD13, systimestamp, loginname, id ) as select
JV104FZ.APPTINM.APAM32, JV104FZ.APPTINM.APNO20,

Is there anyway i can run the Online Spufi panel in batch. I don't
want to use the DSNTEP2 program, b'cause it has a limit of 133 Record
length. And apart from these i don't have access to other DB2
utilities to access DB2.

Is DB2 v8.1 the only version available for download from IBM?  I have
looked at IBM sites but could not find where I could download DB2 7.1.
Is it being desupported?
Thanks in advance for any pointers.

A very simple piece of SQLJ:
    try
     {
    #sql [sqlj4context] sqlj4_iterator = {SELECT PHONENO FROM

is there another way to export data to a csv-file (comma-separated format)?
We tried the EXPORT-command and got the following error
"
     SQL1325N The remote database environment does not support the command

Can anyone tell me how to find out what causes this error -- the
message is not very revealing!
I'm using DB2 8.1 fixpak 5 on Windows XP, using the Sun JDK 1.4.2.
Thanks,

After installing DB2 8.1 and then migrating the instance and the databases
to 8.1, is there anything that needs to be done to remove DB2 7.2 code or
keep 7.2 from starting up? Will there be any ambiguity when issuing DB2
commands as to which version of a DB2 command should be ...

The following merge statement is taking forever (as in it may still be
running when you read this; it hasn't finished after 2 hours as I write)
to run. While I am totally unschooled in reading EXPLAIN output, one RE
CPU COST entry from EXPLAIN_OPERATOR stood out in that it was ...

I have question about differences in fenced sql procedures and fenced
stored procedures. Do fenced sql procedures take up an extra memory
segment when executed? Reason I ask is we have several fenced sql
procedures that have been excuting o.k. We implemented a fenced stored

This is a very simple DB2 SQLJ stored procedure. The problem is that it
seems to run fine but returns NOTHING. I mean..as if nothing has
happened..not resultset is returned. I am passing value 'D11' to :workdept
and I have checked in the table that 6 rows should have returned. Any

When I create a package (by db2sqljcustomize command), the new package
does not immediately appear in SYSIBM.SYSPLAN for that database. It
appears after some time.
Does anyone know when SYSIBM.SYSPLAN gets refreshed so that the new