Please bear with me if this is not a very intelligent question!!
I have few SAR files that stores some StoredProcedures. I am supposed
to use the "PUT ROUTINE" command to execute them in my DB2 UDB 8
Database.

I have this query:
SELECT AGG_NAME, MAX(AGG_RELNUM) RELNUM, MAX(AGG_RELSPEC) RELSPEC, MAX(ED)
EDIZ
FROM

Howdy,
is there a way to speed-up or tune the database creation?
On my laptop (DB2-UDB PE) it takes 2 minutes to create a virgin database.
This virgin, btw. is 30MBytes heavy.

Can anybody help me with a copy of DB2 6.1 SDK for Windows? I know its
ancient but any help is appreciated.
Regards,
Raf

I have created a (German) database with "Using Codeset ISO8859-1
territory DE". Now when I'm importing from an ixf file, I get sometimes
SQL3050W  Conversions on the data will be made between the IXF file code
page "923" and the application code page "819".

I am unable to do anything with a specific DB2 instance. However, my
other DB2 instances/databases on the same server are functioning well.
Please see the below commands and their outputs:
$ db2 list applications

What's the difference between "Run-Time Client" which I received with
DB2 Developer's edition (used in Workgroup Server Edition for Windows)
and "Redistributible DB2 Run-Time Client Lite" available on IBM's web
site?

Hi gurus,
I have a problem to convert MS SQL Server application to DB2.
I have a view which combines 7 tables ( table sizes 60millions rows, 3 mill,
1 mill, other small ones)

I had a database on windows2000, it was a trial version. The license
got expired, so I took a full database backup. I reinstalled DB2 on my
machine. Now I am trying to restore the database from my backup file. I
am getting the error:

I get the following message:
SQL0973N  Der verfügbare Bereich im Zwischenspeicher "QUERY_HEAP"
reicht für die Ausführung der Anweisung nicht aus
when I send a select-statement to the database. The table has three

We are looking for a command/SQL statement that cancels all table/row
locks in DB2.
The reason for this is:
1) computer A was a sole client of DB2, and crashed

I was wondering if the CREATE DATABASE command uses scripts to create the
catalog so that I can customize my database creation on DB2?
Thanks
Chris

I had just recently installed a new database with partitions.
I realized that all of my previous Java UDFs failed to
install on the new database.
Basically, I got SQL0270N with Reason code 59.

I'm running DB2 UDB v 7.2 FP 9.
I'm connected to my database (testdb) successfully as user db2admin.
then i tried to run the following command:
get db cfg for testdb

1. I did a reorgchk, and found that F2 on table and F4 on index
indicates a reorg is necessary.
2. Did a reorg.
3. Again I do a reorgchk, the report is the same as in Step 1