How can I find out how much space has been used in the log file
and how much of it is free or yet to be used ?
Thanks,
Hype

I get the following output from a very simple page which tries to
connect to a db2 database hosted on my linux system, which is also
hosting my apache/php system. I have tried several permutations of the
connect string:

I cannot get Korean data to show up in Command Center or Crystal
Reports.  I wrote a small JDBC program and that is working fine.
Here are the details.
DB2 Server : AIX DB2 8.1.3 64 bit  

I've looked on google for this but can't find an explanation.
Hopefully someone here can help.
We use DB2 Connect to link a PC application written in VB6 to OS/390
DB2 (V7) tables.

this question is about DB2 UDB V8 and its inplace reorganisation.
It seems that in small tables, an inplace reorg doesn´t start. Is
there a limit in size of a table when a reorg starts? How can I be
sure that a reorg has successfully finished?

I have a sample proc which returns cursor based on the IN param
passed, the query returns the records.Here is the sample proc..
create procedure sample_proc(IN deptNo varchar(10),IN deptNm
varchar(10))

We are going to have 2 windows 2003 server working as a cluster.
Each physical server has 2 intel cpu.
How can we let DB2 make full use of the environment?
I could not find any redbook about this.

We're encountering an issue with working with CLOB's. We're doing a
basic insert into a table that has a CLOB column. Sometimes the CLOB
is fairly tame in size (10k-15k), and once in a while they're fairly
large (30k-60k).

Has anyone come across this before and fixed it?
My system (a small development system with DB2 8.1 Enterprise on
RedHat 8.1 Linux) has been working fine for ages.
Suddenly I now get the following error after running code that has

How can I set the QUERYOPT value for only a few stored procedures?  I have a
large .sql file that is loaded using db2 -td@ -vf file.sql... however I want
to be able to set the QUERYOPT setting to different valus for different
stored procs in that file.. is this possible?

I was hoping to save some time and check if anyone would share their
script to automate online backups using DB2 v8 on Windows and backing
up to TSM.  The part I am specially looking for is the automatic LOG
cleaning.

I am attempting to write my first SQL procedure (modeled on one in
Celko's _SQL for Smarties_) and I'm getting the following message:
DB21034E  The command was processed as an SQL statement because it was
not a

Hi forum,
can anyone tell me wether it is possible to adjust the journaling via
JDBC? I have created a database (library) via CREATE SCHEMA which creates
a journal and journal receiver automatically, what is very nice (thank you

I have DB2 v8.1 for Linux for a class environment; each user has
his/her own database as dbadm and they are suppose to study queries
from another database.
They have the right permissions to this database so they can do the

(Using UDB 7.2 FP11). Given this output from LIST BACKUP HISTORY FOR
MYDB: (It's an online backup image)