I am trying to convert an existing COBOL app from using exclusively
tradional I-O (READ verb) to using a mix of traditional and and SQL.
Please don't ask why, my question is conceptual.  After populating a
cursor from table A and displaying on the screen, a user makes a change

i have a jpg file on my pc which contains only 1 photo,
1. i would like to ftp the file to mainframe and then
2. insert that value into blob field of a db2 table
can anyone tell me how to do above mentioned steps

Is this possible to tune this query further :
Env : DB2 UDB 8.2 on AIX 5.3, Non partitioned tables
Query:
SELECT

Q 1.
How do I come to know what type of logging has been enabled for a
particular database (circular/archival,etc.) ?
Q 2.

we are using db2 v8.2 on windows. Have a error while run the
application,
DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
NULLID.SYSLH20A 0X5359534C564C3031

How can I determine the name of a database I'm connected to.
I tried the SNAP_GET_DB, SNAPSHOT_DATABASE, ... but all these return all
databases that are defined as "Indirect" or "Home" in LIST DATABASE
DIRECTORY command. This is not the desired behaviour.

Can anyone please help me and explain:
[24/03/06 11:22:28:212 EST] 3e70982f WSRdbDataSour I DSRA8203I:
Database product name : OS2
[24/03/06 11:22:28:332 EST] 3e70982f WSRdbDataSour I DSRA8204I:

i have some simple doubt in DB2
1. can we disable or enable an  INDEX.
2. can we  drop a column from a table .
3. can we change  the datatype  of a column  i.e say from varchar to

   I am trying to acquire a lock on a table A in exclusive mode, and this
statement gives an error indicating a deadlock or timeout
   has been detected. The lock timeout value is set to 0 which I understand
is to wait for however long it takes to acquire a lock.

I installed the DB2 UDB v 8.2 trial version  on Windows xp professional
environment.
In First Steps I tried to create the Sample Database but it gives me an
SQL

I have installed DB2 V7.2 twice now and I keep getting the error:
"[IBM][JDBC Driver] CLI0622E Error accessing JDBC administration
service extensions."
I see that this is a fairly common error but I have yet to find out how

One day our Windows 2000 Server OS crashed, so our NT admin has
re-installed the OS on C: drive. Fortunately we kept our database file
and installation in F: drive. When we re-installed DB2 on the same
location we are able to catalog and recover the database with old data

Anyone had luck having tablespaces on NFS with Netapp filers?
I keep getting
SQL0298N  Bad container path.  SQLSTATE=428B2
Even though its a valid path. Also tried creating symbolic links to

is there a view or a table that i can query the total size of my
database (including the containers belonging to DMS and SMS
tablespaces)
Thanks & Regards,

When I issue an db2 list applications on my DB2 UDB V8.2 database on
AIX 5.3 I get the following o/p
/home/card30/admin] > db2 list applications
Auth Id  Application    Appl.      Application Id                 DB