In DB2/400, if I run this statement:  delete from ordvcrec a where not
exists(select * from i$paint b where a.part#=b.i$part)
Where ORDVCREC is a join logical of physical files ORDVALID and
ORDMASCREC, will the rows being deleted be the "logical" rows from

is it not possible to load data with admin_cmd into a table?
This SP ended with SQL3304N The table does not exist.:
CREATE PROCEDURE ADM_LOAD ( )
DYNAMIC RESULT SETS 1

I am trying to load comma delimited text files (data originates from
an MS Access database) to a DB2 database.
I have come to the conclusion, based on errors such as:
SQL0530N The insert or update value of the FOREIGN KEY constraint-name

create table test (a integer not null generated always as identity
(start with 1 increment by 1))
I cannot insert data since a is defined with "generated always", and
there aint no other columns. This is a hole, just found this when I

I was using DB2 9.1 on Linux which came with db2cc
The same level of DB2 on AIX 5.3 with the same install options and there
is no db2cc in the sqllib.
I know that db2cc is a script so trying to run the command on the AIX

Within DB2 v8.1 is it possible to force all database sessions for a
certain user to use a specific isolation level? Basically, I have a
readonly user that I want to force to use an isolation level of
Uncommitted Read for every database session.

What's the difference between DB2V8 32-bits and 64-bits instance on
AIX? and I am confused  the relationship between DB2 32/64-bits
instance and 32/64-bits AIX?
Maybe it is a simple question. Please advise. Thanks so much.

I was wandering if someone has seen a bad side of using one of these
parameters ?
Amy performance problem ?
Since with db2_evaluncommitted, db2 evaluates the where clause before

       I have heard that stored procedure on Z/OS can be written on
assembler language only. Can any body could help me out on DB2 stored
procedure on Z/OS. If you recommend me any materials, that would be
great helpful for me.

Hi. I was wondering if anyone out here knows if there is a limit to
the size of an external stored procedure? I am currently using VB
programs in Windows to call small COBOL stored procs residing in AIX
without any problems. This time, however, I am planning to have

I was curious if i could find what process id of the host system(AIX)
was associated with a particular agent id provided by the database.
Can anybody tell if such a pid can be found out.
Thanks a lot.

When i run the query,
" select distinct lock_object_type from sysibmadm.snaplock"
I gives lock object types as  "ROW LOCK", "TABLE LOCK",
"INTERNALP_LOCK", "INTERNALC_LOCK", "INTERNALV_LOCK".

is there any query to manually monitor our DB's performance and status
and to take the output to a file.
how to make it possible.. can any one give me a solution with the code?

I tried to generate the query plan for a query using a tool called
Aqua Data Studio.
It showed the explain plan and showed that a particular scan on a
particular table was taking a long time.

I'm about to experiment a bit with range partitioning in V9.5, but
discovered that on the target machine there is a:
[db2inst1@arwen ~/lelle/range_partitioning]$ db2licm -l
Product name:                     "DB2 Workgroup Server Edition"