Hello, all.
Let the tablespace SY810T4K is almost full:
  ---------------
  db2 => list tablespaces show detail

I am trying to debug a stored procedure by using the source code given
by Serge in one of the DW article about SQL procedure tracing
(http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0409rielau/)
I am unable to get rid of these errors while linking the sqlpltrc

I would like to use same  SQL statement  in my SQC program for several
tables
I tried something like that:
  - sql_sts="SELECT col1, col2 FROM ?"

        here is a message I have been recieving in my db2diag.log file
240 E457831A419        LEVEL: Warning (OS)
PID     : 369436               TID  : 5707        PROC : java
INSTANCE: db2inst1             NODE : 000

Our dba is out on vacation, we lost power, db2 came back up but it's
mounting to wrong point.  We do not know the name of the mount point it
should use nor do we know how to change it.
We will pay $$ for a quick phone support.

Did restore from an OFFLINE backup under V8.2 to new db in V9.
OS=Windows 2000 Server
Can not migrate.  Receive error:
SQL0270N  Function not supported (Reason code = "75").  SQLSTATE=42997

i have a UTF-8 Database. application loads japanese data in to it which
is in ascii format in to it.
when i saw the result through command center it appears as garbage
value.as though  db2  supports japanese charecter

Hai everyone...
                       Can anyone tell me how to analyze the output i
got frm db2trc....
Regards...

our db2advis is broken and i am trying to find other ways to get
recommended indexes
i tried using command "SET CURRENT EXPLAIN MODE RECOMMEND INDEXES" and
it populated ADVISE_INDEXES table. new indexes recommended by this

I have the following message in my db2diag.log file repeating every
minute.
Does anyone know what the error is ?
2006-07-10-10.27.08.921000-240 I95651H390         LEVEL: Error

 I am creating an unique index on surrogate key column. The surrogate
key is a generate number always increasing on my dimension table. The
only operation on the table is insert (no update and no delete).
 1- Can I specify pctfree=0 for the unique index on the surrogate key

I have a process that does inserts that runs 50% slower that Oracle and
Mssql.
Queries normally take 50% slower than normal.
DB2, Oracle, Mssql all are configured on same os, same disk array (raid

i all ready have one running instance, if i want to create  another new
instance which supports japanese language, how would i create it from
command line.
thanks and regards

I am new to shell scripting. I need to use the db2_all command in a
shell script can someone help.
I need to use the following command in the shell script:
db2_all <<-0< db2 conncet to sample; db2 export to ./exp/tabname.ixf

      This problem seems to be trivial but yeah its happening to me.
I am trying to drop a nickname
db2 "drop nickname <schemaname>.<tablename>"
after I execute the command, the cursor just hangs there. Nothing