I just stumbled upon this olap function and wondered why the "NULLS
FIRST/LAST" clause is not possible in normal order by but only using
row_number() over(). Sure, I can do a
SELECT *, row_number() over(ORDER BY col1 ASC NULLS FIRST) AS rn FROM

I am getting following message when i try to restart my database. I am
using DB2 V 8.1 on windows. I am getting this error since my System as
hard booted. I have searched for solution on IBM site, the questions
posted on this group. The only solution seems to me is to restore the

I am pretty new to DB2. I am trying to use MKT tool to copy one
oracle  [ schema + data  ]  to a target DB2 database. I import the
oracle DDL sql scripts and everything goes fine till the final tab
(deploy).

Hello, I am relatively new to DB2 and i would appreciate if anybody
can give me advice on UDF table.
My question is :
1) Is performance an issue when using UDF table?

I am trying to use the XMLUPDATE stored procedure. Installed fine, and
seems to work great if I execute the statement from a sql query using
the controll center.. Doesn't work from java however. I get a 07004
error that says I must in clude a USING or INTO clause in my dynamic

Folks,
I just upgraded to ESE UDBv91 (from v82) and found that there's no
COM.ibm.db2.jdbc.net.DB2Driver in db2java.zip anymore. the only one that's
there is the COM.ibm.db2.jdbc.app.DB2Driver

I've used DB2 LUW V7 a long time ago. Now i'm back and installed DB2
V8.2.2 PE and CONNPE. The DB2 stuff like CC works fine. I can access
the sample db and also select records. Than i've defined the SAMPLE DB
as an ODBC datasource. But i'f i start my ODBC application, which

I have a UNIX .sh script that invokes a DB2 SQL .sql script that
contains the following:
db2 -t -f parmtest.sql -z parm_output.log
My question is how can I pass a parameter to the parmtest.sql script

Whilst in CubeLand, I was informed that our 1970's era COBOL codebase
would not be modernized (?) to utilize Stored Procedures (bound COBOL
code in our case; they've not figured out SQL SP yet) because CICS is
more secure than DB2.  I found this a fantastical statement.  A review

I have a two tables with same structure in DB2 Ver 6 on OS/390
1- CurrPay(CustomerId, BnkId, BranchCode, PayDate, Amount)
    for Current Period Customers Payments
2- PayHist(CustomerId, BnkId, BranchCode, PayDate, Amount)

We have z/OS and DB2 v7. I have various fields on tables that I need
to perform searching through using the LIKE operator and wildcards
such as %.  Currently on our million row plus tables the performance
we are getting is like 25 seconds for this query to execute solely

I have a database I have inherited (new job).  I am trying to baseline
the code and have done a DB2Look to get the code out of an existing
db.  The DB2Look produced a SP with the following form:
Create SP1

I use db2 v8.1 on aix 5.2
I cannot connect to the database through clp or control center.
all the background processes are running when checked using ps -eaf
command.

DB2 LUW 8.2 FP14 Red Hat AS 2.1
I am using a response file w/ db2setup to install DB2.
I then want to install the latest fixpak in the same
automated way.

Until this date, I believed that DB2 has no TRUNCATE TABLE command. But
then I came across
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.d
oc/doc/c0023297.htm
where it says: