Dear Friends
Is there any systables in DB2 Database for the following :
How to display instance name and instance status
How to display database name and database status

I have as sql query that is very long, and has a small bug. Occasionally
I get what appears to be duplicate rows in the output (unfortunately a
php drawn pdf). I have stared at the SELECT statement and what I think
are the relevant portions of the database to no avail. Each of ...

Can you not use the 'FOR READ ONLY' option with the cursor declare
unless you put the SELECT statement in the declare?
re:
EXEC SQL

I am thinking about backup strategy. I have couple of questions for my
db2 community brothers.
1. Can i use full online or offline database backup as base for
incremental backup for tablespace?  For example, if i take backup of

I installed DB2 RUNTIME CLIENT on my machine.i cataloged the
databases.when i tried to connect to DB2 SERVER(work group server
edition DB2 8.1.7.445 and FixPak 7) i am getting the following error
SQL30082N  Attempt to establish connection failed with security reason

What do you people do (if anything) to help with
automated access-plan checking of static-SQL
on DB2 LUW v8.2.2 ?
Sometimes after we rebind, DB2 will choose a

Does anyone know of any problems on setting the following db2
environment variables?
DB2_EVALUNCOMMITTED=ON
DB2_SKIPINSERTED=ON

Dear Friends
I am working as oracle and ms sql dba from last 4 years. My company
recently migrated to DB2 databases.
So i am very much new to db2 database

when I try a left outer join on one table everything works fine:
select * from (tourist.users u left outer join
tourist.user_extended_info ue on (u.id = ue.id))
But now I need to do another left outer join with a third table, but

I have a stored procedure that wraps a moderately complex query over 5,
6 related tables. The performance of the procedure is unacceptably slow
as it takes on average 5-10 min to complete.
To diagnose the problem, I copied the query in db2 command editor, and

I am hoping someone can help me. I have used MySQL (sorry) in the past
and I am struggling with the syntax to do an update on some records in
a DB2 database. I am simply trying to get a list of records that
contains spaces in some_field, then strip all of the spaces. Any help

Hello,I am a fresh man to study the DB2.An error occured when I try t
Run a Java class.
Details of the Error:
Code

I'm looking for a DB2 version 8 DBA for a permanent position
in Houston.  Are there any good user groups available where
I might be able to make some contacts?  If you have any
information on this topic, please contact me via email.

I have to delete older policies and its related records in other
tables.
The deletion from the parent table will trigger the deletion of
relevant records from about 30 something tables that are defined with

I'm trying to create a cursor and complete some processing against DB2.
I'm using DB2 V8.2 on AIX.  I don't wont to create a stored procedure,
I just want to use a regular query editor such as command editor or
DBArtisan.